90-Day Accounting: From Records to Foresight

Stage output: Build the Accounting System Charter and Control Map.

1. Day 1
   What decisions should the accounting system support?

   Define the decisions the accounting system must help Northstar Foods Ltd make.

2. Day 2
   What makes financial information useful?

   Judge information by relevance, faithful representation, timeliness and understandability.

3. Day 3
   What is evidence in accounting?

   Build a traceable source-evidence index for the fictional business.

4. Day 4
   Which accounting roles and responsibilities are needed?

   Separate preparation, review, approval and custody responsibilities.

5. Day 5
   How should accounts be organised?

   Review and extend a decision-focused chart of accounts.

6. Day 6
   Where can an accounting workflow fail?

   Map five accounting risks to preventive or detective controls.

7. Day 7
   Can the learner explain the whole system?

   Assemble the Week 1 Accounting System Charter and defend its logic.

Stage output: Clean transaction register and evidence index.

1. Day 8
   What belongs in a transaction register?

   A transaction register needs enough information for another person to identify the event, locate the source and understand its status before posting. Mandatory fields should be completed consistently; missing evidence remains an exception.

2. Day 9
   How do sales documents flow into records?

   A sales trail normally connects order or agreement, dispatch or delivery, invoice, credit note where relevant, and later receipt. The accounting record must distinguish cash sales, credit sales, returns and cancellations.

3. Day 10
   How do purchase documents flow into records?

   Purchase capture should establish business purpose, supplier, date, amount, approval and evidence of receipt. Duplicate invoice numbers, repeated amounts and unsupported supplier changes deserve explicit review.

4. Day 11
   How are cash and bank records distinguished?

   Cash on hand and money at bank are separate assets with different evidence and risks. A bank narration can help match a movement, but it rarely proves the complete business purpose or accounting classification by itself.

5. Day 12
   What evidence supports payroll totals?

   The ledger usually needs authorised payroll control totals, payment evidence and account allocation—not unnecessary employee-level personal data. Totals should reconcile across gross pay, deductions, employer costs, net pay and payment or liability balances.

6. Day 13
   How are duplicates, gaps and cut-off issues found?

   Quality checks look for repeated references, sequence gaps, unusual dates, incomplete fields, inconsistent signs and transactions near the period boundary. A flagged item is a question for investigation, not automatic proof of error or fraud.

7. Day 14
   Is the source pack complete enough to post?

   A posting-ready source pack is complete enough for controlled processing: records are indexed, classifications are supportable and every unresolved exception is visible with an owner and next action. Readiness does not mean pretending uncertainty has disappeared.

Stage output: Posted journal, ledgers and first trial balance.

1. Day 15
   Why must every entry balance?

   For each transaction, identify what the business received, what it gave up or owes, and which accounts changed. Assets and expenses normally increase with debits; liabilities, equity and income normally increase with credits.

2. Day 16
   How are sales and receipts posted?

   A credit sale commonly increases receivables and revenue; a later receipt increases bank and reduces receivables. A cash sale combines the sale and receipt effect. Returns and taxes, where present, must remain visibly classified.

3. Day 17
   How are purchases and payments posted?

   A credit purchase records an asset or expense and a payable; later payment reduces bank and the payable. Classification depends on what was acquired and when its benefit is consumed, not merely on the supplier name.

4. Day 18
   How are capital, drawings and financing recorded?

   Owner investment, drawings, borrowing and loan repayment are financing or equity events, not ordinary trading income and expense. Interest, however, is normally a finance cost distinct from principal repayment.

5. Day 19
   How do journals become ledgers?

   A ledger groups journal lines by account while retaining date, reference, narration and the opposing logic. The closing balance is the accumulated result of correctly posted movements, not an independently typed total.

6. Day 20
   What does the trial balance prove—and not prove?

   A trial balance proves that posted debit balances equal posted credit balances at a point in the workflow. It does not prove completeness, correct classification, correct cut-off or adequate evidence.

7. Day 21
   Can posting errors be found systematically?

   Error correction should preserve the original record, identify the cause, receive appropriate approval and post a traceable correction. Suspense or plug figures can locate imbalance temporarily but cannot substitute for investigation.

Stage output: Reconciliation pack with open-item log.

1. Day 22
   Why can bank and ledger balances differ?

   Bank and ledger balances can differ because of outstanding payments, deposits in transit, bank charges, direct debits, interest, errors or period cut-off. Classification determines whether the ledger needs an entry or the item simply needs monitoring.

2. Day 23
   How is a bank reconciliation prepared?

   Begin with dated source balances, update the ledger for valid bank-only items, list remaining timing differences and prove the reconciled balance. Old or unusual reconciling items require investigation and ownership.

3. Day 24
   How are cash-control issues identified?

   Petty cash reconciliation compares the authorised float with cash counted plus supported vouchers and approved replenishments. Shortages, IOUs, missing receipts and stale advances are exceptions, not routine expenses.

4. Day 25
   Do receivables agree to customer balances?

   The receivables control balance should agree with the total of individual customer balances after valid timing items and corrections. Ageing, disputes, unapplied receipts and credit balances affect recoverability and follow-up.

5. Day 26
   Do payables agree to supplier balances?

   The payables control account should agree with the supplier schedule. Missing invoices, duplicate entries, unallocated payments, debit balances and statement differences may reveal completeness or cash-pressure risks.

6. Day 27
   How are unresolved items controlled?

   Open items need a stable reference, origin, amount, age, risk, owner, target date and next action. Ageing helps management distinguish routine timing from items that threaten accuracy, cash or control.

7. Day 28
   Is the reconciliation pack review-ready?

   Review is more than a signature. The reviewer checks source balances, arithmetic, classifications, ageing, corrective entries, unresolved risk and evidence that previous questions were answered.

Stage output: Adjusted trial balance and adjustment schedule.

1. Day 29
   Why do period-end adjustments exist?

   Adjustments address timing, consumption, estimates and identified errors so the period reflects supported economic activity. A control schedule prevents journals from becoming isolated, unexplained fixes.

2. Day 30
   How are accruals recognised?

   An accrual recognises an expense incurred before the supplier invoice is recorded, together with a liability. The estimate should use the best available evidence and be reversed or compared with the eventual invoice.

3. Day 31
   How are prepayments recognised?

   A prepayment is the portion of a paid cost that relates to a future period. Release should follow the period or usage pattern supported by the contract, not an arbitrary monthly amount.

4. Day 32
   How is depreciation applied transparently?

   Depreciation allocates depreciable cost over estimated useful life; it is not a cash payment or a current market valuation. Method, useful life, residual value, start date and asset disposal status must remain visible.

5. Day 33
   How is inventory adjusted at period end?

   Period-end inventory should be supported by count evidence, cut-off and an appropriate valuation basis. Count differences may indicate timing, recording error, damage, wastage or control failure.

6. Day 34
   How are doubtful debts and corrections assessed?

   Receivable collectability and error correction require evidence, assumptions and review. Age alone may be insufficient; disputes, customer circumstances, subsequent receipts and policy all affect judgement.

7. Day 35
   Does the adjusted trial balance remain controlled?

   The adjusted trial balance combines controlled opening balances, routine postings and approved adjustments. It must balance and reconcile to the adjustment schedule, while unusual or unexpected balances remain subject to review.

Stage output: Close checklist, role map and jurisdiction watchlist.

1. Day 36
   What does a reliable close look like?

   A close checklist sequences source cut-off, posting, reconciliation, adjustments, review, reporting and open-item follow-up. Each step needs an owner, due date, dependency, evidence and completion status.

2. Day 37
   Which controls prevent or detect common errors?

   Control testing asks whether the control is suitably designed and whether it operated as described. A test records the population, sample or observation, evidence, result, exception and response.

3. Day 38
   How should access and segregation be designed?

   System access should reflect job need and separate incompatible powers such as creating suppliers, posting invoices and releasing payments. Small teams can add independent review, dual approval and change reports as compensating controls.

4. Day 39
   What records may tax and payroll systems need?

   Tax and payroll processes may require transaction classifications, dates, payroll control totals, registrations and supporting evidence. This lesson maps inputs and responsibilities; it does not calculate a live liability or replace current professional guidance.

5. Day 40
   How does the UK pathway stay current?

   Time-sensitive UK requirements should be checked at the point of use against GOV.UK, HMRC, Companies House or the relevant standard setter or regulator. Record the page, access date, jurisdiction, question and unresolved need for advice.

6. Day 41
   How does the Nigeria pathway stay current?

   Nigeria-specific requirements should be checked against the relevant current official authority, such as FIRS, CAC or another competent regulator. Federal and state responsibilities must not be assumed interchangeable.

7. Day 42
   When must work be escalated?

   Escalation is a control, not a failure. Live filing, material uncertainty, tax treatment, assurance, legal disputes, suspected fraud, insolvency, sanctions, money laundering and privacy incidents require the appropriate authorised professional or authority.

Stage output: Income statement, balance sheet and cash-flow explanation.

1. Day 43
   How does a trial balance become an income statement?

   Income and expense accounts are mapped consistently to performance lines for the reporting period. Mapping rules should be documented once and exceptions reviewed, rather than reclassifying accounts invisibly inside the report.

2. Day 44
   What drives gross profit and operating profit?

   Gross profit reflects revenue less direct cost of sales; operating profit also reflects operating expenses in the simplified model. Amount and margin movements should be connected to price, volume, mix, input costs, wastage and overhead evidence.

3. Day 45
   How does a trial balance become a balance sheet?

   Assets, liabilities and equity are classified at the reporting date. Current and non-current presentation depends on timing and purpose; contra balances and unusual signs require review rather than automatic reversal.

4. Day 46
   Does the accounting equation hold?

   The accounting equation requires assets to equal liabilities plus equity. A non-zero check signals a model or mapping problem; a zero check proves arithmetic consistency but not completeness, ownership, recoverability or valuation.

5. Day 47
   What explains the movement in cash?

   Profit and cash differ because of working-capital movements, non-cash charges, capital expenditure, financing and owner transactions. A cash-flow bridge explains the movement from opening to closing cash using reconciled information.

6. Day 48
   What disclosures and judgements matter?

   Useful notes identify the reporting period, basis, significant classifications, estimates, uncertainties, commitments and limitations needed to interpret the statements. They should clarify evidence and judgement, not bury them in boilerplate.

7. Day 49
   Can the statements be defended together?

   A defensible pack agrees across statements, reconciles to controlled balances and distinguishes fact, estimate and interpretation. The learner should be able to trace material figures and explain why profit, position and cash tell different but connected stories.

Stage output: KPI pack and working-capital action list.

1. Day 50
   Which measures answer the original decision questions?

   A useful KPI has a decision purpose, formula, source, frequency, owner, target or comparison and a stated limitation. Measures should connect back to the questions defined on Day 1.

2. Day 51
   What does margin analysis reveal?

   Gross margin and operating margin show different layers of performance. Changes may arise from price, volume, mix, direct input cost, wastage, productivity, overhead or classification; amounts and percentages should be read together.

3. Day 52
   What does liquidity analysis reveal?

   Current and quick ratios compare selected current assets with current liabilities, but asset quality and timing matter. Slow inventory, disputed receivables, restricted cash or concentrated obligations can weaken the headline result.

4. Day 53
   How is receivables performance assessed?

   Debtor days is an indicative collection measure whose denominator and period basis must be stated. Ageing, customer concentration, disputes, credit notes and subsequent receipts reveal risks the average can hide.

5. Day 54
   How is payables performance assessed?

   Creditor days estimates supplier payment timing, but late disputed invoices, missing liabilities, differing credit terms and one large supplier can distort interpretation. Longer payment may preserve cash or signal distress.

6. Day 55
   How is inventory performance assessed?

   Inventory days connects stock held to cost of sales over a stated period. Product mix, seasonality, safety stock, obsolescence and valuation quality affect the result and required action.

7. Day 56
   Which working-capital action is justified?

   Working-capital action should connect a measured issue to an owner, expected cash effect, timing, operational consequence and control. Collection, purchasing, stock and payment actions often interact.

Stage output: Operating budget and 13-week cash forecast.

1. Day 57
   What is the budget for?

   A budget may support coordination, resource allocation, target setting and variance learning. The purpose determines the horizon, level of detail, contributors, approval and update rhythm.

2. Day 58
   How are revenue drivers modelled?

   Revenue should be driven by visible quantities, prices and where useful product or customer mix. Capacity, conversion, seasonality, cancellations and collection timing constrain unsupported growth assumptions.

3. Day 59
   How are variable costs modelled?

   Variable cost assumptions connect activity to input quantity, unit price, yield, wastage or delivery cost. They may not move perfectly with volume, so relevant breakpoints and uncertainty should be visible.

4. Day 60
   How are fixed costs and timing modelled?

   Fixed costs are often fixed only within a relevant range and period. Contract dates, step changes, annual renewals, inflation, hiring and one-off expenditure affect both amount and cash timing.

5. Day 61
   How are opening cash and receipts phased?

   The cash forecast begins with reconciled available cash, then phases customer receipts and other inflows when cash is expected—not when revenue is recognised. Existing receivables and new sales need separate collection assumptions.

6. Day 62
   How are payments and financing phased?

   Payments are phased using supplier terms, payroll dates, taxes, capital commitments, financing schedules and other known obligations. Principal and interest remain distinct, and uncertain financing is not treated as committed cash.

7. Day 63
   Where is the minimum cash point?

   Weekly opening cash plus inflows less outflows gives closing cash, which rolls into the next week. The minimum point, timing and headroom matter more than the final-week balance alone.

Stage output: Scenario model and sensitivity table.

1. Day 64
   What distinguishes a scenario from a forecast?

   The base case reflects the current supported view, while downside and upside cases describe plausible alternative conditions. Each narrative should be internally coherent and linked to a decision—not simply a percentage copied across every line.

2. Day 65
   Which assumptions matter most?

   Material assumptions should be separated from formulas and labelled with unit, source, owner, date, base value and scenario values. Visibility lets another person challenge the model without reverse-engineering it.

3. Day 66
   What is the break-even point?

   Unit break-even is fixed cost divided by contribution per unit; revenue break-even depends on contribution margin. The calculation assumes relevant ranges and consistent classification, so capacity, mix and step costs may limit interpretation.

4. Day 67
   How sensitive is cash to sales volume?

   A volume sensitivity changes expected units while preserving or explicitly changing linked revenue, variable cost, capacity and collection assumptions. Profit impact and cash timing may differ.

5. Day 68
   How sensitive is cash to price and margin?

   Price changes affect revenue and contribution only if volume, mix, discounts and customer response are considered. Input cost or wastage changes may compress margin without any list-price change.

6. Day 69
   How sensitive is cash to collection delays?

   Collection delay can create a cash shortfall without changing recognised revenue or profit. A timing sensitivity should move receipts across weeks and preserve the closing-cash roll-forward.

7. Day 70
   Which trigger should management monitor?

   A trigger links a measurable signal and threshold to an owner, review frequency and pre-agreed response. Good triggers allow early action while avoiding constant reaction to immaterial noise.

Stage output: Variance analysis and decision memo.

1. Day 71
   What is financial foresight?

   Lagging measures describe what has already happened. Foresight asks what the measure implies for future cash, capacity, commitments and decisions, using assumptions and leading indicators that can be monitored.

2. Day 72
   How is budget variance made useful?

   A variance table needs consistent periods, sign conventions and definitions. Amount and percentage variances should lead to an evidence-backed explanation, not merely a favourable or adverse label.

3. Day 73
   Which variances are material?

   A management materiality threshold focuses attention but should consider both size and nature. A small control breach, fraud indicator, legal matter or liquidity issue may be material even below a numeric threshold.

4. Day 74
   What caused the result?

   Driver analysis separates the observable components of a movement and avoids double counting. Price, volume, mix, cost, timing, classification and one-off events should be distinguished from unsupported stories.

5. Day 75
   What can management control next?

   Actions should address controllable drivers and state owner, due date, expected effect, cost, risk, leading measure and review point. Some drivers cannot be controlled directly but can be monitored or mitigated.

6. Day 76
   How should uncertainty be communicated?

   Decision-ready communication separates known facts, estimates, assumptions, ranges and unknowns. Confidence should reflect evidence quality; downside wording should identify exposure and response without pretending to predict precisely.

7. Day 77
   Can insight be turned into a decision?

   A concise memo states the decision, recommendation, supporting evidence, alternatives, assumptions, risks, cash implication, owner and review trigger. It distinguishes analysis from approval authority.

Stage output: Complete month-end close evidence pack.

1. Day 78
   Is the new source batch complete?

   Begin independently: inventory the supplied documents, apply validation rules and preserve unresolved exceptions. Do not copy prior classifications automatically when the new evidence differs.

2. Day 79
   Are all transactions posted?

   Post from indexed evidence with balanced entries, narrations and stable references. Use the imbalance check to locate omissions or one-sided entries, then investigate rather than forcing a plug.

3. Day 80
   Are bank and control accounts reconciled?

   Reconcile bank, cash, receivables and payables from independently derived balances. Classify timing and errors, post supported corrections and age unresolved items.

4. Day 81
   Are adjustments supported?

   Every adjustment should appear once in the control schedule and link to calculation, evidence, approval, journal and reversal or review rule. Estimates state uncertainty and alternatives.

5. Day 82
   Do the statements reconcile?

   Generate the statements from controlled mappings and the adjusted trial balance. Check the accounting equation, statement relationships, cash balance and unusual classifications before interpretation.

6. Day 83
   What do the KPIs and variances say?

   Select KPIs that answer the agreed questions, compare actual with plan and explain only material drivers. Distinguish observed result, supported cause, assumption and proposed action.

7. Day 84
   Can another person review the close?

   A reviewable pack has a clear index, version, preparer, dates, cross-references, passed checks and transparent open items. Review questions and responses are part of the evidence.

Stage output: Financial foresight pack and oral defence.

1. Day 85
   What must the owner or board know first?

   A message hierarchy begins with the decision and the matters most likely to change it. Each message should contain the signal, evidence, implication and—where appropriate—action, without repeating the entire workbook.

2. Day 86
   What does the cash outlook require?

   The scenario summary should show minimum cash, timing, headroom, key assumptions and the action required in each case. It must distinguish approved finance from possibilities and profit effects from cash timing.

3. Day 87
   Which actions have the strongest evidence?

   Action ranking makes trade-offs visible. Expected impact, evidence confidence, time to effect, cost, reversibility, dependencies and downside risk should be considered before a recommendation is approved.

4. Day 88
   Is the pack concise and internally consistent?

   The final pack should use one controlled version, consistent periods and definitions, traceable figures, passed checks, visible uncertainty and a clear decision request. Detail belongs in indexed supporting evidence.

5. Day 89
   Can the learner defend the figures and judgement?

   Defence demonstrates ownership of the work. The learner should trace material figures, explain checks and assumptions, respond to challenge, acknowledge uncertainty and identify matters requiring professional escalation.

6. Day 90
   What system will continue after the course?

   Learning becomes capability when the workflow continues. The operating plan sets the next source cut-off, close calendar, owners, controls, reporting rhythm, action reviews and escalation boundaries.