Knowledgebase
Spic&Scan Support Desk > Spic&Scan Support Desk > Knowledgebase

Search help:


(EN) What are the importing instructions for succesfully using Spic&Scan?

Solution


To have a succesfull import, your Spic&Scan file needs to comply to some basic demands.
- The Spic&Scan file must have one of the following formats: Excel (XLS of XLSX) of CSV (semicolon devided)
- The columnnames in the first row of your QuickScan-file need to be identical to the names in our uploadfile
- If a file is provided in CSV format: the correct way for dates is: DD/MM/YYYY and please use a comma as decimal separator

To have a minimum spendanalysis, your Spic&Scan file needs to contain the following columns:
- Date
- Amount*
- Supplier name and number

* All amounts reported in this software and your Spic&Scan file will be reported in Euro's, unless a valid 3-digit valuta code is mentioned in the Column 'Valuta'.
In that case, Spic&Scan is programmed to recalculate the amounts to EURO's, based on the currency-rates mentioned by the European Central Bank valid on the transaction day from the 'Date' Column.

 
Was this article helpful? yes / no
Related articles (EN) There are different currencies in my administration. Is that a problem?
(NL) Wat zijn de importeer-instructies?
(NL) Er staan verschillende valuta in mijn administratie. Is dat een probleem?
Article details
Article ID: 1
Category: (EN) Importing issues
Views: 195
Rating (Votes): Article rated 5.0/5.0 (1)

 
« Go back

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies