Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingBookkeepingSales Journal (Sales Day Book)

SpreadsheetBookkeepingFree

Sales Journal (Sales Day Book)

Record every credit sale once, then post the totals: receivables, sales by account and sales tax, with a balance check.

Shown with sample data

Colour

Sales Journal (Sales Day Book)

Record every credit sale once, then post the totals: receivables, sales by account and sales tax, with a balance check.

Net sales
$14,177
Sales tax collected
$940.13
Total receivable raised
$15,117
Invoices not yet posted
5
Total debits
$15,117
Total credits
$15,117
Difference
$0
Must be zero
Gross invoiced by customer
  • Juniper & Co$6,440
  • Harbor Logistics$4,521.60
  • Cedar Health$1,641.20
  • Bluepeak Retail$1,314
  • Atlas Freight$1,200
Credits by sales account
  • Product sales$11,751.6778%
  • Service revenue$2,15014%
  • Sales tax payable$940.136%
  • Shipping income$2752%

How to use it

  1. 1Enter each credit-sale invoice in number order with date, customer, description and sales account.
  2. 2Type the net amount and tax rate. Tax and gross calculate for you.
  3. 3At period end, post the Posting summary: one debit to accounts receivable and credits to sales and tax.
  4. 4Mark rows Posted once they are in the ledger and check Difference is zero.
  5. 5Agree the By customer totals with your customer (sales) ledger balances.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

The sales journal (sales day book) is where credit sales are recorded before they reach the general ledger. Enter each invoice with its customer, net amount and tax rate; the journal works out tax and gross, prepares the period’s posting (debit receivables, credit each sales account and sales tax payable), checks it balances and builds each customer’s total for the sales ledger.

Who it’s for

  • Businesses that invoice customers on credit
  • Manual or spreadsheet bookkeeping
  • Learning special journals and control accounts

What’s included

  • Sales journal sheet: One row per credit sale invoice or credit note.
  • Posting summary sheet: The period’s journal entry to post to the general ledger.
  • By customer sheet: Net sales and Gross invoiced and the number of entries for each customer.

How to use it

  1. 1Enter each credit-sale invoice in number order with date, customer, description and sales account.
  2. 2Type the net amount and tax rate. Tax and gross calculate for you.
  3. 3At period end, post the Posting summary: one debit to accounts receivable and credits to sales and tax.
  4. 4Mark rows Posted once they are in the ledger and check Difference is zero.
  5. 5Agree the By customer totals with your customer (sales) ledger balances.

Tips

  • Cash sales do not belong here: they go in the cash book (cash receipts journal).
  • Never skip or reuse an invoice number. A gap in the sequence is the first thing an auditor or tax inspector asks about.
  • Record credit notes as negative lines with their own CN number so the totals stay right.

Questions

What is a sales day book?

It is the book of prime entry for credit sales: a list of every sales invoice issued. Totals are posted to the general ledger periodically, and each line is posted to the customer’s account in the sales ledger.

What is the double entry for a credit sale?

Debit accounts receivable (trade debtors) with the gross amount; credit sales with the net amount; credit sales tax or VAT payable with the tax.

How is a sales journal different from a sales report?

The journal is an accounting record designed to be posted; a sales report analyses performance. This journal still gives you totals by customer and account.

Related searchessales journalsales day booksales journal templatecredit sales journalsales ledgerspecial journals accounting

Details

Format
Spreadsheet
Category
Bookkeeping
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBookkeepingFree

Sales Journal (Sales Day Book)

Record every credit sale once, then post the totals: receivables, sales by account and sales tax, with a balance check.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Bookkeeping
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More bookkeeping templates

View all
General Ledger2 sheets

Total debits

$19,020

Total credits

$19,020

Out of balance

$0

ABCD
1Entry no.DateAccountDescription
2J-001Nov 1BankOwner investment
3J-001Nov 1Owner equityOwner investment
4J-002Nov 2EquipmentLaptop and printer
5J-002Nov 2BankLaptop and printer
Journal
SpreadsheetBookkeeping

General Ledger

A double-entry journal with account totals, a running check that debits equal credits and balances by account type.

10 min setupPreview
Chart of Accounts2 sheets

Accounts

18

Active

18

ABCD
1NumberAccount nameTypeStatement
21,000Bank: current accountAssetBalance sheet
31,100Accounts receivableAssetBalance sheet
41,200InventoryAssetBalance sheet
51,500EquipmentAssetBalance sheet
Accounts
SpreadsheetBookkeeping

Chart of Accounts

A numbered, ready-to-edit account list for a small business with types, statement mapping and active flags.

10 min setupPreview
Cash Book3 sheets

Cash in hand

$514

Bank balance

$3,954

Receipts (excl. contra)

$3,439

ABCD
1DateDetailsCategoryCash in
2Nov 2Till takingsCash sales$1,287
3Nov 2Takings bankedContra (cash to bank)$0.00
4Nov 3Shop rent, NovemberRent$0.00
5Nov 4Cedar Café: catering orderCustomer receipts$0.00
Cash book
SpreadsheetBookkeeping

Cash Book

A two-column cash book for cash and bank with running balances, analysis by category and a cash count check.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ