Importing a Document from Clipboard #
1. Navigate to Admin Panel → Data Import Tool → Documents.
2. Select the document you would like to import.
3. The Import window opens, showing the columns required for this document. Required columns are necessary to record an entry and vary from one document to another.
4. If you would like to import additional data along with the mandatory columns, click Edit template to add more columns and tick the additional columns. Use the arrows to change the order of the columns.
5. Fill in the table manually or copy and paste data from a spreadsheet.
6. Tick the checkbox Cells contains value to select the data from the dropdown list.
7. Red triangle is a hint in each column that provides information about the input data format.
8. Click Next after filling in the table.
9. If all required fields were field, you will see the message in the bottom of the screen showing creation of all mapped documenrts.
Please note: All documents will be imported as drafts. If you need to import document as Opening balances refer to this page.
10. If a required field has been left blank (as in line 1 in the image below):
- The Data Mapping window displays all unmapped entries.
- Enter values for the required fields.
or Click the Import data button. If the required fields are not entered, they will be left empty.
11. After entering the missing fields, you can view the list of all mapped fields to check the entered data again. In the drop down menu, select Mapped items.
12. The confirming message will be the same as in step 9.
Importing a Document from File #
1. Navigate to Admin Panel → Data Import Tool → Documents.
2. Select the document you would like to import.
3. The Import window opens, showing the columns required for this document. Required columns are necessary to record an entry and vary from one document to another.
4. If you would like to import additional data along with the required columns, click Edit template to add more columns and tick the additional columns. Use the arrows to change the order of the columns.
5. After selecting the columns, click From file and Save the template to your computer.
6. Fill in the table and then click Import spreadsheet
7. The rest of the steps are the same as steps 8 to 12 of the Importing from Clipboard procedure.
Please note: All documents will be imported as drafts. If you need to import document as Opening balances refer to this page.