Feb
4
2016

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

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

To start importing a list of  expense entries follow these steps:

Notes:

  • Only CSV files / Text files (Comma Separated, Tab Delimited, Column separated can be import).
  • 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 function to quickly add your data in a spread-sheet and import into the system, here we explain how to import data using Microsoft Excel software.
  1. Open the Excel program
  2. In the first row add the fields “Date“, “Amount“, “Currency“, “Category“, “Vendor” and “Notes“.
  3. Under every cell fill in all the details as in this image.
  4. The Date field must be formatted the same as your system’s date format; in my case we use the DD/MM/YYYY format.
  5. The Currency filed field must be added in the country’s currency’s code, like such as USD, AUD, ..etc.
  6. All added category categories and vendors are automatically saved.income-expenses-excel
  7. After you have added all your items save the eExcel file as CSV (Comma delimited.).

    save as csv

  8. Log in to your online invoices system.
  9. From the “Finance” menu choose “Expenses“.
  10. Click the “Import” button from in the top right corner.kkjbhj
  11. The importing wizard will start. Step 1 Import Options :

    income-expence-import-1

    1. Choose the file to import (the CSV file we previously saved).
    2. From the Delimiters section choose “Comma Separated“.
    3. Click the “Import First Row” check box. If your file contains field labels in the first row don’t tick this box. In our case we will not tick the box.
    4. Click the “Next Step” button.
  12. Step 2 (Fields Mapping):

    income-expence-import-2

    1. In this step we will tell the system where the data is so the system can add it.
    2. The Amount* field is required and must exist in the file.
    3. Select a corresponding field in the file for each system field as seen in the above image.
    4. If you have entered a new category or vendor it will be saved in the system.
    5. Click the “Import” button.
  13. Step 3 (Importing):

    Import-projectstep-3

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

Contact us if you have any issues or more questions.

Leave a comment

This website is protected by 256-bit SSL security