The month-end file is open on one screen, bank statements sit in an email folder, and the person who built the spreadsheet is on leave. For many South African small businesses, that is the point where a spreadsheet stops serving the enterprise and starts creating exposure.
A pastel cloud accounting migration can bring daily transactions, customer balances and management reporting into one controlled system. It needs more than importing a trial balance. We treat it as an accounting system setup project, with SARS record retention, VAT treatment and access controls decided before the first transaction goes live.
Decide What You Are Moving From
The phrase “Pastel cloud” causes understandable confusion. Sage 50cloud Pastel is desktop accounting software with cloud-connected features. It does not operate in the same way as a browser-based cloud accounting platform where authorised users can work through an internet connection from different locations.
That distinction matters when directors expect remote access, live reporting or a cleaner handover between an internal bookkeeper and an external adviser. Before selecting software, establish whether the current environment is:
● A spreadsheet-based bookkeeping process, often with invoices, debtors and bank reconciliations in separate files.
● Sage 50cloud Pastel or another desktop Pastel product, with data held on a local machine or server.
● A cloud platform such as Sage Accounting, QuickBooks Online South Africa or Xero, which needs repair, restructuring or a more disciplined chart of accounts.
We do not recommend a full system migration simply because the business wants a modern interface. If a small enterprise has a low volume of transactions, one experienced bookkeeper and well-maintained records, an improved spreadsheet process may remain appropriate for a period. Once several people edit files, debtors require regular follow-up, or management needs weekly figures, cloud accounting usually gives stronger control.
Start With a Clear Migration Scope
A migration scope should answer four practical questions: which date starts the new system, how much historic detail moves across, who owns each clean-up task, and what evidence stays accessible after the move.
Sage states that its conversion partner can move data from Pastel Xpress and Partner, QuickBooks Online and Desktop, and Xero into Sage Accounting. Its stated offer includes up to 24 months of converted data at no charge and a process of less than 48 hours, subject to the provider’s process. That conversion service does not remove the need to review opening balances, VAT codes or supporting documents.
The mistake we see most often is treating a data conversion as an accounting sign-off. A system can import every account code correctly while carrying forward unreconciled bank items, old customer credits or an incorrect VAT setting.
Protect SARS Records Before You Move
Cloud accounting improves access to records. It does not change the underlying obligation to keep them.
SARS requires taxpayers to retain tax records, including electronic records, for five years from the date they submit the relevant return. The records must remain in their original form, orderly, safe and available for SARS inspection. A PDF bank statement and an exported general ledger help, but they may not replace the original invoices, source documents and audit support that explain a transaction.
Failure to retain records as required can constitute a criminal offence, with a fine or imprisonment of up to two years on conviction. This is why we do not advise businesses to migrate opening balances only and then delete the old Pastel file or spreadsheet folders.
Keep an Archive That Someone Can Actually Use
Before cutover, create a controlled archive of the old system. It should include the final trial balance, detailed general ledger, customer and supplier age analyses, bank reconciliations, VAT201 working papers, invoices, bank statements and payroll journals relevant to the retention period.
Give the archive a named custodian and test it. Ask that person to find a February invoice, the related bank transaction and its ledger entry within a few minutes. If they cannot, the business has moved files without preserving an inspection trail.
If electronic tax records will sit outside South Africa, the taxpayer must seek SARS authorisation through the EFR001, Electronic Record Keeping Declaration. The question is not where the business accesses the software from. The question is where the electronic records are kept, so raise it with your tax adviser before selecting data storage arrangements.
Worked Example: A Spreadsheet Business With Missing Support
Take a Durban wholesaler with twelve staff, annual taxable supplies of about R2.8 million and a finance file maintained by two people. The business records sales in one workbook, supplier payments in another and keeps scanned invoices in personal email folders. At year-end, its accountant spends roughly 30 hours matching transactions, and several supplier claims lack clear supporting documents.
The business could move customer invoices, supplier bills, bank feeds and a cleaned chart of accounts into a cloud accounting platform from the first day of the next VAT period. It should retain the historic workbooks and source documents in a controlled archive because the new platform does not recreate the original evidence. If management did the project again, it would start document collection six weeks before cutover, rather than asking the bookkeeper to repair four years of records during month-end.
Configure VAT Before Posting Transactions
VAT configuration deserves director attention because a default tax code can affect every invoice and expense entry that follows. South Africa changed its VAT registration thresholds on 1 April 2026. Compulsory registration applies once taxable supplies exceed R2.3 million annually, while voluntary registration starts above R120,000 annually.
A business below R120,000 should not assume that VAT registration belongs in its accounting system simply because a template includes VAT codes. A business approaching R2.3 million needs a more deliberate review of its taxable supplies and registration position. The accounting platform should reflect the business’s actual VAT status, not the treatment used in an old spreadsheet.
VAT vendors use the VAT201 return. SARS requires filing and payment by the 25th after the end of the tax period, or by the last business day of that month when the vendor submits both the return and payment through SARS eFiling.
The practical step people skip is comparing the first cloud-generated VAT report against the last submitted VAT201 working paper. Do this line by line before you submit the first return from the new system. Investigate differences in zero-rated sales, exempt income, imported services, credit notes and timing before they become a SARS query.
Worked Example: Moving From Desktop Pastel
Take a Cape Town services company using desktop Pastel, with monthly turnover of about R450,000 and five users who email reports to one another. The company wants remote access and chooses a browser-based platform, but its first proposed plan transfers only a R180,000 opening bank balance and broad debtor and creditor totals. That approach would save time at the start, yet it would leave the finance team unable to explain individual balances when customers dispute invoices.
A stronger approach carries detailed open customer and supplier items into the new system, reconciles the bank to the cutover date and keeps the Pastel data and source records available for the statutory period. The company should budget for a review of its chart of accounts and opening balances, not only the technical import. If it repeated the project, it would appoint one internal decision-maker to approve account mappings, rather than allowing five users to make separate changes.
Build Controls Around the New Platform
Cloud access makes collaboration possible. It also creates a need for clear authority.
Under the Protection of Personal Information Act, 2013, known as POPIA, a business remains responsible for personal information processed by its cloud provider. The business must use reasonable security safeguards and have a written operator contract that requires the provider to maintain those safeguards.
For accounting data, that means deciding who can raise invoices, approve supplier bills, change bank details, post journals, view payroll data and export customer information. Do not give every user administrator access because it feels convenient during setup. Access should match the person’s role, and management should review it when staff leave or change responsibilities.
A bank feed also needs judgement. It imports transactions from the bank, but it does not prove that each entry has the right account code, VAT treatment or supporting document. Someone must review exceptions and complete bank reconciliations each month.
The First 30 Days Matter Most
We recommend a controlled first month after migration. Keep a checklist for daily invoice processing, weekly debtor reviews, month-end bank reconciliation and management reporting. Assign one person to record questions and recurring errors so the business can correct system settings once, rather than creating workarounds in new spreadsheets.
Management should review four items at the first month-end: the bank reconciliation, aged debtors, aged creditors and VAT report. Those reports reveal whether the new system reflects the commercial reality of the business.
What Our Cloud Accounting Migration Service Covers
M&J Consultants supports South African enterprises that need an orderly move from spreadsheets or desktop Pastel to cloud accounting. Our advisory work begins with the records, reporting needs and compliance position of the business, then sets a practical migration plan.
Our cloud accounting migration support can include:
● Reviewing the current bookkeeping process and identifying gaps in source records.
● Designing a chart of accounts that supports management reporting and tax compliance.
● Preparing opening balances, customer and supplier data for migration.
● Reviewing VAT settings against the business’s registration position.
● Establishing user roles, approval controls and document retention practices.
● Supporting the first reporting cycle after go-live.
The cost and timing depend on transaction volume, the quality of existing records, the number of historic periods required and the complexity of VAT treatment. We scope the work after reviewing the current system, because a two-user consultancy with clean records needs a different engagement from a trading business with years of unreconciled data.
If you need pastel accounting support Oudtshoorn or elsewhere in South Africa, confirm service availability, response times and the provider’s software status before relying on a local listing. Local proximity can help, but accounting expertise, clear accountability and a disciplined migration plan matter more.
Frequently Asked Questions
Is Sage 50cloud Pastel the same as cloud accounting?
No. Sage 50cloud Pastel is desktop accounting software with cloud-connected features. A browser-based cloud accounting platform works differently, so confirm the required remote access, reporting and user controls before choosing a solution.
Can we migrate from spreadsheets to cloud accounting mid-year?
Yes, but choose a cutover date that allows you to reconcile the bank, debtors, creditors and VAT position. Many businesses use the start of a VAT period or financial month because it creates a clearer control point, although the right date depends on record quality.
Do we still need old Pastel files after migration?
Yes. SARS requires tax records to remain available for five years from submission of the return. Keep the old data, source documents and reconciliation support in an orderly archive even when the new platform holds current transactions.
Does a bank feed complete the bank reconciliation?
No. A bank feed imports transactions. A responsible user still needs to check coding, VAT treatment, supporting documents and unmatched items before signing off the reconciliation.
A cloud platform should give your leadership team timely numbers without weakening tax records or governance. Speak With Our Team to scope your cloud accounting migration and accounting system setup in South Africa.
