Use this function to print the Trial Balance, a report of General Ledger accounts and balances for a specified time period. You can print a report for any fiscal month/period as well as for SOY (Start of Year), EOY (End of Year), and Source/Use/Neither to date amounts. You can also choose to print net monthly amounts or cumulative year-to-date balances. Finally, you can decide whether or not to print summary accounts or accounts with zero balances.
The Trial Balance Report Setup Screen, shown in Figure 5-11 below, appears when you select Trial Balance from the Reports Pulldown Menu. This screen allows you to establish report options to be stored in a temporary one-record file. You enter the setup screen in Add mode and you are not allowed to change mode.
Figure 5-11. Trial Balance Report Setup Screen
This screen contains the following report options for printing the Trial Balance:
Enter the accounting period or basis for printing the Trial Balance as follows:
mm/ccyy: |
Enter the fiscal month/period (01-13), a "/", and the 4-digit fiscal year |
SOYccyy: |
For Start of Year, enter "SOY" and the 4-digit fiscal year |
EOYccyy: |
For End of Year, enter "EOY" and the 4-digit fiscal year |
SUNccyy: |
For Sources/Uses/Neither to date, enter "SUN" and the 4-digit fiscal year |
Enter the code for the terms in which the amounts are to be printed. Click the list button to select one of the options listed below:
NET: |
Net monthly amount |
CUM: |
Cumulative year-to-date balance |
Select "yes" or if you do not want to print summary accounts; otherwise, select "no" or . The initial default is "yes".
If summary totals are not suppressed, they are printed on a separate page following the Trial Balance.
Select "yes" or if you want to print accounts with zero balances (or amounts); otherwise, select "no" or . The initial default is "no". This will skip lines with zero amounts.
Press ENTER or click or the OK button to store the report options and continue. The system may redisplay the screen to report any error or warning messages. If so, you must address any concerns and press ENTER or click or the OK button again. To exit the function, press END or click or the Cancel button.
If you elect to continue, you will follow the same general procedure for printing that is used in all APPX applications. Refer to the APPX User Manual for detailed instructions in regard to any record selection, sort order, and/or disposition screens that appear.
A sample Trial Balance Report is shown below.
Expert Computing, Inc. 11/07/01 11:33 LGG Page: 1
Trial Balance
Trial Balance as of Aug 99 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
|