RB User Guide > Tools > QuickBooks Integrator

Importing payments into QuickBooks

RB9 only

Instead of recording deposits manually in QuickBooks, you can import payment transactions directly from RB9, including payment processing fees and surcharges. However, you must set up your business units’ financial accounts first, then import invoices before you can import payments since payments are applied to invoices in QuickBooks. (See Importing invoices into QuickBooks.)

1. Launch your QuickBooks and have the right company file open.
2. Tools > QuickBooks Integrator
3. In the Search By pane, specify the following filters:

• QuickBooks Data

  Select Receive Payments in the drop-down.

• *Post Date From/Post DateTo

  Required. Default is today. Enter the date or date range (up tp 7 days) payments were posted.
4. Click . RB9 lists all of the payments posted on the specified date.
5. Check the box in the header to select all of the payments displayed or check individual boxes to select specific payments.
6. Choose Import to QuickBooks.

IMPORTANT: Always open QuickBooks & company file before importing

Having QuickBooks and/or the company file closed when you attempt to connect will drastically increase the amount of time taken when importing data to QuickBooks(over 300%). It can also cause errors.

It is possible to connect with these closed, however all requests to the company file must first go through QuickBooks, which means QuickBooks must be launched in the background for each query.  It will always be fastest to connect with QuickBooks already running.

Reference

• QuickBooks preferences
• Business units

Step-by-step instructions

• Preparing to use QuickBooks Desktop with RB9
• Importing entities into QuickBooks
• Importing invoices into QuickBooks
• Importing credits & journal entries into QuickBooks
• Importing resource payroll checks into QuickBooks
• Troubleshooting QuickBooks Integrator
• Selecting BU financial accounts