Sales, purchase and party reports

Reports for your sales, purchases, day-to-day transactions, and money owed by and to your parties.

Updated

These reports live in the Transaction and Party groups on the Reports screen.

Transaction reports

  • Sale report — every sales invoice in the period, with totals. Filter by Party or by Status (Draft, Unpaid, Partial, Paid).
  • Purchase report — every purchase bill in the period. Also filters by party and status.
  • Day book — everything that happened on your chosen days — sales, purchases, payments and more — in one list, like a diary.
  • All transactions — sales, purchases, and returns together. Filter by Type (Sales, Purchase, Sales return, Purchase return).
  • Sales order report — every sale order in the period, with its total, how much has already become an invoice (Converted), and how much is still pending. A cancelled (Closed) order shows nothing as pending. A second view, Sales order items, lists what each order was for — ordered, fulfilled and pending quantities, rate, discount, tax and total. That view shows one row per item, so an item you put on the bill twice is added up into a single row, and its Rate is the average price without tax.

Party reports

  • Receivables aging — how much each customer owes you, sorted by how long it has been outstanding, so you can see overdue money. It ages unpaid bills by their bill date — a carried-in opening balance has no bill to age, so it counts in All-party balances but not here, and the two reports can rightly show different totals.
  • Payables aging — how much you owe each vendor, the same way.
  • All-party balances — the current balance for every customer and vendor in one list, the same figure as that party’s statement: any opening balance you entered and any advance payments count too. A party the shop owes — a vendor, or a customer due a refund — shows under Payable, never as a minus in Receivable. Money owed on bills with no party gets its own Unassigned / walk-in line, and a party you deleted still counts, on a Deleted parties line — removing someone never writes off what they owe, it only takes their name off the report. A party you merely hid from your list is not on that line: hiding changes nothing here, so they stay listed under their own name. The Total row shows Receivable and Payable separately, so one party owing ₹50,000 and another owed ₹50,000 reads ₹50,000 / ₹50,000, not zero.
  • Sale/purchase by party — how much business you did with each party.
  • Party-wise profit & loss — sales, purchases, gross profit or loss and margin for each party, plus the current balance. A loss is named Loss in its own column. Amounts are before GST with returns netted, and cost comes from your item purchase price — the same cost basis as the profit reports, though counter sales with no party are not listed here. Click a row to open that party’s statement.
  • Party report by items — pick a party and see, item by item, what you bought from them and sold to them: quantities, amounts, and profit or loss. Amounts are before GST with returns netted, profit uses your item purchase price (the same cost basis as the profit reports), and only catalogue items are listed — free-text bill lines are not. An item you only bought shows a blank Profit/Loss — nothing was sold, so there is no profit to claim, and blank is not ₹0.00. If any item you sold has no purchase price on its item card, its profit — and the profit total — stay blank until you set one: an unknown cost is never shown as zero. Click a row (with a party picked) to open that party’s statement; under All parties the app asks you to pick a party first.
  • Items report by party — the reverse view: pick an item and see every party who bought or sold it, with quantities, amounts, rates, and profit or loss. The Purchase Rate and Sales Rate are weighted averages across the period (total amount divided by total quantity), not the last price entered. Amounts are before GST with returns netted, profit uses your item purchase price (the same cost basis as the profit reports), and only parties on your books are listed — walk-in cash sales have no party to show. A party you only bought from shows a blank Profit/Loss, and one you sold to with no purchase price on the item blanks its profit and the total. Click a row to open that party’s statement.

Set the date range and export any of these to CSV, PDF, or Excel. Amounts show in ₹ and dates as DD/MM/YYYY.