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.
Select the settings shown below and save.
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.
Click Turn off sales tax.
Choose yes to confirm.
✋ 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.
Learn more about signing the Goods & Services page.
Then go to Reports > System Reports in Passare.
Search and select QBO Export.
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.
- Check this if you want to view the import without flagging data as exported.

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.
Once all report settings are selected, click Run Report.
Next, go to Reports > Download Center (or email, whichever you selected as your Delivery Method).
Download the file and save to your computer.
Import to SaasAnt
Next, login to SaasAnt.
On their website, select Support & Login > SaasAnt Transactions (Online). Or, use this link.
Login using your login credentials. 
Upload the import file and click Submit.

On the next screen, select Journal Entries.
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


All mappings should have a green check mark.
Select More > Save Mapping to save these settings for future imports.
Click on Import to QuickBooks at the bottom-right. You will see this screen while the file imports.
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.
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.
Need more information?
Need Help? Email us at support@passare.com or call 1-800-692-5111.