Mapping General Ledger Accounts

After you map POS, Cash, and Billing general ledger accounts, you can export the posted general ledger transactions to import into your accounting system.

For multitenant environments, the following setup must be completed for each company. The parent company setup is not automatically applied to individual companies.

To map general ledger accounts

  1. In AcuityLogic Admin, click Company and select Company Setup.
  2. In the Company Information window, click the GL Setup link.
  3. From the Source drop-down list, select POS, Cash or Billing.
  4. To export general ledger transaction types and information and view them in a Microsoft Excel spreadsheet, click Export.
  5. Click Edit next to a transaction type.
  6. To map a transaction type by an account and record a general ledger account number:
    1. From the Account Mapping column drop-down list, select Account.
    2. From the GL Account Number column drop-down list, select a general ledger account number for the transaction type.
    3. Click Update.
  7. To map a account type by an item type and record a general ledger account number:
    1. From the Account Mapping column drop-down list, select Item Type.
    2. Click Map Item Types.

      The GL Setup by Item Type window opens.

    3. To assign the same general ledger account number to all item types associated with the account type, select a general ledger account number from the Sales Account Number drop-down list and click Apply to all Item Types.
    4. To select a different general ledger account number for an item type, click Edit next to the item type in the table, select a new general ledger account number from the Sales GL Account Number column drop-down list, and click Update.
      You can set up category exceptions for each item type. See Setting Up General Ledger Exceptions.
    5. Click Return to close the window.
    6. Click Update.
  8. To determine the general ledger account number that will be used when exporting these inventory general ledger transactions, from the Center Mapping column drop-down list, select one of the following options and click Update:
    • Select Office to use the office’s general ledger center code. This option allows you to post to different general ledger accounts at different office locations.
    • Select Company to use the company’s general ledger center code.
  9. Click Return.

Related Topics