4. Import Accounting Lines from Excel KFS line import templates allow you to import any number of accounting lines from a comma-delimited (.csv) file. Double click the Excel icon to open the RJV-template. Each document type has its own template. 1. The instructions for using templates to import multiple lines of data are described in the next few pages. Figure 22 The first step is to open the template and save it on your computer, where you can easily 1. find it again. Figure 23 The next step is to complete your Accounting Lines in the columns as indicated 1. (Red = Required). 2. You can enter as many lines as preferred/needed. You only need to complete one template for the RJV. Debit and Credit Please note: 3. amounts are indicated separately in different columns per accounting line.
4. Import Accounting Lines from Excel KFS line import templates allow you to import any number of accounting lines from a comma-delimited (.csv) file. 1. Double click the Excel icon to open the RJV-template. Each document type has its own template. The instructions for using templates to import multiple lines of data are described in the next few pages. Figure 22 1. The first step is to open the template and save it on your computer, where you can easily find it again. Figure 23 1. The next step is to complete your Accounting Lines in the columns as indicated (Red = Required). 2. You can enter as many lines as preferred/needed. 3. Please note: You only need to complete one template for the RJV. Debit and Credit amounts are indicated separately in different columns per accounting line.