CALL US: 1-855-255-2466
0 item(s)
12.5.19 - Analyzing Bank Statements Using Excel-Based Tools (Live Webinar) 1 CPE / 1 CLE

12.5.19 - Analyzing Bank Statements Using Excel-Based Tools (Live Webinar) 1 CPE / 1 CLE

Your Price $19.99
In Stock.
Course Number:ACC125-W
  • When:Thursday, December 5th, 2019. 12:00 PM to 1:00 PM EST
  • Location:Your home or office
  • CPE Credits:1 Accounting CPE
  • CLE Credits:1 Substantive CLE
  • Delivery Method:Group Internet-Based

Analyzing trends in smaller firms without extensive accounting reporting systems likely requires the usage of company bank statements. However, analyzing bank statement data is often difficult. In this session, we will discuss how to validate and normalize data, identify key trends, and uncover suspicious transactions. Participants will also learn about how to develop pivot tables to highlight important data points.

Learning Objectives:

  • Examine how to convert bank and credit card statements to Excel
  • Validate and normalize firm data
  • Identify sources and uses of funds
  • Review key trends in converted information

When: Thursday, December 5th, 2019. 12:00 PM to 1:00 PM EST
Where:Your home or office
Speaker: Barbara Steinberg
CPE Credits: 1 Accounting CPE
CLE Credits: 1 Substantive CLE
Program Level: Basic
Prerequisites: None
Advanced Preparation: None
Delivery Method: Group Internet-Based
Tech Support: Bill Kline Email: [email protected] or Phone: 267-251-3805

The Presenter:
Barbara has been an entrepreneur for many years starting businesses in technology, financial services, and elder care financial planning. For the past 10 years, she has been helping the elderly and their families apply for Medicaid to pay for their long-term care. Medicaid applications require the analysis of 5 years of bank and other financial statements. While watching her employees struggle with this tedious, labor-intensive process, she said, “there has to be a better way”. Her search led her to Altia-ABM, a Scottish Financial Fraud Detection software company in business since 2002, whose customers include law enforcement, government agencies, accountants and attorneys.

Barbara likes to compare herself to Victor Kiam, who said, “I liked the shaver so much, I bought the company”. While she didn’t buy the company, she was so happy as a customer of Altia-ABM that she stepped up to be their U.S. reseller. Barbara holds a B.S. in Medical Computer Science from SUNY Downstate Medical Center, an M.S. in Electrical Engineering (Biomedical Engineering) from Columbia University and an MBA in Management of Science and Engineering from Fairleigh Dickinson University.

McDevitt & Kline, LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: https://www.nasbaregistry.org/

* McDevitt and Kline's live, internet-based courses are approved as Distance Learning courses by the PA Supreme Court CLE Board. For additional information, please visit http://www.pacle.org/. Check with your State CLE Board for rules pertaining to live webcasts. These rules differ from state to state. For example, PA attorneys may earn up to 6 CLE credits per compliance period via live webcasts (or 6 out of 12 credits per year); NJ and DE attorneys may earn up to 12 CLE credits per compliance period via live webcasts (or 12 out of 24 credits per two years).

Related Items

Recently Viewed Items