Step

Previous day electronic bank statements for bank accounts that are part of the UNDP Global Interface are reported and uploaded daily using the following navigation in Quantum: 

Cash Management>Bank Statements and reconciliation. Each bank statement is loaded with a statement ID, statement end date and numbers of statement lines.

Responsible Party

GSSC B2B

Template/Guideline

Explanatory Notes

Establish controls to ensure that uploaded statements match with those reported.

Bank statements may be reviewed in Quantum by using the following navigation.

Reports and Analytics>Browse Catalog>Financial>Cash Management>Bank Statements>

Step

Opening and closing bank balances are also automatically loaded into Quantum. The balances can be viewed at the following navigation in Quantum: Cash Management>Bank Statements and reconciliation>Task Bar>Bank Statements>Manage Bank Statements

Responsible Party

GSSC B2B

Template/Guideline

Explanatory Notes

Opening and closing bank balances may be manually loaded using the following navigation.

Cash Management>Bank Statements and reconciliation>Task Bar>Bank Statements>Create Bank Statements 

Step

Automatic Reconciliation is run as a batch process centrally and reconciles transactions from the most recent bank statements loaded to Quantum with transactions from Accounts Payable (AP), Accounts Receivable (AR) and Treasury (TR) sub modules. 

Responsible Party

GSSC B2B

Template/Guideline

Explanatory Notes

Step

The Automatic Reconciliation Exceptions
For each one to one automatic reconciliation rule, exceptions are looked for in the following order:
1)    Ambiguous - This exception occurs when either there is more than one application transactions that could match to the line or the transaction could match to more than one statement line.
2)    Date - This exception occurs when a system transaction meets all the matching criteria except the date of the transaction is out of the tolerance range. 
3)    Amount - This exception occurs when a system transaction meets all of the matching criteria except the amount of the transaction is outside the tolerance range.

Responsible Party

GSSC B2B

Template/Guideline

Explanatory Notes

Transactions with exceptions are required to be investigated and reconciled by GSSC B2B