GL Entry inquiry

This inquiry contains the entries for all the accounts that appear on your company's financial reports. Because the GL Entry inquiry can be quite large, you may want to set conditions on the inquiry so that only the information you want appears.

Use this inquiry to see information for your GL entries, such as accounting date, amount, session, department, and account.

If needed, you can add predefined columns and view supplemental information such as the transaction, project, employee, client, vendor, and bank.

Using the inquiry

From the > Reports menu, click Standard inquiries > General Ledger > GL Entry.

Audience

Accounting staff

Standard columns

Column Links to this inquiry Description Date range available

Type

 

The type of GL entry produced by the session task

Examples: Bank Entry, Beginning Balances, Billed, Cost, Payroll Payment, Premium Cost

 

Accounting Date

 

The date Ajera uses to determine the period for which the GL entry appears on financial statements

 

Amount

 

The total amount of the GL entry

x

Accrual Department

Department

The accrual department associated with the GL entry

 

Accrual Account

GL Account

The accrual account associated with the GL entry

 

Cash Basis Department

Department

The cash basis department associated with the GL entry

 

Cash Basis Account

GL Account

The cash basis account associated with the GL entry

 

Session Task

Session

The session task that resulted in the GL entry; indicates where the GL entry was made in Ajera

Examples: Client Invoices, In-house Expenses, Journal Entries, Process Payroll, Time & Expenses, Vendor Invoices, Vendor Payments

 

Project ID & Description

Project

The ID and description of the project associated with the GL entry

 

Predefined columns

You can add predefined columns to this inquiry. Many columns are available, organized in these categories:

Column Links to this inquiry Description Date range available

General info:

GL Entry Key

 

The database identifier of the GL entry

 

Accrual Department Key

Department

The database identifier of the accrual department associated with the GL entry

 

Accrual Company Key

 

Multi-company only. The database identifier of the accrual company associated with the GL entry

 

Accrual Company Name

 

Multi-company only. The name of the accrual company associated with the GL entry

 

Accrual Account Key

GL Account

The database identifier of the accrual account associated with the GL entry

 

Accrual Account ID

GL Account

The ID of the accrual account associated with the GL entry

 

Cash Basis Department Key

Department

The database identifier of the cash basis department associated with the GL entry

 

Cash Company Key

 

Multi-company only. The database identifier of the cash basis company associated with the GL entry

 

Cash Company Name

 

Multi-company only. The name of the cash basis company associated with the GL entry

 

Cash Basis Account Key

GL Account

The database identifier of the cash basis account associated with the GL entry

 

Cash Basis Account ID

GL Account

The ID of the cash basis account associated with the GL entry

 

Transaction Key

 

The database identifier of the transaction associated with the GL entry

 

Transaction Date

 

The date of the transaction associated with the GL entry

 

Control Account Type

 

The type of control account associated with the GL entry

Examples: Accounts Payable, Cash, Payroll, WIP

 

Is Current

 

Indicates if GL entry is current

As you make changes in Ajera, GL entries may be rewritten to reflect that change.

Non-current GLs show history.

 

Is Beginning Balance

 

Indicates if GL entry is the result of a beginning balance session task

 

GL Offset Key

 

Matches debit to credit GL entries when they have a one-to-one relationship

 

Is Accrual Intercompany Account

 

Multi-company only. Indicates if GL entry is an accrual intercompany entry

 

Is Cash Intercompany Account

 

Multi-company only. Indicates if GL entry is a cash intercompany entry

 

Session:

Session Key

Session

The database identifier of the session associated with the GL entry

 

Project:

Project Key

 

The database identifier of the project associated with the GL entry

 

Project ID

 

The ID of the project associated with the GL entry

 

Project Description

Project

The name of the project associated with the GL entry

 

Project - Project Type Key

Project Type

The database identifier of the project type associated with the GL entry at the project level

 

Project - Project Type

Project Type

The project type associated with the GL entry at the project level

Examples: Residential, Commercial, Interiors

 

Project Company Key

 

Multi-company only. The database identifier of the company associated with the project

 

Project Company Name

 

Multi-company only. The name of the company associated with the project

 

Phase Key

Phase

The database identifier of the phase associated with the GL entry

 

Phase ID

Phase

The ID of the phase associated with the GL entry

 

Phase Description

Phase

The name of the phase associated with the GL entry

 

Phase ID & Description

Phase

The ID and description of the phase associated with the GL entry

 

Phase - Project Type Key

Project Type

The database identifier of the project type associated with the GL entry at the phase level

 

Phase - Project Type

Project Type

The project type associated with the GL entry at the phase level

Examples: Residential, Commercial, Interiors

 

Activity Key

Activity

The database identifier of the activity associated with the GL entry

 

Activity Description

Activity

The description of the activity associated with the GL entry

Examples: Administration, Billable Time, Fees & Permits, Meetings, Mileage, Photocopies, Vacation

 

Activity Type

 

The type of activity associated with the GL entry

Examples: Consultant, Expense, Labor

 

Employee:

Employee Key

Employee

The database identifier of the employee associated with the GL entry

 

Employee Name

Employee

The name of the employee associated with the GL entry

 

Employee Type Key

Employee Type

The database identifier of the employee type associated with the GL entry

 

Employee Type Description

Employee Type

The description of the employee type associated with the GL entry

Examples: Administration, Architect, Employee, Principal

 

Employee Company Key

 

Multi-company only. The database identifier of the company linked to the employee associated with the GL entry

 

Employee Company Name

 

Multi-company only. The name of the company linked to the employee associated with the GL entry

 

Timesheet Key

Timesheet

The database identifier of the timesheet associated with the GL entry

 

Timesheet Row

Timesheet Detail

The timesheet row associated with the GL entry

 

Timesheet Date

Timesheet

The end date of the timesheet associated with the GL entry

x

Timesheet Company Key

 

Multi-company only. The database identifier of the company linked to the timesheet associated with the GL entry

 

Timesheet Company Name

 

Multi-company only. The name of the company linked to the timesheet associated with the GL entry

 

Expense Report Key

Expense Report

The database identifier of the expense report associated with the GL entry

 

Expense Report Row

Expense Report Detail

The expense report row associated with the GL entry

 

Expense Report Date

Expense Report

The end date of the expense report associated with the GL entry

x

Expense Report Company Key

 

Multi-company only. The database identifier of the company linked to the expense report associated with the GL entry

 

Expense Report Company Name

 

Multi-company only. The name of the company linked to the expense report associated with the GL entry

 

Journal Entry Key

 

The database identifier of the journal entry associated with the GL entry

 

Journal Entry Reference

 

The reference ID of the journal entry associated with the GL entry

 

Journal Entry Description

 

The description of the journal entry associated with the GL entry

 

Journal Entry Company Key

 

Multi-company only. The database identifier of the company linked to the journal entry associated with the GL entry

 

Journal Entry Company Name

 

Multi-company only. The name of the company linked to the journal entry associated with the GL entry

 

In-house Expense Company Key

 

Multi-company only. The database identifier of the company linked to the in-house expense associated with the GL entry

 

In-house Expense Company Name

 

Multi-company only. The name of the company linked to the in-house expense associated with the GL entry

 

Client:

Client Invoice Key

Client Invoice

The database identifier of the client invoice associated with the GL entry

 

Client Invoice Date

Client Invoice

The date of the client invoice associated with the GL entry

x

Client Invoice Number

 

The ID of the client invoice associated with the GL entry

 

Client Key

Client

The database identifier of the client associated with the GL entry

 

Client

Client

The name of the client associated with the GL entry

 

Client Type Key

Client Type

The database identifier of the client type associated with the GL entry

 

Client Type

Client Type

The client type associated with the GL entry

Examples: Builder, Government, Hospital

 

Vendor:

Vendor Invoice Key

Vendor Invoice

The database identifier of the vendor invoice associated with the GL entry

 

Vendor Invoice Date

Vendor Invoice

The date of the vendor invoice associated with the GL entry

x

Vendor Invoice Number

 

The ID of the vendor invoice associated with the GL entry

 

Vendor Invoice Description

 

The information in the Description field on the vendor invoice associated with the GL entry

 

Vendor Invoice Notes

 

The information in the Notes field on the vendor invoice associated with the GL entry

 

Vendor Invoice Company Key

 

Multi-company only. The database identifier of the company linked to the vendor invoice associated with the GL entry

 

Vendor Invoice Company Name

 

Multi-company only. The name of the company linked to the vendor invoice associated with the GL entry

 

Vendor Key

Vendor

The database identifier of the vendor associated with the GL entry

 

Vendor

Vendor

The name of the vendor associated with the GL entry

 

Vendor Type Key

Vendor Type

The database identifier of the vendor type associated with the GL entry

 

Vendor Type

Vendor Type

The vendor type associated with the GL entry

Examples: Communications, Electrical Consultant, Insurance

 

Bank:

Bank Entry Key

Bank Entry

The database identifier of the bank entry associated with the GL entry

 

Bank Entry Company Key

 

Multi-company only. The database identifier of the company linked to the bank entry associated with the GL entry

 

Bank Entry Company Name

 

Multi-company only. The name of the company linked to the bank entry associated with the GL entry

 

Receipt Key

 

The database identifier of the client receipt associated with the GL entry

 

Receipt Project Key

 

The database identifier of the client receipt project associated with the GL entry

 

Receipt Company Key

 

Multi-company only. The database identifier of the company linked to the client receipt associated with the GL entry

 

Receipt Company Name

 

Multi-company only. The name of the company linked to the client receipt associated with the GL entry

 

Paycheck Key

 

The database identifier of the paycheck associated with the GL entry

 

Payroll Company Key

 

Multi-company only. The database identifier of the company linked to the paycheck associated with the GL entry

 

Payroll Company Name

 

Multi-company only. The name of the company linked to the paycheck associated with the GL entry

 

Is Cash

 

If the accounting basis is not marked accrual, this column indicates if the accounting basis for the GL entry is cash.

 

AxTransaction Notes

 

Any notes about the transaction associated with the GL entry

 

Notes

 

Any notes associated with the GL entry as entered in Manage Journal Entries

 

Transaction Company Key

 

Multi-company only. The database identifier of the company linked to the transaction associated with the GL entry

 

Transaction Company Name

 

Multi-company only. The name of the company linked to the transaction associated with the GL entry

 

Defined links:

Link - Department - Accrual

Department

A link to the Department inquiry with a condition limiting the information to accrual departments

 

Link - Department - Cash

Department

A link to the Department inquiry with a condition limiting the information to cash departments

 

Link - Transaction

Transaction - All

A link to the Transaction - All inquiry

 

Link - GL Account - Accrual

GL Account

A link to the GL Account inquiry with a condition limiting the information to accrual accounts

 

Link - GL Account - Cash

GL Account

A link to the GL Account inquiry with a condition limiting the information to cash accounts

 

Link - Session

Session

A link to the Session inquiry

 

Link - Project

Project

A link to the Project inquiry

 

Link - Employee

Employee

A link to the Employee inquiry

 

Link - Timesheet

Timesheet

A link to the Timesheet inquiry

 

Link - Expense Report

Expense Report

A link to the Expense Report inquiry

 

Link - Client

Client

A link to the Client inquiry

 

Link - Client Invoice

Client Invoice

A link to the Client Invoice inquiry

 

Link - Client Receipt

Client Receipt

A link to the Client Receipt inquiry

 

Link - Vendor

Vendor

A link to the Vendor inquiry

 

Link - Vendor Invoice

Vendor Invoice

A link to the Vendor Invoice inquiry

 

Link - Vendor Payment

Vendor Payment

A link to the Vendor Payment inquiry

 

Link - Bank Entry

Bank Entry

A link to the Bank Entry inquiry

 

Link - Paycheck

Check Detail

A link to the Check Detail inquiry