Setup Task List for Payment Reconciliation

Global Payroll integrates with Cash Management and General Ledger. This integration facilitates the setup of banks, branches, and bank accounts, and the reconciliation of bank statements with payment transactions.

An administrator or implementor with the appropriate privileges performs the tasks shown in this table:

Application	Setup Steps	Task
General Ledger	Create an account combination for the reconciliation differences account.	Account Combinations
Cash Management	Set up transaction codes that map to the payment method transaction codes used in payroll.	Cash Transaction Type Mapping Bank Statement Transaction Codes
Cash Management	Create reconciliation rules.	Bank Statement Reconciliation Tolerance Rules Bank Statement Reconciliation Matching Rules Bank Statement Reconciliation Rule Sets
Payroll	Create liability, cash clearing, and cash accounts for your payment sources. Specify the option Transfer to General Ledger.	Costing of Payment Sources

Reconciliation Differences Account Setup

If you reconcile payment costs before posting the costing results to General Ledger, set up a reconciliation differences account in General Ledger using Account Combinations. The reconciliation differences accounts in Cash Management records discrepancies between the bank statement and the transferred payment files, such as over and under payments.

Payroll Transactions Codes Setup

If you cost your payments, set up and map transaction codes in Cash Management for the organization payment methods.

Task	Action
Bank Statement Transaction Codes	Review the transaction and statement codes that your enterprise currently uses Create transaction codes for the transaction types that support your organization payment methods
Cash Transaction Type Mapping	Map transaction types to payment types used for the organization payment methods that support costing of payments. Identify the organization payment methods for payroll accounts, such as payroll liability, cash, and cash clearing accounts.

Reconciliation Rules Setup

Payroll processes transfer your payment entries to Cash Management for manual or automatic reconciliation with bank statements, and cost the unreconciled and reconciled payments to the appropriate account, such as the cash clearing and cash accounts.

If you reconcile transactions automatically, in Cash Management complete the tasks listed in this table.

Task	Action
Bank Statement Reconciliation Tolerance Rules	Create tolerance rules based on date, amount, or percentage that prevent or warn you when reconciliation exceeds a defined tolerance.
Bank Statement Reconciliation Matching Rules	Define bank statement automatic reconciliation matching rules.
Bank Statement Reconciliation Rule Sets	Assign a group of matching rules and tolerance rules to a bank account for reconciling bank statement lines with transactions.
Bank Accounts	Specify the Reconciliation Differences account you set up in General Ledger..

Payroll Accounts Setup

Create a liability and cash account. Use Costing of Payments to create a cash clearing account to track payments such as checks/cheques, where a delay exists between the date the payment is issued and the date it clears.

Note: When you set up the accounts, it's best practice to enter the same account information that you use for the cash and cash clearing account that you created in General Ledger.