General Ledger > Reports > GL Period End Worksheet

GL Period End Worksheet

You use this program to view the effect of adjusting journals on your period ending balances.

Adjusting journals (posted within the GL Journal Entry program) comprise Period end adjustments (usually entered by an accountant employed by your company) and Auditor's adjustments (usually entered by an external auditor to your company).

In addition, you can use the printed worksheet to note further adjustment entries for subsequent entry and posting within the GL Journal Entry program.

Report Options

Field Description
Report sequence

You can select to print the report in one of the following sequences:

  • Ledger (i.e. Ledger code)
  • Description (i.e. Ledger code description)
  • Group (i.e. Ledger group)
Adjustment to print These adjustment types refer to the type of journal selected when the journals were processed using the GL Journal Entry program.
OptionDescription
Period endSelect this if you want to include only Period end adjustment entries in the report.
AuditorsSelect this if you want to include only Auditor's adjustment entries in the report.
BothSelect this if you want to include both Period end and Auditors adjustment entries in the report.
Ledger year and period selection
Option Description
Current

Select this to generate the report for a period in the current year.

You indicate this period in the Period field below.
Previous

Select this if you want to print the report for a period in a previous year.

You indicate this year and period in the Year and Period fields below.

You can only print the report for a prior ledger year if detail transactions are held on file for that year.
Year

Indicate the year for which you want to generate the report.

This only applies if you selected to print the report for a Previous year.
Period Indicate the period for which you want to generate the report.
Account types

Indicate the account types you want to include in the report.

All account types are selected by default, but each can be individually deselected as required.
Other Options  
Include inactive accounts

Within this program, an inactive account refers to an account against which no detail transactions have been posted for the current ledger year.

Select this if you want to list these accounts on the report.
Work lines to print You can specify up to 50 work lines to be printed below your adjustment entries column.

These work lines can be used to write in further adjustment entries that you intend entering and posting using the GL Journal Entry program.
Blank lines between accounts You can specify up to 9 blank lines to print after the ledger code, adjusting details and work lines.

This enables you to increase the size of the blank area printed between ledger codes. You can use this area to enter comments or notations.

Selection criteria

Field Description
Ledger code selection Indicate the ledger code(s) for which to generate the worksheet.
Group selection Indicate the ledger group(s) for which to include ledger codes in the report.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

A source code of PE indicates period end adjustments, while a source code of AU indicates auditor's adjustments.

The final adjusted balance is referred to as the current balance for the period. The current balance is calculated as the actual current balance less any adjusting entries printed. This enables you to view the before and after effect of the adjusting entries posted to your ledger.