Importing client data from Peachtree

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

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:

  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.

Top of page

Share This