Difference between revisions of "QuickBooks Export"

From Rts
Jump to: navigation, search
(Configuring File -> Options)
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
===Configuring File -> Options===
 
===Configuring File -> Options===
  
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/>  
+
[[File:QBE1.png|350px]]<br/><br/>  
  
''Note: The most frequently used Version in RTS is the '''QuickBooks Manual Report.'''''
+
<span style="color:#000080">''Note: The most frequently used Version in RTS is the '''QuickBooks Manual Report.'''''
  
2) Verify the location name is your location
+
2) Verify the location name is your location.
  
3) Set the '''Deposit Amount''' to be exactly how it is set up in QuickBooks
+
3) Set the '''Deposit Account''' to be exactly how it is set up in QuickBooks.
  
4) Under '''QuickBooks Version''', select your version of QuickBooks
+
4) Under '''QuickBooks Version''', select your version of QuickBooks.
  
 
===Accounts===
 
===Accounts===
  
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/>  
+
[[File:QBE2.png|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.
  
3) Repeat this step as needed
+
3) Repeat this step as needed.
  
 
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/>  
+
[[File:QBE3.png|350px]]<br/><br/>
  
 
===Allocation===
 
===Allocation===
  
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/>  
+
[[File:QBE4.png|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 39: 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/>  
+
[[File:QBE5.png|350px]]<br/><br/>  
  
''Note: IIF is the file extension of a QuickBooks File''
+
<span style="color:#000080">''Note: IIF is the file extension of a QuickBooks File''
  
 
===Viewing QuickBooks Data===
 
===Viewing QuickBooks Data===
  
1) Navigate in RTS to <code>Actions -> Export -> Deposit to IIF</code>
+
1) Navigate in RTS to <code>'''Actions -> Export -> Deposit to IIF'''</code>.
  
2) Check the deposit(s) that you would like to export
+
2) Check the deposit(s) that you would like to export.
  
3) Select '''Load Allocation''' to load the deposit information
+
3) Select '''Load Allocation''' to load the deposit information.
  
4) Select '''Export Data''' to view the information in QuickBooks
+
4) Select '''Export Data''' to view the information in QuickBooks.

Latest revision as of 15:05, 10 July 2019

Configuring File -> Options

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

QBE1.png

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.

QBE2.png

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.

QBE3.png

Allocation

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

QBE4.png

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.

QBE5.png

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.