Trial Balance

Document Sample
Trial Balance Powered By Docstoc
					Event 1 Liberty Reports                                                                                             5/7/2011
for Sage Master Builder
                                                  Trial Balance                                                     5:27 AM
                                                     Instructions

      Example Name                   Trial Balance.xlt

      Purpose                        This report produces a standard trial balance for the desired period in the current
                                     fiscal year. The account list can be quickly filtered using the auto-filter drop-down
                                     buttons that appear above each column caption.
                                     NOTE - This workbook has been converted to static values and contains no links to
                                     live data that can be refreshed.

      More Like This                 For information about more templates like this one, contact us at:
                                     support@event1software.com

      Before You Start               Macros are presently enabled
                                     Some of the functionality of this workbook is provided by Excel macros. To learn
                                     more about macro security, click th following link.
                                     http://kb.event1software.com/questions/45

      Requirements                    Event 1 Liberty Reports for Sage Master Builder
                                      Sage Master Builder

      Using This Example             1. Click the Trial Balance worksheet
                                     2. Enter the desired period number in the Period cell.
                                     3. Click Refresh on the Liberty Reports toolbar to see current values.
                                     4. Optionally - Filter the list of accounts by clicking the drop-down button that
                                     appears on a given column caption. For example, the account list can be quickly
                                     filtered to show only certain types of accounts that you want to see.

                                     Not sure where to start? Use the "Sample Company" data folder provided with
                                     your Sage Master Builder software and use the "Sample Values" worksheet for
                                     guidance.

      Disclaimer                     This template is provided as an example. Use of it results in a live connection to
                                     your Sage Master Builder database. We suggest testing this template with your
                                     data before determining its suitability for your business needs. Your review
                                     process may need to involve your Sage Master Builder consultant and your
                                     representative for services pertaining to Event 1 Software products.


      About the Design               A single query drives most of the information in this report. The query includes the
                                     account number, title, beginning balance for the year, and period amounts for
                                     periods 1 to 12. Most of these columns are hidden. Formulas in adjacent columns
                                     determine which values to show in order to reflect the current period activity and
                                     current balance.


      Revision Number                Revision 1
                                     Saturday, November 07, 2009 at 1:38 PM




D:\Docstoc\Working\pdf\2e6d68af-4d8e-4eae-82e5-f4e632413fb8.xls                                                 Page 1 of 4
Event 1 Liberty Reports                                                                                                 5/7/2011
for Sage Master Builder
                                                    Trial Balance                                                       5:27 AM

Managed Rite Construction
C:\MB7\Sample Company
                                                                                               Fiscal Year: 6/29/1905
                                                                                                   Period:   5

                                                                           Beginning        Period                 Ending
   Account                      Account Title                Type           Balance         Activity              Balance
    1000        General Checking                   Cash Account                76,071.02       6,762.07              82,833.09
    1002        Payroll Checking                   Cash Account                 1,488.79         (454.71)             1,034.08
    1003        Field Checking                     Cash Account                   302.86             -                  302.86
    1010        Petty Cash                         Cash Account                   300.00             -                  300.00
    1020        Savings                            Cash Account                27,113.18     125,000.00             152,113.18
    1120        Contract Receivables               Current Asset              711,589.67     (71,927.54)            639,662.13
    1180        Bad Debt Allowance                 Current Asset              (15,000.00)            -              (15,000.00)
    1190        Underbillings                      Current Asset               15,795.21             -               15,795.21
    1200        (Inventory)                        Current Asset                9,475.40             -                9,475.40
    1250        Plan Deposits                      Current Asset                  450.00             -                  450.00
    1260        Refundable Deposits                Current Asset                1,900.00             -                1,900.00
    1420        PPD Liability Insurance            Other Asset                  2,892.02      (2,471.39)                420.63
    1430        Work Comp Deposit                  Other Asset                  5,725.00             -                5,725.00
    1590        Note Receivable - Shareholder      Other Asset                 10,000.00             -               10,000.00
    1800        (Heavy Equipment)                  Fixed Asset                 74,081.00             -               74,081.00
    1810        Vehicles                           Fixed Asset                109,377.85             -              109,377.85
    1820        Shop Equipment & Tools             Fixed Asset                 42,845.64             -               42,845.64
    1840        Office Equipment                   Fixed Asset                 45,523.30             -               45,523.30
    1860        Furniture & Fixtures               Fixed Asset                 19,960.21             -               19,960.21
    1900        (Accum Dep'n Heavy Equipment)      Depreciation               (47,719.53)        (739.06)           (48,458.59)
    1910        Accum Dep'n Vehicles               Depreciation               (68,291.16)     (1,157.69)            (69,448.85)
    1920        Accum Dep'n Shop Eq/Tools          Depreciation               (24,071.00)        (444.75)           (24,515.75)
    1940        Accum Dep'n Office Equipment       Depreciation               (29,383.00)        (470.75)           (29,853.75)
    1960        Accum Dep'n Furniture & Fxt        Depreciation               (13,610.00)        (222.25)           (13,832.25)
    2000        Trade Accounts Payable             Current Liability         (242,293.91)   (232,585.26)           (474,879.17)
    2200        Sales Tax Payable                  Current Liability                 -               -                     -
    2300        Fica/FIT Payable                   Current Liability           (5,540.55)         502.36             (5,038.19)
    2301        State Payroll Taxes Payable        Current Liability           (4,693.81)        (296.03)            (4,989.84)
    2302        Workers' Compensation Payable      Current Liability           (2,490.42)     (4,365.76)             (6,856.18)
    2303        Futa Payable                       Current Liability             (339.64)        (288.32)              (627.96)
    2308        Child Support Payable              Current Liability             (580.00)          20.00               (560.00)
    2311        401K Payable                       Current Liability           (3,459.81)     (2,714.03)             (6,173.84)
    2500        Corporate Federal Tax Payable      Current Liability          (52,458.47)            -              (52,458.47)
    2510        Corp State Income Tax Payable      Current Liability          (23,480.70)            -              (23,480.70)
    2800        (Heavy Equipment Loan)             Longer Term Liability      (19,103.78)         371.98            (18,731.80)
    2810        Vehicle Loans                      Longer Term Liability      (45,813.71)         756.94            (45,056.77)
    3000        Capital Stock                      Equity                     (25,000.00)            -              (25,000.00)
    3300        Retained Earnings                  Equity                     (49,245.16)            -              (49,245.16)
    4000        Contract Income                    Operating Income        (1,460,534.07)   (479,419.58)         (1,939,953.65)
    4090        Discounts Given                    Operating Income                  -            212.02                212.02
    4200        Interest Income                    Operating Income            (1,145.22)            -               (1,145.22)
    4400        Discounts Earned                   Operating Income                  -               -                     -
    5001        Material                           Direct Expense             324,028.37     192,372.44             516,400.81
    5003        Equipment Expense                  Direct Expense               2,121.50       3,053.50               5,175.00
    5004        Subcontracted                      Direct Expense             460,700.65     242,263.20             702,963.85
    5005        Other Job Expense                  Direct Expense               1,180.05          396.92              1,576.97
    5400        Direct Labor                       Direct Expense              75,560.98      42,143.84             117,704.82
    5401        D/L Payroll Taxes                  Direct Expense              11,572.59       6,036.81              17,609.40
    5402        D/L Workers' Compensation          Direct Expense               9,267.42       6,320.31              15,587.73
    5403        D/L Benefits                       Direct Expense              20,169.67      13,290.46              33,460.13
    5404        D/L Liability Insurance            Direct Expense               4,834.25       2,960.56               7,794.81
    5405        D/L Small Tool Exp                 Direct Expense               1,315.00          918.50              2,233.50
    5750        (Equipment Repair)                 Equip/Shop Expense           2,017.69          650.00              2,667.69
    5800        (Equipment Use Contra)             Equip/Shop Expense            (294.00)     (1,871.00)             (2,165.00)
    6000        Rent                               Overhead Expense             7,600.00       1,900.00               9,500.00
    6001        Office Supplies                    Overhead Expense             7,771.09          611.15              8,382.24
    6002        Utilities                          Overhead Expense               460.22           94.66                554.88
    6003        Telephone                          Overhead Expense             1,309.80          285.98              1,595.78
    6004        Cell Phone / Paging                Overhead Expense             1,862.83          624.82              2,487.65
    6005        Bank Charges                       Overhead Expense               210.00             -                  210.00
    6006        Postage & Freight                  Overhead Expense               686.75          300.00                986.75
    6007        Janitorial                         Overhead Expense               765.00          270.00              1,035.00



                                                         CONFIDENTIAL
D:\Docstoc\Working\pdf\2e6d68af-4d8e-4eae-82e5-f4e632413fb8.xls                                                     Page 2 of 4
Event 1 Liberty Reports                                                                                                  5/7/2011
for Sage Master Builder
                                                    Trial Balance                                                        5:27 AM

Managed Rite Construction
C:\MB7\Sample Company
                                                                                                Fiscal Year: 6/29/1905
                                                                                                    Period:   5

                                                                            Beginning        Period               Ending
   Account                     Account Title                 Type            Balance         Activity             Balance
    6008        Advertising & Promotion            Overhead Expense              1,044.85         990.00             2,034.85
    6010        Accounting Fees                    Overhead Expense              6,450.00         580.00             7,030.00
    6011        Legal Fees                         Overhead Expense                250.00         175.00               425.00
    6015        Consulting Fees                    Overhead Expense                   -         1,200.00             1,200.00
    6020        Travel, Meals                      Overhead Expense              4,863.86         784.27             5,648.13
    6025        Dues & Subscriptions               Overhead Expense                439.90         395.00               834.90
    6026        Continuing Education               Overhead Expense                225.00         800.00             1,025.00
    6028        Charity Donations                  Overhead Expense                700.00         500.00             1,200.00
    6030        Maintenance & Repair               Overhead Expense              1,213.12         423.29             1,636.41
    6100        General Insurance                  Overhead Expense                   -           375.00               375.00
    6110        Taxes & Licenses                   Overhead Expense              1,037.87             -              1,037.87
    6120        Interest Expense                   Overhead Expense                953.58       1,350.61             2,304.19
    6999        Suspense/clearing                  Overhead Expense                  1.84             -                  1.84
    6220        Warranty Work                      Overhead Expense                   -               -                   -
    6400        Overhead Labor                     Overhead Expense             37,740.00      11,460.03            49,200.03
    6401        O/H Payroll Taxes                  Overhead Expense              3,924.60       1,221.74             5,146.34
    6402        O/H Workers' Compensation          Overhead Expense              1,713.26         535.87             2,249.13
    6403        O/H Benefits                       Overhead Expense              4,981.00       1,493.80             6,474.80
    6404        O/H Liability Insurance            Overhead Expense                998.92         315.83             1,314.75
    6500        Vehicle Expenses                   Overhead Expense              2,892.47         737.88             3,630.35
    6520        Vehicle Fuel                       Overhead Expense              5,102.01         853.24             5,955.25
    6600        Small Tools/Shop Supplies          Overhead Expense                786.53           56.96              843.49
    6810        Depreciation Expense               Overhead Expense              9,181.76       3,034.50            12,216.26
    7400        Admin Salaries                     Administrative Expense       26,153.82       7,692.30            33,846.12
    7401        Admin Payroll Taxes                Administrative Expense        3,108.48         588.45             3,696.93
    7403        Admin Benefits                     Administrative Expense        2,879.46         846.90             3,726.36
    6395        Estimating Labor                   Overhead Expense             14,960.00       4,400.00            19,360.00
    1225        Prepaid Health Ins                 Current Asset                 1,645.19           45.30            1,690.49
    1121        AR - Startup                       Current Asset                      -               -                   -
    6022        Entertainment                      Overhead Expense              3,564.88         197.37             3,762.25
    5710        Equipment Interest Expense         Equip/Shop Expense              667.54         159.26               826.80
    5720        Equipment Depreciation Expense     Equip/Shop Expense            2,956.24             -              2,956.24
    2325        Line of Credit Payable             Current Liability          (110,000.00)    110,000.00                  -
    5604        Shop Liability Ins                 Equip/Shop Expense                 -             97.00               97.00
    1125        (Service)                          Current Asset                      -               -                   -
    2001        AP - Startup                       Current Liability                  -               -                   -
    3499        Startup Clearing                   Equity                             -               -                   -
    1845        Software                           Fixed Asset                  15,786.75             -             15,786.75
    5780        Equipment Fuel                     Equip/Shop Expense                 -               -                   -
    4010        Resale                             Operating Income                   -               -                   -
    4005        Service Income                     Operating Income                   -               -                   -

                Report Totals                                                         -               -                     -




                                                         CONFIDENTIAL
D:\Docstoc\Working\pdf\2e6d68af-4d8e-4eae-82e5-f4e632413fb8.xls                                                      Page 3 of 4
Event 1 Liberty Reports                                                         5/7/2011
for Sage Master Builder
                                           Trial Balance                         5:27 AM
                                             Sample Values

     Try this template using the "Sample Company" and the following values:


     Parameter Values

     Trial Balance
     Period               5




D:\Docstoc\Working\pdf\2e6d68af-4d8e-4eae-82e5-f4e632413fb8.xls               Page 4 of 4

				
DOCUMENT INFO