4Reports and Inquiry
Option 7Trial Balance with Subsidiary Codes
This function prints a trial balance including amounts for all subsidiary codes. The following processing steps accomplish this job.
- Step 1This function allows you to enter parameters to define the type of information to be included on the Trial Balance with Subsidiary Codes.
The screen shown below allows you to enter parameters for the Trial balance with Subsidiary Codes.
Trial Balance w/Sub Codes screen
Data items for the preceding screen are described below:
- Fiscal Month/Year
Upper case, up to 5 characters Required
Define the accounting period to which these parameters apply. Valid entries and their meanings are:
mm/yy: 2 digits each for the fiscal month and year for these entries (months can be 01 - 13; the slash must be included)
EOYyy: End-of-Year, followed by 2 digits for the fiscal year
SOYyy: Start-of-Year, followed by 2 digits for the fiscal year
YSRyy: Year-to-Date Sources, followed by 2 digits for the fiscal year (for Account Balances only)
- Net or Cumulative Amounts
Upper case, up to 3 characters Letters only Valid: NET, CUM Required
Define the code that identifies the terms in which the balances are to be printed.
- NET
- Month-to-Date net activity
- CUM
- Year-to-Date cumulative amounts
- Suppress Summary Totals?
Y or N Default Y Required
Indicate whether or not the summary account totals should be suppressed. If summary totals are not suppressed, they are printed on a separate page following the Trial Balance.
- Y
- Yes, suppress the summary totals
- N
- No, print the summary totals
- Print Zero Balances?
Default Y Required
Enter ;Y’ (Yes) or ‘N’ (No).
Indicate whether or not to print accounts which have zero amounts:
- Y
- print all lines
- N
- skip lines with zero amounts
The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:
Press ENTER to save the information on this screen.
- Step 2In preparation for performing a sort/selection process on the Chart of Accounts information, this step provides you with a default sequencing of data records by Summary Account? and Account Number, with the option to change modifiable parameters at run time. Selection of data records is provided by Account Component, with the option to enter user-specified comparisons at run time.
- Step 3This disposition type is used for all standard General Subsidiary reports.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5In order to print the Trial Balance with Subsidiary Codes, this step formats the Chart of Accounts, Account Balances and Subsidiary Codes by Account information. The following data items are shown: Account, Description, Sub Type, Amount, Subsidiary Code, and Asterisk for Out of Balance. As appropriate, group headings appear whenever a change occurs in Summary Account? If requested, totals appear whenever a change occurs in Summary Account?. When totals are specified, the following items are accumulated: Balance and Subsidiary Balance.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 16:19 LGG Page: 1
Trial Balance with Subsidiary Codes
Trial Balance as of Aug89 in Year-to-Date Terms
O
Account Description Sub Type Balance Sub Code Description Sub Balance B
=================================================================================================================================
1150002000MA Equipment, Canadian 384,486.91
1160001000 Furniture and Fixtures 198,960.00
1160002000 Furniture/Fixtures, Canadian 163,195.88
1170001000 Accumulated Depreciation GL 741,987.74- COMPUTER New Computer Syst. Development 30,844.00-
GENERAL Non Project-Specific Costs 711,143.74-
——————— ———————
— Account Totals —> 741,987.74- 741,987.74-
============== ==============
3010001001WH Sales, Wholesale 560,855.13-
3010002001MA Sales, Canadian Manufacturing 351,141.89-
3010002001WH Sales, Canadian Wholesale 248,845.81-
3020000000 Service Charge Income 4,750.00-
3030001001 Foreign Exchange/Canadian 0.00
3060000000 Miscellaneous Income 168.96
4010000000 Cost of Goods Sold, Interco. 59,119.20
4010000000MA Cost of Goods Sold, Corp./Mfg. 38,709.39
4010000000WH Cost of Goods Sold, Corp/Whlsl 32,601.60
4010000001MA Cost of Goods Sold, Sales/Mfg. GL 27,000.93 JONES Salesperson Sam Jones 15,004.70
PETERS Salesperson George Peters 14,640.76
WILLIAMS Salesperson Kris Williams 13,071.01
——————— ———————
— Account Totals —> 27,000.93 42,716.47
*
============== ==============
4010000001WH Cost of Goods Sold, Sales/Whls 26,569.72
4020000001MA Sales Commissions, Mfg. GL 74,333.73 JONES Salesperson Sam Jones 27,145.24
PETERS Salesperson George Peters 25,255.54
WILLIAMS Salesperson Kris Williams 21,932.95
——————— ———————
— Account Totals —> 74,333.73 74,333.73
============== ==============
4020000001WH Sales Commissions, Wholesale 38,234.51
4040001000 Depreciation Expense GL 57,821.00 COMPUTER New Computer Syst. Development 1,904.00
GENERAL Non Project-Specific Costs 55,917.00
——————— ———————
— Account Totals —> 57,821.00 57,821.00
============== ==============
4040002000 Depreciation Expense, Canadian 30,750.00
4070000000WH Discounts Lost, Wholesale 492.28
4080000000 Salaries Expense GL 58,862.41 COMPUTER New Computer Syst. Development 50,421.74
GENERAL Non Project-Specific Costs 33,888.78
——————— ———————
— Account Totals —> 58,862.41 84,310.52
============== ==============