Saturday, September 25, 2021
You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

How to Set Up an Automatic Error-Checking System in Excel Reports

Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...
How to aggregate named groups of GL accounts.

How to Report GL Account Groups in Excel

Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...
In Excel, you can report named groups of GL account numbers, product codes, and so on—just as you report one such number. Here’s how.

How to Use Array Formulas to Report Groups of Accounts

Often, in accounting, marketing, and other departments, we'd like to report and analyze groups of items rather than one item at a time. In Part...
Here's how to add sources and uses of funds to your company's Balance Sheet in Excel to get a clearer picture of how the changes affect your cash flow.

Use this Excel ‘Cash Flow Balance Sheet’ to See Sources & Uses of Funds...

For most businesses, cash flow is more important than profits and losses. The reason is clear. A profitable company with negative cash flows may not...
If you track Accounts Receivable the way most companies do—with Days Sales Outstanding in Receivables (DSO)—you probably know less about your receivables than you think. There's a better way, which also can improve your cash flow forecasts.

Use Excel to Fix Your Broken AR Measure of Days Sales Outstanding in Receivables

During tough economic times it's particularly important to manage your Accounts Receivable balance carefully. Unfortunately, the traditional way to measure AR performance is badly...
Your Return On Equity ratio is a key indicator of financial health. This report lets you show the components of that ratio in a unique Excel display.

Map Your Financial Health With an Excel DuPont Dashboard

Management reporting is all about communication. Reporting Return On Equity (ROE) is a case in point. The ROE financial ratio is a key measure of...
In finance, breakeven charts illustrate how your fixed and variable costs vary with your monthly sales. Here's how to set up break-even charts in Excel.

Map Costs and Sales in Excel with a Classic Breakeven Chart

When I worked as a CFO, my monthly reports always included a breakeven chart. It was one of the most popular reports I produced. But...
Does your company need to make scheduled payments to companies that don't send invoices? This worksheet will help to plan those cash requirements.

Manage Periodic Payments with an Excel Cash Calendar

Most companies must write checks periodically to companies that don't send invoices. Often, their accounting systems provide little help in keeping track of these...
Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

How Fast Is Too Fast?

(Originally published in Inc Magazine.) What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
Here's how to use Excel to figure out whether you're making or losing money on the cash you borrow, why it matters, and what you can do about it.

Weighing Your Debt Load

(Originally published in Inc Magazine.) I've talked to any number of business owners over the years who felt buried under a mountain of debt. But...

Latest Articles

Two unusual formulas can use the SEARCH or FIND functions to search any number of cells for any number of words—almost instantly.

How I Set Up SEARCH and FIND Formulas on Steroids

I've used Excel long enough to recognize when I've stumbled across an unusual formula. And it happened again a few minutes ago. In the past,...
Use this unique Excel dashboard to track the general rate of inflation, your personal rate, and the rate of the goods and services you buy.

Inflation Tracker Excel Dashboard with Consumer Prices

U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats." However, a rising inflationary tide does not lift...
Excel's Quick Access Toolbar can save you many clicks and needless work. Here are the eight QAT tools that I use, and how I use them.

Eight Great Tools for Your Quick Access Toolbar

I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself. Before I get into the...
Advertisement
Advertisement