4Reports and Inquiry
Option 2Account 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 formast 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/03/94 15:39 LGG Page: 1
Account Balances History Report
=================================================================================================================================
Account 10000 Assets
Fiscal Year 0
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 660,297.10 Dec Dec MTD Sources 125,835.57-
Jun 756,003.17 Jan Jun 95,706.07 Jan MTD Uses 327,201.60
Jul 776,673.21 Feb Jul 20,670.04 Feb MTD Neither 0.00
Aug 791,348.21 Mar Aug 14,675.00 Mar YTD Sources 701,680.44-
Sep Apr Sep Apr YTD Uses 1,019,422.58
Oct May Oct May YTD Neither 0.00
Nov Nov
EOY 0.00 EOY 0.00
Account 1010001001 Cash, Sales Outlets
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 39,225.00-
Sep Apr Sep 0.00 Apr 0.00 YTD Uses 39,225.00
Oct May Oct 0.00 May 0.00 YTD Neither 0.00
Nov Nov 0.00
EOY 459,041.00 EOY 459,041.00