Skip to main content
Try for free

GL Mappings

GL Transaction Mappings tell Cetec which general-ledger account each posting goes to, for every kind of transaction (invoices, receipts, vouchers, payments and so on). They drive your ledger, P&L, balance sheet and the other financial reports.

Updated Nov 9 2026

Before you start

  • GL Transaction Mappings is under Admin > Config Settings. The menu item is shown to the Admin role by default, and the page needs the Can Edit Config Settings function (Config Settings role by default; Admin always). Without it Cetec shows Admin Access Required!.
  • Saving a mapping needs the Admin role.
  • Set up your chart of accounts first; you can only map to accounts that exist.
  • Consult your CPA to make sure each posting goes to the right account.
  1. Review the transaction mappings

    1. Go to Admin > Config Settings > GL Transaction Mappings. The page is titled GL Transaction Mapping.
    2. Each row is a Transaction (for example Ar Payment, Receipt, Voucher, Warehouse Transfer). Status shows how many of its postings have an account, such as 7 / 7 Set.
    3. Click a Transaction to see and set its postings.
  2. Set the account for a posting

    1. Open Admin > Config Settings > GL Transaction Mappings and click the Transaction. The page is titled GL Transaction Mapping - Edit transaction.
    2. Find the posting by its Description. Descriptions name the document that posts, not the transaction row you clicked (on Ar Payment they read Customer Payment - …), and a page can include a related transaction's posting (Progress Invoice starts with *External Invoice
      • Debit Full Amount To*). Info shows the Suggested/Default Account: (the account Cetec looks for by name when nothing is set) and the Type. A red Account cell showing (select account) means no account is set and your chart has no account with the suggested name, so pick one yourself.
    3. Pick the account in the Account list (type to search; accounts show as number name) and click Set on that row. Picking alone saves nothing. Set saves at once; Cetec shows Set! Value is followed by the account's id.
    4. To map one warehouse location differently, choose it in Location To Map and click Submit. Cetec shows Setting Mapping For Transactions From Location … Only and adds - <location> to each description. Submit only reloads the rows for that location; they start with the same accounts as All. Set each row with its own Set.
    5. Back To All GL Transactions opens the older transaction list. To get back to the current one, use Admin > Config Settings > GL Transaction Mappings again.

Related

How-tos
Blog Posts
Docs