Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Accounts receivable

Spreadsheet import - invoice items

Use the spreadsheet import wizard to import invoice item information from a spreadsheet using .XLS or Microsoft Excel file format .XLSX. Accounting CS will import the following invoice item types — Discount, Format, Item, Other charge, Sales tax, Service, and Shipping. Accounting CS won't import Group or Sales tax group items.
note
Remember to keep the spreadsheet closed during the import process, and make sure it's not password protected.

Select the source file

  1. Select
    File
    Import
    Spreadsheet
    .
  2. In the
    Source Data
     screen, select the client from the
    Client name
     field.
  3. Select
    Invoice Items
     from the dropdown list in the
    Data type
     field.
  4. In the
    Import File
     section, enter the path and file name of the spreadsheet file to import, or select
    Browse
     to find the file.
  5. Select the worksheet within the spreadsheet file to import.
  6. To have the spreadsheet import wizard skip all data-mapping screens for the additional data types, select the
    Skip data mapping screens
     checkbox. The application skips all data-mapping screens unless it needs input from you.
  7. Select
    Next
    .

Mapp spreadsheet columns

Use this screen to map the spreadsheet columns to specific data fields in Accounting CS.
  1. If you saved mapping information from a prior import as a mapping template, that template will be included in the dropdown in the
    Template
     field. If needed, select the appropriate template.
  2. If the spreadsheet includes column headings or other rows of data that should not be imported, select the checkbox in the
    Omit row
     column for that row. The application won’t validate or import data in that row.
  3. For each column, select the column heading in the grid, and then select the applicable mapping item from the dropdown in the
    Column
     field.
    Mapping item
    Additional info
    Required?
    ID
    Yes
    Description
    --
    Type
    Yes
    Price
    --
    Sales General Ledger Account
    Yes, for Items and Services
    Cost
    --
    Cost of Goods General Ledger Account
    Yes, if Cost is mapped
    Inventory General Ledger Account
    Yes, if Cost is mapped
    Tax Status
    --
    Discount
    Percentage Amount General Ledger Account
    -- -- Yes, if Discount is mapped
    Other Charge
    Percentage Amount General Ledger Account
    -- -- Yes, if Other Charge is mapped
    Sales Tax
    Description General Ledger Account
    Yes, if Sales Tax is mapped or Tax Status is "Additional" Yes, if Sales Tax is mapped or Tax Status is "Additional"
    Shipping
    Percentage Amount General Ledger Account
    -- -- Yes, if Shipping is mapped
  4. After you've mapped all columns, select
    Next
    .
  5. The application validates the spreadsheet data. If any issues occur, the invalid items are highlighted. Correct the data and then select
    Next
    .
  6. Continue by importing the information.

This article applies to:

  • Product: Accounting CS Client Access,Accounting CS

Related content

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close