Peachtree/Sage 50 Payroll – Dillner's Accounting Tools

Peachtree© is a registered trademark belonging to Best Software SB, Inc.

Use this import to bring payroll checks issued in Peachtree or Sage 50 into FCA as payroll checks so you can produce payroll tax forms and W2 forms from FCA.

Create File in Peachtree

These instructions are for the 2007 and later versions.

Open the desired client file in Peachtree.
Select Reports & Forms>Payroll.
Select Payroll Journal in the Report List.
Click the Options button in the toolbar.
Enter the desired date range in the From and To fields.
Click the Columns button in the upper right corner of the window.
Verify that Transaction Date, Employee Name, GL Account ID, Transaction Reference and Amount as DR/CR are selected.
Select the Show box for GL Account Description and Field Name.
Click the OK button.
Click the Hide button to hide the report header.
Click the Excel button to create an excel file.
Click OK.
Select Create a new Microsoft Excel workbook and click OK.
When the Excel workbook opens, select File>Save As.
Select the desired path in the Save In: field.
Enter the desired name in the File name: field.
Change the Save as type: to Text (Tab delimited)(*.txt).
Click Save.
When the Microsoft Excel warning about features being not compatible appears, click Yes to continue.
If a dialog box appears asking you to save changes or when one appears when you close Excel, click No.

Import File to FCA™

Note: Before importing payroll checks, Payroll Company Defaults and all employees must be set up. If the client has multiple state payroll, all withholding will import to only one state as there is only one state withholding item in Peachtree. Checks with state withholding amounts for states other than the one selected in the mapping process must be edited after the import.

Select Activities>Import Transactions>Peachtree Payroll.
Click the icon to browse for the desired file.
Verify the date range in the Import transactions from: and through: fields.
Map each Peachtree Payroll Item to the appropriate FCA in the Map To field in the top grid.
Map the client's accounts using the account map grid on the left side of the window, by selecting the FCA Write Up account in the Map To column for each of the client's Peachtree accounts. Click the Fill Map button at the upper right of the window to have the system look for and map all accounts where the account Lookup in FCA matches the account Lookup used in the file being imported.
Click OK to import the data.

Note: Be aware of the Save icon in the toolbar.
FCA will save and remember the mapping for any account which has been previously imported. If it is necessary to cancel an import after some accounts have been mapped, click the Save icon to save the mapping that has been completed.

Cancel—Click the Cancel button to close the screen without importing.
Print—Click the Print button to print the saved mapping for the displayed import.
Fill Map—The program will look for accounts with the same Lookup as the account number in the file being imported and populate the Map To field with any matches.
Export Map—Click the Export Map button to export memorized mappings to a .txt or .csv file.
Undo by Batch—To delete all transactions imported in a batch, select Writeup>Import Transactions>Peachtree/Sage 50 Payroll. Select the Batch to be deleted in the Undo by batch field and select Undo.
Batch—Each import will be assigned a unique Batch name that follows a similar format. Batch PTP 2003 9-1 indicates that the import is the first Peachtree or Sage 50 Payroll import done in period 9 of 2003. If a file is imported in the same period using this import, the batch name would be PTP 2003 9-2.

View Imported Transactions

Select Search Transactions from the Utilities menu.
Clear the Date fields.
Select the Batch from the Batch field drop-down list.

Additional filters may be set to zero in on particular transactions.