Modern Financial Modeling Using Special Excel Tools for Budgets, Forecasts and Projections
Joe Weil
100 Min
Product Id: 705898
This training program will help attendees to understand the financial modeling concepts to construct powerful & effective templates and Excel's linear regression analysis to model your firm's sales forecast, identifying key revenue and cost drivers and charting techniques for report forecasting results to top management.
Form W-2 for 2019: All You Need to Know
Vicki M. Lambert
90 Min
Product Id: 703816
This training program will discuss various aspects of the IRS Form W-2 for 2019. The webinar will cover requirements for completing and filing the form including a box by box explanation. Best practices for completing and reconciling the form, and handling duplicate requests from employees will also be covered. The webinar training will further look at when to use the correction Form W-2c and the latest requirements for the Affordable Health Care Act as it relates to reporting requirements on the form.
Excel Dashboard for the Financial Professional - Great for Anyone Interested in Excel Dashboard Techniques
Joe Weil
90 Min
Product Id: 705156
The hallmark of an interactive, data-driven dashboard is the ability to see and understand data at the speed of thought. This training webinar will deliver the skills needed to design well-planned Excel dashboards that present answers to questions in real-time, render visually striking displays, turn insight into action, help accomplish your firm’s objectives and improve your Excel skills. Attendees will be able to define key performance indicators and build a dashboard in Excel to monitor them.
Reimbursing Employees for Expenses: Navigating Taxes
Patrick A Haggerty
90 Min
Product Id: 704194
This training program will engage attendees in a discussion on whether an expense reimbursement qualifies for exclusion from employee wages. It will offer stringent guidelines on what is required to substantiate various expenses and benefits under an accountable plan.
Forecasting with Excel's Powerful Sensitivity Tools - Scroll Bars, Goal Seek, Data Tables, Solver and Scenario Manager
Miles Hutchinson
90 Min
Product Id: 703156
In this financial forecasting webinar learn how to use Excel’s powerful sensitivity tools and design efficient forecasting models. Application of scroll bars, goal seek, data tables, solver and scenario manager. Also received bonus material containing the demo model, complete with instructions for each of these tools!
Best Practices Processes for Travel and Entertainment Expenses - IRS Tax Codes, Audit Tips and Documentation
Candace Leuck
90 Min
Product Id: 704567
This training program is designed to ensure that businesses maximize the available deductions for travel and entertainment expenses. It is important to remain current on these regulations as the Internal Revenue Service focuses a fair amount of effort in this area during audits.
Vendor Fraud - How to Prevent Them for Large scale Companies
Peter Goldmann
90 Min
Product Id: 703157
This training on detecting and preventing vendor fraud will help the attendees to identify the different types of vendor-related fraud schemes and implement best practice anti-fraud control strategies.
Sales and Use Tax - Avoiding Double Tax on Drop Shipments
Miles Hutchinson
100 Min
Product Id: 703616
This webinar will discuss the principles of drop shipment exemption. It will also detail how you can help your company legally avoid tax assessments by your drop shippers on your resale orders.
RFP Fundamentals
Kenneth Jones
60 Min
Product Id: 705499
This webinar will teach you how to craft a Request for Proposal (RFP) with confidence. Contractors will gain insight on how to ask the right questions and what is involved in getting an award through the RFP process.
Same-Day ACH - All You Need to Know
Rayleen M Pirnie
60 Min
Product Id: 705243
In response to the need for faster electronic payments and settlement, NACHA balloted a proposal for Same-Day ACH. The ballot passed and Same-Day ACH is rolling out over a three year span; phase one went into effect in September 2016. Current statistics show that Same-Day ACH is already gaining in popularity, but phase two is just around the corner and presents significantly more risk for all involved. In this training program, participants will grasp the background and basics of Same-Day ACH and learn to analyze the benefits and risks involved.
Mastering Excel Formulas and Functions
Mike Thomas
90 Min
Product Id: 705014
This training program will aid those who use Excel at a basic level and help them learn to create formulas and use some of its built-in functions effectively. The training will be delivered using Excel 2016 for Windows however much of the functionality is also available to users of earlier versions of Excel on both Windows and Mac.
UCC4A Applications to ACH Payments, ACH Fraud Risk Management, and Contracts
Rayleen M Pirnie
90 Min
Product Id: 705386
This webinar will untangle the complexities of UCC4A and how it applies to ACH payments. It will discuss legal and compliance risks presented by UCC4A and provisions impacting potential liability.
Exploring Excel: Data Analysis - Automating Excel-Based Financial Statements
David H Ringstrom
90 Min
Product Id: 705039
This Excel training program will elucidate Excel functions that allow you to quickly create accounting reports. Attendees will learn how to create dynamic reports for any month of the year on one worksheet. They will also receive helpful handouts to help execute their learning.
Tax Refund Fraud: The Fraud that Keeps Getting Worse
Rayleen M Pirnie
90 Min
Product Id: 705134
This training program will help identity frauds that lead to tax refund fraud and discuss funds availability exceptions. It will also discuss common non-post issues, the IRS Opt-In Program and eLeads, refund handling procedures, remedial actions, and suspicious activity reports.
ACH Exception Processing - Part 3: Reinitiation and Reversals
Donna K Olheiser
90 Min
Product Id: 705350
This is the third training session in the 3-part series on Exception Processing. It’s not just about return entries – exceptions are anything that is out of the ordinary ACH processing day-to-day (such as Direct Deposits and Direct Payments via ACH). Reinitiation of Entries and the Reversal process are anything but ordinary; they require knowing what the specifics are and ensuring a financial institution is in compliance with the NACHA Operating Rules.
Strengthening Compliance with Effective AML Analytics, Algorithms, Machine Learning and Data Science
Joe Soniat
60 Min
Product Id: 705143
Learn how effective AML analytics, algorithms, machine learning and data science can strengthen your compliance program. This session will also discuss using analytics to help BSA/AML investigations, how you can use the CDD data gathered along with analytics, model validation and BSA/AML.
Implementing a Risk Management Program - Handbook, Risk Appetite and Risk Culture
Fred Vacelet
60 Min
Product Id: 705115
This training program will review a few ways to ensure that a financial institution reviews things from the start and consistently, in setting up a risk management framework that allows the bank to focus on its strategy rather than mere compliance.
Modeling the Critical Monthly Cash Flow Forecast - Building a Can't Miss Template
Joe Weil
100 Min
Product Id: 704995
From calculating DSO and DSI and planning for seasonal adjustments to using Excel date arithmetic to schedule payables, receivables and cash flow, this training program will assist attendees in effectively constructing the monthly cash flow forecast using Excel.
The IRS is Coming: How to Prepare for the New IRS Partnership Audit Rules
Travis A Greaves,T Joshua Wu
60 Min
Product Id: 705112
The new IRS partnership audit rules require all partnership and LLCs taxed as partnerships to amend their partnership agreement and take action now. In this training program, attendees will learn how these rules impact your business and your clients. The session will discuss IRS issues with TEFRA (Tax Equity and Fiscal Responsibility Act) and detail the concepts and terms in the Bipartisan Budget Act.
SBA: Projecting Cash Flow - Best Practices and Evaluation Techniques
Charles H Green
60 Min
Product Id: 705106
This training program will help attendees recognize the risks of failing to thoroughly vet the information received from a business loan applicant that project future revenues, profits and cash flows. Attendees will also learn to track cash through a business operation, dissect the cash cycle of the operation, and comply with SBA standards concerning expected cash flow attributes of loan applicants.