SNAPCOMMIT

Bank CSV and financial table cleanup guides

Small fixes for bank exports and copied financial tables. Each guide includes concrete examples and the limits to check.

Xero bank CSV import errors: dates, mapping and file limits

Check Xero’s native import settings first, compare ambiguous CSV dates with a worked example, and see when local preparation helps.

QuickBooks Australia bank feed stopped? Check the CSV fallback

Start with Intuit’s Open Banking migration guidance, then check CSV date ranges, import limits and duplicate overlap before a manual upload.

Prepare a bank CSV for import: dates, signs and duplicates

A worked bank CSV example for bookkeepers: map columns, check decimal commas and amount signs, review possible duplicates, and reuse next month’s setup.

Clean pasted tables for Excel

A practical workflow for fixing currency symbols, bracketed negatives and repeated headers in copied financial tables.

US and European number formats in copied tables

Understand decimal commas, grouping separators and ambiguous numbers before copying a financial table into Excel.

Keep leading zeros and long IDs when pasting into Excel

Protect account codes, product IDs and other identifiers during table cleanup and spreadsheet import.