Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Accounts receivable

Import process

No matter what type of data you are importing, after you select the prerequisites for the type of data, then the import process is the same.
  1. Select
    File
    Import
    Spreadsheet
    .
  2. In the Source Data screen, client and data type.
  3. Enter the path and file name of the spreadsheet file or select
    Browse
     to locate the file.
  4. Select the worksheet within the spreadsheet file.
  5. Optionally, select
    Skip data mapping screens
     to bypass all data-mapping screens unless input is required.
  6. Select
    Next
    .
  7. Map spreadsheet columns
  8. Use this screen to map spreadsheet columns to specific data fields.
  9. If you have a saved mapping template, select it from the
    Template
     dropdown.
  10. To omit rows that should not be imported, select the checkbox in the
    Omit
     row column for those rows.
  11. Select
    Next
    .
  12. Map more data types
  13. Depending on the columns mapped, additional Data Mapping screens may appear. These screens allow you to map the spreadsheet data to corresponding Accounting CS data.
  14. Options:
    1. Clear Mapping: Clears any changes made in the current Data Mapping screen.
    2. Show all mappings: Displays all mapped and non-mapped items. Clearing this checkbox shows only items that need attention.
    3. Reset default to: Sets a default action for blank fields mapped to required fields (Add as is, Do not import, or a blank field).
  15. Data mapping screens
  16. Depending on the options you've selected above, you can add more details for the following:
    1. Customers
    2. Chart of accounts
    3. Payment terms
    4. Finance charges
    5. Shipping items
    6. Sales tax items
  17. Select the option that applies and either
    Add as is
     or
    Do not import
    .
  18. If you select
    Add as is
    , the application opens a subsequent payment term Data Mapping screen, based on the due date type you select.
    1. Day Based.
       Enter the number of days after the transaction date to use as the due date.
    2. EOM Based.
       Select the month on which to base the calculation of the expiration date. EOM represents the last day of the current month; EOM+1 represents the last day of next month; EOM+2 represents the last day of the month after next and so forth.
    3. In the
      Days +/- from EOM
       column, specify the number of days from the last day of the month.
    4. In the
      Cutoff day
       column, enter the number of days from the beginning of the month to represent the cutoff day.
  19. Review import data
  20. Go to the Data Analysis screen to review the import.
  21. Select
    Back
     to make changes.
  22. Select an item in the list, then select
    Preview Selected
     or
    Print Selected
     to see a diagnostic report.
  23. Select
    Finish
     when done.
  24. Complete the import
  25. The Import Complete screen shows you a summary of the imported information.
  26. You can review the information again.
  27. Select
    Print
     to see a report or select
    Finish
    .

This article applies to:

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close