This is an educational record-organization workflow for a manual cashbook. It is not a statutory accounting close, a tax classification guide or a substitute for advice about your business's reporting obligations.
1. Define the period and the cash you are tracking
Write down the month and the accounts or cash balances included in the record. Keep that scope consistent when comparing opening and closing amounts. A cashbook covering one business account cannot be expected to match a combined total from that account, a personal account and a payment platform.
Keep actual receipts and payments separate from unpaid invoices and expected future costs. A customer promising to pay next week is useful planning information, but it is not cash received today. If you also track orders or forecast cash, keep their different purposes visible.
2. Put the supporting records where you can find them
Gather the statements, receipts, payment confirmations and other documents relevant to the period. A simple folder structure by year and month can be enough for this review. Use consistent filenames or a separate note to connect an unclear entry with its supporting document. This is an organization suggestion, not a claim that the HFP workbook stores attachments.
The IRS overview of business records explains the role of documents supporting entries. Its legal requirements are US-specific. The general point used here is narrower: a spreadsheet total does not replace the records that explain it.
For a missing document, keep an exception note with the date, amount and question still open. Do not invent a description just to make the list look complete.
3. Use categories that you can apply consistently
Category labels should help you find and review similar activity. Choose labels that suit the records you actually maintain, then use the same label for the same purpose throughout the period.
| Example label | Record-organization purpose | Question to resolve |
|---|---|---|
| Software services | Group recurring tools used in the business | Is this a business-only charge or does it need clarification? |
| Workspace costs | Find premises-related cash payments | Which period and document does the payment relate to? |
| Packaging and shipping | Review cash paid for those activities | Is the amount already included in another recorded payment? |
| Professional services | Group payments for services received | Do you have the invoice and payment evidence? |
| Customer receipts | Find money actually received from customers | Does the deposit combine several payments or reflect fees? |
These are review labels, not deductible-expense categories. Keep owner contributions, drawings and loan principal distinct from operating activity according to the workbook's supported entry types. Ask a qualified adviser about an uncertain transaction's accounting or tax treatment.
4. Separate the operating cash result from the change in cash
Consider a fictional month with $1,200 opening cash. The record contains $900 received from customers, $350 of operating payments and a $500 owner contribution. There are no other movements in this simplified example.
| View | Calculation | Result |
|---|---|---|
| Operating cash result | $900 − $350 | $550 |
| Change in tracked cash | $900 + $500 − $350 | $1,050 |
| Closing tracked cash | $1,200 + $1,050 | $2,250 |
The owner contribution explains why cash rose by more than the operating cash result. Recording it as a customer sale would distort that distinction. These cash figures are not an accrual profit calculation or a tax return.
The Small Business Bookkeeping spreadsheet provides a manual cashbook for one calendar year, up to 600 dated entries and 20 unique category labels. Its monthly views distinguish operating activity from owner funds, loan principal and other cash movements. It does not provide bank feeds, accrual accounts or tax calculations.
5. Investigate differences instead of forcing a match
Compare the tracked closing amount with the actual records for the same cash scope and date. If they differ, inspect missing payments, duplicated entries, refunds, fees, transfers and timing differences. A processor payout may combine several customer receipts and deductions; keep enough supporting information to explain what was recorded.
Do not add an unexplained balancing amount just to make two totals equal. Resolve the source of the difference or leave a clearly described open item. This is a manual check; the product does not automatically reconcile your bank account.
6. Keep a review note and separate next month's forecast
Save the review date, unresolved items and any corrections that need explanation. Keep a dated copy if you need to preserve the state of the record before later edits. Use the next period's actual opening position consistently; do not also enter that same opening balance as new customer income.
For future receipts and payments, compare the 13-Week Cash Flow Forecast. It serves a different job from the cashbook. The order-to-cash guide shows why an order balance and an expected receipt date belong in separate views. The files do not synchronize automatically.
Is this a full month-end accounting close?
No. This workflow reviews a manual cash record and its supporting evidence. It does not cover accrual adjustments, payroll reporting, inventory valuation or formal financial statements.
Should I create a category for every supplier?
Only if that distinction helps your review. Categories group activity; the transaction description and supporting document identify the particular payment. Keep the workbook's 20-label capacity in mind before designing the list.
Can HFP tell me which expenses I can deduct?
No. The product organizes cash entries. Deductibility and reporting rules depend on your circumstances and jurisdiction. For help opening the supplied files, use the Google Sheets setup guide and the exact product's compatibility information.
