MoneyWiz Import CSV and OFX: Convert PDF Bank Statements for MoneyWiz

How do I import transactions into MoneyWiz?

Drag an OFX, QFX, QIF, CSV or MT940 file onto the MoneyWiz window or its icon, and the Import Wizard walks you through linking accounts, payees and categories. You can also copy a file's contents and use Import from clipboard in MoneyWiz Settings. PDF is not on the list. When the months you need only exist as PDF statements, convert them to OFX with the upload box on this page and drag the OFX in like any bank download.

Most people hit this for one of two reasons. MoneyWiz's own help center says Online Banking usually downloads 30 to 90 days of history when you connect an account, sometimes more, and that the bank and provider decide. Its advice for anything older is to export it from the bank and import it manually. The second reason is the plan: MoneyWiz Standard ($29.99 a year) has cloud sync but no bank sync at all, so every transaction on Standard arrives by file or by hand.

What file formats does MoneyWiz import?

MoneyWiz imports CSV, QIF, OFX, QFX and MT940 files. Here is how the files you are probably holding line up against that list.

OFX is the least work of the lot. Dates sit in one fixed format, amounts carry their sign, and every transaction has an ID, so there is no field mapping step and no question about whether 06/07 means June or July. That is why we recommend converting a PDF to OFX rather than CSV for anything you will import without editing first.

How do I import a PDF bank statement into MoneyWiz?

Convert the PDF to OFX, then drag the OFX onto MoneyWiz. The converter reads the transaction table on every page, scanned statements included, and writes one OFX file per statement with the posting date, signed amount, description and a stable transaction ID on each line. This routine keeps a full year clean:

1. Upload one statement month with the box at the top of this page. Checking, savings, money market and credit card statements all work, digital or scanned.
2. Check the extracted rows against the PDF (dates, amounts, signs), then download the result as OFX.
3. Drag the .ofx file onto the MoneyWiz window or onto its icon. The Import Wizard opens.
4. At Link Accounts, point the account found in the file to the right MoneyWiz account, or let MoneyWiz create it.
5. Pick Quick import for a routine month, or Advanced import the first time so you can link payees and categories. MoneyWiz remembers those links for the next file.
6. If MoneyWiz flags possible duplicates, decide line by line, then compare the account balance on the statement end date with the closing balance printed on the PDF.

A month per file sounds slow and is not. Each import takes a minute, and checking the balance after each one catches problems while they are small. A difference equal to one transaction means a line is missing; a difference of twice an amount means a sign came in reversed.

MoneyWiz import CSV: mapping the columns

CSV import works well in MoneyWiz, and it is the better choice when you want to add categories, tags or memos in a spreadsheet before the data lands. When you import a CSV, MoneyWiz asks how each column relates to a transaction field. It matches columns by header name on its own, so a column called Date links to Date automatically, and anything it cannot place defaults to Don't import. At minimum you need Date, Amount, and Payee or Description.

MoneyWiz accepts either one Amount column or the pair Amount (Expenses) and Amount (Incomes), never a mix. That suits bank statements well, because many US banks print withdrawals and deposits in separate columns. The converted CSV keeps the columns the way the statement prints them, so a two-column statement maps straight to the pair. If you want a single column instead, the converter's Split Debit/Credit option works the other way round (one column into two), so leave it off and add a formula in Excel.

Two details from MoneyWiz's CSV guide matter here. First, it cannot read a date that has a time stuck in the same column. Second, extra text above the header row, such as an account balance line, confuses the import. Choose Transactions only before you convert, and the CSV contains just the transaction table under one header row. Dates stay as the statement prints them; if MoneyWiz is unsure about the order, it shows you a few rows and asks, and for a US statement the answer is month first.

Which route should you use for older history?

On Premium, the practical order is to import converted statements up to the end date of your most recent statement, then connect Online Banking. MoneyWiz's help center explains why: when you connect an account that already holds transactions, it downloads only transactions newer than the latest one and does not fill gaps behind it. Import first and the two routes meet cleanly. If you connect first, import the older statements afterwards and let the duplicate check handle the few days where they overlap.

How MoneyWiz handles duplicates

MoneyWiz checks every transaction in an imported file against the ones already in the account and asks you what to do when it finds a possible duplicate. Its own examples are importing the same file twice, importing a statement that runs from 25 September to 25 October after you already imported all of September, and importing two accounts that both hold the same transfer. Online Banking uses its own rule on top of that: a downloaded transaction with exactly the same amount and a date within 3 days of one you entered updates your entry instead of adding a second one. Import one statement month per file and keep the ranges from overlapping, and you will rarely see the prompt.

Moving to MoneyWiz from another app

MoneyWiz has migration guides for Microsoft Money (export a Loose QIF), Quicken Essentials for Mac (one CSV per account), Banktivity, YNAB and Moneydance, and each one asks you to note the opening balance of every account before you export. Those exports cover the years the old app held. The gap is usually the months after your last export, or accounts you never tracked. Convert those statements to OFX and import them once the old history is in. If you are still comparing apps, our pages on importing PDF statements into Banktivity and converting statements for Moneydance show the same job in those programs.

How much does it cost to convert a year of statements?

The demo converts up to 15 pages with no credit card, enough to run a statement or two through MoneyWiz end to end. A year of a typical checking account is 12 statements of 2 to 6 pages each, well inside the Starter plan at $49 a month (2,500 pages a month on the faster AI model, up to 25 pages per statement). Cancel after the month if the backlog is done. Bookkeepers catching up several clients, or anyone with long statements, will want Plus for bulk upload of up to 50 files. See pricing for current plans.

For scale, MoneyWiz Premium is $59.99 a year. One month of conversion to load several years of history costs less than a year of the app, and far less than an evening of typing a business account line by line.