Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Financial setup

Setting Up Invoice Formats

Because companies may have multiple AP centers with different requirements, company system administrators can set up multiple formats for the invoice spreadsheet and the invoice summary pages. These files are included in the AP batch.
You can customize the invoice summary format by removing, adding, or changing financial and matter fields that appear at the end of the default format. The invoice spreadsheet should be formatted so that it contains all the information needed for your AP department to pay the invoices.
Two spreadsheet formats are supported:
  • Single-row format
    : Each invoice is represented by a single line. All invoice accounting code allocation rows are listed in the same line in the AP batch invoice spreadsheet. The standard row is the only source for the accounting code allocation rows content from the invoices. There is one standard row for each invoice included in the invoice spreadsheet.
  • Multi-row format
    : Each invoice is represented by multiple lines. Each invoice accounting code allocation row is listed on a separate line.
Tip | We recommend that you show the sample default single-row invoice spreadsheet, a sample default multi-row invoice spreadsheet, and the invoice spreadsheet specifications to your AP department so that they can determine which columns to include.
To set up new invoice formats, open the AP Routes page:
  1. Select
    Settings
     in the left navigation.
  2. In the
    Accounting and A/P Settings
     sections, select
    AP Route Configuration
    .
To create a new invoice spreadsheet format
  1. In collapsible section
    Step 2: Formatting
    , select
    Create new invoice spreadsheet format
    . You can find this option below your list of currently defined formats. It may be necessary to scroll down.
  2. Define the fields as they correspond to your invoice.
    Field Reference
    Field
    Description
    Name
    The name of your invoice spreadsheet format. When you assign the format to a particular AP Route, you select the format by name. Therefore, it is best to use an intuitive name that relates to the route to which the format will be assigned (for example, "European SAP").
    File format
    Comma Separated Value (.csv)
    : If the invoice spreadsheet is in the Comma Separated Value format, text is surrounded by double quotation marks. Numbers do not have quotes. For example, a line in a Comma Separated Value file would appear as: "CompanyName," 100.00, "MatterName."
    Pipe Delimited
    : In a pipe delimited file, all fields are separated by a vertical pipe character. For example, a line in a pipe delimited file would appear as: CompanyName | 100.00 | MatterName.
    Multiple item field format
    Comma Separated Value (.csv)
    : If the invoice spreadsheet is in the Comma Separated Value format, text is surrounded by double quotation marks. Numbers do not have quotes. For example, a line in a Comma Separated Value file would appear as: "CompanyName," 100.00, "MatterName."
    Pipe Delimited
    : In a pipe delimited file, all fields are separated by a vertical pipe character. For example, a line in a pipe delimited file would appear as: CompanyName | 100.00 | MatterName.
    File Extension
    The file extension is made up of the last three letters of the file name. For example: invoicespreadsheet.csv. Enter the file extension you would like on the invoice spreadsheet file when the AP Batch is run. For a comma separated values file, type
    csv
    . For a pipe delimited file, type
    txt
    .
    Date Format
    Use the dropdown to select the date format to use for the invoice format.
    Delimiters
    A delimiter is a character, or a combination of characters used to separate items of data. Most delimiters are characters that will not be used in the data, such as "|" or "[]".
    • Beginning-of-File Delimiter: If selected, select a dlimiter and decide if it is on a separate line.
    • End-of-File Delimiter: If selected, select a delimiter and decide if it is on a separate line.
    • Beginning-of-Row Delimiter: If selected, select a delimiter.
    • End-of-Row Delimiter: If selected, select a delimiter.
    Invoice inclusion rules
    • Include reversed invoices: If this box is checked, reversed invoices are allowed. Clear this box to exclude reversed invoices.
    • Include reversal invoices: If this box is checked, reversal invoices are allowed. Clear this box to exclude reversal invoices.
    • Include credit invoices: If this box is checked, credit invoices are allowed. Clear this box to exclude credit invoices.
    • Include zero amount invoices: If this box is checked, zero amount invoices are allowed. Clear this box to exclude zero amount invoices.
    File header and trailer
    The
    File header and trailer
     section includes options for including a row of summary information at the beginning and/or end of every file (the date the batch was run and the total number of invoices, for example). You might also choose to specify a constant value to appear at the beginning or end of the file, such as "Acme Company Legal Invoices."
    • Include unique header row at the beginning of the file: Select or clear the box to indicate if you want to include a header tow. If you select the box, a section appears that lets you select the column order and column value from the fields.
    • Include unique trailer row at the end of the file: Select or clear the box. If you select the box, a section appears that lets you select the column order and column value from the fields.
    Invoice header and trailer
    The Invoice header and Invoice trailer sections include options for including a row of summary information at the beginning and/or end of every invoice. You might also choose to specify one or more constant values to appear at the beginning or end of each invoice.
    • Include unique header row at the beginning of each invoice
      : Select or keep the box clear. If you select the box, then select the column order and column value from the fields. See the Invoice Spreadsheet Specification for a complete list of the fields.
    • Include unique trailer row at the end of each invoice
      : Select or keep the box clear. If you select the box, then select the column order and column value from the fields. See the Invoice Spreadsheet Specification for a complete list of the fields.
    Allocations
    • Allocation format
      : Use the dropdown to select single row or multi-row format.
    • Include Column Header Row
      : (Single-row format only) If this option is selected, there will be one allocations header row output for each invoice (displayed before that invoice's allocation rows).
    • Include allocations header
      : (Multi-row format only)
    • Include allocations trailer
      : (Multi-row format only)
    • I
      nclude empty allocation rows
      : (Multi-row format only) Because some AP systems require that there are always the same number of allocation rows, there is the option to include empty allocation rows. If there are fewer than the maximum number of allocation rows (100), empty allocation rows are included until the maximum number of allocation rows (100) has been created. When this option is selected, the invoice always contains the maximum number of allocation rows, but some may be empty.
    Allocation rows format
    Include Column Header Row
    : If you select this option, there will be a header row before the section of the invoice spreadsheet that contains the standard rows. There will be one standard row header for each invoice spreadsheet.
    For single-row format, the standard rows follow the standard row header, and the standard rows are contiguous in the invoice spreadsheet. There is one standard row for each invoice included in the invoice spreadsheet.
    When using enhanced (mode) accounting code allocations, the allocation row information from invoices is only output in the allocation rows. Unlike simple (mode) accounting code allocations, the standard row does not include any invoice accounting code allocation content.
    The column choices do not reference specific allocation rows. Instead, you select columns for: accounting code types, allocation percentage, allocation amount, and comment. The spreadsheet that is produced will contain an allocation row for every allocation row for all the included invoices.
    Column
     corresponds to the columns in your spreadsheet.
    Column Name/Data
    corresponds to the information that will appear in that column. When you specify an option, a list appears. Scroll through the list to locate the value that corresponds to your column.
    When you select an option, a new column option appears.
    Standard rows
    For single-row format, the Standard row is the only source for the accounting code allocation rows content from the invoices. There is one Standard row for each invoice included in the invoice spreadsheet.
    Column
     corresponds to the columns in your spreadsheet.
    Column Name/Data
    corresponds to the information that will appear in that column. When you specify an option, a list appears. Scroll through the list to locate the value that corresponds to your column.
    When you select an option, a new column option appears.
  3. On the toolbar, select
    Save & close
    .
Invoice Fields from the Accounting tab on the Invoice
Some of the spreadsheet information corresponds to fields on the invoice's
Accounting
tab.
For example, the
Comments
field on the
Invoice tax configuration and cost allocations
 section of the invoice can be added to the spreadsheet. Select
Allocation Comments To AP
 from the dropdown.
You can also include the
Comments to AP
 field that appears on the
Accounting
tab in the
Other Invoice Accounting Details
 section. Select
Allocation Comments To AP
from the drop-down list. You cand find this option in the
Invoice Data
 section in the dropdown.
To copy an existing invoice spreadsheet format
  1. In collapsible section
    Step 2: Formatting
    , select
    Copy to new format
    next to the format you want to copy. Tip | You can select the hyperlinked name of a defined format to open it and view the settings.
  2. Give the new format a unique name, and then configure it as appropriate.
  3. On the toolbar, select
    Save & close
    .
To create a custom Invoice Summary format:
  1. In collapsible section
    Step 2: Formatting
    , select
    Create new invoice summary format
    .
  2. In the
    Invoice Summary Format Name
     field, type a name for the format. This name will be used to identify the format when you are selecting formats for your AP routes.
  3. In the
    Additional Financial Information
     and
    Matter Information
     collapsible sections, click
    Remove
    next to any row you want to remove from the format.
  4. To add a row, select
    Add additional row
    . Use the dropdown to select the value for rows you want to add.
  5. On the toolbar, select
    Save & close
    .
To configure the invoice spreadsheet:
  1. Under
    Step 2: Formatting
    , select the name of a spreadsheet to edit.
  2. On the new window that opens, scroll down to the Standard Rows section.
  3. Select the required columns from the dropdowns. You can find the following under Invoice Data on the dropdown:
    • Billed to Entity
    • Billed to Address
    • Client Name
    • Billed to Address
    • Tax ID
    • Street
  4. If you want to assign a custom name to the column, enter it in the
    Custom Column Name
     (Optional) field.
  5. On the toolbar, select
    Save & close
    .
Converting from Single-Row Format to Multi-Row Format
If you have never used the enhanced accounting codes mode, all of your AP batch invoice spreadsheet formats will be single-row format. If and when you enable the enhanced accounting codes mode, you should strongly consider converting your invoice spreadsheet formats from single-row format to multi-row format.
  1. Select
    Settings
    in the left navigation.,
  2. Under
    Accounting and A/P Settings
    , click
    AP Route Configuration
    .
  3. Under
    Step 2: Formatting
    , open the single-row invoice spreadsheet format that you want to convert and print out (or otherwise note) the Standard rows column selections for Allocations.
  4. On the toolbar, click
    Cancel
    to exit from the single-row format.
  5. Click
    Copy to new format
     next to the existing single row format you wish to convert to multi-row format.
  6. Give the new format a unique name and save.
  7. Open the new invoice spreadsheet format.
  8. Scroll down to
    Allocations - Allocations format:
     and select
    Multi-Row (enhanced mode)
    .Tracker displays a warning about changing to multi-row format. The directions will advise you about what to do to avoid problems.
  9. The
    Allocation format
     will change to multi-row format and allocation-specific columns will be deleted from the Standard Rows columns selections. The
    Allocation row format
     section is now available.
  10. Select allocation columns in the
    Allocation rows
     format section that are equivalent to the allocation columns that were deleted from the
    Standard rows
     section (after you converted from single-row to multi-row in Step 2 above). Note that the multi-row format simplifies this process. You select one column for each accounting code allocation row element. Your selection represents all allocation rows. The invoices spreadsheet will contain one row for every allocation row from each invoice.
    • You can reorder your column selections by drag and drop using the grip tape icons to the left of the column letters.
    • To delete a column, select the blank column name at the top of the column names menu and move the blank column to the bottom of the list. The blank column will be omitted from the results when you save.
    • If you select the Include empty allocation rows option, then the invoice spreadsheet will contain 100 allocation rows for each invoice. Blank rows will be included for rows that do not contain allocation row data. If your invoice spreadsheet appears to be missing data, check to see if this option has been selected. If you have included empty allocation rows, you may need to scroll down past the empty rows before you can see the next invoice.
  11. On the toolbar, select
    Save & close
    .
Including the Billed To Entity in AP Batch Documents
If a Billed to entity is included in an invoice and you would like it to appear in the AP batch files sent to your AP department, you must configure the invoice spreadsheet and invoice summary to include the Billed to entity.
Scroll down to the
Standard Rows
 section and select the required columns from the dropdowns.
You can find the following under
Invoice Data
 on the dropdown:
  • Billed to Entity
  • Billed to Address
  • Client Name
  • Billed to Address
  • Tax ID
  • Street
In the
ADDITIONAL FINANCIAL INFORMATION
 section, select
Billed to
 from the drop-down menu.

This article applies to:

  • Product: Legal Tracker
  • Subject: Invoices
  • Audiences: Company