What is included
- Income and expense ledgers connect with invoice, bill and monthly P&L views.
- Dashboard summaries include cash, unpaid invoices, upcoming bills and category comparisons.
- A bank-check area compares your entered statement balance; the tax-jar estimate uses your chosen rate.
- Includes Google Sheets plus a macro-enabled Excel sample and macro-free blank .xlsx workbook.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- Income and expense source records
- A consistent set of bookkeeping categories
- Invoice references and the payments recorded against them
A practical way to use your records
Choose a reporting period and enter transactions consistently. Reconcile recorded amounts with the source accounts, then review invoice tracking and profit and loss using the same dates. Keep supporting documents available so totals can be checked against individual entries.
A worked example
Fictional example: a small business reconciles three cash-record categories for one month before reviewing its wider bookkeeping records.
- Customer receipts
- $3,000 actually received
- Recorded supply payments
- $700
- Recorded service payments
- $200
- Match each entry to its invoice, receipt or payment reference and keep dates consistent with the period being reviewed.
- Check the listed receipts and payments, then separately investigate outstanding invoices and any additional business expenses.
Result: The listed cash movements have a $2,100 difference. This is a check on these records only; it is not a complete profit, cash-balance or tax calculation because other opening balances and transactions are outside the example.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Small Business Bookkeeping Spreadsheet for Google Sheets and Excel
Additional previews from this product's Etsy listing. Open any image for a larger view.
Learn the method
Questions about this product
Does this include invoice tracking?
Yes. Income and expense records, invoice tracking and profit and loss are included.
Is this a future financial forecast?
This is a bookkeeping spreadsheet. Compare the separate forecast products if your main task is modeling future sales or cash flow.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
