Enterprise P&L and balance sheet from controlled transactions

Where reliable financial statements come from

A P&L and balance sheet that leadership can trust come from transactions entered once, at source, with the right account and cost centre, and reconciled before the reports are released. The reports themselves are a by-product. If invoices, bills and payments are controlled, the statements will agree. If they are not, no amount of formatting will fix them.

Many enterprises produce management accounts by exporting ledger data to a spreadsheet and adjusting it there. Each adjustment may be reasonable, but the result is a report that cannot be traced back to the ledger. When the auditor's figures differ from the board pack, nobody can say which adjustments explain the gap.

Designing the chart of accounts around leadership decisions

The chart of accounts decides what the P&L can tell you. With too few accounts, leadership cannot see where margin went. With too many, staff guess between near-identical options and costs scatter unpredictably.

Group revenue accounts by the revenue streams leadership actually discusses. Separate direct costs that move with sales from overheads. Use cost centres or departments for the organisational split instead of opening a separate expense account per department, so that one travel account can be analysed across the whole company. Lock the chart so only a finance owner can add accounts, and write a one-line description for each account explaining what belongs in it.

Coding happens at source, so the chart has to be usable by the people who enter transactions. Map each product and service to its revenue account once, in the product setup, so billing staff never choose a revenue account by hand. Do the same for common supplier categories on the bill side. The fewer account choices made by individuals at the point of entry, the more consistent the P&L becomes.

Keeping manual journals rare and reviewed

Subledger transactions such as invoices and bills carry their own evidence. Manual journals do not, so they are where errors and deliberate misstatements hide most easily. Every manual journal needs a description a stranger could follow, an attachment supporting the amount, and approval from someone other than the preparer.

Review the journal listing at each close. Journals that recur every month, such as depreciation or prepayment releases, can often be scheduled. Journals that correct mistakes point to an upstream process that needs fixing. Journals posted straight to control accounts like receivables, payables or tax should be rare, because they break the link between the control account and its subledger.

Balance sheet lines that need a reconciliation every period

Each balance sheet line should be backed by a schedule that proves its value independently of the ledger. The schedule, not the ledger balance, is the evidence.

• Bank accounts, reconciled to bank statements with unpresented items listed
• Trade receivables, agreed to the AR aging report by customer
• Trade payables, agreed to the listing of unpaid supplier bills
• Tax balances, agreed to the workings behind the relevant return
• Accruals and prepayments, with a schedule showing each item and its basis
• Fixed assets, agreed to the asset register and depreciation schedule
• Intercompany balances, confirmed with the counterparty entity
• Suspense and clearing accounts, cleared to nil or explained item by item

Explaining P&L movements before the board meeting

Once the balance sheet is reconciled, compare the P&L with budget and the prior period. For each significant movement, the account owner writes a line or two grounded in transactions: a large contract invoiced earlier than planned, a supplier price rise, an accrual for a delayed bill. An explanation that just says timing, with no detail, is a sign nobody has looked.

Keep these explanations alongside the report. Over several months they build into a record of how the business behaves, and they let a new controller or auditor understand past results without reconstructing them.

Check the link between the two statements as well. Retained earnings on the balance sheet should move by the period's profit less any dividends declared, and cash movements should be explainable from profit, working capital changes and capital spending. When these links do not hold, something has been posted directly to an equity or balance sheet account and needs investigating before the pack goes out.

Producing statements straight from the ledger

BukuCloud generates the P&L and balance sheet from the invoices, bills and payments recorded in it, alongside the AR aging report that supports the receivables line. Your accountant reviews the same ledger, so year-end adjustments are made in the books rather than in a separate file. See bukucloud.com.

Frequently asked questions