DOCUMENTATION

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

  1. Open it

    Choose the period with the date presets.

    Where: Reports → Invoices analysis

  2. 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.

  3. Split into columns

    + in the top-left cell adds a column grouping. Flip axes swaps rows and columns.

  4. Choose measures

    Measures: untaxed, tax, total, quantity (base units) or count of invoices. Sort by amount orders rows highest or lowest first.

  5. Filter

    Invoiced or Draft, Customers or Vendors, Invoices or Credit notes.

  6. 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.
Analyse sales in a pivot table or chart | ASKERP Docs