Sales - Export invoice totals due
When you export invoices, it gives you multiple lines for any invoice which has more than one line. It is therefore not possible to easily total up the amounts due because some invoices are on there multiple times meaning the values are overstated.

Hi Stewart, is there a way you see the export being more helpful for you. For example would you be looking for a summary of each invoice? The Receivable Summary and Detail reports maybe useful for this sort of view and can be exported.
-
Stewart Anderson commented
Hi, I'm not sure where these reports are?
I just want to be able to have a report where each invoice has 1 summary line of amount of invoice and amount owing, rather than it itemising each line on the invoice, which then means if you're trying to get totals it duplicates the total amounts meaning that the total is wrong.
-
Stanley Wood commented
I want to view a list of the invoices (with their Totals) by customers. I can look at invoices within Xero, and would like to me able to export what I see on the screen. Not all the additional information (expecially not the line item rows.
I just want the totals.