TxnProof conversion guide
How to map bank CSV columns for QuickBooks
Bank CSV files use different headers and sign conventions. A reusable recipe is useful only after each mapped column has been checked against representative rows.
Identify a single amount model
Some exports use one signed Amount column; others split Debit and Credit. Do not map both models at once unless the source format explicitly requires it.
Verify the date pattern
Distinguish month/day/year from day/month/year using a date whose day is greater than twelve. Preserve the original value in the receipt for later audit.
Separate payee from memo
Map the stable merchant or counterparty field to payee and the longer transaction detail to memo. Avoid using a volatile reference string as the only payee identity.
Save the recipe with evidence
Name the recipe after the bank and export type, then retain a source hash and row count. Recheck the mapping whenever the bank changes its CSV layout.