2Initial Setup Opening Entries
Option 8Account Balances History Report
This report prints the start-of-year, end-of-year, and monthly balances for accounts in fiscal year order. Balances are reported in cumulative and net monthly amounts. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Account Balances information, this step provides you with a default sequencing of data records by Account and Fiscal Year, with the option to change modifiable parameters at run time. Selection of data records is provided by Account, Account Component, Fiscal Year, Revenue/Expense?, Currency, Sub Type, Application Type, and Summary Account?, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all standard General Ledger reports.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Account Balances History Report, this step formats the Account Balances information. The following data items are shown: Fiscal Year, SOY, Month Descriptor, Monthly Balances, Monthly Amount, MTD Sources, MTD Uses, MTD Neither, YTD Sources, YTD Uses, YTD Neither, and EOY. As appropriate, group headings appear whenever a change occurs in Account.
A sample output is shown below.
Expert Computing, Inc.
11/07/94 11:34 LGG Page: 1
Account Balances History Report
=================================================================================================================================
Account 10000 Assets
Fiscal Year 87
Cumulative: Net:
SOY 0.00 Dec 0.00 Dec 0.00 MTD Sources
Jun 0.00 Jan 0.00 Jun 0.00 Jan 0.00 MTD Uses
Jul 0.00 Feb 0.00 Jul 0.00 Feb 0.00 MTD Neither
Aug 0.00 Mar 0.00 Aug 0.00 Mar 0.00 YTD Sources 0.00
Sep 0.00 Apr 0.00 Sep 0.00 Apr 0.00 YTD Uses 0.00
Oct 0.00 May 0.00 Oct 0.00 May 0.00 YTD Neither 0.00
Nov 0.00 Nov 0.00
EOY 0.00 EOY 0.00
Account 1010001000 Cash, Corporate
Fiscal Year 88
Cumulative: Net:
SOY 0.00 Dec 0.00 Dec 0.00 MTD Sources
Jun 0.00 Jan 0.00 Jun 0.00 Jan 0.00 MTD Uses
Jul 0.00 Feb 0.00 Jul 0.00 Feb 0.00 MTD Neither
Aug 0.00 Mar 0.00 Aug 0.00 Mar 0.00 YTD Sources 0.00
Sep 0.00 Apr 0.00 Sep 0.00 Apr 0.00 YTD Uses 0.00
Oct 0.00 May 0.00 Oct 0.00 May 0.00 YTD Neither 0.00
Nov 0.00 Nov 0.00
EOY 960,026.00 EOY 960,026.00
Fiscal Year 89
Cumulative: Net:
SOY 960,026.00 Dec 960,681.56 Dec 136,512.28 MTD Sources
Jun 776,688.88 Jan 1,204,779.55 Jun 183,337.12- Jan 244,097.99 MTD Uses
Jul 640,168.38 Feb 785,497.07 Jul 136,520.50- Feb 419,282.48- MTD Neither
Aug 460,561.99 Mar 883,873.53 Aug 179,606.39- Mar 98,376.46 YTD Sources 5,252,046.53-
Sep 885,246.50 Apr 991,401.54 Sep 424,684.51 Apr 107,528.01 YTD Uses 4,952,317.63
Oct 1,132,735.47 May 660,297.10 Oct 247,488.97 May 331,104.44- YTD Neither 0.00
Nov 824,169.28 Nov 308,566.19-
EOY 660,297.10 EOY 0.00
Fiscal Year 90
Cumulative: Net:
SOY 1,239.36- Dec Dec MTD Sources 0.00
Jun 1,239.36- Jan Jun 0.00 Jan MTD Uses 0.00
Jul 1,239.36- Feb Jul 0.00 Feb MTD Neither 0.00
Aug 1,239.36- Mar Aug 0.00 Mar YTD Sources 0.00
Sep Apr Sep Apr YTD Uses 0.00
Oct May Oct May YTD Neither 0.00
Nov Nov
EOY 0.00 EOY 0.00
Account 2030002001 Retention Pay, Canadian Sales
Fiscal Year 88
Cumulative: Net:
SOY 0.00 Dec Dec 0.00 MTD Sources
Jun 0.00 Jan Jun 0.00 Jan 0.00 MTD Uses
Jul 0.00 Feb Jul 0.00 Feb 0.00 MTD Neither
Aug 0.00 Mar Aug 0.00 Mar 0.00 YTD Sources 0.00
Sep Apr Sep 0.00 Apr 0.00 YTD Uses 0.00
Oct May Oct 0.00 May 0.00 YTD Neither 0.00
Nov Nov 0.00
EOY 1,177.00- EOY 1,177.00-