Book a demo

Which SQL Accounting document does each sales paper go into?

Your delivery order goes into Delivery Order, an invoice for goods into Invoice (eStream calls it Sales Invoice), a cash bill into Cash Sales, a debit note into Sales Debit Note and a credit note for goods returned into Credit Note (Sales Credit Note). eStream points billing with no stock items to Customer Invoice. The table below covers every paper.

Last checked against eStream’s SQL Accounting documentation (the Sales and Customer usage guides) and wiki.

Which sales papers this is about

Most sales documents are made in SQL Accounting and printed from it. This guide is for the ones that start on paper: a handwritten invoice book, a delivery order book kept at a branch or in the lorry, a cash bill written at the counter. Each one still has to go into SQL Accounting, and into the right document.

SQL Accounting keeps sales documents in two menus. The Sales menu holds the documents that carry item lines, with quantity and unit price. The Customer menu holds the customer’s account: bills with no items, payments, and the notes that adjust them.

Every sales paper, and where it goes

The paper you holdKey it intoNotes
Your delivery order, signed by the customerDelivery Order (Sales menu)The invoice can be transferred from it later
Your invoice for goodsInvoice (Sales menu; eStream’s name is Sales Invoice)Item lines, quantity and unit price
Your bill for a service, with no itemsCustomer Invoice (Customer menu)GL account codes only, no quantity or unit price
A cash bill, paid at the counterCash Sales (Sales menu)SQL Accounting asks for the payment and the change when you save it
Your debit note, raising what a customer owesSales Debit NoteFor an amount the invoice undercharged
Your credit note for goods the customer returnedCredit Note (Sales menu; eStream’s name is Sales Credit Note)Transfer it from the invoice or cash sale it reverses
Your credit note for a discount, with nothing returnedCustomer Credit Note (Customer menu)Credited to a GL account

Customer Invoice or Sales Invoice?

Both record what a customer owes you. The difference is what the bill is for.

  • Sales Invoice is the Invoice in the Sales menu. eStream’s customer guide says it tracks quantity and unit price, and recommends it for stock-related billing.
  • Customer Invoice is in the Customer menu. eStream’s guide says it shows only GL account codes and does not track quantity or unit price.

So an invoice for goods you sell goes into the Sales menu’s Invoice. A bill for a service, a rental or a charge with no items can go into Customer Invoice.

Delivery order first, then the invoice

When goods leave with a delivery order and the invoice follows, key the delivery order into Delivery Order when it is signed. When you bill, open Invoice, choose the customer, right-click the Invoice title and choose Transfer from Delivery Order, so the lines are not keyed twice. That is the order eStream’s Sales guide uses.

Cash bills

A cash bill for goods paid on the spot goes into Cash Sales. When you save it, SQL Accounting asks for the payment and the change.

Debit notes and credit notes

A debit note raises what a customer owes, for example an amount your invoice undercharged. It goes into Sales Debit Note.

A credit note lowers what a customer owes. When the customer returned goods, it goes into the Sales menu’s Credit Note: right-click its title and choose Transfer from Sales Invoice/Cash Sales, then enter the returned quantities. When nothing came back, for example a discount after the sale, eStream’s customer guide uses a Customer Credit Note credited to a GL account instead. For a return, the same guide says to “use a Sales Credit Note first, then knock it off in Customer Credit Note”.

Keep your own printed number with every paper you key. It is how you spot the same delivery order or invoice book page going in twice, the same way the duplicate supplier invoices guide does it for purchases.

The purchase side

The same question for papers from suppliers is answered in which SQL Accounting document each supplier paper goes into.

Sources

  1. eStream, SQL Accounting documentation: Sales guide, opened
  2. eStream, SQL Accounting documentation: Customer guide, opened
  3. eStream wiki: SQL Accounting Linking (document names), opened

See it on a real invoice

Book thirty minutes and watch IgnisArc Finance read, check and post a supplier invoice into SQL Accounting.

Book a demo