Percentage of Annual Sales by Month
Monthly sales (excluding VAT) are calculated from the monthly percentages of forecast total sales entered for the year as illustrated below. These percentages are also applied to purchases and variable overheads.
In the example below a business is expected to return 5% of its total annual sales in January, 4% in February, 7% in March and so on. To illustrate the procedure for the year as a whole, assume a year with trade sales (excluding VAT and delivery or service charges) of £1,000,000.
| Month Ref: | % of Annual Sales Entered | i.e. Returning Sales per Month |
| January | 5% | £50,000 |
| February | 4% | £40,000 |
| March | 7% | £70,000 |
| April | 6% | £60,000 |
| May | 7% | £70,000 |
| June | 8% | £80,000 |
| July | 7% | £70,000 |
| August | 9% | £90,000 |
| September | 10% | £100,000 |
| October | 14% | £140,000 |
| November | 18% | £180,000 |
| December | 5% | £50,000 |
| Totals | 100% | £1,000,000 |
Delivery or Service Charges
If your business also adds delivery or service charges to its billings these are calculated from the percentage of annual sales you enter for these. If 3% of trade sales is selected for delivery or service charges, 30,000 will be added to to the 1,000,000 of trade sales of this example before calculating monthly sales.
All sales are entered excluding VAT. Our system calculates and applies all VAT transactions.