You can use Oracle Payroll in combination with Oracle Cash Management to verify that payments have been processed. The process is:
1. Import the bank statement. You do this in Oracle Cash Management.
See: Importing Bank Statements, Oracle Cash Management User Guide 2. Run the automatic reconciliations process. You do this from Oracle Cash
Management.
See: Reconciling Bank Statements Automatically, Oracle Cash Management User Guide.
3. View the results of the reconciliation process. You can do this either through Oracle Payroll, or Oracle Cash Management.
To do this in Oracle Payroll, see: Viewing Payroll Process Results, page 4-13 In Oracle Cash Management, you can view the following reports:
• The Available Transactions report.
• The AutoReconciliation Execution report
4. Identify any payments that are marked in error, and reconcile them manually.
Note: If you are using Oracle Payroll with Oracle Cash Management for the reconciliation of payments then you will need to set up accounting reference data when you are setting up Oracle Cash Management
See: Accounting Reference Information for Cash Management Integration, Oracle HRMS Implementation Guide
Setting Up Exception Reports
You use exception reports to identify potential overpayments or underpayments before they occur. You can specify the amount, or percentage that will cause an exception to be noted. If you run your exception reports immediately after the payroll run you can identify discrepancies and avoid the retrospective corrections necessary when a wrong payment has already been made.
To create an exception report:
Use the Exception Reports window to create an exception report 1. Select Add Another Row
2. Enter the report name. You can enter any name that meets your reporting requirements - there is no standard format.
3. Select the balance that you want to report on. You can enter a predefined, or user-defined balance.
4. Select the balance dimension that you want to report on. There are some dimensions that you must select when you choose a particular comparison type:
Balance Dimension When to Select these Dimensions
_ASG_MONTH, _PER_MONTH You must select one of these dimensions if you want to use the Average in Months comparison type. These dimensions are not available for Japanese Payroll.
_PER_QTD, _ASG_QTD You must select one of these dimensions if you want to use the Average in Quarters comparison type. These dimensions are not available for Japanese Payroll.
_PTD You must select this dimension for the
comparison types Average of Previous Periods, Average of Previous Paid Periods, Average of Total Periods in Days, and Average of Paid Periods in Days. This dimension is not available for Japanese Payroll.
_ASG_MTD_JP You must select this dimension if you want
to use the Average in Months comparison type. This dimension is available for Japanese Payroll only.
_ASG_QTD_JP You must select one of this dimension if you want to use the Average in Years comparison type. This dimension is available for Japanese Payroll only.
ASG_PROC_PTD You must select this dimension for the
comparison types Average of Previous Periods, Average of Previous Paid Periods, Average of Total Periods in Days, and Average of Paid Periods in Days. This dimension is available for Japanese Payroll only.
5. Select the comparison type.
Comparison Types for Exception Reporting
This table lists each comparison type that you can select, and explains how it operates as a basis of comparison
Comparison Type How it Operates as a Basis of Comparison
Current Period Identifies any exceptions within the current payroll period. Does not use any previous period as a basis for comparison
Previous Period Uses the previous period as a basis of comparison
Previous Month Uses the previous month as a basis of comparison
Previous Quarter Uses the previous quarter as a basis of comparison
Previous Year Uses the previous year as a basis of
comparison
Average in Months Compares the current month-to-date with the average of previous months-to-date. Only available if you have the balance dimensions ASG_MONTH or _PER_MONTH.
Average in Quarters Compares the current quarter-to-date with the average of previous quarters-to-date.
Only available if you have the balance dimensions _PER_QTD or _ASG_QTD Average of Paid Periods in Days Compares the current period with
the number of previous pay period included within the specified number of days. However, only includes those pay periods in which an employee actually received payment. Only available for _PTD dimensions.
Average of Previous Paid Periods Compares the current period with the number of previous periods in which the employee actually received payment for _PTD dimensions only.
Average of Previous Periods Compares the current period with previous periods for _PTD dimensions only
Average of Total Periods in Days Compares the current period with the number of previous pay periods included within the specified number of days. Only available for _PTD dimensions.
1. Enter your comparison value. For example, if you select 3, when your
comparison type is Average in Quarters, this means that your current quarter is compared to the average of the previous three quarters
Some comparison values are preset and you cannot change them:
• Current period always has a comparison value of 0.
• Previous Period, Previous Month, Previous Quarter and Previous Year all have a comparison value of 1.
2. Select your variance type. This must be either percentage or amount.
3. Enter a variance operator
Variance Operators and How You Can Use Them
You can choose one of the following variance operators. The Exception
Reporting Output column indicates the effect of selecting each variance operator assuming that:
• Comparison Type is Previous Period
• Previous period amount is 10,000
• Variance Value is 1000
Variance Operator Exception Report Output
Variance (+/-) All assignments that either exceed or are less than the previous period amount by the amount or percentage stated in the variance value. So, Variance Value (+/-) returns all assignments having a value between 9000 and 11000
Less than All assignments that are less than
the previous period amount by the amount or percentage stated in the variance value. So, Less than returns all assignments having a value of less than 9000
Less than or equal All assignments with a current value either equal to or less than the previous period amount by the amount or percentage stated in the variance value. So, Less thanor equal returns all assignments having a value of 9000 or less
Equal All values that are exactly equal to the
higher limit or the lower limit of the variance value. So, Equal returns all assignments having a current value equal to 9000 or 11000.
Greater than All assignments that are greater than the previous period amount by the amount or percentage stated in the variance value. So, Greater than returns all assignments having a value of more than 11000
Greater than or equal All assignments with a current value either equal to or greater than the previous period amount by the amount or percentage stated in the variance value. So, Greater than or equal returns all assignments having a value of 11000 or more.
1. Enter a variance value, unless your comparison type is previous payroll period.
For all other comparison types you can specify the exact percentage, or the numerical value depending on which variance type you choose. In subsequent exception reports you can change your variance values in the SRS window when you are running the report.
For examples of how to set exception reporting to identify particular exceptions, see Examples of Exception Report Setup