Sales Register Format: Record Every Invoice

A sales register is the running list of every invoice and credit note you issue, in date order, with the net amount, tax and total on each line. If your accountant asks "what were your sales in October?" or your tax return needs the output tax figure, the sales register answers it in one sum. This guide gives you a practical sales register format, a filled example with totals you can check, and the variations you need for VAT and GST.

It is written for small businesses that invoice from a template or a simple tool and want a record that holds up when the books are reviewed. Nothing here is tied to one accounting package; the same layout works on paper, in Excel or in Google Sheets.

What is a sales register?

The sales register (also called the sales book, sales journal or sales day book) is a book of original entry. Each invoice is recorded once, in the order it was issued, before the totals are posted to the general ledger. It does three jobs:

• Totals. It gives total net sales and output tax for any month or quarter.
• Completeness. Because invoice numbers run in sequence, gaps and duplicates stand out. A good invoice numbering system makes this check easy.
• Follow-up. With a status column, it shows which invoices are still unpaid. The detail per customer lives in the customer ledger.

Tax authorities expect you to be able to produce this kind of record. For example, HMRC's guidance on what records the self-employed must keep includes all sales and income, and the IRS page on what kind of records to keep says your books must show gross receipts, supported by documents such as invoices. This article is general information, not tax or legal advice.

Sales register format: the columns

Column	Example	Purpose
Date	03-11-2026	Invoice or tax point date
Document type	Invoice / Credit note	Separates sales from returns
Document number	INV-1042	Sequential, checked for gaps
Customer name	Kessler Interiors	Links to the customer ledger
Customer tax ID	VAT/GST number if registered	Needed for B2B tax reporting in many countries
Net amount	1,250.00	Sales before tax
Tax rate	20%	Supports rate-wise totals
Tax amount	250.00	Output tax
Gross total	1,500.00	Amount the customer owes
Payment mode	Cash / Credit / Card	Separates cash sales from receivables
Due date	03-12-2026	From your payment terms
Status	Unpaid / Part-paid / Paid	Quick view of outstanding invoices

Optional columns: sales category (products vs services), salesperson, region, or currency and exchange rate if you invoice in more than one currency.

Sales register example with totals

Here is a November sample for a small supplier charging UK-style VAT at 20%. It includes four invoices and one credit note.

Date	No.	Customer	Net	VAT 20%	Gross	Mode	Status
01-11	INV-1041	Brightwell Cafe	450.00	90.00	540.00	Credit	Paid 20-11
03-11	INV-1042	Kessler Interiors	1,250.00	250.00	1,500.00	Credit	Unpaid
05-11	INV-1043	Cash customer	85.00	17.00	102.00	Cash	Paid
08-11	INV-1044	Brightwell Cafe	320.00	64.00	384.00	Credit	Unpaid
10-11	CN-0012	Kessler Interiors (against INV-1042)	-150.00	-30.00	-180.00	Credit	Applied
Totals			1,955.00	391.00	2,346.00

Check the totals before relying on them:

• Net: 450 + 1,250 + 85 + 320 - 150 = 1,955.00
• VAT: 1,955.00 x 20% = 391.00, which matches the column sum (90 + 250 + 17 + 64 - 30)
• Gross: 1,955.00 + 391.00 = 2,346.00

The credit note is entered as a negative line on the date it was issued, so net sales for November are 1,955.00, not 2,105.00. If you want to understand when to use one, our guide to issuing a credit note covers it. Notice the cash sale too: it is in the sales register because an invoice was issued, and the money also appears in the cash book.

How to keep a sales register step by step

1. Record each invoice the day you issue it. Copy the number, date, customer, net, tax and total exactly as they appear on the invoice.
2. Record cancelled numbers. If an invoice is voided, keep the row with zero amounts and the word "Cancelled". Deleting it leaves a gap that looks suspicious.
3. Enter credit notes as negatives, with a reference to the original invoice.
4. Update the status when payments arrive, and post each payment to the customer ledger.
5. Total monthly. Net, tax and gross totals feed your general ledger and your tax return.
6. Reconcile. Compare the output tax total with the tax return, and the closing unpaid total with the sum of customer ledger balances.

Sales register format in Excel

A sales register format in Excel needs only a few formulas:

• Tax: =ROUND(F2*G2,2), where F is net and G is the tax rate.
• Gross: =F2+H2.
• Monthly totals with SUMIFS by month, or a pivot table by month and tax rate.
• Gap check: sort by number and add a column =C3-C2 on the numeric part of the invoice number; any result other than 1 is a gap or duplicate.

Use data validation for the Status and Mode columns so entries stay consistent, and freeze the header row. Save a PDF copy of each month's register once your return is filed.

Reconciling the sales register at month end

A sales register that nobody checks drifts. Spend fifteen minutes at month end on three reconciliations, using the November example above:

1. Sequence check. Invoices INV-1041 to INV-1044 run without gaps, and credit notes have their own series (CN-0012). If INV-1045 had been issued on 30 November but missed, the gap would show up when December starts at INV-1046.
2. Receivables check. Unpaid gross amounts are INV-1042 (1,500.00 less the 180.00 credit note = 1,320.00) and INV-1044 (384.00), a total of 1,704.00. That should equal the sum of customer ledger balances for these sales, plus any older open invoices.
3. Cash check. The cash sale of 102.00 should appear in the cash book on 5 November, and the 540.00 payment for INV-1041 on 20 November should appear in the bank column.

If all three agree, your sales figure for the month is reliable enough to use in a tax return or to share with a lender.

Using the sales register for business insight

The register is not only a compliance record. With a couple of extra columns it answers practical questions:

• Who are your biggest customers? A pivot by customer shows that Kessler Interiors accounted for 1,100.00 of the 1,955.00 net sales in the example, about 56%. That is a concentration risk worth knowing about.
• How fast do you get paid? Adding a "date paid" column lets you calculate days to pay per customer.
• What sells? A category column (products, services, delivery charges) shows where revenue actually comes from.
• Seasonality. Twelve monthly totals side by side show quiet months you can plan around.

Variations by country

GST sales register (India)

Under GST, the register usually splits tax into CGST and SGST for sales within a state and IGST for sales to another state. Add columns for customer GSTIN, place of supply, HSN or SAC code and taxable value. Separating B2B (with GSTIN) from B2C sales matters because GSTR-1 reports them differently. Our guide to GSTR-1 and GSTR-3B filing explains how the register totals flow into the returns.

Pakistan sales tax register

Registered businesses typically record the buyer's NTN or CNIC and STRN, the value excluding sales tax, the sales tax rate and amount, and any further tax. Keep the register in the same order as your sales tax invoices so it can be reconciled with the monthly return.

UK and EU VAT

Keep columns for each VAT rate (standard, reduced, zero) and for exempt and outside-scope sales, plus EU or export sales where relevant. If you use Making Tax Digital software, the register effectively becomes your digital record.

US sales tax

Add a column for the ship-to state and local jurisdiction, and separate taxable from exempt sales (with the exemption certificate reference). That is what you need when you file state returns.

Common mistakes

• Recording sales when paid instead of when invoiced, if you use accrual accounting. The register should follow the invoice date.
• Netting credit notes against new invoices instead of recording them separately.
• Typing totals instead of using formulas, which hides arithmetic errors.
• Deleting cancelled invoices, leaving unexplained gaps.
• Mixing purchases into the same sheet. Keep a separate purchase register for supplier bills.

A sales register is only as good as the invoices behind it. If each invoice is numbered, dated and totalled correctly, the register almost fills itself. You can create invoices like the ones in this example in our free invoice generator, which calculates tax and totals for you, needs no sign-up and saves straight to PDF.