To switch from Quicken to QuickBooks Online, pick a start date, set up each business bank and card account in QuickBooks with its balance on that date, and then upload bank files from the start date forward, oldest first. Quicken data does not convert into QuickBooks Online, so the history you keep comes in as bank files.
What changes when you leave Quicken for QuickBooks Online?
Quicken tracks accounts and spending categories. QuickBooks Online keeps double-entry books: a chart of accounts, customers, vendors, invoices and reports an accountant can file from. Because the two programs store money so differently, there is no converter between them. You rebuild the structure in QuickBooks and bring the bank activity across as files.
The shift in thinking
In Quicken, a payment to the electric company is a line in a checking register with a category such as Utilities. In QuickBooks Online, the same payment is an expense that hits two accounts: the bank account goes down, and a Utilities expense account goes up. Most of the time you never see the second half. It matters when you set up opening balances, because QuickBooks needs to know where each starting amount comes from.
What you gain
- Invoices that track who owes you, and bills that track whom you owe.
- A balance sheet and a profit and loss report that an accountant can work from.
- Bank rules that categorize repeat payees for you.
- Access for a bookkeeper or accountant without sending a data file.
What you leave behind
Personal features such as budgets, investment tracking and bill reminders for household accounts have no place in QuickBooks Online. Those stay in Quicken if you still want them.
How much Quicken history to keep for QuickBooks Online?
Most businesses keep only the current year and start QuickBooks Online on January 1, or on the first day of their tax year. That gives a full year of reports in one program. Older years stay in Quicken, where you can still look them up, and in saved reports.
Three start dates compared
- Start of the current year. The most common choice. You set balances as of December 31 and import every bank line since. One program holds the whole tax year.
- Start of this month. The least work. You set balances as of last month end and let the feed carry on. Earlier months this year stay in Quicken, so year-end reports need both programs.
- Several years back. Only worth it when someone needs multi-year reports in QuickBooks, such as for a loan. Each extra year adds twelve statements per account to import and check.
Check how far your bank feed reaches
When you connect a bank account, QuickBooks Online can download some past activity without any files. Intuit's guide to connecting bank and credit card accounts to QuickBooks says download timespans vary by bank, from 90 days up to 24 months. If your feed reaches back to your start date, you may need no history files for that account at all.
Splitting business and personal Quicken accounts before the switch
Only business accounts belong in QuickBooks Online. Before you set anything up, list every account in your Quicken file and mark each one as business, personal or mixed. Business accounts move. Personal accounts stay in Quicken. Mixed accounts need a decision, because one card used for both makes clean books hard.
Making the list
Open Quicken's account list and write down each account's name, type, institution and last four digits. Add a column for business or personal. For each business account, note the balance on your chosen start date, taken from the bank statement rather than from the Quicken register.
Mixed accounts
A card that pays for both groceries and printer ink is common in a Quicken file. You have two choices. Move the card into QuickBooks and record personal charges as owner draws, or open a separate card for business and leave the old one in Quicken. The second choice gives cleaner books from the first day.
A note for sole traders
If you were using QuickBooks Self-Employed or another app alongside Quicken, the same split applies. Moves from other small-business tools follow a similar pattern; switching from Wave to QuickBooks Online walks through one from software that already kept business books.
Setting up QuickBooks Online accounts and opening balances from Quicken
Opening balances in QuickBooks Online are the amounts each business account held on the day before your start date. Take them from the bank and card statements, not from Quicken, because a Quicken register can hold uncleared or misdated entries. Enter each one when you create the account, dated the day before the start date.
A worked example
These values are examples only. A one-person design studio switches to QuickBooks Online with a start date of 2026-07-01.
| Account in Quicken | Type in QuickBooks | Balance on 2026-06-30 (from statement) |
|---|---|---|
| Business Checking 2201 | Bank | 14,382.50 |
| Business Savings 7740 | Bank | 25,000.00 |
| Studio Visa 9012 | Credit card | 1,946.18 owed |
| Household Checking 5503 | Stays in Quicken | not moved |
The checking and savings balances go in as amounts held. The card goes in as an amount owed. QuickBooks records the other side of each opening balance in an equity account, which your accountant can reclassify later if needed.
Customers and vendors
Quicken has payees, not customers and vendors. You do not need to move every payee. Add customers when you first invoice them and vendors when you first pay them, and let QuickBooks build the lists from use. If you have many to load at once, a spreadsheet import can save typing; importing Google Sheets into QuickBooks Online shows how to lay out a sheet that QuickBooks will read.
Uncleared items on the start date
A check you wrote on June 28 that clears July 3 belongs to the old period. Your statement balance at June 30 does not include it yet. Enter the check in QuickBooks with its real date, so that it can match when the July statement line arrives.
Importing bank files into QuickBooks Online in date order
Bank history comes into QuickBooks Online as files you upload to each account, one account at a time, oldest month first. Intuit's help lists the file types the upload takes, and recommends a QBO file. Uploading in date order lets you check each month's ending balance against the statement before you move on.
Which file to use
Intuit's article on manually uploading transactions into QuickBooks Online names QBO, QFX and CSV, and its steps also list TXT and OFX. A CSV needs either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), with every date in the same format. Files are limited to 350 KB and 1,000 lines per upload, so one month per file is the comfortable size.
The QIF files that Quicken exports are not on that list. Rather than exporting from Quicken, download fresh files from your bank, or work from the statements themselves.
An upload order
- Connect the bank feed and set its start date to the earliest date the feed can reach, or to your own start date if that is later.
- For the months before the feed's first date, get one file per month per account.
- Upload the oldest month for one account. Categorize or match its lines.
- Compare the account balance in QuickBooks with the statement's closing balance for that month.
- Move to the next month only when they agree.
- Repeat for each account, then reconcile each month in QuickBooks.
When the bank only gives PDFs
Older months are often available only as PDF statements. The same upload screen can read a PDF or image statement and show you its lines to check before you save them. If you would rather have a file you can check in a spreadsheet first, SimpleBankConvert is being built to turn a PDF statement into a CSV or QBO file for QuickBooks Online, with dates in one format and money going out shown as minus amounts; the get started page has the details.
Quicken categories that do not map onto a chart of accounts
Quicken categories are the most common source of trouble in this switch. A category is a label for spending, while a QuickBooks account is part of a set of books. Some categories map neatly onto an expense account. Others, such as transfers, loan payments and owner withdrawals, need a different treatment altogether.
Categories that map well
Office Supplies, Software, Phone, Rent and similar spending categories become expense accounts of the same name. Keep the list short. Ten clear accounts are easier to report on than forty narrow ones carried over from Quicken.
Categories that need care
- Transfers between accounts. In QuickBooks these are transfers between two bank accounts, not expenses. Categorizing them as an expense overstates spending.
- Loan payments. Only the interest is an expense. The principal reduces a loan account.
- Money you took out for yourself. This is an owner draw, an equity account, not an expense.
- Sales tax collected. This is a liability you owe, handled through QuickBooks' sales tax setup.
Other tools with the same problem
Moves from invoicing apps hit a similar mapping step, with income categories in place of spending ones. Switching from FreshBooks to QuickBooks Online covers that version, which is useful if you also sent invoices from another tool alongside Quicken.
Keeping the Quicken data file after the QuickBooks Online switch
Keep the Quicken data file, and a backup of it, after the switch. It holds the history you chose not to move, and it is the quickest way to answer a question about an old transaction. Before you stop using it, save the reports you are most likely to need as PDFs.
Reports worth saving
- A transaction report for each business account, for each year you did not move.
- A spending by category report for each of those years.
- An account balances report as of the day before your start date.
Name each file with the account and the period, for example "Business Checking 2201, 2025.pdf", and store them with your bank statements.
Stopping Quicken cleanly
Stop entering business transactions in Quicken on the day before your start date. Leaving both programs running for business accounts invites double entry. Personal accounts can carry on in Quicken as before.