QuickBooks is a popular accounting software used by many specialty retailers.  RICS integrates directly with QuickBooks to send daily general ledger information from closed POS batches.

Follow the step-by-step directions below to integrate RICS with QuickBooks Online.

• Enablement
• Connect to QuickBooks Online
• Mapping Accounts
• Financial Export

Enablement

Prior to connecting your RICS account to QuickBooks, please contact RICS Support to have a support team member activate the integration for your organization then follow the steps below.

1. Login to the Store Owner level of your RICS Backoffice
2. Navigate to Setup :: Users :: Manage Roles
3. Click on ‘LookUp’ in the Quick Lookup, without entering any data in the field
4. Locate the Role Name you wish to give access to QuickBooks; click ‘Select’

5. Scroll down the Permissions list to Setup : Store and click on the ‘QuickBooks Setup’ role

6. Click ‘Save’

Connect to QuickBooks Online

Before a user can start exporting to QuickBooks, the account must be linked to RICS using the steps outlined below.

1. Download the RICS QuickBooks Connector   (http://downloads.ricssoftware.com/partners/quickbooks/QuickBooksSetup.exe)
2. The file will appear at the bottom left corner of your screen if using Chrome, or the top right corner if using Edge

5. Follow the prompts to install the RICS QuickBooks Connector

Note: RICS QuickBooks Connector is necessary to connect your RICS Backoffice to QuickBooks Online.

6. Navigate to Setup :: Manage Store :: QuickBooks Setup
7. Type the Store Owner number into the ‘Store Number’ Quick Lookup field; click LookUp.
8. Select ‘Online’ from the QuickBooks Edition options
9. Click ‘Connect to QuickBooks’

9. Sign into QuickBooks using your existing User ID and Password

10. Close the QuickBooks sign-in window
11. Click ‘Load Accounts’ at the bottom of the page.

12. Click ‘Accounts’

13. Proceed to step 3 in Mapping Accounts below

MAPPING ACCOUNTS

A mapping tells the system which QuickBooks account to use for a certain piece of data. For example, the store owner might want the Cash tender to map to a particular checking account in QuickBooks.

RICS recommends setting up your QuickBooks mappings at the Store Owner level. When a mapping is defined at the Store Owner level, it will be inherited by each Store beneath it. Mappings can be updated at the store level as well, if needed.

1. Type the Store Owner number into the ‘Store Number’ Quick Lookup field; click LookUp.
2. Click ‘Accounts’

3. Map all Tenders and Transaction Types to their appropriate QuickBooks accounts by checking the box next to each and selecting the appropriate account from the dropdown on the right

4. Click ‘Save’
5. Repeat this process for each store by entering the Store Level number in the ‘Store Number’ Quick Lookup field.
6. Click 'Save' after setting the mappings for each store location.

FINANCIAL EXPORT

After mapping your accounts you may begin exporting to QuickBooks. Daily exports are available beginning from the day RICS Support enables your integration; any sales prior to this date are not available for export.

1. Login to the RICS Backoffice
2. Navigate to Reporting :: Financial Export
3. Click ‘New Export’

Note: An alert center message will appear informing you of how many records were exported to QuickBooks and for which locations

4. After clicking ‘OK’, an entry will appear in the drop-down at the top of the page with the date and time of the export

Note: An alert will come up if any of the tenders or transactions used on that day’s batch are not mapped in QuickBooks Setup. If you receive the alert shown below, please follow the Mapping Accounts steps outlined above.