1. Home
  2. Documents
  3. Sales Report Maker

Sales Report Maker

Enter targets and actuals to get attainment and growth worked out.

Runs in your browser · No upload
Document language
Paper

Report details

Sales by item

Enter the amounts below in the unit chosen above.

Item 1
Attainment 112.4% | Change +8,200.00 (+17.1%)
Item 2
Attainment 91.0% | Change -4,200.00 (-13.3%)
Item 3
Attainment 109.0% | Change +4,200.00 (+23.9%)

Total: target 100,000.00 | actual 105,300.00 | attainment 105.3%

Highlights, issues and plan

Each line prints as a paragraph.

Approval boxes

Preview (print layout)
In the print dialog choose "Save as PDF" as the destination. Paper and margins are already set, so leave the dialog margins on "Default".
This form is a reference document that lays out the details of a transaction. It does not replace a tax invoice, cash receipt, card slip or any other legal proof, and it is not tax, accounting or legal advice.

What you type and the images you add are processed in this browser only and never uploaded.

How to use

  1. 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).
  2. 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.
  3. Attainment and change are worked out right under each line, and the totals appear too.
  4. Under highlights, issues and plan, write the key results, issues and risks, and the plan for next period. Each line breaks into a paragraph.
  5. 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.

What you type is processed in this browser only and never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.