qb invoice import template by cuiliqing

VIEWS: 29 PAGES: 5

									                                                                                Page 1 of 5


QuickBooks Excel Invoice Import Template
Fill this out with Invoice information and use the Info On The Web Quickbooks (IOTW-QB) Program to import directly into QuickBooks
IOTW can customize this form and program to fit your exact import needs, including importing to other programs.
First 4 rows are examples.

   Customer:Job:           Invoice Date:           Invoice #:               Bill To:                  Adr1:                 Adr2:        City:      State:
These 3 records in green are examples
Abercrombie, Kristy    2008-02-23                               101 Kristy Abercrombie        5647 Cypress Hill Rd                   Bayshore      CA
Cuddihy, Matthew       2008-02-24                               102 Cuddihy, Matthew          8321 S. Flower                         E. Bayshore   CA
Morgenthaler, Jenny    2008-02-23                               103 Morgenthaler, Jenny       37105 E. Oasis Dr.                     Middlefield   CA
                                                               Page 2 of 5




  Postal Code:   PONumber:     Terms:     Due Date:            Customer Message                          Item1            Description

94326                 12345 Net 30      2008-02-19    It's been a pleasure working with you!   Blueprint changes   blue print charges
94781                       Net 15      2008-02-10    It's been a pleasure working with you!   Blueprint changes   blue print charges
94485                 45678 Net 30      2008-02-19    It's been a pleasure working with you!   Blueprint changes   blue print charges
                                                                 Page 3 of 5




Hrs/Qty       Rate     Amount        Tax   Item2        Description            Hrs/Qty   Rate     Amount     Tax        Item3

          1      100    100.00 tax         Labor labor for kitchen remodel          10       50     500.00 non
          1      100    100.00 tax         Labor labor for kitchen remodel          10       75     750.00 non     Interior Door kit
          1      100    100.00 tax         Labor labor for kitchen remodel          10      100   1,000.00 non     Fluorescent Ceiling Lighting
                                                                        Page 4 of 5




     Description         Hrs/Qty   Rate     Amount        Tax   Item4   Description Hrs/Qty   Rate   Amount   Tax   Item5   Description Hrs/Qty


complete Interior door         1      120    120.00 tax
Fluorescent Lights             3       10     30.00 tax
                                                           Page 5 of 5




Rate   Amount   Tax   Item6   Description Hrs/Qty   Rate   Amount        Tax   Item7   Description Hrs/Qty   Rate   Amount   Tax

								
To top