|
Commercial Banking Course for Financial Analysts, Collateral Analysts and Auditors
Commercial Banking Course Features:
Work on actual data files that replicate what staff will see out in the field.
Learn the specific calculations and formulas for calculating ineligibles.
Learn specific techniques for detecting fraud at the field level.
Become familiar with different file types as well as re-reporting the data in a format acceptable for analysis.
Export out your findings to Excel, Access or other file types.
Incorporating your data and your analysis requirements is an option for this course and is strongly encouraged.
Upon completion of the course staff will be able to immediately implement Monarch for their field work. 14 CPE Credits Awarded.
Commercial Banking Course Fees:
For the on-site two day course for up to 8 people the fee is $8500.00 with an additional $40 (plus shipping) per trainee for the training manual, plus travel and lodging expenses port to port.
For the web based course, three 4 hour blocks three days in a row, the fee is $7500.00 for up to 6 people plus $40 (plus shipping) per trainee for the training manual. All fees are due 21 days prior to class date.
Class Curriculum: Commercial Banking Course Curriculum.pdf
Also Covered: Basic Course.pdf
Accounts Receivable
Calculate ineligibles per Detailed and Summary AR agings
- re-age data based on invoice or due date (calculate past dues)
- Credits in past dues
- Cross aging reserve
- Foreign AR
- Contras
- Intercompany
- Chargebacks
- Partially paid invoices
- Customer/Vendor same name or address for contra detection
Sort by customer
Top 10 reporting
Pick out transactions for a particular customer
Analyze subsidiary registers or individual transactions
Segregate different transactions (credits from invoices)
Analyze cash receipts
Convert due date to invoice date agings
Sample selection
- Statistical
- High dollar items
- Round dollar items
Inventory
Sort by value
Exclude or include by product codes
Exclude per sku
Refoot and re-extend values
Determine inventory values by location
Item analysis (compare inventory levels)
- Statistical
- High dollar items
- Round dollar items
Accounts Payable
Sort by vendor
Top 10 reporting
Pick out transactions for a particular vendor
Convert due date to invoice date agings and vice versa
Cash
Check register -- sort by big ticket items
Find even or zero cent item
Files/Reports Incorporated
Files used in class:
- AR detail
- AP detail
- Check Register
- Inventory Report
- Invoice Register
- Credit memo register
- Detailed GL or extract of GL (i.e., one account)
Web Based Class Process:
- The training is delivered via Office Live Meeting in three 4 hour blocks, from 8:30 AM to 12:30 PM, three consecutive days.
- Manuals and course exercise files are delivered prior to class date along with detailed installation instructions. These are exercise files only, not the Monarch software.
- The trainee is not required to have Monarch loaded on their computer to view the course. But to do the exercises they must have Monarch running.
- Audio is provided via a telephone conferencing facility.
- This is a very interactive course hands on course, it is NOT a webinar. All trainees complete exercises and projects during the class as part of the course.
- Follow up support is provided at no cost for small to intermediate stage projects.
- At the end of each morning session the trainees are free to go back to their desks and complete their normal days' work, there is no down time due to traveling.
- Upon conclusion of the course the trainees will be up and running Monarch and able to deliver data extractions on their own.
Back to Top
|
