Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Accounts receivable

Spreadsheet import - AR transactions

Use the Spreadsheet Import wizard to bring in your invoice, credit memo, cash, check, credit card, and write-off transactions from a spreadsheet. Just make sure your file is in .XLS or .XLSX format. Accounting CS saves these transactions as invoices, credit memos, or payments, which you can then manage or apply in the
Manage Customer Payments
 screen.
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 appropriate client from the
    Client name
     field.
  3. Select
    Accounts Receivable Transactions
     from the dropdown in the
    Data type
     field.
  4. In the Import File section, enter the path and filename 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, mark the
    Skip data mapping screens
     checkbox. The application skips all data-mapping screens unless it requires input from you.
  7. Select
    Next
    .

Map 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 to use as a mapping template, that template is included in the dropdown in the
    Template
     field. Select the appropriate template.
  2. If the spreadsheet includes column headings or other rows of data that should not be imported, mark the checkbox in the
    Omit row
     column for 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 <x>
     field.
    Mapping item
    Additional information
    Required?
    Transaction Type
    Yes
    Customer ID
    Yes
    Customer Name
    Yes
    Journal
    --
    Date
    --
    Reference
    --
    Payment Term
    --
    Due Date
    --
    PO Number
    --
    Accounts Receivable General Ledger Account
    Yes, for Invoices and Credit Memos
    Undeposited Payments General Ledger Account
    Yes, for Cash, Check, and Credit Card transactions
    Bad Debt Expense General Ledger Account
    Yes, for Write-off transactions
    Unearned Revenue General Ledger Account
    Yes, for Cash, Check, Credit Card, and Write-off transactions
    Message
    --
    Item
    ID Description Quantity Price Amount
    Yes, for Invoices and Credit Memos -- -- -- --
    Sales Tax Item ID
    Yes, for items with a taxable tax status
    Shipping
    Item ID To Amount Date Contact Salutation Contact Name
    -- -- -- -- -- --
    Payment Amount
    --
  4. After you map 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:

Related content

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close