Profit and Loss Statement for a Consulting Business - Excel by uss19488

VIEWS: 928 PAGES: 7

More Info
									Event 1 Liberty Reports                                                                                          7/11/2011
for Sage Master Builder
                                           Financial Statements                                                   8:48 PM
                                                    Instructions

      Example Name                  Financial Statements.xlt

      Purpose                       This report produces a standard balance sheet and profit & loss statement for the
                                    desired period in the current fiscal year.
                                    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 Admin worksheet.
                                    2. Enter a value for the Period To Report (this must be a number from 1 to 12).
                                    3. Click Refresh Data

                                    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              Each account section is driven by a query that lists the accounts of the appropriate
                                    types. Accounts having no beginning balance for the year and no activity in the
                                    current year are excluded. Functions in hidden columns on the Admin worksheet
                                    determine the name of the period field that represents the current period's values.
                                    DBLookup functions adjacent to the queries return the values for each account.

                                    A VBA macro is used for the refresh process so that row heights are automatically
                                    re-adjusted after the data is refreshed.


      Revision Number               Revision 3
                                    Monday, July 11, 2011 at 8:48 PM




D:\Docstoc\Working\pdf\8adb5399-6c60-4761-ad3b-299bdf1c07e5.xls                                                Page 1 of 7
Event 1 Liberty Reports                                            7/11/2011
for Sage Master Builder
                                   Financial Statements             8:48 PM
                                         Report Parameters

                            Report Parameters




D:\Docstoc\Working\pdf\8adb5399-6c60-4761-ad3b-299bdf1c07e5.xls   Page 2 of 7
Event 1 Liberty Reports                                                                                7/11/2011
for Sage Master Builder
                                              Balance Sheet                                             8:48 PM

                                          Managed Rite Construction
                                      Period 5 of fiscal year ending 12/31/2007

Assets

           Current Assets
              1000     General Checking                            82,833.09
              1002     Payroll Checking                             1,034.08
              1003     Field Checking                                 302.86
              1010     Petty Cash                                     300.00
              1020     Savings                                    152,113.18
              1120     Contract Receivables                       639,662.13
              1121     AR - Startup                                      -
              1125     (Service)                                         -
              1180     Bad Debt Allowance                         (15,000.00)
              1190     Underbillings                               15,795.21
              1200     (Inventory)                                  9,475.40
              1225     Prepaid Health Ins                           1,690.49
              1250     Plan Deposits                                  450.00
              1260     Refundable Deposits                          1,900.00
              1420     PPD Liability Insurance                        420.63
              1430     Work Comp Deposit                            5,725.00
              1590     Note Receivable - Shareholder               10,000.00
           Total Current Assets                                                   906,702.07

           Long Term Assets
              1800     (Heavy Equipment)                           74,081.00
              1810     Vehicles                                   109,377.85
              1820     Shop Equipment & Tools                      42,845.64
              1840     Office Equipment                            45,523.30
              1845     Software                                    15,786.75
              1860     Furniture & Fixtures                        19,960.21
              1900     (Accum Dep'n Heavy Equipment)              (48,458.59)
              1910     Accum Dep'n Vehicles                       (69,448.85)
              1920     Accum Dep'n Shop Eq/Tools                  (24,515.75)
              1940     Accum Dep'n Office Equipment               (29,853.75)
              1960     Accum Dep'n Furniture & Fxt                (13,832.25)
           Total Long Term Assets                                                 121,465.56

Total Assets                                                                                   $   1,028,167.63



Liabilities & Equity

           Current Liabilities
               2000       Trade Accounts Payable                  474,879.17
               2001       AP - Startup                                   -
               2200       Sales Tax Payable                              -
               2300       Fica/FIT Payable                          5,038.19
               2301       State Payroll Taxes Payable               4,989.84
               2302       Workers' Compensation Payable             6,856.18
               2303       Futa Payable                                627.96
               2308       Child Support Payable                       560.00
               2311       401K Payable                              6,173.84


                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\8adb5399-6c60-4761-ad3b-299bdf1c07e5.xls                                      Page 3 of 7
Event 1 Liberty Reports                                                                              7/11/2011
for Sage Master Builder
                                              Balance Sheet                                           8:48 PM

                                        Managed Rite Construction
                                    Period 5 of fiscal year ending 12/31/2007

              2325     Line of Credit Payable                          -
              2500     Corporate Federal Tax Payable             52,458.47
              2510     Corp State Income Tax Payable             23,480.70
           Total Current Liabilities                                            575,064.35

           Long Term Liabilities
              2800     (Heavy Equipment Loan)                    18,731.80
              2810     Vehicle Loans                             45,056.77
           Total Long Term Liabilities                                           63,788.57

           Total Liabilities                                                    638,852.92

           Equity
               3000     Capital Stock                            25,000.00
               3300     Retained Earnings                        49,245.16
               3499     Startup Clearing                               -
                        Current Earnings                        315,069.55
           Total Equity & Retained Earnings                                     389,314.71

Total Liabilities & Equity                                                                   $   1,028,167.63




                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\8adb5399-6c60-4761-ad3b-299bdf1c07e5.xls                                    Page 4 of 7
Event 1 Liberty Reports                                                                                                7/11/2011
for Sage Master Builder
                                                Profit / Loss Statement                                                 8:48 PM


                                                    Managed Rite Construction
                                                Period 5 of fiscal year ending 12/31/2007

                                                                  Period Activity                      Year To Date
 Revenue
          4000    Contract Income                            479,419.58                         1,939,953.65
          4090    Discounts Given                               (212.02)                             (212.02)
          4200    Interest Income                                   -                               1,145.22
          4400    Discounts Earned                                  -                                    -
          4010    Resale                                            -                                    -
          4005    Service Income                                    -                                    -
       Total Revenue                                                             479,207.56                      1,940,886.85


 Cost
          5001      Material                                 192,372.44                          516,400.81
          5003      Equipment Expense                          3,053.50                            5,175.00
          5004      Subcontracted                            242,263.20                          702,963.85
          5005      Other Job Expense                            396.92                            1,576.97
          5400      Direct Labor                              42,143.84                          117,704.82
          5401      D/L Payroll Taxes                          6,036.81                           17,609.40
          5402      D/L Workers' Compensation                  6,320.31                           15,587.73
          5403      D/L Benefits                              13,290.46                           33,460.13
          5404      D/L Liability Insurance                    2,960.56                            7,794.81
          5405      D/L Small Tool Exp                           918.50                            2,233.50
       Total Cost                                                                509,756.54                      1,420,507.02

       Gross Revenue                                                              (30,548.98)                     520,379.83



 Expense
          5750      (Equipment Repair)                           650.00                            2,667.69
          5800      (Equipment Use Contra)                    (1,871.00)                          (2,165.00)
          6000      Rent                                       1,900.00                            9,500.00
          6001      Office Supplies                              611.15                            8,382.24
          6002      Utilities                                     94.66                              554.88
          6003      Telephone                                    285.98                            1,595.78
          6004      Cell Phone / Paging                          624.82                            2,487.65
          6005      Bank Charges                                    -                                210.00
          6006      Postage & Freight                            300.00                              986.75
          6007      Janitorial                                   270.00                            1,035.00
          6008      Advertising & Promotion                      990.00                            2,034.85
          6010      Accounting Fees                              580.00                            7,030.00
          6011      Legal Fees                                   175.00                              425.00
          6015      Consulting Fees                            1,200.00                            1,200.00
          6020      Travel, Meals                                784.27                            5,648.13
          6025      Dues & Subscriptions                         395.00                              834.90
          6026      Continuing Education                         800.00                            1,025.00
          6028      Charity Donations                            500.00                            1,200.00
          6030      Maintenance & Repair                         423.29                            1,636.41
          6100      General Insurance                            375.00                              375.00
          6110      Taxes & Licenses                                -                              1,037.87
          6120      Interest Expense                           1,350.61                            2,304.19
          6999      Suspense/clearing                               -                                  1.84
          6220      Warranty Work                                   -                                   -
          6400      Overhead Labor                            11,460.03                           49,200.03
          6401      O/H Payroll Taxes                          1,221.74                            5,146.34
          6402      O/H Workers' Compensation                    535.87                            2,249.13
          6403      O/H Benefits                               1,493.80                            6,474.80
          6404      O/H Liability Insurance                      315.83                            1,314.75
          6500      Vehicle Expenses                             737.88                            3,630.35
          6520      Vehicle Fuel                                 853.24                            5,955.25
          6600      Small Tools/Shop Supplies                     56.96                              843.49
          6810      Depreciation Expense                       3,034.50                           12,216.26


                                                       CONFIDENTIAL
D:\Docstoc\Working\pdf\8adb5399-6c60-4761-ad3b-299bdf1c07e5.xls                                                       Page 5 of 7
Event 1 Liberty Reports                                                                                     7/11/2011
for Sage Master Builder
                                            Profit / Loss Statement                                          8:48 PM


                                                           Period Activity                   Year To Date
          7400    Admin Salaries                        7,692.30                         33,846.12
          7401    Admin Payroll Taxes                     588.45                          3,696.93
          7403    Admin Benefits                          846.90                          3,726.36
          6395    Estimating Labor                      4,400.00                         19,360.00
          6022    Entertainment                           197.37                          3,762.25
          5710    Equipment Interest Expense              159.26                            826.80
          5720    Equipment Depreciation Expense             -                            2,956.24
          5604    Shop Liability Ins                       97.00                             97.00
          5780    Equipment Fuel                             -                                 -
       Total Expense                                                         44,129.91                   205,310.28

       Net Profit                                                        (74,678.89)                     315,069.55


       Other Income & Expense
                                                             -                                -
                                                             -                                -
       Total Other Income & Expense                                                -                            -

       Adjusted Net Profit / Loss                                        (74,678.89)                     315,069.55




                                                       CONFIDENTIAL
D:\Docstoc\Working\pdf\8adb5399-6c60-4761-ad3b-299bdf1c07e5.xls                                           Page 6 of 7
Event 1 Liberty Reports                                                        7/11/2011
for Sage Master Builder
                                     Financial Statements                        8:48 PM
                                             Sample Values

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


     Parameter Values

     Admin Worksheet
     Period To Report     5




D:\Docstoc\Working\pdf\8adb5399-6c60-4761-ad3b-299bdf1c07e5.xls               Page 7 of 7

								
To top