Computerised accounting is a core skill for Central University of Technology (CUT) diploma students in Accounting and Financial Information Systems. Many CUT modules, including ACCY15AO Computerised Accounting, ACCF511 Accounting for Computerised Environments, and related practicals, require strong competence in Sage 50c / Pastel Partner. This exam-focused guide summarises the concepts, workflows, and exam-style tasks you are expected to master, with specific emphasis on the South African context and what commonly appears in CUT semester tests, practical assessments, and final exams.
1. Exam Context: CUT, South African Modules, and Common Requirements
1.1 Where Computerised Accounting Fits in CUT Diplomas
At the Central University of Technology (Bloemfontein and Welkom campuses), computerised accounting is integrated into several undergraduate diploma and higher certificate programmes in the Faculty of Management Sciences, including:
- Diploma in Accounting
- Diploma in Financial Information Systems
- Higher Certificate in Accounting / Financial Information Systems
- Advanced Diploma in Accounting
Typical CUT modules where Pastel / Sage-based content is examined include:
- ACCY15AO – Computerised Accounting 1A (often first-year, first semester)
- ACCY16BO – Computerised Accounting 1B
- ACCF511 – Accounting for Computerised Environments
- FSIF515 – Financial Information Systems Fundamentals
- ICT-Accounting Integration Practicals in certain diplomas
The key focus across these modules is:
- Understanding how accounting theory (as learnt in modules like ACCY11AO Financial Accounting 1) is implemented in a computerised environment.
- Becoming practically competent in Sage 50c / Pastel Partner to handle:
- Company setup
- Chart of accounts
- Customers and suppliers
- Inventory (if applicable)
- Journals and source documents
- VAT processing and returns
- Reporting and reconciliation
Exam questions often simulate a full accounting cycle for a small South African business using Pastel or Sage.
1.2 Other South African University Keywords and Relevance
While this guide is focused on CUT, similar content is covered in modules at other South African institutions, and these are often used as reference or self-study materials:
- UNISA:
- FAC1502 – Financial Accounting Principles, Concepts and Procedures
- FAC1503 – Financial Accounting for Law Practitioners
- FAC1601 – Financial Accounting Reporting
- CLPA2601 – Computerised Accounting Systems (some study packs link this to Sage)
- Tshwane University of Technology (TUT):
- ACC201T – Computerised Accounting
- University of Johannesburg (UJ):
- ACC1CFA – Computerised Financial Accounting
- Cape Peninsula University of Technology (CPUT):
- ACC116S – Computerised Accounting 1
Students often search for terms like:
- “Pastel Partner exam notes”
- “Sage 50c study notes UNISA”
- “CUT ACCY15AO Pastel assignment solutions”
- “computerised accounting memo Sage”
This guide is written using those common exam patterns and search behaviours to give you targeted preparation.
1.3 Typical Exam Structure in CUT Computerised Accounting
Past papers for modules such as ACCY15AO and ACCF511 at CUT show a blend of:
-
Theory / Conceptual Questions (20–40%):
- Compare manual vs computerised accounting systems.
- List advantages and disadvantages of Sage Pastel.
- Define key concepts: audit trail, source document, batch, period-end, etc.
- Explain how VAT is handled in Pastel.
-
Short Practical Questions (20–30%):
- Identify the correct module for a transaction (Customers vs Suppliers vs Cash Book).
- Classify accounts as control, detail, or system accounts.
- Record a small set of transactions by providing the correct menu paths.
-
Integrated Practical Case Study (30–50%):
- Given a trial balance and additional transactions, set up:
- Company details and accounting periods
- General ledger and VAT settings
- Capture:
- Customers and suppliers
- Inventory items (if the module includes inventory)
- Transactions for one or more periods
- Run reports:
- Trial Balance
- Customer / Supplier Age Analysis
- VAT Report
- Income Statement and Balance Sheet
- Given a trial balance and additional transactions, set up:
Assessment may be in a computer lab using Sage Pastel Partner or a similar variant (e.g., Sage 50c), with students required to save work in specific folders and print or export PDF reports.
1.4 Mark Allocation Patterns and Time Management
A common pattern in CUT computerised accounting exams:
| Question Type | Typical Marks | Time Guideline (3-hr exam) |
|---|---|---|
| Theory (definitions, comparisons) | 20–30 | 25–35 minutes |
| Short practical (menu navigation) | 20–30 | 25–35 minutes |
| Comprehensive Pastel practical | 50–60 | 80–110 minutes |
| Total | 100 | 180 minutes |
Time-management tips:
- Spend no more than 1 minute per theory mark.
- Keep at least 90 minutes for the main Pastel practical.
- In lab exams, save work after every major step:
- After company setup
- After creating master data
- After each batch of transactions
- Before running final reports
1.5 Skills and Outcomes Examiners Are Testing
Across CUT’s ACCY15AO and ACCF511 modules, exam outcomes are typically aligned to the following competencies:
- Understanding the role of computerised accounting in modern businesses in South Africa, especially SMEs using VAT, inventory, and basic payroll.
- Practical ability to operate Pastel / Sage:
- Setup and configuration
- Master data creation and editing
- Transaction processing and batch control
- Period-end procedures
- Accuracy in applying accounting principles:
- Debits and credits must still balance
- Correct VAT treatment per South African VAT Act
- Correct classification of accounts and modules
- Ability to interpret system-generated reports:
- Trial balance, income statement, balance sheet
- Age analyses to identify overdue accounts
- VAT reports for SARS submissions
- Internal control awareness:
- Importance of audit trails
- Passwords and user access levels
- Backup and data integrity
Understanding these outcomes guides what you should focus on while studying and practising.
2. Core Theory: Manual vs Computerised Accounting, Sage & Pastel Concepts
2.1 Manual vs Computerised Accounting Systems
In modules like ACCF511 at CUT, a favourite theory topic is comparing manual and computerised accounting. You must be ready to:
2.1.1 Manual Accounting Features
Manual accounting involves:
- Physical source documents (invoices, receipts, cheques)
- Journals written by hand
- Posting to ledger accounts in physical books
- Manual trial balance preparation
- Manual financial statements (income statement, balance sheet)
Advantages:
- Low initial cost for very small entities.
- Simple for extremely low volumes of transactions.
- No dependence on computers or electricity.
Disadvantages:
- Time-consuming and prone to human error (calculation mistakes).
- Difficult to update or correct errors (erasures, rewriting pages).
- Limited reporting capabilities.
- Inadequate for audit trail and internal control in medium/large entities.
2.1.2 Computerised Accounting Features
Computerised accounting, as implemented in Sage 50c / Pastel Partner, involves:
- Entering transactions directly into software modules.
- Automatic posting to General Ledger (GL) accounts.
- Instant recalculation of balances.
- Ability to generate multiple types of reports quickly.
- Built-in checks (e.g., no unbalanced journals).
Advantages:
- Speed: High volume processing.
- Accuracy: Automatic arithmetic and posting.
- Reporting: Customisable, real-time financial reports.
- Audit trail: System logs, batch controls, and user access logs.
- Scalability: Can handle more transactions and users.
Disadvantages:
- Initial cost of software licences and training.
- Dependency on hardware, electricity, and sometimes internet.
- Risk of data loss if backups and security are poor.
- Potential for sophisticated fraud if user controls are weak.
Exam answers should not be generic; explicitly mention Pastel / Sage and South African SMEs where appropriate.
2.2 Sage 50c vs Pastel Partner vs Sage Pastel Xpress
In South Africa, the term “Pastel” is often still used even when the product brand is officially Sage 50c Pastel Partner. For exam purposes at CUT:
-
Sage 50c / Pastel Partner:
- Full-featured package.
- Used in most tertiary institutions for training.
- Supports multi-user and multi-company, inventory, and VAT.
-
Sage Pastel Xpress:
- Simplified version.
- Some TVET colleges and small businesses use this.
You must be comfortable referring to:
- “Pastel Partner” as the main training environment.
- “Sage 50c” when exam questions reference newer branding.
The key interface and processes remain essentially the same in exam scenarios.
2.3 Key Concepts and Definitions (Frequently Examined)
Know these terms thoroughly; they often form short questions of 2–5 marks.
-
General Ledger (GL):
- The central set of accounts summarising all financial transactions.
- In Pastel, GL accounts have unique account numbers and are used in all modules.
-
Subsidiary Ledger:
- Detailed ledger for specific types of accounts, e.g. Customers, Suppliers, Inventory.
- The total of each subsidiary ledger is represented in the GL by a control account.
-
Control Account:
- GL account that summarises balances of a subsidiary ledger.
- Examples:
- Accounts Receivable Control = total of all customer balances.
- Accounts Payable Control = total of all supplier balances.
- Must always reconcile with the subsidiary ledger.
-
Batch:
- A group of transactions entered but not yet updated to the General Ledger.
- Pastel allows batches in various modules (e.g., Journal Batch in GL).
- You can edit transactions until the batch is updated (posted).
-
Audit Trail:
- A log that records all changes, entries, and updates in the system.
- Essential for internal control and audit purposes.
- Pastel’s audit trail report shows, for example, user, date, time, and transaction details.
-
Period / Accounting Period:
- A division of the financial year (usually 12 months).
- In Pastel, periods must be set up correctly when creating a company.
-
Source Document:
- Original document recording a transaction (e.g., invoice, receipt, purchase order).
- In computerised accounting, you must know which transaction type corresponds to each.
-
VAT (Value-Added Tax):
- South African consumption tax currently at the 15% standard rate.
- Pastel handles VAT automatically when properly configured.
2.4 VAT Handling in Sage / Pastel (Very Common Exam Area)
For CUT and broader South African context, VAT is crucial:
- Current standard rate: 15%.
- Some goods/services at 0% (zero-rated) or exempt.
- Entities registered for VAT must:
- Charge VAT on taxable supplies (Output VAT).
- Claim VAT on business purchases (Input VAT).
- Submit VAT201 returns (usually every 2 months).
In Pastel:
-
VAT Types:
- Define different VAT rates and categories, such as:
- 01 – Output VAT 15%
- 02 – Input VAT 15%
- 03 – Zero-rated
- 04 – Exempt
- Exams may give you a VAT type table you must interpret.
- Define different VAT rates and categories, such as:
-
VAT Control Account:
- GL account where net VAT (Output – Input) is accumulated.
- At period-end, the VAT amount due or refundable is calculated.
-
Common Pastel VAT Exam Tasks:
- Setting up VAT percentages and control accounts.
- Allocating proper VAT types to:
- Customers (usually standard 15% output).
- Suppliers (usually standard 15% input, where applicable).
- Inventory items (depending on whether items are standard rated).
- Explaining why some items use zero-rated or exempt codes.
Example: VAT Journal Entry in Pastel
A credit sale of R11,500 including 15% VAT:
- Selling price excluding VAT = R10,000
- VAT = R1,500
Pastel processing (in GL terms):
- Debit: Accounts Receivable (Customer Control) R11,500
- Credit: Sales Income R10,000
- Credit: Output VAT (VAT Control) R1,500
Examiners will test whether you understand this split, even if the software calculates it automatically.
2.5 Internal Control, Security, and Backups
Conceptual questions may test your understanding of how a computerised system improves or threatens internal control.
Key points:
-
User IDs and Passwords:
- Each user should have a unique ID.
- Different user roles (e.g., data capturer, supervisor, accountant) with appropriate access rights.
-
Segregation of Duties:
- Avoid one person controlling all parts of a transaction.
- Example:
- Person A captures supplier invoices.
- Person B authorises payment.
- Person C performs bank reconciliation.
-
Data Backups:
- Perform regular backups to external drives or secure cloud.
- Test backup restoration periodically.
- In an exam theory question, mention:
- Daily incremental backups.
- Weekly full backups.
- Off-site backup storage.
-
Audit Trails and Logs:
- Pastel’s audit trail should not be disabled.
- Changes to transactions after posting should be strictly controlled.
Examiners at CUT may use scenario questions:
“Explain how Sage Pastel can assist in preventing and detecting fraud in a small business. Mention at least four features.”
Your answer should mention user access levels, audit trails, password policies, and system-generated reports used for review and reconciliation.
3. Company Setup and Master Data in Sage Pastel (ACCY15AO Practical Focus)
3.1 Creating a New Company in Pastel
Practical exams often give you:
- A company name, e.g., Mangaung Traders (Pty) Ltd
- Financial year dates (e.g., 1 March 2025 to 28 February 2026)
- VAT registration status
- Currency (South African Rand – ZAR)
You must then set up a new company in Pastel.
3.1.1 Basic Steps (Typical Exam-Style Answer):
- Open Pastel Partner.
- From the main menu, select:
File→New→Company. - Choose a folder location (as specified in the exam paper), e.g.:
C:\ACCY15AO\StudentNumber\MangaungTraders. - Enter company details, including:
- Company Name: Mangaung Traders (Pty) Ltd
- Financial Year Start Date: 01/03/2025
- Number of Periods: 12
- Indicate whether the company is VAT registered and set:
- VAT type defaults.
- VAT number (if given).
- Complete any wizard options for:
- Chart of accounts template (choose one similar to a trading company if allowed).
- Inventory, customers, and suppliers.
Exams might ask:
“List the steps to create a new company in Sage Pastel and specify the menu paths required.”
Respond with a clear, ordered list as above.
3.2 Setting Up the Chart of Accounts
The Chart of Accounts is the backbone of your system. CUT exams often give you either:
- A pre-defined chart and you must add missing accounts, or
- A list of accounts and numbers that you must create in Pastel.
Common GL account categories:
- Assets (1xxx): e.g., Bank, Debtors Control, Inventory.
- Equity (3xxx): e.g., Capital, Retained Earnings.
- Income (4xxx): e.g., Sales, Services Income.
- Expenses (5xxx–7xxx): e.g., Rent, Wages, Telephone.
3.2.1 Creating GL Accounts in Pastel
Menu path:
Edit→General Ledger→Accounts
For each account, you will enter:
- Account Number (e.g., 1000 for Bank)
- Description (e.g., “Bank – FNB Cheque Account”)
- Category / Group (e.g., Current Asset, Expense)
Exam tip: If the assignment tells you to use specific account numbers (e.g., 1100 for “Debtors Control”), your marks depend on exact accuracy.
3.2.2 Control Accounts and System Accounts
You must correctly mark:
- Control Accounts:
- Debtors (Accounts Receivable) Control
- Creditors (Accounts Payable) Control
- Inventory / Stock Control (if applicable)
- System Accounts:
- Retained Earnings
- VAT Control
- Rounding and system adjustment accounts
Examiners often test whether you:
- Can identify which GL accounts should be control accounts.
- Can explain why control accounts must not be used for direct postings in some cases.
3.3 Creating Customers and Suppliers (Master Files)
In a second part of the practical, you are usually given:
- Customer list (Customer Code, Name, Address, VAT number, Terms).
- Supplier list (Supplier Code, Name, Address, VAT number, Terms, maybe Opening Balance).
3.3.1 Creating Customers
Menu path:
Edit→Customers→Accounts
Fields commonly required:
- Account Code: e.g., “CUST001”
- Name: “Bloem Furniture CC”
- Contact Details: Address, Telephone, Email
- Terms: e.g., 30 days from statement
- Credit Limit: e.g., R50,000
- VAT status: VAT Vendor, with VAT number
- Default Tax Type: typically Output VAT @ 15%
Exam tasks:
- You may need to capture 5–10 customers.
- Marks are typically awarded for:
- Correct account code
- Correct name and VAT settings
- Correct terms and credit limits
3.3.2 Creating Suppliers
Menu path:
Edit→Suppliers→Accounts
Fields similar to customers but relating to suppliers:
- Account Code: e.g., “SUPP001”
- Name: “Welkom Office Supplies”
- Terms: 30 days from statement
- VAT number (if supplier is VAT registered)
- Default Tax Type (Input VAT @ 15% for applicable items)
Examiners may ask:
“Differentiate between a customer and a supplier account in Sage Pastel and highlight three fields that are mandatory for each.”
You can answer by listing relevant fields and items such as account code, name, and VAT status.
3.4 Inventory / Stock Items (Where Applicable)
In some CUT modules, especially in second-year levels, Pastel inventory is tested.
Menu path:
Edit→Inventory→Item File
Fields:
- Item Code: e.g., “STK001”
- Description: “A4 Copier Paper 500 sheets”
- Cost Price
- Selling Price (inclusive or exclusive of VAT depending on setup)
- VAT Type
- Unit (e.g., “Ream”)
Examiners can test:
- Knowledge of periodic vs perpetual inventory systems.
- How inventory interacts with the General Ledger via control accounts.
Example: Inventory Item Setup
For “A4 Copier Paper”:
- Item Code: PAP001
- Description: A4 Copier Paper 500 Sheets
- Cost Price: R50.00
- Selling Price: R80.00
- VAT Type: Standard Rated 15%
- Inventory Control Account: 1400 – Inventory
- Cost of Sales Account: 5000 – Cost of Sales
Every sale of PAP001 through the Customers module will:
- Increase Sales (Income) and Output VAT.
- Decrease Inventory and increase Cost of Sales, depending on inventory configuration.
3.5 Opening Balances
Exams commonly include a Trial Balance at a certain date (e.g., 1 March 2025) that you must use to enter opening balances into Pastel.
3.5.1 General Ledger Opening Balances
Menu path:
Process→Journals→General Journalor a specific “Opening Balances” routine depending on the version.
Steps:
- Enter a journal with all GL account opening balances.
- Ensure that the total debits equal total credits.
- Use a suspense account temporarily if required.
3.5.2 Customer and Supplier Opening Balances
For customers and suppliers, opening balances are best entered through their respective modules (to maintain subsidiary ledger detail):
Process→Customers→Journal.Process→Suppliers→Journal.
You allocate:
- Debit Customer account for opening balances.
- Credit Supplier account for amounts owed.
Examiners may test whether you know why you should avoid opening balances directly in GL for customers and suppliers (because it breaks reconciliation with subsidiary ledgers).
4. Transaction Processing: Journals, Batches, and Source Documents in Pastel
4.1 Understanding the Accounting Cycle in a Computerised Environment
A typical accounting cycle for CUT practical cases:
- Setup company and master data.
- Enter opening balances.
- Capture daily transactions:
- Customer invoices and receipts.
- Supplier invoices and payments.
- Cash receipts and payments.
- General journal entries.
- Update batches to the GL.
- Perform month-end and year-end procedures.
- Generate financial reports and VAT returns.
- Reconcile control accounts and fix errors if any.
Exams simulate a part of this cycle, usually focusing on step 3 and 6.
4.2 Source Documents and Corresponding Pastel Modules
You must be able to map source documents to the correct module:
| Source Document | Module in Pastel | Example Transaction |
|---|---|---|
| Sales invoice | Customers → Process | Credit sale to a customer |
| Credit note (customer) | Customers → Process Credit | Goods returned by a customer |
| Purchase invoice | Suppliers → Process | Credit purchase from supplier |
| Supplier credit note | Suppliers → Process Credit | Returned goods to supplier |
| Cash receipt | Cash Book / Customers | Cash sale, receipt from debtor |
| Cash payment | Cash Book / Suppliers | Payment to supplier, expenses in cash |
| Journal voucher | General Journal | Adjusting entries, depreciation, corrections |
Exam questions may present a list of documents and ask you to:
- Indicate which Pastel module to use.
- State whether it increases or decreases customer/supplier balance.
- Indicate the effect on assets, liabilities, or equity.
4.3 Customers Module: Processing Invoices and Receipts
4.3.1 Processing Credit Sales (Invoices)
Menu path:
Process→Customers→Processing
Steps to record a sale on credit:
- Select the correct customer account.
- Choose transaction type: Invoice.
- Enter:
- Date of sale
- Invoice number (the system may auto-generate)
- Reference (e.g., “Sale of stock”)
- Select inventory items or GL accounts:
- If inventory is used, choose item code and quantity.
- Pastel automatically calculates unit price, total, and VAT.
- Confirm VAT type and ensure the total is correct.
- Save the transaction in the batch.
- Update the batch when all invoices are captured.
Exam-style question example:
“Record a credit sale to customer CUST002 for 10 units of item PAP001 at the default selling price. Standard VAT of 15% applies. Show the Pastel menu path and explain which accounts are debited and credited.”
Your answer must mention:
- Path:
Process → Customers → Processing - Debits: Customer (Accounts Receivable)
- Credits: Sales (Income) and Output VAT
4.3.2 Processing Customer Receipts (Payments Received)
Menu path:
Process→Cash Book(Receipts)
orProcess→Customers→Receipts(depending on version)
Steps:
- Select bank account (e.g., Bank – FNB).
- Choose customer and open invoice.
- Enter:
- Date
- Amount received
- Payment reference (e.g., EFT, receipt number)
- Allocate the payment to specific invoice(s).
- Save and update batch.
Exam tasks may involve:
- Partially paid invoices.
- Overpayments (to be recorded as customer credits).
4.4 Suppliers Module: Processing Purchases and Payments
4.4.1 Processing Purchase Invoices (Credit Purchases)
Menu path:
Process→Suppliers→Processing
Steps:
- Select supplier account.
- Choose transaction type: Invoice.
- Enter:
- Date
- Supplier invoice number
- Reference (e.g., “Purchase inventory”)
- Choose:
- Inventory items (increases stock), or
- GL expense accounts (e.g., “Stationery Expense”).
- Confirm VAT type (Input VAT 15%).
- Save the invoice to the batch and update.
Exam tasks may require:
- Differentiating between inventory purchases (Capitalise to stock) and expense purchases (e.g., electricity, rent).
4.4.2 Supplier Payments
Menu path:
Process→Cash Book(Payments)
orProcess→Suppliers→Payments
Steps:
- Select the bank account.
- Select supplier.
- Allocate payment to outstanding invoice(s).
- Enter date, amount, and reference (e.g., “EFT 12345”).
- Save and update batch.
Examiners often include questions relating to:
- Early settlement discounts.
- Part payments.
- Handling payment of multiple invoices in one transaction.
4.5 Cash Book: Receipts and Payments (Cash / Bank Transactions)
The Cash Book module is critical and frequently examined.
Common cash transactions:
- Cash sales (no customer account).
- Payment of expenses (rent, wages, utilities).
- Bank charges and interest.
- Transfers between bank accounts or between bank and petty cash.
4.5.1 Processing Cash Receipts (Non-Credit Sales)
Menu path:
Process→Cash Book→ Select Bank →Receipts
Example exam case:
Cash sale of R1,150 including VAT at 15% on 5 April 2025, receipt number CR001.
Steps:
- Open cash receipts for the bank.
- Enter:
- Date: 05/04/2025
- Reference: CR001
- Select the Sales GL account.
- Enter the amount inclusive of VAT (R1,150).
- Ensure the VAT type is Standard 15%.
- Save and update.
Pastel will split R1,150 into:
- Sales (R1,000)
- Output VAT (R150)
- Bank (R1,150)
4.5.2 Processing Cash Payments (Expenses and Other Outflows)
Menu path:
Process→Cash Book→ Select Bank →Payments
Example exam case:
Pay rent of R8,000 (VAT exempt) on 30 April 2025, cheque number CP001.
Steps:
- Open cash payments for bank.
- Enter:
- Date: 30/04/2025
- Reference: CP001
- Select Rent Expense GL account.
- Enter amount: R8,000.
- VAT type: Exempt or 0% (depending on chart).
- Save and update.
Resulting entry:
- Debit: Rent Expense R8,000
- Credit: Bank R8,000
4.6 General Journal Entries
Some transactions don’t originate from customers, suppliers, or cash book modules. These include:
- Depreciation
- Bad debt write-offs
- Accruals and prepayments
- Correction of certain errors
Menu path:
Process→Journals→General Journal
Example exam scenario:
On 28 February 2026, record monthly depreciation of R2,000 on office equipment.
Steps:
- Open General Journals.
- Date: 28/02/2026
- Reference: “Depn Feb”
- Line 1:
- Debit Depreciation Expense R2,000
- Line 2:
- Credit Accumulated Depreciation – Office Equipment R2,000
- Ensure debits = credits.
- Save and update.
Examiners may also ask you to:
- Explain why depreciation is done via the General Journal and not the Cash Book (no cash involved).
4.7 Batches, Updating, and Error Correction
Understanding batch behaviour is essential for both theory and practical.
-
Capture Stage:
- Transactions are entered into a batch.
- You can still edit or delete entries during this stage.
- Examiners might test your understanding of temporary vs permanent records.
-
Update Stage:
- When you “Update” a batch, Pastel posts all entries to the GL.
- At this point, some versions do not allow easy deletion; instead, you might need a reversing journal.
-
Error Handling:
- If a captured invoice has the wrong amount but is still in an unposted batch: simply edit it.
- If you discover an error after updating:
- Pass a correcting journal entry.
- Or process a credit note / reversing entry, depending on transaction type.
Exam questions often ask:
“Explain the difference between editing a transaction in an open batch and correcting a posted transaction in Sage Pastel.”
You must describe that:
- Open batch: direct editing.
- Posted transaction: reversal or additional journal entries, ensuring the audit trail remains intact.
5. Reporting, Reconciliation, and Exam Strategy for CUT Computerised Accounting
5.1 Essential Reports in Sage Pastel and Their Exam Relevance
CUT exams require you not only to capture transactions but also to generate and interpret key reports:
- Trial Balance
- Income Statement (Statement of Profit or Loss)
- Balance Sheet (Statement of Financial Position)
- Customer Age Analysis
- Supplier Age Analysis
- VAT Report
- Audit Trail
Knowing how to run each report, interpret its contents, and check for errors is vital.
5.1.1 Trial Balance
Menu path:
View→General Ledger→Trial Balance
The trial balance lists all GL accounts with their debit or credit balances at a specific date. The total debits must equal total credits.
Exam tasks:
- Print or export trial balance as at a given date.
- Use it to verify that all transactions are posted.
- Spot missing accounts or incorrect balances.
Examiners may ask conceptual questions:
“Explain the purpose of a trial balance in a computerised accounting system like Sage Pastel. Why is it still necessary if the software enforces double-entry?”
Expected points in your answer:
- To detect errors of omission or misclassification.
- To provide a summary before financial statement preparation.
- As an audit checkpoint.
5.1.2 Income Statement and Balance Sheet
Menu path:
View→General Ledger→Income StatementView→General Ledger→Balance Sheet
These reports are generated automatically from the trial balance.
Exam tasks:
- Produce the income statement for the year ending on a specific date.
- Produce the balance sheet on that same date.
- Use these statements to answer short theory questions about profitability and financial position.
Example exam question:
“Based on the income statement generated in Sage Pastel, comment briefly on Mangaung Traders’ profitability for the year. Mention at least two indicators.”
Candidates must be able to interpret elements such as gross profit, net profit, and expense ratios.
5.2 Customer and Supplier Age Analysis
Age analyses are key tools for credit control and often appear in exam questions:
5.2.1 Customer Age Analysis
Menu path:
View→Customers→Age Analysis
Purpose:
- Shows outstanding balances for each customer segmented into ageing buckets:
- Current
- 30 days
- 60 days
- 90 days and over
Exam tasks:
- Generate customer age analysis as at month-end.
- Identify customers with balances older than 90 days.
- Suggest actions to manage overdue accounts (e.g., reminders, stop supply, legal action).
5.2.2 Supplier Age Analysis
Menu path:
View→Suppliers→Age Analysis
Similar to customer age analysis but from the point of view of what the business owes.
Exam scenario:
“Print the supplier age analysis as at 30 April 2025 for New Dawn Retailers. Identify the supplier with the highest overdue balance and the amount overdue.”
You must understand how to read the report and extract information quickly.
5.3 VAT Report and SARS Compliance
The VAT Report is essential for preparing VAT201 returns.
Menu path:
View→General Ledger→VAT Report(exact path may vary by version)
Tasks:
- Generate VAT report for a specified period (e.g., March–April 2025).
- Identify:
- Total Output VAT
- Total Input VAT
- Net amount payable to or receivable from SARS
Exam questions may ask:
“Explain how the VAT report generated by Sage Pastel assists a VAT-registered business in complying with SARS requirements.”
Include points about:
- Summarising VAT by categories.
- Reducing arithmetic and classification errors.
- Providing an audit trail supporting VAT claims.
5.4 Reconciliation and Error Checking
Reconciliation is one of the most common topics combining both theory and practical skills.
5.4.1 Debtors and Creditors Reconciliation
For customers (debtors):
- Total of all customer balances (from age analysis) should equal the Debtors Control account balance in GL.
- If there is a difference, investigate:
- Direct postings to Debtors Control (instead of through customers module).
- Transactions captured in customer ledger but not updated to GL.
- Wrong dates or misallocations.
For suppliers (creditors):
- Same logic with Suppliers Age Analysis vs Creditors Control GL account.
Exam scenario:
“The balance of the Debtors Control account in the General Ledger is R120,000, but the total of the Customer Age Analysis is R118,000. Give three possible reasons for the difference.”
Possible answer points:
- Direct journal postings to Debtors Control.
- An updated customer batch not yet posted to GL or vice versa.
- A customer ledger transaction dated in a different period.
5.4.2 Bank Reconciliation
While detailed bank reconciliations may be covered more in other modules, Pastel provides tools to assist.
Key concepts:
- Bank balance per GL vs bank statement balance.
- Timing differences: outstanding cheques, deposits not yet reflected.
- Errors in capturing amounts or dates.
Examiners may combine manual bank recon knowledge with Pastel concepts:
“Explain how Sage Pastel’s bank reconciliation functionality supports accurate cash management and reduces the risk of fraud.”
Highlight features like:
- Matching transactions with bank statement entries.
- Flagging unmatched transactions.
- Generating reconciliation reports.
5.5 Exam Strategy and Study Techniques for CUT Computerised Accounting (ACCY15AO / ACCF511)
5.5.1 Balancing Theory and Practical Preparation
Many students focus only on the Pastel practical and lose marks on theory. A balanced strategy:
- Allocate 50–60% of study time to practising in Pastel.
- Allocate 40–50% to theory:
- Definitions
- Comparisons (manual vs computerised accounting)
- Internal control concepts
- VAT theory
- Interpreting reports
Use past papers labelled ACCY15AO and ACCF511 from the CUT library or departmental LMS to identify frequently repeated theory questions.
5.5.2 Building Practical Speed and Accuracy
Practise full case studies:
- Start with company creation and chart of accounts.
- Capture master data (customers, suppliers, items).
- Process 30–50 mixed transactions.
- Run full sets of reports (TB, income statement, balance sheet, age analysis, VAT).
Time yourself:
- Try to complete a full cycle within 90–120 minutes.
- Aim to reduce errors by careful reading and double-checking.
5.5.3 Common Mistakes to Avoid in Practical Exams
-
Incorrect Dates:
- Many mistakes come from capturing transactions in the wrong period.
- Always check the system date and transaction date.
-
Wrong VAT Types:
- Using standard 15% when the transaction is zero-rated or exempt.
- This leads to wrong VAT report figures and marks lost.
-
Direct Posting to Control Accounts:
- Debtors and Creditors Control should be updated via customers and suppliers modules, not through general journals (except in certain controlled opening balance situations).
-
Not Updating Batches:
- Students sometimes forget to update their batches and then wonder why their trial balance has missing entries.
-
Incorrect Account Selection:
- For example, posting rent to “Repairs and Maintenance” instead of “Rent Expense”.
- Always read the chart of accounts and exam instructions carefully.
5.5.4 How to Answer Theory Questions for Maximum Marks
When answering theory questions in ACCY15AO or ACCF511:
- Use clear definitions, including references to Sage / Pastel and South African context.
- Structure answers with:
- Bullet lists for advantages/disadvantages.
- Short paragraphs for explanations.
- Where relevant, give pastel-specific examples, e.g.:
- “In Sage Pastel, the audit trail report logs…”
Example: “Discuss three advantages of using a computerised accounting package like Sage Pastel for a small VAT-registered trading business in South Africa.”
Model outline:
-
Speed and Efficiency:
- Point: High-volume transaction processing.
- Example: Capturing hundreds of sales invoices per day with automatic VAT calculations.
-
Accuracy and Reduced Errors:
- Point: Automated double-entry and VAT computations.
- Example: Preventing unbalanced journal entries and calculation mistakes.
-
Improved Reporting and Compliance:
- Point: Real-time financial statements and VAT reports.
- Example: Generating VAT201 support reports for SARS quickly and accurately.
Providing at least one concrete example per bullet often earns full marks.
5.5.5 Using Other South African Study Resources While Staying CUT-Focused
Many CUT students supplement their learning with study guides labelled:
- “UNISA CLPA2601 computerised accounting notes”
- “Pastel Partner tutorial exercises CPUT ACC116S”
- “TUT ACC201T Sage practical workbook”
While these are valuable, ensure that:
- You map content back to your CUT module outcomes (especially ACCY15AO and ACCF511).
- You practise exact menu paths and software versions that CUT uses in the labs.
- You adjust for differences in:
- VAT rates if any historical content uses older rates.
- South African vs international fiscal year dates.
By integrating strong command of accounting principles with hands-on Sage Pastel skills, CUT students in modules like ACCY15AO Computerised Accounting and ACCF511 Accounting for Computerised Environments can approach tests and exams with confidence. Focus on mastering company setup, accurate transaction processing, VAT handling, and report interpretation, while also being ready to explain the underlying theory and internal control implications of computerised accounting in the South African SME environment.
