Guides · HomeBank

HomeBank import: CSV format, QIF and OFX files, step by step

Updated November 15, 2026 · 8 min read · By the Utilly team

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.

Checking CSVChecking OFXChecking QIF

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.

FileWhat's in itKnown totals
Checking CSVThe 31 lines of the fictional checking statement in HomeBank's eight-column transaction layout, no header row20 payments 28,575.27; 11 deposits 29,597.43; net +1,022.16
Checking OFX / QIFThe same 31 lines as Utilly's converter writes them from the PDF statementAs the checking CSV
Credit card OFX / QIFThe 21 lines of the matching fictional card statement19 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:

FormatHomeBank's manual saysWhat 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".

  1. 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.
  2. Select the files. Drop more files in, or use the +/- buttons to add or remove them. HomeBank can import several statements in one go.
  3. 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).
  4. 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:

#ColumnWhat HomeBank's manual allows
1datey-m-d, m-d-y or d-m-y; the year can be 2 or 4 digits; separators can be / . or -
2paymentA number code (table below)
3numberA string (for example a check number)
4payeeA payee name
5memoA string
6amountA number with a period or a comma as the decimal separator, for example -24.12 or 36,75
7category"a full category name (category, or category:subcategory)"
8tags"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:

CodePaymentCodePayment
0none6debit card
1credit card7standing order
2check8electronic payment
3cash9deposit
4bank transfer10financial institution fee
5internal transfer (imported as 4, bank transfer, because a CSV holds one account)11direct 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:

  1. 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.
  2. 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.
  3. 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:

CheckChecking fileCredit card fileIf it's wrong
Transactions3121Fewer: some were unchecked as possible duplicates, or lines didn't match HomeBank's column layout
Money out28,575.27 (20)1,939.94 (19)A different total means a column was read in the wrong place
Money in29,597.43 (11)1,542.18 (2)Same as above
Change in balance+1,022.16397.76 more owedThe opposite sign means the amounts were read the wrong way round
DatesSept 1–30, 2026Sept 1–30, 2026Other months mean the wrong date order was set (choose m-d-y)
Statement balance12,418.36 → 13,440.52owed 2,846.12 → 3,243.88Start 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

SymptomWhat HomeBank's manual says
Your bank's CSV won't import or comes in wrongHomeBank'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 semicolonsHomeBank uses semicolons by default; save the CSV with semicolons or change the CSV Separator under Edit → Preferences..., Import/Export
Your CSV has only seven columnsThe "tag column is mandatory": keep the eighth column even if it's empty (end each line with a semicolon)
Dates in the wrong monthsSet 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 importThe assistant unchecks likely duplicates; check the list in step 3 and tick the ones you want
Transactions went into the wrong accountCheck 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 fileThat step has no scrollbar; split the import file
Payee and memo swapped from a QIFUse the QIF option "Swap memos with payees" in the preferences
Internal transfers came in as bank transfers from a CSVExpected: 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 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.