Retail Shop Statement of Account Template (Customer & Supplier)

A retail shop owner in Jeddah, Riyadh, or Dammam needs a clear answer every month to one simple question: how much is owed to me and how much do I owe, for each customer, each supplier, the bank, and the cash drawer. The answer never comes from a single invoice or a receipt voucher pinned to the office board. It comes from a structured accounting document called a statement of account. The statement of account is the mirror that shows your financial relationship with one specific party over a defined period: opening balance, every debit and credit movement, and the closing balance.

The problem is that many small and mid-size retail shops in the Saudi market still issue statements of account manually on an Excel sheet, with no sequential numbering, no tax identification number, no separation between the pre-VAT 15% value and the post-VAT value, and no official signature from the shop. This approach causes customer disputes, delays collection, and creates an obvious weakness in front of a ZATCA auditor when they ask you to match declared revenue with customer statements.

This page gives you a ready-to-use statement of account template for a retail shop. It works for customers, suppliers, banks, and the cash drawer. You will find a detailed explanation of every field, the differences between a monthly statement and a custom-period statement, how to use the statement to collect overdue debts, how it ties into your annual Zakat return, and how Qoyod generates the statement for any party in a single click with zero manual work.

What is a retail shop statement of account, and how does it differ from an invoice and from the general ledger

A retail shop statement of account is a formal accounting document that summarizes all financial activity between the shop and one specific party (customer, supplier, bank, or cash drawer) over a defined period. It starts with an opening balance on day one of the period, lists every debit and credit transaction in chronological order with the running balance updated after each movement, and ends with a closing balance that precisely equals what the party owes the shop, or what the shop owes the party.

Many shop owners confuse three very different documents: the invoice, the statement of account, and the general ledger. Each has a defined purpose and audience, and mixing them up causes customer disputes and errors in tax filings.

The tax invoice

An invoice is a document that records a single sale at a single point in time. It contains a unique invoice number, issue date, seller details (trade name, tax identification number, address), buyer details, item descriptions, price before VAT 15%, the VAT amount, and the total. The invoice does not show prior balances or later payments. It shows only that one transaction. Under Phase 2 of e-invoicing, the invoice is issued in XML format with an attached QR code and sent to the Fatoora platform of the Zakat, Tax and Customs Authority (ZATCA) at the moment of issuance.

The statement of account

The statement of account is not a sale. It is a summary of every sale and every collection with one party. If you have a customer who bought 12 invoices from you in a month and paid 4 installments, the monthly statement consolidates them all on a single page. It opens with the balance carried over from the previous month, lists the 12 invoices in the debit column and the 4 payments in the credit column, and then prints the remaining balance. The purpose of the statement is for the other party to see a complete picture of their relationship with you, so you both agree on a final number that feeds into settlement or payment.

The general ledger

The general ledger (GL) is a strictly internal document inside the accounting system. It never goes out to the customer. It contains the movements of every account in the chart of accounts: sales account, purchases account, the bank account, accounts receivable, VAT 15% payable, and so on. The statement of account is extracted from the general ledger, but the difference is that the general ledger is meant for the accountant and the auditor, while the statement is meant for the external party. To be precise, a customer’s account in the general ledger is essentially the same as their statement of account, just in an internal format without any formal presentation.

Types of statements of account in a retail shop

A retail shop does not issue one type of statement. It issues five main types, each serving a different counterparty and a different purpose. The mix-up happens often in small shops, which is why your chart of accounts must be designed to fully separate each type.

Customer statement of account (accounts receivable)

Issued to customers who buy on credit (mostly B2B). Your issued invoices appear in the debit column, and their payments appear in the credit column. A positive balance means the customer owes you. This statement is the primary collection tool and is sent periodically to customers as a reminder and a request for payment. In our example, a shop in Jeddah sells to 8 B2B customers; each customer has an independent statement that opens with their own opening balance followed by the month’s activity.

Supplier statement of account (accounts payable)

The supplier issues this to you, and it mirrors your own statement. Purchase invoices you received from them appear in the credit column on your side (an increase in your obligation), and your payments to them appear in the debit column. A credit balance means you owe them. You use this statement to reconcile your cycles with the supplier before any payment, especially with wholesale suppliers from whom you buy SAR 50,000 or more per month.

Bank statement of account

The bank (Al Ahli, Al Rajhi, Al Bilad, Alinma, Riyad) issues this monthly, showing every deposit, withdrawal, and fee. You use it for the monthly bank reconciliation: you compare the bank account activity in your accounting system with the actual bank statement, identify the differences (uncashed checks, deposits in transit, fees you did not record), and then post adjusting entries to equalize the two balances. This is a mandatory monthly process in any well-run shop.

Cash drawer statement of account

The cash drawer is the liquid cash account inside the shop (cash in the till, or what is handed to the cashier at the end of the day). The cash drawer statement records every cash inflow and outflow: cash revenue from direct sales, small petty expense withdrawals (fuel, cleaning, hospitality), cash deposits to the bank, or owner draws. The closing balance must match the physical cash count at end of day, and any difference is resolved with a shortage or overage entry.

Till (POS) statement of account

In modern systems, the till refers to a specific point of sale or cashier station. If you have 3 cashiers in the shop, each has their own till with its own statement, closed at end of day by handing cash over to the main drawer. This separation is essential to hold each cashier accountable and to control any daily shortages or overages.

Components of a professional statement of account

A statement of account that the customer respects and that a ZATCA auditor accepts has a fixed structure. Any missing column opens the door to disputes, and any unclear field lengthens the collection cycle. These are the mandatory components:

• Document header: shop name as listed in the commercial register, tax identification number (15 digits), national address, contact number, shop logo.
• Counterparty details: customer or supplier name, their tax identification number if available, their account number in your system (customer code), period dates (from date to date).
• Opening balance: the amount carried over from the end of the previous period, on the first line.
• Activity columns: date, reference number (invoice number or receipt voucher), description (short narration), debit, credit, running balance after each movement.
• VAT field: total VAT 15% included in the period’s invoices, presented separately.
• Closing balance: the final amount on the last line, marked “Debit” or “Credit” as appropriate.
• Signature and stamp: signature of the responsible person and the shop’s stamp at the bottom.

Sample table for a customer statement in Jeddah

This is a real-world example for one of the eight customers of the Jeddah shop, with an opening balance of SAR 5,625 (part of a total SAR 45,000 spread across the 8 customers), over a full month of activity:

Note on the table: total sales for the month are SAR 10,350 (inclusive of VAT 15%), which equals SAR 9,000 before VAT and SAR 1,350 VAT. Collections in the month are SAR 9,075. Closing balance is SAR 6,900 owed by the customer, and this figure rolls forward as the opening balance for June.

Differences between a monthly statement and a custom-period statement

Retail shops in Saudi Arabia use two types of periods when issuing statements of account, and each has its purpose and use case.

The recurring monthly statement

Issued once per month, usually on the last day of the month or the first day of the following month. Its purpose is to periodically remind the customer of what they owe, and it is sent automatically to all active customers. This statement is the foundation of ongoing communication with your customer base, and it helps reduce forgetfulness and surface any dispute early. In the Jeddah shop with 8 B2B customers, the monthly statement goes out on day 1 of each month and an email is sent to each one.

The custom-range statement

Issued only as needed, for a period the user defines: from March 15 to June 30, the full fiscal year, or the second quarter. It is used in specific cases:

• Settlement before signing a new contract: if you are about to sign a new contract with an existing customer, you ask them to agree on the closing balance for the entire prior period before the new period starts.
• Year-end close: on December 31, you issue a period statement from January 1 to December 31 for every customer and supplier as part of annual closing procedures.
• Quarterly VAT filing: if your business size requires VAT 15% returns every 3 months, you issue a period statement for each customer to verify the declared amounts.
• Legal or arbitration review: when a dispute with a customer escalates to a lawyer or court, you issue a full period statement covering the entire history of dealings.

Practical comparison of the two types

How statements are issued on a recurring schedule and how they are delivered

Issuing statements of account manually in Excel is the number one reason for delayed collection in small shops. With 8 customers, you need a full hour at the end of every month to issue 8 separate files, verify carried-over balances, and send each one. With 50 customers, the task takes a whole day.

The right solution is automated scheduling: you prepare the template once, connect it to the daily transaction database in the system, and then schedule issuance to run automatically on a fixed date every month.

Delivery channels

• Email: the most-used formal channel in B2B. You attach the statement as a PDF with explanatory text and a call to settle. Make sure the customer’s email in your database is correct and up to date.
• WhatsApp: a very effective channel in the Saudi market for individuals and small shops. You send the PDF via WhatsApp Business with a friendly message.
• Printed copy: still essential with traditional customers, especially in industrial zones and popular markets. You print the statement with stamp and signature and hand it over in person.
• Secure link (customer portal): in advanced systems, the customer gets a login link to a dedicated portal where they can view their statement online at any time.

Timing of delivery

The best time to send the monthly statement is between days 1 and 3 of the following month. Sending it on day 1 reaches the customer before they get busy with their new month’s work, and gives you room to follow up before the end of the first week. Sending it in the middle of the month weakens collection effectiveness, because the customer has already spent their liquidity on other obligations.

Mandatory fields and VAT 15% in the statement

The Zakat, Tax and Customs Authority (ZATCA) requires statements of account to support and match tax returns. Any discrepancy between a customer statement and what is declared in the VAT 15% return triggers audit alerts. The mandatory fields:

• Tax identification number: the 15-digit number for the shop (seller), and for the counterparty if they are VAT-registered.
• Date of each transaction: a clear Gregorian date in YYYY/MM/DD format.
• Invoice reference: the tax invoice number as it appears in the Fatoora platform, so each line in the statement can be traced to the invoice XML when audit verification is needed.
• Pre-tax value: the original sale amount.
• Tax amount: 15% calculated separately.
• Total inclusive of tax: the amount recorded in the debit or credit column of the statement.

How VAT appears in the statement

There are two schools of thought on how to show VAT 15% inside the statement of account:

The first approach (compact): the invoice is shown in the debit column at its total amount inclusive of VAT, and a summary at the end of the statement breaks down the total VAT included in the period’s activity. This approach is simpler for the customer and more common.

The second approach (detailed): each invoice is shown on two lines: one line for the pre-tax value and a separate line for the VAT amount. This approach suits B2B customers who use the statement in their own tax returns and need a clear breakdown.

Pick one approach and apply it consistently across all customers. Do not mix the two.

Statements of account and reconciliation with customers and suppliers

Reconciliation is the process of agreeing on a final shared number between two parties after comparing each side’s statement. In practice, the shop’s statement rarely matches the customer’s statement on the first pass, which is normal due to timing differences and recording errors.

Common causes of variances

• Timing differences: the shop recorded the invoice on the 30th, but the customer actually received it on the 2nd of the following month and so it shows up in their statement one month later.
• Payments in transit: a bank transfer made on the 31st that did not hit the shop’s account until the 2nd.
• Unrecorded discounts or returns: the customer returned goods that the shop has not yet recorded.
• Human errors: an invoice number recorded incorrectly, or an amount entered wrong.

Structured reconciliation steps

1. Ask the customer to send their own statement for the same period.
2. Compare the two statements line by line and identify the variances.
3. Classify each variance by cause: timing, recording error, missing invoice, missing payment.
4. Agree on the necessary adjusting entries from both sides.
5. Issue a new “post-reconciliation” statement reflecting the agreed balance, signed by both parties as the formal reference.

This process typically happens every quarter with large customers and once a year with the rest. Do not wait for a dispute to start reconciling.

How to use the statement of account to collect overdue debts

The statement of account is not just an informational document. It is a powerful collection tool if used wisely. Many shop owners lose large amounts every year because they do not leverage the statement to accelerate collection. The smart use of the statement rests on three pillars.

Classify debts by aging

Add an aging table to the statement that breaks the outstanding balance into time buckets:

This classification shows the customer that some debts have actually been outstanding for a while, prompts a sense of urgency, or moves them to negotiate a payment plan. It also helps you set priorities in follow-up.

A structured follow-up sequence

Adopt a clear escalation ladder by debt age:

• Day 1 of the following month: send the monthly statement by email with a neutral tone.
• Day 15: friendly phone call to confirm the statement was received.
• Day 30: formal WhatsApp message requesting a payment date.
• Day 45: in-person visit or a message from shop management.
• Day 60: formal written notice with credit on hold.
• Day 90: referral to a lawyer or a specialized collection office.

Offer flexible payment options

Attach a payment-plan offer with the statement if the amount is large, or a small early-payment discount (1% to 2%) for those who settle within 10 days. These incentives shorten the collection cycle in many cases.

Statements of account and the annual Zakat return

ZATCA requires the annual Zakat return for a retail shop to include a clear statement of accounts receivable and accounts payable at fiscal year-end. These figures are extracted directly from the statements of account.

Accounts receivable in the return

The total of customer statement balances (debits in your favor) is included in the Zakat base as a business asset. Long-standing receivables (over two years old) are subject to special rules in Zakat and may be excluded from the base if their delinquency is proven and there is no reasonable prospect of collection.

Accounts payable in the return

The total you owe to suppliers (supplier statement balances) may be deducted from the Zakat base under the conditions set by ZATCA. So it is in your interest to keep supplier statements accurate and up to date on December 31.

Documentation requirements

During an audit, the ZATCA auditor will request:

• Statements of account for every customer and supplier as of December 31, with details of the year’s activity.
• An official bank statement from the bank on December 31 that matches the bank account balance in the accounting system.
• The cash drawer statement on December 31 with a physical cash count record.
• A breakdown of long-standing receivables with the collection actions taken.

Differences between system-generated and manual statements

A manual statement in Excel or Google Sheets only works for a shop with fewer than 3 to 5 credit customers and simple monthly activity. As soon as customer count exceeds 8 or 10, manual statements become a real burden and a risk to the accuracy of your numbers.

Common mistakes when issuing statements of account

This is a list of mistakes that recur in small and mid-size shops. Watch for them before sending any statement.

1. Opening balance does not match the prior closing balance

One of the most common mistakes: the new monthly statement opens with a different opening balance from the prior month’s closing balance. The usual cause is a manual edit to the old statement after it was sent. The fix: never edit a statement you have already sent. Instead, issue a separate correction statement.

2. Mixing VAT-inclusive and VAT-exclusive invoices

Some shops record old invoices (pre-2018) without VAT 15% and modern invoices inclusive of VAT, which causes confusion in the total figures.

3. Skipping returns and credit notes

Returns must appear as a separate credit note with its own number, not be netted against the original invoice.

4. A statement without a tax identification number

Any statement issued without the 15-digit tax identification number in the header is not fit for official use and is not accepted in audits.

5. Unclear currency unit

Writing numbers without “Saudi Riyal” or the SAR symbol creates ambiguity, especially when dealing with foreign suppliers.

6. Sending to an outdated email

The customer database must be refreshed at least once a year, especially emails and contact numbers.

7. Missing signature and stamp

A statement without the signature of the responsible person and the shop’s stamp counts as a draft, not a formal document.

How Qoyod generates the statement for any party in a single click

Qoyod (qoyod.com) turns the monthly chore of issuing statements of account into a single click. The system is built on a standard chart of accounts that automatically separates customers, suppliers, banks, cash drawers, and tills. Every sale, purchase, collection, or payment is recorded in real time in the relevant account.

How the system works

• Create the customer or supplier once: you record the party’s details (name, tax identification number, email, WhatsApp, national address), and a sub-account is automatically generated in the chart of accounts.
• Real-time transaction recording: every invoice you issue to a customer is automatically posted to their statement, and every receipt or payment voucher updates the balance instantly.
• One-click issuance: pick the customer, set the period, click “Issue,” and you get a professional PDF with all activity neatly organized.
• Automated scheduled delivery: schedule monthly statements to all active customers to send automatically on a fixed date each month, via email or WhatsApp.
• E-invoicing link: every invoice in the statement is linked to the original XML sent to the Fatoora platform, with QR code for verification.
• 24/7 support: the Qoyod support team is available around the clock to help you set up statements or resolve any issue.

The value for a shop in Jeddah

The Jeddah shop in our example, selling to 8 B2B customers with a total opening balance of SAR 45,000, benefits from Qoyod (qoyod.com) on three levels:

Level 1 (operational): instead of one hour a month to issue 8 statements manually, 30 seconds is enough to issue and email them all. Saving an hour each month means 12 hours per year for the accountant.

Level 2 (collection): aging reports flag overdue customers immediately, enabling smart follow-up and faster collection. If we assume the shop’s average long-standing receivables are SAR 8,000 per year, accelerating collection by 25% frees up SAR 2,000 of trapped cash.

Level 3 (tax): statements of account in Qoyod match VAT 15% returns submitted to ZATCA exactly, so no discrepancies arise that would trigger an audit.

Explore Qoyod’s plans to choose the right plan for your shop size, and visit the Qoyod for retail page to see solutions tailored for retail shops.

Frequently asked questions

Is a statement of account issued from Excel legally acceptable in Saudi Arabia?

An Excel statement is acceptable as an internal document and as a communication reference with customers, but it is not a substitute for a certified accounting system for formal tax purposes. ZATCA requires tax invoices to be issued from a certified e-invoicing system connected to the Fatoora platform, and a statement extracted from that system automatically carries an official character. An Excel statement on its own is just a manual summary that is prone to errors.

How often should I issue statements of account to my customers?

The minimum is once a month for active customers buying on credit. For large customers (where your annual dealings exceed SAR 100,000), make it a bi-monthly statement every 15 days. For customers you stopped dealing with due to delinquency, send a monthly statement as legal evidence of the claim and as an ongoing reminder.

What is the difference between a debit balance and a credit balance on a customer statement?

On a shop’s customer statement: a debit balance means the customer owes the shop (they have not yet paid the full value of their invoices). A credit balance means the customer is in credit with the shop (they paid more than they bought, so they have a balance in their favor). Most customer statements naturally show a debit balance. On a supplier statement, it is the reverse: the supplier is in credit with you when you have received goods you have not paid for.

Should VAT 15% be shown separately on every line?

The law does not require you to show VAT on every line of the statement, because the detailed VAT breakdown is on the tax invoice itself. It is enough for the statement to show the total VAT included in the period’s activity in the final summary. That said, if your B2B customer uses the statement in their own tax return, it is better to show VAT separately on each line to make their work easier.

How do I handle a customer who disputes the balance on their statement?

Step one: ask them to send you a copy of your account in their books. Step two: compare the two statements line by line and identify variances. Step three: classify the variances into four categories (timing differences, recording errors, missing invoices, missing payments). Step four: agree on the necessary adjusting entries from both sides. Step five: issue a new “post-reconciliation” statement showing the agreed balance, signed by both parties. That document becomes the reference for the period in question and is not reopened for dispute.

Can I send the statement of account by WhatsApp only?

Yes, WhatsApp is very effective in the Saudi market, but it is always better for WhatsApp to be a supporting channel and not the only one. Email remains the most legally robust channel for archiving. A good plan: send the statement by email on day 1 of the month, then send a short WhatsApp reminder on day 5 with the same PDF attached to confirm receipt.

At what customer count should I move from Excel to an accounting system?

The practical rule: more than 5 credit customers, more than 30 invoices per month, or any dealings with suppliers above SAR 20,000 per month. At these thresholds, manual statements become costly in time, in errors, and in missed collection opportunities. Moving to an accounting system pays for itself in the first 3 months through time savings, faster collection, and fewer errors.

Is the statement of account considered legal evidence to claim a debt?

The statement of account on its own is not conclusive evidence, but it is strong supporting evidence, especially when combined with the original tax invoices, delivery documents, and shipping paperwork. In Saudi commercial courts, combining the invoice (original), the statement of account (summary), and the delivery receipt (proof) builds a strong claim file. So keep an organized archive of all these documents for at least 6 years (the retention period required by ZATCA for records).