...
- Save the spreadsheet as a CSV file.
If you wish to do an import on both the income and expense sides, create two import files, one for each side.
Tip title Tip You may want to save frequently used templates on your desktop for easy access.
Navigate to ‘Internal Billing’.
Click on the question mark symbol next to the ‘Internal Billing’ heading.
You will be directed to the ‘Data Import Templates’ page. Locate the appropriate template for the eDoc.
Info title Info Many eDocs use the same Standard Import template.
Enter the Accounting Lines.
Info title Info The columns with red headings are required.
- The “Amount” column should contain no commas. In the ‘Amount’ column, change the format to General to remove any commas, if any are present.
- Delete the first three lines of text.
- Save the document as a CSV file. To do so,
- Click on Save As.
- From the drop-down menu next to ‘Save as type’, select CSV (Comma delimited).
- Click the Save button.
- In saving the file, you may receive a prompt(s) like the one shown below. Click Yes for these prompts.
- On the ‘Accounting Lines’ tab, click on the IMPORT LINES button.
- Click on Choose File.
- Locate your CSV import files.
- Click Open.
- Click the ADD button next to the filename.
Doing so will complete the process. Your Accounting Lines will be successfully imported into your eDoc.
Related Articles
...