Sage One ZA workflow
How to monitor FX exposure from Sage One South Africa
Updated
Sage One Accounting South Africa holds the raw material for an FX review: tax invoices, supplier invoices, customer receipts, supplier payments, allocations, currencies and bank accounts, measured against a rand base. The work is turning those records into a finance view that separates open exposure, settlement rates and cash timing, and preparing the balance of payments category your bank needs, because the bank submits BOPCUS to SARB while the business supplies the category.
For South African finance teams running Sage One who want a practical, rand-based FX exposure workflow from their own accounting records.
The short answer
Start with open foreign-currency tax invoices and supplier invoices in Sage One, read the exchange rate held on each document, then use customer receipts, supplier payments and allocations to separate settled FX from open revaluation against your rand base. Keep every figure tied back to the Sage One document number so each rand of FX movement has a source record behind it.
Source records
| Record | Used for | Watch out |
|---|---|---|
| Tax invoices | Open foreign receivables, customer concentration, document numbers and due-date buckets. | Outstanding, Overdue, Unpaid and PartiallyPaid all describe an invoice that is still exposed, so filtering on Outstanding alone understates the position. |
| Supplier invoices | Supplier obligations, payable timing and natural offset checks against foreign receipts. | A foreign supplier invoice falling due before the customer receipt creates a rand funding gap even when the net currency position looks small. |
| Customer receipts, supplier payments and allocations | Settlement dates and settlement rates for realised FX on paid foreign documents. | A part-paid invoice settles across several allocations, so the settlement rate is an amount-weighted blend of the individual payment rates rather than a single quoted rate. |
| Bank accounts and the currency list | Foreign cash held by currency, which can offset exposure and can also move on revaluation. | Sage often returns a numeric currency identifier on a bank account instead of an ISO code, so the currency list has to resolve first before the balance means anything. |
What finance teams run into
| Problem | What it means | Response |
|---|---|---|
| Rand and foreign documents share one ledger | Finance reads a rand total that already blends translated foreign invoices with domestic ones, so the exposure is invisible at the top line. | Group receivables and payables by transaction currency first, then translate into rand for the reporting view. |
| A foreign invoice with no usable booking rate | Some Sage One rows carry the rate on the customer or supplier field rather than on the document header, so the booking rate can read as 1 and the FX impact disappears. | Resolve the rate from the customer or supplier exchange-rate field, and where nothing usable exists, backfill from a dated public reference and label that source on the invoice. |
| The BoP category gets chosen in the bank portal | The category is decided under time pressure at payment, away from the invoice that explains what the money was for. | Prepare the category against the invoice record in advance, and leave the submission with your Authorised Dealer. |
Checks before relying on the numbers
- Base currency. Hedgr reads the company default currency from Sage One and falls back to ZAR when the company record does not state one, so confirm the base before reading any translated figure.
- Rate source. Each foreign invoice should show whether the rate came from the Sage One document, from a matched payment, from a payment allocation, or from a dated public fixing, because an unexplained rate makes the FX number unauditable.
- Invoice status. Open invoices belong in unrealised FX and Paid invoices belong in realised settlement impact, so the status mapping decides which side of the bridge each document lands on.
- Cash timing. A foreign receivable only funds a foreign supplier invoice once the cash actually lands, so the due dates matter as much as the currency match.
- BoP preparation boundary. The bank submits BOPCUS to SARB and the business supplies the category, so a prepared category is evidence for your Authorised Dealer and is not a filing.
Sage One ZA records to finance question
Illustrative figures, not customer data.
| Item | Value | Note |
|---|---|---|
| Tax invoices | Foreign receivables | Open customer amounts, document numbers and due dates, translated against the rand base. |
| Supplier invoices | Foreign payables | Supplier obligations and the rand outflow they create on their due date. |
| Receipts and allocations | Settled items | Settlement dates and amount-weighted settlement rates once the cash has moved. |
| Bank accounts | Foreign cash held | Balances by currency, once the Sage currency identifier resolves to an ISO code. |
| BoP category | Prepared for the bank | A category per cross-border receipt or payment, ready for the Authorised Dealer to submit. |
Sage One ZA FX review checklist
| Stage | Finance question | What to check |
|---|---|---|
| Pull open items | What is still exposed? | Tax invoices and supplier invoices with Outstanding, Overdue, Unpaid or PartiallyPaid status, grouped by transaction currency. |
| Match settlement | What has settled? | Customer receipts, supplier payments and allocations matched to paid foreign documents, with the settlement date and the amount-weighted rate. |
| Bucket timing | What is due first? | Overdue items, then the 0-14, 15-30, 31-60, 61-90, 91-180 and 180 day-plus maturity windows. |
| Explain movement | Why did FX P&L change this month? | Rate movement on open items, newly raised foreign invoices, invoices settled during the period, and overdue receipts. |
| Prepare the category | What does the bank need from us? | The balance of payments category for each cross-border receipt and payment, with the invoice attached as the reason for the flow. |
Common mistake
Reading a single rand total out of Sage One hides the settlement rate behind each paid foreign invoice, and that rate is what turns an open exposure into a realised gain or loss.
Where Hedgr fits
Use Hedgr to connect Sage One South Africa records into one rand-based view of open exposure, realised and unrealised FX, cashflow timing and BoP category preparation. Hedgr is paid by subscription only, so the analysis has no view on whether you should hedge, and any conversion or forward cover happens at your own bank or broker.
Related guides
- Sage One ZA FX Risk Management
- How to Monitor FX Exposure from Xero
- How to Monitor FX Exposure from QuickBooks Online
Hedgr is read-only. It does not execute trades, move funds or give investment advice.
Guides
- FX exposure basics
- SME FX policy template
- Unrealised FX gains and losses
- Realised vs unrealised FX
- Multi-currency invoice cashflow risk
- Xero FX exposure workflow
- QuickBooks Online FX exposure workflow
- Exporter month-end FX reporting
- Multi-entity FX consolidation software
- SARB BoP categories after the August 2026 change
- Sage One South Africa FX exposure workflow
- Rand exposure for SA importers and exporters
- IAS 21 and the margin basis: does your FX impact double-count?
- FX exposure from a spreadsheet
- AI tool to analyse FX exposure for a small business
- What to do when your FX broker drops your account
- Forward contract deposit and close-out cost for SMEs
- How to hedge one foreign-currency invoice
- What SME FX providers charge in 2026
- How to pay a USD supplier from a GBP account
- How to check an FX margin against the mid-market rate
- EUR supplier payments for a group with a GBP parent
- When to buy foreign currency for invoices
- FX payments with Xero and QuickBooks
- How a small business books an FX forward contract
- Alternatives to your bank for business FX payments
- Can a small business automate FX hedging?
- How invoice-by-invoice FX hedging works
- What agentic FX is, and what an AI FX agent should do
- Canada: USD payables for CAD-reporting importers
- Canada: FX exposure in QuickBooks Online Canada
- Canada: FX gains and losses in Xero
- Canada: checking a USD/CAD bank margin
- Canada: FX forward contracts for small businesses
- Canada: how to pay US suppliers in USD
- FX risk management software for SMEs
- FX hedging software for SMEs
- Hedge accounting software: IFRS 9 checklist for SMEs
- FX risk for e-commerce and DTC exporters