How to import a trial balance CSV for 3-statement forecasting
This article focuses on the common question “Can I import a trial balance CSV?” and what to do if import mapping does not match accounts as expected.
Supported CSV columns
Typical supported patterns:
account_code,account_name,balanceaccount_name,balance(code optional)debit,creditwith derived balance rules- Common Japanese headers such as
科目名,残高
A balance on assets is usually positive, while liabilities and equity may be negative. Keep one sign convention for the whole file to avoid reversals in import mapping.
How to import
- Prepare a CSV in one of the supported formats.
- Download the template from the app and compare your columns.
- Upload and run the model.
- Review mapped/unmapped rows and corrected codes in the result panel.
Import troubleshooting
- Blank code lines: map by name if code is missing.
- Unknown account names: check aliases and full-width / half-width differences.
- Negative signs: confirm whether your file uses sign-reversal for liabilities.
How long can the forecast be run?
You can set monthly or annual periods. Longer horizons and multiple repeats are supported as long as the data structure remains valid.