In order to create an expense in zistemo, you have two options:
1. You can do it manually, by clicking the “Add Expense” button or
2. By import through .csv file (click the “Import” button -> choose ‘Import as CSV’ OR open user menu -> ‘Import’ -> choose ‘Import Expenses’ and click ‘Import’).
Note: Please use “UFT-8” for encoding
Next, you can download a sample file to see how this .csv would look. You can also view and download a sample file HERE.
To create a .csv, select your file and click “Upload File”:
Importing Expense Categories
When importing your expenses, one of the required fields in your .csv file is “Category” (expense category):
If you use one of the existing categories, the system will take it from the existing list (find “Expense Categories” list in “Purchases” -> “Expense Categories”). If you use a category that’s not on the list, this new category will be added automatically to the “Expense Categories” list.
IMPORTANT: if you use the existing categories, remember to also fill the “Category ID” column to prevent mistakes. By the way, if you did not enter the correct ID (check out the list below to see the default IDs used in zistemo), the system will use the category with the ID you provided, which will override the existing (default) one.
Example: In zistemo, Advertising Cost ID is 1 and Representation Cost ID is 3.
If you enter “Advertising Cost” in the “Categories” column, but in the “ID” column you insert “3”, then this imported expense will be related to the category “Representation Cost”.
zistemo “Default Categories” and IDs
|4||Food and Meals|
|8||Gifts and Giveaways|
|9||Sales Provisions and Commissions|
|10||Shipping, Transport, and Logistics|
|17||Other Business Services|
|21||Phone & Communication|
|24||Books and Magazines|
|25||Training and Education|
|29||Other Office Equipment|
|32||Heating and Ventilation|
|40||Car Running Costs|
|45||Other Vehicle Purchase|
|54||Patents and Rights|
|65||Annual Report and Tax Fees|
|76||Employee Salary Tax|
|77||Temporary Employee Salary|
|78||Temporary Employee Salary Tax|
|80||Medical Expenses and Sick Leave|
|83||Transport Costs from / to Work|
|91||Local Income Tax|
|92||Employer Social Security Costs|