Sep 17, 2012

Aaron Solar

No Comments

 Email This Post

482 view(s)

Simplifying Bank Reconciliations in GCS Premier Using Impromptu

Bank reconciliations are painful enough. However, a quick report in Cognos Impromptu can make the experience less painful.

• In Impromptu, add all of the fields from the Bank Rec File (General Ledger > Bank Reconciliation File – GL23BRF) to the report.
• To make data viewing easier, add the Vendor Name from the Vendor Master File (Accounts Payable > Vendor Master File – AP02VMF).
• Rename the field names if you wish to have a more user friendly report and to save space when printing the report.
• Add filters to the report, such as narrowing down dates in the “BRF Bank Accept Date” field. Filtering the data between 8/1/12 and 8/31/12 will return only items that have cleared the bank account between those dates.
• Group items by Debits (such as cash receipts) or Credits (such as cash disbursements) by using the Transaction Code (Txn Cd) field.
• Adding a subtotal to the BRF Bank Amount field when grouped will facilitate matching items to the bank statement.
• Refresh the data (Ctrl-R) while updating GCS for real time bank rec reporting, or export the data to Excel (File > Save As > Save As Type > Excel With Format).
• If the data doesn’t render correctly, you may need to create a “join” on the Vendor ID field between the Bank Rec File and the Vendor Master File as illustrated below.

Want to learn more about “joins” in Impromptu? Join us for Aronson’s Impromptu 201 webinar on October 3rd highlighting several functions including table joins, custom fields, filter techniques, and prompting.

Register Today!