Quickbooks Integration-Accounting Integration

Accounting Interface

Focus Point of Sale can integrate into Quick Books and ACCPAC directly or QuickBooks compatible accounting applications.

Restrictions

The Accounting Interface will not automatically export. Once the Accounting Interface is configured you can generate a report that can be exported as a file, or emailed to the accounting department that can be imported into QuickBooks.

Process to Setup Accounting Interface

Step 1: Attain the Chart of Accounts

Step 2: Enter the Chart of Accounts

• Navigate to Miscellaneous>Accounting Interfaces

• Select the first unused interface option from the lefthand column. Once selected it will be highlighted in dark blue, and you can begin configuring the new accounting interface.

• In the NAME field type in the name you would like to use as a reference. Multiple accounting interfaces can be setup.

• In the TYPE dropdown select the type of accounting application you will be using.

• From the bottom transaction listing, select the first line (Line1) and use the Transaction Configuration area from above to map to the accounting application.
• From the SALES TYPE dropdown, select the type of transaction you would like to add to the export. Below is a listing of example Sales Types.

• In the ACCOUNT NUMBER field input either the account name exactly the same as listed in the accounting application or the account number.

• From the DEBIT/CREDIT dropdown select whether the entry will be a debit or credit against the account.

• Under VENDOR NAME you can enter a memo or description of the GL entry (i.e.:Beer Sales).

• Select the SAVE button to save your work, and if additional entries need to be made select the next line to add additional transactions.

Note: Since Focus reports the Net Sales on the DSR and accounting export if you wish for the gross sales to be reflected into your accounts you must also set all item level discounts (RGDisc–REPORTGROUPNAME) to credit to the same account as the corresponding Sales Accounts.

Step 3: Setup Accounting Interface Report Export

• Navigate to Reports>Setup

• Create a new report

• Name=Accounting Export

• Type=Daily Report

• File Format=Accounting Interface

• Accounting Interface=Name of Interface Created Above

• Select Daily Transactions

• Select the 'Output' tab

• Destination=E-mail

• File Name=%dAccountingExport.iif

• E-Mail Address=Email addresses of accounting department

- Select Save and Close

Step 4:Setup Interface Export to Email Accounting Department

• Navigate to Reports>Setup

• Create a new report

• Name=Accounting Email

• Type=Collection Report

• Date=Previous Business Date (or week or month, depending on accountant preference)

- Reports to Include in Collection=Accounting Export

Step 5: Create Time Range to send report if not sending daily

• Navigate to Miscellaneous>TimeRanges

• Create appropriate Time Range (if not sending every day)

• Navigate to Miscellaneous>Events

• Name=QB Interface

• Report=Accounting Export

• Options=Active

• Option 1 Daily:
• - Frequency=Once Daily Time=DesiredTime

• Option 2: Weekly/Monthly
• - Active Time=Time Range created above (if applicable)

• Select Save and Close

*PRO TIP*

QuickBooks Online DOES NOT accept iif files and the site will need to use a converter program. Here are a couple suggestions, we do not endorse either but resellers have had success with the programs:

Axis-Import Utility $195

https://appcenter.intuit.com/zed-axis-import-qbo?locale=en-US

Transaction Pro starts at 19.95/mo (30-day free trial)

https://appcenter.intuit.com/transactionproimporter?locale=en-us