Connection lost — reconnecting…

We couldn't reconnect to the server.

The server rejected the reconnection.

Easy help Sign in

Sales, spend and the cash registers

What Sales by customer, Sales by item, Spend by supplier, Bills by account, Purchases by item and the receipts and payments registers count, and how to print them.

These reports live under Reports → Sales and Reports → Purchases.

What counts

The analyses (Sales by customer, Sales by item, Spend by supplier, Bills by account and Purchases by item) are on the accrual basis by document date. A finalised invoice, recorded bill or credit note counts in the period it is dated, whether it has been paid or not.

An undone document stays in the period it was dated in, and its undo counts as a negative in the period it was undone. Your accounts work the same way: the undo is dated on the day you did it. So a June bill undone in August is in June's spend, August shows it taken off, and a period you have closed never changes when something is corrected later. A report over June to August shows nothing for it, because the two cancel out. In the list of documents behind a figure, the undo is marked "undone" and dated on the day it was undone.

Left out:

  • drafts, and invoices or bills waiting for approval,
  • opening balances (they carry what was owed before you started with Easy, they are not sales or spend of the period),
  • on-account credit notes (money a customer overpaid, or a deposit you paid a supplier; they reduce nothing).

Every amount is in your base currency, named once at the top of the report. A foreign-currency document counts at the base value fixed when it was raised, so the figures add up across currencies and agree with your income and expense accounts. The list of documents behind a figure shows each foreign document's own-currency total beside it.

Net is the amount before VAT, less credit notes. Gross is net plus VAT. Share is the row's part of the total net. Negative amounts are in brackets and a dash means nothing. A company not registered for VAT sees no VAT column, on the screen or in the Excel and PDF files.

The period, the comparison, the order, the search and the page you are on are kept in the page address. Open a figure, then go back (or use the trail at the top), and the report is as you left it. You can also bookmark or share the address.

Sales by customer

One row per customer with invoices or credit notes in the period: how many invoices, what they came to, the credit notes taken off, and the net, VAT and gross that leaves.

Select a customer's name to open their statement for the same period. Select a figure to see the documents behind it (see The documents behind a figure).

Compare with adds two columns:

  • Previous period: for a period of whole months, the same number of months just before (September against August, a quarter against the quarter before). For any other period, the same number of days just before.
  • Same dates last year.

A customer who bought only in the comparison period is not listed; the comparison total still includes them.

Sales by item

One row per item: the units sold less units credited, and the net, VAT and gross of those lines. An invoice with the same item on two lines counts once in that item's invoice count. An invoice with several items is on several rows, so the Total row leaves the invoice count blank; it is the same on Purchases by item and Bills by account.

Lines typed as free text, without an item picked, are gathered in one row, Lines with no item.

Select an item's name to open the item. Select a figure to see the invoices and credit notes the item was on, with that item's quantity and amounts on each. Under a search, Lines with no item holds only the free-text lines whose description matches, and so do the documents behind it.

Spend by supplier

The same as Sales by customer, for recorded bills and supplier credit notes.

Select a supplier's name to open their statement for the same period.

Tick Split by account to see, under each supplier, the accounts their bills were coded to (net of their credit notes). Select an account's amount to see the lines coded to it. The Excel export carries the split on a second sheet.

Bills by account

Reports → Purchases → Bills by account answers "what did our bills go on": every supplier's bill lines added up by the account they were coded to, before VAT and less supplier credit notes. It is Split by account for all suppliers at once: what bills and supplier credit notes put on each account. Payments from the cash book, journals and expense claims paid on a payslip can land on the same accounts too, so the account itself can hold more: the profit and loss is the whole spend. Select a figure to see the bills and credit notes with lines on that account, with only those lines' amounts on each.

Purchases by item

Reports → Purchases → Purchases by item is the twin of Sales by item, for recorded bills and supplier credit notes: per item, the units bought less units sent back, and their cost before VAT. Services and items whose stock you don't track count too. Lines typed as free text are gathered in Lines with no item. Select a figure to see the bills and credit notes the item was on, with that item's quantity and amounts on each.

Discounts given

Reports → Sales → Discounts given adds up the line discounts on finalised invoices and credit notes dated in the period, by customer, by item or by month (choose under Edit report). Only lines with a discount count: Before discount is what those lines came to before it, Discount is what came off, After discount is what they were charged at, and Discount % is the discount as a share of the value before it. A credit note's discounted lines count against the figures, as credit notes do on Sales by customer. Every figure opens the lines behind it, each linked to its invoice or credit note. Amounts are in your books currency, at the rate fixed on each document. Export (Excel or PDF) hold every row and the total for the period and grouping on the screen. How to give a discount is in Give a discount.

The documents behind a figure

Every figure on Sales by customer, Sales by item, Spend by supplier, Bills by account and Purchases by item that is not worked out from others opens the documents behind it, newest first:

  • Invoices (or Bills) and Invoiced (or Billed): the invoices or bills only,
  • Credit notes: the credit notes only,
  • Quantity, Net, VAT and Gross: all of them,
  • Previous: all of them in the comparison period,
  • an account under Split by account: that supplier's lines coded to the account.

The Total row at the bottom of that list is the figure you selected. Credit notes count as negatives. The buttons above the list switch between all documents, the invoices or bills, and the credit notes. Each document number opens the document.

Share and Change are worked out from other figures, so they do not open anything.

Receipts and payments registers

The Receipts register (Reports → Sales) lists every receipt dated in the period; the Payments register (Reports → Purchases) every payment. Each shows the date, number, who paid or was paid, the reference, the bank or cash account and the amount.

  • Amount is what moved through the bank or cash account, in the base currency: the figure recorded in your accounts.
  • Settled documents is the part applied to invoices, bills or credit notes. Select it to see which ones: each links to its document, and their total is the figure you selected.
  • Other is the rest: money coded straight to an account, the VAT on it, or money kept on account as a credit.

Select the number or the amount to open the receipt or payment. When it names one customer or supplier, their name opens their statement for the same period. The period, the bank or cash account, the search, the page and the row you opened are kept in the page address, so going back returns you to the register as you left it.

An undone receipt or payment stays on its own date, and its undo is a row of its own on the day it was undone, every figure negative and marked "undone". So each period's total agrees with the bank or cash account for that period, and a period you have closed never changes.

A receipt or payment through a foreign-currency bank account also shows the amount in that account's currency. A settlement of a foreign-currency invoice or bill shows how much of the document it settled, in the document's currency. The gain or loss on that settlement is on Reports → Realised FX.

A customer refund is a payment, so it is in the Payments register under the customer's name. A supplier's refund is in the Receipts register.

Sales and purchases registers

The Sales register and the Purchases register list every invoice, bill and credit note dated in the period, with its status in plain words. The Purchases register also shows the supplier's invoice number, and the net and VAT of each bill. An undone document stays on its own date, marked with the day it was undone, and its undo is a negative row on that day, as on the analyses above. By default they show only what is in your accounts, so the total agrees with them. Choose another Status to see drafts and bills waiting for approval, or everything; the total always adds up the rows shown. A recurring schedule's template is never listed.

Excel and PDF

Each of these reports has Export (Excel or PDF). Both are rebuilt from the filters on the screen and hold every row, not only the page you are looking at. Credit notes are negative there too, as on the screen, and the note under the heading names the currency.

The PDF prints the same tables as the Excel file. The document registers, overdue receivables, supplier bills due, the aged reports and the other list reports have a PDF too.