...

Description:  In this guide you , the user will learn about the Payroll Module.

Roles Required: Superuser, Payroll

Permissions Required:  N/A

Overview 

The payroll module  The Payroll Module allows users with Payroll Role the payroll role to review, batch, process, approve , and reconcile entries for Payroll payroll purposes. The system will generate a Payroll payroll file with all necessary data that can be used to create the document documentation needed to send to funding sources for payment. 

Employee punches can be processed in payroll batches and exported on a transmit file that can be imported into the company’s payroll system. The Payroll Module payroll module includes the following functions:

• Batches: Create payroll batches
• Punch Entries: View, search, and batch punch entries
• Payroll Entries: View and search for payroll entries
• Previously Paid Entries: View, search, and batch previously paid entries
• Employees: Search employees and view employee’s details, and
• Reconcile: Reconcile payroll batches

Roles Required: Superuser, Payroll

Permissions Required:  N/A

Batches 

Create New Batch 

The Batches function is the The Batches function is the landing page for the Payroll Modulepayroll module. The table will list every batch all batches in the system. Use the filters to search for a particular batch. Batches can be created from either the Batches screen page or the Punch Entries screenpage.  

To create a new batch from the Batches screenpage: 

1. Login Log in to DCI with an appropriate profile  
2. Click Payroll on the Main Menumain menu 
3. Click Batches on the submenu 
4. Click Actions, then
5. Select New Payroll Batchfrom the drop-down menu
6. Complete the Create Batch wizard
   1. Name (required): Give the batch a name that can be recognized easily  easily recognized 
   2. Description (optional)  : This could include the dates of the payroll period
   3. Up to Date (required): Specify Up to Date: specify the range of entries you want to include in the batch. The up-to-date will be the latest date of service included the . The system will include any available entries prior to before that date.  
   4. Cost   Cost Center Code (optional): leave Leave blank to include all cost centers, use a wildcard to include cost centers that start with the same characters (i.e., to include all AZ cost centers, type AZ*), or type a specific cost center.  
   5. Account Type (optional): The service account type
   6. Profile Type (optional): Select the program or profile type
   7. Service Code (optional): leave Leave blank to include all service codes for the specified funding source and units (see below), and use a wildcard to include service codes that start with the same characters (i.e., to include all 151 service codes, type 151*), or type a specific service code  code.  
   8. Employee Type (Optionaloptional): Type of employee (i.e., hourly non-exempt, contractor, etc.)
   9. Entry Type (optional): Type of entry (i.e., punch, reimbursement, vendor, etc.)
   10. Unit Type: Type of unity unit (i.e., hourly, dollar, etc.  ) 
   11. Employee Name: Process a batch for a specific employee
7. Click Next to review the Batch Summary page
8. If the batch looks is correct, click Save Click Yes on the confirmation alert  and Yes to confirm.

The batch is now submitted, and the system will take you to the Batch Details page with the batch in Pending Status shows the batch details page. The batch is in pending status and must be validated. Process as normal. 

Create New Batch

...

The Batch Details Page will show: 

• Actions Menu 
  • New Note 
  • New Attachment 
  • Edit Batch: change the name and description of the batch 
  • Edit Custom Field Values: add additional batch fields specific to your company 
• Green button: The label will change depending on what status the batch is in 
• Batch Details window 
  • Batch id: unique system id number 
  • Date: date the batch was created 
  • Status: current status of the batch 
    • Pending 
    • InProcess or Process Started 
    • Validate
    • Processed 
    • ApproveInProcess 
    • Approved 
    • Transmitted 
    • Reconciled 
  • of Credit Entries: total number of positive entries 
  • of Debit Entries: total number of negative entries 
  • Credit Total: total amount of positive entries 
  • Debit Total: total amount of debit entries 
  • Rounded Amount: total amount rounded (this plus the debit total should equal credit total)   
  • of Employees/Vendors: total number of Employees/Vendors who have entries in the batch 
  • Units: unit type 

Batch Processing

To process a batch, simply click on the green button. As you click on the button, it will change names as it completes that process. When it is greyed out, the process is running, and the batch is not ready for the next step. Refresh your browser to update status. Here are the steps:

• Click Validate and then select Yes to confirm batch when prompted
  1. The batch details status is Pending
  2. During the Validate Batch process you can review, remove entries or split the batch by scrolling down and reviewing the entries, then selecting the entries you would like to remove or split into a new batch.
     1. Once the entries are selected either select remove to remove them from the current batch or split to split the selected entries to a new batch.

• Click Process and then select Yes to process batch when prompted
  1. The batch details status updates to Validate
     1. You may have to select Refresh to change batch processing status.
  2. While the green button is greyed out, the batch is processing, and Refresh can update status.
  3. Once a batch has been processed, it needs to be approved.
• Click Approve and then select Yes to confirm batch when prompted
  1. The batch details status changes to Processed
     1. You may have to select Refresh to change batch processing status.
  2. Once approved has finished processing, the status changes to Transmitted

Batch Processing is now complete. While you are in the Batch Details screen, this is a perfect time to edit or override entries that have just been processed.

Edit/Override Batch Entry

Processing the batch will create payroll entries for each punch entry. Payroll overrides can be made once the batch is processed. To do an override:

• Use the filters to find the payroll entry in question from the Batch Details screen
• Click anywhere on the entry to override to open the Payroll Entry Detail screen
• Click Actions
• Click Edit Entry
  1. On the Edit Entry wizard, you can add an override for the payroll modifier, the payrate, or pay units.
• Enter the desired information then click Save.
• Click Approve and then Yes to override the entry

The overrides will appear on the entry details page, as well as be applied to the transmit file after the batch is approved.

Create New Batch – Bulk

To create a new batch in bulk from on the Batches screen:

by Punch Entries

The Punch Entries submenu tab within the payroll module lists all entries that are ready to be processed or have already been processed in a payroll batch. Entries that have been approved and do not violate an authorization max (remaining balance, daily max, weekly max, or monthly max) will appear in this table. Entries include:  

• Hourly Punch Entries  
• Residential Program Attendance Entries  

• Residential Program Absent Entries  
• Day Program Attendance Entries  
• Group Service Attendance Entries  
• Parenting Program Attendance Entries  
• Parenting Program Absent Entries  

• Client Transportation Entries  
• Transportation Entries  
• Vendor Payment Entries  

New payroll batches can be created directly from the Punch Entries page:  

1. Log in to DCI with an appropriate profile
2. Click Payroll on the main menu
3. Click Punch Entries on the submenu 
4. Select the header check box to select all listed entries, or select the check box next to each entry to include in the batch  
5. Click New Batch
6. Enter a name for the batch (required) and a description (optional)
7. Click Next
8. Review the entries and click Save

The batch is now submitted, and the system shows the batch details page. The batch is in pending status and must be validated. Process as normal.

Create New Batch by External File

To create a new batch from an external file on the Batches page:

1. Log in to DCI with an appropriate profile
2. Click Payroll on the main menu
3. Click Batches on the submenu
4. Click Actions
5. Select New Payroll Batch from the drop-down menu
6. Add batch name (required) and description (optional)
7. Click Add From File
8. Click Upload tab delimited TXT file and locate the .txt file to upload
9. Click Open
10. Click Next
11. Review batch summary
12. Click Save and Yes to confirm

The batch is now submitted, and the system shows the batch details page. The batch is in pending status and must be validated. Process as normal.

Add Entries to Existing Batch

To add entries to an existing batch from the Punch Entries page:

1. Log in to DCI with an appropriate profile
2. Click Payroll on the main menu
3. Click Punch Entries on the submenu
4. Click the check box next to the entries to add
5. Click Add to Existing Batch
6. Select the batch to add the entries to
7. Click Save and Yes to confirm

The batch is now submitted, and the system shows the batch details page. The batch is in pending status and must be validated. Process as normal.

Remove Entries from Existing Batch

Entries can be removed from an existing batch before the batch is processed:

1. Log in to DCI with an appropriate profile
2. Click Payroll on the main menu
3. Create a batch and follow the steps to arrive at the Process Batch page
4. Before processing, scroll down to the bottom of the page to review the entries.
5. Click the checkbox next to the entries to remove
6. Click Remove and Yes to confirm

The entry is now removed but is available for processing for future batches. Continue processing the batch as normal.

Split Batch

Batches can be split from an existing batch before the batch is processed:

1. Log in to DCI Login with an appropriate profile
2. Click Payroll on the Main Menu
3. Click Actions, then New Payroll Batch
4. Complete the Create Batch wizard
   1. Name: Give the batch a name that can be recognized easily
   2. Description (optional)
   3. Up to Date: specify the range of entries you want to include in the batch. The up to date will be the latest date of service included the system will include any available entries prior to that date.
   4. Funding Source: one batch will be created per funding source.
      1. To create a bulk batch for the funding source, do not specify any further criteria, skip to step 5
   5. Cost Center Code (optional): leave blank to include all cost centers, use a wildcard to include cost centers that start with the same characters (i.e. to include all AZ cost centers, type AZ*), or type a specific cost center.
   6. Service Code (optional): leave blank to include all service codes for the specified funding source and units (see below), use a wildcard to include service codes that start with the same characters (i.e. to include all 151 service codes, type 151*), or type a specific service code
   7. Account Type
   8. Client Name (optional): leave blank to include all clients or type a specific Client Name.
   9. Units: Only one unit type can be included in a single payroll batch.
5. Click Next
6. On the Batch Summary page, review the information, then click Save.
7. Click Yes on the confirmation alert
8. The system will take you to the Batch Details page with the batch in Pending Status.

Create New Batch – Specific Entries

To create a new batch from specific entries on the Punch Entries screen:

1. Login with an appropriate profile
2. Click Payroll on the Main Menu
3. Click Punch Entries on the Sub Menu
4. Click the check box next to the entries you would like to add
5. Click New Batch
6. Enter a Name for the batch
7. Review the Entries Click Save
8. The system will take you to the Batch Details page with the batch in Pending Status

Create New Batch – External File

To create a new batch from an external on the Batches screen:

1. Login with an appropriate profile
2. Click Payroll on the Main Menu
3. Click Actions, then New Payroll Batch
4. Complete the Create Batch wizard
5. Click Select from Add From File
6. Click Upload Tab Delimited Text File and locate the .txt file on your local computer that you would like to upload
7. Click Save
8. Complete the form wizard
9. Click Save
10. If the batch looks correct, select the checkbox on the Batch Creation page
11. Click Next
12. On the Batch Summary page, review the information, then click Save.
13. Click Yes on the confirmation alert
14. The system will take you to the Batch Details page with the batch in Pending Status.

Add Entries to Existing Batch

To add entries to an existing batch from Punch Entries screen:

1. Login with an appropriate profile
2. Click Payroll on the Main Menu
3. Click Punch Entries on the Sub Menu
4. Click the check box next to the entries you would like to add
5. Click Add to Existing Batch
6. Click on the batch you would like to add the entries to
7. Review the Entries Click Save
8. The system will take you to the Batch Details page with the batch in Pending Status.

Remove Entries from Existing Batch

Entries can be removed from an existing batch before the batch is processed. As we have discussed earlier in this module, batches can be created in bulk, from payroll, from an external txt file, or from punch entries. Batches may also be split or merged. Later in this module, we will get to the Process Batch section. Before a batch is processed, you will have  the ability to review and remove entries if necessary. Regardless of batch type, once a batch is created, they all follow the same processing steps. Here is how you remove entries from an existing batch before it is processed:

1. Login with an appropriate profile
2. Click Payroll on the Main Menu
3. Create a batch and follow the steps to get to the Process Batch screen
4. Before you process the batch, scroll down to the bottom of the screen to review the entry
5. Click on the checkbox next to the entry you would like to remove
6. Click Remove
7. Click Yes to confirm

The entry is now removed. The removed entry is available for processing for future batches. Continue processing the batch as normal.

Split Batch

Batches can be split from an existing batch before the batch is processed. As we have discussed earlier in this module, batches can be created in bulk, from payroll, from an external txt file, or from punch entries. Batches may also be split or merged. Later in this module, we will get to the Process Batch section. Before a batch is processed, you have the ability to review and split batches to create two separate batches if necessary. Regardless of batch type, once a batch is created, they all follow the same processing steps. Here is how you remove entries from an existing batch before it is processed:

1. Login with an appropriate profile
2. Click Payroll on the Main Menu
3. Create a batch and follow the steps to get to the Process Batch screen
4. Before you process the batch, scroll down to the bottom of the screen to review the entry
5. Click on the checkbox next to the entries you would like to split
6. Click Split
7. Click Yes to confirm

The batch is now split creating two batches in pending status. The split batches can continue processing as normal.

Merge Two Batches

To merge existing batches from batches screen:

1. Login with an appropriate profile
2. Click Payroll on the Main Menu
3. Locate one of the batches that you would like to merge in the Batches table by using the Search functionality or by scrolling
   1. The batches that you would like to merge must be in a pending status, if it has already been processed, you can no longer merge the batch
4. Click anywhere in the row to open the pending batch to open the Batch Details page
5. Click the Merge button
6. The Merge Batch form wizard will open with a list of available batches to merge
7. Enter a name for the batch
8. Enter a batch description (optional)
9. Select the batch that you would like to merge from the list
10. Click Save

The batch is now merged, continue processing the batch following your normal steps.

Payroll Override

To override the information in a payroll entry before the entry is processed:

1. Login with an appropriate profile
2. Click Payroll on the Main Menu
3. Click Payroll Entries on the Sub Menu
4. Search for the payroll entry that you would like to override
5. Click anywhere in the row to open the entry details
6. Click Actions
7. Click Edit Entry
8. Update the form wizard with the override information
9. Click Save
10. Click Yes to confirm

The payroll override is complete and can be processed as normal.

Reconcile

Payroll batches can be reconciled in DCI after the employee has been paid. This helps track which entries have been paid out. Additionally, it is necessary to reconcile dollar-based entries in a payroll batch in order to give a billable amount to the entry.

Once a Payroll Batch has been processed and approved, the system will generate the Raw Payroll Dump file. This file contains some data that will be required to reconcile the batch. Before we go into the steps of how to reconcile a batch, we will first go through the steps that need to be completed to create the text file that will be used to reconcile a batch.

1. main menu
2. Create a batch and follow the steps to arrive at the Process Batch page
3. Before processing, scroll down to the bottom of the page to review the entries.
4. Click the checkbox next to the entries to split
5. Click Split and Yes to confirm

The batch is now split creating two batches in pending status. Continue processing the split batches as normal.

Merge Two Batches

To merge existing batches from the batches page:

1. Log in to DCI with an appropriate profile
2. Click Payroll on the main menu
3. Locate one of the batches to merge in the Batches table by using the Search functionality or by scrolling
   1. The batches to be merged must be in a pending status. If already processed, they can no longer be merged.
4. Click anywhere in the pending batch row to open the batch details page
5. Click Merge
6. Enter a name for the batch
7. Enter a batch description (optional)
8. Select the batch from the list to merge
9. Click Save and Yes to confirm

The batches are now merged. Continue processing the batch as normal.

Batch Details 

The Batch Details page will show: 

• Actions Menu 
  • New Note 
  • New Attachment 
  • Edit Batch: Change the name and description of the batch 
  • Edit Custom Field Values: Add additional batch fields specific to the organization 
• Green button: The label will change depending on the batch status 
• Batch Details window 
  • Batch id: Unique system id number 
  • Date: Date the batch was created 
  • Status: Current status of the batch 
    • Pending 
    • InProcess or Process Started 
    • Validate
    • Processed 
    • ApproveInProcess 
    • Approved 
    • Transmitted 
    • Reconciled 
  • of Credit Entries: Total number of positive entries 
  • of Debit Entries: Total number of negative entries 
  • Credit Total: Total amount of positive entries 
  • Debit Total: Total amount of debit entries 
  • Rounded Amount: Total amount rounded (this plus the debit total should equal the credit total)   
  • of Employees/Vendors: Total number of employees/vendors who have entries in the batch 
  • Units: Unit type 
• Tabs: Entries, Notes, Attachments, Events, Custom Fields, History

Payroll Override

To override the information in a payroll entry before the entry is processed:

1. Log in to DCI with an appropriate profile
2. Click Payroll on the main menu
3. Click Payroll Entries on the submenu
4. Search for the payroll entry to override
5. Click anywhere in the row to open the entry details
6. Click Actions
7. Select Edit Entry from the drop-down menu
8. Update with the override information
9. Click Save and Yes to confirm

The payroll override is complete and can be processed as normal.

Batch Processing

To process a batch, simply click the green button. The button will change names as it completes the process. When it is greyed out, the process is running, and the batch is not ready for the next step. Refresh the browser to update the status.

To process a batch:

1. Click Validate then Yes to confirm batch when prompted
2. The batch details status is Pending
3. During the Validate Batch process the user can review, remove entries, or split the batch by scrolling down and reviewing the entries, then selecting the entries to remove or split into a new batch.
   1. When the entries are selected, either select Remove to remove them from the current batch or Split to split the selected entries into a new batch.
4. Click Process then Yes to process batch when prompted
5. The batch details status updates to Validate
   1. Refresh the browser to update the batch processing status
6. While the green button is greyed out, the batch is processing. Refreshing can update the status.
7. After a batch has been processed, it must be approved.
8. Click Approve then Yes to confirm batch when prompted
9. The batch details status changes to Processed
   1. Refresh the browser to update the batch processing status
10. When processed, the status changes to Transmitted

Batch processing is now complete. While on the batch details page, edit or override entries as necessary that have just been processed.

Download Raw Payroll Dump File 

If on the final step of processing a batch and have the batch details page open:

1. When a batch has been approved, the green Reconcile button displays, and the batch details status is Transmitted.
2. Scroll down the page to click the Attachments tab
3. Locate the file that begins with RawPayrollDump
   1. Following the name is an underscore followed by numbers to create a unique identifier for each Raw Payroll Dump file
4. Click the Download drop-down and select CSV as the file type
5. Click the blue Download Arrow Icon to start the download
6. Click the downloaded file to open the RawPayrollDump in Excel

If the batch is Transmitted and the raw payroll file was not downloaded during the batch creation process:

1. Select Payroll from the main menu
2. Select Batches from the submenu
3. Use filters to locate the batch and click Search
4. Click anywhere in the batch row to open the batch details page
5. When a batch has been approved, the green Reconcile button displays, and the batch details status is Transmitted
6. Scroll down the page to click the Attachments tab
7. Locate the file that begins with RawPayrollDump
   1. Following the name is an underscore followed by numbers to create a unique identifier for each Raw Payroll Dump file
8. Click the Download drop-down and select CSV as the file type
9. Click the blue Download Arrow Icon to start the download
10. Click the downloaded file to open the RawPayrollDump in Excel

Edit/Override Batch Entry 

Processing the batch will create payroll entries for each punch entry. Payroll overrides can be made after the batch is processed. To complete an override:

1. Use the filters to find the payroll entry in question from the batch details page
2. Click anywhere on the entry to open the Payroll Entry Detail page
3. Click Actions
4. Select Edit Entry from the drop-down menu
5. On the form wizard, add an override for the payroll modifier, the payrate, or pay units.
6. Click Save
7. Click Approve then Yes to override the entry

The overrides will appear on the entry details page, as well as be applied to the transmit file after the batch is approved.

Payroll Entries 

The Payroll Entries submenu tab lists all existing payroll entries. This table is a great way to look up details of individual payroll entries, including status. Payroll entries in approved status can be edited by the following steps:

1. Click Payroll on the main menu
2. Click Payroll Entries on the submenu
3. Filter and search to find the entry to edit
4. Click anywhere on the entry to open the Payroll Entry Detail page
5. Click Actions
6. Select Edit Entry from the drop-down menu
7. Edit as needed
8. Click Save and Yes to confirm

The edits will appear on the entry details page and will be applied to the transmit file after the batch is approved.

Reconcile

Payroll batches can be reconciled in DCI after the employee has been paid. This helps track which entries have been paid. Additionally, it is necessary to reconcile dollar-based entries in a payroll batch to give a billable amount to the entry.

After a payroll batch has been processed and approved, the system will generate the Raw Payroll Dump file. This file contains data that will be required to reconcile the batch. But first, it’s necessary to create the text file that will be used for reconciliation.

The system will start the reconciliation The system will start the reconciliation process. The batch status will update to ReconciliationInProcess. Once When complete, the user can see the view results file under the Reconcile FunctionAttachments tab on that batch page. If all entries were successfully reconciled, the batch status will update to Reconciled.

• If any entry failed reconciliation, the n the Results results file will display the Reconciliation reconciliation status and the reason for failure.

• If entries were successfully reconciled,   then the the results file will list Success as the Reconciliation Status reconciliation status and the entry status will update to Paidpaid.
• The reconciliation process can be automated if desired. When enabled, it will automatically move punches to Paid paid status after the specified number of days after a batch is approved. This process simply changes the status; it does not input any data and will not update the billable amount on dollar-based punches.

Download Raw Payroll Dump File

Follow these steps if you are on the final step of processing a batch and have the Batch Details screen still open. 

• With the Batch Details screen open, once a Batch has been approved, the green button displays Reconcile and the Batch Details status displays Transmitted.
• Scroll to the tabs located under the Batch Details information and click the Attachments
• Locate the file name that starts with RawPayrollDump.
  1. Following the name there will be an underscore followed by numbers to create a unique identifier for each Raw Payroll Dump file.
• Click the Download dropdown and select CSV for the file type.
• Click the blue Download Arrow Icon to start the download.
• Click the downloaded file to open the RawPayrollDump in Excel.

Follow these steps if the Batch is Transmitted and the Raw Payroll File was not downloaded during the Batch creation process:

• Click Payroll on the Main Menu.
• Click Batches on the Sub Menu.
• Search for the batch by typing batch detail information into the search filters and then click Search.
• Click anywhere in the batch row to open the Batch Details
• With the Batch Details screen open, once a Batch has been approved, the green button displays Reconcile and the Batch Details status displays Transmitted.
• Scroll to the tabs located under the Batch Details information and click the Attachments tab.
• Locate the file name that starts with RawPayrollDump.
  1. Following the name there will be an underscore followed by numbers to create a unique identifier for each Raw Payroll Dump file.
• Click the Download dropdown and select CSV for the file type.
• Click the blue Download Arrow Icon to start the download. 
• Click the downloaded file to open the RawPayrollDump in Excel.

Create Reconcile Text File

To create a text file, open excel and create a file with the following headers:

1. PayrollEntryID
   1. The Payroll Entry ID as it is listed in DCI. Create one row per payroll entry.
   2. You must include every payroll entry in the batch.
   3. Required field.
2. PayrollSystemReferenceID
   1. The ID from the payroll engine
   2. Required field.
3. PayrollRefCheckId
   1. The check number that the entry was paid out on
   2. Optional field.
4. UnitAmount
   1. The unit amount as entered on the punch entry. This must match the punch exactly.
   2. Required field.
5. NetPay
   1. The net amount paid to the employee.
   2. Required field.
6. PayDate
   1. The date the employee was paid.
   2. Required field.
7. PayrollBurden
   1. The actual payroll burden for the entry.
   2. Required for dollar-based entries.

Once the Excel file is completed, save it as a Text (TXT) file or it will not be able to be imported to DCI. 

NOTE: The headers must be spelled exactly as listed above or there will be an error when trying to import the text file.

How to Reconcile a Single Batch

Follow these steps if you are on the final step of processing a batch and have the Batch Details screen still open. 

1. With the Batch Details screen open, once a Batch has been approved, click the green button displays Reconcile.
2. The Reconcile from Payroll form wizard opens, complete the following fields:
3. Enter a Ref Reconcile Id (required) - this can be any reference number you choose.
4. File Name (required) - this name will appear in the attachments table to describe the reconcile file
5. Click Add Attachment to attach the Reconcile Text File discuss in the previous steps.
6. Click Save.

The system will start the reconciliation process. The batch status will update to ReconciliationInProcess. Once complete, the user can see the results file under the Reconcile Function.

The Reconcile function may  be done separately from batch processing. It can be done as a single standalone batch or as multiple batches that need to be reconciled.

How to reconcile a Single Batch

• Click Payroll on the Main Menu.
• Click Reconcile on the Sub Menu.
• Search for the file by typing Reconcile Text File into the search filters and then click
• Click anywhere in the batch row to open the Attachment Details
  • If any entry failed reconciliation, the Results file will display the Reconciliation status and the reason for failure.
  • If entries were successfully reconciled, the results file will list Success as the Reconciliation Status.
  • If all entries were successfully reconciled, the batch status will update to Reconciled. If the amount received (as listed in the reconcile file) matches or exceeds.

How To Reconcile Multiple Payroll Batches

Reconciling from the Reconcile tab allows users to reconcile rollups across multiple batches. 

1. Create the Reconcile Text File with the steps listed above.
2. Click Payroll on the Main Menu.
3. Click Reconcile on the Sub Menu.
4. Click Actions and then click Upload Text File from the dropdown menu.
5. The Reconcile file form wizard opens, complete the following fields:
   1. Enter a Ref Reconcile Id (required) - this can be any reference number you choose.
   2. File Name (required) - this name will appear in the attachments table to describe the reconcile file
6. Click Add Attachment to attach the Reconcile Text File discuss in the previous steps.
7. Click Save.

Punch Entries

The Punch Entries tab within the Payroll Module lists all entries that are ready to be processed or have already been processed in a Payroll batch. Entries that have been approved and do not violate an authorization max (remaining balance, daily max, weekly max, or monthly max) will appear in this table. Entries include:  

• Hourly Punch Entries  
• Residential Program Attendance Entries  

• Residential Program Absent Entries  
• Day Program Attendance Entries  
• Group Service Attendance Entries  
• Parenting Program Attendance Entries  
• Parenting Program Absent Entries  

• Client Transportation Entries  
• Transportation Entries  
• Vendor Payment Entries  

New Payroll Batches can be created directly from the Punch Entries function. To do so:  

1. Use the filters to search for the desired punches and click Search
2. Select the header checkbox to select all listed entries, or select the checkbox next to each entry that you wish to include in the batch  
3. Click New Batch to create a New Batch  
4. Complete the wizard to create a New Batch   
5. Click Add to Existing Batch to add the selected entries to an existing Pending Payroll Batch  
6. Click Remove to remove the selected entries from an existing Pending Payroll Batch 
7. Process the batch as normal

...

Create Reconcile Text File

Open Excel and create a file with the following column headers:

1. PayrollEntryID
   1. Listed as Entry Id on RawPayrollDump file
   2. Create one row for each payroll entry in the batch
   3. Must include every payroll entry in the batch
   4. Required field
2. PayrollSystemReferenceID
   1. ID generated from the organization’s payroll system/engine, external to DCI
   2. Required field
3. PayrollRefCheckId
   1. Check number on which the entry was paid, generated from the organization’s payroll system/engine.
   2. Optional field
4. UnitAmount
   1. Unit amount as entered on the punch entry. This must match the punch exactly.
   2. Listed as Pay Units on RawPayrollDump file
   3. Required field
5. NetPay
   1. Net amount paid to the employee, generated from the organization’s payroll system/engine.
   2. Required field
6. PayDate
   1. Date the employee was paid, generated from the organization’s payroll system/engine.
   2. Required field
7. PayrollBurden
   1. Actual payroll burden for the entry
   2. Required for dollar-based entries, optional for all other units
   3. Listed as Burden Multiplier on RawPayrollDump file

Save as a Text (TXT) file to import. 

*Please note: The headers must be spelled exactly as listed above and in the same sequence as listed above or there will be an error when trying to import the text file.

Reconcile a Single Batch

If on the final step of processing a batch and have the batch details page open:

1. On an approved batch, click the green Reconcile
2. Complete the Reconcile from Payroll form wizard
   1. Enter a Ref Reconcile Id (required)– Choose any reference number
   2. File Name (required)– Name that will appear in the attachments tab describing the reconcile file
   3. Click Add Attachment to attach the reconcile text file discussed in the previous steps
   4. Click Save

Reconcile Multiple Batches

Reconciling from the Reconcile submenu allows users to reconcile rollups across multiple batches:

1. Create the Reconcile Text File using the steps above
2. Select Payroll from the main menu
3. Select Reconcile from the submenu
4. From the attachments table, select one or more files to reconcile
5. Click Actions
6. Select Upload File from the drop-down menu
   1. The reconciliation file will include the entries from selected batches
   2. Enter a Ref Reconcile Id (required)– Choose any reference number
   3. File Name (required)- Name that will appear in the attachments tab describing the reconcile file
   4. Click Add Attachment to attach the reconcile text file discussed in the previous steps
   5. Click Save and Yes to confirm

Review Reconciled Batches

1. Select Payroll from the main menu
2. Select Reconcile from the submenu
3. Search for the file by typing reconcile text file name into the search filters and clicking Search
4. Click anywhere on the row in the attachments table to the open results file
5. In the Attachment Details widget, next to the name field, click the blue download arrow icon to start the download.
6. Open the downloaded TXT file
7. Review results file
   1. The first row is headers
   2. Subsequent rows are results for each line on payroll reconcile file
   3. Each row will state Failure or Success at the end of the row (see ReconcileStatus header)
      1. Failures will include a failure reason (see Reconcile Reason header)

Exception Batches

DCI runs payroll validations after the green Validate button is clicked on a pending payroll batch. DCI has the functionality to enable Negative Paycheck Validation, which will check to see if any employee will receive a negative paycheck. The validation checks to see if any employee has a net negative number of hours or miles. Either condition is referred to as an exception.

Exceptions can only occur if previously paid entries for the impacted employee have been canceled or edited, resulting in compensating (negative) entries being pulled into the payroll batch that outweigh the positive entries for the same employee. If an exception occurs, all entries for the impacted employee(s) are removed from the batch and placed into a new batch. The new batch shares the name of the original batch and includes the suffix EXCEPTIONS.

An exception batch can be processed like all other batches in DCI. A payroll user can:

• Add entries to the exceptions batch
• Remove entries from the exceptions batch
  • If desired, negative entries can be removed from the batch so they will be available to pull for the next payroll cycle
• Process the exceptions batch as is

After an exceptions batch is processed, the new negative entries will move to a status of approved, and the original entries will remain in a status of processed. The batch status will show transmitted, and the processing of the exceptions batch is complete

The Payroll Entries function lists all existing Payroll entries. This table is a great way to look up details of individual payroll entries, including status. Payroll Entries in Approved status can be edited by the following steps:

1. Click Payroll on the main menu
2. Click Payroll Entries on the sub menu
3. Filter and search to find the entry you would like to edit or override
4. Click anywhere on the entry to override to open the Payroll Entry Detail screen
5. Click Actions
6. Click Edit Entry
   1. On the Edit Entry wizard, you can add an override for the payroll modifier, the payrate, or pay units.
7. Enter the desired information then click Save.
8. Click Approve and then Yes to override the entry

The overrides will appear on the entry details page, as well as be applied to the transmit file after the batch is approved.

Previously Paid Entries

The Previously Paid Entries function submenu tab lists all entries that have been compensated (edited or canceled) after being processed in a payroll batch. This may occur if an error was noticed some time after the payroll process was completed. Previously paid entries also appear on the Punch Entries page, but the Previously Paid Entries function allows area provides a quick way to find specific entries, as well as an easy way to batch compensating and corrected entries together. New Payroll Batches payroll batches can be created directly from the Previously Paid Entries function. To do soarea:  

1. Use the filters to search for the desired punches and click Search
2. Select the header checkbox to select all listed entries , or select the checkbox next to each entry that you wish to include in the batch  batch 
3. Click New Batch to create a New Batch  
4. Complete the wizard to create a New Batch   
5. Click Add to Existing Batch to add the selected entries to an existing Pending Payroll Batch  
7. Enter batch name (required) and description (optional)
8. Click Next
9. Review batch summary
10. Click Save and Yes to confirmClick Remove to remove the selected entries from an existing Pending Payroll Batch 
11. Process the batch as normal

...

Employees

The Employee functions allow Employees submenu tab allows users with Payroll Role the payroll role to quickly search for information they might need regarding employee account information.   View filenamePayroll Module - Admin Guide.pdfheight250

Related articles

...