4Reports and Inquiry
Option 1Trial Balance Report
This report prints a list of General Ledger accounts and balances for a specified time period. A report may be selected for any month, and prints either the net activity or the YTD cumulative balances. The following processing steps accomplish this job.
- Step 1You can use this function to enter the fiscal period for which the Trial Balance is to be printed, whether net or cumulative amounts are to be shown on the report, and whether summary account totals are to be printed.
The screen shown below allows you to enter parameters needed for the Trial Balance report.
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)
YUSyy: Year-to-Date Uses, 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 Account 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 Accounts with 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
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 Account Balances information, this step provides you with a default sequencing of data records by Account Component, with the option to change modifiable parameters at run time. Selection of data records is provided by Account, Account Component, and Revenue/Expense?, 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 Trial Balance, this step formats the Account Balances information. The following data items are shown: Account, Sub Type, Description and Amount. If requested, totals appear whenever a change occurs in Account Components. When totals are specified, the following items are assimilated: Total Amount, Total Sources, Total Uses, and Total Neither.
A sample output is shown below.
Expert Computing, Inc.
11/03/94 15:38 LGG Page: 1
Trial Balance
Trial Balance as of Aug89 in Year-to-Date Terms
Account Sub Type Description Debits Credits
=================================================================================================================================
10100010 Cash (Posting Account) 0.00 0.00
1010001000 Cash, Corporate 791,348.21 0.00
1010001001 Cash, Sales Outlets 2,098,201.72 0.00
10200020 Cash, Canadian (Posting Acct) 0.00 0.00
1020002000 Cash, Canadian Corporate 1,739,345.94 0.00
1020002001 Cash, Canadian Sales Outlets 984,348.27 0.00
10300010 Accts Receiv. (Posting Acct) 0.00 0.00
1030001000 Accts Receiv, Intercompany 59,119.20 0.00
1030001000MA Accts Receiv, Corp./Mfg. 241,525.79 0.00
1030001000WH Accts Receiv, Corp./Wholesale 177,133.42 0.00
1030001001MA Accts Receiv, Sales/Mfg. 257,784.41 0.00
1030001001WH Accts Receiv, Sales/Wholesale 131,936.81 0.00
10300020 Accts Rec, Canadian (Post Act) 0.00 0.00
1030002000MA Accts Rec, Canadian Corp/Mfg 169,864.57 0.00
1030002000WH Accts Rec, Canadian Corp/Whls 118,433.40 0.00
1030002001MA Accts Rec, Canadian Sales/Mfg. 112,775.51 0.00
1030002001WH Accts Rec, Canadian Sales/Whls 99,709.31 0.00
10400010 Retention Rec (Posting Acct) 0.00 0.00
1040001000MA Retention Rec, Corp./Mfg. 2,095.63 0.00
1040001000WH Retention Rec, Corp./Wholesale 1,802.19 0.00
1040001001MA Retention Rec, Sales/Mfg. 4,546.05 0.00
1040001001WH Retention Rec, Sales/Wholesale 2,557.13 0.00
10400020 Retent Rec, Canadian Post Acct 0.00 0.00
1040002000MA Retent Rec, Canadian Corp/Mfg 6,478.35 0.00
1040002000WH Retent Rec, Canadian Corp/Whls 2,843.65 0.00
1040002001MA Retent Rec, Canadian Sales/Mfg 1,276.32 0.00
1040002001WH Retent Rec, Canadian Sales/Whl 1,250.62 0.00
1050001000 Service Charges Receivable 5,270.00 0.00
1050002000 Service Charges Rec, Canadian 13.23 0.00
1060001000 Prepaid Insurance 6,000.00 0.00
1060002000 Prepaid Insurance, Canadian 5,328.87 0.00
1061001000 Prepaids & Deposits 5,640.00 0.00
1061002000 Prepaids & Deposits, Canadian 6,455.67 0.00
1070001000MA Inventory, Corp./Mfg. 190,421.28 0.00
1070002000MA Inventory, Canadian Corp./Mfg. 193,451.35 0.00
1080001000MA Work in Process, Corp./Mfg. 298,948.00 0.00
1080002000MA Work in Proc, Canada Corp/Mfg 104,865.83 0.00
1090001000MA Finished Goods 201,876.82 0.00
1090002000MA Finished Goods, Canadian 382,361.37 0.00
1100001000WH Resale Inventory 249,583.02 0.00
1100001001WH Resale Inventory, Sales Outlet 297,051.68 0.00
1100002000WH Resale Inventory, Canadian 115,788.75 0.00
1105000000MA Interco. Inventory Profit, Mfg 52,000.00 0.00
1105000000WH Interco. Inventory Profit, Whl 16,520.00 0.00
1130001000 Land 650,000.00 0.00
1130002000 Land, Canadian 514,767.12 0.00
1140001000 Buildings 410,000.00 0.00
1140002000 Buildings, Canadian 313,762.82 0.00
1150001000MA GL Equipment 598,300.00 0.00