The balance sheet shows 42 million CFA francs of inventory. The banker asks how that figure is built. If the answer takes three days and a spreadsheet, the problem is not the banker. A finance team must be able to start from any amount in its statements and go down, without a break, to the vouchers that justify it. This is financial lineage.
What financial lineage is
Financial lineage is the continuous thread linking each level of accounting information to the next:
| Level | Question | What links it to the next level |
|---|---|---|
| Financial statement | How much inventory on the balance sheet? | The line groups a list of accounts |
| Accounts | Which accounts make up this amount? | Each account has a balance made of entries |
| Entries | Which transactions moved these accounts? | Each entry belongs to a voucher |
| Voucher | Which document justifies the transaction? | Invoice, delivery note, statement, contract |
The thread runs both ways. Tracing back (from the statement to the voucher) justifies a figure. Tracing forward (from the voucher to the statement) checks that a transaction is correctly classified and measures its effect on the accounts.
Auditors call this the audit trail. The principle is as old as double-entry bookkeeping: a financial statement is only worth something if it can be linked to supporting documents.
Why it is the finance team’s business
- In front of the auditor and the tax authority, an amount you cannot break down is a disputed amount. Every hour spent rebuilding a figure is an hour billed, or a possible reassessment.
- In front of the banker, the perceived quality of the statements drives credit. A manager who opens a line’s detail in a meeting inspires confidence; one who promises to “get back to you” much less.
- Internally, an unexpected change (an expense line that doubles) must be explained by its entries, not by a guess.
- At year end, lineage lets you correct at the source: an error found in the voucher is fixed once, and every statement follows.
Why Excel set-ups break the thread
In many SMEs in the OHADA zone, financial statements are produced like this: export the trial balance from the bookkeeping software, paste it into a workbook, and formulas allocate it to the balance sheet and income statement lines. The tax package is filled in from that workbook.
The result may be right. But the thread is cut in three places:
- Between the trial balance and the statement: the mapping lives in formulas, often changed from one year to the next, that only their author understands.
- Between the workbook and the software: the pasted trial balance is a snapshot. An entry posted after the export is not in it, and nobody notices.
- Between the account and the voucher: to justify a balance, you go back to the software, find the account, then the voucher, hoping the figures still match.
There are then two versions of the figures, the software’s and the workbook’s. The day they diverge, the question is no longer “where does this figure come from?” but “which one is right?”.
Five principles to guarantee lineage
- One single source. Statements are computed directly from entries, never from a copy.
- Posted entries that no longer move. A posted voucher is not edited: it is reversed. Otherwise, the figure justified yesterday may have changed today.
- Each statement line defined by its accounts, explicitly and stably, in line with the SYSCOHADA framework.
- Each total defined by a readable formula: you must see which lines make it up.
- Each entry linked to its voucher, viewable in one click.
The test to run on your own statements
Take your latest balance sheet and do these two exercises, stopwatch in hand.
Tracing back: pick three lines at random (for example inventory, customers, other expenses). For each, find the accounts that make it up, then three entries, then the matching vouchers.
Tracing forward: pick three vouchers (a purchase invoice, a customer payment, a miscellaneous entry). For each, find the accounts moved, then the balance sheet or income statement line where they land.
If the exercise takes more than a few minutes per line, or requires reopening a workbook, your lineage has breaks. That is exactly where the auditor will spend their time.
How we organise it at SynkriaOps
In SynkriaOps, financial statements are computed directly from posted entries: there is no intermediate workbook. Clicking a line of the balance sheet, income statement, cash flow statement or a note opens a three-tab detail panel: the accounts that make it up, their entries, and the formula when the line is a total. From there, an entry opens the source voucher, and View in the General Ledger opens the ledger filtered on the account.
The other way, clicking an account number in the ledger or trial balance opens its profile (balance, SYSCOHADA definition, normal direction) with links to the trial balance and ledger. Posted vouchers are sealed by a chained fingerprint: they are no longer edited, they are reversed.
The step-by-step guides are in the help centre:
- Trace a financial statement back to the voucher;
- Viewing the general ledger: views, filters, matching and export;
- Post and reverse a voucher.
Also read: Financial statements and tax package under revised SYSCOHADA and Third-party circularisation.