Caseware Working Papers | What information do I require to complete the dialog for the Pastel Evolution Direct Import into CaseWare?

Published: 18/08/2023

What information do I require to complete the dialog for the Pastel Evolution Direct Import into Caseware?

Answer:

You will be required to review information on the following three settings:

1. Import settings

You are required to obtain the following information to connect to SQL server:

Please contact your appointed Pastel Evolution Administrator or the Pastel Evolution Support Desk should you require assistance on how to select and connect to the correct server details.

Server and SQL Server Details
Port Number
Evolution Database User Name / ID
Evolution Database Password

2. General Ledger Account Number Setup

Caseware Working Papers requires you to specify your general ledger structure, also referred to as your chart of accounts which forms the basis of your annual financial statements.

Please contact your appointed Pastel Evolution Administrator or the Pastel Evolution Support Desk should you require assistance with identifying the correct general ledger structure and account information.

There are two general ledger setup scenarios available in Pastel Evolution, namely, the

Standard General Ledger Structure (Master – Sub); and
Segmented General Ledger Structure (Consisting between 0 – 10 segments).

The following table explains the difference between the general ledger structures as well as defines the Caseware requirements for a successful import:

3. Accounting Period settings

Caseware Working Papers requires you to specify the current year of processing in order to import information from Pastel Evolution successfully. Pastel Evolution keeps records for up to 5 years of financial data, before you can purge selected years to open another year. This feature requires you to activate periods for processing or block certain periods to avoid transactions being processed in the incorrect period.

To access your accounting periods, go to the Common module...Company Details...Accounting Periods tab.

Please contact your appointed Pastel Evolution Administrator or the Pastel Evolution Support Desk should you require assistance with identifying the correct processing period.