From statement to journal entry,every step checked
One workbook per bank account: transactions in date order, an account column per ledger account, a running balance, and a journal entry that balances.
One workbook per bank account: transactions in date order, an account column per ledger account, a running balance, and a journal entry that balances.
| 5000 | 6020 | 6040 | 9999 | |||||
|---|---|---|---|---|---|---|---|---|
| Date | Description | Amount | Account | Payroll | Rent | Software | Suspense | Bank balance |
| 01/01/2026 | Beginning balance | 12,500.00 | ||||||
| 01/05/2026 | ACH payroll disbursement | (4,250.00) | 5000 | (4,250.00) | - | - | - | 8,250.00 |
| 01/06/2026 | Office rent, Elm St | (2,200.00) | 6020 | - | (2,200.00) | - | - | 6,050.00 |
| 01/09/2026 | Zoom subscription | (49.00) | 6040 | - | - | (49.00) | - | 6,001.00 |
| 01/12/2026 | Client payment, Alder Co | 3,800.00 | 9999 | - | - | - | 3,800.00 | 9,801.00 |
| Totals | (4,250.00) | (2,200.00) | (49.00) | 3,800.00 | 9,801.00 |
The same workbook, with the accounting handled the way that statement actually works.
Cash you hold. Deposits raise it, withdrawals lower it.
Opening and closing balance, and each month hands off to the next.
Cash at bank
Money you owe. Charges raise it, payments lower it.
Previous balance plus activity equals new balance, and each month connects to the next.
Credit card payable
Trades, dividends, interest, fees and transfers.
Positions and cash tie to the statement totals.
Investment, income, fees and realized gains
Four layers, in order. Each one only handles what the one before couldn't.
Exact and near-exact descriptions match the prior-year workbook. Filled in, no highlight.
“ZOOM.US 888” finds “Zoom Video”. High confidence fills in; medium fills in and highlights.
Optional. Picks from your account list using general accounting knowledge.
Anything still unknown goes to 9999, highlighted, with the reason shown.
Column totals become debits and credits. The difference is the change in the statement balance, posted to Cash at bank. Statements are checked for opening and closing balance and for continuity from month to month before anything is built.
| Account | Debit | Credit |
|---|---|---|
| 5000 Payroll expense | 4,250.00 | |
| 6020 Office rent | 2,200.00 | |
| 6040 Software subscriptions | 49.00 | |
| 9999 Suspense review before posting | 3,800.00 | |
| 1000 Cash at bank | 2,699.00 | |
| Total Balanced | 6,499.00 | 6,499.00 |
After a run, open the review page. Each yellow row shows why it was flagged. Choose the account, apply it to every row with the same description, save, and download the updated workbook. Reviewed rows lose their highlight.
Try the review page| Description | Account | Status |
|---|---|---|
| Staples #2291 | 6030 Office supplies | Ready |
| Client payment, Alder Co | Choose an account | Needs review |
| E-transfer J. Moreau | Choose an account | Needs review |
Its accounts become the columns and its classifications guide this year's.
Upload .xlsx or .csv. Every account becomes a column, even unused ones.
Get clean, reconciled transactions with no classification, ready to code yourself.
Upload one PDF. See the workbook, the flags, and the journal entry in about a minute.
+ Convert a statementNo credit card. Files are deleted from our server after 30 minutes.