Built by Pyalm
Pyalm Books connects bank accounts, records and matches transactions and reconciles them against the ledger — so reconciliation is part of the month's routine, not a spreadsheet project. Free while in beta.
Load your bank statement and the cash book for the same account. The tool pairs lines that agree on amount and date, then shows what is only on the bank statement and what is only in your books.
Money in is positive, money out negative — map either a signed amount column, or separate in/out columns.
The same bank account as recorded in your books. In a ledger, a debit is money in.
Pyalm Books connects bank accounts, records and matches transactions and reconciles them against the ledger — so reconciliation is part of the month's routine, not a spreadsheet project. Free while in beta.
A bank reconciliation proves that the cash balance in your books agrees with the bank, apart from known timing differences. Items on the bank statement but not in the books are usually charges, interest or receipts you have not recorded. Items in the books but not at the bank are typically uncleared cheques or deposits in transit.
Each bank line is matched to at most one ledger line with exactly the same amount, preferring the closest date within the tolerance you choose, and breaking ties by similar descriptions. Map either a signed amount column or separate money-in and money-out columns for each side. Batched deposits and split payments will not pair automatically — they show up in the unmatched lists for you to resolve.
📖 Read the full guide: Bank Reconciliation Step by Step, With Examples
Upload a bank CSV, map the columns, and download a clean Excel-ready file — nothing uploaded.
Spot repeated payments and invoices by amount, date, vendor and reference.
Check that debits equal credits and get hints on why a trial balance is out of balance.
A date, a description and either a signed amount or separate in/out columns. Headers are detected automatically and you can change the mapping.
The ledger side labels its columns accordingly: 'Money in (debit)' and 'Money out (credit)'. Pick the right columns and the signs are aligned for you.
Files are parsed in your browser and never uploaded. Close the tab and nothing remains.
Not automatically. For batches, compare the unmatched totals or reconcile in accounting software that supports multi-line matching.
