Trial balance import balance sheet does not balance
This page targets searches such as “trial balance import balance sheet does not balance,” “TB CSV balance sheet not balance,” and “imported trial balance mismatch.” The first review should focus on signs, account mapping, retained earnings, and the opening cash tie.
Why does my balance sheet not balance after trial balance import?
- Debit and credit columns may have been imported with the wrong sign convention.
- Some source account names may be unmapped or mapped to the wrong PL/BS category.
- Retained earnings or current-year profit may be duplicated or missing.
- Cash, AR, AP, debt, tax payable, and equity accounts may be directionally reversed.
What should I check first?
Review unmapped rows, total debits and credits, opening BS totals, and the Checks tab before adding forecast transactions. If the opening position is wrong, later periods will inherit the mismatch.
How Statement Engine fits
Use the web forecast for free to review the imported opening position. Export Excel only after the imported TB and Checks tab look reasonable.