System Interface Setup
To setup the system interface, use the following steps:
- From the shop management program, run
End of Day (EOD).
The End of Day should complete without any errors before you attempt to
export to QuickBooks!!!
-
Open QuickBooks.
-
Minimize QuickBooks.
-
Double-click the program's interface located on the desktop.
- QuickBooks - Application with No Certificate screen displays.
-
Check Yes, always; allow access even if QuickBooks is not running.
-
The interface checks to see if QuickBooks is set up correctly. This may take
some time.
-
Make sure that a customer does not have the same name as anyone in the Vendor
List or Others List in QuickBooks. Any errors that occur will result
in an Export Report.
-
Any errors will display the Results tab with a list of issues, otherwise
an Awaiting Your Command displays on the bottom left corner.
Export Settings Tab
-
Check Export ALL Sales or Charges ONLY.
-
If Export ALL Sales is checked, select:
- Itemized Cash Sales - where transactions get posted to a specific
customer
- Summarize Cash Sales - where transactions get posted
to a miscellaneous customer
-
Credit Cards can be broken up to track by name or type.
-
Chose to Update Cost of Goods Sold or not.
-
Select the Export Deliveries option. Check Update Inventory Assets (default.)
Expense Deliveries by Dept unlocks the General Expenses default account. If a delivery does not match a department code, it will go into general expenses. Otherwise, the department code can be transferred into whatever account is chosen.
-
After running End of Day (EOD), select Edit Dept Expense Accounts
and fill in the accounts for each department code.
-
Default Accounts is used to set a default account for Inventory Asset,
General
Expenses and Cost of Good Sold.
-
Check Export Credit Info back to SMS to export the credit information back to the program.
Cloud users leave this un-checked.
-
The path must be set to ACR\LIVE\DATA folder.
Bank Deposits Tab
-
From the left side, select the QuickBooks account that you want each of type of
sale to export into. Setting all four Undeposited Funds is most common.
-
From the right side, match the credit card names up with the payment type. For
cards with no name, select Credit.
-
Select a deposit account for each payment type (usually Undeposited Funds).
Continue on to Posting.