Sample of Notes of Financial Statements

Document Sample
Sample of Notes of Financial Statements Powered By Docstoc
					Event 1 Office Connector Import                      AP Invoice                                                         8/4/2011
for Sage Timberline Office
                                                       Instructions                                                      3:59 PM


       Template Name              GL Financial Statements with Drill Down.xlt

       Purpose                    This template produces a Trial Balance, Balance Sheet and Income
                                  Statement. You may define your own prefix lists for consolidation and you
                                  may select a financial period up to 24 months in the past or up to six months
                                  in the future. An amount having a right-facing double-arrow (>>) indicates
                                  that you can double-click the amount to drill-down into the transactional detail.
       More Like This             For information about more templates like this one, contact us at:
                                  support@event1software.com

       Requirements                Event 1 Office Connector Query
                                   Sage Timberline Office General Ledger (vr 9.3 or higher)

       Using This Template        Refreshing Data
                                  1. Click the Admin worksheet
                                  2. Select the desired prefix option, enter the desired fiscal year, fiscal period
                                  and select the desired budget type.
                                  3. Click Refresh Data
                                  4. Double-click any amount having a right-facing double-arror (>>) to drill
                                  down into the transactional detail.

                                  Setup Prefix Lists
                                  1. Click the Prefix Lists worksheet
                                  2. Each row represents a grouping of prefixes. Each column represents a
                                  prefix in the list. If no prefixes are identified, all will be included. This will
                                  consolidate all prefixes by base account.
                                  3. To define a new prefix list, first change the name in column A.
                                  4. Next, enter the list of prefixes you wish to include in columns B through U.
                                  If your accounts contain more than one prefix, you must enter the separators
                                  between each prefix section.

                                  Not sure where to start? Use the "Construction Sample Data" data folder

       Disclaimer                 Use of this Excel template results in a live connection to your Sage Timberline
                                  Office database. This Excel template is provided only as an example, and we
                                  suggest evaluating it before determining its suitability for your business
                                  needs. Your evaluation process may need to involve your Sage Timberline
                                  Office certified consultant and your representative for services pertaining to
                                  Event 1 Software products.
       About the Design           This template utilizes a special function called GLAmount. This function
                                  utilizes Office Connecor functions to retrieve data from Timberline and apply
                                  the logic necessary to roll backward or forward the correct number of periods
                                  in order to report on the desired fiscal period. This function also
                                  accomplishes consolidation by using the list of prefixes (or prefix masks)
                                  identified by the prefix group being used.
       Revision Number            Revision 5
                                  Tuesday, February 17, 2009 at 6:20 PM




D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                                                       Page 1 of 12
Event 1 Office Connector                          Financial Statements                          8/4/2011
for Sage Timberline Office                                                                      3:59 PM
                                                        Report Parameters

      Report Parameters

      Prefix Selection                                                 Period
         Consolidate All Prefixes

         Single Prefix, or Consolidate Prefixes Like:                  Fiscal Year     2001
          Report Title                                                 Fiscal Period      5
            Company

                                                                       Budget
         Consolidate Prefixes in a Prefix List:
            Prefix List        List 1                                  Budget Type




D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                               Page 2 of 12
Event 1 Office Connector                   Financial Statements                                          8/4/2011
for Sage Timberline Office                                                                               3:59 PM
                                                       Trial Balance
       Trial Balance
       Timberline Construction
       C:\Program Files\Timberline Office\Accounting\Construction Sample Data

       All Companies
       May of 2001


                                                                                Current
       Account                                          Type                    Activity       Balance

       Cash                                             Current assets             171,024 »    1,047,795 »
       Petty Cash                                       Current assets                 - »            300 »
       Accounts Receivable                              Current assets              (7,140)»    1,052,086 »
       Draws Receivable                                 Current assets                 - »         48,025 »
       Retainage Receivable                             Current assets              15,895 »      139,633 »
       Due From Other Timberline Companies              Current assets             359,446 »    1,103,910 »
       WIP - Parts                                      Current assets                 - »          1,357 »
       WIP - Labor                                      Current assets                 - »          1,327 »
       WIP - Miscellaneous                              Current assets                  88 »           88 »
       Cost in Excess of Billings                       Current assets                 - »         15,322 »
       Parts Inventory                                  Current assets             (39,523)»     (567,392)»
       Investments                                      Noncurrent assets              - »        872,512 »
       Buildings                                        Noncurrent assets              - »         82,859 »
       Furniture & Fixtures                             Noncurrent assets              - »        100,528 »
       Motor Vehicles                                   Noncurrent assets              - »        226,487 »
       Construction Equipment                           Noncurrent assets              - »        126,075 »
       Accum Depreciation - Buildings                   Noncurrent assets              - »        (56,558)»
       Accum Depreciation - Furniture                   Noncurrent assets              - »        (80,309)»
       Accum Depreciation - Vehicles                    Noncurrent assets              - »       (108,384)»
       Accum Depreciation - Equipment                   Noncurrent assets              - »       (107,431)»
       Accounts Payable                                 Current liab               (33,107)»      (37,847)»
       Notes Payable                                    Current liab                   - »        (25,000)»
       Subcontracts Payable                             Current liab               (41,356)»     (360,508)»
       Retainage Payable                                Current liab                (4,981)»       (9,754)»
       Tax Payable                                      Current liab                   (86)»       (3,655)»
       Due To Other Timberline Companies                Current liab              (359,446)»   (1,103,910)»
       PO Accrual                                       Current liab                   (88)»          (88)»
       Union Payable                                    Current liab               (19,851)»      (88,453)»
       Federal Income Tax Withheld                      Current liab                   - »         (4,365)»
       State Income Tax Withheld                        Current liab                   - »         (1,027)»
       FICA - Employee                                  Current liab                   - »         (2,269)»
       FICA - Employer                                  Current liab                   - »         (2,269)»
       Health Insurance                                 Current liab                  (956)»       (9,820)»
       Workers' Comp Insurance                          Current liab                (4,669)»      (30,000)»
       Unemployment Insurance                           Current liab                   - »           (509)»
       Other Withholdings                               Current liab               (27,477)»     (129,361)»
       Accrued Salaries/Wages                           Current liab                   - »         (5,723)»
       Accrued Vacation/Sick                            Current liab                   - »         (3,150)»
       Accrued Disability Insurance                     Current liab                   - »           (567)»
       Accrued 401K                                     Current liab                (1,354)»      (14,421)»
       Owners' Equity                                   Equity                         - »     (1,647,980)»
       Retained Earnings                                Retained earnings              - »       (466,532)»
       Income                                           Income                    (295,395)»   (1,640,170)»


                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                                       Page 3 of 12
Event 1 Office Connector                   Financial Statements                                                  8/4/2011
for Sage Timberline Office                                                                                       3:59 PM
                                                       Trial Balance
       Trial Balance
       Timberline Construction
       C:\Program Files\Timberline Office\Accounting\Construction Sample Data

       All Companies
       May of 2001


                                                                                    Current
       Account                                          Type                        Activity           Balance
       Discount Income                                  Income                            (89)»             (124)»
       Other Income                                     Income                         (1,950)»           (1,950)»
       Sales - Parts                                    Income                            - »               (165)»
       Sales - Labor                                    Income                            - »             (3,675)»
       Sales - Miscellaneous                            Income                            - »                (55)»
       Sales - Trip Charge                              Income                            - »               (450)»
       Sales - Small Jobs                               Income                            - »             (1,580)»
       Cost of Sales - Labor                            Cost                           89,957 »          354,384 »
       Cost of Sales - Subcontract                      Cost                           49,805 »           97,930 »
       Cost of Sales - Materials                        Cost                           82,525 »          335,946 »
       Cost of Sales - Equipment                        Cost                           56,710 »          735,764 »
       Cost of Sales - Other                            Cost                              832 »           38,338 »
       Expense - Parts                                  Expense                           - »                165 »
       Expense - Labor                                  Expense                           - »              1,372 »
       Expense - Miscellaneous                          Expense                           - »                 28 »
       Purchase Variance                                Expense                           - »             (2,699)»
       Executive Compensation                           Expense                         6,658 »           69,298 »
       Admin Compensation                               Expense                         2,528 »           33,033 »
       Field Wages                                      Expense                            74 »            1,016 »
       Other Compensation                               Expense                         1,115 »           12,439 »
       Employee Benefits                                Expense                           783 »            8,290 »
       Auto/Truck Expense                               Expense                          (547)»            1,045 »
       Misc Expenses                                    Expense                           - »                 76 »
       Office Supplies                                  Expense                            95 »              452 »
       Postage                                          Expense                            30 »              440 »
       Rent                                             Expense                           - »              7,000 »
       Taxes                                            Expense                           - »                  4»
       Telephone                                        Expense                           333 »            1,697 »
       Utilities                                        Expense                           116 »            1,129 »

       Totals                                                                   $              0   $             0




                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                                               Page 4 of 12
Event 1 Office Connector                  Financial Statements                                         8/4/2011
for Sage Timberline Office                                                                             3:59 PM
                                                    Balance Sheet
       Balance Sheet
       Timberline Construction
       C:\Program Files\Timberline Office\Accounting\Construction Sample Data

       All Companies
       May of 2001

                                                               Current
                                                               Activity                   Balance

       Assets

           Current Assets

               Cash                                                171,024 »               1,047,795 »
               Petty Cash                                              - »                       300 »
               Accounts Receivable                                  (7,140)»               1,052,086 »
               Draws Receivable                                        - »                    48,025 »
               Retainage Receivable                                 15,895 »                 139,633 »
               Due From Other Timberline Companies                 359,446 »               1,103,910 »
               WIP - Parts                                             - »                     1,357 »
               WIP - Labor                                             - »                     1,327 »
               WIP - Miscellaneous                                      88 »                      88 »
               Cost in Excess of Billings                              - »                    15,322 »
               Parts Inventory                                     (39,523)»                (567,392)»

               Total Current Assets                                 499,789                2,842,451


           Long Term Assets

               Investments                                              -   »                872,512 »
               Buildings                                                -   »                 82,859 »
               Furniture & Fixtures                                     -   »                100,528 »
               Motor Vehicles                                           -   »                226,487 »
               Construction Equipment                                   -   »                126,075 »
               Accum Depreciation - Buildings                           -   »                (56,558)»
               Accum Depreciation - Furniture                           -   »                (80,309)»
               Accum Depreciation - Vehicles                            -   »               (108,384)»
               Accum Depreciation - Equipment                           -   »               (107,431)»

               Total Long Term Assets                                   -                  1,055,780

           Total Assets                                                         499,789




       Liabilities

           Current Liabilities

               Accounts Payable                                     33,107 »                 37,847 »
               Notes Payable                                           - »                   25,000 »


                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                                   Page 5 of 12
Event 1 Office Connector                   Financial Statements                                          8/4/2011
for Sage Timberline Office                                                                               3:59 PM
                                                    Balance Sheet
       Balance Sheet
       Timberline Construction
       C:\Program Files\Timberline Office\Accounting\Construction Sample Data

       All Companies
       May of 2001

                                                               Current
                                                               Activity                     Balance
               Subcontracts Payable                                 41,356 »                   360,508 »
               Retainage Payable                                     4,981 »                     9,754 »
               Tax Payable                                              86 »                     3,655 »
               Due To Other Timberline Companies                   359,446 »                 1,103,910 »
               PO Accrual                                               88 »                        88 »
               Union Payable                                        19,851 »                    88,453 »
               Federal Income Tax Withheld                             - »                       4,365 »
               State Income Tax Withheld                               - »                       1,027 »
               FICA - Employee                                         - »                       2,269 »
               FICA - Employer                                         - »                       2,269 »
               Health Insurance                                        956 »                     9,820 »
               Workers' Comp Insurance                               4,669 »                    30,000 »
               Unemployment Insurance                                  - »                         509 »
               Other Withholdings                                   27,477 »                   129,361 »
               Accrued Salaries/Wages                                  - »                       5,723 »
               Accrued Vacation/Sick                                   - »                       3,150 »
               Accrued Disability Insurance                            - »                         567 »
               Accrued 401K                                          1,354 »                    14,421 »

               Total Current Liabilities                            493,370                  1,832,695

           Long Term Liabilities


               Total Long Term Liabilities                              -                          -

           Total Liabilities                                                      493,370




       Equity

               Owners' Equity                                           -   »                1,647,980 »
               Retained Earnings                                        -   »                  466,532 »

               Current Earnings                                #NAME?                       #NAME?

           Total Equity                                                         #NAME?


       Total Liabilities plus Equity                                            #NAME?




                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                                     Page 6 of 12
Event 1 Office Connector              Financial Statements          8/4/2011
for Sage Timberline Office                                          3:59 PM
                                              Balance Sheet




                                                     3,898,231




                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls   Page 7 of 12
Event 1 Office Connector              Financial Statements          8/4/2011
for Sage Timberline Office                                          3:59 PM
                                              Balance Sheet




                                                     1,832,695




                                                  #NAME?


                                                  #NAME?




                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls   Page 8 of 12
Event 1 Office Connector                                      Financial Statements                                                         8/4/2011
for Sage Timberline Office                                                                                                                 3:59 PM
                                                                Statement of Profit Loss

Statement of Profit & Loss
Timberline Construction
C:\Program Files\Timberline Office\Accounting\Construction Sample Data

All Companies
May of 2001

                                                                         Current Period                                Year To Date
                                                         Budget              Actual        Variance       Budget          Actual        Variance

Revenue

     Income                                                       -            295,395 »      (295,395)            -      1,640,170 »    (1,640,170)
     Discount Income                                              -                 89 »           (89)            -            124 »          (124)
     Other Income                                                 -              1,950 »        (1,950)            -          1,950 »        (1,950)
     Sales - Parts                                                -                - »             -               -            165 »          (165)
     Sales - Labor                                                -                - »             -               -          3,675 »        (3,675)
     Sales - Miscellaneous                                        -                - »             -               -             55 »           (55)
     Sales - Trip Charge                                          -                - »             -               -            450 »          (450)
     Sales - Small Jobs                                           -                - »             -               -          1,580 »        (1,580)

     Total Revenue                                                -            297,434       (297,434)             -       1,648,170     (1,648,170)


Cost

     Cost of Sales - Labor                                        -             89,957 »       (89,957)            -        354,384 »      (354,384)
     Cost of Sales - Subcontract                                  -             49,805 »       (49,805)            -         97,930 »       (97,930)
     Cost of Sales - Materials                                    -             82,525 »       (82,525)            -        335,946 »      (335,946)
     Cost of Sales - Equipment                                    -             56,710 »       (56,710)            -        735,764 »      (735,764)
     Cost of Sales - Other                                        -                832 »          (832)            -         38,338 »       (38,338)

     Total Cost                                                   -            279,829       (279,829)             -       1,562,362     (1,562,362)


Gross Margin
                                                                  -             17,604        (17,604)             -         85,808         (85,808)




Expense

     Expense - Parts                                              -                - »             -               -            165 »          (165)
     Expense - Labor                                              -                - »             -               -          1,372 »        (1,372)
     Expense - Miscellaneous                                      -                - »             -               -             28 »           (28)
     Purchase Variance                                            -                - »             -               -         (2,699)»         2,699
     Executive Compensation                                       -              6,658 »        (6,658)            -         69,298 »       (69,298)
     Admin Compensation                                           -              2,528 »        (2,528)            -         33,033 »       (33,033)
     Field Wages                                                  -                 74 »           (74)            -          1,016 »        (1,016)
     Other Compensation                                           -              1,115 »        (1,115)            -         12,439 »       (12,439)
     Employee Benefits                                            -                783 »          (783)            -          8,290 »        (8,290)
     Auto/Truck Expense                                           -               (547)»           547             -          1,045 »        (1,045)
     Misc Expenses                                                -                - »             -               -             76 »           (76)
     Office Supplies                                              -                 95 »           (95)            -            452 »          (452)
     Postage                                                      -                 30 »           (30)            -            440 »          (440)
     Rent                                                         -                - »             -               -          7,000 »        (7,000)
     Taxes                                                        -                - »             -               -              4»             (4)
     Telephone                                                    -                333 »          (333)            -          1,697 »        (1,697)
     Utilities                                                    -                116 »          (116)            -          1,129 »        (1,129)

     Total Expense                                                -              11,186        (11,186)            -        134,784        (134,784)


Net Profit or Loss
                                                                  -               6,418         (6,418)            -        (48,975)        48,975




                                                              CONFIDENTIAL
D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                                                                          Page 9 of 12
Event 1 Office Connector                                                                 Financial Statements                                                                                    8/4/2011
for Sage Timberline Office                                                                                                                                                                       3:59 PM
                                                                                              GL Transactions

GL Transactions
                                                               « Back
Base Accounts                                                                                                   Accounting Dates

        From    4001           Income                                                                                 From            5/1/2001
          To    4001           Income                                                                                   To           5/31/2001


                 Accounting              Reference Reference                                                                      App of                                             Bank
    Account         Date       Journal       1         2               Transaction Desc           Debit             Credit        Origin    Batch   Vendor   AP invoice       Job   account      Check
21-4001            5/31/2001   31                              May Billing                                -       (133,900.00)    AR       5
21-4001            5/31/2001   31                              May Activity                               -        (25,050.00)    AR       23
22-4001             5/4/2001   30                              Weekly equip charge                        -          (5,200.00)   JC       56                             03-001
22-4001             5/4/2001   30                              Weekly equip charge                        -          (2,600.00)   JC       56                             03-001
22-4001            5/11/2001   30                              Weekly equip charge                        -          (6,240.00)   JC       57                             03-001
22-4001            5/11/2001   30                              Weekly equip charge                        -          (2,600.00)   JC       57                             03-001
22-4001            5/30/2001   51                                                                         -          (6,900.00)   EQ       6
22-4001            5/30/2001   51                                                                         -          (7,750.00)   EQ       6
22-4001            5/30/2001   51                                                                         -        (18,500.00)    EQ       6
22-4001            5/30/2001   51                                                                         -        (17,250.00)    EQ       6
22-4001            5/30/2001   51                                                                         -        (19,500.00)    EQ       6
22-4001            5/30/2001   51                                                                         -        (15,625.00)    EQ       6
22-4001            5/30/2001   51                                                                         -        (17,250.00)    EQ       6
22-4001            5/30/2001   51                                                                         -          (6,900.00)   EQ       6
22-4001            5/30/2001   51                                                                         -          (5,500.00)   EQ       6
22-4001            5/31/2001   51                              Pole Installation                          -          (1,500.00)   EQ       17                             03-006
22-4001            5/31/2001   51                              Pole Installation                          -            (825.00)   EQ       17                             03-006
22-4001            5/31/2001   51                              Pole installation                          -          (1,500.00)   EQ       18                             03-006
22-4001            5/31/2001   51                              Pole installation                          -            (825.00)   EQ       18                             03-006
22-4001            5/31/2001   51                              Reveers                                    -           1,500.00    EQ       19                             03-006
22-4001            5/31/2001   51                              Reveers                                    -             825.00    EQ       19                             03-006
22-4001            5/31/2001   51                              Clear Site for Pole Erection               -            (125.00)   EQ       20                             03-006
22-4001            5/31/2001   51                              Clear Site for Pole Erection               -            (525.00)   EQ       20                             03-006
22-4001            5/31/2001   51                              Dust Control                               -             (60.00)   EQ       20                             03-006
22-4001            5/31/2001   51                              Backfill Work                              -            (145.00)   EQ       21                             03-003
22-4001            5/31/2001   51                              Demolition of Foundation                   -          (1,450.00)   EQ       21                             03-003

                                                               Total Debits & Credits                    -        (295,395.00)
                                                               Net Activity                      (295,395.00)




D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                               CONFIDENTIAL                                                                                    Page 10 of 12
Event 1 Office Connector                                                                                                                       Title                                                                                                                                 8/4/2011
for Sage Timberline Office                                                                                                                                                                                                                                                           3:59 PM
                                                                                                                                           Subtitle


Prefix Lists
Use this worksheet to define up to 25 prefix lists, each of which may identify up to 20 prefixes. When defining a new
prefix list, you can enter your own name for the list in the List Name column. The prefix values that you enter in the
columns must be full prefixes. For example, if your GL Account format uses three prefixes, you would enter prefixes
that include all three sections with the separator characters included.

          List Name             Prefix 1     Prefix 2    Prefix 3     Prefix 4     Prefix 5     Prefix 6     Prefix 7    Prefix 8   Prefix 9     Prefix 10   Prefix 11   Prefix 12   Prefix 13   Prefix 14   Prefix 15   Prefix 16   Prefix 17   Prefix 18   Prefix 19   Prefix 20
List 1
List 2
List 3
List 4
List 5
List 6
List 7
List 8
List 9
List 10
List 11
List 12
List 13
List 14
List 15
List 16
List 17
List 18
List 19
List 20
List 21
List 22
List 23
List 24
List 25




D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                                                                                                                                                                                                               Page 11 of 12
Event 1 Office Connector Import               AP Invoice                                    8/4/2011
for Sage Timberline Office                                                                   3:59 PM
                                              Sample Values

     Try this template using the "Construction Sample Data" and the following values:

     Parameter Values

     Admin
     Prefix Selection     All Prefixes
     Fiscal Year          2001
     Fiscal Period         5
     Budget Type          Approved

     Prefix Lists
     Cell A6              Company 10
     Cell B6              10
     Cell A7               Company 2x
     Cell B7              20
     Cell C7              21




D:\Docstoc\Working\pdf\01977c2a-9263-4349-a933-2e962706e510.xls                         Page 12 of 12

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:243
posted:8/4/2011
language:English
pages:12
Description: Sample of Notes of Financial Statements document sample