Billing Invoice Template - Excel

Document Sample
Billing Invoice Template - Excel Powered By Docstoc
					                                                SIR # DTFACT-10-R-00004
                                         00cccc70-168c-4943-a8a6-e5ffa82cf24d.xls

Vendor                          Vendor Name
Task Order                      Task Order Name
Contract #                      DTFACT-09-D-000XX/0001
Task Order #                    0001
Invoice #                       0001-01
Invoice Date                    9/21/09
Invoice Period of Performance   8/1/09-8/31/09

                                                 Cost             Fee             CPFF
Task Ceiling Value                             $900,000.00      100,000.00     1,000,000.00
Task Ceiling Remaining (Unfunded )             $600,000.00       50,000.00       650,000.00
Task Ceiling Remaining (Actual)                 #REF!            #REF!            #REF!

Funded Amount                                  $300,000.00       $50,000.00         350,000.00
Amount Invoiced To Date                         #REF!            #REF!               #REF!
Funding Remaining                               #REF!            #REF!               #REF!

Task Order Subcontracting Percentage                  27%

                                                       Current                             Cumulative
                                                Hours          Amount                Hours          Amount
Labor Prime                                        321.50      $22,840.70              821.50        #REF!
OH                                   0.00%                          $0.00                            #REF!
G&A                                  0.00%                          $0.00                            #REF!
     Prime Labor Subtotal                                      $22,840.70                            #REF!


Labor Subcontractor                                200.00         $7,500.00            300.00       #REF!
Subcontractor M&H                    0.00%                            $0.00                         #REF!
 Subcontractor Labor Subtotal                                     $7,500.00                         #REF!

          Total Labor                                            $30,340.70                         #REF!

Travel                                                             $805.00                          #REF!
G&A                                  0.00%                           $0.00
          Total Travel                                             $805.00                          #REF!

ODCs                                                               $150.00                          #REF!
Material and Handling                0.00%                           $0.00                          #REF!
           Total ODCs                                              $150.00                          #REF!

          Total Costs                                            $31,295.70                         #REF!

Fee Per Hour                         $0.00                            $0.00                         #REF!
Fee Withheld                                                         $0.00                          #REF!
           Total Fee                                                  $0.00                         #REF!

  Total CPFF Invoice Amount                        521.50        $31,295.70           1,121.50      #REF!
                                                 00cccc70-168c-4943-a8a6-e5ffa82cf24d.xls


Prime Labor
Task Order #                                 0
Invoice #                                    0
Billing Date                            1/0/00
Period of Performance:                1/0/1900

                                                                   Direct
                         Skill                                     Labor      Current       Current    Cumulative   Cumulative
   Labor Category        Level    Location          Employee       Rate*       Hours        Amount       Hours       Amount
Task Area Lead            AA     AC Gov't Site        John          $50.00        54.50      $3,043.72      54.50      $3,043.72
Engineer                   A     DC Gov't Site        Mary          $35.00       128.00      $6,535.20     128.00      $6,535.20
Engineer                   E      DC Offsite           Joe          $20.00       139.00      $3,224.40     139.00      $3,224.40




                                                          TOTALS                 321.50     $12,803.32     321.50      12,803.32




                                                 00cccc70-168c-4943-a8a6-e5ffa82cf24d.xls
                                                 00cccc70-168c-4943-a8a6-e5ffa82cf24d.xls


Subcontractor Labor
Task Order #                                  0
Invoice #                                     0
Billing Date                             1/0/00
Period of Performance:                1/0/1900

                         Skill                                                                  Current    Current    Cumulative
  Labor Category         Level    Location           Employee          Vendor         Rate       Hours     Amount       Hours
Task Area Lead            AA     AC Gov't Site         John            ACME            $75.00     100.00    $7,500.00     100.00
Engineer                   A     DC Gov't Site         Mary            ACME            $50.00     100.00




                                                                    TOTALS                        200.00    $7,500.00     100.00
00cccc70-168c-4943-a8a6-e5ffa82cf24d.xls




              Cumulative
               Amount
                 $7,500.00




                  $7,500.00
                                                                   00cccc70-168c-4943-a8a6-e5ffa82cf24d.xls



Travel
Task Order #                                   0
Invoice #                                      0
Billing Date                              1/0/00
Period of Performance:                 1/0/1900

                                   Labor
                               Category/Skill                                                                                 Hotel
   TAR #            Employee       Level           Travel Dates   Origination Destination   Air/Train  Rental Car   Hotel     Tax       Meals     POV      Misc     Total
     1                                                                                         $400.00    $250.00   $100.00    $15.00    $30.00    $0.00   $10.00   $805.00
                                                                                                                                                                      $0.00
                                                                                                                                                                      $0.00
                                                                                                                                                                      $0.00
                                                                    CURRENT TOTALS          $400.00      $250.00    $100.00   $15.00     $30.00    $0.00   $10.00   $805.00
                             00cccc70-168c-4943-a8a6-e5ffa82cf24d.xls


ODCs
Task Order #                                   0
Invoice #                                      0
Billing Date                              1/0/00
Period of Performance:                 1/0/1900

  ODCAR #           Vendor        Invoice #        Invoice Date         Description
   11111             ABC           101010            9/30/2009             Parts




                                                             CURRENT TOTALS
             00cccc70-168c-4943-a8a6-e5ffa82cf24d.xls




Amount
  $150.00




   $150.00

				
DOCUMENT INFO
Description: Billing Invoice Template document sample