Which SQL Accounting document does each supplier paper go into?
A supplier’s invoice for goods goes into Purchase Invoice, a cash bill into Cash Purchase, a delivery order into Goods Received, a debit note into Purchase Debit Note and a credit note into Purchase Returned. eStream points bills for services, insurance and stationery to Supplier Invoice. The table below covers every paper.
Last checked against eStream’s SQL Accounting documentation (the Purchase and Supplier usage guides) and wiki.
Every supplier paper, and where it goes
SQL Accounting keeps supplier documents in two menus. The Purchase menu holds the documents that carry item lines (item code, quantity, unit cost). The Supplier menu holds the supplier’s account: invoices for things you do not stock, payments, and the notes that adjust them.
| The paper you hold | Key it into | What it does |
|---|---|---|
| Your purchase order to the supplier | Purchase Order (Purchase menu) | Records the order you placed |
| The supplier’s delivery order | Goods Received (Purchase menu) | Records the goods that arrived |
| The supplier’s invoice for goods | Purchase Invoice (Purchase menu) | Adds the amount to the supplier’s account |
| The supplier’s invoice for a service, insurance or stationery | Supplier Invoice (Supplier menu) | Adds the amount to the supplier’s account |
| A cash bill, paid on the spot | Cash Purchase (Purchase menu) | Nothing left to pay: it records the payment too |
| The supplier’s debit note | Purchase Debit Note (Purchase menu) | Raises what you owe |
| The supplier’s credit note for goods you sent back | Purchase Returned (Purchase menu) | Lowers what you owe; knock it off against the invoice it reverses |
| A debit note or credit note on a Supplier Invoice bill | Supplier Debit Note or Supplier Credit Note (Supplier menu) | Raises or lowers what you owe |
Supplier Invoice or Purchase Invoice?
Both record a bill you owe a supplier. The difference is what the bill is for.
- Purchase Invoice is in the Purchase menu. You enter it line by line, with item codes, quantities and unit costs, and eStream’s guide has you enter it once the purchase order is approved and the goods have arrived. If the delivery is keyed already, right-click the Purchase Invoice title and choose Transfer from Goods Received instead of keying the lines again.
- Supplier Invoice is in the Supplier menu. eStream describes it as the place for “general invoices received from suppliers, such as for services, insurance, stationery, or any non-stock control billing”.
So a bill for goods you keep in stock goes into Purchase Invoice. A bill for a service you used, where there is no stock to receive, can go into Supplier Invoice.
The order and the delivery come first
A purchase order and a goods received note are not bills. eStream describes the purchase order as the document you issue when you place an order, and the goods received note as proof that the delivery arrived. The bill is the supplier’s invoice, and it goes into Purchase Invoice: in eStream’s own example, a Purchase Invoice debits the purchase account and credits the supplier’s account.
That is why the supplier’s delivery order goes into Goods Received, not into an invoice. When the invoice comes, the Purchase Invoice can be transferred from that Goods Received note.
Cash bills
A cash bill or receipt for something paid on the spot goes into Cash Purchase. eStream’s guide says it is for purchases “paid for immediately with cash, with no outstanding balance”, and that saving it makes the Supplier Payment for you. Nothing is left on the supplier’s account to pay later.
Debit notes and credit notes
A debit note from a supplier raises what you owe, for example an amount the invoice undercharged. For goods, it goes into Purchase Debit Note, which eStream says is used to increase an expense or the amount owed to a supplier. On a Supplier Invoice bill, it goes into Supplier Debit Note.
A credit note lowers what you owe. When it is for goods you sent back, it goes into Purchase Returned (the window it opens is titled Purchase Return), which can be transferred from the Purchase Invoice it reverses. On a Supplier Invoice bill, it goes into Supplier Credit Note. The guide on supplier credit notes and debit notes covers both, and how to tie each note to its invoice.
Whichever document a paper goes into, keep the supplier’s own document number with it. It is how you spot the same paper arriving twice: see duplicate supplier invoices.
Papers you do not key in
A supplier statement lists the invoices and notes the supplier has sent you, and what is still unpaid. It is not a bill. Check it against the supplier’s account, and if an invoice on it is missing from your books, ask for that invoice and key it from the invoice itself.
Before any paper goes in, check the supplier invoice: the supplier, the number, the sums and the dates. Papers you issue to customers are in which SQL Accounting document each sales paper goes into.