Analyse sales in a pivot table or chart
Invoices Analysis totals invoice lines by month, customer, product, category or salesperson, in rows and columns, as a table or a chart, and downloads to Excel.
Aasan alfaaz mein: Invoices Analysis mein sale ko mahine, customer, product, category ya salesperson ke hisaab se rows aur columns mein dekhein, table ya chart ki shakal mein, aur Excel mein download karein.
Step by step
Open it
Choose the period with the date presets.
Where: Reports → Invoices analysis
Group the rows
Use the quick buttons (Month, Customer, Product, Category, Salesperson), or + on any row to add a level under it and − to remove it.
Split into columns
+ in the top-left cell adds a column grouping. Flip axes swaps rows and columns.
Choose measures
Measures: untaxed, tax, total, quantity (base units) or count of invoices. Sort by amount orders rows highest or lowest first.
Filter
Invoiced or Draft, Customers or Vendors, Invoices or Credit notes.
Chart and Excel
Graph shows bar, stacked, line or cumulative charts. Excel downloads the table as it is shown.
What happens in the books
- Figures come from invoice and bill lines (what was invoiced); credit notes count negative. Ledger balances are in the accounting reports.