Import expenses – 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

 

]]> Import Expenses from Shoeboxed/Expensify https://zistemo.com/knowledge-base/content/expenses-import-concurshoeboxedexpensify/ Wed, 14 Dec 2016 12:13:24 +0000 https://moneypenny.me/knowledge-base/?post_type=ht_kb&p=1614 Expensify
Shoeboxed
Xero
Expenses Import

To integrate zistemo expenses with Expensify or Shoeboxed, first, you have to set it up in “User menu” -> “Integration”.

Expensify

Click the “Expensify” button. Here, you need to fill “Client ID” and “Client Secret”. To get it, click the green link in the header – “Integration settings”:

expenses-import-from2

Then click “Click here to regenerate your partnerUserSecret”.

expenses-import-from3

Copy the data:

expenses-import-from4

and insert it in the “Expensify” integration settings screen, as shown below:

expenses-import-from5

Note: if you want to export expenses from Expensify to zistemo – first you should create the expense report and attach expenses to this report in Expensify.
The expense currency should be the same as in your zistemo account.

Shoeboxed

To integrate zistemo with Shoeboxed, you need the “Client ID” and the “Client Secret”.

expenses-import-from8

To get it, go to your Shoeboxed account –> open “Settings” -> choose “My API apps” tab -> and click “Create a new API app”.

expenses-import-from9

Now add your “Company name” (or any other relevant info/name) to the “Company/app name” field, then copy the URL from your zistemo Shoeboxed integration window and insert to the “Redirect URL” field. Next, click “Save”.

expenses-import-from10

expenses-import-from11

After saving, you will see “ID” and “Secret”:

expenses-import-from12

Copy it to your “Shoeboxed” integration screen and click “Save”.

expenses-import-from13

Note: if you wish to export expenses from Shoeboxed to zistemo, it’s recommended to have them registered in Shoeboxed with category and amount. Also, you should use the same currency as in your zistemo account.
Shoeboxed lets you add more than one category to an expense, while zistemo only allows one. In this case, remember that zistemo will take the first category.

NOTE: If you change your mind, you should know that you can change/disconnect Xero, Shoeboxed, Expensify or Quickbooks at any time. Just go to the user menu ->  Integration and click “Disconnect”:


]]>