Moving from QuickBooks Desktop to OurBooks
For: QuickBooks Desktop owners deciding whether to move, or already moving, who want to know how to export, in what order to import, and what will not be in OurBooks afterwards.
You do the move yourself: you export files from QuickBooks Desktop and import them into OurBooks, one step at a time. This guide covers how to export, what order to import in, and what does not come into OurBooks.
Table of contents
- Before you start
- How to export from QuickBooks Desktop
- What order to import in
- What does not come into OurBooks
- If a file is refused
Before you start
- Imports can't be undone in one step. Every import shows a preview first. Read it before you commit.
- Customers, suppliers and items can't be deleted. You deactivate one you don't want.
- On the Chart of Accounts, you delete accounts one at a time, with Delete on the account's row. OurBooks refuses to delete a system account or an account with transactions, and offers Deactivate instead. It also refuses to delete an account a company setting names until you choose a different account in that setting.
- Delete does not check whether an item uses an account. Do not delete an account an item still uses.
- Restart Company (the company's owner only) clears your transactions and keeps your setup, including accounts, customers, suppliers and items. It does not undo a master-data (IIF) import. See Clearing a company to start again for what restarting clears and keeps.
- So a master-data (IIF) import can't be taken back. Read its preview, and its Unsupported panel, before you click Import Selected.
- Confirm your currency first. The first import locks the company's currency permanently, so OurBooks asks you to confirm it before any import opens.
- The guide's lists come from the QuickBooks Desktop Pro Plus 2022 export (version 32.0D). A different QuickBooks version can export different record types, so check the preview and the Unsupported and Not imported panels on your own files.
โ ๏ธ Warning โ Importing the same history twice can double it. Use one file for any period of history, not two overlapping files.
How to export from QuickBooks Desktop
Open Import Data in OurBooks. Each tile there for a QuickBooks report or file has a ? help link with the export steps for that file. The estimate and unbilled-cost steps have no tile of their own: they run in the wizard, and each shows its export steps under How to export this from QuickBooks. You can also run the whole path through the step-by-step wizard: on Import Data, click Open Wizard, then choose QuickBooks at Where are you migrating from?.
You export from QuickBooks Desktop in two ways: one IIF file for your lists, and one CSV file for each report.
The IIF file (your lists)
- Open the File menu.
- Hover over Utilities, then Export.
- Click Lists to IIF Files...
- Check the lists you want, such as the Chart of Accounts, Customer List and Vendor List.
- Click OK and choose where to save the
.IIFfile.
The IIF file holds your lists: accounts, customers and jobs, vendors, items, employees and similar. The IIF file you export from your lists holds no transactions.
๐ Note โ An IIF import creates no invoices or bills. Your open receivables and payables come from the AR Aging Detail and AP Aging reports below, or from a Journal Detail export.
The CSV reports
In each report, click Export at the top, choose Create a comma separated values (.csv) file, click Export and save the file.
| Report in QuickBooks Desktop | Where to find it | Import it as |
|---|---|---|
| Trial Balance | Reports โ Accountant & Taxes โ Trial Balance | Trial Balance CSV |
| Journal | Reports โ Accountant & Taxes โ Journal | Journal Detail CSV |
| A/R Aging Detail | Reports โ Customers & Receivables โ A/R Aging Detail | AR Aging Detail CSV |
| Estimates by Job | Reports โ Jobs, Time & Mileage โ Estimates by Job | Import Open Estimates step (first of its two files) |
| Job Progress Invoices vs. Estimates | Reports โ Jobs, Time & Mileage โ Job Progress Invoices vs. Estimates | Import Open Estimates step (second of its two files) |
| A/P Aging Detail | Reports โ Vendors & Payables โ A/P Aging Detail | AP Aging CSV |
| Unbilled Costs by Job | Reports โ Jobs, Time & Mileage โ Unbilled Costs by Job | Import Unbilled Costs step |
| Inventory Valuation Summary | Reports โ Inventory โ Inventory Valuation Summary | Inventory Valuation Summary tile |
The Import Open Estimates step needs both estimate reports before it can preview. Its export help lists the date and filter settings each report needs.
๐ก Tip โ Export Inventory Valuation Summary. The detail version of that report and the Stock Status report are not the report this check reads: the Stock Status file is refused, and the detail file is accepted but misread, so the check's figures mean nothing.
โ ๏ธ Warning โ Export one Journal for the whole period you want. If you export two Journals that overlap, import only one of them. OurBooks skipped every entry of a second, overlapping file in testing, because the entries were already in the books, but it does not promise to catch every case.
What order to import in
The wizard runs the steps in this order, and each step builds on the one before. You can skip any step after Set up your books. You can leave the wizard and come back.
- Set up your books โ currency and history start date. This step cannot be skipped.
- Import Master Data โ the IIF file: chart of accounts, customers, vendors and items.
- Import Opening Trial Balance โ opening balances for all accounts.
- Import Journal Details โ historical journal entries.
- Import Open AR โ outstanding customer invoices, from the AR Aging Detail CSV.
- Import Open Estimates โ open and part-billed estimates, brought in as quotes, from two CSV files: Estimates by Job, and Job Progress Invoices vs. Estimates.
- Import Open AP โ outstanding vendor bills, from the AP Aging CSV.
- Import Unbilled Costs โ job costs your customers still owe you. This step is last because it matches cost lines that the Journal Details step created.
Master data goes first because every later step looks up accounts, customers, vendors and items that must already exist.
Stock is not one of the wizard's steps. Open the Inventory Valuation Summary tile on Import Data after the trial balance and the journal detail: the items arrive without quantities, and the tile checks the stock report against the inventory balance in your books. Set Stock report date to the date your stock report was run as of. After a Journal Detail import, it starts out as the day after the journal detail's last entry, so inventory tracking starts after your imported history. Click Preview to see the check. Nothing posts until you click Post opening stock, which starts inventory tracking on the stock report date and gives each matched item its opening quantity and value. Your account balances don't change. If the preview gives a reason instead of Post opening stock, opening stock can't be posted until that is fixed. Only the company's owner can post opening stock. If posting stops part-way, the tile says opening stock was posted but isn't finished, and offers Finish opening stock, which only the company's owner can click.
โ ๏ธ Warning โ Opening stock can be posted only once, and it can't be voided or edited afterwards, so check the Stock report date before you post. Posting turns on inventory tracking and Enforce unit conversions, and once stock has moved, tracking can't be turned off.
For each file, upload it and read the preview. The IIF, Trial Balance, Journal Detail, AR Aging and AP Aging steps also accept the file's contents pasted in; the other steps take an upload only. The Import Open Estimates and Import Unbilled Costs steps show a preview only after you click Check & Preview.
Then click the import button under the preview to commit. Its label depends on the step:
| Step or tile | Button that commits |
|---|---|
| Import Master Data (the IIF file) | Import Selected |
| Import Opening Trial Balance | Import as Journal Entry, then Confirm Import |
| Import Journal Details | Import Journal Entries |
| Import Open AR | Import Invoices |
| Import Open Estimates | Import n Quotes (Import 1 Quote for one), with the number of estimates to import |
| Import Open AP | Import Bills |
| Import Unbilled Costs | Mark n billable, with the number of costs you ticked |
| Inventory Valuation Summary tile | Post opening stock |
Two of these ask before they commit:
- Import as Journal Entry opens a confirmation. The import commits when you click Confirm Import.
- Import Journal Entries can stop twice before it commits. If the file charges sales tax that the company has no tax set up for, it shows Set up sales tax from this file, where you click Create and import or Skip and import. If some lines match no item in your item list, it asks once before importing them without an item, and Continue commits.
To back out of a wizard step before committing, click Start Over.
What does not come into OurBooks
This list comes from importing a QuickBooks Desktop Pro Plus 2022 sample company into OurBooks and recording what the importer said about each record type. It describes what the importer does with each record type, not every export you could make. A record type that appears in a file with no rows is not listed.
In your IIF file
The preview lists most of these in an Unsupported panel before you import, so you are warned. The last row in the table is the one you are not warned about.
| In QuickBooks | What the importer does |
|---|---|
Reminders (TODO) | Ignored. The panel reads "Ignored. Not Currently Supported". |
Price levels (PRICELEVEL) | Ignored. The panel reads "Ignored. Not Currently Supported". |
Sales reps (SALESREP) | Ignored. The panel reads "Ignored. Not Currently Supported". |
Sales tax codes (SALESTAXCODE) | Ignored. The panel reads "Ignored. Tax status is imported on each customer". |
| Quantity on hand and total inventory value on items | Not imported. The items themselves import normally; their stock levels are dropped. Stock comes in later from the Inventory Valuation Summary tile on Import Data, and posts only when you click Post opening stock. |
| The price level assigned to each customer | Skipped without a message. The Unsupported panel lists the price-level definitions, not the customers they were assigned to. OurBooks has no price levels, so the assignments are not imported and nothing tells you. If you price by customer, write the assignments down from QuickBooks before you move. |
After an import, the result screen also notes:
- Items that QuickBooks stores as a percentage, such as a finance charge, import without a sales price.
- Some item types are skipped: subtotal, discount, payment and sales-tax items.
- An assembly or group imports without its component lines, because OurBooks keeps no bill of materials for it.
- Fixed assets move to the Fixed Asset Register, not the item list.
- If two accounts share a name, the importer warns you and shows a View duplicates button. A row that names a duplicated account by its short name alone is left unwritten.
๐ Note โ An IIF import creates no invoices or bills. The IIF file you export from your lists holds no transactions. Until OurBooks imports transactions from IIF files, bring in open AR and AP with the AR Aging Detail CSV and the AP Aging CSV, or with a Journal Detail import.
In your Journal Detail CSV
The Journal Detail preview has a Not imported panel. It says the following.
- The Payroll Item, SSN/Tax ID and Ship Date columns are not imported.
- A Name that matches no customer, supplier, employee or other name is imported with its amounts and accounts but without the name.
- Checks, credit card charges, sales receipts, sales tax payments, inventory adjustments, vendor credits and credit memos create no invoice or bill. Their Item, Qty and U/M appear on the journal entry line only.
- A unit of measure is imported only if it matches a unit already in your list by code or name. The import never creates a unit.
- Per-line tax and discount splits are not imported. For credit memos and sales receipts that carry tax, the breakdown by rate is not imported either, so that tax shows as unattributed on the tax reports.
- Cost lines assigned to customer jobs may include billable costs you have not yet invoiced. Export Unbilled Costs by Job and use the last wizard step to deal with them.
Zero-amount lines are skipped, and the preview warns you.
Reports with no importer
Some QuickBooks reports have no OurBooks importer, and the file is refused when you try one. Do not plan on importing these:
- Open purchase orders. Every row is a one-sided entry, so the Journal Detail import refuses it, with "Unbalanced" or "Journal entry must have at least 2 lines".
- Payroll detail. The Journal Detail import refuses it with "Could not detect required columns."
- Inventory Valuation Detail. The Journal Detail import refuses it with the same message. The Inventory Valuation Summary check accepts it but misreads it (see the Tip above), so do not use that tile for it either.
Keep those reports from QuickBooks as your record.
If a file is refused
What you see depends on when the file is refused and which step refused it.
When you load the file. A file the step cannot read is refused when you load or check it, before anything is imported, and the message says what the step expected. On the AR Aging step, for example, it reads "Could not detect required columns. Expected: Type, Date, Name, Open Balance." Export the report the step expects and load it again.
When you commit a Trial Balance, AR Aging or AP Aging import, or an IIF file of lists. An IIF file of lists holds no transactions, like the one this guide describes. If OurBooks saves none of it, the screen reads "Import rejected โ nothing was saved." and lists the reasons. Fix the file, then click Back to Upload and upload it again. If only part of it is rejected, the screen says how many items were saved and how many were rejected.
When you commit a Journal Detail import. Every Journal Detail import is sent in chunks; a small file is one chunk. The transactions in an IIF file, if it has any, are sent in chunks the same way. If OurBooks refuses a chunk, the screen says that nothing in that chunk was written and how many entries posted before it, and offers Resume from chunk n. The message gives the error and, when it can, the row that failed, which tells you whether the cause is in OurBooks or in the file. For a cause in OurBooks, fix the cause in OurBooks in another browser tab, because leaving the page drops the resume, then click Resume from chunk n. The "Import rejected" message does not appear when a Journal Detail chunk stops, except in the one case noted below.
โ ๏ธ Warning โ When a Journal Detail chunk is refused, resume rather than import the whole file again. Any chunks before the refused one are already posted. When the first chunk is refused, none are.
If you have left the page, or the cause is a row in the file itself (a resume sends the same rows again), fix the cause, in OurBooks or in the file, and import the file again. Importing the same history twice can double it (see Before you start): a re-import works only because the new run skips the entries already in your books. The preview says how many it will skip, so read the preview's skip count before you commit. As with overlapping Journals, OurBooks does not promise to catch every case.
If the run fails instead of being refused, what you see depends on why:
- If the chart of accounts or the opening trial balance changed after the preview, and nothing has been posted yet, a message says so and you return to the preview. Check the preview again, then import. If the fresh preview can't be loaded, the screen reads "Import rejected โ nothing was saved." instead. Click Back to Upload and import the file again.
- "may be partly posted โ check this import run in the journal list before importing again". Check that import run in the journal list before you import again.
- "nothing from chunk n was written". Another import was already running, so nothing from that chunk was written. Start the import again once it finishes. If earlier chunks posted, the new run relies on the same skip of entries already in your books, so read the preview's skip count before you commit.
When you commit the estimates or unbilled costs. The Import Open Estimates and Import Unbilled Costs steps show their own failure message, with a Back to Upload button.
Last updated: 2026-11-15 ยท OurBooks documentation
Next steps
No credit card required