On this page
What is customer accounts software?
It is software that keeps a file for every customer and supplier and tells you, at any moment, how much they owe you and how much you owe them. People search for it as “customer accounts software”, “customer statement software” or “accounts receivable software”. All of them describe one need: your debts should not be scattered across a paper ledger, an Excel sheet and your staff’s memory.
In Anzma the module is called Contacts, and it means your register of trading parties, not the address book on your phone. Every sales or purchase invoice raised for a party in this register is posted to the books under their name, so their balance is the result of real accounting rather than a number someone typed. It is the first module you fill in, because sales, purchasing, follow-up and loyalty all stand on it.
For the wider picture, from first enquiry to loyal customer, read about customer management software, which combines this module with follow-up, loyalty, memberships and prepaid balances.
What does a customer or supplier file contain?
The file holds everything you need to deal with the party commercially and in the books: type (customer, supplier or both), kind (company or individual), contact details, trading terms, and whatever accumulates around them. Customers are numbered automatically with a CUS- prefix and suppliers with SUP-.
- Name, legal name, up to eight labelled phone numbers, email and website.
- Several billing and shipping addresses by country, city, district, street and building.
- Tax number, commercial register, national ID, and a tax-exempt switch.
- Contact people with job titles and phones, with one marked as primary.
- Payment days, credit limit, currency, salesperson and branch.
- Tags for classification, custom fields you define, attachments and internal notes.
- For suppliers: a default expense account and bank details (IBAN and SWIFT).
How is a customer statement of account built?
It is read from the customer sub-ledger, not from a separate table. Every invoice increases what the customer owes, every payment, return or credit note reduces it, and each line shows its date, journal number, description and a link to the source document. If the customer asks where a number came from, you open the line and reach the invoice.
The statement starts with an opening balance for the period, then lists movements with a running balance after each line, then totals the debit and credit and shows the closing balance, with an aging table as of the end date beneath. A short version appears in the Statement tab of the customer file; the full report lives in financial reports, with a period you choose and Excel or PDF export.
The example below is illustrative, with made-up numbers, for a customer buying on credit over one month.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 01/03 | Opening balance | 2,000 | ||
| 04/03 | Sales invoice INV-0101 | 5,000 | 7,000 | |
| 12/03 | Payment received | 3,000 | 4,000 | |
| 19/03 | Return on INV-0101 | 500 | 3,500 | |
| 26/03 | Sales invoice INV-0107 | 1,200 | 4,700 | |
| 31/03 | Totals and closing balance | 6,200 | 3,500 | 4,700 |
How do you track customer debts and their age?
You use the receivables aging report, which splits each customer’s balance by the age of the invoice: 0 to 30 days, 31 to 60, 61 to 90 and over 90. Ages are computed oldest-first, so each payment settles the oldest open invoice, and money paid before an invoice appears in an “unapplied” column.
The report ranks customers from the largest debt down, and from any row you open the customer’s statement. Supplier aging works the same way so you know what you owe and when it falls due. That is the practical difference between a ledger that says “he owes 10,000” and software that says 6,000 of it is more than ninety days old.
| 0–30 days | 31–60 days | 61–90 days | Over 90 | Total |
|---|---|---|---|---|
| 1,200 | 2,500 | 0 | 1,000 | 4,700 |
Is a customer balance debit or credit?
A customer who buys on credit has a debit balance, because it is an amount owed to you. The word confuses people since “debit” sounds like “the customer is in debt”, which is exactly what it means here: the customer owes you, so the account sits on the debit side of your books. The balance turns credit when the customer pays in advance, or returns goods worth more than they owe.
A supplier is the mirror image: normally a credit balance, because you owe them. The system reverses the sign by party type, so a supplier statement reads “what you owe” and a customer statement reads “what they owe you”. In the party file, a positive opening balance means they owe you and a negative one means you owe them.
An illustration: a customer opens at 2,000 debit, buys 5,000, then pays 8,000. Their balance is now 1,000 credit, money you hold for them, which you can set against the next invoice or refund. Overpayments show in the unapplied column of the aging report so they do not get lost.
How do you make collection a regular habit?
Knowing the debt is not enough; it has to turn into a weekly action. Here is a simple routine that uses only what the module actually shows.
- 1
Open the aging report each week
Sort by largest debt and look at the over-90 column first, then 61–90.
- 2
Open each late customer’s statement
Review open invoices and recent payments before calling, so you never chase something already paid.
- 3
Export and send the statement
Save it as PDF and send it so the customer can reconcile it with their books, surfacing disputes early.
- 4
Log the follow-up
Note the call and the promise to pay on the customer file or as a CRM follow-up, so colleagues see what was agreed.
- 5
Record the payment on arrival
Once it lands it is recorded against the invoice, and the statement and aging update immediately.
Can a party be a customer and a supplier at the same time?
Yes, choose the type “both”. It stays one file with one number and one set of details, with two accounts: a receivable for what they buy from you and a payable for what you buy from them. You can request two separate statements, one as customer and one as supplier, so the figures never mix.
This is common in trading and distribution. Instead of two files with the same name and doubt about which to update when a phone number changes, you maintain one. Supplier-only fields, such as the default expense account and bank details, appear only when the party is a supplier.
Supplier balances connect to purchasing: a supplier invoice raises the payable, and paying it from cash and bank management software reduces it.
How do you set a credit limit and payment terms per customer?
You set both in the customer file: payment terms in days and a credit limit as an amount. Invoices use the payment terms to compute the due date, so nobody types it each time.
When an invoice would take a customer past their limit, sales and invoicing software reacts according to a setting you choose: allow, warn, or block. A separate permission lets selected people override the limit, so you can stop an ordinary employee and leave only a manager able to issue an exceptional invoice for a trusted customer. The check runs when the invoice is saved, so the seller learns at the moment of sale rather than the accountant at month end.
A practical tip: start by setting limits for new and small customers only, and leave them blank for those you trust. A strict limit on everyone slows selling, and no limit invites debt to pile up.
What about supplier accounts?
Suppliers get the same file, statement and aging from the opposite angle: what you owe and when. The supplier file adds the default expense account their invoices are charged to and the bank details for transfers: bank name, IBAN, SWIFT and account holder. A field for “our account number with the supplier” makes payment correspondence easier.
Supplier aging helps you order payments: pay those past due first and defer those not yet due, protecting both your reputation and your cash. A supplier invoice enters their payable directly, and settling it from the treasury reduces the balance.
How do you move from an Excel ledger to the system?
Upload your customer list as it is and the system does the rest in four steps. Suppliers use the same flow with their own template.
- 1
Download the template or upload your file
CSV and XLSX up to 20 MB are accepted; the template covers name, phone, email, tax number, address, credit limit, opening balance and tags.
- 2
Match the columns
The system guesses headers in Arabic and English, mapping “mobile” and “phone number” to the phone field, and you adjust any miss.
- 3
Preview the rows
Every row is validated before saving, showing errors and what will be imported, so broken data never slips in unseen.
- 4
Start the import
It runs in the background and ends with a report of rejected rows and the reason for each, so you can fix and re-upload.
How does an Excel ledger compare with customer accounts software?
Excel works for a few dozen customers run by one disciplined person, and fails when staff multiply and activity grows. The comparison is between kinds of method, not between named products.
| Criterion | Paper ledger or Excel | Anzma customer accounts |
|---|---|---|
| Balance updates | Manual after every transaction | Automatic with each invoice and payment |
| Debt aging | Fragile formulas, or none | Ready report with four buckets |
| Several users | Conflicting copies of the file | Users with permissions on one system |
| Change history | Not available | Activity log on every file |
| Link to invoices | Copy and paste | Every statement line opens its document |
| Credit limit that stops a sale | Not possible | Allow, warn or block |
| Access anywhere | A file on one machine | Cloud, in the browser |
| Sending the statement | Manual copy | Export PDF or Excel and send it yourself |
Who is it for and how do you start?
It suits any business that sells or buys on credit: wholesale and retail shops, supply companies, workshops and service offices. The module is enabled in every business template, including retail store management software, tender and supply management software, pharmacy management software, car showroom management software and marketing agency management software.
To start, import your customers and suppliers, enter opening balances at your go-live date, set payment days and credit limits, then raise a first invoice and watch its effect on the statement. Plans differ in users and branches, so see the pricing page. To decide whether one system covering accounts and sales suits you, read the ERP selection guide, or book a free online meeting and we will migrate your customers and show you the statement on your own data.
Frequently asked questions
How do I get a customer statement of account?
Open the customer file and use the Statement tab for the latest movements, or open the customers and suppliers statement report in financial reports and pick the customer and period. You get the opening balance, movements, closing balance and aging, exportable as PDF or Excel.
Does the balance update automatically with every invoice and payment?
Yes. The statement is read from the sub-ledger: every posted invoice increases what the customer owes, and every payment, return or credit note reduces it. You never type the balance. Drafts do not affect it before posting, and cancelling a document reverses its effect.
How do I see which debts are overdue?
Use the aging report. It splits each customer’s debt into 0–30, 31–60, 61–90 and over 90 days by invoice age, largest debt first. Payments are applied to the oldest open invoice, so the genuinely late invoice shows up rather than the newest one.
Can one party be both customer and supplier?
Yes, by choosing the type “both”. It stays one file with two accounts: a receivable for what they buy from you and a payable for what you buy from them, with a statement as customer and another as supplier. No need to duplicate details in two files.
How do I import my customers from Excel?
On the customers screen choose import and upload a CSV or XLSX file, or start from the template. The system guesses the columns, you preview the rows, and it imports the valid ones in the background, handing back a report of rejected rows and reasons. Suppliers work the same way.
Can I send the statement to the customer?
You export the statement as PDF or Excel from the report and send it yourself by email or WhatsApp. The system does not send account statements automatically today. Invoices and quotations have their own links and mailing in the sales module.
Is a customer balance debit or credit?
A customer who owes you has a debit balance, because it is a receivable on your books. It becomes credit if they overpay or pay in advance. The system reads the balance by party type, so for a supplier the sign is reversed.
Does the system check for duplicate customers?
Yes. On saving, it looks for a party with the same phone, email or tax number and shows the matches so you can decide. It is a warning rather than a block, since one customer may have several branches sharing a tax number or phone.
Can I group customers into segments?
You classify them with tags, add or remove tags for many customers at once, and filter the list by tag. The same tags feed campaign segments in CRM. There is no separate customer-groups screen today.
Does it support multiple currencies?
A party can have its own currency, and invoices can be issued in other currencies with an exchange rate on the document, as in the sales module, with everything posted to the books in the company currency. Check your company’s base currency before importing.
Part of the product line
customer management software
Six modules on one customer: the account, statement and ageing; the lead, opportunity and follow-up; and points, memberships, credit and deposits, all tied to the invoice and the books.
Rate this page
Did you find this useful? Your rating helps others.
No ratings yet.


