Close
Quickbooks
WHAT IT IS

The Edge/QuickBooks integration posts aggregated sales and inventory data from The Edge to QuickBooks.

WHAT IT DOES

The Edge allows you to integrate features and map to your QuickBooks chart of accounts. It is required that every feature in The Edge be mapped to an appropriate account in your chart of accounts, even if you do not use this feature. This ensures all activity can be posted to QuickBooks, even if the feature is used some time in the future.

HOW IT WORKS

We have previously covered the QuickBooks Operational Summary that lists the several steps you must complete in order to properly integrate The Edge with your Quickbooks Company File. Now we are going to cover setups for some of the various tabs.
QuickBooks SetUp: General Tab
Select Administrative → QuickBooks → Set Up QuickBooks Integration. The QuickBooks Setup window will appear with the General tab open.
TAKE NOTE: Most Edge features post to accounts; no direct maintenance in QuickBooks is required. However, some features in The Edge post to an account in QuickBooks that may not represent the final step in bookkeeping. In these cases, The Edge has taken the financials as far as it can go and a direct QuickBooks maintenance procedure will be required.
The General tab contains three data entry fields:
  • Company File: Optional. If you specify a QuickBooks company file here, The Edge will launch QuickBooks when you attempt to post. If you leave this blank (which most do), The Edge will require you to have your QuickBooks Company File open before you can post.
  • POS “Customer”: The QuickBooks customer record to which all sales activity will be attributed. You should create a customer record in QuickBooks for this purpose and name it “POS,” for example.
TAKE NOTE: Over time, this single customer record in QuickBooks will accumulate a large amount of sales activity data and cause posting from The Edge to QB to take a long time. To prevent this, you can occasionally create a new customer record in QuickBooks and then link The Edge point of sale customer to that new customer record. Example: POS Customer 2017.
  • Maximum Number Length: To prevent errors related to reference numbers that are too long, this field should be set to 16 by default. Try 12 or 8 for older versions of QuickBooks.
Browse to these values using the drop-down menu and select the Accounts tab.
QuickBooks SetUp: Taxes Tab
The Taxes tab is for identifying the vendors, or governmental body, to whom sales tax is paid.
For each sales tax definition in The Edge:
  1. Select the tax.
  2. Select a tax vendor from the Tax “Vendor” drop-down list at the bottom of the window. For each definition, select the vendor on file that you write the tax payable check to, e.g., Department of Treasury.
  3. Click OK.
QuickBooks SetUp: Misc Items Tab
The Misc Items tab is used to associate each of your miscellaneous sales line definitions to a QuickBooks account. Whenever you sell via a miscellaneous sale line, the amount is posted to the corresponding G/L account, and an offsetting amount is posted to accounts receivable. Any tender is then in turn posted against the accounts receivable.
To associate an account: To associate an account:
  1. Select the desired miscellaneous category.
  2. Select an account from the QuickBooks Account drop-downlist.
  3. Click OK.
TAKE NOTE I: Check the Inactive Box to map any Misc Charges that have been used in the past.
TAKE NOTE II: Unlike other features in The Edge, we cannot control what Misc Sale lines are used for in daily operations. You may have some Misc lines setup as Credits (such as coupons) that should be mapped to expense-type accounts. Misc sale lines should typically be mapped to either an Income or Expense account. If you are not sure, you should consult your accountant.

EXPAND YOUR EDGE EDUCATION

Click the button below to launch EdgeUser.com for even more information on integrating QuickBooks, including setting up other tabs like Accounts, Inventory, Repair, Store, and more. And look for more email features on QuickBooks Procedures and Troubleshooting.