# Switch from Square Invoices > Export your Square customer directory as a CSV file, list your open invoices, map the columns, import them and confirm your clients. Source: https://support.billingmart.com/switching/square-invoices Updated: 2026-11-17 · Applies to: Web · Section: Switching to BillingMart Bring your Square customers and open invoices into BillingMart. Nothing is sent to anyone while you import. > **Before you start:** Finish the period's work in Square Invoices, such as payments received today, so the open invoices you export match what your clients owe. ## Export from Square Invoices Square exports its customer directory as a CSV file from Square Dashboard. 1. Sign in to Square Dashboard and go to **Customers**, then **Customer directory**, then **Directory**. 2. Select **Import / Export**, then **Export customers**. Choose all customers or specific groups, and select **Export**. 3. When the file is ready, select **Download**. For open invoices, use the export on your Square invoice list if your account shows one. Otherwise list them in a spreadsheet, one row per invoice, with the columns in the table below, and save it as a CSV file. See [Switch from a spreadsheet](https://support.billingmart.com/switching/spreadsheets.md). These steps follow Square'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, so each invoice finds its client. | From Square Invoices | Import as | | --- | --- | | The customers CSV file | Clients | | Your open invoices, as a CSV file | Open invoices | Square Invoices 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 | 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](https://support.billingmart.com/invoices/what-counts-as-a-send.md). The rules for every file, such as duplicates and rows that cannot be imported, are in [Import clients from a file](https://support.billingmart.com/clients/import-clients.md). ## 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](https://support.billingmart.com/clients/verified-contacts.md). ## 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](https://support.billingmart.com/clients/client-statements.md). ## 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](https://support.billingmart.com/payments/merchant-account.md). ## Keep your accountant in the loop Keep your Square Invoices 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](https://support.billingmart.com/getting-started/export-to-quickbooks.md).