Skip to content
English
  • There are no suggestions because the search field is empty.

Browser - Reports : GL Code Report

See the debits and credits behind each GL account for any date range

Overview

The GL Code Report shows the debits and credits behind each GL (General Ledger) account for the dates you pick. Accountants, bookkeepers and GMs use it to see which GL account each sale and payment maps to, and to find sales and other transactions that have no GL account set up. Those show as rows starting with Missing :. This article covers the Browser application.

Run the report
  1. Open Reports, then select GL Code Report from the list of reports. The screen opens titled GL CODE REPORT and starts on today's date.
    The GL Code Report screen with the filter row and results
  2. In Group By, choose Date or Chart Of Accounts.
  3. Set the date range you want to check.
  4. Select Search. To go back to today's date and Date grouping, select Clear.

The results have four columns: Memo, Account, Debit and Credit.

Find sales with no GL account
  1. Run the report for the day or range you are checking, with Group By set to Date. Grouping by Chart Of Accounts joins all the Missing : rows into one row.
  2. Look down the Memo column for rows that start with Missing :. These rows have a blank Account column.
    A Missing row with a blank Account column
  3. Read the name after Missing :. For a sale, it is the department and sub-department with no GL account set up. For example, Missing : Food-Appetizers means the Food department's Appetizers sub-department. For other transactions, it is the transaction type, and it can include the terminal location.
  4. Get a GL account set up for that sub-department or transaction type.
Export the report
  1. Run the report with the grouping and dates you want.
  2. At the bottom of the results, select the export you need. The first icon (the Excel logo) is Excel Export. The second (a document icon) is Banner Excel Export. Hover over an icon to see its name.
    • Excel Export downloads the report as you see it, with the Memo, Account, Debit and Credit columns.
    • Banner Excel Export downloads a different layout with Description, Fund, Account, Absolute_Amount_No_Negative and D_or_C columns. Use it only if your accounting system asks for that format.

    The two export icons below the results
Common Questions

Is this the same as GL Code Report V2 or the General Ledger Report?

No. GL Code Report V2, General Ledger Report, Muni GL Code Report and Oracle GL Code are separate reports with their own screens. The steps here apply only to GL Code Report.

Why don't I see GL Code Report in my list of reports?

The reports you see depend on the report access in your user role. If you need it, ask the person who manages roles at your facility.

What does a Missing : row mean?

Sales for that sub-department, or that transaction type, have no GL account to post to. The Account column on that row is blank.