Convert HSBC statement to Excel — accurate & reconciled

How HSBC statements are structured

HSBC statements are conservative in the best way: an account summary with opening and closing balances up front, then activity in labeled sections with dates, descriptions, and a single amount column per section, so a row's direction comes from where it sits. US retail statements print in dollars and follow the same summary-plus-sections shape as other large banks, while descriptions for international wires can run long and wrap onto a second line. HSBC also repeats the masked account number and statement period in a page header on every page; those repeated headers are detected and discarded so page breaks never become phantom rows. Our engine assigns debits and credits from the section a row falls in, merges wrapped wire descriptions, and keeps check numbers in the description when they print. Reconciliation then runs the full math: opening balance plus every extracted transaction must equal the closing balance printed in the summary. If the figures do not tie, the results page shows the exact difference rather than passing the file through quietly. HSBC savings and business statements follow the same overall structure and convert the same way.