Convert a bank CSV to an IIF file
Use LedgerConverzn when a bank export gives you transaction rows in a spreadsheet and you need a private, reviewable path to an IIF file.
Start with the bank export, not the balance
Most bank CSV files contain more columns than the converter needs. LedgerConverzn focuses on the transaction date, the description or memo, and the value of each row. A running balance can remain in the source file for your own reference, but it is not used to create the basic IIF entries.
Useful bank CSV structures
One signed amount
Some exports place withdrawals below zero and deposits above zero in one Amount or Transaction column. Choose that column in the standard workflow.
Separate debit and credit
Other exports place money out in Debit or Withdrawal and money in in Credit or Deposit. LedgerConverzn Plus can map those two fields and calculate the signed value for each row.
How to prepare the file
- Export the transactions as CSV and keep the header row.
- Check whether the date is recognizable and whether the file uses a comma delimiter.
- Decide whether the amount is signed or split into debit and credit.
- Open the working LedgerConverzn converter, map the columns, and analyze the preview.
Bank transaction example
A split export could look like Date,Description,Debit,Credit, followed by 07/05/2026,Office supply,42.18, and 07/06/2026,Customer payment,,480.00. An empty debit or credit cell is expected when the row represents only one side of the transaction.
What to review before export
Check the date format, sign direction, descriptions, destination bank account name, and the expense or income account names. The preview shows which rows are ready and which need review; it does not compare the result against your bank's balance.
Limitations and compatibility
Bank exports are not standardized. Semicolon-delimited files, unusual date formats, multi-line descriptions, transfers, and bank-specific transaction types may need cleanup before conversion. LedgerConverzn is independent and is not affiliated with, sponsored by, or endorsed by Intuit Inc.; Intuit and QuickBooks are registered trademarks of Intuit Inc.
Bank CSV to IIF FAQ
Do I need to include the balance column?
No. Keep it if you want it for comparison, but map the transaction amount fields instead.
What if my bank uses withdrawals and deposits?
Use LedgerConverzn Plus to select separate debit and credit columns. The standard flow expects a single signed amount column.
Where are the product limits documented?
The LedgerConverzn conversion guide explains supported structures and limitations. You can also review privacy, security, account access, and pricing.
CSV to IIF converterDebit and credit workflowSpreadsheet to IIF