Critics have claimed that traditional managerial accounting is at best useless and at worst dysfunctional and misleading. Today’s general ledger and budgeted spending systems support departmental and “stovepipe” managerial philosophies. In contrast, activity-based cost management (ABC/M) information supports process-based thinking. ABC is a key component of the increasingly popular enterprise and corporate ..
Everything you need to know to have a compliant California payrollAs an employer in California, there is a lot to know about how to properly handle and calculate pay for employees. This webinar will give all the tools necessary to make sure you are in compliance with California state requirements for your employees.Understanding all the rules around overtime pay in CaliforniaUnderstanding special California..
In this beneficial presentation, Excel expert David H. Ringstrom, CPA, introduces you to Excel dashboards. Dashboards are quite popular because they empower users to quickly assimilate large amounts of data by way of charts and summary tables. David demonstrates how to: use Excel’s Pivot Table feature to create charts that display data trends, filter data faster using the Slicer feature in Excel 2010 and la..
Extracting data from text files or from database management systems, such as Microsoft Access or Microsoft SQL Server, can be intimidating to Excel users. In this outstanding presentation, Excel expert David Ringstrom, CPA, walks you through the process of getting the data you need from databases or from text files into Excel. Once your data is in Excel, you can work with it in a variety of ways, such as us..
In this presentation, Excel expert David Ringstrom, CPA, shares a variety of ways you can automate your work in Excel by way of the Custom Views feature—one of Excel’s most overlooked features. Step-by-step, David demonstrates how Custom Views allows you to hide and unhide multiple worksheets at once, set a print range for multiple areas of a worksheet, make a single set of data serve multiple purposes, gai..
In this insightful webcast, Excel expert David Ringstrom, CPA, focuses on alternatives to the VLOOKUP function. While many Excel users rely on VLOOKUP for basic lookup functionality, it’s often because they’re unaware of other functions that can enable them to work more efficiently in Excel. David sheds light on what can go awry with VLOOKUP; explains how to future-proof VLOOKUP; and discusses alternative f..
A Leer, A Pat, A Joke, A Gesture, An Innuendo, A Kiss: Are You Prepared To Be the Next Social Media Blitz, Identified on #MeToo, or a Headline in the Newspaper?
Harvey Weinstein, Matt Lauer, Charlie Rose, Al Franken, Garrison Keillor, members of Congress, and various State lawmakers have been accused of sexual harassment and/or sexual assault. But there is a difference between pulling one’s pants down in front of a female colleague at work and touching a woman on her buttocks during a photo op—isn’t there? What is that difference? Are both examples considered sexua..
When you participate in this enlightening session, you’ll learn from Excel expert David Ringstrom, CPA, a variety of tips and techniques to help you create and automate your Excel charts. David discusses several helpful features, including the Recommended Charts feature, the Slicer feature, the Sparkline feature, the PivotChart feature, and more. In addition, he explains how to avoid repetitive formatting, ..
Why is the Statement of Cash Flows so important and what will you learn from analyzing it. In this session, you will learn about the three parts of the Statement of Cash Flows and we will break each one down accordingly. You will understand that a company can show their sales increasing every year and also show they are making profits. However, if they cannot generate cash flow from their daily operations t..
This session will cover the US Taxation of Expatriates. Specifically, we will focus on the Foreign Earned Income Exclusion, the Foreign Tax Credit and State Tax Issues. During the Foreign Earned Income Exclusion section, we will discuss the two tests to qualify for this exclusion and the additional housing exclusion. During the Foreign Tax Credit section, we will discuss the difference between US and Foreig..
A whistleblower or qui tam action can provide financial rewards to individuals who provide information that a company, hospital or individual has defrauded the government. The primary statutes under which this relief may be sought are the federal and state False Claims Acts (“FCAs”). State and federal governments pay hundreds of billions of dollars each year for pharmaceutical drugs, medical devices, hospit..
What are the rules regarding paying and IRS reporting on Independent Contractors? How do we avoid the IRS CP-2100 (B-Notices)? What if our vendor/payee claims exemption; must we obtain a W-9 anyway? What are the best practices for handling our information reporting obligations? How can we minimize the risk of improper exemption claims by our payees and vendors? Get the answers to these and related questions..
All business produce financial transactions. These transactions are transformed into three financial statements that indicate the financial results produced from these transactions. Results are expressed in required statements: Balance Sheet, Income Statement, and Cash Flow Statement. These statements provide the language that communicates the financial health of the company to its managers and stakeholders..
Expense reimbursement fraud—encompassing the myriad forms of employee travel and entertainment (T&E) schemes as well as Purchasing Card (P-Card) fraud—costs organizations hundreds of thousands, if not millions of dollars per year. According to the Association of Certified Fraud Examiners (ACFE), expense reimbursement frauds result in a median loss of $26,000 per incident and represent 14.5% of all emplo..
In this valuable session, you’ll learn from Excel expert David Ringstrom, CPA, how to create spreadsheets that are interactive, accurate, and user-friendly. David demonstrates a variety of Excel’s form controls and features to control the data input of other users, simplify data entry, preserve key formulas, minimize spreadsheet maintenance, and more. David demonstrates every technique at least twice, first..