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!!!
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
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
- 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,
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.