Switch from QuickBooks Desktop
Export your QuickBooks Desktop lists as IIF files, bring your open invoices as a CSV file, import them and confirm your clients.
On this page
Bring your QuickBooks Desktop customers, items, vendors and jobs, and your open invoices, into BillingMart. Nothing is sent to anyone while you import. For the overview of both QuickBooks products, see Move from QuickBooks to BillingMart.
Before you start: Sign in to your QuickBooks Desktop company file as an admin, and finish the period's work, such as payments received today.
Export from QuickBooks Desktop
QuickBooks Desktop exports its lists, such as customers, items and vendors, as IIF files. It does not export transactions such as invoices as IIF, so your open invoices come across as a CSV file.
- Go to File, then Utilities, then Export, then Lists to IIF Files. On a Mac, go to File, then Export, then Lists to IIF File.
- Select the customer list and select OK, then choose where to save the file and select Save. Do the same for the item list and the vendor list.
- For open invoices, go to Reports, then Reports Center, and open the Open Invoices report. Select Excel, then Create New Worksheet, and save the worksheet as a CSV file.
Jobs come with the customer list: QuickBooks names a job under its customer, such as "Rivera Homes:Kitchen remodel", and each one becomes a job under that client in BillingMart.
These steps follow Intuit's own help pages. Checked 2026-11-16. Menus change; if yours differ, look for the export option on each list.
Import into BillingMart
Open Import in the menu and choose what is in the file. Import clients first, then products and services, then open invoices, vendors and bills and jobs, so each invoice finds its client.
| From QuickBooks Desktop | Import as |
|---|---|
| The customer list IIF file | Clients (and the jobs under each customer) |
| The item list IIF file | Products and services |
| The vendor list IIF file | Vendors |
| The open invoices CSV file | Open invoices |
BillingMart reads QuickBooks Desktop IIF list files as they are: customers, items and vendors, with their fields matched for you.
| Keep this column | It becomes |
|---|---|
| Invoice number | Invoice number |
| Customer or client | The client |
| Invoice date | Invoice date |
| Due date | Due date |
| Line description or item | The invoice line |
| Rate or price, and quantity | The line amount |
| Amount due or balance | What is still owed |
Select Read the file, then Check the file. That is a dry run: it shows every count and writes nothing. Then select Import.
For open invoices, choose Import open invoices as sent. Each one becomes a real BillingMart invoice with its original number, invoice date and due date, and the amount still owed. Nothing is emailed to your clients, and payment reminders stay off until you turn them on. Importing invoices as sent counts each one as a send; the dry run shows how many before anything is written. See What counts as a send.
The IIF files need no column matching. The open invoices CSV file goes through Match the columns; keep the columns in the table above.
The rules for every file, such as duplicates and rows that cannot be imported, are in Import clients from a file.
Check your data
Open Settings, then Data health, and select Start. It reads your clients, open invoices and payments, and lists anything to fix, each with a link to where you fix it.
Review and confirm clients
Contacts from a file arrive unverified, so BillingMart cannot yet send them statements or open the portal for them. Open Review and confirm clients and go through the imported list: fix names, addresses, emails and phone numbers, then confirm each client. Then, if you like, send a welcome email under your business name. It tells your clients you have moved and links to the portal, where they see what they owe. See Verified contacts and why a send is blocked.
Your first statement
At the end of the month, send each client a balance-forward statement. It starts from what the client owed, lists every invoice, payment and credit with a running balance, and shows how much is past due, by age. The printed statement carries a Pay balance QR code your client scans to pay. See Client statements.
Get paid online
To take card and bank payments, apply for a merchant account. Until it is live, invoices and statements still go out, and you can record cash, check and bank transfer payments. See Get your merchant account approved.
Keep your accountant in the loop
Keep your QuickBooks Desktop exports for your records. If your accountant works in QuickBooks, BillingMart writes your invoice and bill lines in QuickBooks Online's import layout. See Export from BillingMart to QuickBooks.
Related articles
- Switching to BillingMartWhat moves when you switch, what stays behind, the order of work, and a guide for the system you use today.
- Import clients from a fileBring your client list in from a CSV file, how the columns are matched, what happens to duplicates and bad rows, and what to expect afterwards.
- What counts as a sendWhich actions use up your monthly sends, which never do, and what still works when you reach your limit.
- Verified contacts and why a send is blockedWhat a verified email or phone means, the three ways a contact becomes verified, what an unverified contact can and cannot receive, and why a send is held back.
- Client statementsShow one client's account for a month or a year, download or email it, where customers read it in the portal, and why a statement is held back.
- Move from QuickBooks to BillingMartExport customers, products and open invoices from QuickBooks Online or Desktop, import them, confirm your clients and send your first statements.
- Export from BillingMart to QuickBooksGive your accountant your invoice lines and bill lines in QuickBooks Online's import layout, and every other record as a CSV file.
Still need help? Contact us
Tell us what you were trying to do, and the BillingMart team will take it from there.