Synthetic IIF example
!TRNS DATE NAME ACCNT AMOUNT TRNS 01/15/2026 Office supplies Checking -45.00 ENDTRNS TRNS 01/16/2026 Client payment Checking 1200.00 ENDTRNS
IIF EXCELIIF
IIF
to Excel.
Read IIF bank transaction fields into Excel with typed dates and amounts. Review the preview before downloading.
FinanceConvert reads TRNS groups and their SPL details from tab-delimited IIF exports. Each TRNS becomes one transaction; split information is summarized in Memo. This is a transaction extract, not a lossless migration of a company ledger.
How your file is handledYOUR CONVERSION WORKSPACELocal first
PDF · OFX · QFX · QBO · QIF · IIF · CSV
Documents and conversion results are stored privately for 90 days to investigate errors and improve conversion quality. Temporary downloads expire after 15 minutes or first use. Storage and deletion details.
Inspect an IIF transaction extract in Excel
The worksheet lets you filter transaction dates and review amounts. Split details remain text in Memo rather than separate journal rows. Do not use this spreadsheet as a lossless company-file backup.
Content checked against the implemented converter on . Scope and editorial method.
Understand IIF source files · Understand Excel output files · How to assess conversion quality
A CONCRETE EXAMPLEWhat goes in.
What goes in.
What comes out.
These are synthetic examples, not customer data. Output excerpts illustrate the transaction mapping; download a sample through the converter to try the full workflow.
Illustrative Excel excerpt
Transactions worksheet Date Description Debit Credit Balance 2026-01-15 Office supplies 45.00 955.00 2026-01-16 Client payment 1200.00 2155.00
FIELD MAPPINGThe same transactions.
The same transactions.
A different format.
| Source field | Output | Handling |
|---|---|---|
| TRNS DATE | Date cell | Source dates are validated. Choose a convention when the file is ambiguous. |
| TRNS NAME / ACCNT and SPL summary | Description / Memo text cells | Supported text is mapped; this does not reconstruct the original accounting structure. |
| TRNS AMOUNT | Debit, Credit and Amount numeric cells | Debit/credit direction is retained; amounts are not reconciled automatically. |
| No running balance in the transaction-group mapping | Balance numeric cell and validation report | Missing balances stay missing. A balance check does not prove every transaction was extracted. |
THREE STEPS
Prepare. Convert. Review.
Check the source
Upload an unlocked IIF file up to 10 MB. Choose a date order if it cannot be established from the file.This path reads transaction fields directly; no document-reading AI is needed.
Read the preview
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 & validate
Download the Excel output, then inspect its mapping in your destination application. The temporary download expires after first use or 15 minutes. A separate encrypted review copy is retained for 90 days.
Questions about this conversion
When should I choose another format instead of Excel?
Choose CSV when your destination requires a text import. Excel is useful for inspection, but a workbook is not a company backup or proof that PDF extraction is complete.
What should I check before using this export?
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.
Are my source and result deleted after download?
No. Temporary download links expire after first use or 15 minutes. A private encrypted source/result copy, including failed attempts, is retained for 90 days to investigate errors and evaluate conversion improvements. The upload notice explains storage, and the document receipt lets you request deletion.
OTHER WORKFLOWS
All converters