Skip to content
  • There are no suggestions because the search field is empty.

Export and import financials to QuickBooks Online

Export your invoice and payments and adjustment reports out of Passare and import to QuickBooks Online.


This export supports General Journal style accounting, not Invoice accounting.

✋ To import to QBO you must first purchase SaasAnt, a third-party converter tool. The lowest subscription works well for this.

Jump ahead to


Set up QuickBooks 

First, set up a new account in QuickBooks called Passare AR. This will act as a holding account for funds exported from Passare.

In QuickBooks, go to Accounting > Chart of Accounts > New.

New button in QuickBooks

 

Select the settings shown below and save.

Fill out details for Other Current Assets account

A few things to keep in mind:

  • Type the account name exactly as written here. It is case-sensitive and must match perfectly to import correctly.
  • If you use account numbers in QuickBooks, be sure to fill this in here. If you do not use account numbers, leave this field blank. 

 

If you collect sales tax, make sure your QuickBooks has automatic tax rate turned off.

To do this, go to Taxes > Sales Tax in the left menu. Then select Sales Tax Setting in the top-right.

Sales Tax Settings option in QuickBooks

 

Click Turn off sales tax.

Turn off sales tax button in QuickBooks

 

Choose yes to confirm.

Turn off sales tax confirmation 

Some settings need to be configured in Passare before moving on. Contact Passare Support at support@passare.com or (800) 692-5111 for help.

 

Export a Passare case

Before exporting, make sure the case(s) you wish to export are signed on Goods & Services.

 
Then go to Reports > System Reports in Passare.

Reports > System reports

 

Search and select QBO Export.

Search for QBO Export in System Reports

 

Select the following report settings:

  • Report Format: Excel CSV
  • Delivery Method: Run & Send to Download Center (you can also email the file if you prefer)
  • Date Range: Case(s) sign date range. You can select a predefined or custom range.
    • We recommend selecting export all items up to end date. This will export all un-exported items, including changes to older cases that fall outside the date range.
  • Filter Items to Be Exported: Export only un-exported items
  • Case: Select an individual case or leave as All Cases.
    • If this is your first time exporting, we recommend starting with one case.
  • Preview Export: 
    • Check this if you want to view the import without flagging data as exported.
      Do not import this file!
    • Leave unchecked when you are ready to import the file. Downloading the file while unchecked will flag data as exported.

QB export settings

 

If you like these settings and want Passare to save them, click Save Configuration. 

This will prompt you to name the configuration, then click Save.

Name a saved configuration

 

Once all report settings are selected, click Run Report. 

Next, go to Reports > Download Center (or email, whichever you selected as your Delivery Method).

Reports > Download center

 

Download the file and save to your computer.

Download report from the Download Center

 

Import to SaasAnt

Next, login to SaasAnt.

On their website, select Support & Login > SaasAnt Transactions (Online). Or, use this link.

Login to SaasAnt

 

Login using your login credentials.

Type in SaasAnt login credentials to access

 

Upload the import file and click Submit.

Browse file

Upload file and submit

 

On the next screen, select Journal Entries.

Journal Entries button in QuickBooks

 

Next, you will set up and save mappings. This step is only done once with your first import.


Map the following sections:

  • Account: Account Number
  • Description: Memo 1
  • Amount (Debit or Credit): Amount
  • Class: Class ID
  • Journal Date: Date

Map accounts in QuickBooks 1

Map accounts in QuickBooks 2

 

All mappings should have a green check mark.

Select More > Save Mapping to save these settings for future imports.

Save mapping button

 

Click on Import to QuickBooks at the bottom-right. You will see this screen while the file imports.

File imports in QuickBooks

 

Once the file imports successfully, go into QuickBooks to review the entry.

If you're having issues, check out our QBO troubleshooting article.

 

Review data in QuickBooks

In QuickBooks, use the search bar to view recent transactions or search for the case.

Search bar showing recent journal entries

 

You can also view the entry from Accounting > Chart of Accounts > Passare AR account.

Click on view register > journal entry > edit.

Click the journal entry to view details.

Journal entry details in QuickBooks

 

Need more information?

Need Help? Email us at support@passare.com or call 1-800-692-5111.