Trial balance debit and credit reversed in forecast
This page targets searches such as “trial balance debit credit reversed forecast,” “TB debit credit sign mistake,” and “imported trial balance sign error.” A reversed TB sign convention can make cash, debt, equity, or retained earnings look wrong.
How do I know debit and credit were reversed?
- Cash or accounts receivable imports as a negative balance.
- Debt, accounts payable, or equity imports as a positive asset-like balance.
- Opening BS totals do not balance even though the accounting system TB was balanced.
- Retained earnings or current income looks like the plug needed to force balance.
What to check before re-importing
- Whether the CSV uses separate debit and credit columns or one signed balance column.
- Whether assets are positive and liabilities/equity are negative, or the opposite convention.
- Whether the import template expects account code, account name, debit, credit, or balance.
- Whether the Checks output flags the opening balance sheet before any forecast transactions.
How Statement Engine fits
Use the free web forecast and TB CSV template to review sign convention before exporting Excel. If signs are wrong, fix the source CSV rather than correcting every forecast line manually.