Expense ID – Zistemo Knowledge Base https://zistemo.com/knowledge-base Zistemo is the smartest app for instant time and expense tracking. Boost productivity and save time with zistemo. Tue, 14 Apr 2020 13:55:12 +0000 en-US hourly 1 https://wordpress.org/?v=6.0.2 Import Expenses https://zistemo.com/knowledge-base/content/import-expenses/ Mon, 14 Nov 2016 10:01:58 +0000 https://moneypenny.me/knowledge-base/?post_type=ht_kb&p=1430 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

import-expenses1

Next, you can download a sample file to see how this .csv would look. You can also view and download a sample file HERE.

import-expenses2

To create a .csv, select your file and click “Upload File”:

import-expenses3

Importing Expense Categories

When importing your expenses, one of the required fields in your .csv file is “Category” (expense category):

import-expenses4

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.

import-expenses5

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

ID           Name
2            Advertising Cost
3            Representation Cost
4            Food and Meals
5            Travel (Employees)
6            Travel (Owner)
8            Gifts and Giveaways
9            Sales Provisions and Commissions
10            Shipping, Transport, and Logistics
11            Packaging
12            Transport Insurance
14            Consulting Services
15            Research Services
16            Creative Services
17            Other Business Services
19            Office Supplies
20            Postage
21            Phone & Communication
22            Internet
23            Office Equipment
24            Books and Magazines
25            Training and Education
26            Small Equipment
27            Software
28            Hardware
29            Other Office Equipment
31            Rent
32            Heating and Ventilation
33            Gas
34            Electricity
35            Water
36            Trash
37            Cleaning
38            Maintenance
40            Car Running Costs
41            Car Insurance
42            Car Rental
43            Car Taxes
44            Car Purchase
45            Other Vehicle Purchase
47            Land
48            Buildings
49            Equipment
50            Machinery
51            Deposits
53            Investments
54            Patents and Rights
56            Finishing Goods
57            Raw Materials
58            Subcontracting
60            Insurance Premium
61            Membership Fees
62            License Fees
64            Legal Fees
65            Annual Report and Tax Fees
66            Bookkeeping Costs
68            Financial Fees
69            Interest Paid
70            Interest Received
71            Financial Adjustments
72            Owner Payment
73            Owner Withdrawal
75            Employee Salary
76            Employee Salary Tax
77            Temporary Employee Salary
78            Temporary Employee Salary Tax
79            Social Security
80            Medical Expenses and Sick Leave
81            Unemployment Cost
82            Non-Monetary Salary
83            Transport Costs from / to Work
85            Income Tax
86            Company Tax
87            VAT Payment
88            VAT Refund
89            Import VAT
91            Local Income Tax
92            Employer Social Security Costs

 

]]>