Example 1: one signed amount column

This layout uses negative values for money out and positive values for money in. Map Date to Date, Description to Description, and Single amount column to Amount. Leave Debit and Credit unused.

Date,Description,Amount,Reference
07/01/2026,Coffee Shop,-4.50,TX1001
07/02/2026,Client Payment,850.00,TX1002
07/03/2026,Monthly Fee,-12.00,TX1003

Example 2: separate debit and credit columns

This layout stores withdrawals under Debit and deposits under Credit. Leave Single amount column unused, then map Debit and Credit to their matching headings.

Posted,Details,Debit,Credit,Memo
25/07/2026,Office Supplies,62.10,,Receipt 184
26/07/2026,Customer Deposit,,1200.00,Invoice 220
27/07/2026,Bank Fee,10.00,,Monthly fee

Choose the date order

The first sample uses month/day/year because 07/25/2026 means July 25. The second uses day/month/year because 25/07/2026 cannot be month/day/year. When all days fall between 1 and 12, compare the export against the statement to resolve the ambiguity.

Create a safe test

You can copy a layout into a new plain-text file with a .csv extension to understand the mapping interface, but do not import fictional transactions into production books. For a real test, export two or three posted transactions from the intended bank account, convert them, and verify the preview before downloading.

Never paste actual financial records into an online example or support request. Bank2QBO processes selected files locally, so you can work with the original data without uploading it to our servers.

Common mistakes when creating a sample

A useful sample preserves the source layout without preserving sensitive values. Replace merchant names, references, memos, and amounts consistently, but keep representative signs, blanks, quoted commas, and date formats. Otherwise the sample may stop reproducing the mapping issue.

Never “anonymize” by deleting an entire problem column or changing every amount to a positive value. That can hide the exact condition you need to diagnose. Store and share samples only under your organization’s security policy; local conversion means no sample needs to be sent to Bank2QBO.

  • Use fictional names and identifiers.
  • Keep the same headers and column order.
  • Preserve whether cells are blank, quoted, positive, or negative.
  • Use only a few rows needed to reproduce the layout.
  • Review the sample as plain text before sharing it anywhere.
Important: Keep the original export, test a short date range, and review the receiving account before accepting imported transactions. Bank2QBO is not affiliated with Intuit or QuickBooks.