How to Fix a Check Register That Does Not Calculate Balances in Spreadsheets
Question details
The user is trying to resolve an issue where their check register fails to automatically update the running balance when new debits or credits are entered.

- Product
- Spreadsheets
- Device & OS
- not provided
- Scenario
- Tracking daily financial transactions and managing accounts using a spreadsheet check register.
- Observed behavior
- The running balance column remains unchanged or displays errors instead of automatically subtracting debits and adding credits.
Before troubleshooting specific cells, ensure your spreadsheet's calculation mode is set to 'Automatic' rather than 'Manual' in the Formulas tab so that data updates in real-time.
Verify and Fix Running Balance Formulas
The most common reason for a check register failing to calculate is incorrect, overwritten, or missing formulas in the balance column.
A proper check register formula must take the previous row's balance, subtract the current row's debit, and add the current row's credit.
Click on the first cell in your running balance column that is failing to calculate.
Look at the formula bar at the top of the spreadsheet to ensure the mathematical logic is correct (e.g., =E2-C3+D3, where E2 is the previous balance, C3 is the debit, and D3 is the credit).
Once the formula is corrected, hover over the bottom-right corner of the cell until you see the fill handle (a plus sign), then click and drag it down the column to apply the correct formula to all subsequent rows.

Adjust Cell Formatting to Currency or Number
If cells are accidentally formatted as text, the spreadsheet cannot recognize the entries as values to be calculated.
Resolve Circular References and Blank Data
Errors in reference logic or blank data cells can disrupt the calculation chain for the entire sheet.
Create and Manage Check Registers Easily with WPS Spreadsheet
WPS Office provides built-in financial templates and robust formula tools to help you track expenses and manage check registers seamlessly without calculation errors.
- 1. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' from the main dashboard.
- 2. Access Templates: Navigate to the Template library and search for 'Check Register' or 'Expense Tracker'.
- 3. Select and Use: Choose a pre-formatted template. The balance calculation formulas are already set up and locked, so you only need to enter your daily debits and credits.

Frequently Asked Questions
Why did my check register suddenly stop updating balances?
This usually happens if your spreadsheet's calculation settings were accidentally changed to 'Manual', or if a formula in the running balance column was overwritten by a statically typed number.
How do I locate a circular reference error in my check register?
Go to the 'Formulas' tab on the top ribbon, click on 'Error Checking', and hover over 'Circular References'. This will display the exact cell coordinate that is causing the calculation loop.
Does formatting a cell as Text prevent formulas from working?
Yes. If your debit or credit amounts are entered into cells formatted as text, the spreadsheet treats them as words rather than numbers. Consequently, mathematical formulas will ignore them or return an error.




