Spreadsheet Troubleshooting & Guides
Practical guides and working formulas for resolving common Excel and CSV formatting issues with bank statement data.
How to Preserve Leading Zeros in Bank Statement Numbers in Excel
Stop Excel from dropping leading zeros in bank check numbers, UK sort codes, and routing codes. Includes working formulas, Text Import steps, and recovery limitations.
Read guide →
How to Fix Bank Statement Date Formats in Excel (DD/MM vs MM/DD)
Resolve Excel date confusion in international bank statements. Covers UK/AU DD/MM/YYYY, US MM/DD/YYYY, Canadian date variations, and silent date flipping fixes.
Read guide →
Why Bank Statement Amounts Sum to Zero in Excel (And How to Fix It)
Fix bank statement numbers stored as text in Excel where =SUM() returns 0. Covers non-breaking spaces (CHAR(160)), trailing minus signs, CLEAN limitations, and 4 working fixes.
Read guide →
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.
Read guide →