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.
Leave a comment
You must be logged in to post a comment.
What We Are Writing
- A Marriage of Inconvenience: GSA Schedule Contracts & The Contractor Code of Business Ethics & Conduct Clause
- Emerging Small Businesses: To Grow Your Business, You Must Plan For Growth
- Government Contracting: Look Before You Leap!
- GSA Schedules – Strategies for Success
- New Employee vs. Independent Contractor Considerations
- Pay on Display – Understanding the Executive Compensation and Subcontractor Data Reporting Requirements & Ramifications
- The GSA Schedule: Your Ticket to the Federal Market (May 2010)
- The New FAR Codes of Conduct and Compliance Program Provisions
- The Seven Deadly Sins (of contract compliance)