Selling S/ 1,000 does not mean S/ 1,000 is available to spend. Money may arrive later, be subject to fees, already be committed, or fail to match what we think we recorded.
A small business can begin with a transaction ledger, a list of obligations, and a regular reconciliation. Its purpose is not to replace an accountant or produce formal financial statements. It helps determine how much money actually came in, how much went out, what remains to be collected, what falls due soon, and which differences require an explanation. Australian government and SBA business-record guidance recommends keeping evidence, recording income and expenses, and reconciling bank and cash accounts [R01][R02].
1. Distinguish Sales, Revenue, Collections, Payments, and Available Cash
These terms describe different events. A sale is an agreed commercial transaction; an invoice is a commercial or tax document as applicable; recognized revenue depends on the relevant accounting basis; a collection is money actually received. A purchase or expense does not necessarily result in immediate payment. Profit results from revenues and costs or expenses under an accounting policy, while cash flow deals with money coming in and going out. A loan received is not a sale; transferring money between your own accounts is not new revenue.
| Hypothetical event | Does it increase sales? | Does it increase cash available today? | What to record |
|---|---|---|---|
| Make a credit sale for S/ 350 | Yes | No | Sale and receivable |
| Collect S/ 200 from an earlier sale | No; already recorded | Yes | Collection linked to debt |
| Borrow S/ 500 | No | Yes, subject to restrictions | Financing inflow and debt |
| Move S/ 100 from cash to the bank | No | Total unchanged | Transfer between owned accounts |
| Pay today for supplies purchased earlier | Does not change the earlier purchase | Decreases | Payment and reduced payable |
The formal meanings of revenue and expenses depend on accounting standards and applicable rules. For daily management, keep the commercial event, document, and movement of money distinct. The SBA explains differences between cash-basis and accrual accounting; this article does not choose a tax method for the reader [R02].
2. Design a Minimum Verifiable Transaction Ledger
A simple spreadsheet needs ID · date/time · description · customer/supplier · document · currency · amount · inflow/outflow · payment method · account · status · related reference · owner. If a payment partially settles an invoice, link it to the same obligation ID to avoid duplicates. An unpaid sale belongs in the receivables list; do not invent it as a cash receipt in the ledger.
Third-party commitments arising from purchasing and receiving supplies must appear in accounts payable even if cash has not yet left.
For multiple currencies, maintain separate fields for original currency, original amount, reporting currency, exchange rate, and conversion date as needed. Do not add S/ 100 and US$ 100 as though they amounted to 200 units of one currency. With payment processors, identify the sales date, settlement date, fee, and net deposit; these figures can differ.
Correction rule: retain the original transaction and document an adjustment or reversal with author, reason, and date. Deleting a row just to force the balance to match destroys traceability. Protect payment data and restrict access; a cash ledger does not need full card numbers or unnecessary sensitive documents.
3. Track Receivables and Payables with Due Dates
An accounts receivable record should identify who owes what, the document, due date, amount paid, balance, and owner of follow-up. An accounts payable record identifies suppliers, payroll, and applicable obligations, including amounts, due dates, partial payments, and confirmation. A due date is not merely a reminder: it can change how much cash is free for a new purchase.
To collect payment without losing agreed conditions, record from the B2B or B2C sales process who owes what, when, and under which agreement.
| ID | Class | Counterparty | Original total | Paid/collected | Outstanding | Due | Status |
|---|---|---|---|---|---|---|---|
| C-018 | Receivable | Customer A | S/ 350 | S/ 0 | S/ 350 | Day 7 | Pending |
| P-011 | Payable | Supplier B | S/ 400 | S/ 0 | S/ 400 | Day 5 | Scheduled |
An S/ 350 invoice partially collected for S/ 100 leaves S/ 250 outstanding, not a second sale of S/ 100. Where there are disputes, refunds, or overdue invoices, separate amounts legally due from those realistically collectible; do not treat the best-case outcome as certain cash. Follow-ups must comply with contracts, privacy, and local debt collection rules.
4. Control Cash, Transfers, Cards, and Platforms Separately
Physical cash can be counted but requires control of change, withdrawals, and deposits. Bank transfers have transaction references; cards and wallets can hold, reverse, or settle funds days later; platforms may charge fees, withhold funds, or initiate chargebacks. Record gross amount, fee, net settlement, and time of availability when these differ.
General example: a S/ 100 sale with a hypothetical platform fee of S/ 3 produces a net settlement of S/ 97. The fee has not vanished because the bank only displays 97. Tax and accounting treatment of fees, chargebacks, and sales must be verified locally. If a customer pays in two parts by different methods, record both movements against the same obligation.
Control who receives cash, processes refunds, and authorizes material outflows. In small operations one person may perform several roles, but should preserve evidence and periodically review unusual entries. Australia's tax authority recommends keeping banking records and regularly reconciling money in and out [R03].
5. Reconcile by Explaining Differences, Not Forcing a Match
Reconciliation compares the ledger balance with the actual position shown by counted cash, bank statements, and processor settlements. For each account, start with a verified opening balance, add actual receipts, and subtract actual payments. Then identify unrecorded movements, fees, pending transfers, errors, or duplicates. Never invent a fee just to make the numbers match: find supporting evidence.
Hypothetical bank account example: opening balance S/ 300, bank transfer collected S/ 450, supplier payment S/ 120. The expected ledger balance is 300 + 450 − 120 = S/ 630. The bank statement shows S/ 624. The S/ 6 difference needs investigation. Assume the statement proves an actual bank fee of S/ 6 that was not yet recorded. Add a supported fee transaction; the updated ledger agrees with S/ 624.
| Bank account item | S/ |
|---|---|
| Opening balance | 300 |
| Confirmed bank collection | +450 |
| Recorded supplier payment | −120 |
| Expected balance before adjustment | 630 |
| Fee supported by bank statement | −6 |
| Reconciled balance | 624 |
If S/ 200 in cash is counted and recorded separately, the total across both accounts is S/ 824. Cash needs its own reconciliation; do not simply presume the 200 remains in the drawer. The SBA lists bank reconciliation as a core financial task [R02].
6. Separate Bank Balance from Money You Can Commit
Having S/ 824 on hand does not mean it is prudent to spend it all. Supplier obligations, wages, taxes, refund reserves, financing, and replenishment may be due soon. An initial planning approximation is:
Provisionally uncommitted cash = reconciled balances − confirmed near-term payments − earmarked reserves.
This is not a universal accounting measure and does not make uncertain obligations exact. With S/ 824 reconciled and a confirmed S/ 400 invoice due this week, S/ 424 remains provisionally uncommitted before any other unlisted expenses, taxes, fees, or contingencies. Do not call that figure “profit”: the case has not identified all costs and obligations.
Clearly mark items as committed, likely, or contingent. Track available balances by account and a date-based consolidated view. If a business holds restricted customer funds, do not redirect them to unrelated spending without proper contractual and legal authorization.
7. Build a Payment Calendar and Weekly Cash View
Instead of waiting for month-end, create a seven- to fourteen-day table with opening balance, confirmed collections, likely collections shown separately, dated payments, projected balance, and decision. Likely receipts can appear in a scenario, not in guaranteed cash. A useful forecast answers: “On which day might we be short, and which commitments could we legitimately renegotiate, finance, or reschedule?”
When the near-term calendar reveals future shortfalls, update the cash-flow and reserve projection; the forecast does not replace reconciliation of actual balances.
| Illustrative horizon | Opening balance | Confirmed incoming | Committed outgoing | Balance without other movements |
|---|---|---|---|---|
| Today | S/ 824 | S/ 0 | S/ 0 | S/ 824 |
| This week | S/ 824 | S/ 0 | S/ 400 | S/ 424 |
This is not a second twelve-month financial forecast, which belongs to business preparation. It is a short-term operating routine that feeds more extensive forecasts with observed data. If incoming funds are insufficient, adjust commitments realistically; do not make promises the operation cannot deliver just to plug a cash gap.
8. Connect Sales, Contribution Margin, and Liquidity Without Mixing Them
Three questions require three views. Did we sell? Examine orders and sales. Was it economically worthwhile? Examine price, variable costs, discounts, fees, fixed costs, and contribution; a cash receipt does not establish profitability. Can we pay? Examine dated collections and payments. A business can have positive contribution per order and still lack cash when suppliers are paid before customers pay.
When evaluating a channel or price, calculate contribution under the appropriate assumptions. When deciding whether a debt can be paid tomorrow, cash is more relevant than monthly accounting profit. Do not deduct a fee twice when comparing processor net deposits with gross sales. Business.gov.au's cash management guidance recommends records of sales, costs, and supporting documents to interpret liquidity [R04].
Avoid dashboards that call every figure “revenue.” Define the metric and data source: dated sales, settled receipts, receivables, payments, obligations, reconciled cash, and reserves. That prevents higher sales from hiding the fact that the company is involuntarily financing its customers.
9. Recognize Warning Signs and Act on Evidence
Watch for late receivables, unsupported expenses, recurring reconciliation differences, unrecorded returns, dependence on one settlement provider, projected negative balances, and personal spending mixed with business funds. A discrepancy does not prove fraud by itself: first investigate data entry, dates, fees, and pending transfers. An unexplained pattern, however, warrants supervision and additional controls.
Set attention thresholds based on business risk. For instance, “every unexplained discrepancy must be recorded and reviewed before the close is declared complete,” rather than pretending that S/ 5 or a specific legal deadline is universal. Retain who reviewed the issue, what was found, and the next action.
Where funds are held for third parties, advance payments are restricted, tax withholding applies, or payroll is involved, do not decide treatment from a generic template. Check applicable law and seek appropriate professional advice for safeguarding and record keeping.
10. Establish a Daily or Weekly Close You Can Sustain
A realistic small-business routine is: (1) gather sales and documents; (2) record actual receipts and payments; (3) update outstanding amounts and due dates; (4) reconcile accessible cash and bank movements; (5) check upcoming obligations and minimum cash; (6) investigate differences; (7) preserve evidence and approve the close. At higher volume, transaction imports can reduce work, but automation never replaces investigating discrepancies.
Increase formality as the business grows: access permissions, separation of duties, accounting, backups, and independent reviews. Tax rules, record retention, e-invoicing, and payroll depend on country, industry, and legal form. A simple cash workbook is an initial operating control, not a declaration of full accounting or tax compliance.
Worked Example: S/ 1,000 in Sales and Only S/ 650 Collected
The Almuerzo Cerca case is entirely hypothetical. Daily sales total S/ 1,000. The business receives S/ 450 by bank transfer and S/ 200 in physical cash; S/ 350 remains receivable. Opening balances are S/ 300 in the bank and S/ 0 in cash. It pays S/ 120 to a supplier from the bank account. The statement reveals a documented S/ 6 fee. A S/ 400 invoice is due later in the week.
| Question | Calculation | Result |
|---|---|---|
| Daily sales | Assumption | S/ 1,000 |
| Collected today | 450 + 200 | S/ 650 |
| Still receivable | 1,000 − 650 | S/ 350 |
| Reconciled bank balance | 300 + 450 − 120 − 6 | S/ 624 |
| Cash counted | 0 + 200 | S/ 200 |
| Total across accounts | 624 + 200 | S/ 824 |
| Confirmed upcoming payment | Assumption | S/ 400 |
| Provisionally uncommitted | 824 − 400 | S/ 424 |
The S/ 350 receivable is not part of current cash. The S/ 200 physical cash is not counted a second time as additional sales. The S/ 424 is only a preliminary balance after the identified payment; other expenses, taxes, payments, and reserves may remain. Nor can we determine profit from these sales: the example does not provide all related costs.
Decision: review the expected S/ 350 collection date, plan the S/ 400 payment without losing cash visibility, identify any other due items, and investigate discrepancies before closing. A forecast in which the collection arrives on time is a scenario, not a guaranteed balance.
Ready-to-Use Templates
A. Cash and bank ledger
| ID | Date | Account/method | Description | Inflow | Outflow | Ending balance | Evidence |
|---|---|---|---|---|---|---|---|
| M-001 | Day 1 | Bank | Reconciled opening balance | S/ 300 | — | S/ 300 | Opening statement |
| M-002 | Day 1 | Bank | Customer collection | S/ 450 | — | S/ 750 | Bank transaction |
| M-003 | Day 1 | Bank | Supplier payment | — | S/ 120 | S/ 630 | PO/invoice |
| M-004 | Day 1 | Bank | Verified fee | — | S/ 6 | S/ 624 | Statement |
| M-005 | Day 1 | Cash | Customer collection | S/ 200 | — | S/ 200 | Receipt and count |
Calculate balances per account: M-005 does not inherit the bank balance from M-004. The opening balance is a reference entry, not another sale.
B. Outstanding obligations register: Obligation ID · customer/supplier · issue date · currency · original amount · paid/collected · outstanding · due date · status · evidence · owner · next action.
C. Payment calendar: Week/day · confirmed opening balance · confirmed collections · likely collections separate · mandatory payments · negotiable payments · minimum balance · decision.
D. Account reconciliation: Account and date · ledger balance · bank statement/counted balance · difference · items in transit · verified fees · documented adjustments · reconciled balance · owner and evidence.
Common Mistakes and Limitations
- Treating invoices or sales as collected money, including customer debts in cash, or double-counting transfers between owned accounts.
- Hiding fees inside net deposits and then comparing those net deposits with gross sales as though the numbers were equivalent.
- Deleting differences to force agreement instead of reconciling them and documenting the reason.
- Adding unlike currencies without an exchange-rate policy or treating committed funds as available for new investment.
- Using a workbook as a substitute for tax obligations, audit requirements, statutory retention, or local accounting advice.
What You Should Have When You Finish
An account-level inflow/outflow ledger, dated outstanding amounts, a documented reconciliation, a payment calendar, and a provisional free-cash figure calculated without confusing sales, profit, and actual money. The useful discipline is small but consistent: record, compare, explain, and decide.
References
- [R01] Australian Government, business.gov.au. Record keeping. Income, expenses, banking, and supporting documents.
- [R02] U.S. Small Business Administration. Manage your business. Cash versus accrual and the importance of reconciliation and outstanding accounts.
- [R03] Australian Taxation Office. Tips for banking records. Separation and reconciliation of bank transactions.
- [R04] Australian Government, business.gov.au. Guide to managing cash flow. Record keeping and cash-management discipline.