0
Under review

Export invoices for accounting

clement.triplet 1 year ago in Home Portal updated 1 year ago 3

Hi,

I am writing to you today as I have a question about XTRF and about how to configure exported data.

I need to export the invoicing information so that I can import it into my accounting software (specifically the invoice number, the date, the amount excl. VAT per language combination, the VAT rate, etc.).

However, I do not know how to obtain what I want: XTRF gives me merely the total amount invoiced, and I need this amount broken down by each line of the invoice. In other words, where an invoice is for a project involving several languages, I would like to be able to get the total excl. VAT per language in addition to the other information (VAT, incl. VAT, etc.).

I have not found any information on this issue either in the documentation or online.

Can you help me?

Thanks in advance and kind regards.

Answer

Answer
Under review

Such breakdown is not really possible in the Invoices module. Per design, one line there is one Invoice as a whole. 

Instead, you should take a look at Projects > Tasks view. 

Firstly, because it is the Task that ends up on an invoice. 

Secondly, you may filter by invoice attributes (show invoiced Tasks and filter by invoice date etc.). 

Task total Agreed, as well as VAT rate are there too. The only item missing is Gross total, but that's a matter of a simple Custom Column. 

I see you are using Tasks views extensively, so this should not be a mystery tour for you. Get back to your account manager if you need any customizations done.

Answer
Under review

Such breakdown is not really possible in the Invoices module. Per design, one line there is one Invoice as a whole. 

Instead, you should take a look at Projects > Tasks view. 

Firstly, because it is the Task that ends up on an invoice. 

Secondly, you may filter by invoice attributes (show invoiced Tasks and filter by invoice date etc.). 

Task total Agreed, as well as VAT rate are there too. The only item missing is Gross total, but that's a matter of a simple Custom Column. 

I see you are using Tasks views extensively, so this should not be a mystery tour for you. Get back to your account manager if you need any customizations done.

We had the same issue. We had a custom macro made for us to export data at the task level, as Maciej says, that includes the invoice detail, project/task detail, and the receivable descriptions. So for us, this was a necessary customization.

Ok I will ask to our contact.

Thank you for your help !