How to Setup an Accounting Interface

Purpose

The procedure to create an Accounting Interface is listed below.

Procedure to Establish an Accounting Interface

▪ Retrieve the Chart of Accounts from QuickBooks.

▪ While in Focus Setup, select Miscellaneous > Accounting Interfaces.

▪ Select Line 1 in the Accounting Interface Window.

▪ Select the appropriate Sales Type for the QuickBooks account.

▪ Enter the QuickBooks account number into the Account Number field. Note: The Account Number entered is case-sensitive and must match the QuickBooks account number exactly.

▪ Repeat the process for the necessary Sales Types to complete the GL entry.

Example 1 Accounting Interface Setup

The following example is used when Item and Subtotal Discounts are used. The Report Group Discounts are added back into the Report Group Sales to calculate a gross dollar amount and then the Discount is debited for the entry.

Line	Account Number	Sales Type	Debit/Credit
1	Sales/Food	Sales – Food	Credit
2	Sales/Liquor	Sales – Liquor	Credit
3	Sales/Beer	Sales – Beer	Credit
4	Sales/Wine	Sales – Wine	Credit
5	Payment/Visa	Payments – Visa	Debit
6	Payment/MasterCard	Payments - MasterCard	Debit
7	Payment/AMEX	Payments – AMEX	Debit
8	Sales/Food	RG Discs. – Food	Credit
9	Sales/Liquor	RG Discs. – Liquor	Credit
10	Sales/Beer	RG Discs. – Beer	Credit
11	Sales/Wine	RG Discs. – Wine	Credit
12	Bar Comp	Discounts – Bar Comp	Debit
13	Manager Meal	Discounts – Manager Meal	Debit
14	15% Discount	Discounts – 15% Discount	Debit
15	Manager Comp	Discounts – Manager Comp	Debit
16	Paidouts	Paidouts – Misc	Debit
17	Paidins	Paidins – Misc	Credit
18	Gift Cards	Gift Cards	Credit
19	Net Cash	Net Cash	Debit
20	Tip Fee	Tip Fee	Credit
21	Refunds	Refunds	Debit
22	Sales Tax	Taxes – Food Tax	Credit