PDFtoRow
PDF to Excel & CSV
FeaturesBanksGuidesFormatsPricingSecurityFAQ
Sign InConvert Statement
All guides & articles
Spreadsheet Troubleshooting
9 min read
Updated 2026-10-15

How to Check a Converted Bank Statement Against Its Totals in Excel

Check that the rows in a converted bank or credit card statement add up to its printed balances: formulas for totals, a running-balance check, duplicate flags, and what a difference tells you.

What this check proves, and what it does not

When you convert a statement PDF into a spreadsheet, the first question is whether every transaction made it across correctly. The quickest test is arithmetic: the rows should add up to the totals and balances printed on the same statement.

This is not a bank reconciliation. A bank reconciliation compares the bank statement with your own records (your cash book or accounting software) and explains differences such as outstanding checks and deposits in transit. The check in this guide compares the converted file with the statement it came from. It is a useful first step before a reconciliation, not a replacement for one.

Matching totals is strong evidence that no row is missing, duplicated or has the wrong amount, but it does not prove everything is right. A wrong date or description does not change any total, and two errors can cancel out. Spot-check rows against the PDF as well.

Step 1: Copy the printed figures from the statement

Before writing any formula, note the figures the statement itself prints, usually in a summary box on the first page:

• Deposit (checking, current or savings) account: opening or beginning balance, total deposits or credits, total withdrawals or debits, and closing or ending balance.

• Credit card: previous balance, payments and credits, purchases, fees, interest, and new balance.

Use the printed figures rather than ones you calculate, because the point is to test the converted rows against an independent number. If your statement prints no totals, the opening and closing balance alone are enough for the main check.

Then look at the converted rows and exclude anything that is not a transaction from your sums: the opening and closing balance lines and any "balance brought forward" or "carried forward" lines repeated at page breaks. Adding those to a total counts the same money twice.

Step 2: Total the rows and compare (worked example)

The example below is synthetic: it was made up for this guide and is not a real customer statement. It uses separate Debit and Credit columns with the transactions in rows 2 to 7: Date in A, Description in B, Debit in C, Credit in D and Balance in E. The printed figures from the statement summary are typed into H2 to H5.

Row Date Description Debit Credit Balance 2 03/02/2026 Salary 2,400.00 3,650.00 3 03/05/2026 Rent 1,100.00 2,550.00 4 03/09/2026 Grocery store 86.45 2,463.55 5 03/15/2026 Transfer from savings 150.00 2,613.55 6 03/21/2026 Electricity bill 94.20 2,519.35 7 03/28/2026 Monthly account fee 5.00 2,514.35 Printed on the statement: H2 opening 1,250.00 H3 total credits 2,550.00 H4 total debits 1,285.65 H5 closing 2,514.35

Now add these formulas. Each result is shown after the arrow:

• Total credits: =SUM(D2:D7) → 2,550.00. It should equal H3.

• Total debits: =SUM(C2:C7) → 1,285.65. It should equal H4.

• Calculated closing balance: =H2+SUM(D2:D7)-SUM(C2:C7) → 2,514.35.

• Difference from the printed closing balance:

=ROUND(H5-(H2+SUM(D2:D7)-SUM(C2:C7)), 2)

A result of 0 means the rows add up: 1,250.00 + 2,550.00 − 1,285.65 = 2,514.35. If your spreadsheet has one signed Amount column instead (deposits positive, withdrawals negative), the calculated closing balance is simply =H2+SUM(Amount column).

If SUM returns 0 or a figure that is far too small, some amounts are probably stored as text, which SUM ignores. Fix those first using the steps in our guide to converting statement amounts from text to numbers.

Step 3: Find the row where the balance breaks

If the statement prints a running balance after each transaction, you can test every row, not just the total. In F2, compare the first row with the opening balance:

=ROUND($H$2+D2-C2-E2, 2)

In F3, compare each row with the balance on the row above, then fill the formula down to the last transaction:

=ROUND(E2+D3-C3-E3, 2)

Every result should be 0. The first non-zero row is where a transaction is missing, duplicated or has the wrong amount or side. In the example above all six rows return 0. Statements that list transactions for several days and print a balance only once per day need the same idea applied to the last row of each day instead.

The running balance check only works on rows in the order the statement prints them, so do not sort the sheet before running it.

What the size of the difference tells you

A non-zero difference is usually a clue in itself. Using the example above, with the difference calculated as printed closing balance minus calculated closing balance:

• A missing debit shows up as a difference equal to minus that amount. Without the 86.45 grocery row the difference is −86.45, so search the PDF for 86.45.

• A duplicated debit shows up as plus that amount. If the 5.00 fee appears twice, the difference is 5.00.

• A transaction on the wrong side shows up as twice its amount. If the 150.00 transfer is read as a debit instead of a credit, the difference is 300.00.

• A difference of a cent or two across many rows usually means rounding or an amount with an extra decimal, not a missing transaction.

To flag possible duplicates without deleting anything, add a column with =SUMPRODUCT(($A$2:$A$7=A2)*($B$2:$B$7=B2)*($C$2:$C$7=C2)*($D$2:$D$7=D2))>1 and fill it down. TRUE marks rows that have an identical twin. This exact comparison is used instead of COUNTIFS because COUNTIFS treats an empty criteria cell (a blank Debit or Credit) as 0 and treats * and ? in descriptions as wildcards. Two genuine identical transactions on the same day do happen, so check the PDF before removing a row.

Credit card statements use a different formula

Do not reuse the deposit-account formula on a credit card. On a card statement, purchases, fees and interest increase the balance you owe, and payments and credits reduce it. The usual check is:

New balance = Previous balance − Payments and credits + Purchases + Fees + Interest

The U.S. Consumer Financial Protection Bureau's sample credit card statement shows how the figures fit together: previous balance $482.42, payments and credits $350.42, purchases $1,258.56, fees $0, interest $2.15, and new balance $1,392.71. Check it: 482.42 − 350.42 + 1,258.56 + 0 + 2.15 = 1,392.71.

Card issuers print the transaction amounts with different sign conventions. Some show payments as negative numbers, some print them as positive amounts in a separate section, and some add a CR marker. Look at how your statement shows a payment before writing the formula. If purchases are positive and payments negative in one Amount column, the check becomes =Previous balance + SUM(Amount column) − New balance, which should be 0.

Rounding: always compare with ROUND

Excel stores numbers as binary floating-point values with about 15 significant digits, so sums of amounts like 0.10 can differ from the exact result by a tiny fraction. A difference such as 0.0000000000001 is not a missing transaction. Wrapping the comparison in ROUND(…, 2), as in the formulas above, rounds to cents before comparing, so these tiny differences come out as 0.

Legitimate reasons the numbers do not match

• Pending transactions: pending items shown in online banking are not on the statement, so the statement will not match your current online balance. Compare with the statement only.

• Statement period boundaries: a statement lists transactions by the date they were posted to the account. A purchase made on the last day of the period may appear on the next statement, so filter by posting date when you cut a period yourself.

• Several accounts in one PDF: some banks combine checking, savings and card sections in one statement. Check each account's rows against that account's own opening and closing balance.

• Fees and interest: monthly fees, overdraft charges and interest are transactions too. If the statement prints them in a separate summary section, make sure they are in your rows before comparing totals.

• Part of a statement: if you converted only some pages, the closing balance on the last page you have will not match the full-period total.

Checking a file converted with PDFtoRow

PDFtoRow keeps the statement's own columns and rows, including the opening and closing balance rows where the statement prints them, and stores amounts and balances in the Excel file as real numbers, so the formulas above work without cleaning. Exclude those balance rows from your SUM ranges as described in Step 1.

The free preview shows the first 10 rows so you can check that the columns and signs look right before you pay. It does not check the rest of the file, so run the total and running balance checks above on the full download. If a statement cannot be read reliably, PDFtoRow shows an error instead of a partial file and you are not charged.

Convert Bank Statement PDFs Cleanly with PDFtoRow

Tired of fixing broken columns, corrupted dates, and numbers stored as text? PDFtoRow extracts transaction tables directly from digital PDF vector layers, preserving check numbers and outputting true numeric amounts. Statements up to 5 pages are free once per email every 24 hours. Check the 10-row preview before you download.

Convert PDF to Excel (.xlsx) →Convert PDF to CSV →

Frequently Asked Questions

It is the most important single check, because a missing, duplicated or wrong-sided amount changes it. It cannot catch a wrong date or description, or two errors that cancel out, so also run the row-by-row running balance check and spot-check a few rows against the PDF.

Floating-point arithmetic can leave a tiny remainder such as 0.0000000000001 that displays as 0.00. Compare with ROUND(…, 2) instead of testing the raw result.

No. This checks the converted file against the statement it came from. A bank reconciliation compares the statement with your own accounting records and explains items such as outstanding checks and deposits in transit.

Primary Evidence & Official References
Related Bank Statement Guides
Citi Statement Guide →TD Canada Trust Statement Guide →Scotiabank Statement Guide →Westpac Statement Guide →Chase Statement Guide →CommBank Statement Guide →