Reconciliation Dashboard
The Reconciliation Dashboard is a
tool used to compare and reconcile any transaction mismatches between (BTE) and Pay & Bill data in ATS. This tool is commonly used to:-
Ensure all pay and bill data needed for export is correctly synced over from BTE to ATS.
-
Further identify the reason behind any discrepancies or failures, perform Recalcs, etc.
-
-
Identify any unapproved expense reports.
The Reconciliation Dashboard is a living tool, meaning it's constantly changing as data moves between systems. Due to this, it is not recommended to export data from the Reconciliation Dashboard.
- In the BTE Time Management Console (TMC), navigate to Maintenance > Administration.
- Click Reconciliation Dashboard.
- Fill out the following information on the Reconciliation Dashboard page:
- PPED date range or Sync date range: The date range in which discrepancies will be searched for.
- PPED date range: Includes all Pay Periods that fall within the search parameter (up to 7 days).
- Sync date range: Includes all timesheets sent between the specified dates regardless of Pay Period.
- Exclude Manual / Include Manual: Determines if manual transaction in ATS are included in the discrepancy search.
- All / Only Not Matched: Determines if the results pull in all data or only data that doesn't match between BTE and ATS.
- Include Empty BTE Timesheets: Checking this will include empty BTE timesheets. Useful for cases where a timesheet delete (reopen/reject) did not make it across to ATS.
- PPED date range or Sync date range: The date range in which discrepancies will be searched for.
- Click Search.
- Color coded results are displayed for review in card and table format for easy comparison between Time & Expense (TE) and Pay & Bill (P&B) data across Pay, Bill, and Approval Status categories.
- Red: There is a mismatch between systems.
- Gold / Yellow: An expense report is not approved in BTE.
- To investigate the discrepancy, you can perform the following actions from the Actions button on each line of the table.
- View ATS Transaction: Opens the ATS Pay and Bill transactions in a pop up window.
- Open in Placement Viewer: Opens a popup window of Placement Viewer, with the placement in question already filled in.
- Recalc: Recalculates the timesheet.
- You can also select the Recalculate All Discrepancies button at the top of the results to mass recalc all discrepancies shown in the results.
- Open Timecard: Opens the BTE timesheet in a new window.
- Once you've investigated and corrected any applicable discrepancies, you can reset the dashboard by clicking Reset or enter a new date range to search.
Was this helpful?