Simple Excel Invoice - Excel - Excel by kzz14536

VIEWS: 0 PAGES: 4

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


       Template Name

       Purpose




       Requirements


       Using This Template




       About the Design




       Template Revision




C:\Documents and Settings\Default User\My Documents\d7c17cc8-a1b9-401c-919a-69042aaa75402   Page 1 of 4
Event 1 Import Tools                                      AP Invoice                        11/22/2010
for Sage Timberline Office                                                                     3:00 PM
                                                            Instructions


AP Invoice.xlt

This template provides a simple example of creating a single AP 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 Payable

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 Vendor ID and Invoice ID would would
represent the primary key for the AP 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.

Revision 2
Monday, January 21, 2008 at 4:16 PM




C:\Documents and Settings\Default User\My Documents\d7c17cc8-a1b9-401c-919a-69042aaa75402   Page 2 of 4
Event 1 Import Tools                                                                                        AP Invoice                                                                                      11/22/2010
for Sage Timberline Office                                                                                                                                                                                     3:00 PM
                                                                                                            Entry Form

AP Invoice Entry Form

Vendor                                                                       Invoice Date
Invoice                                                                      Date Received
Description                                                                  Discount Date
                                                                             Accounting Date
Amount            Discount       Misc Deduct                                 Payment Date
              -              -                 -

Invoice Code 1
Invoice Code 2


              Item Commitment    Comm Item         Job   Extra   Cost Code   Category          Expense Account   Units   Unit Cost           Amount       Retainage       Description   Authorization   Joint Payee
                  1                                                                                                                          $        -
                  2                                                                                                                          $        -
                  3                                                                                                                          $        -
                  4                                                                                                                          $        -
                  5                                                                                                                          $        -
                  6                                                                                                                          $        -
                  7                                                                                                                          $        -
                  8                                                                                                                          $        -
                  9                                                                                                                          $        -
                 10                                                                                                                          $        -

                                                                                                                            Total Invoice:            -               -




C:\Documents and Settings\Default User\My Documents\d7c17cc8-a1b9-401c-919a-69042aaa75402                                                                                                                    Page 3 of 4
Event 1 Import Tools                                AP Invoice                                       11/22/2010
for Sage Timberline Office                                                                              3:00 PM
                                                    Sample Values

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


      Invoice Details
      Vendor                 1000
      Invoice                8192
      Description            Installation of heating unit
      Discount                          -
      Misc Deduction                    -
      Invoice Code 1
      Invoice Code 2
      Invoice Date           5/1/2001
      Date Received
      Discount Date
      Accounting Date        5/10/2001
      Payment Date           6/10/2001

      Distribution Details
      Commitment             01001-03
      Comm Item              1
      Job                    03-001
      Extra
      Cost Code              15-500
      Category               S
      Expense Account        21-5002
      Units
      Unit Cost
      Amount                 100
      Retainage              10
      Description            Installation
      Authorization          MP
      Joint Payee




C:\Documents and Settings\Default User\My Documents\d7c17cc8-a1b9-401c-919a-69042aaa75402 Page 4 of 4

								
To top