AIN2601 Assignment 6 PORTFOLIO (ANSWERS) 2026 - DISTINCTION GUARANTEED

Comprehensively structured AIN2601 Assignment 6 PORTFOLIO (ANSWERS) 2026 - DISTINCTION GUARANTEED - DISTINCTION GUARANTEED. Prepared to a distinction standard with detailed and well-developed responses. Task 1: Use the Setup Assistant to create ProPrint Solutions SA (PPS) on Pastel Partner. 1.1 Use the following information (use the default information provided, unless specific information is given): • Postal address: 45 Mofolo Crescent, Midrand, Johannesburg, 1685. • Date sequence: DMY, with four digits per year, confirm that the Sample Date format is correct i.e. dd/mm/yyyy. • Start date of financial year (current financial year): 01/05/2026, with each period ending on the last day of the month. PPS uses one period for each month of the year. In this assignment period x of 2026 will refer to the xth period falling within the 2026 financial year which ends on 30/04/2026 (previous financial year) and period x of 2027 will refer to the xth period falling within the 2027 financial year which ends on 30/04/2027 (current financial year). • Use the Generic Chart of Accounts as the standard chart of accounts for PPS. • PPS has a current account at NEDBANK . They also use a Petty Cash account to pay for smaller, ad-hoc expenses. • PPS has two price lists – ‘Wholesale’ and ‘Retail’. Wholesale (i.e businesses who buy wholesale for resale purposes, schools and NGO’s) are charged the ‘Wholesale’ prices provided their purchasing volume is sufficient to warrant the lower prices. The ‘Retail’ price list is to be used for all other customers unless the ‘Wholesale’ prices have specifically been authorised by the accountant. Sales volume for both price lists are quite high but of late PPS sells more to Wholesale. • The default terms for customers are 30 days and the customer accounts are prepared using open item processing. • PPS uses a fast laser printer for printing all their business documents and correspondence on plain paper. (Before you continue, please ensure that the virtual and/or physical printer you are using is set to A4 paper size. Refer to Pastel Manual Lesson 1 for instructions) Task 2: User security 2.1 Use the following information to create the supervisor’s user account name and password: • Do not Force strong password. • User nr 0 o User Name: Thabiso o Password: Wholesale o Email address: o Security question: Which module am I busy with? o Security answer: AIN2601 Task 3: Edit the Chart of Accounts. 3.1 View the Trial Balance to familiarise yourself with the various general ledger accounts available in the Generic Chart of Accounts you have selected during setup. 3.2 Edit the following general ledger accounts, by setting the Tax processing to VAT – Standard rated (15%): Main account number Description 1000 Sales 2000 Cost of Sales / Purchases AIN2601/Assessment 6 /2026/S1 16 3.3 Add the following general ledger accounts: NB! Type your own student number in after “Sales – Printers” as well as “Maintenance Equipment” – Net value” account description (where the “xxxxxxxx” is indicated). If the documents/printouts required later do not reflect your own student number where required, you will receive zero percent (0%) for your whole assignment! Main account number Sub-account number Description Financial category Report writer category 1000 100 Sales – Printers (xxxxxxxx) 1000 200 Sales – Printer Consumables 1000 300 Sales – Accessories 1000 400 Sales – Installation&Maint 2000 100 Cost of Sales – Printers 2000 200 Cost of Sales – Printer Consumables 2000 300 Cost of Sales - Accessories 7700 100 Inventory – Printers 7700 200 Inventory – Printer Consumables 7700 300 Inventory- Accessories 5100 000 Share capital Share Capital Share Capital 6500 000 Maintenance Equipment-–-Net-value xxxxxxxx Fixed assets FA - Other assets 1 6500 010 Maintenance @ Cost Fixed assets FA - Other assets 1 6500 020 Maintenance Equipment-–-Accum Depreciation Fixed assets FA - Other assets 1 8450 000 Inter Bank Transfers (when asked “Would you like to create Cash Book 03”– select “No”) Bank Bank . Task 4: Setup the Company parameters. 4.1 If you are using the Educational Pastel version, Pastel has automatically changed your company name (ProPrint Solutions SA (Pty) Ltd) to “Educational No: Sage Pastel” to prevent misuse. This is fine – do not worry! However, we need to know that your Pastel assignment was your own work, therefore, you must change the name again to reflect your student number (all students need to do this, regardless of whether they are working on the full or educational software). Do the following: If you are working on the Educational software: • Select Setup – Company Parameters from the main menu • Click inside the Company Details - Name field; • Simultaneously press Ctrl-Shift-T; • Enter “PPS” and your own student number, then click OK; • The company name should now display as follows: “Educational No: PPS xxxxxxxx” (where xxxxxxxx will reflect your own student number). • Click inside the Company Details – Trading Name field; AIN2601/Assessment 6 /2026/1 17 • Enter PPS and your own student number • The Trading name should now display as follows: PPS xxxxxxxx” (where xxxxxxxx will reflect your own student number). • Please note that if you are using another version of Pastel you will not have the option to insert a Trading name – that is fine. If you are working on the full version of Pastel Partner: • Select Setup – Company Parameters from the main menu • Click inside the Company Details - Name field; • Enter “” PPS and your own student number, then click OK; • The company name should now display as follows: • “PPS xxxxxxxx” (where xxxxxxxx will reflect your own student number). • Click inside the Company Details – Trading Name field; • Enter “PPS” and your own student number • The Trading name should now display as follows: PPS xxxxxx” (where xxxxxxxx will reflect your own student number). • Please note that if you are using another version of Pastel you’ll will not have the option to insert a Trading name – that is fine. NB!!! If ALL the required Pastel printouts do not reflect your own student number next to the company’s name, you will receive zero percent (0%) for your assignment! 4.2 Use the following information: • Contact name: Thabiso • Contact surname: Mokoena • E-mail: • Telephone 1: • VAT Registration number: – You will receive an error message “VAT registration number is invalid. Please ensure you have entered the number correctly.” This happens because Pastel has a built in VAT registration number validation process to ensure only valid VAT numbers are entered. • You are welcome to leave this field blank for assignment purposes, alternatively make use of an existing company’s VAT number which can be found on a till slip or the internet. You will note that Pastel will accept this VAT number, as it is a valid registered number. 4.3 PPS uses only one set of Document numbers for their company and they have decided to start the new financial year with the default Pastel document numbers. 4.4 Enter the Inter Bank Transfers account as the Cash Books Transfer Account. 4.5 Make a backup of PPS Pastel Company in a new folder named “PPS parameters”. Save a copy of this backup on an external memory device. AIN2601/Assessment 6 /2026/S1 18 Task 5: Setup the users, entry types and tax Users: EA has four people working in their accounts department. Separate functions are allocated to each of the four people on Pastel to ensure segregation of duties. 5.1 Setup the users listed below with the access rights as indicated: Designation Accountant Sales clerk Purchases clerk Cashbook clerk User nr 00 01 02 03 User Name Thabiso Naledi Koos Vishay Password Wholesale sales purchases cash The above-mentioned passwords are case sensitive so please type it carefully Email User Group Supervisor Personalised Personalised Personalised Select: Copy from Group N/A Update batches No update of batches No update of batches You can only adjust the Menu access and Processing options for each user as instructed below after copying from the above-mentioned group (that means you need to click on “Copy from Group” after selecting from the drop down menu). When copying from a group you will be asked if you want to overwrite the user - select yes. Menu Access All. Keep options as automatically selected. Update the Edit menu as follow: • Only Customers must be selected. • All other options under the Edit menu must be deselected. Update the Process menu as follow: • Only Customers and Match open item must be selected. • All other options under the Process menu must be deselected. Keep all other Menu options as is. Update the Edit menu as follow: • Only Suppliers must be selected. • All other options under the Edit menu must be deselected. Update the Process menu as follow: • Only Suppliers and Match open item must be selected. • All other options under the Process menu must be deselected. Keep all other Menu options as is. Update the Edit menu as follow: • Deselect all options under the Edit menu. Update the Process menu as follow: • Only Cashbook; Bank Reconciliation; Match open item and all options under Receipts must be selected. • All other options under the Process menu must be deselected. Keep all other Menu options as is. AIN2601/Assessment 6 /2026/1 19 Accountant Sales clerk Purchases clerk Cashbook clerk User Name 00 – Thabiso 01 - Naledi 02 - Koos 03 - Vishay Process options All. Keep options as automatically selected. General ledger: Only select: • Multi Period Processing • Can change transaction date • Can update batches • Can delete batches Customers: Keep all the current options selected as is. Additionally, also select the following: • Change discounts while processing. • Can delete documents. • Can process invoices if customer is overdue. Deselect the following: • Can exceed credit limit. Suppliers: Deselect all options. Inventory: Deselect all options General ledger: Only select: • Multi Period Processing • Can change transaction date • Can delete batches Customers: Deselect all options. Suppliers: Keep all the current options selected as is. Additionally, also select the following: • Can delete documents. Inventory: Deselect all options. General ledger: Keep all the current options selected as is. Additionally, also select the following: • Can process bank transfers. • Can change transaction date • Multi Period Processing Customers: Deselect all options Suppliers: Deselect all options. Inventory: Deselect all options. When you return to a user already created you will note that the “Copy from Group” selection reflects as “Supervisor”. This is fine – do not worry! The selections you have made for each user has not disappeared therefore please do not click on “Copy from Group” again. Pastel changes the dropdown list back to “Supervisor” in the event you want to change the specific user’s settings and want to copy from group again. Entry types: 5.2 Change the Entry type descriptions for the two cashbooks so that the payments and receipts reflect the bank account names, refer back to Task 1.1, rather than CB1 or CB2 and select Contra in Detail for both cash books. Tax: 5.3 Ensure the Tax Default Entry method is set to Inclusive. 5.4 Set the Tax Manager Tax Reporting Frequency as Category A – 2 Monthly, ending at the end of every odd month. AIN2601/Assessment 6 /2026/S1 20 Task 6: Setup of Customers control, Suppliers control and Inventory Customers control: 6.1 Setup the Customers control configuration to Print the Tax Amount on the document lines and insert the correct Tax Reference Prompt Amount as per the VAT guidelines. 6.2 Setup the Customer statements to have three Ageing totals, and the Customer statements to display the following messages: • Terms: “Please pay before the end of the month.” • Terms + 1: “Your account is overdue. Please pay ASAP.” • Terms + 2: “Your account is long overdue. Please pay immediately.” 6.3 Setup the Customer Early Payment Terms as 10% within 5 days from invoice date and setup the Default Tax Entry Method as Inclusive and the Customer Default processing method as open item. Suppliers control: 6.4 Setup the Suppliers control configuration to Print the Tax Amount on the document lines and ensure the Goods Received Notes are set to mandatory. 6.5 Setup the Normal monthly payment terms as 60 days; Supplier Early Payment Terms as 10% within 10 days from last day of period; the Supplier Default processing method as open item and the Default Tax Entry Method as Exclusive. Inventory: 6.6 Setup the Inventory Decimals for Quantity to 0; set both the Maximum Line Discount % and the Maximum Invoice Discount % to 10%. 6.7 On the Integration/Groups tab: • Ensure the Integrate Inventory to General Ledger tick box is ticked; • Select Automatic Allocation of Costs to Projects at Time of Sale; • Enter the information as per the table below: • Note: The above integration is critical to ensure that your transactions will be posted to the correct general ledger accounts! 6.8 Print the Inventory Groups Listing for all inventory groups. 6.9 Make a backup of PPS Pastel company in a new folder named PPS defaults”. Save a copy of this backup on an external memory device. Code Description Default Buy tax Default sell tax Sales Adjust-ment Cost of sales Inventory Count variance Purchase variance 001 Printers 15 15 1000/100 2100/000 2000/100 7700/100 2150/000 2200/000 002 Printer Cons 15 15 1000/200 2100/000 2000/200 7700/200 2150/000 2200/000 003 Accessories 15 15 1000/300 2100/000 2000/300 7700/300 2150/000 2200/000 004 Install & Maint 15 15 1000/400 2100/000 1000/400 1000/400 2150/000 2200/000 AIN2601/Assessment 6 /2026/1 21 Tasks 7 and 8 : VAT implications on supplier and customer account setup Please take note of the following when completing Tasks 7 and 8: • Where the customer is NOT a registered VAT-vendor: The default tax type will still be selected as 15, as ProPrint Solutions SA Ltd is a registered VAT-vendor and should raise output VAT on all sales and in turn is entitled to claim input VAT on purchases. (The customer will not have a VAT registration number). • Where the supplier is NOT a registered VAT-vendor: The default tax type will be selected as 00, as the supplier will not raise output VAT on their sales. ProPrint Solutions SA Ltd is therefore not allowed to claim input VAT on purchases from a supplier who is not registered for VAT. Task 7: Edit Supplier accounts. 7.1 Create Supplier accounts for the suppliers listed below: NB! Type your own student number in after each supplier name (where the “xxxxxxxx” is indicated). Description: Ink Masters (xxxxxxxx) Techsource Distributors (xxxxxxxx) Printgear Supplies (xxxxxxxx) Account code: IM001 TD07 PGS01 Postal address: P.O. Box 1023 Randburg, 2125 P.O. Box 4589 Edenvale, 1610 P.O. Box 30145 Braamfontein, 2017 Physical address: 18 Jetline Park, Edison Crescent, Randburg, 2125 12 Newton Road Meadowdale, Germiston, 1401 27 Graphite Street Crown Mines Johannesburg, 2092 Contact name: Your own first name Your own first name Your own first name Telephone: (011) 792-3345 (010) 880-2211 (087) 351-7788 Fax: (011) 792-3300 (011) 880-2000 (087) 351-7700 E-mail: Tax code: VAT standard rated VAT standard rated Not a registered VAT vendor Tax reference: N/A Credit limit: R1 800 000.00 R1 200 000.00 R450 000.00 NB! If the documents/printouts required later do not reflect your own student number as part of the supplier name or your own first name as the contact name, you will receive zero percent (0%) for your whole assignment! 7.2 Print the Supplier account (master) listing, sorted in supplier code sequence with details shown. 7.3 Make a backup of PPS Pastel company in a new folder named “PPS Supplier”. Save a copy of this backup on an external memory device. AIN2601/Assessment 6 /2026/S1 22 Task 8: Edit Customer accounts. 8.1 Create Customer categories with the same names as the Price lists. 8.2 Create Customer accounts for the customers listed below and allocate each customer to the correct customer category: NB! Type your own student number in after each customer name (where the “xxxxxxxx” is indicated). Description: BrightStart Academy (Student nr: xxxxxxxx) Ubuntu Literacy Foundation (Student nr: xxxxxxxx) OfficeHub Retailers (Student nr : xxxxxxxx) Account code: BSA07 UBU001 OH003 Postal address: Create your own Create your own Create your own Delivery address: Create your own Create your own Create your own Contact name: Your own surname Your own surname Your own surname Telephone: Create your own Create your own Create your own Fax: Create your own Create your own Create your own E-mail: Create your own Create your own Create your own Tax code: VAT standard rated Not a registered VAT vendor VAT standard rated Tax reference: N/A Price list: Wholesale Retail Wholesale Invoice discount % 2% 0% 5% Credit limit: R1 083,000.00 R900,000.00 R1 300,000.00 NB! If the documents/printouts required later do not reflect your own student number as part of the customer name, your own surname as the contact name or other unique contact details where you have to create your own information above, you will receive zero percent (0%) for your whole assignment! 8.3 Print the Customer account (master) listing, sorted in customer account name sequence for all customer categories and with details shown. 8.4 Make a backup of PPS Pastel company in a new folder named “PPS Customer”. Save a copy of this backup on an external memory device. AIN2601/Assessment 6 /2026/1 23 Task 9: Edit Inventory categories and items. 9.1 Create Four Inventory categories namely Printers, Printer Consumables, Accessories and Install&Maintenance. 9.2 Create the Inventory items listed below, using the correct category and inventory group according to the inventory code. When creating the inventory items: • Insert your student number as the inventory code for the inventory item “HP 26A Black Toner Cartridge”. Note: if your student number is not 8 characters long add a U at the end of your student number to ensure it is 8 characters in length • Create your own unique inventory code for the “Wireless Print Server” inventory item. Note the inventory code must be 8 characters in length. • The first 3 inventory items are Printers, the next two are Printer Consumables, the next one is an Accessory, and the last two are Installation and maintenance offered. Inventory Code and Description Unit Wholesale Selling Price (Incl. VAT) Retail Selling Price (Incl. VAT) Preferred Supplier Code Supplier Inventory Code Min Qty Max Qty PRNT001 HP LaserJet Pro Each R 4 700.00 R 4 999.00 TD07 HPL001 25 100 PRNT002 Epson EcoTank Each R 3 300.00 R 3 699.00 TD07 EPS01 30 400 PRNT003 Canon PIXMA G3420 Wireless Each R 3 500.00 R 3 799.00 TD07 CAN111 40 350 Your own student number (8 characters) HP 26A Black Toner Cartridge Each R 2 700.00 R 2 999.00 IM001 TON450 100 400 CONS02 Canon GI-41 Cyan Ink Each R180.00 R 220.00 IM001 CYA01 100 1 500 Your own unique code (8 characters) Wireless Print Server Each R 900.00 R 1 100.00 PGS01 WPS55 100 2 000 INSTAL Installation Service p/c R850.00 R950.00 MSE Maintenance Service p/c R 800.00 R 1 000.00 • Note: remember that if you select the wrong inventory group, your allocations in the financial statements will be wrong! • NB! If the documents/printouts required subsequently do not reflect your own student number as the inventory code for “HP 26A Black Toner Cartridge” or your own unique inventory code for the “Wireless Print Server” you will receive zero percent (0%) for your whole assignment! 9.3 Print the Item based price list, sorted by category, inclusive of VAT for both Wholesale and Retail prices and show zero quantity items. 9.4 Print the Preferred supplier listing, showing preferred supplier only, grouped by suppliers. 9.5 Make a backup of PPS Pastel company in a new folder named “PPS setup”. Save a copy of this backup on AIN2601/Assessment 6 /2026/S1 24 an external memory device. SECTION B – TAKE-ON OF OPENING BALANCES Task 10: Process take-on general journals 10.1 Create the four sub-accounts required for the take-on of the opening balances. 10.2 Process (but do not update) the General Journals to take-on the trial balance balances using the appropriate opening balance sub-accounts. ProPrint Solutions SA Ltd Trial Balance 30 April 2026 Dr Cr Retained Income 8 496 082.00 Share Capital 7 664 433.00 Investments 4 399 433.00 Computer Equipment @ Cost 4 569 433.00 Computer Equipment - Accumulated Depreciation 4 659 813.00 Furniture and Fittings @ Cost 4 396 873.00 Furniture and Fittings - Accumulated Depreciation 2 316 918.00 Maintenance @ Cost 4 399 433.00 Maintenance Equip - Accumulated Depreciation 3 744 434.00 NEDBANK Current Account 5 491 624.00 Petty Cash (float) 50 000.00 Inventory Control 4 076 919.00 Customer Control 3 181 689.00 Supplier Control 2 566 239.00 VAT Control 1 117 485.00 .00 .00 10.3 Print the General Journal without contras. 10.4 Update the General Journal batch. 10.5 Make a backup of PPS Pastel company in a new folder named “Take on TB”. Save a copy of this backup on an external memory device. AIN2601/Assessment 6 /2026/1 25 Task 11: Process take-on inventory journals 11.1 Process and update the Inventory Journals to take-on the inventory items at year end. • Note: unique inventory code you have created in Task 9.2. for the “Wireless Print Server” inventory item • Your own student number will be reflected as the inventory code of the inventory item “HP 26A Black Toner Cartridge” if you have followed the instructions in Task 9.2 correctly. ProPrint Solutions SA Ltd Inventory valuation 30 April 2026 Inventory code Description Quantity Latest cost price (excl. VAT) Total Grand Total PRNT001 HP LaserJet Pro 240 R 3 800.00 R 912 000.00 PRNT002 Epson Eco Tank 310 R 2 300.00 R 713 000.00 PRNT003 Cannon Pixma G3420 Wireless 251 R 2 499.00 R 627 249.00 R 2 252 249.00 Your own student number HP 26A Black Toner Cartridge 320 R 1 999.00 R 639 680.00 CONS02 Your own unique code Cannon GI-41 Cyan Ink Wireless Print Server 1 369 1 293 R110.00 R800.00 R 150 590.00 R 1 034 400.00 R 790 270.00 R 1 034 400.00 INSTALL MSE Installation service Maintenance service R 4 076 919.00 11.2 Print the Inventory reorder report for period 1 of 2027, sorted by Inventory Category, for Supplier Techsource Distributor only, without supplier details, include zero minimum reorder items and include zero quantity to order items. 11.3 Make a backup of PPS Pastel company in a new folder named “take-on Inventory”. Save a copy of this backup on an external memory device. AIN2601/Assessment 6 /2026/S1 26 Task 12: Process take-on cashbook 12.1 Process and update the current account and petty cash opening balances in the cashbook by referring to the Trial Balance in Task 10.2. 12.2 For April 2026, process and update the outstanding payments and deposits from the Bank Reconciliation into the current account cashbook. NB! Type your own student number where the “xxxxxxxx” is indicated when processing RC486 or you will receive zero percent (0%) for your assignment! ProPrint Solutions SA Ltd Bank Reconciliation Statement 30 April 2026 Balance per Bank Statement 5 251 724.00 Plus: Receipts not yet deposited 30 April 2026 RC486 xxxxxxxx 250 000.00 Total outstanding deposits: 250 000.00 Less: Cheques not yet presented 23 April 2026 Q381 City of Johannesburg 7 800.00 27 April 2026 Q385 Supersonic 2 300.00 Total outstanding cheques: 10 100.00 Reconciled Bank Balance 5 491 624.00 Bank balance per Trial Balance 5 491 624.00 Difference 0.00 12.3 Reconcile only the bank opening balance Amount so that the bank reconciliation on Pastel Partner resemble the bank reconciliation provided. Update the bank reconciliation. 12.4 Print the bank reconciliation for period 12 of 2026. 12.5 Make a backup of PPS Pastel company in a new folder named “Take-on Cashbook”. Save a copy of this backup on an external memory device. AIN2601/Assessment 6 /2026/1 27 Task 13: Process take-on supplier journals 13.1 Process and update the Supplier Journals to take-on the supplier invoice details in the correct periods for age analysis purposes. ProPrint Solutions SA Ltd Supplier Age Analysis 30 April 2026 Supplier code 90 days 60 days 30 days Current Total IM001 790 401.61 445 499.09 1 235 900.70 TD07 236 093.99 258 676.89 452 684.56 947 455.44 PGS01 230 961.51 151 921,35 382 882.86 230 961.51 1 026 495.60 410 598.24 898 183.65 2 566 239.00 The supplier balances are made up as follows: IM001 11 Feb 26 Invoice 478 569 089.16 24 Feb 26 Invoice 502 221 312.45 790 401.61 26 April 26 Invoice 543 445 499.09 552 341.79 1 235 900.70 TD07 15 Feb 26 Invoice 356 236 093.99 236 093.99 22 March 26 Invoice 489 258 676.89 258 676.89 18 April 26 Invoice 571 224 169.39 25 April 26 Invoice 590 228 515.17 452 684.56 947 455.44 PGS01 27 Jan 26 Invoice PG375 230 961.51 12 March 26 Invoice PG489 151 921,35 382 882.86 13.2 Print the Supplier Detailed Ledger by Entry type for period 1 to 12 of 2026, with Each period shown separately. 13.3 Print the Supplier Age Analysis for period 1 of 2027, sorted in Supplier code sequence, Print the descriptions, as well as the Full details, but Do not print transactions. 13.4 Make a backup of PPS Pastel company in a new folder named “Take-on Suppliers”. Save a copy of this backup on an external memory device. AIN2601/Assessment 6 /2026/S1 28 Task 14: Process take-on customer journals 14.1 Process and update the Customer Journals to take-on the customer invoice details in the correct periods for age analysis purposes. ProPrint Solutions SA Ltd Customer Age Analysis 30 April 2026 Customer code 60 days 30 days Current Total BSA07 483 934.90 598 157.54 1 082 092.44 UBU001 347 440.44 493 479.96 840 920.40 OH003 445 436.46 409 483.37 403 756.33 1 258 676.16 445 436.46 1 240 858.71 1 495 393.83 3 181 689.00 The customer balances are made up as follows: BSA07 08 Mar 26 IN381 483 934.90 483 934.90 08 April 26 IN760 239 263.02 29 April 26 IN812 358 894.52 598 157.54 1 082 092.44 UBU001 20 Mar 26 IN715 347 440.44 15 April 26 IN787 493 479.96 840 920.40 OH003 16 Feb 26 IN302 445 436.46 01 Mar 26 IN366 409 483.37 29 April 26 IN815 403 756.33 1 258 676.16 14.2 Print the Customer Detailed Ledger by Customer for period 1 to 12 of 2026, sorted in Account name sequence, with Each period shown separately. 14.3 Print the Customer Age Analysis for period 1 of 2027, sorted by Description, Print the descriptions, as well as the Full details, but Do not print transactions. 14.4 Make a backup of PPS Pastel company in a new folder named “Take-on Customers”. Save a copy of this backup on an external memory device. Task 15: Print take-on trial balance 15.1 Print the trial balance for period 1 to 12 of 2026, use sub-accounts, but Do not print zero items. AIN2601/Assessment 6 /2026/1 29 SECTION C – PROCESSING OF DAILY TRANSACTIONS Task 16: Process transactions NOTE: All calculations should be rounded to two decimal digits if necessary. NB! You will have to log-on as the correct employee to process the various transactions. To log-on as a different user you need to go to the File menu, then open and select the PPS company, then insert the password for the required user. Repeat this for every change in user. Always use the lowest level of employee to complete the task. Notice how the menu and functions are limited for the various users. The first time you use a new user you will be required to create a security question and security answer. For each user create the following: o Security question: Which module am I busy with? o Security answer: AIN2601 You can also create your own security questions and answers but please note that if you forget your security answers, lecturers will not be able to help you. Designation Accountant Sales clerk Purchases clerk Cashbook clerk User nr 00 01 02 03 User Name Thabiso Naledi Koos Vishay Password Wholesale sales purchases cash 16.1 On 1 May 2026 BrightStart Academy and Ubuntu Literacy Foundation pay the full Amount due on 30 April 2026. Capture receipt nr RC487 and RC488 respectively for these payments received. (Tip: You may want to carefully examine the customers’ account setup and the customer age analysis.) Match the receipt Amount and discount (if applicable) to the sales invoices for BrightStart Academy and Ubuntu Literacy Foundation. 16.2 On 4 May 2026 OfficeHub Retailers pays PPS the full Amount outstanding on this date. (Tip: You may want to carefully examine the customers’ account setup and the customer age analysis.) Capture receipt RC489 for this payment received. Note: you must use your student number in the description column, else you will receive zero percent (0%) for your whole assignment! Match the receipt Amount and discount (if applicable) to the sales invoices for OfficeHub Retailers. 16.3 Print the Receipt cashbook batch with contras. 16.4 For the following printers prepare a purchase order for Printgear Supplies dated 5 May 2026. Enter the latest cost price excluding VAT (Take note of the built in Pastel control, management is aware of this transaction so please proceed): Quantity Item 20 HP LaserJet Pro 15 Epson Eco Tank Include this remark after the Epson Eco Tank: ‘Colour must be black’ Print this Purchase order. (Note: if your printer’s paper settings are not on A4, the bottom part of your documents will not print correctly! Refer to the Pastel Manual for detail guidance on how to correct this.) AIN2601/Assessment 6 /2026/S1 30 16.5 Convert the purchase order of Printgear Supplies to a goods received note dated 6 May 2026 for all the items ordered, except that only 10 of each item ordered was delivered. Remove the whole original purchase order. Print this Goods received note. 16.6 Increase the petty cash float Amount to R55 000 by transferring the necessary Amount from Nedbank current account to the Petty Cash account on 7 May with cash cheque Q386. 16.7 PPS has engaged BrightWave Communications, a VAT-registered marketing consultancy, to roll out a targeted promotional campaign. The campaign will combine online channels such as LinkedIn and Instagram with traditional methods including radio slots and trade journals, ensuring maximum reach to both corporate and retail clients. BrightWave Communications has been contracted to design, manage, and implement the entire campaign strategy. The weekly fee payable to BrightWave Communications is R6 325.00 including VAT. Pay the weekly amount to BrightWave Communications on 8 May 2026 out of Petty Cash (petty cash voucher PC112). 16.8 Update all open batches which can be updated. (Tip: Remember to log on with the correct user, view open batches, then jump to correct batch and update from there.) 16.9 Make a backup of PPS Pastel company in a new folder named “Week-end 8 May”. Save a copy of this backup on an external memory device. 16.10 Prepare a sales quotation for OfficeHub Retailers dated 11 May 2026 to expire after 7 days (on 18 May 2026) for: Quantity Item 15 Cannon Pixma G3420 Wireless 300 HP 26A Black Toner Cartridge 25 Wireless Print Server 15 Installation service Print this Sales quotation. 16.11 Sell the following items to BrightStart Academy with a tax invoice dated 12 May 2026. Give them an additional 10% discount on HP 26A Black Toner Cartridge bought. Their order number is ORD678. (Take note of the built in Pastel control! Consider what you will do in a real-life situation to solve this problem. Make sure you DO manage to sell all these items to the customer!): Quantity Item 20 HP LaserJet Pro 40 Epson Eco Tank 15 Cannon Pixma G3420 Wireless 50 HP 26A Black Toner Cartridge 20 Cannon GI-41 Cyan Ink 38 Wireless Print Server 55 Installation service 15 Maintenance Print this Tax invoice AIN2601/Assessment 6 /2026/1 31 16.12 Use the Remittance Assistant on 13 May 2026 to pay Techsource Distributors and Printgear Supplies the full Amount due on or before 30 April 2026. Do not pay any Amount only due in the 2026 financial year. Use PPS71 as the starting reference number. Do not print remittances and cheques. Note: use F3 to manually match the payments created in the cashbook. 16.13 On 14 May 2026 pay Ink Masters with cheque Q387, the full Amount outstanding on this date. (Tip: You may want to carefully examine the suppliers’ account setup and the supplier age analysis). Note: you must use your student number in the description column, else you will receive zero percent (0%) for your whole assignment! Match the payment Amount to the supplier invoices for Ink Masters. 16.14 On 15 May 2026, pay R238 000.00 (inclusive of vat) with cheque Q388 to InfraVision Technologies, a registered VAT vendor, for the repair of a handheld infrared scanner used in routine maintenance service for R18 000.00 (incl vat) as well as the purchase of a new industrial infrared scanner for R220 000.00 (incl vat). The new infrared scanner is capital goods (Maintenance equipment) and the repair is allocated to repairs and maintenance costs. 16.15 On 16 May 2026, pay R3 200.00 to Supersonic (registered Vat vendor) with cheque Q389 for Internet cost (General Expense). 16.16 Pay BrightWave Communications on 16 May 2026 out of Petty Cash (petty cash voucher PC113) the weekly Amount of R6 325.00 including VAT for advertising. 16.17 Print the Nedbank Payment cashbook batch with contras. 16.18 Make a backup of PPS Pastel company in a new folder named “Weekend16 May”. Save a copy of this backup on an external memory device. 16.19 Convert the sales quotation created in task 16.10 for OfficeHub Retailers to a tax invoice dated 18 May 2026. They have accepted the quotation in full. Notice how Pastel has automatically changed the quantity of HP 26A Black Toner Cartridges from 300 (as per the quotation) to 270, because only 270 are in stock. Remove the whole original document. Their order number is ORD679. Although only 270 HP 26A Black Toner Cartridge Inverter are currently in stock, OfficeHub Retailers still wants the requested amount of HP 26A Black Toner Cartridge, we therefore have to create another sales order for HP 26A Black Toner Cartridges. Move your cursor to the quantities field for HP 26A Black Toner Cartridge and press F5 or click on the magnifying glass. Click on the create order button. Type in the Sales Order Qty block the number of HP 26A Black Toner Cartridge OfficeHub Retailers still wants, but what we are currently unable to deliver (30). Click on the Sales/Purchase Order button. Click OK. Then finalise the current sales invoice (note only 270 HP 26A Black Toner Cartridges are actually sold on this invoice as you can’t sell more stock than what you have!) Print this tax invoice. 16.20 Go to sales orders (under process customers) and print the sales order for OfficeHub Retailers dated 18 May 2026, which was automatically prepared in 16.19 above. The order number ORD679B and the delivery date 20 May 2026. 16.21 Print the Back Orders – Details by Item report (back orders for all items- under View customers back orders). Print Descriptions and Do not Show totals only, for all deliveries ending 20 May 2026. You don’t need to update batches before printing back orders. 16.22 Pay BrightWave Communicationson 20 May 2026 out of Petty Cash (petty cash voucher PC114) the weekly Amount of R6 325.00 including VAT for advertising. 16.23 On 22 May 2026 reimburse the accountant out of Petty Cash (petty cash voucher PC115). She paid R15 000.00 to Stylish Food (not a registered Vat-vendor) for catering (Entertainment expense) for a company function. AIN2601/Assessment 6 /2026/S1 32 16.24 Update all open batches which can be updated. (Tip: Remember to log on with the correct user, view open batches, then jump to correct batch and update from there.) 16.25 Make a backup of PPS Pastel company in a new folder named “Week-end 22 May”. Save a copy of this backup on an external memory device. 16.26 On 25 May 2026 you realise that you have items of stock that are below the minimum order quantity. For all inventory items, use the Reorder Assistant to prepare the required purchase orders. Include Outstanding sales orders. Open each of the purchase orders created with the Reorder Assistant. For each item, on the created purchase orders, where no Amount is reflected in the Exc Price field insert the correct Amount by using the latest cost price excluding VAT . (Tip: Refer back to tasks 7.1 and 9.2 and note each supplier’s VAT vendor status). It is rumoured that prices will decline in the very near future so PPS doesn’t want to hold too much stock on hand. Reduce the quantity of the following items on their purchase orders: -HP 26A Black Toner Cartridge: reduce to 50 units Convert purchase order created in 16.26 to a goods received notes dated 26 May 2026 for all the items ordered. Remove the whole original purchase order. Ensure correct dates on goods received notes. 16.27 Print the Outstanding GRNs – Details by Supplier for all suppliers. 16.28 Create a sales order, dated 27 May 2026, for Ubuntu Literacy Foundation who sent an order for the following items. Their order number is UBU156. Quantity Item 10 HP LaserJet Pro 3 Epson Eco Tank 2 Cannon GI-41 Cyan Ink 4 Wireless Print Server 10 Maintenance 16.29 On 28 May 2026 BrightStart Academy returned 10 HP 26A Black Toner Cartridge sold to them on 12 May 2026. The items are no longer needed as the customers who previously ordered these items cancelled their orders. These items can therefore still be sold. Process a sales return document for BrightStart Academy, including an appropriate message on the sales return document. (Make sure you choose the correct document type for this transaction!) (Tip: You may want to carefully examine the related original tax invoice before processing this sales return). Update and print this sales return. 16.30 Convert the sales order to a tax invoice for Ubuntu Literacy Foundation on 28 May 2026. Remove the whole original sales order. He has accepted the sales order in full, except that he only want 5 HP LaserJet Pro. Print this tax invoice. 16.31 Pay BrightWave Communications on 28 May 2026 out of Petty Cash (petty cash voucher PC116) the weekly amount of R6 325.00 including VAT for advertising. 16.32 Update all open batches which can be updated. (Tip: Remember to log on with the correct user, view open batches, then jump to correct batch and update from there.) AIN2601/Assessment 6 /2026/1 33 16.33 Make a backup of PPS Pastel company in a new folder named “up to 28 May” have a copy of this backup on an external memory device. 16.34 You received supplier invoice nr PG764 from Printgear Supplies. Convert the goods received note for Printgear Supplies to a supplier invoice dated 29 May 2026. Because of the short delivery on 6 May, they have also given you a 5% discount on Epson Eco Tank (on this item only) received on 6 May. Print this invoice. 16.35 You received supplier invoice nr INK856 from Ink Masters. Convert the goods received note of Ink Masters to a supplier invoice dated 29 May 2026. All the quantities and prices on the supplier invoice agree with the details on the goods received note. Ink Masters however ran a marketing campaign and has therefore given a 5% invoice discount. (16.26) Print this invoice. 16.36 Print the Supplier Invoice Summary Listing 16.37 Convert the sales order created in task 16.20 for OfficeHub Retailers to a tax invoice dated 29 May 2026. Remove the whole original document. On the same tax invoice also sell the following items to OfficeHub Retailers. Their order number is ORD679B Quantity Item 10 Epson Eco Tank 16.38 Print the Tax Invoice Summary Listing. 16.39 Print the Detailed Ledger for the Petty Cash account only (period 1 of 2027). 16.40 Use the printout in 16.39 to calculate how much is required to restore the petty cash float (as increased by you in 16.6) to its limit. Transfer the required Amount as calculated by you to restore the petty cash float from the Nedbank Bank current account to the Petty Cash account on 30 May 2026 with cash cheque Q390. 16.41 Pay BrightWave Communications on 30 May 2026 out of Petty Cash (petty cash voucher PC117) the Retail weekly Amount of R6 325.00 including VAT. 16.42 Update all open batches which can be updated. (Tip: Remember to log on with the correct user, view open batches, then jump to correct batch and update from there.) 16.43 On 30 May 2026, pay the staff their monthly salaries using electronic transfer to their bank accounts. Use Sal01May as starting reference number. The following amounts were paid: Thabiso (R45 000); Naledi (R32 500); Koos (R29 500) and Vishay (R25 000). 16.44 Process the monthly depreciation journal on assets on 31 May 2026. All assets are depreciated on a straight-line basis. The annual depreciation rates are: • Computer Equipment 20% • Furniture and Fittings 10% • Maintenance Equipment 25% You must only process depreciation relating to the asset types listed above. Do not process the depreciation journal with regards to office equipment and motor vehicles. Remember to include any new purchases in May 2026. (TIP: The Depreciation journal is processed monthly and you might need to consider calculating a monthly depreciation rate. Round each asset type’s depreciation to two decimal places) AIN2601/Assessment 6 /2026/S1 34 16.45 Update all open batches which can be updated. (Tip: Remember to log on with the correct user, view open batches, then jump to correct batch and update from there.) 16.46 Make a backup of PPS Pastel company in a new folder named “31 May”. Save a copy of this backup on an external memory device. SECTION D – MONTH END PROCESSING Task 17: Prepare a bank reconciliation Use the following bank statement: NEDBANK current account Bank Statement of ProPrint Solutions SA Ltd 31 May 2026 Date Description Debits Credits Balance 01-May-26 Balance brought forward 5 251 724.00CR 01- May-26 Deposit 250 000.00 5 501 724.00CR 02- May-26 Q385 2 300.00 5 499 424.00CR 03- May-26 Q381 7 800.00 5 491 624.00CR 03-May-26 Deposit 483 934.90 5 975 558.90CR 16-May-26 Q386 5 000.00 5 970 558.90CR 18-May-26 Q389 3 200.00 5 967 358.90CR 20-May-26 EFT 230 961.51 5 736 397.39CR 25-May-26 Q388 238 000.00 5 498 397.39CR 30-May-26 EFT 45 000.00 5 453 397.39CR 30-May-26 EFT 32 500.00 5 420 897.39CR 30-May-26 EFT 29 500.00 5 391 397.39CR 30-May-26 EFT 25 000.00 5 366 397.39CR 31-May-26 Credit interest 68 450.00 5 434 847.39CR 31-May-26 ***Monthly bank fees 3 130.00 5 431 717.39CR 31-May-26 Closing Balance 5 431 717.39CR ***Bank fees are inclusive of VAT 17.1 Capture and update the bank related transactions from the bank statement into the cashbook. 17.2 Balance and update the bank reconciliation for PPS for May 2026. 17.3 Print the bank reconciliation for PPS for May 2026. 17.4 Make a backup of PPS Pastel company in a new folder named “month-end bank recon”. Save a copy of this backup on an external memory device. AIN2601/Assessment 6 /2026/1 35 Task 18: Month end reporting 18.1 Print the Trial balance as from 1 May 2026 to 31 May 2026, include opening balances and use sub-accounts, but do not print zero items. Print Balance Sheet accounts first. 18.2 Print the Income statement for period 1 of 2027, with detail lines and include sub-accounts, but do not print zero items. 18.3 Print the Balance sheet for period 1 of 2027, with detail lines, but do not print zero items and do not print the Asset section first. 18.4 Print the Cash Movement Report for period 1 of 2027, for cashbook 01 (NEDBANK) only, include sub-accounts but do not show only the totals. 18.5 Print the Cash book details for NEDBANK current account for period 1 of 2027, with the opening balance included, but do not show the totals only. 18.6 Print the Inventory valuation report for period 1 of 2027, sorted by description, do not use last costs, show zero quantity items and do not include unposted quantities. 18.7 Print the Tax type report for the 202605 (01/04/2026 – 31/05/2026) tax period. In order to view the report, you need to follow the instructions below: • You will receive the following message: “You need to close your previous Tax Periods before viewing your tax reports. Please select your Current Tax Period. All tax periods prior to this will be closed.” • Click on the drop-down list and select 202605 (01/04/2026 – 31/05/2026). • Click on OK. • You will receive the following message: “Your previous Tax Periods are now closed. All processing will continue in your current Tax Period 202605 (01/04/2026 – 31/05/2026).” • Click on OK. • On the next screen make sure that the following is selected: “View Reports”, “Tax Type Report”, “View current Tax Period”. The following must be deselected: “View closed Tax Period(s), “Close the current Tax Period”. • Click on next. • After performing the procedures above, you have to print the Tax type report for the current tax period, all tax types, show details, print descriptions, do not print a new page per account, do not offset credits against sales/purchases. 18.8 Print the Open item remittance statement for Ink Masters for period 1 of 2027. Do not show paid items only. 18.9 Change only Printgear Supplies from Open-item processing to Balance forward processing. Now print the Balance forward remittance statement for Printgear Supplies for period 1 of 2027. Do not show paid items only. • Carefully examine both printout 18.8 and 18.9. Note the differences on the statements between open item and balance forward processing. 18.10 Print the Customer age analysis for period 1 of 2027, sorted by Customer code, with descriptions, partial details, printing of transactions and print zero items. 18.11 Print the Supplier age analysis for period 1 of 2027, sorted by Supplier description, with full details, descriptions, printing of transactions and print zero items. Carefully examine printout 18.11. Note the differences on the age analysis between Ink Masters (open item processing) and Printgear Supplies (balance forward processing).