Guides

Catch-up bookkeeping: a year of bank statements into one spreadsheet

A fast, checkable workflow for turning 12 months of Singapore bank statement PDFs into one reconciled ledger for year-end or a late tax filing.

Year-end, a new accountant, or a late filing: suddenly you need twelve months of transactions in one place. Here's a workflow that takes an hour instead of a weekend, and that you can check.

1. Collect the PDFs

Download every monthly eStatement for the period (see the bank guides for UOB, DBS/POSB, OCBC, Maybank). Name them by month so they sort: 2025-01.pdf, 2025-02.pdf.

2. Convert them in one batch

On StatementSheet, with a pack key, drop all twelve at once. You get a zip with one file per month, each with identical columns and a Check column. Choose Excel if you'll review in a spreadsheet, or the Xero or QuickBooks format if you're importing straight in.

3. Chain the balances

This is the check that catches missing months: each month's opening balance (on its Statement sheet) must equal the previous month's closing balance. If one doesn't, a statement is missing or a month was converted twice.

4. Stack into one sheet

In Excel, paste the Transactions sheets one under another. Because the columns are the same, a single table results. Sort by date, then add a column for category if your accountant wants one.

5. Spot-check flagged rows

Any row marked other than reconciled in the Check column is a row to compare against the PDF. On clean bank PDFs there are usually none.

Twelve statements is twelve credits, S$9 for a pack of ten plus the free one each month, so a year of catch-up costs under S$12.