Trial Balance Report

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:

Fiscal Month/Year

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

 

Print Net or Cumulative Amounts

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

 

Suppress Summary Account Totals?

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.

Print Accounts with Zero Balances?

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