What is a shadow ledger?
A shadow ledger is a parallel record of accounting data kept alongside the official general ledger, usually in another system or spreadsheet. Finance teams use one when the main ERP cannot easily handle a task, such as consolidating many entities, reconciling intercompany balances, applying different accounting rules or producing management views, without replacing the ERP itself.
Also calledparallel ledgersecondary ledgersidecar ledger
Compare the softwareBest financial consolidation software →All 14 ERP and general ledger vendors →
- Sits beside
- The official general ledger
- Used for
- Consolidation, intercompany, reporting
- Key control
- Reconcile to the ERP
How a shadow ledger works
Data is copied from one or more ERPs into the shadow ledger, often daily, and enriched with mappings, eliminations or adjustments. The team then runs processes there that would be slow or impossible in the ERP, such as group consolidation across different systems, intercompany matching, or reporting under a second accounting framework. Historically, shadow ledgers were spreadsheets that drifted from the official books, which made them a control risk. Modern versions are software platforms that sync continuously with the ERP, post agreed adjustments back to it, and keep an audit trail, so they act as an automation layer rather than an unofficial second set of books. The key control is reconciling the shadow ledger to the official ledger at every period end. Nominal builds a shadow general ledger beside the ERP for consolidation, intercompany and close.
Common questions
Is a shadow ledger the same as keeping two sets of books?+
No. A shadow ledger is a working copy used for processing and reporting, reconciled to the official ledger. Two sets of books implies conflicting records, which is a serious control failure.
Why not do everything in the ERP?+
Some tasks, such as consolidating entities on different ERPs or complex intercompany matching, are slow or impractical in many ERPs, and replacing the ERP is costly and disruptive.
What are the risks of a shadow ledger?+
Drifting out of line with the official books, adjustments made in one place but not the other, and weak access controls. Regular reconciliation and an audit trail address them.
Shadow ledger software
Part of Accountio’s accounting technology coverage · Glossary
