A simple Excel cash log you can check
See how six cash movements become one balance. Then change a payment and check the difference in a free Excel practice workbook.
By Anz Makes Sense · Updated
Try the cash log
Start with the example already filled in. Change one payment and see how the closing balance responds.
Download the Excel workbookInside the workbook
- A Summary sheet that traces the closing balance
- Six fictional transactions and 100 prepared rows
- Instructions, input checks and a comparison balance
What you need. An app that opens XLSX files. Tested in desktop Excel for Windows; Excel for the web and other spreadsheet apps remain untested.
Educational prototype. Made-up data for practice; no profit, forecast, payroll or tax calculations.
How you may use the sampleThe problem: a total you cannot explain
A total is harder to trust when the input rows, calculations and expected payments are mixed together. You need to see what entered or left the account, and how those movements lead to the amount left at the end.
The build: keep the movements together
This small workbook separates Transactions, Summary and Instructions. The example covers one made-up account, one short period and six completed transactions. The Summary sheet brings the opening balance, money received and money paid into one calculation.
The figures are fictional Philippine pesos. You can follow the relationship in any single currency; the sample does not convert currencies. An expected payment stays outside the recorded movements until it is received.
The result: a balance you can trace
On a small screen, scroll the table sideways to see every column. Keyboard: focus the table, then use the arrow keys.
| Step | Amount (PHP) |
|---|---|
| Opening balance | 10,000 |
| Money received | 9,000 |
| Money paid | 6,000 |
| Closing balance | 13,000 |
Opening balance + money received − money paid = closing balance.
The closing balance is PHP 13,000. Compare it with a separate statement or count, then investigate any difference. A matching total alone does not prove that all the rows are correct.
Try it: change one payment
- Download the workbook and save a separate working copy. Keep the untouched sample so you can recover a formula if you change one by mistake.
- Open Summary. The example starts with closing cash of PHP 13,000 and a difference of PHP 0.
- Open Transactions and find T03, the service payment in row 14. Change its amount in F14 from 1,200 to 1,500.
- Before returning to Summary, predict what the extra PHP 300 paid should do to the balance.
- Check Summary. Money paid should now be PHP 6,300, closing cash PHP 12,700, and the difference −PHP 300, displayed as (300.00) in Excel.
The comparison balance stays at PHP 13,000. Keep that difference visible until you establish why the two disagree. Changing the comparison just to make it match would hide the question you need to answer.
Prefer to work through the calculation first? Read the cash-log guide for the full six-row example and two practice questions.
Before entering more rows
Read the Instructions sheet. Change the amber input cells on Summary and enter transaction inputs in B:F on Transactions. Columns G:I contain formulas. Use In or Out with a positive amount, rather than a negative payment.
There are 100 prepared rows, 12–111. Rows below 111 are not included. To remove a transaction, clear its inputs in B:F and keep the formulas. Formula cells are editable and are not password protected.
Check the input warnings after typing or pasting. In desktop Excel, a typed negative amount was blocked, but a pasted negative amount was accepted: the workbook then flagged the row and showed n.a. for the affected totals. Correct the input before using a result.
What the checks tell us
The original calculation, corrected payment and save/reopen behavior were checked in desktop Excel for Windows on 22 September 2026. These checks support the worked example. Other spreadsheet applications and beginner usability have not been tested.
See the checks and remaining limits
Workbook checks. Automated checks covered the baseline, changed payment, added rows, missing or invalid inputs, duplicate IDs, period dates and a mismatch. The saved XLSX was reimported and both calculation cases were checked again. The preview above is a render of this workbook’s Summary sheet.
Desktop Excel. A copy retrieved from the public download URL was checked in Excel for Windows, version 16.0.20326.20144. Automated recalculation checks confirmed the original PHP 13,000 balance and the corrected PHP 12,700 balance, including after save/reopen. Invalid amounts, an invalid direction and a date outside the period produced warnings and withheld affected totals.
Direct interaction. A separate test opened a disposable copy in Excel, changed T03 through the interface and checked the PHP 12,700 balance and −PHP 300 difference after saving and reopening. Typing a negative amount triggered Excel’s Stop dialog. Pasting a negative amount bypassed that dialog, but the workbook flagged the input and withheld the affected totals. The inspected Summary, Transactions and Instructions areas were readable on the test desktop.
What remains untested. Excel for the web, LibreOffice, Google Sheets, physical-phone use and beginner comprehension. No human usability pass is claimed. Try a small example in your own application before relying on a result.
Version 1.0 is unchanged. The downloadable file retains its original Instructions verification note. This dated page records the later Excel checks. The file contains no macros, external data connections or real financial information; it remains an educational prototype, not a profit report, forecast, payroll tool or tax calculation.
If a result surprises you, ask a question or report a problem. Describe the step and expected result using made-up information. The file-version guide can help you keep the original and your working copy clear.

