Reconciliation Dashboard

The Reconciliation Dashboard is a Bullhorn One tool used to compare and reconcile any transaction mismatches between Bullhorn Time & Expense (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.

  1. In the BTE Time Management Console (TMC), navigate to Maintenance > Administration.
  2. Click Reconciliation Dashboard.
  3. 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.
  4. Click Search.
  5. 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.
  6. 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.
  7. 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.