Import CSV

Use the attached template to upload your data. The template can be opened and edited in Microsoft Excel. Always save the template as a .csv file.

The data is arranged in 5 columns

Number:    Ledger account number

Name:       Ledger account name

Amount:    Amount

Period:      Period Number

Year:         Fiscal Year

Amounts

• Asset accounts are expected to have a positive value

• Liabilities accounts are expected to have a negative value

• Revenue accounts are expected to have a negative value

• Cost accounts are expected to have a positive value

Profit & loss as cumulative values 

Use cumulative values for Profit & Loss accounts for the book year. Use the total amount from the beginning of the book year.

Some useful facts

• When you import data for a period, all existing data for that period will be deleted. Make sure all accounts are listed in the file for the period that you want to import.

• A ledger account can only have one value per period. If there are several values for the same period in your import sheet, the file can’t be imported.

• You can determine the periods that you want to import yourself. It’s possible to import 1 month or multiple years at the same time. Periods do not have to be sequential.

• Store your import files in a safe location so you can always go back to the previous version if you make a mistake.

• We advise to remove periods that are locked from the import sheet.