A Step-by-Step Guide

In this article, we’ll guide you through the process of creating user profiles in Sage Pastel Partner. Creating user profiles and controlling system rights in Sage Pastel Partner is essential for maintaining security, enhancing operational efficiency, ensuring compliance, preventing fraud, and providing a tailored user experience. These controls help protect the organization’s financial data and support a structured, accountable, and efficient working environment.

How to Create User Profiles in Sage Pastel Partner

Step 1: Access the User Setup

1. Open Sage Pastel Partner.
2. Navigate to the Setup menu.
3. Select Users/Passwords.
4. Click on Users.

Step 2: Enter Admin Password

1. A prompt will appear asking for the admin password. Enter the admin password and click OK.

Step 3: User Setup Window

1. You will now be in the Users Setup window.
2. Ensure this is the only window open by closing other windows if necessary.
3. The options available are Delete, Save, Reject, Search, and navigation buttons.

Step 4: Create a New User(Lets say a Cashbook Clerk)

1. Click on Next to create a new user.
2. The User Code will be automatically generated by the system.
3. Fill in the following fields:
   • Username: Enter the user’s name (e.g., Susan Jack).
   • Email Address: Enter the user’s email address (e.g., jack@demo.com).
   • Password: Set a password for the user and confirm it.
   • User Group: Select Personalized.

Step 5: Set User Permissions

1. Click on Menu Access to assign permissions.
2. A window replicating the main menu will appear. Here, you can set specific rights for the user.

Step 6: Assign Rights by Menu

1. File Menu: Uncheck all options as these are typically administrative functions.
2. Edit Menu: Uncheck all options.
3. Process Menu:
   • Uncheck all initially.
   • Check only the necessary tasks (e.g., Cash Book and Bank Reconciliation).
4. View Menu:
   • Uncheck all initially.
   • Check relevant reports for the user’s role (e.g., Cash Movement Report under Financial Reports and Cashbook Details under Transactions).
5. Change Menu: Uncheck all options.
6. Setup Menu: Uncheck all options.
7. Utility Menu:
   • Uncheck all initially.
   • Check relevant tools (e.g., Note Facility, Price Search, and Calculator).

Step 7: Save the User Profile

1. Once all permissions are set, click OK.
2. In the Users Setup window, click Save to save the new user profile.

Step 8: Log In as the New User

1. Close the Users Setup window.
2. Go to the File menu and click Open.
3. Select your company file and click Open.
4. Enter the new user’s password.
5. Set up a security question and answer, then click OK.

Step 9: Verify User Permissions

1. Log in as the new user (e.g., Susan Jack).
2. Check the permissions:
   • Under File, the user should only have access to Open, Set Printer, and Exit.
   • Under Edit, there should be no options available.
   • Under Process, ensure only Cash Book and Bank Reconciliation are available.
   • Under View, verify access to Cash Movement and Cashbook Details reports.
   • Under Change and Setup, there should be no options available.
   • Under Utility, the user should only have access to Note Facility, Price Search, and Calculator.

Creating user profiles and controlling system rights in an accounting system like Sage Pastel Partner is crucial for several reasons:

1. Security and Data Integrity

• Prevent Unauthorized Access: By creating user profiles and assigning specific permissions, you can ensure that only authorized personnel have access to sensitive financial data. This minimizes the risk of unauthorized access and potential data breaches.
• Data Protection: Limiting access to certain functionalities helps protect the integrity of your accounting data, ensuring that only qualified personnel can modify critical financial records.

2. Accountability and Audit Trail

• Traceability: User profiles enable tracking of actions performed by different users within the system. This is essential for creating an audit trail that can be used to investigate discrepancies or errors.
• Responsibility: Assigning specific roles to users ensures that each person is accountable for their actions. This clarity helps in identifying who made changes or entries, thereby facilitating accountability.

3. Operational Efficiency

• Role-Based Access: By granting access based on job roles, employees can quickly access the information and tools they need to perform their tasks efficiently without being overwhelmed by unnecessary functionalities.
• Reduce Errors: Restricting access to certain functions reduces the likelihood of accidental errors by users who are not trained or authorized to perform specific tasks.

4. Compliance with Regulations

• Regulatory Requirements: Many industries have strict regulatory requirements regarding financial data access and management. Implementing user profiles and access controls helps ensure compliance with these regulations, such as GDPR, SOX, or HIPAA.
• Audit Readiness: Controlled access and detailed audit trails prepare your organization for external audits, demonstrating that you have robust controls in place to protect financial data.

5. Minimizing Internal Fraud

• Segregation of Duties: Implementing user profiles allows for the segregation of duties, where different users are responsible for different parts of a process. This reduces the risk of internal fraud by ensuring that no single individual has control over all aspects of a financial transaction.
• Detecting Suspicious Activities: With controlled access and monitoring, it is easier to detect and investigate suspicious activities, such as unauthorized data manipulation or unusual transactions.

6. Customizable User Experience

• Tailored Access: Customizing the user experience by providing access to only relevant features and data enhances usability. Users can focus on their specific tasks without navigating through irrelevant options.
• Training and Support: With user profiles tailored to specific roles, training can be more focused and effective, ensuring users are well-versed in the functionalities they need to use.

7. Improving System Performance

• Resource Management: Limiting access to high-resource functions to only those who need them can help in managing system resources more efficiently, leading to better overall system performance.

Conclusion

In summary, creating user profiles and controlling system rights in Sage Pastel Partner is essential for maintaining security, enhancing operational efficiency, ensuring compliance, preventing fraud, and providing a tailored user experience. These controls help protect the organization’s financial data and support a structured, accountable, and efficient working environment.

Introduction to General Ledger Transactions

To process general ledger transactions in Sage Pastel Partner, we use the ENTRY TYPE called “general journals.” The ENTRY TYPE represents the book of original entry. Whenever you hear “entry type,” remember it refers to the book of original entry.

Accessing the General Journal

1. Click on Process: Navigate to the Process menu.
2. Select Journals: From the dropdown, select Journals.
3. Click on General Journal: This will open the General Journal window.

Before we dive into capturing general ledger transactions, let’s define some key terms.

What Are General Ledger Transactions?

General Journal transactions are defined as transactions that are not:

1. Cashbook transactions
2. Customers or Debtors transactions
3. Suppliers or Creditors transactions

Defining Cashbook, Debtors, and Creditors Transactions

Cashbook Transactions: These include all transactions involving cash, bank, and electronic money (credit cards, ecocash, debit cards). If a transaction involves cash in any form, it is captured through the cashbook.

Debtors Transactions: These involve sales and returns of products and services to customers or debtors done on account (i.e., no cash involved). These are captured through the Customer Journal. If cash is involved, the transaction is captured through the cashbook instead.

Creditors Transactions: These involve purchases and returns of products and services from suppliers or creditors done on account. These are captured through the Suppliers Journal. If cash is involved, the transaction is captured through the cashbook instead.

Determining the Transaction Type

Before capturing a transaction, you must identify its type:

• Is this a General Ledger transaction?
• Is this a cashbook transaction?
• Is this a Customers/Debtors transaction?
• Is this a Suppliers/Creditors transaction?

Choose the appropriate entry type or book of original entry accordingly. This step is crucial.

Understanding the General Journal Window

The General Journal window consists of the following fields:

• Entry Type: The name of the book of original entry (General Journal in this case).
• Period: The month the transaction occurred.
• Date: The date on which the transaction occurred.
• Account: The general ledger account being debited or credited.
• Reference: A code to trace the transaction.
• Description: Describes the nature of the transaction.
• Debit Column: Enter the amount if debiting the account.
• Credit Column: Enter the amount if crediting the account.
• Project: The cost center affected by the transaction.
• Contra Account: The account that will be debited or credited based on the account column entry.

Buttons in the General Journal Window

• Delete: Delete a line or the entire batch.
• Insert: Insert a line in the batch.
• Match: Not applicable here.
• Inclusive/Exclusive: Not applicable here.
• Preview: Preview transactions before updating.
• Print: Print the batch.
• Update: Post transactions to the general ledger, automatically updating the trial balance, income statement, and balance sheet.
• Batch: Update batch settings.
• Settings: Automate some batch processes, like incrementing reference numbers.

Overview of the Function

This tutorial will guide you through the steps required to send and receive data using the Accountant Data Assistant in Sage Pastel Partner. This function is essential for organizations that have internal accounts personnel, such as bookkeepers, who prepare initial financial records up to the trial balance, and external accountants who finalize the accounts, make corrections, and produce reports using the data compiled by the bookkeeper.

The Accountant Data Assistant allows:

1. Sending a full backup of the company data.
2. Restoring a full backup of the company data.
3. Importing the GAAP Category Allocations and Journal Batches.

We will focus on the first two parts: sending and restoring a full backup of the company data.

Part 1: Sending a Full Backup of the Company Data

Step-by-Step Guide

1. Access the Function
   • Click on File in the main menu.
   • Select Send and Receive Accountant Data Assistant.

Send a Full Backup of the Company Data

• • Click on Send a full backup of the company data.
  • You will see two methods to send the data:
    • Save to disk
    • Email to accountant

Method 1: Save to Disk

1. Select Save to Disk
   • Choose Save to disk and click Next.

Select Drive

• In the next window, select the drive where you want to save the backup file by clicking the drop-down arrow.
• Click Next.

Confirm Operation

• You will be taken to the confirm operation window. Read through the notes.
• Click Process.

Operation Complete

• The operation will run, and you will be taken to the operation complete window.
• Click Finish.

Send Backup via Email

• Use your normal email services to send the saved backup file as an attachment to the accountant.

Method 2: Email to Accountant

1. Select Email to Accountant
   • Choose Email to accountant and click Next.
2. Enter Email Details
   • Write in the email address of the receiver, the subject, and the body of the email.
   • Click Next.
3. Confirm Operation
   • You will be taken to the confirm operation window. Read through the notes.
   • Click Process.
4. Operation Complete
   • The operation will run, and you will be taken to the operation complete window.
   • Click Finish.

Using either method, you will have successfully sent a full backup of your company data.

Part 2: Restoring a Full Backup of the Company Data

Step-by-Step Guide

1. Access the Function
   • Click on File in the main menu.
   • Select Send and Receive Accountant Data Assistant.
2. Restore a Full Backup of the Company Data
   • Click on Restore a full backup of the company data.
   • Click Next.
3. Select Drive with Backup Files
   • In the next window, select the drive with your received backup files by clicking the drop-down arrow.
   • The received backup files will appear in the window.
   • Select the file you want to restore and click Next.
4. Confirm Operation
   • You will be taken to the confirm operation window. Read through the notes.
   • Click Process.
5. Warning
   • A warning will appear stating that you are about to do a restore. Click OK.
6. Operation Complete
   • The process will run, and once complete, click Finish.
7. Log into Restored Company
   • You will be prompted to log into the restored company.
   • Enter your password and click OK.

You are now ready to work with the restored data.

Conclusion

By following these steps, you can effectively use the Send and Receive Accountant Data Assistant to manage your financial data exchange between the bookkeeper and the accountant. This ensures that your financial records are accurately maintained and finalized, facilitating smooth and efficient accounting processes within your organization.

A Step-by-Step Guide

In this article, we’ll walk you through the process of creating customer accounts in Sage Pastel Partner. Creating customer accounts on Sage Pastel Partner is essential for maintaining organized financial records, managing customer relationships effectively, and ensuring compliance with regulatory standards. It enables businesses to track transactions, manage credit, streamline operations, and make informed decisions based on accurate financial data.

Getting Started

To begin creating customer accounts, follow these steps:

1. Navigate to the Customer Accounts Section:
   • Click on Edit.
   • Select Customers.
   • Choose Accounts.
   • The system will load the Edit Customer Accounts window.

Understanding the Edit Customer Accounts Window

In this window, you’ll find several buttons and fields essential for managing customer accounts:

• Add/Edit/Delete Buttons:
  • Add: Create a new customer account.
  • Edit: Modify an existing customer account.
  • Delete: Remove a customer account (Note: Do not delete accounts with posted transactions).
  • Save: Save the details of a customer account.
  • Reject: Discard changes before saving.
  • Search: Find a customer by account code or name.
  • Navigation Buttons: Move to the first, last, previous, or next customer account in the list.
• Account Code: Enter a unique code for the customer.
• Description: Provide the customer’s name.
• Customer Category: Select the appropriate category (e.g., Individual or Corporate).

Entering Customer Details

Let’s break down the process into manageable steps, starting with the Details tab.

1. Details Tab:
   • Account Code: Enter a unique code (e.g., CA001).
   • Description: Enter the customer’s name (e.g., Makonde Enterprises Pvt Ltd).
   • Customer Category: Select the appropriate category (e.g., Corporate).
   • Postal Address: Enter the postal address (e.g., P.O. Box 2010, Harare Main Post Office, Harare).
   • Physical Address: Enter the physical address (e.g., 43A Steve Biko Drive, Masasa).
   • Contact Person: Enter the name of the contact person (e.g., Prospect Tama).
   • Phone Number: Enter the business phone number (e.g., 0242-123456).
   • Mobile Number: Enter the mobile number if available.
   • Email: Enter the business email address.
2. Sales Representative:
   • Select the sales representative who handles this customer.
   • Use the code or description to find the representative.

Additional Tabs

Once you’ve filled out the Details tab, proceed with the following tabs:

1. Processing Tab:
   • Currency: Select the home currency.
   • Processing Method: Choose Open Item to link payments to specific invoices, ensuring accurate age analysis reports.
2. Terms Tab:
   • Adjust terms if necessary (e.g., credit limits, early payment terms).
3. Additional Options Tab:
   • Usually, no changes are needed here.
4. Balances Tab:
   • This tab shows transactions for the customer (empty for new customers).
5. Notes Tab:
   • Add any notes relevant to the customer account.

Final Steps

1. Save the Customer Account:
   • Once all details are entered, click on Save to create the customer account.
2. Creating Another Account:
   • Click on Add to start creating another customer account.

Creating customer accounts in Sage Pastel Partner is crucial for several reasons:

1. Transaction Tracking: Customer accounts allow you to track all transactions related to a specific customer in one place. This includes sales, payments, credits, and refunds. By organizing transactions within customer accounts, you can easily monitor customer activity and history.
2. Accuracy in Financial Reporting: Customer accounts provide accurate data for financial reporting and analysis. With each transaction recorded against the respective customer account, you can generate detailed reports such as sales summaries, aging analysis, and customer statements. This level of detail ensures accurate financial reporting and helps in decision-making processes.
3. Credit Management: Customer accounts help in managing credit terms and limits effectively. You can set credit limits for individual customers and monitor their outstanding balances. This helps in controlling credit risk and ensures timely payment collections.
4. Customer Relationship Management (CRM): Maintaining customer accounts facilitates better customer relationship management. You can store contact information, preferences, and notes about individual customers, enabling personalized communication and service delivery. This strengthens customer relationships and fosters loyalty.
5. Efficient Order Processing: Customer accounts streamline the order processing workflow. By associating each order with a specific customer account, you can easily process orders, generate invoices, and track deliveries. This enhances operational efficiency and reduces errors in order fulfillment.
6. Compliance and Audit Trail: Customer accounts contribute to regulatory compliance and audit trail requirements. By accurately recording all customer-related transactions, Sage Pastel Partner helps in demonstrating compliance with accounting standards and regulatory requirements. Additionally, it provides an audit trail for internal and external audits, ensuring transparency and accountability.

In summary, creating customer accounts on Sage Pastel Partner is essential for maintaining organized financial records, managing customer relationships effectively, and ensuring compliance with regulatory standards. It enables businesses to track transactions, manage credit, streamline operations, and make informed decisions based on accurate financial data.