How to use
- Under report details, enter the report title, period, date, department and author, and pick the currency and the amount unit (the currency itself, thousands or millions).
- Under sales by item, enter the target, actual and previous-period figure (last month, or the same period last year) for each account, product or rep. Type the amounts in the unit you chose.
- Attainment and change are worked out right under each line, and the totals appear too.
- Under highlights, issues and plan, write the key results, issues and risks, and the plan for next period. Each line breaks into a paragraph.
- Name the approval boxes, separated by commas, check the preview, then print to PDF or download a DOCX.
The currency starts as the currency of the country you visit from. Changing it does not convert the amounts you typed; only the symbol and decimal places change, so edit the amounts yourself.
How it is calculated
Amounts are entered and calculated as whole numbers, and percentages are worked out to one decimal place with round half up (0.5 and above rounds up).
| Item | Formula | Note |
|---|---|---|
| Attainment | actual / target x 100 | left blank if the target is empty or 0 |
| Change | actual - previous | only when both are present |
| Change % | (actual - previous) / previous x 100 | left blank if previous is empty or 0 |
| Total | sum of each column | total attainment is total actual / total target |
Increases get a + and decreases a -. If target or previous figures are filled in for only some lines, the total percentages can be off, and a notice appears.
The sample page, worked out
The English sample uses USD with the unit set to the currency itself (dollars), and the values are:
| Item | Target | Actual | Attainment | Previous | Change | Change % |
|---|---|---|---|---|---|---|
| Account A | 50,000 | 56,200 | 112.4% | 48,000 | +8,200 | +17.1% |
| Account B | 30,000 | 27,300 | 91.0% | 31,500 | -4,200 | -13.3% |
| Online store | 20,000 | 21,800 | 109.0% | 17,600 | +4,200 | +23.9% |
| Total | 100,000 | 105,300 | 105.3% | 97,100 | +8,200 | +8.4% |
Account A’s change is 8,200 / 48,000 = 17.083…%, written as 17.1%. In the same way the total change is 8,200 / 97,100 = 8.44…%, which is 8.4%.
Writing the report
- Put target, actual, attainment and change versus the previous period above the table. A reader can grasp the situation from those four lines alone.
- Split items on one basis only. Mixing accounts and products makes totals overlap.
- Keep the comparison period consistent: last month for a monthly report, the same period last year for an annual one.
- Add the reason behind the numbers in a line each under highlights and issues, which cuts down on follow-up questions.
Keep in mind
What this tool produces is a reference layout of the figures you typed. Whoever enters the numbers is responsible for their accuracy. It does not replace a tax invoice, cash receipt or other legal proof, is not a set of accounting statements, and is not tax, accounting or legal advice.
Frequently asked questions
How does the amount unit work?
The unit is only printed on the document, such as “(Unit: USD thousand)”. Calculation uses the numbers exactly as typed, so enter every cell in the unit you chose.
Why is attainment blank?
If the target or actual is empty, or the target is 0, attainment is left blank because dividing by zero gives nothing meaningful.
Can I enter negative sales?
Yes. In a month with many returns or refunds you can enter a negative number, and change and change % follow.
Can I enter amounts with decimals?
Amounts follow the currency’s decimals: whole numbers for won and yen, up to two decimals for most others. For finer detail in won, switch the unit from thousand or million down to the currency itself.
Is what I type sent to a server?
No. Calculation and document generation happen only in your browser.
Related tools
- Expense Report Maker: get spending approved
- Approval Request Maker: get a plan approved
- Percent Calculator: work out ratios on their own
- Percent Change Calculator: check growth and decline rates
- Margin Calculator: check margin on sales
What you type is processed in this browser only and never sent to a server.