Importing Accounting Lines

Process Overview

The import lines button is located in the upper right corner of the appropriate tab (for example, the Accounting Lines tab). This button allows you to import a csv file containing multiple lines of data into the tab.

Different types of e-docs use different import templates, but in some cases multiple e-docs use the same template.

The layout and format of the .csv import template files varies by document type. Using the incorrect format for the .csv file causes the import to fail. Note that, for financial transactions, a separate file is needed for each Accounting Lines tab section (for example, the From and To sections).

To get the templates for the csv files, navigate here.

Creating a .csv File

  1. Open the template file that corresponds to the type of financial transaction document you are working on.
  2. Add data to the file.
    image of data in excel
  3. Required field headings are marked with an asterisk and appear in red.
  4. If the file is to be used again in the future, save the file as an Excel workbook (don't delete the headers yet). If the file is not to be used again, skip this step.
  5. Delete the header rows at the top.
    deleting rows in Excel
  6. Save the file again, with a new name, in .csv format.
    saving Excel in csv format

Importing a saved .csv File

The import lines button is located in the upper right corner of the applicable tab.

  1. Click import lines on the top right of the Accounting Lines tab.
    import lines button in KFS
  2. The system displays additional buttons such as Browse, add, and cancel import.
  3. Click and locate the file you have created from your computer.
  4. From the Choose File window, select the .csv file to be imported and click open.
  5. Click add.
  6. The screen displays the imported data.

Notes on importing accounting lines from a .csv File

  • Be aware that if amounts have commas, your import file may not work. Be sure to change the column formatting to text to be safe.
  • Leading 0s can be handled by setting the column format to text.
  • Avoid commas in the Line Description.