# Switch from Excel Bookkeeping to QuickBooks

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2024-10-19
- Updated: 2024-10-19
- Category: Switching accounting software
- Canonical: https://www.simplebankconvert.com/blog/switch-from-excel-bookkeeping-to-quickbooks

> How to switch from Excel bookkeeping to QuickBooks: set up accounts, choose a start date and bring past bank activity in as files rather than retyping.
To switch from Excel bookkeeping to QuickBooks, turn your spreadsheet's category columns into a chart of accounts, pick a start date such as the first day of the year, and enter the balances your workbook shows on the day before. Then import bank activity from the start date onward as files built from the bank's records, not retyped rows.

## Turning Excel bookkeeping categories into a QuickBooks chart of accounts

A chart of accounts is the list of buckets QuickBooks sorts every transaction into: bank accounts, income, expenses, and what you own and owe. In a bookkeeping spreadsheet, those buckets are usually column headings or a category column. The first job is to write that list down and decide which QuickBooks account each one becomes.

Start from the workbook you actually use. Scroll through a full year and list every category that appears, including the odd ones someone typed once. Then group them. Most spreadsheets have more categories than a small business needs, because a new label got added whenever a transaction did not fit.

### An example mapping

These spreadsheet labels and accounts are illustrative. Your own list will differ.

| Spreadsheet category | QuickBooks account | Account type |
| --- | --- | --- |
| Sales, Client work, Invoiced | Service income | Income |
| Gas, Fuel, Car | Vehicle expenses | Expense |
| Adobe, Software, Apps | Software subscriptions | Expense |
| Owner draw, Personal | Owner's draw | Equity |
| Visa | Business credit card | Credit card |
| Checking | Business checking | Bank |

Labels that point to the same thing merge into one account. Labels that are really transfers, such as "Moved to savings", are not expenses at all; they become a transfer between two bank accounts.

### Bring the list across

Intuit's [common questions about importing data into QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/common-questions-importing-data-quickbooks-online/L4OYJRFdj_US_en_US) lists the chart of accounts among the things you can import, from a CSV, Google Sheets or Excel file. For a short list, typing the accounts in by hand is often just as quick and lets you choose each account type with care.

## Which start date suits an Excel-to-QuickBooks move?

The best start date is the first day of your financial year, and the next best is the first day of a month. A year start gives QuickBooks a complete year for tax reporting. A month start keeps the cut simple, because every bank statement ends on a month boundary and gives you a printed balance to begin from.

Picking a date halfway through a year means the year is split. The early months stay in Excel and the later months live in QuickBooks, and someone has to add the two together at tax time. That is workable, but it is extra work every year until the split year is behind you.

A start date also controls how much bank history you need to import, since everything from the start date up to today must be in QuickBooks. [Choosing a conversion date when switching to QuickBooks](/blog/conversion-date-when-switching-to-quickbooks) goes through the year-start and month-start choices in more detail, including what balances each one needs.

## Starting balances taken from the Excel workbook

Starting balances are the amounts your business had in each account on the day before the start date: cash in each bank account, what each card owed, money customers owed you and bills you had not paid. They give QuickBooks a starting point, so the first imported month adds onto the right figure rather than onto zero.

Check every bank and card figure against a real statement before you enter it. Spreadsheet balances drift. A formula that skipped a row, a pasted value that overwrote a calculation, or a transaction entered twice can each leave the workbook a little off from the bank. When the workbook and the statement disagree, enter the statement's figure, and note the difference somewhere so you can find its cause later.

### A short checklist for starting balances

1. Each bank account: the closing balance on the statement that ends the day before the start date.
2. Each credit card: the balance owed on that same date, from the card statement.
3. Loans: the principal balance from the lender's statement.
4. Customers who owe you: a list of each unpaid invoice, not just the total.
5. Bills you owe: a list of each unpaid bill.
6. Equipment or vehicles you track: their value on your last tax return, if your accountant wants them on the books.

Unpaid invoices and bills deserve their own entries because they will be paid after the start date. If QuickBooks holds only a total, there is nothing for the payment to close.

## Why the bank's records beat the Excel sheet for QuickBooks imports

Use the bank's own records for bank imports, not your spreadsheet rows. The bank's file reflects what really cleared, with the bank's dates and exact amounts. A spreadsheet reflects what someone typed, which may include a check that never cleared, a rounded amount or a date entered as the day it was written rather than the day it posted.

This matters most when you reconcile. Reconciling means matching the QuickBooks bank register to the bank statement, line by line, so the balances agree. If the register was built from the bank's data, the first reconciliation in QuickBooks is quick. If it was built from the spreadsheet, every typing error from the past shows up as a difference to track down.

### Where the bank's records come from

- A download from the bank's website, if it offers CSV or QBO files for the months you need.
- PDF statements saved from the bank's website or kept from the mail.
- For QuickBooks Desktop, a Web Connect file from the bank; Intuit's guide to [downloading bank transactions into QuickBooks Desktop](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-feeds/download-bank-feed-transactions-quickbooks-desktop/L8o0Aw9VM_US_en_US) says Web Connect only works with .qbo files.

When the only thing left is a stack of PDF statements, QuickBooks Online's upload can read a PDF statement and show its lines for you to review, while Desktop still needs a .qbo file. SimpleBankConvert is being built to produce a CSV or QBO file from each PDF statement, and anyone who wants to try it can sign up on the [get started page](/get-started).

Your spreadsheet still has a job: it holds the categories you chose for each transaction. Keep it open while you categorize the imported lines, so you can see how you treated a payee last year.

## Shaping Excel bank rows for the QuickBooks upload

If you do upload rows yourself, QuickBooks Online expects a simple, narrow file. Intuit's article on [manually uploading transactions into QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) says each CSV needs three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), one date format throughout, and a file no larger than 350 KB.

Intuit also says to leave zero-value cells blank rather than typing 0, and to split a day-of-week out of the date column if the bank includes one. For long histories, it suggests shorter date ranges uploaded in smaller batches.

### Before and after

This example shows rows from a typical bookkeeping sheet and the same rows reshaped for upload. The values are made up.

| Sheet row as kept | Date | Description | Amount |
| --- | --- | --- | --- |
| "Jan 3", Coffee for client, Meals, 18.40 | 01/03/2026 | Coffee for client | -18.40 |
| "1/5/26", Invoice 112 paid, Sales, 950 | 01/05/2026 | Invoice 112 paid | 950.00 |
| "Jan 7", Phone bill, Utilities, 74.99 | 01/07/2026 | Phone bill | -74.99 |

Three things changed. The dates now share one format. The category column is gone, because the upload has no place for it. And money going out carries a minus sign, since a single amount column needs a sign to tell spending from income.

Upload one bank account per file. A sheet that mixes checking and card rows has to be split first, or card charges land in the checking register.

### Mistakes that make the upload fail

- **Text dates.** A date Excel stored as text, such as "Jan 3", may look right but export as words. Convert the whole column to real dates before saving.
- **Totals at the bottom.** A monthly total row uploads as a giant transaction. Delete every subtotal and balance row.
- **Commas in amounts.** A figure saved as "1,250.00" with the comma can split across two columns in a CSV. Format amounts as plain numbers first.
- **Saving the wrong sheet.** A CSV holds only the sheet that was open when you saved it, so check that the bank rows were the active tab.

## Should Excel bookkeeping history go into QuickBooks at all?

Often it should not. If your start date is the beginning of this year, past years can stay in the workbook, closed and filed with the tax returns they produced. Importing them adds work, and every imported year must also reconcile, or it leaves differences that sit in the books for good.

Bring older history in only when someone needs it inside QuickBooks: a lender asking for multi-year reports from one system, or a business that wants year-on-year comparisons on screen. [How much bank history to move to new software](/blog/how-much-bank-history-to-move-to-new-software) weighs each choice against the import and checking work it creates.

### A Desktop wrinkle

If you choose QuickBooks Desktop instead of Online, past months arrive as Web Connect files, and the dates inside each file decide what gets added. [How the QuickBooks Desktop Web Connect date range works](/blog/quickbooks-desktop-web-connect-date-range) explains what a bank puts in the file and when overlapping dates double up.

### Keep the workbook, but freeze it

Whatever you decide, save a final copy of the spreadsheet, mark it read-only and stop adding to it on the start date. Two live sets of books, even briefly, is how the same expense ends up counted twice.