Feb
4
2016

How to import a list of income entries from CSV file

You can add many income entries with few steps without having to enter every income 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  income 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 “Date“, “Amount“, “Currency“, “Category“, “Vendor” and “Notes“.
  3. Under every cell fill all the details as in this image.
  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 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 system.
  9. From “Finance” menu choose “Income“.
  10. Click the “Import” button in  the top right corner.incomes
  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 “Incomes” page to check the imported items.

Contact us if you have an issue or more questions.

Leave a comment

This website is protected by 256-bit SSL security