EN
Shipping and Logistics

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
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is a weekly management report, and why is it needed?
  3. Lesson 2: Which 8 indicators should go into the weekly report?
  4. Lesson 3: How are weekly indicators calculated?
  5. Lesson 4: How do you read the report when comparing two weeks?
  6. Lesson 5: How do you interpret a margin decline and a rise in returns?
  7. Lesson 6: How do you interpret receivables and cash indicators?
  8. Lesson 7: How do you set up the weekly report and run the meeting?
  9. Lesson 8: How do you extend the weekly report to monthly and quarterly?
  10. What are the most common mistakes in management reporting?
  11. How does NetKasam make management reporting easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Write the eight indicators in a single table this week
  14. 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.

Training mapThe six steps of the weekly management report
  1. 01
    ChooseSet the eight indicators.
  2. 02
    CalculateCalculate each indicator with the same formula.
  3. 03
    ComparePut them side by side with last week.
  4. 04
    CauseFind the cause of the indicator that deviates.
  5. 05
    DecideAssign an action and a person responsible to each deviation.
  6. 06
    RoutineSave 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.

ReportsFrequencyQuestionWho looks at it?
Daily sales summaryEvery dayWhat did we sell today?Operations
Weekly management reportOnce a weekWhat changed, and what should we do?Management
Monthly closing reportOnce a monthWas the month profitable?Management, accounting
Quarterly analysisEvery three monthsIs 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.

IndicatorFormulaWhat does it tell you?
1. Net salesSales net of returns and cancellationsRevenue
2. Number of ordersWeekly order countVolume
3. Average basketNet sales ÷ Number of ordersRevenue per order
4. Gross profit margin(Net sales − Cost of goods sold) ÷ Net salesProfitability
5. Return rateNumber of returns ÷ Number of ordersQuality and satisfaction
6. Inventory coverage daysInventory ÷ Daily salesInventory adequacy
7. Overdue receivablesOpen balance past its due dateCollection risk
8. Cash and bank balanceCash + bank totalCash 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 dataThis weekLast week
Net sales480.000 ₺450.000 ₺
Cost of goods sold288.000 ₺261.000 ₺
Number of orders1.6001.500
Number of returns128105
Inventory coverage days32 days30 days
Overdue receivables96.000 ₺80.000 ₺
Cash and bank310.000 ₺340.000 ₺
Calculated indicatorThis weekLast week
Average basket480.000 ÷ 1.600 = 300 ₺450.000 ÷ 1.500 = 300 ₺
Gross profit480.000 − 288.000 = 192.000 ₺450.000 − 261.000 = 189.000 ₺
Gross profit margin192.000 ÷ 480.000 = %40,0189.000 ÷ 450.000 = %42,0
Return rate128 ÷ 1.600 = %8,0105 ÷ 1.500 = %7,0
ChartThis week, ₺192,000 in gross profit remained from ₺480,000 in net sales
  1. Net sales₺480,000
  2. Cost of goods sold−₺288,000
  3. 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.

IndicatorLast weekThis weekChangeDirection
Net sales450.000 ₺480.000 ₺+%6,7Good
Number of orders1.5001.600+%6,7Good
Average basket300 ₺300 ₺0Neutral
Gross profit189.000 ₺192.000 ₺+%1,6Weak
Gross profit margin%42,0%40,0−2.0 pointsBad
Return rate%7,0%8,0+1.0 pointsBad
Inventory coverage days30 days32 days+2 daysMonitor
Overdue receivables80.000 ₺96.000 ₺+%20Bad
Cash and bank340.000 ₺310.000 ₺−%8,8Bad

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.

ChartGross profit margin over the last 8 weeks: a clear drop this week
  1. Week 141.5%
  2. Week 242.0%
  3. Week 341.8%
  4. Week 442.3%
  5. Week 541.7%
  6. Week 642.2%
  7. Week 742.0%
  8. 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 causeHow to check
Discount campaignLook at the sales share of campaign products and the discount rate
Increase in supply costLook at the change in cost of goods sold per unit
Shift in product mixHas the sales share of low-margin products increased?
Channel mixHas 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:

ChartReasons for returns: size/fit issues and not meeting expectations lead the way
  • 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 ageAmountShareAction
1–30 days overdue60.000 ₺%62,5Send a reminder
31–60 days overdue24.000 ₺%25,0Call and get a payment date
More than 60 days12.000 ₺%12,5Reconciliation and consideration of legal proceedings
Total overdue96.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.

StepWhat to do?
1For each indicator, it is determined which report it will be taken from
2Filters (date range, channel, warehouse) are set up once and saved
3The report is run on the same day every week and entered in the table
4The change from last week is calculated and indicators that are getting worse are flagged
5In the 30-minute meeting, only the flagged indicators are discussed
6A person responsible and a date are assigned to each deviation
Meeting segmentDuration
Overview of the eight indicators5 min
Causes of indicators that are getting worse15 min
Action, person responsible, and date7 min
Review of last week's action items3 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.

Takeaways from the exampleFour numbers from the example week
  • +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.

PeriodAddedRelated article
Weekly8 indicatorsThis article
MonthlyExpense analysis, net profit, personnel costexpense analysis
MonthlyInventory turnover, dead stockdead stock
QuarterlyCustomer and branch profitabilitybranch profitability
QuarterlyABC analysis, price listABC 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?

  1. Including too many indicators. The report goes unread and important deviations get lost.
  2. Reading only from revenue. Margin, return and collection problems stay invisible.
  3. Changing the formula from week to week. Comparisons lose their meaning.
  4. Reading too much into a single week. You can't separate noise from real deviation.
  5. Not assigning an owner to a deviation. The report gets read, but nothing changes.
  6. Opening the report to everyone. Margin and cash information should stay confidential.
  7. 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.

  1. If net sales are ₺300,000 and the cost of goods sold is ₺195,000, what is the gross profit margin?
  2. With 2,000 orders and ₺500,000 in net sales, what is the average basket size?
  3. If there are 90 returns out of 1,200 orders, what is the return rate?
  4. Weekly sales are ₺500,000; margin fell from 40% to 38%. What is the weekly financial impact?
  5. The cash and bank balance fell from ₺400,000 to ₺360,000. What is the percentage change?

Answer key:

  1. (300.000 − 195.000) ÷ 300.000 = %35.
  2. 500.000 ÷ 2.000 = 250 ₺.
  3. 90 ÷ 1.200 = %7,5.
  4. 500,000 × 2 points = ₺10,000.
  5. (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.

Start FreeShipping Integration

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools