...
Description: In In this topic you , the user will learn how to reconcile billing batches . Billing batches can be reconciled in DCI after the company has received payment for services provided. This process helps track which entries are still open or waiting for payment.
Role Required:Superuser/Billing Super User, Billing Team
Permission Required: N/A
Download Raw Billing Dump File
Once After a Payroll Batch payroll batch has been processed and approved, the system will generate the Raw Billing Dump filethe raw billing 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 But first it's necessary to create the text file that will be used to reconcile a batchfor reconciliation.
Follow these steps if you are If on the final step of processing a batch and have the Batch Details batch details screen still open. :
When a batch With the Batch Details screen open, once a Batch has been approved, the green Reconcile button displays Reconcile and the Batch Details status displays Transmittedand the batch details status is transmitted.
Scroll to the tabs located under the Batch Details information and click the down the page to click the Attachments tab.
Locate the file name that starts with RawBillingDump.
Following the name there will an underscore followed by numbers to create a unique identifier for each Raw Billing Dump file.
Click the Download dropdown and select CSV for the file type.
begins with RawBillingDump
Click the Download drop-down and select CSV as the file type
Click the blue Download Arrow Icon to start the downloadClick the blue Download Arrow Icon to start the download.
Click the downloaded file to open the the RawBillingDump in in Excel.
Follow these steps if the Batch is Transmitted and the Raw Billing File If the batch was transmitted and the raw billing file was not downloaded during the Batch batch creation process.:
Select Billing from the main menu
Select Batches from the submenu
Use the filters to locate the batch and click Search
Click Billing 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 screen.the batch details page
When a batch With the Batch Details screen open, once a Batch has been approved, the green Reconcile button displays Reconcile and the Batch Details status displays Transmitteddisplays and the batch details status is transmitted.
Scroll to the tabs located under down the page to click the Batch Details information and click the Attachments tab.Attachments tab
Locate the file name that starts with begins with RawBillingDump.
Following the name there will an underscore followed by numbers to create a unique identifier for each Raw Billing Dump file.
Click the Download dropdown and select CSV Click the Download drop-down and select CSV for the file type.
Click the blue blue Download Arrow Icon to to start the download.
Click the downloaded file to open the the RawBillingDump in in Excel.
Create Reconcile Text File
Open Excel and create a file with the following column headers:
Portal Rollup ID
Required field which is the Rollup ID as listed in the portal.
If reconciling from the batch details page, every rollup in the batch must be listed on the file.
One row per rollup
Listed as Rollup Id on the RawBillingDump
file
Net Amount Required field which is the total
Total amount paid for the rollup
Listed as Net Amount on the RawBillingDump
file
Rollup Reference
Optional field
to add a reference for the rollup ID
GL Code
Required field, but not used by all programs.
Enter NA if not applicable.
Enter the GL code for associated rollup if applicable
Enter NA if it’s not applicable.
Rollup DateRequired field which is the
The date the entries in the rollup were paid
Rollup Reference2
Optional field
to add additional information for the rollup ID
Rollup Reference3
Optional field
...
to add additional information for the rollup ID
Save as a Text (TXT) file to import
*Please note or it will not be able to be imported to DCI. NOTE: The headers must be spelled exactly as listed above and in the same sequential sequence as listed above or there will be an error when trying to import the text file.
Reconcile a Single Batch
Follow these steps if you are If on the final step of processing a batch and have the Batch Details batch details screen still open. :
On an approved batchWith the Batch Details screen open, once a Batch has been approved, click the green button displays green Reconcile button.
The Complete the Reconcile from Billing form wizard opens, complete the following fields:
Enter a Ref Reconcile Id
(required) - this can be - Choose any reference number
you choose.File Name
(required) -
this The name that will appear in the
attachments table to describe Attachments tab describing the reconcile file
Click Add Attachment to attach the
reconcile text file discussed in the previous steps
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.
Open the Reconcile Function
Click on the Attachments tab
Click anywhere on the row in the attachments table to open the results file
In the Attachment Details widget, next to the name field, click the blue download arrow icon to start the download.
Open the downloaded TXT file
Review the results file
First row is headers
Subsequent rows are results for each line on the billing reconcile file
Each row will state Failure or Success at the end of the row (see ReconcileStatus header)
- Failures will include a failure reason (see Reconcile Reason header)
Review Reconciled Batches
Select Billing from the main menu
Select Reconcile from the submenu
Click Billing on the Main Menu.
Click Reconcile on the Sub Menu.
Search for the file by typing Reconcile Text File the reconcile text file into the search filters and then click clicking Search.
Click anywhere on the row in the batch row to open the Attachment Details screen.
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.attachments table to open the results file
In the Attachment Details widget, next to the name field, click the blue download arrow icon to start the download.
Open the downloaded TXT file
Review the results file
First row is headers
Subsequent rows are results for each line on the billing reconcile file
Each row will state Failure or Success at the end of the row (see ReconcileStatus header)
- Failures will include a failure reason (see Reconcile Reason header)
Reconcile Multiple Billing Batches
Reconciling from the Reconcile tab submenu allows users to reconcile rollups across multiple batches.
Create the Reconcile Text File with using the steps listed above.
Log in with appropriate profile
Click Billing on the Main Menu.
Click Reconcile on the Sub Menu.
Click Actions and then click Upload Text File from the dropdown menu.
above
Select Billing from the main menu
Select Reconcile from the submenu
From the attachments table, select one or more files to reconcile.
Click Actions
Select Upload File
The reconcile text file will include the entries from the selected batches
Complete the Reconcile File form wizardThe Reconcile from Billing form wizard opens, complete the following fields:
Enter a Ref Reconcile Id (required) - this can be - Choose any reference number you choose.
File Name (required) - this The name that will appear in the attachments table to describe Attachments tab describing the reconcile file
Click Add
Attachment to attach the
reconcile text file discussed in the previous steps
Click Save
The system will start the reconciliation process. The batch status will update to ReconciliationInProcess. Once When complete, the user can see the results file under the Reconcile Function. Billing Batches Attachments tab on that batch page. Billing batches can be reconciled as many times as necessary.
NOTE*Please note: Write-Off off entries are not reconciled.
Related articles
Content by Label | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...