Avansovka Integration in 1C
Avansovka can be integrated easily into 1C. No changes of any accounting processes are necessary. All that is needed is to upload a simple module to 1C and for the Avansovka App user to set up the Avansovka App correctly for automatic syncronization.
How does Avansovka work with 1C
Avansovka works very easily with 1C. The Avansovka App on the mobile generates an XML file. This file contains all the relevant expense data added to the App which is send with the other data (pictures, details of the expenses) to the accountant. The Accountant then just needs to add to his 1C a small module to read the XML file. All data is now in the Avansovka 1C module. Next the accountant can transfer the data in the 1C module when needed to 1C and do his normal work in 1C with expense reports. Simple. Straigh forward and free!
How to set up the Avansovka App for automatic Syncronization
In order for 1C to understand to which employee and to which company the expenses belong the user has to correctly enter certain data into the Avansovka App. This is
- Set up sheet – Personal data – employee number 1C
- Set up sheet – Corporate information – INN and KPP
If this is set up correctly the data can be automatically allocated in 1C to the employee. The data for above, especially the employee number the Avansovka App user should get from his accountant.
Person Information Setup
Select the small wheel on the right lower corner.
Select the first tap, Personal Information.
Fill in – the must field – 1C Employee Number.
Corporate Information Setup
Select the small wheel on the right lower corner.
Select the eight tap – Corporate Information.
The 1C Plugin
Please download here the plugin to your computer and install it:
Plugin for 1C 3.0
Versions of 3.0 are
- XXX
Install it by uploading this file.
https://drive.google.com/file/d/0B7wfLyBvgSQqaTZUVmJ2OWdfZnc/view?usp=sharing
XXX
Plugin for 1c 2.0
The plugin for 1C 2.0 will be provided in the near future.
How to generat an XML file on Avansovka
XML Files are generated in Avansovka on the reporting sheet.
Each send function in the reporting sheet – the small mail envelops have a selection – per email send 1C data -.
See here the example.
If this category is selected a so called XML file is added.
The XML file looks like this:
Left side from the email client on your mobile – see the XML file attached. And on the right side an open XML file.
Important to enter the personal and company information as documented above in order to do the automatic integration.
This file is the basis what the accountant uploads to 1C.
The 1 C Plugin
The Email tool test
The Plugin test if an email client is available. If so additional functions become available on how to communicate between the Accountant working with the data and the user of Avansovka who send all information by email.
Upload a single XML File
The standard view. 4 main taps available. Here is marked upload single xml files into the plugin.
And here is the data that was uploaded by the XML file
Here the uploaded data from the XML file.
Uploading multiple XML files
It is also possible to upload a full folder of XML files. Not just single files.
Numbering of the expensense uploaded
How to generate an expense report based on the data uploaded
And here one of the key functions. Select the expenses that you like to have included in an expense report. And then just send them to 1C and process them there.
Adding expenses to other already existing expense reports
It ia also possible to add the uploaded expenses to existing expense reports.
This is version 1.0 of the Avansovka 1C Plugin. The plugin will continously be further developed and improved to simplify expense reporting in Russia.