HomeBank import: CSV format, QIF and OFX files, step by step
HomeBank imports bank and card statements from OFX, QFX, QIF and CSV files through its import assistant. Its manual ranks them plainly: OFX or QFX is recommended, QIF is supported, and CSV is for advanced users only, because HomeBank reads its own CSV layout rather than your bank's. Here's which file to use, the import assistant step by step, HomeBank's CSV column format exactly as its manual documents it, how to get PDF statements in, and a free CSV test file with known totals.
Short answer: in HomeBank choose File → Import... (or drop the file onto the main window), add the file, pick the target account, check the transactions and confirm. Use OFX or QFX if your bank offers it; HomeBank's manual calls CSV "Advanced users only" because the "format is specific to HomeBank". A HomeBank CSV has eight semicolon-separated columns: date, payment, number, payee, memo, amount, category, tags. Free test files: a checking CSV in HomeBank's layout (31 fictional transactions), and the same statement as OFX and QIF.
See the statement behind the test files
Open Utilly's fictional September 2026 checking statement: every line, the balance check from 12,418.36 to 13,440.52, and the CSV, QIF and OFX downloads. Free, because the data is made up. The checking test files on this page hold those same 31 lines, so you know exactly what an import should bring in.
1. The test files
These files hold Utilly's fictional September 2026 checking and credit card statements in formats HomeBank imports, so you can try an import into a new test account and compare the result with known totals before you touch real data. No sign-up.
| File | What's in it | Known totals |
|---|---|---|
| Checking CSV | The 31 lines of the fictional checking statement in HomeBank's eight-column transaction layout, no header row | 20 payments 28,575.27; 11 deposits 29,597.43; net +1,022.16 |
| Checking OFX / QIF | The same 31 lines as Utilly's converter writes them from the PDF statement | As the checking CSV |
| Credit card OFX / QIF | The 21 lines of the matching fictional card statement | 19 charges 1,939.94; 2 credits 1,542.18; 397.76 more owed |
The rows come from Utilly's fictional sample statements (explained on sample bank statement PDF), read by the same engine Utilly's converters use. Each CSV line follows the column order in HomeBank's manual: the date month first with slashes (09/01/2026, HomeBank's m-d-y order with a 4-digit year), payment 0 (none), empty number and payee, the bank's text in the memo column (as in the manual's own example), the amount as one signed number with a period decimal (negative = money out), and empty category and tags columns. Semicolons, commas and quote marks are taken out of the descriptions. There's no header row: the manual's example doesn't have one, and it doesn't say the importer skips one. The card statement comes as OFX and QIF only, since the manual doesn't say which sign a card account's CSV amounts should use. The checking CSV is plain ASCII text with Unix line endings, about 1.5 KB.
09/01/2026;0;;;ACH DEBIT GUSTO PAYROLL 0912;-6420.18;;
09/01/2026;0;;;STRIPE TRANSFER ST-K2M8Q4;3184.27;;
09/02/2026;0;;;CHECK 2041;-1850.00;;
09/02/2026;0;;;ACH DEBIT AUSTIN ENERGY UTIL;-412.66;;
2. Which format to import
HomeBank's manual on the import feature lists the formats in order of preference:
| Format | HomeBank's manual says | What it means for you |
|---|---|---|
| OFX / QFX | "Recommended" (sometimes named Money or Quicken files) | The best choice. HomeBank can match the account by its number, and uses the FITID to spot duplicates |
| QIF | "Supported" ("Common Quicken" file) | Fine when OFX isn't offered. Set the date order to match the file (Utilly's QIF uses MM/DD/YYYY, so m-d-y) |
| CSV | "Advanced users only" ("format is specific to HomeBank, see the documentation") | Only after rearranging the file into HomeBank's eight columns (section 4) |
The CSV manual page is blunt about bank files: "The format used for the different files is specific to HomeBank", so a CSV downloaded from your bank won't import as it is, and "you will need to arrange it a little in a spreadsheet" first. If your bank only gives you a CSV, Utilly's CSV to OFX or CSV to QIF converter turns it into a format HomeBank takes without rearranging.
What's inside a QIF file, letter by letter, is on QIF format explained.
3. The import assistant, step by step
Before importing a QIF or CSV, check the date order HomeBank will use: Edit → Preferences..., the Import/Export section, Date order (d-m-y, m-d-y or y-m-d), which the manual describes as "set the default date order for file import". For Utilly's QIF and the test CSV, choose m-d-y. The same section has the OFX/QFX options (what to do with the OFX Name and Memo fields), the QIF options ("Import memos" and "Swap memos with payees"), the CSV Separator, and "Sentence case memo/payee".
- Open the import assistant. From the main window choose File → Import... (the manual's menu page says it will "open the import assistant dialog"), or drop one or several files onto the main window, which opens the assistant with those files already in the list.
- Select the files. Drop more files in, or use the +/- buttons to add or remove them. HomeBank can import several statements in one go.
- Choose what to import for each account. For each file or account, pick the target account: <New account (global)>, which "is a global account to merge several file/account"; <New account>, to "import in a separate account"; one of your existing accounts; or <Skip this account>, "to completely skip the account". HomeBank tries to preset the account itself, using the account number (OFX), then the name (OFX/QIF), then the filename. If the file has no reliable account information, an icon appears next to the target account dropdown, so pick the account yourself. Then check or uncheck transactions in the list (all, none, invert).
- Confirm. The last step summarises what will be imported for each account, with an option to import the transactions as pending status, and two automation options: "Enrich with payee default" and "Run automatic assignment rules".
The manual notes a limit when one file holds many accounts: there's no scrollbar in that step, "so you may need to split your import file".
4. HomeBank's CSV format
HomeBank's CSV file format page documents the transaction import layout. Notice the separator first: "HomeBank uses semi-colon as separator", not a comma, though since version 5.2.5 you can change the separator for transaction import in the preferences (Tab, Comma, Semicolon or Space). The columns, in order:
| # | Column | What HomeBank's manual allows |
|---|---|---|
| 1 | date | y-m-d, m-d-y or d-m-y; the year can be 2 or 4 digits; separators can be / . or - |
| 2 | payment | A number code (table below) |
| 3 | number | A string (for example a check number) |
| 4 | payee | A payee name |
| 5 | memo | A string |
| 6 | amount | A number with a period or a comma as the decimal separator, for example -24.12 or 36,75 |
| 7 | category | "a full category name (category, or category:subcategory)" |
| 8 | tags | "tags separated by space". Since version 4.5 the "tag column is mandatory", so keep the column even when it's empty |
The payment codes:
| Code | Payment | Code | Payment |
|---|---|---|---|
| 0 | none | 6 | debit card |
| 1 | credit card | 7 | standing order |
| 2 | check | 8 | electronic payment |
| 3 | cash | 9 | deposit |
| 4 | bank transfer | 10 | financial institution fee |
| 5 | internal transfer (imported as 4, bank transfer, because a CSV holds one account) | 11 | direct debit |
The manual's own example lines (European dates and decimal commas):
15-02-04;0;;;Some cash;-40,00;Bill:Withdrawal of cash;tag1 tag2
15-02-04;1;;;Internet DSL;-45,00;Inline service/Internet;tag2 my-tag3
Turning a bank CSV into this layout. In a spreadsheet, arrange the columns in the order above: the date first, a payment column (0 if you don't want to set one), an empty or filled number column, payee, memo (the bank's description works here), one signed amount column (combine separate debit and credit columns into one, debits negative), then category and tags, which can be empty. Save as CSV with semicolons, or set the separator in the preferences to match your file. The test CSV shows the result. Utilly's standard bank statement CSV has Date, Description, Amount and Balance columns with year-first dates, so it needs that rearranging too; the OFX route skips it.
A HomeBank export is in the same layout by default, plus extra columns in some cases: an account column when you export from all transactions, and a status column (R = reconciled, C = cleared) if you add it.
5. Duplicates, pending status and assignment rules
Duplicates. By default the assistant detects exact duplicates within the import and similar transactions already in the target account, unchecks them and marks them with an icon. For an OFX or QFX file, "identical FITID means a duplicate"; otherwise a simple comparison where "date, amount, memo, number, payee and category identical means a duplicate". For transactions that look like they already exist, a "Similar transaction in target account" section appears, matching on the same account, the same amount and the same date within a date gap you can change (the "default is 0 days = exact"). Importing overlapping months? Keep those boxes unchecked.
Pending. At confirmation, HomeBank's manual says: "This option is to import transaction as pending status".
Automatic assignment. HomeBank's assignment rules set a payee and/or category from text in the memo or payee. Create them in Manage → Assignments...: click Add, fill in the text to search for, optionally make it case sensitive and choose what to assign. The manual says "The assignment is applied after each file import", and you can also run it from the account window menu with Actions → Auto. assignment. Rules are evaluated in list order; drag to reorder. Payee defaults set on each payee can fill in imported transactions too ("Enrich with payee default" at confirmation).
6. PDF statements
HomeBank's import page lists OFX, QFX, QIF and CSV and doesn't mention PDF. To bring in months you only have as PDF statements:
- Convert each PDF statement with Utilly's bank statement PDF to OFX converter, HomeBank's recommended format, or PDF to QIF. Card statements work the same way. The free preview shows every line and whether the statement balances before you download.
- Import one month into a new test account first (section 7) and compare it with the statement. For Utilly's QIF, set the date order to m-d-y.
- Import the rest with File → Import..., leaving the duplicates HomeBank unchecks unchecked where months overlap.
Prefer CSV? Download Utilly's CSV from the same preview (or use bank statement to CSV) and rearrange it into HomeBank's columns as in section 4. The OFX or QIF route avoids the spreadsheet step.
7. Checking the import against known totals
Import the test files into a new account (and the card files into a new credit card account), never into an account you rely on, then compare:
| Check | Checking file | Credit card file | If it's wrong |
|---|---|---|---|
| Transactions | 31 | 21 | Fewer: some were unchecked as possible duplicates, or lines didn't match HomeBank's column layout |
| Money out | 28,575.27 (20) | 1,939.94 (19) | A different total means a column was read in the wrong place |
| Money in | 29,597.43 (11) | 1,542.18 (2) | Same as above |
| Change in balance | +1,022.16 | 397.76 more owed | The opposite sign means the amounts were read the wrong way round |
| Dates | Sept 1–30, 2026 | Sept 1–30, 2026 | Other months mean the wrong date order was set (choose m-d-y) |
| Statement balance | 12,418.36 → 13,440.52 | owed 2,846.12 → 3,243.88 | Start the test account at the opening figure |
The data is fictional (Example Community Bank and Sample Customer LLC don't exist; both statements say SAMPLE STATEMENT, FICTIONAL DATA FOR DEMONSTRATION ONLY). Replace every row before using a template for real.
8. Problems and fixes
| Symptom | What HomeBank's manual says |
|---|---|
| Your bank's CSV won't import or comes in wrong | HomeBank's CSV layout is its own; rearrange the file into date, payment, number, payee, memo, amount, category, tags, or import OFX or QIF instead |
| Your CSV uses commas, not semicolons | HomeBank uses semicolons by default; save the CSV with semicolons or change the CSV Separator under Edit → Preferences..., Import/Export |
| Your CSV has only seven columns | The "tag column is mandatory": keep the eighth column even if it's empty (end each line with a semicolon) |
| Dates in the wrong months | Set Date order under Edit → Preferences..., Import/Export to the order the file uses (m-d-y for Utilly's QIF and the test CSV) |
| Transactions missing after the import | The assistant unchecks likely duplicates; check the list in step 3 and tick the ones you want |
| Transactions went into the wrong account | Check the target account for each file in step 3; HomeBank presets it from the account number, name or filename, and shows an icon when it isn't sure |
| Can't see every account in a multi-account file | That step has no scrollbar; split the import file |
| Payee and memo swapped from a QIF | Use the QIF option "Swap memos with payees" in the preferences |
| Internal transfers came in as bank transfers from a CSV | Expected: payment 5 imports as 4, because a CSV holds one account |
Comparing programs? GnuCash's CSV import and KMyMoney's CSV wizard map your bank's columns instead of needing a fixed layout, and Moneydance and Banktivity import the same OFX, QFX, QIF and CSV files.
Get PDF statements into HomeBank
PDF statements, downloaded or scanned, get a free preview with the balance check, no sign-up. Download OFX, the format HomeBank's manual recommends, or QIF. Already have a bank CSV? Turn it into OFX or QIF instead of rearranging it. Files are processed in memory and not stored.
Utilly isn't affiliated with HomeBank. The steps and quotes above are from HomeBank's online user manual, checked November 15, 2026; the test files weren't imported into a live HomeBank file, and screens may differ between versions. Sources: Using the Import files feature, CSV file format, Preferences, Main window menu, Using the Automatic assignment feature. If a screen differs, follow HomeBank's current manual.
FAQ
What file formats can HomeBank import?
HomeBank's manual lists OFX or QFX as recommended, QIF as supported, and CSV for advanced users only, because the CSV layout is specific to HomeBank. Use OFX or QFX if your bank offers it.
How do I import a CSV file into HomeBank?
Put the CSV in HomeBank's own transaction layout first: date, payment, number, payee, memo, amount, category and tags, separated by semicolons, with the tags column present even when it's empty. Then choose File, Import, add the file, pick the target account, check the transactions and confirm.
What is the HomeBank CSV format for transactions?
Eight columns in this order: date (y-m-d, m-d-y or d-m-y, 2- or 4-digit year, separated by / . or -), payment (a code from 0 = none to 11 = direct debit), number, payee, memo, amount (with . or , as the decimal separator), category (category or category:subcategory) and tags separated by spaces. The separator is a semicolon by default and can be changed in the preferences.
Can HomeBank import my bank's CSV file directly?
Usually not. HomeBank's manual says its CSV format is specific to HomeBank and that you shouldn't expect to import your bank's CSV directly; you'll need to rearrange it in a spreadsheet first. An OFX or QIF file avoids that.
How does HomeBank handle duplicate transactions on import?
The import assistant unchecks likely duplicates and marks them. For OFX and QFX files an identical FITID means a duplicate; for other files the date, amount, memo, number, payee and category must all match. It also flags similar transactions already in the target account, using a date gap you can change.
Can HomeBank import a PDF bank statement?
HomeBank's manual lists OFX, QFX, QIF and CSV and doesn't mention PDF. Convert the PDF statement to OFX or QIF first, then import that file with File, Import.
Related guides
- GnuCash CSV import: the format, a free template, and every step of the assistant
- Moneydance import: CSV, QIF and OFX files, step by step, with free templates
- Banktivity import: CSV, QIF and OFX files, import rules and Quicken, step by step
- QIF file format explained: every field, with a real example
- Free sample OFX file (bank and credit card), explained
- Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.