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

RecordUsed forWatch out
Tax invoicesOpen 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 invoicesSupplier 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 allocationsSettlement 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 listForeign 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

ProblemWhat it meansResponse
Rand and foreign documents share one ledgerFinance 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 rateSome 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 portalThe 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

Sage One ZA records to finance question

Illustrative figures, not customer data.

ItemValueNote
Tax invoicesForeign receivablesOpen customer amounts, document numbers and due dates, translated against the rand base.
Supplier invoicesForeign payablesSupplier obligations and the rand outflow they create on their due date.
Receipts and allocationsSettled itemsSettlement dates and amount-weighted settlement rates once the cash has moved.
Bank accountsForeign cash heldBalances by currency, once the Sage currency identifier resolves to an ISO code.
BoP categoryPrepared for the bankA category per cross-border receipt or payment, ready for the Authorised Dealer to submit.

Sage One ZA FX review checklist

StageFinance questionWhat to check
Pull open itemsWhat is still exposed?Tax invoices and supplier invoices with Outstanding, Overdue, Unpaid or PartiallyPaid status, grouped by transaction currency.
Match settlementWhat has settled?Customer receipts, supplier payments and allocations matched to paid foreign documents, with the settlement date and the amount-weighted rate.
Bucket timingWhat is due first?Overdue items, then the 0-14, 15-30, 31-60, 61-90, 91-180 and 180 day-plus maturity windows.
Explain movementWhy 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 categoryWhat 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

Hedgr is read-only. It does not execute trades, move funds or give investment advice.

Guides

Accounting integrations

Pricing · All integrations · Home