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.

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.