Skip to content
Help center home

Topics

Contact supportStart free

On billingmart.com

Help center

Switching to BillingMart / Switch from Bill.com

Explore here

Switch from Bill.com

Export vendors, bills, customers and invoices from Bill.com as CSV files, map their columns, import them and confirm your clients.

Last updated Web
On this page

Bring your Bill.com vendors and unpaid bills, and your customers and open invoices, into BillingMart. Nothing is sent to anyone while you import, and nothing is paid.

Before you start: Your Bill.com user role needs permission to sync with an accounting system, and to each kind of record you export. Finish the period's work first, such as payments made today.

Export from Bill.com

Bill.com exports records and transactions as CSV files.

  1. Go to Settings, then Import / Export.
  2. Select Export beside the records you want: vendors and customers, then bills and invoices. Choose or adjust the export profile, then export.
  3. Keep only the bills and invoices still open before you import them.

These steps follow BILL'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, so each invoice finds its client.

From Bill.com Import as
The vendors CSV file Vendors
The unpaid bills CSV file Bills (they arrive as drafts)
The customers CSV file Clients
The open invoices CSV file Open invoices

Bill.com files have no layout BillingMart recognizes, so each file goes through Match the columns. Check what each column is, and choose Skip this column for anything you do not need. Keep the columns below and skip the rest.

Keep this column It becomes
Name or company The client name
Email Email
Phone Phone
Address, city, state, ZIP, country The billing address
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
Vendor The vendor of a bill
Bill number, bill date, due date, amount The bill

Have only invoice totals? Map the amount still owed to the open balance column and import as sent: each invoice becomes one line for what is 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.

Bills arrive as drafts. Nothing is approved and nothing is paid until you do it.

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 Bill.com 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

Still need help? Contact us

Tell us what you were trying to do, and the BillingMart team will take it from there.