How Do You Reflect and Plan Marketplace Payments in Cash Flow? A Course on Payout Delays, Money in Transit, Cash Shortfalls and the Cash Buffer
How do you plan marketplace payments in cash flow? Payout delay, weekly cash table, money in transit, cash shortfall and buffer: an 8-lesson guide.
Contents 15 sections
- What will you be able to do by the end of this training?
- Lesson 1: Why does a payout delay disrupt cash flow?
- Lesson 2: How is net payout calculated?
- Lesson 3: How do you build a weekly cash table?
- Lesson 4: How much money is in transit?
- Lesson 5: In which week does a cash shortfall arise?
- Lesson 6: What do upfront expenses consist of?
- Lesson 7: How large should the cash buffer be?
- Lesson 8: How do you monitor the cash plan regularly?
- Why does the payout cash plan not give the same result as the income statement?
- What are the most common mistakes in marketplace cash planning?
- How does NetKasam make marketplace cash tracking easier?
- Mini quiz: Test what you have learned
- Conclusion: Plan for the day the money arrives, not the day of the sale
- Frequently Asked Questions About Marketplace Cash Flow
Sales are rising, orders are pouring in, yet the money in your account is shrinking. This is the most common contradiction sellers who grow on marketplaces experience: you buy the product upfront today and pay for shipping today, but the money from the sale reaches you from the marketplace days later. The more sales grow, the more money this waiting period represents; even if you are profitable, cash can get tight.
This post is not a narrative but an 8-lesson hands-on course. We will answer the question how to reflect and plan marketplace payments in cash flow using a sample store whose weekly sales are growing: the effect of the payout delay, the weekly cash table, money in transit, finding the shortfall week, the cash buffer and regular monitoring. At the end there is a mini quiz and an answer key. All figures, the commission rate and the payout term are sample values chosen to demonstrate the method; verify your own marketplace's current payment rules in your panel.
What will you be able to do by the end of this training?
In short: You will write the payout into the right week, build a weekly cash table, find the week when a shortfall will arise in advance and calculate the cash buffer you need.
- 01Learn the termDetermine how many days after the sale the payout arrives.
- 02Find the net payoutSubtract commission and deductions from the sale.
- 03Write it in the weekPlace the payout in the payment week.
- 04Add expensesSpread upfront expenses across the weeks.
- 05Find the shortfallSee the week in which cash drops below zero.
- 06Set the bufferDetermine the cash margin you need.
The 8 lessons of the course: (1) what a payout delay is, (2) net payout, (3) the weekly cash table, (4) money in transit, (5) finding the shortfall week, (6) the structure of upfront expenses, (7) the cash buffer, (8) regular monitoring.
Lesson 1: Why does a payout delay disrupt cash flow?
In short: Revenue is recorded at the moment of sale but the money arrives on the payment day; during the gap you finance expenses from your own cash.
In the income statement, a sale appears on the day it is ordered or delivered; in cash, the money appears only when the marketplace pays the payout. The difference between the two dates builds up as "money in transit." If sales are constant, this buildup stays constant and goes unnoticed; as sales grow, money in transit grows too, and every new upfront expense leaving your cash stands in for money that has not yet arrived.
This is why growth periods are the riskiest cash periods even for profitable businesses. To see the gap between profit and cash in a broader frame, see the post how to calculate the cash conversion cycle. To see in detail how the payout amount is formed, the post how to calculate marketplace commission and payouts is a good complement.
Lesson 2: How is net payout calculated?
In short: Commission, service fee, returns and other deductions are subtracted from gross sales; the remainder is the net payout the marketplace will pay.
- Net payout = Gross sales × (1 − Total deduction rate)
- Payment week = Sales week + Payout delay (weeks)
- End-of-week cash = Previous cash + Payout received − Upfront expenses
- Money in transit = Sum of net payouts for weeks not yet paid
In the example, the total deduction rate is assumed to be 18%, so the net payout is 82% of gross sales; the real rate varies by category, campaign and returns. The net payout of a week with ₺100,000 in sales is ₺82,000. Verify the deduction items and run the difference check using the method in the post how to find a marketplace payout difference. Be sure to confirm the payment day and terms in your own marketplace panel; the 2-week delay in this post is an example.
Product pageFree Bookkeeping SoftwareLesson 3: How do you build a weekly cash table?
In short: For each week, write sales, net payout, cash received, upfront expenses and end-of-week cash line by line; the cash received is the payout of the week that is the delay earlier.
| Week | Sales | Net payout (82%) | Cash received | Upfront expenses (75%) | End-of-week cash |
|---|---|---|---|---|---|
| 1 | 100.000 ₺ | 82.000 ₺ | ₺70,000 (earlier period) | 75.000 ₺ | 55.000 ₺ |
| 2 | 120.000 ₺ | 98.400 ₺ | ₺80,000 (earlier period) | 90.000 ₺ | 45.000 ₺ |
| 3 | 140.000 ₺ | 114.800 ₺ | 82.000 ₺ | 105.000 ₺ | 22.000 ₺ |
| 4 | 160.000 ₺ | 131.200 ₺ | 98.400 ₺ | 120.000 ₺ | 400 ₺ |
| 5 (forecast) | 180.000 ₺ | 147.600 ₺ | 114.800 ₺ | 135.000 ₺ | −19.800 ₺ |
The opening cash is ₺60,000. The cash received in the first two weeks is the payout for earlier sales (earlier period). In week 3, week 1's payout (₺82,000) arrives, and in week 4, week 2's payout (₺98,400) arrives. Upfront expenses are 75% of sales: items that grow as orders grow, such as product purchases, shipping and packaging. For the general cash flow statement, see the post how to prepare a cash flow statement.
- Opening cash₺60,000
- Week 1 payout received₺70,000
- Week 1 upfront expenses−₺75,000
- Week 2 payout received₺80,000
- Week 2 upfront expenses−₺90,000
- Week 3 payout received₺82,000
- Week 3 upfront expenses−₺105,000
- Week 4 payout received₺98,400
- Week 4 upfront expenses−₺120,000
- End-of-week-4 cash₺400
Prepared with sample values. Calculation: 60,000 + 70,000 − 75,000 + 80,000 − 90,000 + 82,000 − 105,000 + 98,400 − 120,000 = ₺400.
Lesson 4: How much money is in transit?
In short: The total net payout of the weeks that have been sold but not yet paid is the money in transit; as sales grow, this amount grows too.
At the end of week 4, the payouts for weeks 3 and 4 have not yet arrived: 114,800 + 131,200 = ₺246,000. This money has been earned but is not in your cash. If sales had stayed constant at ₺100,000, money in transit would have stayed at 2 × 82,000 = ₺164,000; growth has pushed it to ₺246,000, so ₺82,000 more money is waiting outside your cash.
- Week 3 payout₺114,80046.7%
- Week 4 payout₺131,20053.3%
Track money in transit as a separate row in the table every week and consider it together with your sales target. To factor the cash outcome into target setting, see the post how to set and track a sales target.
Lesson 5: In which week does a cash shortfall arise?
In short: Extend the table to future weeks; the first week in which cash drops below zero is where the shortfall begins.
| Week | End-of-week cash | Situation |
|---|---|---|
| 1 | 55.000 ₺ | Comfortable |
| 2 | 45.000 ₺ | Comfortable |
| 3 | 22.000 ₺ | Shrinking |
| 4 | 400 ₺ | Close to zero |
| 5 (forecast) | −19.800 ₺ | Open |
- Week 1₺55,000
- Week 2₺45,000
- Week 3₺22,000
- Week 4₺400
In week 5, cash is 400 + 114,800 − 135,000 = −₺19,800. The increase in sales does not enlarge the payout but the expense right away; the payout arrives with a two-week delay. Seeing the shortfall two weeks ahead buys time to look for financing or delay upfront expenses. If you will need credit, see the post how to calculate the real cost of a business loan to work out its cost in advance.
Lesson 6: What do upfront expenses consist of?
In short: Upfront expense items that grow with sales are the largest outflows in the cash plan; knowing which of them can be postponed gives you flexibility.
- Product purchases₺84,00070%
- Shipping₺24,00020%
- Packaging and other₺12,00010%
| Item | Flexibility | What can be done |
|---|---|---|
| Product purchases (70%) | Medium | Terms or part payments with the supplier |
| Shipping (20%) | Low | Check the invoice period and payment day |
| Packaging and other (10%) | High | Adjust order quantity and timing |
To plan supplier payments, see how to plan supplier payments, and for fixed expenses, how to build a fixed expense and payment calendar. The ratios in this table are examples; use your own expense structure.
Lesson 7: How large should the cash buffer be?
In short: Calculate the largest expected shortfall and add a safety margin on top; that amount is the buffer to hold in cash or cover with a credit limit.
In the example, the largest expected shortfall is ₺19,800. With a 20% safety margin, the buffer is 19,800 × 1.2 = ₺23,760, or roughly ₺24,000 rounded. Since forecasts rest on sales growth, raise the margin as uncertainty grows. Part of the buffer can be held in cash, part in an unused credit limit or in a share of postponable expenses.
- Planning sales growth, not slowing it. Growth is good; what matters is that financing is ready alongside it.
- Payout frequency. Check the marketplace's payment frequency and terms regularly; changes affect the table.
- Return share. Include expected returns in the deduction rate; if returns are high, the net payout falls. To bring returns down, see the post how to lower the return rate.
- Campaign periods. Sales and commission differ in campaign weeks; run a separate scenario.
To make the decision to join a campaign together with its cash effect, see the post how to decide whether to join a marketplace campaign.
Lesson 8: How do you monitor the cash plan regularly?
In short: Update the table weekly, enter actuals into the plan and keep the next 4–6 weeks always in view.
| Frequency | What happens |
|---|---|
| Every week | Write the payout received and the expenses paid as actuals; re-forecast the remaining weeks |
| Every month | Compare expected and actual payouts and examine the differences |
| Before a campaign | Recalculate the cash for future weeks based on sales growth |
| Every quarter | Review the deduction rate, the payout term and the buffer amount |
| Indicator | How it is calculated | Sample value |
|---|---|---|
| Money in transit | Payouts of unpaid weeks | 246.000 ₺ |
| Lowest cash | The smallest weekly cash balance | −₺19,800 (week 5) |
| Cash buffer | Largest shortfall × 1.2 | ≈ 24.000 ₺ |
| Payout delay | Payment week − Sales week | 2 weeks |
- 2 weekspayout delay in the example
- ₺246,000money in transit at the end of week 4
- −₺19,800expected cash shortfall in week 5
- ≈ ₺24,000recommended cash buffer
To add the plan to the management report, you can use the layout in the post how to prepare a weekly management report. To track receivables in general, see the post how to calculate the average collection period.
Why does the payout cash plan not give the same result as the income statement?
In short: The income statement records a sale on the day it is earned, while cash flow records it on the day the money arrives; the difference between the two is money in transit.
This is why your income statement can look profitable at month end while your cash is empty. The income statement counts week 4's sales of ₺160,000 as that week's income; the cash table sees ₺131,200 of its net payout in week 6. Keeping both tables lets you explain the difference: "We made a profit this month but X ₺ is still on its way." This difference shows up in the accounting records as a receivable; when you share monthly documents with your accountant, attaching the marketplace payout report makes it easier to track this receivable correctly. For handing over documents, see the post how to hand over documents to your accountant monthly.
Also, stating clearly at month-end close the payouts expected from the marketplace makes the next month's cash forecast easier; for the close, you can use the checks in the post how to do a month-end close.
Recommended ReadingHow Do You Find Stuck Marketplace Orders? A Course on Stage Times, Daily Counts, Causes of Delay, Resolution Order and Root Cause FixesWhat are the most common mistakes in marketplace cash planning?
- Counting a sale as cash. A sale becomes cash when the payout arrives; before that it is a receivable.
- Forgetting the delay. If the payout term is not written in the table, the shortfall comes as a surprise.
- Assuming a fixed deduction rate. Campaigns and returns change it; correct it with actuals.
- Planning growth without cash. A rise in sales enlarges upfront expenses right away.
- Working with a single scenario. Three scenarios (optimistic, expected and pessimistic) are safer.
- Skipping the buffer. Even the smallest delay widens the shortfall.
- Not updating the table. An old table gives false confidence.
How does NetKasam make marketplace cash tracking easier?
- Marketplace integration. Marketplace orders are collected on a single screen, invoiced automatically and posted to bookkeeping (marketplace integration).
- Single-screen order management. You see sales by week and carry them into your table (order management).
- Cash and bank tracking. The arrival of a payout in your account is tracked in bank transactions; cash and bank records are kept in bookkeeping (invoice tracking).
- Expense management. You record upfront expense items and sort them into categories (expense management).
- Saved reports. You save sales and collection reports with their criteria and export them to Excel (reports).
- 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.
- What is the net payout of ₺160,000 in weekly sales with an 18% deduction?
- If cash at the start of week 3 is ₺45,000, payout received is ₺82,000 and upfront expenses are ₺105,000, what is cash at the end of week 3?
- At the end of week 4, money in transit is the payouts of weeks 3 and 4 (114,800 and ₺131,200). What is the total?
- If cash in week 5 is ₺400, payout received is ₺114,800 and upfront expenses are ₺135,000, what is cash at the end of week 5?
- If the largest shortfall is ₺19,800 and the safety margin is 20%, what is the cash buffer?
Answer key:
- 160.000 × 0,82 = 131.200 ₺.
- 45.000 + 82.000 − 105.000 = 22.000 ₺.
- 114.800 + 131.200 = 246.000 ₺.
- 400 + 114.800 − 135.000 = −19.800 ₺.
- 19.800 × 1,2 = 23.760 ₺.
Frequently Asked Questions About Marketplace Cash Flow
Why does cash get tight when sales grow?
Expenses go out upfront, while the marketplace payout arrives at the end of the payment term. As sales grow, money in transit increases and the upfront expenses leaving your cash grow too.
How do you show a payout delay in the cash plan?
The net payout of a sale is written in the week it is paid, not the week of the sale. With a 2-week delay, week 1's payout arrives in week 3.
What is money in transit?
It is the total of payouts for sales already made but not yet in your account. It has been earned, but it is not in your cash.
How is net payout calculated?
Commission, service fee, returns and other deductions are subtracted from gross sales. In the example, deductions are 18%, so the net payout is 82% of gross.
How is the cash buffer determined?
A safety margin is added to the largest expected cash shortfall. In the example, with a ₺19,800 shortfall and a 20% margin, the buffer is about ₺24,000.
Where do I find the payment term?
In your own marketplace's seller panel and contract terms. The 2-week term in this post is an example and may change.
How often is the cash table updated?
It should be updated weekly and always show the next 4–6 weeks. Recalculate it before a campaign.
I make a profit but the cash is empty, why?
The income statement records a sale on the day it is earned, while cash sees it when the money arrives. The difference is money in transit and upfront expenses.
Conclusion: Plan for the day the money arrives, not the day of the sale
The most useful thing you can do today is build a weekly cash table for the next six weeks. Write the marketplace payout into the payment week, add the upfront expenses, find the week in which cash drops below zero and plan a buffer or financing before that week. Update the table every week with actuals.
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.