Synthetic CSV example
Date,Description,Amount,Balance,Currency 2026-01-15,Office supplies,-45.00,955.00,USD 2026-01-16,Client payment,1200.00,2155.00,USD
Read CSV bank transaction fields into QBO with account metadata for an import check. Review the preview before downloading.
CSV files need a header row with a recognized Date and Description column, plus either signed Amount or Debit/Credit. Comma, semicolon and tab separators are detected. ISO dates avoid ambiguity. Malformed quoting, missing dates and invalid amounts are rejected without dropping rows.
Bank exports convert free · no page limit · no account
Files are deleted within 24 hours unless you ask us to keep a failed one. Privacy
The same converter as above, run with its built-in sample file: upload, check the preview, download.
Unlike a spreadsheet, QBO identifies one bank account and currency. Separate combined CSVs by account first and supply the actual bank and institution identifiers. Repeated FITIDs are rejected to avoid importer deduplication.
Content checked against the implemented converter on . Scope and editorial method.
Understand CSV source files · Understand QBO output files · How to assess conversion quality
These are synthetic examples, not customer data. Output excerpts illustrate the transaction mapping; download a sample through the converter to try the full workflow.
Date,Description,Amount,Balance,Currency 2026-01-15,Office supplies,-45.00,955.00,USD 2026-01-16,Client payment,1200.00,2155.00,USD
<STMTTRN> <DTPOSTED>20260115000000 <TRNAMT>-45.00 <NAME>Office supplies </STMTTRN>
| Source field | Output | Handling |
|---|---|---|
| Date column | DTPOSTED | Source dates are validated. Choose a convention when the file is ambiguous. |
| Description / Memo columns | NAME / MEMO | Supported text is mapped; this does not reconstruct the original accounting structure. |
| Amount or Debit / Credit columns | Signed TRNAMT | Debit/credit direction is retained; amounts are not reconciled automatically. |
| Balance column, when present | LEDGERBAL only if a final balance is unambiguous; checks in report | Missing balances stay missing. A balance check does not prove every transaction was extracted. |
Upload a CSV file up to 10 MB. Choose a date order if it cannot be established from the file. Bank exports are read field by field and downloaded free.
Compare the transaction count, date range and totals with your source. Check running-balance warnings. A clean balance check does not prove every row was extracted.
Download the QBO output, then inspect its mapping in your destination application. The temporary download expires after first use or 15 minutes. Files are deleted within 24 hours unless you ask us to keep a failed one.
Use the bank's original QBO when possible. If the importer rejects institution metadata, a supported CSV mapping may be preferable to changing bank identifiers. This is not a company-file migration.
Compare row count, first and last dates, debit/credit direction and totals with the source. Review any balance warnings. Test the destination mapping with a copy or test account; a successful export does not prove importer compatibility.
Not for long. Temporary download links expire after first use or 15 minutes, and the private encrypted copy is deleted within 24 hours. If a conversion fails, you can choose to send the file to our team; we then keep it for 30 days to fix the reader. You can delete your file sooner from the converter.