Setting Up Reconciliation for Payments
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. |
|
Cash Management |
Set up transaction codes that map to the payment method transaction codes used in payroll. |
|
Cash Management |
Create reconciliation rules. |
|
Payroll |
Create liability, cash clearing, and cash accounts for your payment sources. Specify the option Transfer to General Ledger. |
|
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 |
|
Cash Transaction Type Mapping |
|
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.
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.