Trial balance CSV format for forecast import
Trial balance import works best when the CSV separates account code, account name, and balance clearly. This page is for searches like “trial balance CSV format” and “TB CSV format for forecast import.”
What CSV format should I use for trial balance import?
- account_code: chart of accounts code, if available
- account_name: account name used in the trial balance
- debit and credit, or a single signed balance column
- period or closing date, when multiple periods are exported
Sign and balance review
Before import, confirm whether liabilities and equity are stored as credits or negative balances. A clean trial balance CSV should tie before it becomes an opening balance sheet forecast input.
Mapping review after import
Review each account mapping to PL, BS, or cash flow behavior. Account code and account name mapping is often the difference between a usable forecast and a model with unexplained retained earnings or cash movement.