Sage accounting integration for payments: cloud vs Pastel

A Sage accounting integration links your payment and billing system to Sage so that invoices, receipts, fees and refunds are posted automatically. How you do it depends on which Sage product you run: cloud-based Sage Accounting can usually receive data through a direct connection, while desktop Sage 50cloud Pastel is more often fed by a structured import file. Either way, the aim is the same: no retyping of payments, and debtors that are right every day, not just after month-end.

Sage has a long history in South Africa, and many accountants and bookkeepers are most comfortable in it. That makes getting payments into Sage cleanly a priority for a lot of local businesses.

Which Sage product are you on?

As of September 2026, Sage's South African range includes, among others:

Larger businesses may run other Sage ERP products, which usually involve an implementation partner. Check with Sage or your partner which integration options your edition supports.

The practical difference for payments:

• Cloud products typically expose an API, so a billing platform can create customers, invoices and receipts directly.
• Desktop products are commonly updated through batch imports (for example customer receipts or journals) that your bookkeeper reviews and posts.

What a Sage accounting integration should send (and leave out)

You don't need every gateway event in your ledger. Send the records that affect debtors, revenue, VAT and cash:

1. Customers, with account codes that are stable over time.
2. Tax invoices, with each line carrying the correct VAT code.
3. Customer receipts, allocated to the invoice they pay.
4. Merchant fees, as an expense (with VAT where the gateway's tax invoice shows it).
5. Credit notes and refunds, linked to the original invoice.
6. Settlement transfers, from a clearing account to the bank.

Leave out things like abandoned checkouts, declined card attempts and customer portal logins. They belong in your billing system's reports, not in the general ledger.

A step-by-step setup

Agree the account codes

Sit down with your accountant and agree:

• a sales account per revenue stream (for example "Subscriptions - monthly", "Once-off services");
• a gateway clearing account for each gateway, or one shared account;
• a bank charges / merchant fees account;
• a debit order unpaids process (whether you reverse the receipt or post to a suspense account first).

Match VAT codes

Your billing system and Sage must agree on VAT: standard-rated at 15%, zero-rated and exempt supplies each need their own mapping. Also confirm whether amounts are sent inclusive or exclusive of VAT. A mismatch here produces small rounding differences on every invoice that add up to a painful VAT201 reconciliation.

Choose sync or import

• If you're on a cloud product with a supported connection, sync daily or in near real time.
• If you're on Pastel desktop, schedule a daily or weekly export of receipts and invoices in the format your import expects, and have one person review and post the batch.

Reconcile the first week by hand

Take one week of transactions, post them, and reconcile the bank account in Sage. The gateway clearing account should return to zero after each settlement. Only when that works do you switch to routine operation.

Why clearing accounts matter so much

Suppose Yoco or PayFast pays out R12,340.00 on Monday for the weekend's sales. The customer invoices total R12,690.00 and the gateway deducted R350.00 in fees (illustrative figures). If you post R12,340.00 as a receipt, three things go wrong: your revenue is understated, your fees are missing and no individual invoice is marked paid.

With a clearing account, the receipts (R12,690.00) go in, the fee (R350.00) and the bank transfer (R12,340.00) go out, and the balance is zero. That single number tells you everything matched.

South African situations to plan for

• Debit order unpaids. A Netcash debit order can come back unpaid after the batch settled. Reverse the receipt on the exact invoice and flag the customer for follow-up.
• Manual EFT. Match on the bank statement reference, not on a proof of payment. Our EFT vs debit order vs card payments guide compares the options.
• Statements. Many B2B customers still expect a monthly statement. If you generate them from your billing system, make sure the balances agree with Sage. See our guide to the customer statement of account.

Common pitfalls

• Two systems both creating invoices, giving duplicate debtors.
• Account codes that change between exports, breaking customer history.
• Refunds processed at the gateway but never credited in Sage.
• Suspense accounts that quietly grow because nobody owns them.

How CentraPoint helps

CentraPoint runs the billing and collections side: VAT-aware invoices (inclusive or exclusive), subscriptions, payment links and EFT orders, collected through gateways you contract with directly. Statement import auto-matches collections, unpaids, fees and payouts, with exceptions in a queue for review. Accounting integrations include Sage, Xero, QuickBooks and Zoho Books, plus a Pastel export for desktop setups. Read the reconciliation docs for how matching works.

Frequently asked questions

Can payments sync automatically into Sage Pastel?

Desktop Sage 50cloud Pastel setups commonly use structured imports rather than live sync. Check with Sage or your business partner which import and connection options your edition supports.

Should I use one clearing account per gateway?

It's easier to reconcile with one per gateway, because each settlement then clears its own account. A shared account works for low volumes but makes differences harder to trace.

How do I handle debit order unpaids in Sage?

Reverse the original receipt against the specific invoice when the unpaid is reported, so the customer's balance is correct. Then follow your collections process to re-present or contact the customer.

Do I need my accountant to set up the integration?

It's strongly recommended. They should sign off on account codes, VAT mappings and the unpaids process before you switch on automated posting.