QuickBooks Export

QuickBooks Export

Configuring File -> Options

1) Navigate to File -> Options and select the Accounting tab.



Note: The most frequently used Version in RTS is the QuickBooks Manual Report.

2) Verify the location name is your location.

3) Set the Deposit Account to be exactly how it is set up in QuickBooks.

4) Under QuickBooks Version, select your version of QuickBooks.

Accounts

1) Navigate to Setup -> Accounting -> Accounts. A blank window will appear.



2) Add the accounts that are already configured in QuickBooks by selecting the Add button.

3) Repeat this step as needed.

4) You may also edit and delete existing accounts listed by highlighting the account. Close when done.



Allocation

1) Navigate to Setup -> Accounting -> Allocation This will prompt a window of your current subtotals, accounts previously configured and allocations.



2) Highlight the subtotal/item and then select the account it should be associated with.

3) Click Add. This will then add the subtotal and account as an allocation.

4) These steps will need to be repeated for all accounts that are already set up in QuickBooks.



Note: IIF is the file extension of a QuickBooks File

Viewing QuickBooks Data

1) Navigate in RTS to Actions -> Export -> Deposit to IIF.

2) Check the deposit(s) that you would like to export.

3) Select Load Allocation to load the deposit information.

4) Select Export Data to view the information in QuickBooks.


Note For Possible Issues: Subtotal Name needs to be less than 15 Characters for the allocation to work properly when assigning Categories.

    • Related Articles

    • QuickBooks Online Integration Setup

      Setting Up QuickBooks Online Exports With RTS RTS now has integration with QuickBooks Online so you can export your deposit information into the service both manually and automatically. The process of linking your QuickBooks Online account and ...
    • New Customer Setup Checklist

      New Customer Setup Checklist This document is designed to assist you with your RTS setup. The steps highlighted in red are critical for the RTS setup, while those highlighted in green represent additional features available with your licensing ...