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.

    • All / Only Not Matched: Determines if the results pull in all data or only data that doesn't match between BTE and ATS.

  4. Click Search.

    Manual transactions made in ATS are excluded from search results by default.

  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. Option only visible if you are not Time & Labor enabled.

    • View ATS Timesheet: Opens the ATS Timesheet in a pop up window. Option only visible if you are Time & Labor enabled.

    • 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.