TxnProof conversion guide

How to convert bank CSV to QBO on Mac without uploading

A safe conversion keeps the original bank export, makes every mapping decision visible and treats QuickBooks as the final import test. Conversion is not reconciliation.

1. Preserve the original CSV

Keep an untouched copy of the bank export and record its statement period. Work from a duplicate so every transformed row can be traced back to the source.

2. Map columns deliberately

Select the date, amount or debit and credit, payee and memo columns. Confirm the bank's date format and sign convention using both a deposit and a withdrawal.

3. Review normalized transactions

Inspect the row count, dates, payees, signs and net movement. Resolve missing payees and duplicate candidates before generating the accounting file.

4. Test the QBO import

Import into the intended QuickBooks edition and account, verify the first and last transaction and compare totals against the source statement before relying on the result.