Skip to content
Moxisync

Check a converted bank statement

A converted statement is correct when every row adds up to the balance the bank printed. Here is how to check it, and how this tool does it for you.

Runs on your device

Works offline

Drop a bank statement PDF

Drop it here, paste with Ctrl+V, or

Your statement never leaves this device. It is read by your browser, not uploaded. The converter loads when you use it, then works offline.

Try a sampleFictional banks and made-up transactions, generated for testing.

The one check that matters: the running balance

Every bank statement carries its own answer key. The balance column says what the account held after each transaction. So a conversion is right when, for every row:

previous balance + money in − money out = balance on this row

and, at the end, the last balance equals the closing balance on page one. If that holds for every row, no amount was misread, no transaction was dropped and none was counted twice. The converter above runs this check on every row as soon as the statement is read, and again every time you edit a cell.

Doing it yourself in Excel

  1. Put the opening balance in a cell, say H1.
  2. In H2, next to the first transaction, enter =H1+D2-C2 (money in in column D, money out in column C).
  3. Fill it down. In I2 enter =ROUND(H2-F2,2) where F is the printed balance, and fill that down too.
  4. Any row where column I is not 0.00 is where to look.

On statements that print the balance once a day, only compare rows that have a balance; the rows between are checked by the next one.

What usually causes a break

  • A misread amount. The difference equals the error, for example 9.00 when 18.50 was read as 9.50.
  • A missing row. The difference equals one transaction you can find on the PDF but not in the sheet.
  • A duplicated row. The difference equals a transaction that appears twice.
  • Money in and out swapped. The difference is twice the amount.

Try the One wrong balance sample above to see a break: it is a statement from a fictional bank with one balance off by 10.00. Exactly one row turns red, with the difference shown.

Questions people ask

What does “does not reconcile” mean?

Starting from the balance on the row above, adding this row’s money in and taking away its money out does not give the balance printed on this row. Either an amount was read wrongly, a row is missing or duplicated, or the bank printed the balance at a different point.

One wrong number: will every row after it turn red?

No. After a break, the check carries on from the balance printed on the statement and also tries the balance it worked out. Whichever the next printed balance agrees with is used, so a single misread number flags a single row.

Why is the first row “not checked”?

If the statement prints no opening balance, the first row’s balance is used to work it out, so that row cannot be checked on its own. Every row after it is.

What if my statement has no running balance?

Then the check uses the totals: opening balance plus all money in minus all money out must equal the closing balance printed on the statement. It confirms nothing is missing overall but cannot point to a single row.

All business tools