| Available Columns |
Description |
Date Range Available |
Chartable |
Links to Page |
| General Information
|
| Accrual Account Group Order |
The order the accrual account group shows on the list |
|
|
|
| Accrual Account Group |
The accrual account group associated with the GL entry |
|
|
|
| Accrual Account Type |
The accrual account type associated with the GL entry |
|
|
|
| Accrual Department Name |
The accrual department associated with the GL entry
|
|
|
Department |
| Activity Description |
The description of the activity associated with the GL entry
Examples: Administration, Billable Time, Fees & Permits, Meetings, Mileage, Photocopies, Vacation
|
|
|
Activity |
| Activity Type Value |
The numeric identifier of the activity type associated with the GL entry |
|
|
|
| Activity Type |
The type of activity associated with the GL entry
Examples: Consultant, Expense, Labor
|
|
|
|
| Bank Account Type |
The bank account type associated with the GL entry |
|
|
|
| Bank Account |
The bank account associated with the GL entry |
|
|
Bank Account |
| Bank Entry Company Name |
The name of the company linked to the bank entry associated with the GL entry
|
|
|
Company |
| Cash Account Group Order |
The order the cash account group shows on the list |
|
|
|
| Cash Account Group |
The cash account group associated with the GL entry |
|
|
|
| Cash Account Type |
The cash account type associated with the GL entry |
|
|
|
| Cash Basis Department Name |
The cash basis department associated with the GL entry
|
|
|
Department |
| Client Invoice Number |
The ID of the client invoice associated with the GL entry
|
|
|
Client Invoice |
| Client Type |
The client type associated with the GL entry
Examples: Builder, Government, Hospital
|
|
|
Client Type |
| Client |
The name of the client associated with the GL entry
|
|
|
Client |
| Company Name |
The company name associated with the GL entry |
|
|
Company |
| Control Account Type |
The control account type associated with the GL entry |
|
|
|
| Department Name |
The department name associated with the GL Entry |
|
|
|
| Employee Company Name |
The name of the company linked to the employee associated with the GL entry
|
|
|
Company |
| Employee Type Description |
The description of the employee type associated with the GL entry
Examples: Administration, Architect, Employee, Principal
|
|
|
Employee Type |
| Expense Report Company Name |
The name of the company linked to the expense report associated with the GL entry
|
|
|
Company |
| Expense Report Row |
The expense report row associated with the GL entry
|
|
|
|
| In-house Expense Company Name |
The name of the company linked to the in-house expense associated with the GL entry
|
|
|
Company |
| Is Accrual Intercompany Acct |
Indicates if GL entry is an accrual intercompany entry
|
|
|
|
| Is Beginning Balance |
Indicates if GL entry is the result of a beginning balance session task
|
|
|
|
| Is Cash Intercompany Acct |
Indicates if GL entry is a cash intercompany entry
|
|
|
|
| Is Cash |
If the accounting basis is not marked accrual, this column indicates if the accounting basis for the GL entry is cash
|
|
|
|
| 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.
|
|
|
|
| Journal Entry Description |
The description of the journal entry associated with the GL entry
|
|
|
|
| Journal Entry Is Imported |
Indicates if the journal entry was imported |
|
|
|
| Journal Entry Reference |
The reference ID of the journal entry associated with the GL entry
|
|
|
|
| Notes |
Any notes associated with the GL entry as entered in Manage Journal Entries
|
|
|
|
| Payroll Company Name |
The name of the company linked to the paycheck associated with the GL entry
|
|
|
Company |
| Phase - Project Type |
The project type associated with the GL entry at the project level
Examples: Residential, Commercial, Interiors
|
|
|
Project Type |
| Phase Description |
The name of the phase associated with the GL entry
|
|
|
Phase |
| Phase ID & Description |
The ID and description of the phase associated with the GL entry
|
|
|
Phase |
| Phase ID |
The ID of the phase associated with the GL entry
|
|
|
Phase |
| Project - Project Type |
The project type associated with the GL entry at the project level
Examples: Residential, Commercial, Interiors
|
|
|
Project Type |
| Project Company Name |
The name of the company associated with the project
|
|
|
Company |
| Project Description |
The name of the project associated with the GL entry
|
|
|
Project |
| Project ID & Description |
The ID and description of the project associated with the GL entry
|
|
|
Project |
| Project ID |
The ID of the project associated with the GL entry
|
|
|
Project |
| Receipt Company Name |
The name of the company linked to the client receipt associated with the GL entry
|
|
|
Company |
| Revenue Description |
The revenue description entered in the recognize revenue task session where the general ledger entry was created |
|
|
Revenue |
| Revenue Status |
The revenue status of the recognize revenue task session where the general ledger entry was created |
|
|
|
| Session Task |
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
|
|
|
Session |
| Timesheet Company Name |
The name of the company linked to the timesheet associated with the GL entry
|
|
|
Company |
| Timesheet Row |
The timesheet row associated with the GL entry
|
|
|
|
| Transaction Company Name |
The name of the company linked to the transaction associated with the GL entry
|
|
|
Company |
| Transaction Notes |
Any notes about the transaction associated with the GL entry
|
|
|
|
| Type |
The type of GL entry produced by the session task
Examples: Bank Entry, Beginning Balances, Billed, Cost, Payroll Payment, Premium Cost
|
|
|
|
| Vendor Invoice Company Name |
The name of the company linked to the vendor invoice associated with the GL entry
|
|
|
Company |
| 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 Number |
The ID of the vendor invoice associated with the GL entry
|
|
|
Vendor Invoice |
| Vendor Type |
The vendor type associated with the GL entry
Examples: Communications, Electrical Consultant, Insurance
|
|
|
Vendor Type |
| Vendor |
The name of the vendor associated with the GL entry
|
|
|
Vendor |
| People
|
| Billing Manager |
The name of the billing manager on the project associated with the GL entry |
|
|
Employee |
| Employee Name |
The name of the employee associated with the GL entry
|
|
|
Employee |
| Marketing Contact |
The name of the marketing contact on the project associated with the GL entry |
|
|
Employee |
| Principal In Charge |
The name of the principal in charge on the project associated with the GL entry |
|
|
Project Manager |
| Project Manager |
The name of the project manager on the project associated with the GL entry |
|
|
Project Manager |
| Session Employee |
The name of the employee associated with the session on the GL entry |
|
|
|
| Dates
|
| Accounting Date |
The date Ajera uses to determine the period for which the GL entry appears on financial statements
|
|
|
GL Entry |
| Bank Entry Date |
The date of the bank entry associated with the GL entry |
|
|
Bank Entry |
| Client Invoice Date |
The date of the client invoice associated with the GL entry
|
|
|
Client Invoice |
| Expense Report Date |
The end date of the expense report associated with the GL entry
|
|
|
Expense Report |
| Fiscal Year Begin Date |
The fiscal year begin date of the company associated with the GL entry |
|
|
|
| Fiscal Year End Date |
The fiscal year end date of the company associated with the GL entry |
|
|
|
| Receipt Date |
The receipt date of the receipt associated with the GL entry |
|
|
Receipt |
| Revenue Accounting Date |
The accounting date of the revenue batch associated with the GL entry |
|
|
|
| Revenue End Date |
The end date of the revenue batch associated with the GL entry |
|
|
|
| Revenue Start Date |
The start date of the revenue batch associated with the GL entry |
|
|
|
| Timesheet Date |
The end date of the timesheet associated with the GL entry
|
|
|
Timesheet |
| Transaction Date |
The date of the transaction associated with the GL entry
|
|
|
|
| Vendor Invoice Date |
The date of the vendor invoice associated with the GL entry
|
|
|
Vendor Invoice |
| Dollars
|
| Amount |
The total amount of the GL entry
|
X |
X |
|
| Credit Amount |
The credit amount of the GL entry |
X |
|
GL Entry |
| Debit Amount |
The debit amount of the GL entry |
X |
|
GL Entry |
| Accounts
|
| Accrual Account ID & Description |
The ID and description of the accrual account associated with the GL entry |
|
|
GL Account |
| Accrual Account ID |
The ID of the accrual account associated with the GL entry
|
|
|
GL Account |
| Accrual Account |
The accrual account associated with the GL entry
|
|
|
GL Account |
| Cash Basis Account ID & Description |
The ID and description of the cash basis account associated with the GL entry |
|
|
GL Account |
| Cash Basis Account ID |
The ID of the cash basis account associated with the GL entry
|
|
|
GL Account |
| Cash Basis Account |
The cash account associated with the GL entry |
|
|
GL Account |
| GL Account ID & Description |
The ID and description for the expense account associated with the GL entry |
|
|
GL Account |
| GL Account ID |
The ID for the expense account associated with the GL entry |
|
|
GL Account |
| GL Account |
The expense account associated with the GL entry |
|
|
GL Account |
| Keys
|
| Accrual Account Group Key |
The database identifier of the accrual account group associated with the GL entry |
|
|
|
| Accrual Account Key |
The database identifier of the accrual account associated with the GL entry
|
|
|
GL Account |
| Accrual Department Key |
The database identifier of the accrual department associated with the GL entry
|
|
|
Department |
| Activity Key |
The database identifier of the activity associated with the GL entry
|
|
|
Activity |
| Bank Account Key |
The database identifier of the bank account associated with the GL entry |
|
|
Bank Account |
| Bank Entry Company Key |
The database identifier of the company linked to the bank entry associated with the GL entry
|
|
|
Company |
| Bank Entry Key |
The database identifier of the bank entry associated with the GL entry
|
|
|
Bank Entry |
| Billing Manager Key |
The database identifier of the billing manager on the project associated with the GL entry |
|
|
Employee |
| Cash Account Group Key |
The database identifier of the cash account group associated with the GL entry |
|
|
|
| Cash Basis Account Key |
The database identifier of the cash basis account associated with the GL entry
|
|
|
GL Account |
| Cash Basis Department Key |
The database identifier of the cash basis department associated with the GL entry
|
|
|
Department |
| Client Invoice Key |
The database identifier of the client invoice associated with the GL entry
|
|
|
Client Invoice |
| Client Key |
The database identifier of the client associated with the GL entry
|
|
|
Client |
| Client Type Key |
The database identifier of the client type associated with the GL entry
|
|
|
Client Type |
| Company Key |
The database identifier of the company associated with the GL entry |
|
|
Company |
| Department Key |
The database identifier of the department associated with the GL entry |
|
|
Department |
| Employee Company Key |
The database identifier of the company linked to the employee associated with the GL entry
|
|
|
Company |
| Employee Key |
The database identifier of the employee associated with the GL entry
|
|
|
Employee |
| Employee Type Key |
The database identifier of the employee type associated with the GL entry
|
|
|
Employee Type |
| Expense Report Company Key |
The database identifier of the company linked to the expense report associated with the GL entry
|
|
|
Company |
| Expense Report Key |
The database identifier of the expense report associated with the GL entry
|
|
|
Expense Report |
| GL Account Key |
The database identifier of the GL account associated with the GL entry |
|
|
|
| GL Entry Key |
The database identifier of the GL entry
|
|
|
GL Entry |
| GL Offset Key |
Matches debit to credit GL entries when they have a one-to-one relationship
|
|
|
GL Entry |
| In-house Expense Company Key |
The database identifier of the company linked to the in-house expense associated with the GL entry
|
|
|
Company |
| In-house Expense Log Key |
The database identifier of the in-house expense log associated with the GL entry |
|
|
In-house Expense Log |
| Journal Entry Key |
The database identifier of the journal entry associated with the GL entry
|
|
|
|
| Marketing Contact Key |
The database identifier of the marketing contact on the project associated with the GL entry |
|
|
Employee |
| Paycheck Key |
The database identifier of the paycheck associated with the GL entry
|
|
|
Paycheck |
| Payroll Company Key |
The database identifier of the company linked to the paycheck associated with the GL entr
|
|
|
Company |
| Phase - Project Type Key |
The database identifier of the project type associated with the GL entry at the phase level
|
|
|
Project Type |
| Phase Key |
The database identifier of the phase associated with the GL entry
|
|
|
Phase |
| Principal In Charge Key |
The database identifier of the principal in charge on the project associated with the GL entry |
|
|
Project Manager |
| Project - Project Type Key |
The database identifier of the project type associated with the GL entry at the project level
|
|
|
Project Type |
| Project Company Key |
The database identifier of the company associated with the project
|
|
|
Company |
| Project Key |
The database identifier of the project associated with the GL entry
|
|
|
Project |
| Project Manager Key |
The database identifier of the project manager on the project associated with the GL entry |
|
|
Project Manager |
| Receipt Company Key |
The database identifier of the company linked to the client receipt associated with the GL entry
|
|
|
Company |
| Receipt Key |
The database identifier of the client receipt associated with the GL entry
|
|
|
Receipt |
| Receipt Project Key |
The database identifier of the client receipt project associated with the GL entry
|
|
|
Project |
| Revenue Detail Key |
The database identifier of the revenue detail associated with the GL entry |
|
|
|
| Revenue Key |
The database identifier of the revenue batch associated with the GL entry |
|
|
Revenue |
| Session Employee Key |
The database identifier of the session employee associated with the GL entry |
|
|
Employee |
| Session Key |
The database identifier of the session associated with the GL entry
|
|
|
Session |
| Timesheet Company Key |
The database identifier of the company linked to the timesheet associated with the GL entry
|
|
|
Company |
| Timesheet Key |
The database identifier of the timesheet associated with the GL entry
|
|
|
Timesheet |
| Transaction Company Key |
The database identifier of the company linked to the transaction associated with the GL entry
|
|
|
Company |
| Transaction Key |
The database identifier of the transaction associated with the GL entry
|
|
|
Transaction |
| Vendor Invoice Company Key |
The database identifier of the company linked to the vendor invoice associated with the GL entry
|
|
|
Company |
| Vendor Invoice Key |
The database identifier of the vendor invoice associated with the GL entry
|
|
|
Vendor Invoice |
| Vendor Key |
The database identifier of the vendor associated with the GL entry
|
|
|
Vendor |
| Vendor Type Key |
The database identifier of the vendor type associated with the GL entry
|
|
|
Vendor Invoice |
| Action
|
| Open Session Journal |
Opens the session journal |
|
|
GL Entry |
| Gantt
|
unavailable in ajeraCore Select to add the Gantt chart to your table widget.
|
|
|
|
