From PDF bank statement to Excel: reconcile the closing balance
A statement can look right in Excel even when one debit is missing. Keep the original PDF open and use its printed closing balance as an independent check.
Check the reporting period
In the PDF, find the account, currency, dates and opening balance. In PDF Tables to Excel, review the transaction columns before exporting to XLSX. At each page break, compare the last transaction on one page and the first on the next. A carried-forward balance belongs outside the list of transactions.
Recalculate the closing balance
Suppose the account opens at 1,250.00. A payment of 375.00 comes in, a purchase costs 89.50 and the bank charges a 12.00 fee. Enter the opening balance in B2, the credit in B3 and the two debits as positive amounts in B4 and B5.
=B2+B3-B4-B5Find the discrepancy
The result should be 1,523.50. If the sheet shows 1,535.50, the difference is exactly the fee. Check that row against the PDF. When the statement already uses negative amounts for debits, add the signed transactions to the opening balance to avoid subtracting the same debit twice.