Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

Accounts receivable

Spreadsheet import - customer data

You can use the Spreadsheet Import wizard to import customer data, including beginning accounts receivable balances, from a spreadsheet file in .XLS or .XLSX format. This method can add new customer records or update existing ones.
note
Existing beginning balance values are not replaced but appended.

Prerequisites

  • Set up the following information before you start the import.
    note
    You can also add this information during the import.
    • Payment terms
    • Finance charges
    • Shipping type invoice items
    • Sales tax type invoice items. Before you begin the import, you'll need to set up global sales tax information to add sales tax invoice items.
Be sure you close the spreadsheet and it remains closed during the import process.
Be sure that the spreadsheet is not password protected.

Select the source file

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

Map spreadsheet columns

Use this screen to map the spreadsheet columns to specific data fields.
  1. If you saved mapping information from a prior import as a mapping template, that template is included in the dropdown in the
    Template
     box. If needed, select the template.
  2. If the spreadsheet includes column headings or other rows of data that shouldn't 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 correct mapping item from the dropdown in the
    Column <x>
     box above the grid.
    Mapping item
    More info
    Required?
    ID
    No
    Yes
    Customer Name
    No
    Yes
    EIN/SSN
    No
    No
    Tax Exempt #
    No
    No
    Address Line 1
    No
    No
    Address Line 2
    No
    No
    Address City
    No
    No
    Address State
    No
    No
    Address Zip
    No
    No
    Address County
    No
    No
    Address Country
    No
    No
    Phone
    Business, Car, Home, Mobile, Pager, Other
    No
    Phone Fax
    Extension
    No
    Email
    No
    No
    Website
    No
    No
    Beginning Balance Amount
    No
    No
    Beginning Balance Reference
    No
    No
    Beginning Balance PO#
    No
    No
    Beginning Balance AR Account
    No
    Yes, if beginning balance is a non-zero amount
    Beginning Balance Date
    No
    Yes, if beginning balance is a non-zero amount
    General Ledger Account
    No
    No
    Finance Charge
    No
    No
    PO#
    No
    No
    Payment Term
    No
    No
    Shipping Item
    No
    No
    Sales Tax Item
    No
    No
    Message
    No
    No
    Credit Limit Amount
    No
    No
    Credit Hold
    No
    No
    Prompt At Limit
    No
    No
  4. After you've mapped all columns, select
    Next
    .
  5. The application validates the spreadsheet data. If any errors are found, they are highlighted. If necessary, correct the data and then select
    Next
    .
  6. Import the information.

This article applies to:

  • Product: Accounting CS
  • Subject: Accounts Receivable,Import

Related Content

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close