Docstoc

Trial Balance

Document Sample
Trial Balance Powered By Docstoc
					Event 1 Liberty Reports                                                                                          3/19/2011
for Sage Master Builder
                                                 Trial Balance                                                   11:20 PM
                                                    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\7ee8381c-6589-4362-94b8-0a8bb56f37ad.xls                                                Page 1 of 4
Event 1 Liberty Reports                                                                                                3/19/2011
for Sage Master Builder
                                                   Trial Balance                                                       11:20 PM

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\7ee8381c-6589-4362-94b8-0a8bb56f37ad.xls                                                    Page 2 of 4
Event 1 Liberty Reports                                                                                                 3/19/2011
for Sage Master Builder
                                                   Trial Balance                                                        11:20 PM

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\7ee8381c-6589-4362-94b8-0a8bb56f37ad.xls                                                     Page 3 of 4
Event 1 Liberty Reports                                                        3/19/2011
for Sage Master Builder
                                           Trial Balance                        11:20 PM
                                             Sample Values

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


     Parameter Values

     Trial Balance
     Period               5




D:\Docstoc\Working\pdf\7ee8381c-6589-4362-94b8-0a8bb56f37ad.xls               Page 4 of 4

				
DOCUMENT INFO