Documentation/ ERP integrations/ Contasol
Contasol: exporting the entries
Contasol works by file export: Dijit.app downloads the import files and you load them into Contasol. The order they go in is not a whim: reverse it and Contasol rejects the entries.
Invoice list › tick › Export to Contasol
On this page
Before exporting
Check the invoices have the right supplier, date, net, VAT and nominal account. Whatever leaves here wrong will enter your books wrong, and correcting it afterwards costs far more.
Unlike direct sending, there is no validation here to warn you: the file is generated with whatever is there.
The modern format
- On the invoice list, select the ones you want to take across.
- Press Export to Contasol.
- The import files download in the modern format, as spreadsheets.
There are four files, and each has its part to play:
| File | What it carries |
|---|---|
| MAE | The chart of accounts. |
| PRO | The supplier master. |
| IVS | Input VAT details. |
| APU | The accounting entries. |
The import order
In Contasol they have to be imported in this order:
- The masters: MAE and PRO.
- Then IVS.
- And last of all APU.
The order is not a whim: the entries need the accounts and the suppliers to exist already. Load the entries first and Contasol rejects them.
It is this integration's number one mistake, and it produces a rejection that looks like a problem with the file when it is really a problem of sequence.
The older format: ContaPlus
If your installation is an old one, the button's drop-down arrow offers the ContaPlus (ASCII) option.
| Modern format | ContaPlus (ASCII) | |
|---|---|---|
| Files | Four spreadsheets | Two text files |
| Order | MAE and PRO, then IVS, then APU | XSUBCTA before XDIARIO |
| When to use it | Current installations | Older installations |
The logic of the order is the same in both formats: the sub-accounts first, then the entries that use them.
Which documents are exported
Only purchases and expenses. Sales do not go into this export.
If you tick documents of another type and the result is that there are no documents to export, that is usually the cause: what is ticked is not the type this export takes.
Invoices with withholding
Income tax withholding comes out of the entry as professional activity, which is what makes Contasol pick it up for the 111 return. It used to come out in a way that left the entry out of balance and had to be put right by hand.
The sign is right too: the withholding subtracts, both in the entry and in the export.
The risk of duplicating
Dijit.app will let you export the same invoices twice. It keeps no record of what you have already loaded, because it has no way of knowing whether the file was ever imported. Your accounting program, on the other hand, can duplicate the entries.
It is the fundamental difference from direct sending, where documents that go in disappear from the pending list. Here the control is yours.
A routine that works: export by closed periods, a week, a month, and note which period has already been loaded.
Things that come up
| What you see | Why | What to do |
|---|---|---|
| Contasol rejects the entries | APU was loaded before the masters. | Import MAE and PRO, then IVS, and last APU. |
| There are no documents to export | Nothing is ticked, or what is ticked is neither purchases nor expenses. | Tick purchase or expense invoices. |
| The integration is not enabled for this company | It needs switching on. | Write to support. |
| Entries have been duplicated | The same file was imported twice. | Keep a record of what has been loaded and export by closed periods. |
| The files are not the ones Contasol expects | The installation is an old one and needs the ASCII format. | Use the ContaPlus option in the button's drop-down. |