Feb
4
2016

How to import a list of expense entries from a CSV file

You can add a numerous number of expense entries in a few steps without having to enter every expense entry one by one manually to the system by using the importing function. You can import the “Date”, “Amount”, “Currency”, “Category”, “Vendor” and “Notes” .

Start importing a list of  expense entries by following these steps:

Notes:

  • Only CSV files / Text files (Comma Separated, Tab Delimited, Column separated can be imported).
  • If you have any other file type you will need to open using an intermediate application, such as “Microsoft Excel” and save as CSV and import into the system.
  • You can use the import feature to quickly add your data in a spreadsheet and import it into the system, And here we explain how to import the data using Microsoft Excel software.
  1. Open the Excel program
  2. At the first row add the fields “Date”, “Amount”, “Currency”, “Category”, “Vendor” and “Notes”.
  3. Below every field fill out all the details as in this figure below.
  4. The “Date” field must be formatted the same as your system’s date format; in this case, we use the DD/MM/YYYY format.
  5. The “Currency” filled field must be added in the country’s currency’s code, such as “USD”, “AUD”, ..etc.
  6. All added categories and vendors are automatically saved.income-expenses-excel
  7. After you have added all your items save the Excel file as CSV (Comma delimited).save as csv
  8. Log in to your online invoices account.
  9. Through the “Finance” tab, select the“Expenses” option.

Click the blue marked “Import” button at the top right corner.kkjbhjThe importing wizard will start.

Step 1 Import Options:

income-expence-import-1Select the file that will be imported (the CSV file we previously saved).

  1. Through the “Delimiters” section, Select the”Comma Separated” option.
  2. Tick the “Import First Row” check box. If your file contains the same field labels existing at the first row so in this case, we will not tick the check box.
  3. Click the “Next Step” button.

 

 

Step 2 (Fields Mapping):

income-expence-import-2
We will map the fields (Columns) on the imported file to the corresponding fields on the system.

  1. The “Amount” field is mandatory and must exist on the file.
  2. Select a “Corresponding Field In File” for each system field as showing in the above figure.
  3. If you have entered a new “Category” or “Vendor” then it will be saved on the system.
  4. Click the “Import” button.

Step 3 (Importing):

Import-projectstep-3

  1. The system will take a few seconds to import the fields and save them.
  2. You can refer back to the “Expense” page to check the imported items.

 

This website is protected by 256-bit SSL security