Assignment 6 PORTFOLIO GUIDELINES
Unique number:
Due Date:
AIN2601 PORTFOLIO DETAILED STEP BY STEP GUIDELINES
TABLE OF CONTENTS
SECTION A – COMPANY SETUP .................................................................................................... 6
Task 1: Create the Company Using Setup Assistant...................................................................... 6
Task 2: Create Supervisor User ....................................................................................................... 7
Task 3: Edit the Chart of Accounts ................................................................................................. 9
Task 3.1 – View the Trial Balance ....................................................................................................... 9
Task 3.2 – Edit Existing Accounts ..................................................................................................... 10
Task 3.3 – Create New GL Accounts ................................................................................................. 12
Task 4: Setup Company Parameters ............................................................................................. 13
Task 4.1 – Change Company Name and Trading Name ................................................................. 14
Task 4.2 – Enter Contact Details ....................................................................................................... 16
Task 4.3 – Document Numbers .......................................................................................................... 17
Task 4.4 – Set Cash Book Transfer Account .................................................................................... 17
Task 4.5 – Make a Backup ................................................................................................................. 17
Terms of use
Task 5: Setup Users, Entry Types and Tax ..................................................................................
By making use of this document you agree to:
18
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making use of this document you agree to:
Use this document
Fully accept the consequences
solely as a guide forshould you plagiarise
learning, reference,or and
misuse this document.
comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
Reproduction, resale, or transmission of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
AIN2601 PORTFOLIO DETAILED STEP BY STEP
GUIDELINES
TABLE OF CONTENTS
SECTION A – COMPANY SETUP .................................................................................................... 6
Task 1: Create the Company Using Setup Assistant ..................................................................... 6
Task 2: Create Supervisor User....................................................................................................... 7
Task 3: Edit the Chart of Accounts ................................................................................................. 9
Task 3.1 – View the Trial Balance ....................................................................................................... 9
Task 3.2 – Edit Existing Accounts ..................................................................................................... 10
Task 3.3 – Create New GL Accounts................................................................................................. 12
Task 4: Setup Company Parameters ............................................................................................. 13
Task 4.1 – Change Company Name and Trading Name ................................................................. 14
Task 4.2 – Enter Contact Details ....................................................................................................... 16
Task 4.3 – Document Numbers .......................................................................................................... 17
Task 4.4 – Set Cash Book Transfer Account .................................................................................... 17
Task 4.5 – Make a Backup ................................................................................................................. 17
Task 5: Setup Users, Entry Types and Tax .................................................................................. 18
Task 5.1 – Setup Additional Users ..................................................................................................... 19
Task 5.2 – Change Entry Type Descriptions .................................................................................... 26
Task 5.3 – Set Tax Default Entry Method ........................................................................................ 27
Task 5.4 – Set Tax Reporting Frequency .......................................................................................... 28
Task 6: Setup Customers Control, Suppliers Control and Inventory........................................ 28
Task 6.1 – Setup Customer Control Configuration ......................................................................... 29
Task 6.2 – Setup Customer Statements and Messages .................................................................... 30
Task 6.3 – Setup Early Payment Terms and Processing Method ................................................... 31
Task 6.4 – Setup Supplier Control Configuration ........................................................................... 31
Task 6.5 – Setup Supplier Terms and Tax........................................................................................ 32
Task 6.6 – Inventory Decimal and Discount Settings ...................................................................... 33
Task 6.7 – Configure Inventory Integration Groups ....................................................................... 33
Task 6.8 – Print Inventory Groups Listing....................................................................................... 36
Task 6.9 – Backup PPS Defaults ........................................................................................................ 37
Task 7: Edit Supplier Accounts ..................................................................................................... 38
Task 7.2 – Print Supplier Master Listing ......................................................................................... 41
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
Task 7.3 – Backup PPS Supplier ....................................................................................................... 42
Task 8: Edit Customer Accounts ................................................................................................... 43
Task 8.1 – Create Customer Categories............................................................................................ 43
Task 8.2 – Create Customer Accounts .............................................................................................. 45
Task 8.3 – Print Customer Master Listing ....................................................................................... 47
Task 8.4 – Backup PPS Customer ..................................................................................................... 49
Task 9: Edit Inventory Categories and Items .............................................................................. 50
Task 9.1 – Create Inventory Categories............................................................................................ 50
Task 9.2 – Create Inventory Items .................................................................................................... 51
Task 9.3 – Print Item Based Price List.............................................................................................. 56
Task 9.4 – Print Preferred Supplier Listing ..................................................................................... 57
Task 9.5 – Backup PPS Setup ............................................................................................................ 58
Task 10: Process Take-On General Journals ............................................................................... 59
Task 10.1 – Create Sub-Accounts for Opening Balances ................................................................ 60
Task 10.2 – Process Opening Balance General Journal .................................................................. 61
Task 10.3 – Print General Journal Without Contras ...................................................................... 63
Task 10.4 – Print General Journal Batch (Without Contras) ......................................................... 64
Task 10.5 – Backup PPS Parameters ................................................................................................ 67
Task 11: Process Take-On Inventory Journals ............................................................................ 68
Task 11.1 – Process Inventory Journal ............................................................................................. 68
Task 11.2 – Print Inventory Reorder Report ................................................................................... 70
Task 11.3 – Backup PPS Setup .......................................................................................................... 72
Task 12: Process Take-On Cashbook............................................................................................ 72
Task 12.1 – Open the Cash Book ....................................................................................................... 73
Task 12.2 – Capture Opening Cashbook Transactions ................................................................... 73
Task 12.3 – Reconcile the Bank Account .......................................................................................... 75
Task 12.4 – Print Bank Reconciliation .............................................................................................. 77
Task 12.5 – Backup PPS Company ................................................................................................... 78
Task 13: Process Take-On Supplier Balances .............................................................................. 79
Task 13.1 – Process Supplier Opening Balances .............................................................................. 79
Task 13.2 – Print Supplier Detailed Ledger ..................................................................................... 81
Task 13.3 – Print Supplier Age Analysis........................................................................................... 82
Task 13.4 – Backup PPS Supplier Balances ..................................................................................... 83
Task 14: Process Take-On Customer Balances ............................................................................ 84
Task 14.1 – Process Customer Opening Balances ............................................................................ 85
Task 14.2 – Print Customer Detailed Ledger ................................................................................... 87
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
Task 14.3 – Print Customer Age Analysis ........................................................................................ 88
Task 14.4 – Backup PPS Customer Balances ................................................................................... 89
Task 15: Print Trial Balance and Final Opening Balance Verification ..................................... 90
Task 15.1 – Print Trial Balance ......................................................................................................... 90
Task 15.2 – Verify Control Accounts ................................................................................................ 92
Task 15.3 – Correct Errors if Needed ............................................................................................... 93
Task 15.4 – Backup PPS Opening Balances ..................................................................................... 93
Task 16.1 & 16.2 – Capture Customer Receipts .......................................................................... 94
Task 16.1 – Capture Receipt for BrightStart Academy .................................................................. 96
Task 16.2 – Capture Receipt for OfficeHub Retailers ..................................................................... 97
Task 16.2 – Capture Receipt for Ubuntu Literacy Foundation ...................................................... 97
Task 16.3 – Print Receipt Cashbook Batch with Contras ........................................................... 98
Task 16.4 – Prepare Purchase Order for Techsource Distributors.......................................... 100
Task 16.4 – Prepare Purchase Order for Techsource Distributors.......................................... 104
Task 16.6 – Increase Petty Cash Float ........................................................................................ 112
Task 16.7 – Pay Advertising Expense from Petty Cash ............................................................. 114
Task 16.8 – Update All Open Batches ......................................................................................... 117
Task 16.9 – Backup to Folder “Week-end 11 May” .................................................................. 120
Task 16.10 – Prepare Sales Quotation for OfficeHub Retailers ............................................... 123
Task 16.12 – Use Remittance Assistant ........................................................................................... 127
Task 16.13 – Pay Ink Masters in Full .............................................................................................. 129
Task 16.14 – Pay XYZ Technologies (Repairs and Capital) ......................................................... 131
Task 16.15 – Pay MTN Cellphone Account .................................................................................... 133
Task 16.16 – Print Payment Cashbook Batch with Contras ......................................................... 135
Task 16.17 – Backup “18 May” ....................................................................................................... 137
Task 16.18 – Convert Quotation to Tax Invoice (Partial Stock) ................................................... 138
Task 16.19 – Print Sales Order for OfficeHub Retailers ............................................................... 141
Task 16.20 – Print Back Orders Report (Details by Item) ............................................................ 143
Task 16.21 – Pay Advision from Petty Cash ................................................................................... 144
Task 16.22 – Reimburse Accountant for Catering ......................................................................... 146
Task 16.23 – Update All Open Batches ........................................................................................... 148
SECTION C – PROCESSING OF DAILY TRANSACTIONS .................................................... 150
Task 16.24 – Backup Before Continuing ........................................................................................ 150
Task 16.25 – Reorder Assistant for Purchase Orders ................................................................... 151
Task 16.26 – Print Outstanding GRNs............................................................................................ 154
Task 16.27 – Create Sales Order for Ubuntu Literacy Foundation ............................................. 155
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
Task 16.28 – Process Sales Return by BrightStart Academy........................................................ 157
Task 16.29 – Convert UBU963 Sales Order to Tax Invoice .......................................................... 159
Task 16.30 – Weekly Advision Payment from Petty Cash ............................................................ 161
Task 16.31 – Update All Open Batches ........................................................................................... 163
Task 16.32 – Backup up to 27 May.................................................................................................. 165
Task 16.33 – Convert GRNs to Supplier Invoice for Techsource Distributors ........................... 166
Task 16.34 – Process Ink Masters Supplier Invoice....................................................................... 169
Task 16.35 – Print Supplier Invoice Summary Listing ................................................................. 170
Task 16.36 – Convert ORD732 to Invoice and Add Additional Item ........................................... 172
Task 16.37 – Print Tax Invoice Summary Listing ......................................................................... 174
Task 16.38 – Print Petty Cash Detailed Ledger ............................................................................. 175
Task 16.39 – Restore Petty Cash Float ............................................................................................ 177
Task 16.40 – Weekly Advision Payment ......................................................................................... 179
Task 16.41 – Update All Open Batches ........................................................................................... 181
Task 16.43 – Process Depreciation Journal .................................................................................... 181
Task 16.44 – Update Open Batches ................................................................................................. 184
Task 16.45 – Final Backup for 31 May ........................................................................................... 186
Task 17.1 – Capture and Update Bank Statement Transactions.................................................. 187
Task 17.2 – Balance and Update Bank Reconciliation .................................................................. 189
Task 17.3 – Print Bank Reconciliation Report ............................................................................... 192
Task 18.1 – Print Trial Balance (01 May – 31 May 2026) ............................................................. 193
Task 18.2 – Print Income Statement ............................................................................................... 195
Task 18.3 – Print Balance Sheet ...................................................................................................... 196
Task 18.4 – Print Cash Movement Report ..................................................................................... 197
Task 18.5 – Print Cash Book Details (NEDBANK) ....................................................................... 199
Task 18.6 – Print Inventory Valuation Report............................................................................... 200
Task 18.7 – Print Tax Type Report ................................................................................................. 201
Task 18.8 – Print Open Item Remittance for Ink Masters ............................................................ 204
Task 18.9 – Change Techsource Distributors to Balance Forward and Print Remittance ........ 205
Task 18.10 – Print Customer Age Analysis .................................................................................... 207
Task 18.11 – Print Supplier Age Analysis....................................................................................... 208
FINAL SUBMISSION CHECKLIST – AIN2601 PORTFOLIO ................................................. 210
IMPORTANT FILE NAMING FORMAT..................................................................................... 210
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
SECTION A – COMPANY SETUP
Task 1: Create the Company Using Setup Assistant
Use the following step-by-step process in Sage Pastel Partner 50c exactly as required for
AIN2601 Assessment 6.
Step 1: Open Sage Pastel Partner
1. Double-click the Pastel Partner icon on your desktop.
2. Wait for the main Pastel screen to load.
Step 2: Create a New Company
1. On the top menu bar, click File.
2. Select New.
3. The Setup Assistant window will open.
Step 3: Enter Company Folder Name
1. In the Company Name / Folder Name field, type:
PPS xxxxxxxx
Replace xxxxxxxx with your student number.
2. Click Next.
Step 4: Select the Chart of Accounts
1. Under Chart of Accounts, select:
Generic Chart of Accounts
2. Click Next.
Step 5: Enter Company Information
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.