Skip to content
Anzma modulePart of Customers

Customer accounts software and system with live statements

One file per customer and supplier. Statements, balances and aging are built automatically from your invoices and payments, with no ledger book or Excel sheet to keep up to date.

Last updated: 7 min readBe the first to rate this page
Customer accounts software and system with live statements

In short

Anzma’s Contacts module is customer accounts software: one record per customer and supplier from which the statement of account, the balance and the aging of debts are built automatically from invoices and payments. It suits businesses that sell and buy on credit, and it sits underneath sales, purchasing, follow-up and loyalty, so nobody enters a customer twice.

Who is it for?

  • Shops selling on credit
  • Trading and distribution companies
  • Service providers
  • Accounting offices
  • Small business owners
Parties
Customers, suppliers, or both in one record
Statement
Live from the ledger, exported to Excel or PDF
Aging buckets
0–30, 31–60, 61–90 and over 90 days
Import
CSV and XLSX with preview and error report
Credit control
Credit limit and payment terms per customer
Used by
Sales, purchasing, CRM and loyalty

What you get, at a glance

  • One file per party

    Contact details, addresses, tax number, contact people, attachments, notes and an audit trail on a single screen for every customer or supplier.

  • Live statement

    Opening balance, then invoices, payments and returns with a running balance after each line, exported as Excel or PDF so you can send it to the customer.

  • Debt aging

    An aging report splits what is owed into 0–30, 31–60, 61–90 and over 90 days, so you see who is late and for how long.

  • Credit limit and terms

    Set a debt ceiling and payment days per customer, and choose whether the system allows, warns or blocks, with an override permission.

  • Customer and supplier at once

    A party you sell to and buy from stays one record of type “both”, with a customer statement and a supplier statement.

  • Import from Excel

    Upload CSV or XLSX, let the system guess the columns, preview every row, then import and get a report of rejected rows with reasons.

Inside the product

Customer invoices and balancesAn illustrative screen of invoices with status and balance, not real customer data.
On this page
Section 01

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.

Section 02

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).
Section 03

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.

Example: one month of a customer statement (illustrative numbers)
DateDescriptionDebitCreditBalance
01/03Opening balance2,000
04/03Sales invoice INV-01015,0007,000
12/03Payment received3,0004,000
19/03Return on INV-01015003,500
26/03Sales invoice INV-01071,2004,700
31/03Totals and closing balance6,2003,5004,700
Section 04

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.

Example: one customer’s debt by age (illustrative numbers)
0–30 days31–60 days61–90 daysOver 90Total
1,2002,50001,0004,700
Section 05

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.

Section 06

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. 1

    Open the aging report each week

    Sort by largest debt and look at the over-90 column first, then 61–90.

  2. 2

    Open each late customer’s statement

    Review open invoices and recent payments before calling, so you never chase something already paid.

  3. 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. 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. 5

    Record the payment on arrival

    Once it lands it is recorded against the invoice, and the statement and aging update immediately.

Section 07

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.

Section 08

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.

Section 09

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.

Section 10

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

Section 11

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.

Ways to track customer accounts
CriterionPaper ledger or ExcelAnzma customer accounts
Balance updatesManual after every transactionAutomatic with each invoice and payment
Debt agingFragile formulas, or noneReady report with four buckets
Several usersConflicting copies of the fileUsers with permissions on one system
Change historyNot availableActivity log on every file
Link to invoicesCopy and pasteEvery statement line opens its document
Credit limit that stops a saleNot possibleAllow, warn or block
Access anywhereA file on one machineCloud, in the browser
Sending the statementManual copyExport PDF or Excel and send it yourself
Section 12

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.

All Customers modules

Rate this page

Did you find this useful? Your rating helps others.

No ratings yet.

Share this pageWhatsAppXLinkedInFacebook
Pricing

Clear plans that grow with you

Nearly every module in every plan; plans differ by limits.

Basic

For small businesses getting started

450EGP / mo

Billed 5,400 EGP yearly

Save 24%

Includes:

  • 3 users and one branch
  • 150 invoices per month
  • Every module your activity needs
  • 5GB storage
Book a meeting
Most popular

Advanced

For growing businesses with several branches and warehouses

790EGP / mo

Billed 9,480 EGP yearly

Save 20%

Everything in Basic, plus:

  • 7 users, 2 branches and 3 warehouses
  • 750 invoices per month
  • 2 POS devices
  • 15GB storage
Book a meeting

Comprehensive

Everything: unlimited invoices, manufacturing, custom domain and API

1,590EGP / mo

Billed 19,080 EGP yearly

Save 20%

Everything in Advanced, plus:

  • 15 users, 3 branches and 5 warehouses
  • Unlimited invoices
  • Manufacturing, custom domain and API
  • 30GB storage
Book a meeting

Enterprise

For enterprises: open limits, dedicated server and SLA

Custom

Everything in Comprehensive, plus:

  • Unlimited users, branches and warehouses
  • Dedicated server and SLA
  • Storage on demand
  • Account manager and tailored onboarding
Contact us