sales day book report xero

Customise and use report templates

For powerful and efficient reporting, build a set of professional client reports with flexible report templates.

Tailor report templates to suit

Enjoy a simple, intuitive user experience that makes it easy for your practice to create reports fast.

• Included Drag and drop report codes to change formatting
• Included Edit titles and add groups
• Included Add formulas to change your row calculations

Customise column layouts

Take control of how client data is presented.

• Included Insert columns for any date range
• Included Compare against budget or compare any column using formulas
• Included Change the order of your report columns to suit your needs

Use switch rules and groupings

Use dynamic and calculated fields for complex calculations and for presentation rules.

• Included Group accounts with related information together on a report
• Included Use switch rules to move accounts between groups
• Included Show an item as an asset or liability depending on its value

Templates are free in Xero HQ

The report templates in Xero HQ are a partner programme benefit for all accounting and bookkeeping partners.

• Included Xero HQ and report templates are free to Xero partners
• Included If you’re already a Xero partner, just log in to get started
• Included If you’re not a partner, it’s free to join and get Xero HQ

More about using report templates

Use report templates to create sets of reports for all your Xero clients and make client-specific changes as needed. Reports use accurate, up-to-date information out of client accounts, and you can drill-down from any report to the data it uses.

You can edit default reporting dates, titles, report order and layout in your practice’s report templates. Any changes you make will apply when you use the report template for a client’s reports.

Once you’ve used a report template to create a set of draft reports for a client, you can publish a report so your client can view it in Xero. You can export and print it too if you wish.

Join over 200,000 accountants and bookkeepers using Xero in their practice and get Xero, and Xero HQ including report templates, for free.

Xero HQ lets you manage client, staff and queries efficiently, as well as use report templates to build and customise powerful reports. It can help you understand your clients, work faster, and give informed advice.

Start using Xero for free

Access Xero features for 30 days, then decide which plan best suits your business.

• Try Xero for free
• See all features

What to explore next

Sales Day Book

A sales day book is a manual record of all the credit sales by a business to customers. It is a book of prime entry it is a record of transactions before entering the accounting system. It is also known as the sales book.

It lists all the details from the credit invoice in one place, making it easier if a business uses a manual system for issuing credit invoices.

In this article, we look at the following:

• What is a credit Sale
• What to include in a sales day book
• Free Excel Template

If you use a computerised accounting system, the sales day book is unnecessary as it is included in the software.

Table of Contents

Why Should I Use Accounting Software?

If you are using a manual system, you might consider using accounting software like QuickBooks or Xero . If you issue credit invoices for customers using software has the following advantages:

• Customer details are stored in the software, making it easy to issue credit sale invoices.
• The software keeps track of outstanding invoices, and reports are available.
• Most will automatically send out customer statements and reminders.
• Saves the manual sales journal entry to the general ledger
• Automatically completes double entry bookkeeping

What is a Credit Sale?

A credit sale is a sale made to a customer on credit. The customer will have agreed on payment terms for the sale.

If you are a business offering credit, it is worth stating on the invoice due date and including terms of sales with the invoice.

Credit Notes

The chances are if you issue sales invoices on credit to customers at some point, you will have returns to deal with or a change to the invoice amount.

When you receive a return, you will issue a credit note to the customer. The credit note is included in a separate book called the sales return daybook.

So far, we have looked at credit sales, but what happens with cash sales?

Cash receipts are recorded in a separate ledger, not confused with credit sales. The cash is recorded either by transaction or by day and then transferred using a sales journal to the general ledger.

What to Include in a Sales Day Book

A sales day book is a list of all the credit sales and will include the following information:

• Invoice Date
• Invoice Number
• Customer Name
• Sales Amount
• Total amount

If you require more information in the daybook, it is possible to add further columns.

At the end of a period (day, week or month), you total the sales day book and transfer the amount to the sales ledger in the accounting system using a sales journal.

The sales ledger is part of double entry bookkeeping.

Example Sales Day Book

The above example sales day book shows 4 credit sale invoices totalling £1250. The total is transferred to the general ledger using a journal. The sales ledger will only show the total, so the daybook is the detailed list of the credit invoices.

Sales Invoices

A sales Invoice is issued to a customer when you make a sale of goods or services. It is worth including as much information as possible and checking the details against the quote or estimate agreed.

The information required is:

• Your business name, address and contact details
• The customer name and address
• Unique invoice number
• Invoice date
• Payment terms and due by date
• Description of the goods or services, quantity and invoice amounts
• Vat amount and number
• Details on how to pay

If you require a sales invoice template , we have two available VAT and one non-VAT.

Sales Day Book Excel Template

If you require a sales daybook for your business, we have created one, and it is available at the end of this article for free.

Our template allows you to record all the credit sales, including customer name, invoice number, invoice date and amounts. It will automatically total the columns, ready for you to transfer.

One advantage of using Excel is the search feature. If you are looking for a particular customer or amount of an invoice, you can search within the spreadsheet.

Sales Day Book PDF

We have also created a PDF version of the sales day book. This is the ideal solution if you prefer to write the credit sale entries manually.

Licence Agreement

By downloading our templates, you agree to our licence agreement .

sales day book pdf

Sales day book summary.

A sales day book lists all the credit sales that a business issues.

If you use an accounting package, you will not require a sales day book, as the software takes care of everything within the sales ledger for you.

[INSERT_ELEMENTOR id=”8389″]

Angela Boxwell – Senior Writer

Angela Boxwell, MAAT, is an accounting and finance expert with over 30 years of experience. She founded Business Accounting Basics, where she provides free advice and resources to small businesses.

Angela is certified in Xero, QuickBooks, and FreeAgent accounting software. To simplify bookkeeping, she created lots of easy-to-use Excel bookkeeping templates.

Edited August 24, 2023 at 8:08am

Sales Day book

• Strikethrough
• Bulleted list
• Numbered list
• Remove formatting

Write an answer...

A great answer addresses the original question, and might include examples or links to more info. Please follow our  community guidelines  opens in a new tab    and be mindful not to share personal information like phone numbers or email addresses as this is a public forum.

All answers (1)

August 24, 2023 at 8:08am

Hey Pauline

I see you’ve raised a support case for this, and a specialist has been in touch. 😀

To recap, you might use the the Receivable Invoice Detail report for this, as it lets you see the line details of your customer's invoices and credit notes. Like most reports, you can Filter this results, and also decide which columns you would like to include. 👍

There's more info in this here: Receivable Invoice Detail report and here: Select settings in a report .

Please reply from your case if you need any more help with this.

Still have questions?

Contact xero support.

Raise a case with our support team

Start a discussion

Ask our community of customers, accountants and bookkeepers

Product Ideas - open link in new window

Share your ideas and feedback to help us improve our products

Cookie settings

Manage consent preferences, functional cookies.

These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

Performance Cookies

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.

Strictly Necessary Cookies

These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookie List