# Cash book and customer accounts sheet (free Excel)

> Free Excel cash book with a running balance plus customer accounts: sales as quantity times price, customer payments and the amount still due per customer.

Source: https://softwiro.com/templates/cash-customers-account
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Cash book and customer accounts sheet

A free Excel sheet that combines a cash book with customer accounts. You record cash received and paid out and the sheet works out the balance after each entry. You record what you sold to each customer by quantity and price, and the cost appears as quantity × price. Each customer's payments are taken from the cash book to give the amount due = cost − payments.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-cash-customers-account.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-cash-customers-account-blank.xlsx)

Excel file (.xlsx) · 202 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| الإجمالي | 7 | 6,825.00 | 4,725.00 | 2,100.00 |  |
| --- | --- | --- | --- | --- | --- |
| العميل | عدد البنود | إجمالي التكلفة | إجمالي الدفعات | المستحق عليه | الحالة |
| مكتبة النور | 2 | 1,850.00 | 1,500.00 | 350.00 | عليه مستحق |
| بقالة الأمل | 2 | 1,600.00 | 600.00 | 1,000.00 | عليه مستحق |
| محل السلام | 2 | 2,250.00 | 1,500.00 | 750.00 | عليه مستحق |
| شركة الفجر | 1 | 1,125.00 | 1,125.00 | 0.00 | خالص |

Example from the “العملاء” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- “الإعدادات” (Settings): The year and the opening cash balance.
- “التصنيفات” (Categories): The income and expense categories you use.
- “العملاء” (Customers): Each customer's name and phone number, with the number of items, total cost, total payments, amount due and status. It holds up to 300 customers.
- “المبيعات” (Sales): One row per item: date, customer, description, quantity and price, with the cost worked out as quantity × price. It holds up to 2,000 items.
- “الخزنة” (Cash book): Every cash receipt and payment with its date, description and category, and the cash balance after it. For a receipt that is a customer payment, you pick the customer's name and it is deducted from what they owe.
- “ملخص شهري” (Monthly summary): For each category, what came in or went out in every month, plus total income, total expenses and the net.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

A payment is entered once in the cash book. It raises the cash balance and reduces the customer's amount due at the same time, instead of being typed into two sheets where the numbers drift apart.

## How to use it

1. In the “الإعدادات” (Settings) tab, enter the year and the opening cash balance. In “التصنيفات” (Categories), enter your income and expense categories.
2. In the “العملاء” (Customers) tab, enter each customer's name and phone number.
3. In the “المبيعات” (Sales) tab, record each item sold: date, customer, description, quantity and price. The cost appears as quantity × price.
4. In the “الخزنة” (Cash book) tab, record every receipt and payment. If a receipt is a payment from a customer, pick their name in the customer column.
5. The “العملاء” (Customers) tab works out, for each customer, the total cost, total payments and the amount due = cost − payments.
6. Open “ملخص شهري” (Monthly summary) to see income, expenses and the net for each month.

**Before you start:**

- A payment is entered once in the “الخزنة” (Cash book). It raises the cash balance and lowers the customer's amount due together.
- The “العملاء” (Customers) tab counts payments only from the receipts column. Money paid out does not enter a customer's account.
- Write the customer's name in the same form in “العملاء”, “المبيعات” and “الخزنة”. The drop-down list prevents spelling differences.
- Record cash book entries in date order so the running balance is correct.
- The sheet holds 300 customers, 2,000 sales items and 2,000 cash book entries.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-cash-customers-account.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-cash-customers-account-blank.xlsx)

Excel file (.xlsx) · 202 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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

## Still running this on Excel?

This sheet needs someone to copy every invoice and payment into it. In Accountwiro an invoice and a payment are recorded the moment they happen, and the customer's balance shows in a single statement of account.

| In this sheet | In Accountwiro |
| --- | --- |
| You copy every invoice and payment into the sheet by hand. | It shows the customer's invoices, payments and outstanding balance in a single statement of account. |
| Invoices are typed or copied by hand. | It creates an invoice by scanning a barcode or searching by product name, calculates discounts and taxes, and sends it to the customer over WhatsApp. |
| Stock shortages are discovered late. | It updates quantities after every sale and alerts you when a product drops below the required level. |
| Anyone who opens the sheet sees every number. | Permissions per user: the sales employee issues invoices, and the warehouse employee manages stock without access to financial data. |

[See Accountwiro](https://softwiro.com/systems/budoor.html) · [Ask for a demo](https://softwiro.com/contact)

## 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)

## Frequently asked questions

### How do I calculate what a customer owes in Excel?

Enter each item with its quantity and price and the cost appears as quantity × price. Pick the customer's name on every payment that goes into the cash book. The sheet then works out the amount due = total cost − total payments.

### Do I enter a customer's payment in the cash book and in the customers sheet?

No. You enter it once in the “الخزنة” (Cash book) tab and pick the customer's name. It adds to the cash balance and is deducted from what the customer owes.

### What does the status “دائن” (creditor) mean?

It means the customer has paid more than the cost of what they bought, so their balance is negative. The status “خالص” (settled) means they have paid exactly what they owed.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Shops and stores

## More free templates

- Cash Book Template for Excel
- Invoice Template with Invoice Log (Excel)
- Clothing shop inventory sheet by colour and size
- Customer accounts, credit sales and customer statement sheet
- Installments and collection tracker
- General shop inventory tracker (stock in/out, reorder, slow movers)
- Supplier purchase orders and payables tracker
- Multi-warehouse and branch inventory sheet with transfers
- Periodic stock count and count-difference reconciliation sheet
- Barcode, batch and expiry inventory sheet
- Grocery store management sheet
- Stationery shop and photocopy management sheet
- Electronics shop sheet: serials, warranty and repairs
- Wholesale clothing trade sheet: traders, stock and collection
- Food wholesale and distribution sheet in Excel: routes, expiry and collection
- Delivery company sheet: shipments and cash collection
- Student attendance sheet
- Study planner and lesson tracker
- Journal entries, trial balance and financial statements sheet
- Weekly study routine sheet
- Online store orders and profit sheet
- Real estate leads and units tracker
- Rental portfolio tracker: properties, units, tenants and contracts

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
