Simple Excel Invoice - Excel by rkf23660

VIEWS: 60 PAGES: 4

More Info
									Event 1 Import Tools                               AP Invoice      11/22/2010
for Sage Timberline Office                                            2:34 PM
                                                    Instructions


       Template Name

       Purpose




       Requirements


       Using This Template




       About the Design




D:\Docstoc\Working\pdf\6ffc0ece-6ecf-4226-a0c0-43b96f109d65.xls    Page 1 of 4
Event 1 Import Tools                                      AP Invoice                       11/22/2010
for Sage Timberline Office                                                                    2:34 PM
                                                            Instructions


AR Invoice.xlt

This template provides a simple example of creating a single AR Invoice using data
from Excel. More complex solutions involving multiple invoices, more data
validation and calculations could be based on the core aspects of this example.


 Event 1 Import Tools
 Sage Timberline Office - Accounts Receivable

1. Enter values in each of the yellow-shaded cells to complete the entry of the
invoice information. Information for at least one distribution in the distribution grid
must be supplied.
2. Click Save Import Files on the ImportTools toolbar.
3. Provide a name for the import file and click Save.
4. Follow the steps documented in Accounts Payable help to import the file into
Accounts Payable.

Not sure where to start? Use the "Construction Sample Data" provided with your
Sage Timberline Office software then click on the "Sample Values" worksheet to see
values you might try using.


Hidden cell P4 contains a function that returns a unique identifier for the invoice.
This includes the combination of the Customer ID and Invoice ID would would
represent the primary key for the AR Invoice. This approach would be useful when
creating multiple invoices from one workbook because it uniquely identifies each
invoice. The TSImport functions in hidden column P provide the "instructions" to
Import Tools for creating the invoice and distribution records in the import file.
Note that cell P5 contains the TSImport function for the invoice and the TSImport
functions for each of the distributions refer to cell P5 as their parent record. This is
an important relationship to create when creating an import file.




D:\Docstoc\Working\pdf\6ffc0ece-6ecf-4226-a0c0-43b96f109d65.xls                            Page 2 of 4
Event 1 Import Tools                                                                                AP Invoice                                                                      11/22/2010
for Sage Timberline Office                                                                                                                                                             2:34 PM
                                                                                                    Entry Form

AR Invoice Entry Form

Customer                                                                    Invoice Date
Invoice                                                                     Due Date
Description                                                                 Draw Number
                                                                            Contract ID
Amount            Retainage
              -               -



              Item AmountType     Contract Item   Job   Extra   Cost Code   Tax Group      Tax ID      Units     Unit Cost           Amount       Retainage       Accounting Date
                  1                                                                                                                  $        -
                  2                                                                                                                  $        -
                  3                                                                                                                  $        -
                  4                                                                                                                  $        -
                  5                                                                                                                  $        -
                  6                                                                                                                  $        -
                  7                                                                                                                  $        -
                  8                                                                                                                  $        -
                  9                                                                                                                  $        -
                 10                                                                                                                  $        -

                                                                                                                    Total Invoice:            -               -




D:\Docstoc\Working\pdf\6ffc0ece-6ecf-4226-a0c0-43b96f109d65.xls                                                                                                                     Page 3 of 4
Event 1 Import Tools                             AR Invoice                                          11/22/2010
for Sage Timberline Office                                                                              2:34 PM
                                                 Sample Values

      To try this template using the "Construction Sample Data", you can try using the following values:



      Invoice Details
      Customer               OHSU
      Invoice                8192
      Description            Monthly billing
      Retainage                      -
      Invoice Date           5/15/2001
      Due Date               6/15/2001
      Draw Number            1
      Contract ID

      Distribution Details
      Amount Type            Total Billed
      Contract Item
      Job                    03-009
      Extra
      Cost Code
      Tax Group              MET
      Tax ID
      Units                        10.00
      Unit Cost                    25.00
      Amount                      250.00
      Retainage                    25.00
      Accounting Date        5/31/2001




D:\Docstoc\Working\pdf\6ffc0ece-6ecf-4226-a0c0-43b96f109d65.xls                                      Page 4 of 4

								
To top