Synthetic QIF example
!Type:Bank D01/15/2026 T-45.00 POffice supplies ^ D01/16/2026 T1200.00 PClient payment ^
Read QIF bank transaction fields into CSV with debit, credit and identifier columns. Review the preview before downloading.
QIF is a text transaction format with date, signed amount, payee and optional memo/category lines. Date order is inferred from the whole file when possible. If all dates are ambiguous, choose a date order. Split/category details are retained as memo text, not reconstructed as accounting entries.
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.
QIF lacks a universal date convention. Select day/month/year or month/day/year when the whole file remains ambiguous. Bank, cash and credit-card transaction lists are supported; investment and account-list files are refused.
Content checked against the implemented converter on . Scope and editorial method.
Understand QIF source files · Understand CSV 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.
!Type:Bank D01/15/2026 T-45.00 POffice supplies ^ D01/16/2026 T1200.00 PClient payment ^
Date,Description,Memo,Debit,Credit,Balance,Amount,Currency,FITID,AccountID,BankID,AccountType 2026-01-15,Office supplies,,45.00,,955.00,-45.00,USD,,,, 2026-01-16,Client payment,,,1200.00,2155.00,1200.00,USD,,,,
| Source field | Output | Handling |
|---|---|---|
| D date | Date (YYYY-MM-DD) | Source dates are validated. Choose a convention when the file is ambiguous. |
| P payee / M memo | Description / Memo | Supported text is mapped; this does not reconstruct the original accounting structure. |
| T signed amount | Debit, Credit and signed Amount | Debit/credit direction is retained; amounts are not reconciled automatically. |
| No bank running-balance field in this reader | Balance column and validation report | Missing balances stay missing. A balance check does not prove every transaction was extracted. |
Upload a QIF 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 CSV 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.
Choose Excel when typed date and amount cells make review easier. Choose an account import format only when the destination explicitly supports it; CSV column mapping is often more flexible.
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.