QuickBooks Desktop Export and Import

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

Jump ahead to


Download QuickBooks export

First, go to Reports > System reports.

Reports > System reports

Search and select QB Invoices.

QB invoices export

Under Start Date, check the box for Export all items up to the end date.

Under Filter Items to be Exported, select Export only un-exported items.

Export settings

Save Configuration to create a shortcut for future exports.

You’ll be prompted to name your configuration. Then Save again.

Save configuration button

To test the configuration, you can export one case at a time. Under Case, enter the case ID or decedent name.


Once you're comfortable with the configuration, you can leave All Cases checked.

Then Run Report.

Case selector in export settings

Follow the same steps as above for QB Payments and Adjustments report.

QB Payments & Adjustments export

Once you've run both reports, you can find them in Reports > Download center.

Download Center

 

Import IIF files into QuickBooks

To import files, you'll need to be in Single User Mode in QuickBooks. Importing IIF files is a permission setting - an admin can edit those permissions using the following link:
Create and Manage Roles in QuickBooks Desktop.

Once you've downloaded the reports from Passare, open QuickBooks and select File > Utilities > Import > IIF Files.

Screenshot of select utilities, import, IIF files

If you're using the 2019 or newer versions of QuickBooks, follow the steps below. If using a previous version, skip to selecting the file from downloads.


A pop-up will appear. You must select Import it for me. I’ll fix it later for the import to work.

Screenshot of button import for me. i'll fix it later

Select Import IIF.

Box around Import IIF

Under settings, go to This PC, select Downloads and open the Passare report you downloaded.

Screenshot of settings download menu on PC

If it imported successfully, you'll get this message.

Screenshot of success message

If you get a message that is NOT this, screenshot the message and send it along with the file you imported to support@passare.com, for us to research what caused the error.


Repeat these steps with any other files that need to be imported.  

View imported files

To view the imported files, go to Customers > Care Center in QuickBooks.

Screenshot of customers, care center

Search the customer’s last name, select the customer's name, and open the Invoice.

You'll see all the items imported. 

Invoice preview screenshot

If you imported the payments and adjustments report, select Apply Credits or Receive Payments to apply the imported payment to the Invoice in QuickBooks. 

screenshot of apply credits or receive payments

If you select Apply Credits, review the payments listed and make sure the box is checked.

Select Done.

apply credits screenshot

If you select Receive Payments, review the payments listed and make sure the box is checked.

Select Apply Credits.

Save & Close.

Screenshot of review payments with box around apply credits

 

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