Report: General Journal

The General Journal is a general ledger report showing posted journal entries. It can be printed for a transaction date range, reference number range, or a selected journal entry type.

Report Selections

What is this?

Transaction Date Range

Options	What is this?
Current Date	Choose the Current Date option, if you want to report transactions for the current system date only.
Select Date Range	Mark the Select Date Range option, if you want to report transactions for a specific date range. Fill in the From and To dates.

Reference Number Range

Options	What is this?
All Reference Numbers	Mark the All Reference Numbers option, if you want the report to include all reference numbers for the Transaction Date Range selected.
Select Reference Number Range	Choose the Select Reference Number Range option, if you want the report to include only a specific reference number range for the Transaction Date Range selected. Fill in the From and To reference numbers.

Journal Type

You can run the report for All journal entry types or for a specific journal entry type. All is the default.

Division

You can run the report for All divisions (default) or one division.

The Division list only includes divisions you have security rights to. If the report is run for All divisions, only those divisions you have security rights to, are included.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Report Fields

Report Fields	Description
Ref #	Reference number of the journal entry.
Tran Date	The transaction date of the journal entry.
Approved	The actual date the journal entry was physically posted. The date is followed by the short name of the employee who posted (approved) the journal entry.
Tran	Transaction type.
Origin	Origin code.
GL #	General ledger account number.
Dept	Department short name, if general ledger account is an income and expense account.
Subledger	Subledger, if any.
Description	Transaction description.
Debit	Debit amount.
Credit	Credit amount.
Memo	Journal entry memo.
Reason for Void	If a voided transaction, reports the reason for the void.

CSV Columns

CSV Columns	Description
RefNo	Reference number of the journal entry.
GLDate	The transaction date of the journal entry.
ApprovedDate	The actual date the journal entry was physically posted.
ApprovedBy	The short name of the employee who posted (approved) the journal entry.
Tran	Transaction type.
GL#	General ledger account number.
Subledger	Subledger, if any.
Description	Transaction description.
Division	Division name.
Department	Department short name.
Debit	Debit amount.
Credit	Credit amount.
Memo	Journal entry memo.
Invoice	Invoice number, if appropriate for the account (11211000000, 21111000).
PolNo	Policy number, if appropriate for the account (11211000000, 21111000).
VoidReason	If a voided transaction, reports the reason for the void.
Origin	Origin code.