Small Business Spreadsheet: A Simple Weekly Excel Review
A small business spreadsheet is most useful when it supports a repeatable review instead of becoming another file full of disconnected records. Start with four questions each week.
1. What came in?
Review sales and other recorded income for the period.
2. What went out?
Review operating expenses and identify unusual or incomplete entries.
3. Which invoices still need follow-up?
Separate unpaid invoices from cash already received and assign the next action.
4. What needs attention before the next review?
Use cash-flow and profitability views to identify decisions, not just totals.
See the actual workbook before choosing
Watch the 45-second bookkeeping workbook demonstration on YouTube. Inspect fictional SALES and EXPENSES entries and why recorded revenue is not proof of cash received.
English and Spanish captions are available. The DEMO and BLANK workbooks and on-screen text are in English. Silent worksheet walkthrough; the paid download is separate.
Start with one workflow
You do not need every possible dashboard at once. Begin with sales, expenses, invoices and cash, then add other trackers only when they support a real operating decision.
For a reusable Excel system, inspect the MetricForgeHQ Small Business Bookkeeping Spreadsheet. The product page includes a fictional demo, blank workbook, actual workbook previews and a separate free cash-planning sample.
This guide supports general business organization and is not accounting, tax, legal, investment or financial advice.
Worked weekly review: sales are not the same as cash
In a fictional week, a business issues $2,000 in invoices, receives $1,200 against those invoices and pays $900 in expenses. It starts with $1,000 in cash. Assume no other movements, credits or adjustments.
- Invoices still unpaid: $2,000 − $1,200 = $800.
- Net cash movement: $1,200 − $900 = $300.
- Closing cash: $1,000 + $300 = $1,300.
Do not add the unpaid $800 to available cash. Assign collection follow-up, then compare the $1,300 cash balance with upcoming commitments. This cash exercise does not calculate accounting profit or taxes.
Try the free 13-week cash planner or inspect the paid bookkeeping workbook and its actual previews.