Bookkeeping

Daily Bookkeeping: A Practical Routine for Sales, Expenses and Cash Flow

SokoWise TeamSokoWise Team
•••7 min read
Daily Bookkeeping: A Practical Routine for Sales, Expenses and Cash Flow

Daily bookkeeping is the habit of recording business activity accurately while the details are still easy to verify. A short, consistent routine helps identify missing payments, unexplained expenses, stock purchases, refunds, and cash shortages before they become difficult to investigate.

Bookkeeping records support management and tax preparation, but they do not replace current tax advice or statutory filings. Use the record-keeping and invoicing rules that apply to your business.

Record complete transactions

For each sale, record the date, customer or order reference where appropriate, items or service, quantity, price, discounts, taxes, payment method, and status. Keep a separate trail for deposits, partial payments, refunds, reversals, and credit notes.

For expenses, keep the supplier, date, purpose, amount, tax information, payment method, and supporting invoice or receipt. Write a business purpose that another person can understand later. Avoid labeling every payment “miscellaneous” or relying on memory at month end.

Separate business and personal transactions where possible. If a personal payment was used for a business expense, record it clearly and ask an accountant how it should be treated.

Reconcile payments to the sale

A payment report and a sales report answer different questions. Match each sale to the payment record, provider reference, settlement, and any fee or deduction. Reconcile cash, mobile money, cards, online payments, and bank deposits separately, then investigate unmatched amounts.

For M-PESA or another online provider, do not treat a payment prompt as confirmed cash. Match the final provider transaction to the correct order and amount. Record fees, settlement dates, refunds, and reversals in a way that preserves the original transaction history.

Reconcile on a consistent schedule. Daily review is useful for cash and high-volume activity; monthly reconciliation may be enough for some low-volume records, provided statements and source documents remain available.

Use a simple daily close

At the end of a working day:

  1. Confirm all completed sales and invoices have a reference.
  2. Compare payment totals with cash counted and provider records.
  3. Record refunds, discounts, voids, and partial payments separately.
  4. Note stock purchases, stock received, and verified adjustments.
  5. Attach or store supporting documents in a consistent location.
  6. List unresolved differences, assign an owner, and set a review date.
  7. Back up records according to the system and retention process you use.

Do not delete an earlier transaction to make totals match. Record a correction with its date, reason, approver, and link to the original entry.

Review a basic cash-flow forecast

Profit and cash are related but different. A business can show sales while cash is delayed in unpaid invoices or stock purchases. List expected cash coming in and payments due over the next several weeks. Use realistic expected dates rather than invoice dates alone.

Closing cash forecast = opening available cash + expected receipts − expected payments.

Build a conservative scenario for late payments, lower sales, supplier changes, repairs, or tax due dates. If a shortfall appears, decide early whether to follow up on invoices, delay a nonessential purchase, negotiate terms, or seek professional advice. Avoid using customer deposits for unrelated costs if they are needed to complete the order or may need to be returned.

Keep tax and source records organized

Use numbered invoices, credit notes, receipts, supplier documents, payment confirmations, and relevant order or delivery records. File them by date and reference so a transaction can be reconstructed later.

Common bookkeeping questions

How often should I update my books?

Record activity while the source documents are available. Reconcile cash and high-volume payment activity daily or on a schedule that catches differences quickly, then review open invoices and costs weekly. The right cadence depends on transaction volume and risk.

Is a payment message enough to record a sale as paid?

No. Match the final provider transaction or cash count to the sale and keep its reference. A prompt or customer screenshot can help investigate but should not be the only confirmation.

Does bookkeeping replace tax advice?

No. Bookkeeping organizes evidence; a qualified adviser or the tax authority can confirm filing, treatment, and retention obligations for the business.

For businesses in Kenya, the Kenya Revenue Authority’s eTIMS guidance describes electronic tax invoice onboarding and the available solutions. Check current requirements for your business activity and keep the tax invoice separate from a payment confirmation or ordinary receipt where the records serve different purposes.

Retention periods and tax treatment depend on the applicable law and the type of record. Confirm the current rules with KRA or a qualified tax adviser rather than relying on a generic bookkeeping checklist.

Example: profit is not the same as available cash

A business records KES 50,000 of sales this week, but KES 20,000 is still unpaid by customers. It also has KES 18,000 of supplier bills due and expects KES 10,000 for rent and wages before those invoices are collected. The sales figure alone does not show whether the business has enough available cash for the next week.

A short forecast lists opening cash, the dates each customer is expected to pay, supplier and payroll due dates, and any required tax or delivery payment. If a customer’s payment date slips, update the forecast and act early. This arithmetic is an example of cash timing; it is not a profit statement or tax calculation.

Keep forecasts separate from confirmed transactions. Mark assumptions such as expected collections and review them against actual dates. That history helps you estimate how much buffer is useful and which customers or costs need attention.

A weekly and monthly review

Weekly, review overdue customer balances, supplier bills, unmatched payments, stock discrepancies, and upcoming cash needs. Monthly, compare income and costs with the prior period, check that all payment accounts reconcile, and review large or unusual transactions with supporting documents.

Useful measures include gross sales, refunds, gross profit, operating costs, unpaid invoices, cash available, and stock purchases. Define each measure consistently and compare similar periods. A single total rarely explains why it changed; use linked transaction records to investigate.

Set up a small chart of categories

Use categories that help you make decisions and prepare records: sales, refunds, cost of goods, operating expenses, delivery, payment fees, payroll, taxes, and owner transactions are examples. The right structure depends on how the business operates and what its accountant needs. Avoid creating a new category for every supplier or every small purchase.

Write a short rule for ambiguous items. For example, decide whether delivery charged to a customer is recorded separately from the delivery cost paid to a courier. Apply the rule consistently and ask an accountant before making a change that affects tax or financial statements.

Review uncategorized and unusual transactions every week. A new cost may deserve a category, while one isolated purchase may not. Consistency makes month-to-month comparisons more useful.

Mistakes to avoid

  • Mixing personal and business money without a clear record.
  • Recording cash received without a receipt or transaction reference.
  • Matching a provider payout to sales without accounting for fees and timing.
  • Treating refunds as negative sales with no supporting link.
  • Adjusting inventory instead of recording the underlying purchase, sale, or return.
  • Waiting until tax season to organize source documents.
  • Forecasting cash from sales totals instead of likely collection dates.

A small routine followed consistently is more useful than a complicated spreadsheet no one maintains. For documents and tax-invoice distinctions, read receipt records and eTIMS requirements. For customer invoices and overdue balances, see digital invoice tracking.