# Cash book and customer accounts Excel (free) + online

> Free Excel sheet for a cash book and customer accounts: cash in and out with balance, cost = quantity × price, amount due = cost − payments, and a monthly…

Source: https://softwiro.com/blog/cash-customers-account-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Cash book and customer accounts in Excel (free): quantity × price minus payments = amount due

Record cash in and out and what you sold each customer, and see what each one still owes and the month summary.

10 November 2026 4 min read

## In short

- Cost = quantity × price, and amount due = total cost − total payments.
- A payment is typed once, in the cash sheet with the customer name, so it raises the cash balance and lowers what the customer owes.
- Each customer shows a status: owes, settled or in credit.
- A monthly summary of income, expenses and net per category.

You sell to customers on credit and move cash in and out of the till every day, and you want to know at any moment what the till holds and what each customer owes. The free [cash book and customer accounts sheet](https://softwiro.com/templates/cash-customers-account) does that: you enter items and payments once, and both the cash and the customer figures come out.

## The problem

Many people keep a cash book and a customer book. A payment goes into both, one gets forgotten, the figures drift, and "what does Ahmed owe?" takes an hour of adding up.

## How it works

- In Settings enter the year and the opening cash balance, and in Categories your income and expense names.
- In Customers enter each customer and phone.
- In Sales enter each item with date, customer, description, quantity and price. Cost = quantity × price appears.
- In Cash enter every receipt and payment. If a receipt is a customer payment, pick the customer.
- Customers then shows each customer's items, total cost, total payments, amount due and status.
- Monthly summary gives income, expenses and net per month.

## How the numbers are worked out

- Cost = quantity × price per item; a customer's cost is the sum of their items.
- Payments = the sum of the cash "in" column on rows where you picked that customer.
- Amount due = total cost − total payments: positive means "owes", zero "settled", negative "in credit".
- Cash balance = opening balance + total in − total out up to that row.

Open the sheet at /ar/templates/cash-customers-account. It holds 300 customers, 2,000 items and 2,000 cash rows.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: cash box and customer accounts (1/3)](https://softwiro.com/uploads/cheatsheets/cash-customers-account/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/cash-customers-account/en-1.jpg)[![Cheat sheet: cash box and customer accounts (2/3)](https://softwiro.com/uploads/cheatsheets/cash-customers-account/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/cash-customers-account/en-2.jpg)[![Cheat sheet: cash box and customer accounts (3/3)](https://softwiro.com/uploads/cheatsheets/cash-customers-account/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/cash-customers-account/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I work out what a customer owes in Excel?

Enter each item with quantity and price to get cost = quantity × price, and pick the customer on each payment in the cash sheet. The sheet gives amount due = total cost − total payments.

### Do I enter a payment twice?

No. Enter it once in the cash sheet with the customer name; it enters the balance and reduces what the customer owes.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
