Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to maintain a running balance column in Excel and Google Sheets
Topic:Finance basicsExcel & Google Sheets
=B2+IF(A2="",0,C2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Date | Previous Balance | Transaction Amount | Running Balance |
| 2023-01-01 | 1000 | 200 | |
| 2023-01-02 | -50 | ||
| 2023-01-03 | 150 | ||
| 2023-01-04 | -100 |
=B2+IF(A2="",0,C2)→1200
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1In your spreadsheet, add headers such as 'Date', 'Previous Balance', and 'Transaction Amount'.
- 2Enter your transaction data under these headers.
- 3In the cell next to your first transaction amount, enter the formula `=B2+C2` assuming B2 is the previous balance and C2 is the first transaction amount.
- 4Drag the fill handle down to apply the formula to other cells in the column.
- 5Your running balance will now update automatically with each new transaction.
Tips
- Ensure your 'Previous Balance' column starts with an initial balance value.
- Check for any text or non-numeric values in your transaction amounts that might cause errors.
- Regularly back up your spreadsheet to prevent data loss.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What if I have multiple transactions on the same date?
You can sum the transactions for the same date before applying the running balance formula.
How do I handle negative transactions?
Negative transactions are automatically handled by the formula as they reduce the balance.
Can I use this method for a budget tracker?
Yes, this method is suitable for budget trackers where you need to monitor income and expenses over time.
More on Finance basics
See all →How-to
How to calculate compound interest
Calculate a compounded closing balance from principal, annual nominal rate, compounding frequency and years, then separate the interest earned.
How-toHow to calculate the effective annual interest rate
Convert a positive nominal annual rate and a whole-number compounding frequency into an effective annual rate with EFFECT.
How-toHow to calculate the break-even point in units
Divide fixed costs by unit contribution margin and round up to whole units, with an explicit message when the margin is nonpositive.
How-toHow to calculate tiered commission
Apply different commission rates by sales tier using IFS. Works in Excel 2019/365 and Google Sheets.
How-toHow to calculate net pay
Calculate take-home (net) pay by subtracting every deduction from gross salary, with worked examples for fixed amounts, percentage tax, and slab-based tax. Excel and Google Sheets.
How-toHow to calculate gross margin
Compute gross margin percentage as (price − cost) / price. Identical in Excel and Google Sheets.