Difference between revisions of "QuickBooks Export"

From Rts
Jump to: navigation, search
(Created page with "===Configuring File -> Options=== 1) Navigate to <code>File -> Options </code> and select the '''Accounting''' tab. ''Note: The most frequently used Version in RTS is the...")
 
Line 3: Line 3:
 
1)  Navigate to <code>File -> Options </code> and select the '''Accounting''' tab.
 
1)  Navigate to <code>File -> Options </code> and select the '''Accounting''' tab.
  
 
+
[[File:QBE1.JPG|350px]]<br/><br/>
  
 
''Note: The most frequently used Version in RTS is the '''QuickBooks Manual Report.'''''
 
''Note: The most frequently used Version in RTS is the '''QuickBooks Manual Report.'''''
Line 17: Line 17:
 
1) Navigate to <code>Setup -> Accounting -> Accounts</code>  A blank window will appear.
 
1) Navigate to <code>Setup -> Accounting -> Accounts</code>  A blank window will appear.
  
 +
[[File:QBE2.JPG|350px]]<br/><br/>
  
 
2) Add the accounts that are already configured in QuickBooks by selecting the '''Add''' button.
 
2) Add the accounts that are already configured in QuickBooks by selecting the '''Add''' button.
Line 24: Line 25:
 
4) You may also edit and delete existing accounts listed by highlighting the account.  '''Close''' when done.
 
4) You may also edit and delete existing accounts listed by highlighting the account.  '''Close''' when done.
  
 
+
[[File:QBE3.JPG|350px]]<br/><br/>
  
 
===Allocation===
 
===Allocation===
Line 30: Line 31:
 
1) Navigate to <code>Setup -> Accounting -> Allocation</code>  This will prompt a window of your current subtotals, accounts previously configured and allocations.
 
1) Navigate to <code>Setup -> Accounting -> Allocation</code>  This will prompt a window of your current subtotals, accounts previously configured and allocations.
  
 
+
[[File:QBE4.JPG|350px]]<br/><br/>
  
 
2) Highlight the subtotal/item and then select the account it should be associated with.
 
2) Highlight the subtotal/item and then select the account it should be associated with.
Line 38: Line 39:
 
4) These steps will need to be repeated for all accounts that are already set up in QuickBooks.
 
4) These steps will need to be repeated for all accounts that are already set up in QuickBooks.
  
 
+
[[File:QBE5.JPG|350px]]<br/><br/>
  
 
''Note: IIF is the file extension of a QuickBooks File''
 
''Note: IIF is the file extension of a QuickBooks File''

Revision as of 20:01, 15 March 2019

Configuring File -> Options

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

350px

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 Amount 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.

350px

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.

350px

Allocation

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

350px

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.

350px

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