To set up QuickBooks Online from bank statements, pick a start date at the beginning of a statement period, create each bank account with the statement's opening balance on that date, then upload every month's transactions in date order. After each month, check that the QuickBooks balance equals the statement's closing balance before moving on.
Choosing a QuickBooks start date from your bank statements
The start date is the first day your QuickBooks books will cover, and with statements as your only record it should be the first day of a statement period. Intuit's article on opening balances notes that most businesses start tracking from the beginning of the year.
The start of a year is a good default because your tax return and year-end reports cover whole years. Books that begin in July can only show half the year's profit, and someone will have to add the first half from another source.
Look at how your bank cuts its statements before choosing. Many banks run statements from the first to the last day of the month. Others run from, say, the 15th to the 14th. If yours are cut mid-month, the cleanest start date is still a statement start date, because that is the only day for which a printed balance is easy to find. Starting on January 1 with a statement that runs December 15 to January 14 means working out the January 1 balance yourself.
Two practical checks help:
- Do you have every statement from the start date to today? Any missing month becomes a hole in the books. Get it from the bank before you begin.
- Is the start date before any transaction already in QuickBooks? If the company file already has a few entries, the start date must come before the oldest one.
Which bank statement balance becomes the opening balance?
The opening balance is the balance in the account at the start of your start date, which is the opening or beginning balance printed on the first statement you will import. It is also the closing balance of the statement before it. Intuit's article says the statement is the best place to find this figure.
When you create the account, QuickBooks asks for the opening balance and an "As of" date. Intuit's article says to enter the opening balance of the account on the starting date you put in "As of". So for books starting on January 1, the "As of" date is January 1 and the balance is the one the bank shows at the start of that day.
Intuit's article also explains what happens behind the scenes. QuickBooks records the balance against an account called Opening Balance Equity, which keeps the books in balance while you have no history before the start date. Later, your accountant may move that amount into the right equity accounts. You don't need to do anything with it during setup.
Fixing an opening balance typed wrongly
A wrong opening balance shows up at the first monthly tie-out, as a difference that stays the same size every month. You don't need to delete the account. Intuit's article says to open the account's register, select the entry that shows Opening Balance Equity as the payee, then change its date or amount and save. Correct it before you reconcile, so the first reconciliation starts from the right figure.
When the balance is negative
An overdrawn account opens with a negative balance. Enter it as a negative number. A credit card works the other way round: its opening balance is the amount you owed on the start date, entered as a positive balance on the card account.
Creating each account from its own bank statement
Every statement you receive stands for one account, and each needs its own account in QuickBooks. A checking account, a savings account and a credit card are three accounts, even when they sit at the same bank and arrive in one envelope.
Create them in the chart of accounts before any upload:
- Choose the account type: bank for checking and savings, credit card for a card.
- Name it after the real account and its last four digits, such as "Checking 6013".
- Enter the opening balance from that account's first statement.
- Enter the start date in "As of".
- Save, then repeat for the next statement.
Intuit's article mentions one exception. When an account is connected to online banking, it says QuickBooks handles the opening balance for you. Setting up from statements, with no connection, you type it yourself.
If the business tracks departments, locations or projects, decide that before importing too. The post on importing transactions with classes into QuickBooks Online explains where class and location tags survive an import and where they have to be added after.
Uploading the statement months in order with no gaps
Upload the statements one month at a time, oldest first, with each file starting the day after the last one ended. Intuit's help article on uploading transactions says to start each new file on the day after your last transaction in that account, and to make sure the first file starts at least a day before your oldest transaction.
Going oldest first matters because the review screen works through transactions in order, and matching makes more sense when the earlier months are already in. It also makes each monthly check, in the next section, a simple comparison.
The upload takes transaction lists as QBO, QFX or CSV files. The same Intuit page says it can also take a PDF or image statement, which QuickBooks reads with AI and shows side by side with the extracted lines for you to check. If your bank lets you download older activity as a file, use that, because a file needs no extraction. If you only have PDF statements, either check each extraction carefully or turn each statement into a file first. SimpleBankConvert is being built for exactly that step, turning a PDF statement into a CSV or QBO upload file. It is still being prepared for launch, and SimpleBankConvert's homepage explains what it will produce.
Naming the files
Name each file with its account and dates, such as checking-6013-2026-02-01-to-2026-02-28. With twelve months and three accounts, you will handle thirty-six files. Good names stop you uploading February twice or skipping March.
How do you know each statement month ties out?
A month ties out when the QuickBooks balance for the account, on the statement's last day, equals the closing balance printed on that statement. Check it after every month's upload and review. If it matches, the month is complete. If not, find the difference before importing the next month.
Here is a worked example with made-up figures for one checking account:
| Statement | Opening balance | Closing balance on statement | QuickBooks balance after upload | Result |
|---|---|---|---|---|
| January | 8,240.00 | 9,115.60 | 9,115.60 | Ties out |
| February | 9,115.60 | 7,902.35 | 7,876.35 | Off by 26.00 |
| March | 7,902.35 | 10,418.90 | (wait) | Hold until February is fixed |
February is 26.00 short in QuickBooks, which means the books show 26.00 more going out than the bank does. Typical causes are a line added twice, a refund imported as a payment, or a fee entered by hand that the import also brought in. Look for a 26.00 line, or two lines that add up to it.
Once every month ties out, reconcile each account in QuickBooks against its statements. The tie-out you did along the way makes reconciliation quick, because the totals already agree.
Statement lines that need more than a category
Most statement lines take one category on review, but a few need more. Transfers between your own accounts, loan payments that mix principal and interest, and payments the statement describes only by a reference number all need extra handling before the books are right.
- Transfers. Money from checking to savings appears on both statements. Record it as a transfer between the two QuickBooks accounts, not as an expense and an income.
- Loan payments. A loan payment is partly principal, which reduces what you owe, and partly interest, which is an expense. The guide to importing loan payments into QuickBooks Online covers splitting each payment.
- Cash and missing items. If something happened that no statement shows, such as a cash expense paid from your own pocket, add it by hand. The post on manually adding a transaction in QuickBooks Online shows which form to use.
When bank statements are the wrong place to start QuickBooks
Bank statements are the wrong starting point when the business already has books elsewhere, when it owes or is owed money that no statement shows, or when an accountant has a year-end balance sheet you could start from. Statements show cash. They do not show unpaid invoices, unpaid bills, equipment or loans in full.
For a sole trader who runs everything through one checking account and gets paid on the spot, statements are often all the history there is, and they are enough. For a business that sends invoices on 30-day terms, starting from statements alone means customer balances are missing on day one. Ask your accountant for the balances on the start date and enter those alongside the bank opening balance.
A bank feed can also replace part of the work for recent months. If the bank's feed reaches back to your start date, connecting it saves uploading those months, and you only use statements for anything older.
If you use YNAB for personal budgeting alongside the business books, that is a separate job. The guide to importing a bank statement into YNAB from a file covers it.