Percentage of sales method: What it is and how to calculate

Sync data, gain insights, and analyze performance right in Excel, Google Sheets, or the Cube platform.

• Say for example that Jim believes he can increase company revenue (sales) to $400,000 next year.
• Material prices or utility rates could have gone up uncontrollably during the year for example.
• Using the percentage of sales method, you can do just this and determine what percentage or amount of bad debt needs to be built into your finances.
• The essence of the method is that each of the elements of the financial documents is calculated as a percentage of the established sales value.
• Multiply the total accounts receivable by the historical uncollected accounts percentage to predict how much these bad debts might cost for the time period.

Cash Flow Statement

Connect and map data from your tech stack, including your ERP, CRM, HRIS, business intelligence, and more. Easily calculate drop-off rates and learn how to increase conversion and close rates. Next, Barbara needs to calculate her estimated sales for the upcoming year.

Understanding the Percent of Sales Method: A Simple Guide for Learners

To determine her forecasted sales, she would use the following equation. Learn how to use the sales revenue formula so you can gauge your company’s continued viability percentage of sales method example and forecast more accurately. Next, Liz needs to calculate the percentage of each account in reference to her revenue by dividing by the total sales.

Why Your Sales Forecasts Suck (and What to Do About It)

In this article, we’ll show you how the percentage of sales method works and give you tips on how to implement it into your online business. Let’s use the Balance Sheet report for Fred’s Factory and make some forecasts based on the data given to us. We are going to assume that during the same year, Fred’s Factory had Sales add up to $200,000.

Firm of the Future

The percentage of receivables method estimates the allowance for doubtful accounts using a percentage of the accounts receivable at the end of the accounting period. Allowance for doubtful accounts appears on your balance sheet right beneath your accounts receivable balance. It’s a contra-receivable account that reduces the value of your receivables and overall assets. Generally accepted accounting principles require that businesses maintain an allowance for bad debts. That means that estimating uncollectible accounts is a necessary task if you want to produce GAAP financial statements for potential or existing lenders and investors. The Percent of Sales Method is a straightforward and widely-used approach in financial forecasting and budgeting.

• By expressing certain costs and expenses as a percentage of sales, companies can create more accurate and manageable financial plans.
• Using the allowance method, complying with the matching principle, the amount is recorded in the current accounting period with the following percentage of credit sales method journal.
• For instance, if a customer buys a product from a business that has a step cost at 5,000 units, then every unit beyond those first 5,000 comes at a discounted price.
• Most businesses think they have a good sense of whether sales are up or down, but how are they gauging accuracy?

What is sales revenue? Ultimate guide on how to calculate it

Like a looming storm, the best thing you can do is prepare for bad debt and uncollectible accounts. Using the percentage of sales method, you can do just this and determine what percentage or amount of bad debt needs to be built into your finances. For the percentage-of-sales method to yield accurate forecasts, it is best to apply it only to selected expenses and balance sheet items that have a proven record of closely correlating with sales. Outside of these items, it is better to develop a detailed, line-by-line forecast that incorporates other factors than just the sales level. This more selective approach tends to yield budgets that more closely predict actual results. The resulting figure indicates what the allowance for the doubtful accounts balance should be.

The Formula to Calculate Sales Percentage

Calculate Forecasted Sales Figures

• Credit sales carry a great deal of risk despite their convenience, including processing fees.
• As helpful as the percentage of sales method can be for financial projections, it’s not an all-in-one forecasting solution.
• Companies with credit sales will want to keep tabs on their accounts receivable to ensure bad or aged debt isn’t building up.
• Connect and map data from your tech stack, including your ERP, CRM, HRIS, business intelligence, and more.
• A business would need to forecast the accounts receivable or credit sales using the available historical data.