To export invoices, access the sidebar menu, select Sales>invoices>Export
From filters section at the listing page user can sort data on the basis of: Customers, Invoice status, Period
If invoices are being exported after applying some filter, then only the filtered invoices will appear in the excel file.
If no filter has been applied, then, all the invoices will be exported from beginning of current year to till date.
Excel sheet will have information about: Company name, Period for which invoices are exported, Customer name, Invoice number, Date of invoice, Due date of invoice, Invoice status (settled, partial settled, approved or draft), Invoice amount (bifurcated into Base amount, discount and taxes), Amount received (if any), Amount due, Whether email sent or not.
At the bottom section of excel ‘sum or total’ of monetary columns is to be provided.