Calculation Issues

How to Fix a Check Register That Does Not Calculate Balances in Spreadsheets

Rana GarciaRana Garcia Oct 22, 2026 870 views

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.

How to Fix a Check Register That Does Not Calculate Balances
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 you start

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.

Solution 1Recommended

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.

1
Select the broken cell

Click on the first cell in your running balance column that is failing to calculate.

2
Check the formula bar

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).

3
Apply the correct formula

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.

Verify and Fix Running Balance Formulas
Formula Update: Dragging the fill handle will automatically adjust the relative cell references for each row, instantly fixing your entire check register.
Manage Finances Efficiently

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. 1. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' from the main dashboard.
  2. 2. Access Templates: Navigate to the Template library and search for 'Check Register' or 'Expense Tracker'.
  3. 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.
Includes ready-to-use, error-free check register templatesFully compatible with Microsoft Excel (.xlsx) formats and formulasLightweight, fast, and completely free to useBuilt-in error checking to instantly locate formula issues
microsoft office alternative - wps office

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.