Assign Account Details to GL Mapping Query Filters

Modified on Thu, 14 Oct 2021 at 02:15 AM


This guide will walk you through the process of assigning account-specific information to the generated GL Mapping Query Filters to the GL Export process knows how to properly map that data to your accounting platform and specific Chart of Accounts.

NOTE: This guide assumes you have already completed the steps in our article Generate Standard GL Mapping Query Filters.


Use the following steps to make use of the General Ledger Assignments report to edit the GL Mapping Query Filter account info for your Chart of Accounts.

  1. Log into your Cloud Retailer Back Office

  2. From the left-hand menu select Reports -> General Ledger Assignments

  3. Within this report:

    • The accounts should be grouped by Location

    • For each GL Mapping you wish to tie back to your accounting system:

      NOTE: GL Description and GL Type may already by set if the GL Mapping was generated from the Standard Accounting Integration.  You are free to alter these to suit your needs.
      • Set the GL Description column to the description you wish to be sent along with the data. 

      • Set the GL Code column to the account number you wish to map to in your accounting system.

      • Set the GL Type column to either Credit or Debit as appropriate for the type of mapping you are working with.

      • Settings take effect as soon as you leave the current field.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article