Move from QuickBooks to BillingMart
Export customers, products and open invoices from QuickBooks Online or Desktop, import them, confirm your clients and send your first statements.
On this page
You can bring a QuickBooks business into BillingMart in an afternoon: your customers, your products and services, the invoices that are still open, your jobs, and your vendors and bills. Nothing is sent to anyone while you import. You check every count first, and your customers hear from you only when you choose.
For a focused guide to one product, see Switch from QuickBooks Online or Switch from QuickBooks Desktop. Moving from another system? Start at Switching to BillingMart.
Before you start: Finish your last QuickBooks work for the period, such as payments received today, so the open invoices you export match what customers owe.
Step 1: Export from QuickBooks Online
QuickBooks Online exports lists and reports to Excel or CSV. Save each one as a CSV file before you import it. Excel and Google Sheets can both save one.
- Customers. Open the customer list under Sales (or Get paid & pay, depending on your QuickBooks menu), and use its export button to export the list to Excel.
- Products and services. Open the products and services list and export it the same way.
- Open invoices. Under Reports, run the Open Invoices report, or an invoice list filtered to open invoices, and export it to Excel or CSV. Include the invoice number, customer, invoice date, due date and the line details.
- Vendors and bills. If you track what you owe, export the vendor list and your unpaid bills the same way.
Step 2: Export from QuickBooks Desktop
QuickBooks Desktop offers two kinds of file, and BillingMart takes both.
- IIF files for lists. Go to File, then Utilities, then Export, then Lists to IIF Files. Choose the customer list and select OK, then save the file. Do the same for the item list and the vendor list, one list at a time.
- CSV files for reports. Run the Open Invoices report and any unpaid bills report, then use Excel, then Create New Worksheet or Export, and choose a comma separated values (.csv) file.
Step 3: Import into BillingMart
- Open Import in the menu and choose what is in the file: clients, items, invoices or bills. Import clients first, then items, then invoices and bills, so each invoice finds its customer.
- Choose the file and select Read the file. Files exported from QuickBooks are recognized, and their columns are matched for you.
- On Match the columns, check each column. Choose Skip this column for anything you do not need. Suggest with AI can propose the matches. It sees your headings, never your values.
- Select Check the file. This is the dry run, and nothing has been written yet.
- Read the result, then select Import.
For invoices, the dry run also shows how many sends the import uses and how many your plan has left this month. If the import needs more than you have, it asks you to upgrade first, so an import never stops halfway. See What counts as a send.
The rules for each file, such as the 5 MB size limit, duplicates and rows that cannot be imported, are in Import clients from a file.
Choose how open invoices arrive
When you import open invoices, choose one of two options before the dry run.
| Option | What you get |
|---|---|
| Import open invoices as sent | Each open invoice 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. Payment reminders stay off unless you turn them on. |
| One opening balance per customer | Each customer gets a single opening balance, the total they owed as of a date. The date starts as the last date in the file, and you can change it. |
Import as sent when customers will pay invoice by invoice. Choose opening balances when you only need each account to start from the right figure.
Jobs, vendors and bills
- Jobs. QuickBooks names a job under its customer, such as "Rivera Homes:Kitchen remodel". Each job becomes a job record under that customer in BillingMart, and its invoices stay linked to it.
- Vendors. A vendor a bill file names that you do not have yet is created once, with its name.
- Bills. Bills arrive as drafts. Nothing is approved and nothing is paid until you do it.
Step 4: 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 to go through the imported list. For each client you can fix the name, address, email and phone, and then confirm the client.
Confirming is for the workspace owner. It asks for a recent sign-in and your second sign-in step, and each confirmation is recorded in the Activity log with you as the person who approved it. See Verified contacts and why a send is blocked.
Step 5: Send a welcome email (optional)
You can send your clients a welcome email under your business's name. It says you now bill through BillingMart and links to billingmart.com/portal, where they sign in with the email you have on file and see what they owe. You choose who gets it, and nothing is sent until you select send. See The customer portal.
Step 6: Get paid online
To take card 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.
Step 7: Send balance-forward statements
At the end of the month, send each client a statement. A statement starts from what the client owed at the start of the period, lists every invoice, payment and credit with a running balance, and ends with what is owed now. It shows how much of the balance is current and how much is past due, by age. The printed statement carries a Pay balance QR code. Your client scans it with a phone camera to pay what they owe. See Client statements.
Keep your accountant in the loop
If your accountant still works in QuickBooks, BillingMart can write your invoice lines and bill lines in QuickBooks Online's import layout. See Export from BillingMart to QuickBooks.
Related articles
- Switch from QuickBooks OnlineExport customers, products and open invoices from QuickBooks Online, import them, confirm your clients and send your first statement.
- Switch from QuickBooks DesktopExport your QuickBooks Desktop lists as IIF files, bring your open invoices as a CSV file, import them and confirm your clients.
- 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.
- 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.
- 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.
- The customer portalHow your customers sign in without a password, what they can see and do in the portal, and what it never shows them.
- Get your merchant account approvedHow to apply for your BillingMart Merchant Account, what you need, what the statuses mean, and how it goes live once approved.
- What counts as a sendWhich actions use up your monthly sends, which never do, and what still works when you reach your limit.
Still need help? Contact us
Tell us what you were trying to do, and the BillingMart team will take it from there.