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-B5

Find 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.