How to Review Your Business Finances in a Spreadsheet
Build a small review that connects your records to one decision. You need a traceable set of numbers, not an elaborate dashboard.
Choose a Period and Gather the Records
A useful finance spreadsheet shows what happened, what you expected and what needs attention next. Start with one completed month and a short forward cash view. Use the same dates across your bank records, sales reports and expense records.
Gather statements for the business accounts in scope, payment-processor settlement records, unpaid customer invoices and bills you still owe. Keep links or references to the original records in a private place. Don't paste customer names, account numbers or other personal information into a shared review when totals will do.
This review supports your bookkeeping. It doesn't replace bank reconciliation, accounting records or professional advice on how to classify transactions.
Build a Cash Bridge First
Give the sheet separate rows for opening cash, customer receipts, other cash in, cash paid and closing cash. Within the payment rows, keep operating payments, equipment purchases, loan payments and owner withdrawals distinguishable. Match the level of detail to the records you can actually check.
Closing cash equals opening cash plus cash in minus cash out. For an invented example, $18,000 opening cash plus $9,000 customer receipts and $2,000 owner funding, less $11,500 in payments, gives $17,500 closing cash.
Put the row labels in column A and the amounts or formulas in column B. For a minimal layout, put opening cash in B2, customer receipts in B3, other cash in B4 and the sum of all supporting payment rows in B5. Enter payments as positive numbers. In B6, use =B2+B3+B4-B5 for calculated closing cash. Put the actual closing cash from your records in B7 and =B6-B7 in B8. The check in B8 should equal zero after the same accounts and dates are reconciled. Keep the payment breakdown in supporting rows or a separate tab; don't add it again to B5.
Check that result against the closing balances of the same accounts. If it doesn't match, investigate the difference before relying on the review. Look for missing movements, duplicate entries, transfers counted as income or a mismatch in dates. Don't insert a balancing number to make the sheet agree.
Keep Revenue in Its Own View
Add revenue and expenses from your accounting records for the same period, with the accounting method identified. Don't assume the cash-payment total is the expense figure, or that customer receipts equal revenue.
For example, collecting an old invoice increases this month's cash without necessarily adding this month's revenue under accrual accounting. A new loan increases cash but isn't a sale. Keeping these rows separate lets you ask why profit and cash moved differently without changing the underlying records to force them to match.
Compare What Happened with What You Expected
Use columns for planned amount, actual amount, difference and explanation. State how you calculate the difference. 'Actual minus plan' is a simple convention, but a positive number isn't automatically good: higher costs and higher receipts have different meanings.
Suppose you expected $10,000 in customer receipts and received $9,000. The difference is -$1,000. If an invoice moved into the following month, record the expected collection date and update the forward cash view. If the sale was canceled, changing the date would hide a different issue.
Explain the few differences that change a decision. A short note with a source is more useful than coloring every row red or green without saying what happened.
Add the Next Payments, Then Choose an Action
Below the completed period, list upcoming receipts and payments by date or week. Separate confirmed commitments from estimates and possible changes. A spreadsheet can show the effect of a delayed receipt or a proposed expense; it can't guarantee either will happen.
Choose an action that follows from the numbers. You might confirm an invoice's payment status, check a renewal date, or compare whether a proposed purchase still fits if receipts arrive later. Record who will check it and when the answer matters.
Keep formulas separate from input cells and label missing inputs as missing. A blank cost cell isn't proof the cost is zero. Save a dated version before updating the next period so you can compare the forecast you made with what actually happened.
Keep the Review Small Enough to Use
Start with the cash bridge, the few accounting totals you understand and the upcoming payments that affect your next decision. Add detail when you can explain what question it answers.
If you can't reconcile a balance or classify a transaction, bring the source records and the question to a qualified bookkeeper or accountant. A clear spreadsheet makes that conversation easier; it doesn't make uncertainty disappear.
Check the Sheet with a Small Exercise
Enter the fictional example: B2 is 18000, B3 is 9000, B4 is 2000 and B5 is 11500. B6 should calculate 17500. Put 17500 in B7 and the B8 difference should be zero.
Now change the actual bank balance in B7 to 17300. B8 becomes 200. Don't hide that difference by changing the payment total without evidence. Work backwards through dates, transfers and original records until you can explain it.
Finally, write one next action beside the period: what you will check, who owns it and when the answer matters. You can use the SBA finance overview for bookkeeping context and the FDIC cash-flow workbook for the forward cash view.
General education with fictional examples, not accounting, tax or financial advice for your business.