File export to Xledger
When exporting to Xledger, it can be good to have an understanding of which fields from RecMan are included in the file export. We will explain this in more detail in this part of the article. The first thing to do is generate the Xledger files, which is done by selecting the relevant invoices and clicking on the Xledger. Then, you will get two files you can download (shown in the image below) in the CSV format.
As you can see from the files, a customer file and a voucher file are generated. The customer file is of Xledger file type SL02, and the attachment file is of file type AR10 (GBAT10).
These files can be opened in Excel if you use Windows or Numbers if you use a Mac. It can be done to see what information is included and what lines they come up with. If you open it in Excel, the different lines are in separate columns and rows. If you have an understanding of how information is obtained, it is easier to interpret error messages and know what the possible problem is.
Customer file SL02
Attachment file - AR10
Here is an overview of what is included in the file from RecMan.
| Column | Information | Export debit account | Export credit account | Export VAT account |
|---|---|---|---|---|
| A - 1 | File type - Is «GBAT10» in this field. | x | x | x |
| B - 2 | Invoice number | x | x | x |
| C - 3 | Invoice date (yyyymmdd) | x | x | x |
| D - 4 | Not in use | |||
| E - 5 | Month | x | x | x |
| F - 6 | Year (yyyy) | x | x | x |
| G - 7 | Account number | x | x | x |
| H - 8 | VAT account | x | ||
| I - 9 | Invoice sum (to two decimal places) | x | x | x |
| J - 10 | Customer number | x | ||
| K - 11 | Not in use | |||
| L - 12 | Customer name | x | x | x |
| M - 13 | Address Line 1 | x | ||
| N - 14 | Zip code | x | ||
| O - 15 | City | x | ||
| P - 16 | Invoice number | x | x | x |
| Q - 17 | Kid number | x | ||
| R - 18 | Due Date (yyyymmdd) | x | ||
| S - 19 | Not in use | |||
| T - 20 | Not in use | |||
| U - 21 | Customer number and customer name | x | x | x |
| V - 22 | Not in use | |||
| W - 23 | Not in use | |||
| X - 24 | Department number | x | x | x |
| Y - 25 | Not in use | |||
| Z -26 | Not in use | |||
| AA - 27 | «T» –True or «F» – False. | X = "T" | X = "T" | X = "F" |
| AB - 28 | If "T" in column AA - 28, then the invoice sum comes here (ignores the invoice sum that was included in column J - 9. If "F" in column AA, it will only say 00.00 here. | x | x | x |
| AC - 29 | The letter X is written here | x | x | x |
Sample files
File Export provides you with two CSV files: customers and appendices.
- Invoice- Customers, appendices
- Credit note - Customers, appendices