Formula to Calculate Net Sales of a Company
Net sales formula is used to calculate the sales of the company net of its return, discounts and other allowances where the formula of net sales is gross sales revenue generated minus sales returns, discounts allowed to the customers and allowances.
Formula of net sales calculates the Net Revenue of the firm after accounting for any sales return, discounts, allowances. The return would also include any damaged product or missing products.
The gross sales or gross revenue depicts the total income a company or a firm who shall earn during a specified time, which could be a year or a quarter, and that shall include all the credit card, cash, trade credit sales, and debit card sales performed during that time, including the discounts and allowances for sales.
At the end of the accounting period, the company shall calculate the total sales discount and total sales allowances and this figure will be subtracted from the gross sales to arrive at the net sales. The amount that is received from the customer or says the amount that is realized from them is the net sales figure and the same gets reported on the income statement.
ABC limited wants to record the revenue figure in the income statement for the year ended 20XX.
You are required to compute the net revenue figure based on above information provided.
Net Sales can be calculated using the above formula as,
- 50,00,000 – 150,000 – 100,000 – 250,000
- Net Sales = 45,00,000.00
Therefore, the firm needs to record 45,00,000 as Net Revenue in its income statement.
Vijay started a new business around a year ago. He entered the business of bike sales. Last year the firm sold 50,000 units of S model bike, 10,000 units of S+ model bike and 2,500 units of Super S+ model bike. However, there we some sort of complain related to the performance of the bike and as a percentage, some of the bikes came back were: 10% of S model bike, 5% of S+ bikes and 1% of the Super S+ bikes.
The price range was 50,000, 70,000 and 100,000 for the S model, S+ model, and Super S+ model respectively. It’s the policy of the company to provide a flat 2% discount on the gross amount of bike as a completion of one year of the firm. These bikes are subject to service semi-annually and hence those are treated as a firm’s expenditure: 1% of the gross amount for the S+ model and Super S+ model only.
Considering all of the above facts, you are required to calculate the net revenue that Vijay’s firm should record in its books of account.
Here, we are not given any of the figures directly and hence we will first calculate all of those individually.
= 3,45,00,00,000.00 – 28,75,00,000.00 – 95,00,000.00 – 6,90,00,000.00
- Net Sales = 3,08,40,00,000.00
Therefore, the firm needs to record 3,08,40,00,000.00 as Net Revenue in its income statement.
BBZ is in the sales of software in the Kurla market. Below are the common size statements for the income statement which was reported to the bank for loan approval.
As an accountant to the firm, he was asked to help the bank in providing the numbers. The bank has requested him to provide the net revenue figure.
He noted that 3,700 units of software were sold at the rate of 2,000 per piece. You are required to calculate net revenue figure.
We shall first calculate gross revenue and arrived at the net revenue after taking into account all of the sales return, allowances, and discounts.
Gross sales will be no of units * selling price per unit which is 3,700 units * 2,000 which equals to 74,00,000
We can now calculate other figures per percentage of revenue as given in the question.
- 74,00,000.00 – 3,28,560.00 – 2,19,040.00 – 5,47,600.00
Net Sales will be –
- Net Sales = 63,04,800.00
Therefore, the firm needs to record 63,04,800.00 as Net Revenue in its income statement and report same to the bank.
Relevance and Uses
This figure can be used for many purposes like if there is the difference between a company’s net and gross sales is more than the figure of the industry average, the firm may be offering lucrative discounts or they may be realizing a greater amount of sales returns when compared with their peers. While comparing income statements say monthly, that could help them identify any potential problems and look for viable solutions.
This has been a guide to Net Sales Formula. Here we discuss the calculation of net sales along with practical examples and downloadable excel template. You can learn more about financial analysis from the following articles –