1. Home
  2. Knowledge Base
  3. Reports
  4. All Reports
  5. Invoices by GL Account Code Report
  1. Home
  2. Knowledge Base
  3. Reports
  4. All Reports
  5. Invoicing
  6. Invoices by GL Account Code Report
  1. Home
  2. Knowledge Base
  3. Reports
  4. Invoices by GL Account Code Report
  1. Home
  2. Knowledge Base
  3. Accounting
  4. Invoices by GL Account Code Report

Invoices by GL Account Code Report

The Invoices by GL Account Code report gives a list of invoices between selected dates with their amounts classified by the accounting code assigned in Abtrac.

It’s used to reconcile Abtrac invoices to your accounting software, and provides profitability analysis by revenue codes. (also known as a GL Account Code, Sales, or Income codes).

How to generate the Invoices by GL Account Code Report

Go to Reports >> Performance Reports >> Invoicing >> click on Invoices by GL Account Code and select the required date range.

You can also optionally filter and/group this report by Office, Project Team, Client, Project, Job Owner 1, Job Owner 2 and Project Type.

Now click on the ‘Report Options’ button and select one of the preview options. A ‘Choose Additional Report Options’ box appears.

Select the required options and click on the print button in the box to see a preview of ‘Invoices by GL Account Code’ report.

Understanding the Data

The Invoices by GL Account Code shows the following information –

  • Invoice No
  • Client Name
  • Project (Project Code)
  • Description (Project Description)
  • Assigned GL codes and
  • Grand Total (of invoice amount)
  • Total Time Value Allocated
  • Profitability

Invoice No

The Invoice No comes from the Invoices >> Load Invoices page

Client Name

From the Clients, Contacts & Projects(Jobs) >> Search Clients and Projects(Jobs) >> click on a Contact Name to go into the ‘Details for’ page for that client. the client name comes from the Name field in this page.

Project and Description

From the Clients, Contacts & Projects(Jobs) >> Search Clients and Projects(Jobs) >> click on a Project Code to go into the Project Details page for that project >> the Project (Project Code) and Description (Project Description) come from this page.

Assigned GL codes

From Invoices >> Load Invoices >> click on an invoice number to go into Invoice Management page. The ‘GL Account Code’ in the report comes from the ‘GL Account Code’ entered in this box. You can change the default GL Account Code here.

How GL codes are assigned to an invoice and invoice lines

For the individual invoice lines, the GL account code can be changed in the ‘Create/Edit Invoice Line’ box from the ‘Invoice Lines, Narratives and Amounts’ section.

Click on ‘Invoice Lines, Narratives and Amounts’.

Click on the pencil edit button for any invoice line and the ‘Create/Edit Invoice Line’ box appears. The required ‘GL Account Number’ can be selected from the dropdown menu, if different from the default.

GL Account Numbers assigned to invoice lines form the link between your accounting software and Abtrac. In your accounting software they can also be called Sales codes, or Income codes.

You can assign different account codes for each line on an invoice.

These account codes might be assigned automatically if you have preset default codes. For example each office, department, job type, job stage/task, or disbursement can be set to go to a different accounts code.

See Disbursements Types and Assigning GL codes to Disbursements.

You can learn more about setting up GL Account numbers in Abtrac here:

Grand Total

‘Grand Total’ is the total of the amounts invoiced between selected dates for various projects.

Total Time Value Allocated

‘Total Time Value Allocated’ shows the total amount of time and cost entered between selected dates for the various projects.

The ‘Time Value Allocated’ for the individual invoice comes from the ‘Assigned Time and Disbs’ page.

From Invoice Management page >> click on the Report Options button on the top of the page >> select ‘Assigned Time and Disbs’ from the dropdown menu to go into Assigned Time and Disbursements of Invoice page.

The ‘Time Value Allocated’ for this invoice comes from the total of the ‘Charge Extension’ column in this page. Charge extension is calculated as the charge rate multiplied by the number of units.

Charge Extension = Charge Rate x No. of Units

Profitability

Profitability is calculated as the percentage of ‘Grand Total’ over ‘Total Time Value Allocated’.

Profitability = (Grand Total ÷ Total Time Value Allocated) x 100

Abtrac KB# 2146

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support