Xledger (Invoicing file export)

Turn on Xledger as an option for invoice export

Go to System Settings → Economy → Invoice export and scroll down to find and check Xledger as the option.

Then, Xledger will appear as a choice in the invoice overview when you have ticked the relevant invoices. Before exporting an invoice, however, it is important to enter some information inside RecMan for the connection to Xledger to be smooth.

Connect RecMan products to Xledger

Go to the Product overview in the Economy module.

Here, you get a complete overview of all the products you have created in RecMan. When creating products, it is required to add the name and product number. Apart from that, no other information is required. To link the products to Xledger, you need to add some information here. The fields that must be in place and match Xledger are:

• Credit account
• Debit account
• VAT code
• VAT account

The picture below shows where you enter the credit account, debit account and VAT code. As stated, these must correspond to similar information that is registered in Xledger.

The last thing you do in the product overview is to add a VAT account. This field can be found under the actual overview of the products.

After the information here has been added and stored, and it has been seen that the information corresponds to that contained in Xledger, it is mostly ready for invoice export. The final step is to make sure that the customer numbers in RecMan match those in Xledger.

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, this 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 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.