Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

Accountant's Assistant is provided with the CBS Master License.

Complete each of the following steps to import data from Peachtree versions currently supported by the software provider.

See also: Peachtree data import - overview

Exporting data from Peachtree

1. In Peachtree, open the client whose data you wish to export.
2. From the Peachtree main menu, choose File > Select Import/Export.
3. Repeat steps a through h below for each type of data that you wish to export from Peachtree for subsequent import into Accountant's Assistant. Note that each journal must be exported separately.

   Journal Name	Peachtree Location	Export Filename Required (step 3e)
   Sales Journal	Accounts Receivable	SALES.CSV
   Cash Receipts Journal	Accounts Receivable	RECEIPTS.CSV
   Purchases Journal	Accounts Payable	PURCHASE.CSV
   Payments Journal	Accounts Payable	PAYMENTS.CSV
   Vendor List	Accounts Payable	VENDOR.CSV
   Payroll Journal	Payroll	PAYROLL.CSV
   Employee List	Payroll	EMPLOYEE.CSV
   Chart of Accounts List	General Ledger	CHART.CSV
   General Journal	General Ledger	GENERAL.CSV

   1. Click the appropriate journal in the right-hand list and then click the Export button on the toolbar.
   2. In the Date field, choose This period, or whichever data range you wish to export. (Not applicable to the Chart of Accounts List, Vendor List, or Employee List.)
   3. On the Fields tab, click the Show All button. (The file may not import correctly into Accountant's Assistant unless all fields are included.)
   4. On the Options tab, choose Include Headings. (The file will not import correctly into Accountant's Assistant unless all column headings are included.)
   5. On the Options tab, verify the filename for the export file. (The filename for each journal export file must be exactly as noted above.)
   6. If you are completing this procedure at your own office, click the Import/Export File button and change the path to c:\CLIENTID\ (where c: represents the drive letter where you want the export files to be saved and CLIENTID represents the client's ID in CSA).
   7. Click the Open button.
   8. Click OK to begin exporting the selected journal.

Importing the Peachtree export data into Accountant's Assistant

Please note the following:

• For any transactions entered in Peachtree without a reference, Accountant's Assistant assigns a reference of PT99 during import.
• If you will be importing payroll checks from Peachtree, before starting the import process you must set up at least one checkbook in the CSA Setup > Checkbook dialog.

1. Open the client in CSA and then choose Utilities > Accountant's Assistant > Peachtree.
2. Prior to starting the import, use the Setup > Miscellaneous Information dialog to specify information needed during the import process. The following fields are included on that dialog:
3. Choose Tasks > Retrieve, or click the Retrieve icon on the shortcut bar.
4. In the Peachtree Export File Location dialog, specify both the location of data to import and the Peachtree mask, and then click the Import button.

   Notes

   • The Peachtree client export files must be located in a folder named to match the CSA client ID.
   • The Peachtree mask field is available only if Ls or Ds currently appear in the CSA Chart of Accounts Mask field (on the General Ledger tab of the File > Client Properties dialog).
5. Additional setup dialogs open automatically during the import process. Note that, if necessary, you may return to these dialogs at a later time to adjust the setup information and then re-import the Peachtree export files into Accountant's Assistant.
6. To print or view the transaction and diagnostic reports, choose File > Print Reports.
7. To process the client's transactions, choose Tasks > Process Transactions.
8. After you have finished processing the client's transactions in Accountant's Assistant, choose Tasks > Transfer to CSA.
9. Click the Done button to return to the CSA main window.

Was this article helpful?

Yes No

Submit