Dillner's Accounting Tools > section > Imports
Use the Consolidate Payroll function if payroll for one business entity is processed in separate company files and must be combined periodically for the purpose of producing payroll reports and forms for the business. WARNING: Doing payroll processing in separate files, then combining them is not a recommended way to handle payroll and is done at your own risk. It is impossible for the program to anticipate limits for an employee or for the entire company when only part of the overall data is available in an individual file. Note: Only employees with the same Lookup and same social security number will be merged into one employee record in the combined file. Note: A ‘Not Responding’ message in the Windows Task Manager does not mean that the program is not working. A dialog box will appear when the process is complete. DO NOT end the task or interrupt the import. This process can take anywhere from several minutes to a few hours depending upon the speed of your system and the amount of data to be consolidated. Note: If duplicate employee records exist because the employee Lookup was not exactly the same, use Utilities>Search Company Contacts - Merge contacts to merge the employee records. Identify all employees that work in multiple companies. Make sure that the Lookup in the Contact Manager is exactly the same for the employee in all company files that the employee has worked in. Note: Only employees with the same Lookup and same social security number will be merged into one employee in the combined file. Note: A ‘Not Responding’ message in the Windows Task Manager does not mean that the program is not working. A dialog box will appear when the process is complete. DO NOT end the task or interrupt the import. This process can take anywhere from several minutes to a few hours depending upon the speed of your system and the amount of data to be consolidated. Note: If duplicate employee records exist because the employee Lookup was not exactly the same, use Utilities>Search Contacts - Merge contacts to merge the employee records. A batch name will be assigned to to each transaction. The batch name will follow the pattern CPX aaaaaaa YYYY- MM. The first section, CPX stands for Consolidate Payroll Summary, followed by the Company Name (aaaaaa), Transaction Year (YYYY) and Transaction Period (MM). To delete all transactions imported in a batch, select File>Imports>Consolidate Payroll. Select the Batch to be deleted in the Undo by batch field and select Undo. Batches that have been imported in prior periods cannot be undone. Select File>Imports>Consolidate Payroll and reimport any necessary data. Additional filters may be set to zero in on particular transactions.
Consolidate Payroll
Preparing to Consolidate Files
Before the First Consolidation
Subsequent (Monthly or Quarterly) Consolidations
Batch
Undo by Batch
View Imported Transactions
Comments
0 comments
Article is closed for comments.