How Do You Prepare a Weekly Management Report? A Training on 8 Indicators, Week-over-Week Comparison, and Interpreting Margin, Returns, Receivables, and Cash
How do you prepare a weekly management report? Sales, margin, returns, inventory, receivables, and cash indicators, week-over-week comparison, and the meeting: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is a weekly management report, and why is it needed?
- Lesson 2: Which 8 indicators should go into the weekly report?
- Lesson 3: How are weekly indicators calculated?
- Lesson 4: How do you read the report when comparing two weeks?
- Lesson 5: How do you interpret a margin decline and a rise in returns?
- Lesson 6: How do you interpret receivables and cash indicators?
- Lesson 7: How do you set up the weekly report and run the meeting?
- Lesson 8: How do you extend the weekly report to monthly and quarterly?
- What are the most common mistakes in management reporting?
- How does NetKasam make management reporting easier?
- Mini quiz: Test what you have learned
- Conclusion: Write the eight indicators in a single table this week
- Frequently Asked Questions About the Weekly Management Report
At the end of the week, you look at the sales figure: higher than last week. You're pleased. But that same week, returns went up, discounts ate into the margin, a customer's payment was late, and the cash on hand went down. None of this shows up in the sales figure. Reading a business from revenue alone is like driving a car by looking only at the speedometer: you don't know about the fuel, the engine temperature, or the tires.
This article is not a narrative but an 8-lesson practical training. We'll answer the question how do you prepare a weekly management report with figures, using a sample e-commerce business: which 8 indicators to track, how each one is calculated, how two weeks are compared, how decisions are drawn from the figures, and how the report is turned into a lasting routine. At the end, there is a mini quiz with an answer key. For a deeper look at the financial side of reporting, see the article how to prepare an income statement, and for month end, how to do a month-end close; here we build a weekly, short, decision-focused report.
What will you be able to do by the end of this training?
In short: You will choose the 8 indicators for the weekly report, calculate each one, compare two weeks, look for the causes of deviations, and run the report in the same format every week.
- 01ChooseSet the eight indicators.
- 02CalculateCalculate each indicator with the same formula.
- 03ComparePut them side by side with last week.
- 04CauseFind the cause of the indicator that deviates.
- 05DecideAssign an action and a person responsible to each deviation.
- 06RoutineSave the report and run it on the same day every week.
The 8 lessons of this training: (1) what a management report is, (2) which 8 indicators, (3) weekly calculation, (4) comparing two weeks, (5) interpreting margin and returns, (6) interpreting receivables and cash, (7) setting up the report and the meeting, (8) extending to monthly and quarterly.
Lesson 1: What is a weekly management report, and why is it needed?
In short: A management report is a short summary that makes decision-making easier. Length isn't a measure of success; a small number of the right indicators, always the same formula, and a comparison with the previous period make it useful.
The difference from accounting reports is this: an accounting report shows the past in a form suitable for the records; a management report answers the question "what changed this week, and what should I do?" That's why it's weekly: waiting for month end means seeing a problem four weeks late.
| Reports | Frequency | Question | Who looks at it? |
|---|---|---|---|
| Daily sales summary | Every day | What did we sell today? | Operations |
| Weekly management report | Once a week | What changed, and what should we do? | Management |
| Monthly closing report | Once a month | Was the month profitable? | Management, accounting |
| Quarterly analysis | Every three months | Is the strategy right? | Management |
Sample business (figures chosen only to illustrate the method): an e-commerce business selling through multiple channels and receiving an average of 1,500–1,600 orders a week. For a detailed profit calculation, the article how to calculate net profit on a marketplace is a useful complement.
Lesson 2: Which 8 indicators should go into the weekly report?
In short: Choose one or two indicators from each area: sales, profitability, customers, and cash. As the number of indicators grows, the report goes unread; eight numbers fit on one page and can be discussed in a single meeting.
| Indicator | Formula | What does it tell you? |
|---|---|---|
| 1. Net sales | Sales net of returns and cancellations | Revenue |
| 2. Number of orders | Weekly order count | Volume |
| 3. Average basket | Net sales ÷ Number of orders | Revenue per order |
| 4. Gross profit margin | (Net sales − Cost of goods sold) ÷ Net sales | Profitability |
| 5. Return rate | Number of returns ÷ Number of orders | Quality and satisfaction |
| 6. Inventory coverage days | Inventory ÷ Daily sales | Inventory adequacy |
| 7. Overdue receivables | Open balance past its due date | Collection risk |
| 8. Cash and bank balance | Cash + bank total | Cash strength |
For how margin is calculated, see how to calculate profit margin; for returns, how to calculate the cost of returns; and for inventory coverage days, how to calculate inventory turnover. The most important rule when choosing formulas is consistency: don't change a formula once you've chosen it, or week-to-week comparison loses its meaning.
Lesson 3: How are weekly indicators calculated?
In short: First get the raw data (sales, cost, orders, returns, balances), then apply the formulas. Raw data should come from a single source, with the same filters selected.
| Raw data | This week | Last week |
|---|---|---|
| Net sales | 480.000 ₺ | 450.000 ₺ |
| Cost of goods sold | 288.000 ₺ | 261.000 ₺ |
| Number of orders | 1.600 | 1.500 |
| Number of returns | 128 | 105 |
| Inventory coverage days | 32 days | 30 days |
| Overdue receivables | 96.000 ₺ | 80.000 ₺ |
| Cash and bank | 310.000 ₺ | 340.000 ₺ |
| Calculated indicator | This week | Last week |
|---|---|---|
| Average basket | 480.000 ÷ 1.600 = 300 ₺ | 450.000 ÷ 1.500 = 300 ₺ |
| Gross profit | 480.000 − 288.000 = 192.000 ₺ | 450.000 − 261.000 = 189.000 ₺ |
| Gross profit margin | 192.000 ÷ 480.000 = %40,0 | 189.000 ÷ 450.000 = %42,0 |
| Return rate | 128 ÷ 1.600 = %8,0 | 105 ÷ 1.500 = %7,0 |
- Net sales₺480,000
- Cost of goods sold−₺288,000
- Gross profit₺192,000
Prepared with sample values. Gross profit margin 40%.
Lesson 4: How do you read the report when comparing two weeks?
In short: Write the change next to each indicator: a percentage for amounts, a point difference for ratios. It should be visible at a glance which indicators are improving and which are getting worse.
| Indicator | Last week | This week | Change | Direction |
|---|---|---|---|---|
| Net sales | 450.000 ₺ | 480.000 ₺ | +%6,7 | Good |
| Number of orders | 1.500 | 1.600 | +%6,7 | Good |
| Average basket | 300 ₺ | 300 ₺ | 0 | Neutral |
| Gross profit | 189.000 ₺ | 192.000 ₺ | +%1,6 | Weak |
| Gross profit margin | %42,0 | %40,0 | −2.0 points | Bad |
| Return rate | %7,0 | %8,0 | +1.0 points | Bad |
| Inventory coverage days | 30 days | 32 days | +2 days | Monitor |
| Overdue receivables | 80.000 ₺ | 96.000 ₺ | +%20 | Bad |
| Cash and bank | 340.000 ₺ | 310.000 ₺ | −%8,8 | Bad |
Looked at alone, the sales increase is good news. Looked at together, the picture is different: while sales rose 6.7%, gross profit rose only 1.6%; the profit increase is a quarter of the sales increase. The gain has been eaten up by the margin decline and additional returns.
- Week 141.5%
- Week 242.0%
- Week 341.8%
- Week 442.3%
- Week 541.7%
- Week 642.2%
- Week 742.0%
- Week 8 (this week)40.0%
Prepared with sample values.
Be careful when interpreting a single week's change: one week can be noise. The margin stayed in the 41.5–42.3% range for seven weeks; its drop to 40 in the eighth week is outside that range, so it's worth investigating. Putting the last 8 weeks side by side shows the difference between "normal fluctuation" and "a real deviation."
Recommended ReadingHow to Calculate Profit Margin?Lesson 5: How do you interpret a margin decline and a rise in returns?
In short: Write the cost of the margin decline in money; no one takes action when you say "2 points," but saying "₺9,600 this week" gets them moving. Then look for the cause: discounts, cost increases, product mix, or returns.
The monetary effect of the margin loss: 480,000 × 2 points = ₺9,600. If the margin had stayed at last week's 42%, gross profit would have been ₺201,600; the actual figure is ₺192,000. Possible causes:
| Possible cause | How to check |
|---|---|
| Discount campaign | Look at the sales share of campaign products and the discount rate |
| Increase in supply cost | Look at the change in cost of goods sold per unit |
| Shift in product mix | Has the sales share of low-margin products increased? |
| Channel mix | Has the share of the high-commission channel increased? |
On the returns side: if the return rate had stayed at 7% on the same 1,600 orders, there would have been 112 returns; the actual figure is 128. The extra 16 returns × ₺300 average basket = ₺4,800 in sales came back. Knowing the reasons for returns determines the solution:
- Size / fit₺5240.6%
- Didn't meet expectations₺3023.4%
- Arrived damaged₺2418.8%
- Wrong product₺129.4%
- Other₺107.8%
Prepared with sample values.
40.6% of returns (52 ÷ 128) are due to size and fit. Adding a size chart to the product page can reduce this item. To calculate the full cost of returns, see the article how to calculate the cost of returns; for the effect of discount decisions on margin, the article how to offer discounts without losing money is a useful complement.
Lesson 6: How do you interpret receivables and cash indicators?
In short: Sales and profit stay on paper; they can't be spent until they enter the account as cash. If overdue receivables are growing and cash and bank are falling, a business that looks profitable can run into a cash crunch.
| Receivable age | Amount | Share | Action |
|---|---|---|---|
| 1–30 days overdue | 60.000 ₺ | %62,5 | Send a reminder |
| 31–60 days overdue | 24.000 ₺ | %25,0 | Call and get a payment date |
| More than 60 days | 12.000 ₺ | %12,5 | Reconciliation and consideration of legal proceedings |
| Total overdue | 96.000 ₺ | %100 |
While overdue receivables increased by ₺16,000 (20%) in one week, cash and bank fell by ₺30,000. The two should be read together: on one side, money isn't coming in; on the other, money is going out. To find the cause of the cash outflow, see the article how to prepare a cash flow statement, and for managing receivables, how to track receivables.
Lesson 7: How do you set up the weekly report and run the meeting?
In short: Set up the report once with the right criteria, save it, and run it on the same day at the same time every week. The meeting shouldn't exceed 30 minutes; the report exists to discuss decisions, not figures.
| Step | What to do? |
|---|---|
| 1 | For each indicator, it is determined which report it will be taken from |
| 2 | Filters (date range, channel, warehouse) are set up once and saved |
| 3 | The report is run on the same day every week and entered in the table |
| 4 | The change from last week is calculated and indicators that are getting worse are flagged |
| 5 | In the 30-minute meeting, only the flagged indicators are discussed |
| 6 | A person responsible and a date are assigned to each deviation |
| Meeting segment | Duration |
|---|---|
| Overview of the eight indicators | 5 min |
| Causes of indicators that are getting worse | 15 min |
| Action, person responsible, and date | 7 min |
| Review of last week's action items | 3 min |
Access to the report should also be planned: margin, receivables and cash information should not be open to everyone. Decide who can access which report as described in the article how to set up user permissions.
- +6.7%change in net sales
- +1.6%change in gross profit
- ₺9,600weekly cost of the margin drop
- ₺96,000overdue receivables
Lesson 8: How do you extend the weekly report to monthly and quarterly?
In short: The eight weekly indicators stay the same; the monthly report adds expenses and net profit, and the quarterly report adds channel, product and customer profitability. It is not a separate report but an extension of the same one.
| Period | Added | Related article |
|---|---|---|
| Weekly | 8 indicators | This article |
| Monthly | Expense analysis, net profit, personnel cost | expense analysis |
| Monthly | Inventory turnover, dead stock | dead stock |
| Quarterly | Customer and branch profitability | branch profitability |
| Quarterly | ABC analysis, price list | ABC analysis |
The weekly report is your "glasses", the monthly report your "magnifying glass" and the quarterly report your "map". You can't use a magnifying glass without glasses: moving to monthly detail before the weekly routine is in place usually ends half-done. For the first three months, just pull the eight indicators consistently every week.
Recommended readingHow to Prepare a Cash Flow Statement?What are the most common mistakes in a management report?
- Including too many indicators. The report goes unread and important deviations get lost.
- Reading only from revenue. Margin, return and collection problems stay invisible.
- Changing the formula from week to week. Comparisons lose their meaning.
- Reading too much into a single week. You can't separate noise from real deviation.
- Not assigning an owner to a deviation. The report gets read, but nothing changes.
- Opening the report to everyone. Margin and cash information should stay confidential.
- Pulling the data with a different filter each time. The numbers won't match.
How does NetKasam make the management report easier?
- Ready-made and custom reports. You can use ready-made report templates or create your own; by choosing detailed criteria and filters, you get to your business's real data (reports).
- Saving reports. Save a report you pull regularly together with its criteria, and reach the same report with one click the following week.
- Fast results. With filters and criteria, a report is ready in a few seconds.
- Export. You can export reports in Excel format or print them.
- Permissions. You can restrict users' access to report pages with permissions (users and employees).
- Access from anywhere. Because it is an online system, you can view reports anywhere with an internet connection.
- Receivables and inventory in one place. Account balances and due dates are kept with customer and supplier account tracking, and inventory status with inventory management.
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If net sales are ₺300,000 and the cost of goods sold is ₺195,000, what is the gross profit margin?
- With 2,000 orders and ₺500,000 in net sales, what is the average basket size?
- If there are 90 returns out of 1,200 orders, what is the return rate?
- Weekly sales are ₺500,000; margin fell from 40% to 38%. What is the weekly financial impact?
- The cash and bank balance fell from ₺400,000 to ₺360,000. What is the percentage change?
Answer key:
- (300.000 − 195.000) ÷ 300.000 = %35.
- 500.000 ÷ 2.000 = 250 ₺.
- 90 ÷ 1.200 = %7,5.
- 500,000 × 2 points = ₺10,000.
- (360.000 − 400.000) ÷ 400.000 = −%10.
Frequently Asked Questions About the Weekly Management Report
What is a weekly management report?
It is a short summary that shows the state of the business with a small number of indicators and a comparison with the previous week; it is prepared to make decision-making easier.
Which indicators should go into the weekly report?
Net sales, number of orders, average basket, gross profit margin, return rate, inventory coverage days, overdue receivables, and cash and bank balance.
How is gross profit margin calculated?
(Net sales − cost of goods sold) ÷ net sales. In the example, (480,000 − 288,000) ÷ 480,000 = 40%.
How is the return rate calculated?
The number of returns is divided by the number of orders. In the example, 128 ÷ 1,600 = 8%.
Why should the report be weekly?
A monthly report shows a problem four weeks late. A weekly report lets you catch a deviation within a week.
Why might profit not increase while sales increase?
Margin may fall, returns may rise, or costs may go up. In the example, while sales rose 6.7%, gross profit rose only 1.6%.
How long should the weekly meeting last?
30 minutes is enough. The goal isn't to read out figures but to find the cause of indicators that are getting worse and assign a person responsible and a date.
Can I save the report in NetKasam?
Yes. You can save a report you run regularly with its criteria and run it again with one click, export it to Excel, or print it; you can restrict users' access to reports with permissions.
Conclusion: Put the eight indicators in a single table this week
A management report keeps you from seeing the business as nothing more than revenue. This week, write the eight indicators in a table, compare them with last week and assign an owner to any that are getting worse. Once you fill the same table consistently for the next four weeks, you will know how your business behaves each week from numbers rather than guesswork.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.