GL Entry Base
| 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. |
|||
