Manual Supplier statement
The supplier statement (menu Statements / Advances) draws up, by supplier and by currency, the financial summary of the fiscal year: purchase turnover, amount paid, outstanding, balance due and advances. The magnifying glass opens the detailed statement (invoices + purchase delivery notes), exportable to PDF.
Overview
The supplier statement is the control screen for your purchase debt. For each supplier, it aggregates the fiscal year's purchases and shows how much you have paid, what remains due, and the advances already paid. Amounts are grouped by currency and by year.
Business goal
- Track the balance due to each supplier
- Manage treasury and due dates
- Find a supplier's invoices and purchase delivery notes
- Produce a PDF statement
Target audience
- Accounting / finance — debt tracking
- Purchasing department — supplier relationship
- Management — treasury oversight
Related pages
Suppliers and their settings are managed on the supplier record; categorization by category comes from supplier types. Overview: Suppliers.
Access and navigation
Left-hand side menu: Purchasing → Suppliers → Statements / Advances.
The statements table
At the top, summary cards total the amounts for the selected currency / year. Below, one row per supplier with its five color-coded indicators.
| Label | Category | Purchase turnover | Settled | In progress | Balance due | Advance | ||
|---|---|---|---|---|---|---|---|---|
| SOTUMAG Distribution | Wholesaler | 52,800.000TND | 38,600.000TND | 14,200.000TND | 14,200.000TND | 5,000.000TND | ||
| Comptoir Métal Sfax | Raw materials | 33,600.000TND | 19,600.000TND | 14,000.000TND | 14,000.000TND | 0.000TND |
Table columns
| Column | Description |
|---|---|
| Label | Supplier name. |
| Category | Supplier type (see Brands & categories). |
| Purchase turnover | Total purchases over the period. |
| Paid | Amount already paid. |
| Outstanding | Committed but not yet paid. |
| Balance due | Remaining to pay (debt). |
| Advance | Amounts paid in advance. |
| Detail | Opens the detailed statement (section 6). |
The 5 indicators
Each indicator has a dedicated color, identical in the cards and the table, for immediate reading.
Purchase turnover
PurpleTotal purchases (invoices + purchase delivery notes) made from the supplier over the period.
Paid
GreenAmount already paid to the supplier (= purchase turnover − balance due).
Outstanding
AmberAmount committed but not yet paid over the period.
Balance due
RedRemaining to pay (debt) — the figure to watch for treasury.
Advances
MagentaAmounts paid in advance, to be applied against future invoices.
Currency & year filter
The Search restricts the statement to a currency and a year. Since amounts are never mixed from one currency to another, this filter is essential for reading accurate statements.
Search statement
Always think in terms of currency
A supplier in EUR and a supplier in TND are never combined. Switch currency in the search to move from the TND statement to the EUR statement.
Detailed statement
The magnifying glass at the end of the row opens a supplier's detailed statement: a recap of its summary, then the document-by-document list.
| Type | Number | Date | Net | VAT | Gross | Settled | Balance due |
|---|---|---|---|---|---|---|---|
| Invoice | FA: N°000312 | 12/02/2026 | 18,000.000 | 3,420.000 | 21,420.000 | 21,420.000 | 0.000 |
| Invoice | FA: N°000327 | 18/03/2026 | 12,000.000 | 2,280.000 | 14,280.000 | 5,080.000 | 9,200.000 |
| Purchase delivery note | BLA: N°000118 | 26/04/2026 | 4,200.000 | 798.000 | 4,998.000 | 0.000 | 4,998.000 |
The detail view also shows the number of documents (invoices and purchase delivery notes) and the total advances for the supplier over the period.
Invoices & purchase delivery notes
The detailed statement combines two sources of purchase documents, each with its net / VAT / gross amounts, the amount paid and the balance due.
Purchase invoices
Final accounting documents. Their gross amount feeds the purchase turnover; their settlement feeds the Paid amount.
Purchase delivery notes
Goods receipts. The statement is built from the purchase delivery note date, grouped by supplier.
To enter these documents, see the Purchase invoices and Purchase delivery notes modules. The statement is only a read-only summary view; it does not modify any document.
PDF export
From the detailed statement, the PDF icon generates a PDF supplier statement covering the summary and the list of documents — ideal for archiving or sending to the supplier.
PDF content
- Header: supplier, currency, year
- Summary: purchase turnover, paid, outstanding, balance due, advances
- Detail: invoices and purchase delivery notes (net, VAT, gross, paid, balance due)
- Totals per document and number of items
The PDF exactly reflects the active filter (currency + year): change the filter before exporting to get the desired statement.
How it's calculated
The indicators derive from simple formulas, applied by currency and by year.
flowchart LR D[(Invoices + purchase delivery notes
currency · year)]:::st --> CA[Purchase turnover]:::p CA --> SD[Balance due]:::ko CA --> RG[Paid = Purchase turnover − Balance due]:::ok CA --> EC[Outstanding]:::am AV([Advances paid]):::pu --> D classDef p fill:#f3f1ff,stroke:#7366fe,color:#3b328f; classDef st fill:#F1F5F9,stroke:#475569,color:#1E293B; classDef ok fill:#D1FAE5,stroke:#10B981,color:#065F46; classDef am fill:#FEF3C7,stroke:#F59E0B,color:#92400E; classDef ko fill:#FEE2E2,stroke:#EF4444,color:#991B1B; classDef pu fill:#F6EFF9,stroke:#A020F0,color:#6b1a9c;
| Indicator | Calculation |
|---|---|
| Purchase turnover | Sum of the invoice and purchase delivery note amounts for the supplier over the period (currency / year). |
| Balance due | Remaining to pay, aggregated by supplier. |
| Paid | Purchase turnover − Balance due. |
| Outstanding | Amount committed not yet paid over the period. |
| Advances | Total advances paid to the supplier. |
Business rules
Aggregation by currency — amounts are never combined across currencies; each statement is read for one given currency.
Annual scope — the statement covers the selected year (from January 1 to December 31).
Multi-company isolation — you only see the statements of suppliers belonging to your own company.
Read-only — the statement is a calculated summary; it does not alter invoices, delivery notes, or payments.
FAQ & Tips
My EUR amounts aren't showing up?
The statement is filtered by currency. Select EUR in the search to see suppliers in euros.
The balance due looks high to me?
Open the detail (magnifying glass) to see invoice by invoice which documents remain to be paid, and plan your payments.
How do I archive a statement?
From the detail view, click PDF: the filtered statement (currency + year) is generated and downloadable.
Tip — keep an eye on the red
Mentally sort by Balance due (red): the largest balances are your top-priority treasury due dates.