Expenses are purchases/imports that you are doing for your business where you pay Input VAT. The Input VAT can be reclaimed or offset when calculating your VAT returns.
You can also watch a video below on how to upload imports as expenses in our software:
We have prefilled an Expenses template with all the mandatory fields for you, it can be downloaded here: Expenses template. Replace the example data with your data and check the comments for help.
Following fields are mandatory:
VAT reporting date - this field can be changed to a desired period, if you want to claim something in June, this date must show a June date
Buyer VAT number
Buyer VAT number country - The buyer vat number country must match to the arrival country
Seller VAT number (only for E.U. departure countries)
Seller VAT number country - The seller vat number country must match to the departure country. (only for E.U. departure countries)
- Seller billing name
Other related field: hellotax product ID or SKU, fill in one or the other
Item VAT rate
Item gross unit price
- Report currency
|Field||Transaction type||Invoice number|
|hellotax Product ID||SKU||Item VAT rate||VAT country||Item gross unit price||Seller Billing name||Buyer VAT number||Buyer VAT number country||Seller VAT number||Seller VAT number country|
|Format and value that should be filled in||expense||1231-1235, can be a number series, can contain"-" in-between, that appears on the actual invoice||yyyy-mm-dd,|
|the country where the goods are shipped to,|
ISO code e.g DE, FR
|the country from where the goods are shipped, ISO code e.g DE, FR||currency you use to report your transactions, ISO 3 letters code e.g. EUR, USD||Product ID that you can find in the hellotax "Products menu"||stock keeping unit, a machine readable code that you assign to your products||Item vat rate is a number between 1-100, it is the vat rate of the country where it is taxed||the country where the goods are taxed||this prices contains the vat amount, and can have floating point value e.g. 25.99||the name of the vendor from where you bought or imported goods and service as it appears on the invoice||your VAT number , should be in the format stated here.||your VAT country; The buyer|
number country must match the arrival country, ISO code e.g DE, FR
|your Seller's VAT number , should be in the format stated here.||your Seller's VAT country; The seller|
number country must match the departure country, ISO code e.g DE, FR
In case you do not fill out those fields, you won't be able to upload the file and you will receive an error.
Important information if you fill in optional fields:
Original currency - optional to fill in
If the original currency is provided by you, the report currency must be a different one.
After you successfully upload data, you can find it in the order menu by filtering on Manual Input.
Want to upload sales and/or refund invoices, read how here.
Want to upload movement of goods invoices, read how here.