Skip to content
English
More support Customer portal
Contact us
  • There are no suggestions because the search field is empty.

QuickBooks Interface

 

QuickBooks is payroll management software that handles payroll, inventory, and sales. Advantage can produce QuickBooks compatible daily sales reports for CenterEdge customers. In QuickBooks, these entries will be called�CenterEdge Sales,�Daily Sales, or something similar under a customer account to which both applications have access. The�End of Day Balance Report�in Advantage is the model used to post daily information to QuickBooks.

Set up QuickBooks Desktop

Chart of Accounts

Category Sub-CategoriesCategory Accounts
  • Computed income account (i.e., bank accounts for cash, checks, and debit): This is where all your currency accepted in Advantage will be grouped.
  • Credit card accounts: Credit card types can be mapped into individual accounts or into individual credit card accounts.
  • Over/Short Account: Where any till over / shorts will be posted.
  • A/P Sales Tax Account: Sales tax accounts must be associated with a Vendor.

  • Adjustment Account: Posts daily discrepancies which have not been accounted for.

    QuickBooks requires that all General Journal entries debits and credits must balance to zero, so it is important to use this general purpose account so that the information can be posted into QuickBooks. A new Category / Sub-Category created in Advantage can cause discrepancies when sales are generated using the new categories without being mapped in QuickBooks.

  • A/R Account: Used for employee or customer purchases, as well as Groups event purchases, where charges will be collected at a later time.
    • QuickBooks does not allow posting to A/R Accounts in a General Journal entry, so the A/R account in QuickBooks must be set to Other Assets type of account.
  • Write Off Account: Employee purchases charged to A/R and then are written off as a payroll deduction or possibly a bad debt that is being written off will be posted into this account.
  • Other Deferred Revenue Account: Holding account for future sales.

QuickBooks requires that all General Journal entries debits and credits must balance to zero, so it is important to use this general purpose account so that the information can be posted into QuickBooks. A new Category / Sub-Category created in Advantage can cause discrepancies when sales are generated using the new categories without being mapped in QuickBooks.

Customers, Vendors, and Classes

Customers: You need to create one Customer to assign to Advantage, usually called CenterEdge.

Vendor: This would be something like the NC Department of Revenue, which you need to associate with sales tax accounts.

Classes: These are not enabled by default and aren't required, but are useful if you need QuickBooks to segregate Advantage data imported from multiple locations.

Enable the QuickBooks Interface

If the QuickBooks integration is installed, you can enable it for use in Manager Console.

Apps & features
  1. From Manager Console, click�Maintenance.
  2. Double-click�System Settings.
  3. Double-click�Modules.
  4. Open the�Interfaces�tab.
  5. Select�QuickBooks Interface.
  6. Click�OK.

Set Up QuickBooks in Advantage

  1. From Manager Console, click�Cash Control.

  2. Double-click�Accounting.

  3. Double-click�Settings.
  4. Select�QuickBooks .IIF Files�(IIF method) or�QuickBooks Direct�(direct method).
    The Export Types are described below.
  5. Select Enable Accounts Link, Enable Customers Link,�Enable Vendors Link, and�Enable Sales Link.
Export Types

Direct Method

The�Direct�import allows direct access between Advantage and QuickBooks for setup and sales data. When using the direct import method, all Advantage-QuickBooks functions must be performed on the same computer as the QuickBooks application is installed. This method cannot support multiple location data imports.

  1. From the Accounting Settings window you accessed above, click File Lookup.
  2. Browse to and select the QuickBooks company file.
  3. Click Open.

File Import (IIF Intuit Interface Format) Method

IIF are proprietary file types for storing QuickBooks information. The IIF import/export option is more time consuming, but allows all Advantage-QuickBooks functions to be performed on any computer, and multiple locations are supported (e.g., the customer can hire an off-site accountant). For companies with multiple locations, the corporate module can be used to pull IIF files for import into QuickBooks. All data, including the setup and daily sales reports must be exported from or imported to QuickBooks. Any changes made in QuickBooks must be exported from QuickBooks before they are imported into Advantage.

  1. From the Accounting Settings window you accessed above, click Directory Lookup.
  2. Browse to the folder where you store the .IIF files.
  3. Click Import next to the relevant categories below, and select the correct .IIF files.

G/L Mapping

  1. From the Accounting window, double-click G/L Import.

  2. Click�OK.
  3. Double-click�G/L Mappings.
  4. Connect the appropriate information with each account by selecting an associated G/L # from the pull-down lists.
    • Inventory accounts have Sales, Inventory, Cost and Waste G/L#s that can be individually assigned. You can associate entire inventory categories, sub-categories, or stock rooms to these G/L#s.
  5. Click�OK.
  6. Double-click Credit Card Account Mappings.
  7. Associate each Credit Card Type you use to a G/L Number.
  8. Click OK.
  9. Double-click Sales Summary Export to create a new journal entry in QuickBooks.
  10. Select a Starting Date for Update and an Ending Date for Update to choose what time frame to export.
    • Each day will be a separate entry.
  11. Click OK.

 

 

Can't Find What You're Looking For?