Pastel Partner

Accounting Index

Import version	File name	Information imported
Pastel Partner version higher than 3.03:	ACCMAS.DAT	Chart of accounts
	ACCTRN.DAT	General ledger detail (if GL detail button selected)
	ACCPRMGL.DAT	Company profile information
Pastel Partner 3.03:	ACCMAS.DAT	Chart of accounts
	ACCTRN.DAT	General ledger detail (if GL detail button selected)
	ACCPARM.DAT	Company profile information

How to do it:

From the File menu, select Import, and then Accounting Software.
From the Import From drop-down, select Pastel Partner.
From the Version drop-down, select the version of Pastel Partner you want to import. Note that the version number is accompanied by its associated year of release.
In the Import Path field, type or select the exact path where the Pastel Partner file resides. Use the Browse button to locate the file manually.
Under Import Components, choose to import either the Trial Balance or the full General Ledger Detail.
To import client information, select the Import Client Information check box.
If you are importing from version 3.03, do the following:
1. Use the default or type the last income or expense account number from the Pastel file into the Last Income/Expense field.
2. Use the default or type the accumulated income or expense account number from the Pastel file into the Accum Income/Expense box.
If you are importing from other versions, do the following:
1. Use the default or type the customer control account number from the Pastel file into the Customer Control box.
2. Use the default or enter the supplier control account number from the Pastel file into the Supplier Control box.
3. To import prior year data as current year information, select the Import prior year as current year radio button.
  
  Note: As the Pastel file contains only two years of data (current and prior), when you are choosing to import Prior year as current year, please note that there will be no corresponding prior year information imported into the Working Papers file.
If you are importing the current fiscal year data and would like to include budget or prior year balances for comparison purposes, check the applicable boxes. Note that this is only available when the Import current year option is selected.

To import period balances into the Working Papers file, select the check box. The program imports period balances based on the period types designated in the original file. If the period type does not exist in the client file, for example, if importing quarterly balances into a client file that does not have quarterly balances set, Working Papers automatically updates the client file for the new balance type.

If necessary, select the option to ignore the 13th period in the import file.

Imported period balances affect the Working Trial Balance only.

Note: The kind of data that can be added to the file (transactions or period balances) is set in the Engagement Properties Period Balances Tab.
If you are importing from version 4.04 or higher (not 3.03) where the Pastel file account structure is divisional and you want to import the current trial balance or general ledger assigning the divisions to different entities, check the box Use division to build entity.

Note: You must have a consolidation structure set up in Working Papers before importing the Pastel data with this option. Click Cancel and then use the Consolidation function (Engagement | Consolidation) to create the structure.

When the import is processed, an Entity Profile Setup dialog opens to allow you to define the assignment rules (the profile).
If you are importing for the first time from version 6.0 and up when the client file contains accounts imported from previous versions of Pastel, Working Papers checks the length of the existing accounts to see if they comply with the Pastel version's compulsory 7 digit account number structure. If they do, the import proceeds with no user action required. If they do not, the Convert acct. no. by inserting option selects. Select whether to add the extra digit before (leading) or after (trailing) the existing account number. During the import Working Papers searches for and replaces any matching existing 6 digit accounts.

Note: This affects only accounts with entity information during the import.
Click OK to process the import.

A Special note about Pervasive SQL and Windows XP

Notes

Before performing the import, Working Papers checks the dates in the file to see which of the period date sequences (Yearly, monthly, quarterly, etc.) aligns with the file data. If none of the date sequences seem to apply, then, and only then, balances import into Random Periods.
If Working Papers detects that legacy data exists in the file under a Random bucket with twelve periods, upon import it prompts the user if they would like to convert this data to monthly. If the client file already contains data in monthly buckets, Working Papers asks the user if they would like to delete the random bucket amounts instead.