Guide

How to keep a daily sales record for your small business

A useful daily record tells you what sold, how customers paid, what the business spent, who is still owing and what needs attention next.

Practical guidance for Nigerian small businesses using paper, spreadsheets or Berlvis Books.

Berlvis Books editorial teamPublished 11 Jul 2026Updated 4 Sep 20269 min read

The foundation

A daily sales record is the story of one business day in numbers.

It should show what was sold, the amount charged, any discount, what was actually paid, how the money arrived, what remains unpaid and what the business spent.

A sales total alone is not enough. Two businesses can both record ₦60,000 in sales while having very different cash positions because one received everything immediately and the other still has customer balances.

The fields

Record enough context to understand the entry later.

  • Date and time of the transaction
  • Product, service or job sold
  • Quantity, price and any discount
  • Customer when a balance or later payment matters
  • Cash, transfer or split payment
  • Amount paid and balance remaining
  • Recorded business expenses
  • Receipt or note when extra context is useful

Example

One sale should be readable without asking the owner what happened.

CustomerSaleAmountDiscountPaidMethodBalance
ChikaHair treatment₦12,000₦1,000₦11,000Transfer₦0

The useful record is not only “₦11,000 received.” It also explains the original price, discount, what was sold and how the customer paid.

Payment methods

Keep cash, transfer and customer balances separate.

Cash should match money physically collected. Transfer should match bank or wallet credits. A customer balance is not money received yet; it belongs to the customer and original sale until it is paid.

SituationSalePaidMethodBalance
Cash sale₦8,000₦8,000Cash₦0
Transfer sale₦15,000₦15,000Transfer₦0
Part payment₦20,000₦12,000Transfer₦8,000

When the final ₦8,000 arrives later, update the original balance or allocate the later payment to that outstanding sale. Do not count the later collection as a new sale.

Expenses and closing

Sales alone do not explain the full day.

If the business records ₦60,000 in sales and ₦18,000 in stock, transport, packaging or repairs, both sides belong in the daily record.

  • Review total recorded sales
  • Compare cash received with cash in hand
  • Compare transfers with bank or wallet credits
  • Review recorded expenses
  • Check customers still owing
  • Confirm later payments received for earlier sales

Choose a method

Paper, spreadsheets and apps solve different parts of the problem.

Paper is familiar and independent of software, but it is harder to search, total and update when customers pay later. A spreadsheet can calculate and customize, but it may be awkward at a busy counter. A dedicated app can keep transactions and balances connected, but it still depends on the business recording events consistently.

Berlvis Books is designed for the third case: fast daily entry, customer-linked balances, later-payment allocation, reports, receipts and local-first support when connectivity becomes unreliable.

Daily checklist

A complete record is more useful than a sales total.

  • Record each sale close to when it happens
  • Separate cash from transfer
  • Record discounts instead of hiding them in a lower total
  • Attach unpaid balances to the right customer
  • Record business expenses while they are fresh
  • Update later payments against the original balance
  • Review the day before closing

Questions before you start

Daily sales record questions

Start with today

Give today's sales a record you can still explain tomorrow.

Record one sale, one expense and one customer balance while the details are still clear.

Free to start. No accounting knowledge required.