Before importing a CSV prepared in a spreadsheet, verify that the exported values preserve the bank’s exact cents. A sheet may display rounded amounts even when its underlying cells contain more detail, or a conversion may replace values with rounded text.
- Compare several exported amounts with the original bank file, including small charges, credits and large amounts.
- Inspect the actual CSV text or import Preview rather than relying only on the spreadsheet’s visual formatting.
- Check the total money in and money out after the file is read.
Do not repair a rounding difference with a balancing transaction. Find and correct the source conversion so each movement retains its supported amount.
Check formulas and derived columns
If the sheet calculates amounts, confirm that the chosen column represents the posted bank movement. Rates, converted estimates and running balances should not be mapped as transaction amounts.
Keep the original bank export and the working file separately. If totals disagree, inspect the first place they diverge before committing. Passing the number parser confirms a supported format, while comparison with source evidence establishes whether the value is faithful.
Was this article helpful?
Tell us whether this answered the question you came with.