2Monthly Processing
Option 1General Ledger Report
This report lists all posted transactions for the current month. Included are journal entries and transactions posted through to General ledger from other applications. For each account, this report shows beginning balances, the current month’s activity, and ending balances. The following processing steps accomplish this job.
- Step 1You can us this function to choose whether or not to print accounts with zero balances, and/or no monthly activity, on the General Ledger report.
The screen shown below allows you to enter parameters needed for the General Ledger report.
Report screen
Data items for the preceding screen are described below:
- Print Zero Balances?
Y or N Default Y Required
Indicate whether or not to print accounts which have zero amounts:
- Y
- print all lines
- N
- skip lines with zero amounts
Press ENTER to save the information on this screen.
- Step 2In preparation for performing a sort/selection process on the Account Balances information, this step provides you with a default sequencing of data records by Fiscal Year, Account, Currency, and Sub Type, with the option to change modifiable parameters at run time. Selection of data records is provided by Fiscal Year, Account Component, Revenue/Expense?, Currency, and Sub Type, with the option to enter user-specified comparisons at run time.
- Step 3This disposition type is used for all standard General Ledger reports.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5In order to print the General Ledger Report, this step formats the Account Balances and MTD Postings information. The following data items are shown: Account, Description, Operator ID, Control No, Journal Code, Source Transaction No, Transaction Date, Fiscal Month, Fiscal Year, Reference, Revising?, Adjustment?, S/U/N Override, Intercompany, Intercompany Reference, Currency Code, Prior Period Amount, Debits, Credits, and Balance. If requested, totals appear whenever a change occurs in Account or Fiscal Year. When totals are specified, the following items are accumulated: Prior Period, Debits, Credits, and Balance. Total Current Earnings is also shown.
A sample output is shown below.
Expert Computing, Inc.
11/03/94 17:11 LGG Page: 1
General Ledger Report
Fiscal Year 90
Control Group Description
Jrnl Trx Trx Date Mo/Yr Ref Rev? Adj? S/U/N Interco Curr Prior Period Debits Credits Balance
=================================================================================================================================
Account 10100010 Cash (Posting Account) .00
=================================================================================================================================
Account 1010001000 Cash, Corporate 776673.21
MRC / 0000 SUMMARY POSTING
ARCR 0000 03 90 N N 14675.00
SRR / 0157 August Payroll
GL1 0001 08/31/89 03 90 JE N N 125835.57-
SRR / 0157 August A/R Receipts
GL1 0005 08/31/89 03 90 JE N N 178626.70
SRR / 0157 August Revenue
GL1 0006 08/31/89 03 90 JE N N 133899.90
____________ ____________ ____________ ____________
— Account Totals —> .00 327201.60 125835.57- 978039.24
============ ============ ============ ============
=================================================================================================================================
Account 1010001001 Cash, Sales Outlets 2148193.22
SRR / 0000 SUMMARY POSTING
APCD 0000 03 90 N N 3312.05-
SRR / 0000 SUMMARY POSTING
APCD 0000 03 90 N N 49991.50-
SRR / 0000 SUMMARY POSTING
ARCR 0000 03 90 N N 17772.19
SRR / 0157 August A/R Receipts
GL1 0005 08/31/89 03 90 JE N N 153721.53
SRR / 0157 August Revenue
GL1 0006 08/31/89 03 90 JE N N 98160.49
____________ ____________ ____________ ____________
— Account Totals —> .00 269654.21 53303.55- 2364543.88
============ ============ ============ ============
=================================================================================================================================
Account 1020002000 Cash, Canadian Corporate 1739345.94
SRR / 0158 August Reveue
GL1 0001 08/31/89 03 90 JE N N CANADA 60637.85
SRR / 0158 August Expenses
GL1 0002 08/31/89 03 90 JE N N CANADA 42260.26-
____________ ____________ ____________ ____________
— Account Totals —> .00 60637.85 42260.26- 1757723.53
============ ============ ============ ============
=================================================================================================================================