RB User Guide > Tools > QuickBooks Integrator

Importing credits & journal entries into QuickBooks

RB9 only

In addition to payments, you can import other types of transactions, such as credits, duplicate payments, refunds, voids, and write-offs (but not debit memos or miscellaneous payments), directly from RB9. However, you must import invoices before you can import these types of transactions since they 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 Credits/Journal Entries in the drop-down.

• *Post Date From/Post Date To

  Required. Default is today. Enter the date or date range (up tp 7 days) transactions were posted.
4. Click . RB9 lists all of the transactions other than payments that posted on the specified date.
5. Check the box in the header to select all of the transactions displayed or check individual boxes to select specific transactions.
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

Step-by-step instructions

• Preparing to use QuickBooks Desktop with RB9
• Importing entities into QuickBooks
• Importing invoices into QuickBooks
• Importing payments into QuickBooks
• Importing resource payroll checks into QuickBooks