Tutorials › VEE Accounting and Finance › Deriving Cash Paid to Suppliers

VEE Accounting and Finance · Cash Flow Statement Methods · Tutorial 156 of 996

Deriving Cash Paid to Suppliers

Learn to calculate supplier cash payments from inventory and trade payable balances, with a balance-based derivation and checks against common sign errors.

Intermediate 10 min read

What You'll Learn

  • Derive inventory purchases from cost of goods sold and the change in inventory.
  • Use the trade accounts payable rollforward to convert purchases into cash paid.
  • Explain why an inventory increase raises supplier payments and a payable increase lowers them.
  • Distinguish trade accounts payable from other liabilities when selecting balance changes.
  • Check a calculated payment by reconstructing the ending inventory and payable balances.

Why Cost of Goods Sold Is Not Cash Paid to Suppliers

Under the direct method, operating cash flows include the cash actually paid to suppliers for inventory. That amount is not generally equal to cost of goods sold. Cost of goods sold is the inventory cost recognized as an expense during the period; some inventory purchased during the period may remain unsold, and some inventory sold may have been purchased in an earlier period. In addition, a supplier may allow payment after the inventory is received.

The calculation therefore uses two balance rollforwards. First, reconcile cost of goods sold to the inventory acquired during the period. Then reconcile those purchases to the cash paid, using the change in trade accounts payable. This tutorial assumes a merchandising business and ordinary inventory purchases; it does not calculate payments for operating expenses, interest, taxes, or other items.

Definition: Purchases are the inventory costs added during the period. Cash paid to suppliers is the cash disbursed for those purchases during the period. Trade accounts payable is the amount owed to inventory suppliers at a reporting date. For this calculation, use the opening and closing balances of trade accounts payable, not unrelated accrued expenses or other liabilities.

The Two Balance Rollforwards

Assume that inventory is acquired for resale, its costs are recorded in inventory, and its cost is transferred to cost of goods sold when sold. Also assume no inventory write-downs, theft, shrinkage, purchase returns, or other adjustments that change inventory outside ordinary purchases and sales. Under these assumptions, the inventory balance follows this rollforward:

$$ \text{Ending inventory} = \text{Beginning inventory} + \text{Purchases} - \text{Cost of goods sold} $$

Rearranging gives purchases. If inventory increases, purchases must exceed the cost assigned to goods sold. If inventory decreases, purchases are less than cost of goods sold because some goods sold came from inventory already on hand at the start of the period.

$$ \text{Purchases} = \text{Cost of goods sold} + (\text{Ending inventory}-\text{Beginning inventory}) $$

Next, the payable balance increases when purchases on credit are recorded and decreases when the business pays suppliers. Cash purchases also require cash, but do not pass through accounts payable. Combining cash and credit purchases, the general balance relation is that total purchases minus total cash paid equals the increase in trade accounts payable. This assumes the payable balance changes only through ordinary inventory purchases and supplier payments.

$$ \text{Cash paid to suppliers} = \text{Purchases} - (\text{Ending trade accounts payable} -\text{Beginning trade accounts payable}) $$

Substitute the purchases formula into the payable formula to obtain the complete calculation:

$$ \text{Cash paid to suppliers} = \text{Cost of goods sold} + (\text{Ending inventory}-\text{Beginning inventory}) - (\text{Ending trade accounts payable}-\text{Beginning trade accounts payable}) $$

The signs follow directly from the balances. More inventory means purchases exceeded cost of goods sold, so the inventory change is added. More trade accounts payable means some purchases remain unpaid at period-end, so the payable increase is subtracted. A decrease in trade accounts payable means the business paid more than it purchased during the period, so subtracting a negative change increases the calculated cash payment.

A Balance-Based Derivation

The derivation can be seen without memorizing a sign pattern. Write the inventory rollforward and solve for purchases. Then write the payable rollforward and solve for cash. The following steps show how each balance contributes.

1
Start with inventory.
Ending inventory equals beginning inventory plus purchases less cost of goods sold. Rearranging gives purchases equal to cost of goods sold plus the increase in inventory.
2
Adjust purchases for the payable change.
If trade accounts payable rises, the business has not yet paid that portion of purchases. Subtract the increase in the payable balance from purchases to get cash paid.
3
Substitute and interpret.
Cash paid equals cost of goods sold plus the inventory increase minus the trade accounts payable increase. A decrease in either balance is represented by a negative change, so its effect follows from the same formula.

For a compact check, define \(\Delta I\) as ending inventory minus beginning inventory and \(\Delta AP\) as ending trade accounts payable minus beginning trade accounts payable. Then:

$$ \text{Purchases}=\text{Cost of goods sold}+\Delta I, \qquad \text{Cash paid to suppliers}=\text{Purchases}-\Delta AP $$

This is a derivation from two account rollforwards, not a separate assumption about the direction of each change. It also explains why the formula should be applied to changes in balances, not to closing balances alone.

Worked Example: Inventory and Payables Both Increase

A hypothetical retailer reports cost of goods sold of $480,000. Inventory was $62,000 at the beginning of the period and $79,000 at the end. Trade accounts payable was $48,000 at the beginning and $55,000 at the end. Assuming ordinary inventory purchases and payments, calculate cash paid to suppliers. Use the balance-rollforward method and check the result.

Method. First calculate purchases from the inventory rollforward:

$$ \text{Inventory increase}=\$79{,}000-\$62{,}000=\$17{,}000 $$
$$ \text{Purchases}=\$480{,}000+\$17{,}000=\$497{,}000 $$

Then calculate the increase in trade accounts payable:

$$ \text{Payable increase}=\$55{,}000-\$48{,}000=\$7{,}000 $$

The $7,000 increase represents purchases not yet paid at the end of the period. Therefore:

$$ \text{Cash paid}=\$497{,}000-\$7{,}000=\$490{,}000 $$

Check. The inventory rollforward gives $62,000 + $497,000 − $480,000 = $79,000. The payable rollforward gives $48,000 + $497,000 − $490,000 = $55,000. Both ending balances agree with the data. The common mistake to avoid is treating purchases of $497,000 as if all of them had been paid in cash.

Worked Example: Inventory and Payables Both Decrease

A hypothetical distributor has cost of goods sold of $360,000. Inventory falls from $94,000 to $81,000, while trade accounts payable falls from $52,000 to $39,000. Find cash paid to suppliers and explain why it differs from both cost of goods sold and purchases.

Method. Inventory decreased by $13,000:

$$ \Delta I=\$81{,}000-\$94{,}000=-\$13{,}000 $$

Thus, purchases were $13,000 less than cost of goods sold:

$$ \text{Purchases}=\$360{,}000+(-\$13{,}000)=\$347{,}000 $$

Trade accounts payable also decreased by $13,000:

$$ \Delta AP=\$39{,}000-\$52{,}000=-\$13{,}000 $$

Apply the payable adjustment:

$$ \text{Cash paid}=\$347{,}000-(-\$13{,}000)=\$360{,}000 $$

Cash paid is $13,000 greater than purchases because the business also paid down $13,000 of its opening payable balance. Check: $52,000 + $347,000 − $360,000 = $39,000. The inventory check is $94,000 + $347,000 − $360,000 = $81,000.

Common mistake. Subtracting the $13,000 payable decrease from purchases gives $334,000, which is wrong. The change is negative, so the formula subtracts a negative amount: $347,000 − (−$13,000) = $360,000.

Worked Example: Select the Trade Payable Balance

A hypothetical company reports cost of goods sold of $725,000. Inventory rises from $110,000 to $138,000. Its trade accounts payable to inventory suppliers falls from $64,000 to $50,000. The company also has accrued payroll of $18,000 at the beginning and $23,000 at the end of the period. Assuming no unusual inventory or payable adjustments, calculate cash paid to inventory suppliers. All balances are stated in dollars.

Method. The inventory increase is:

$$ \Delta I=\$138{,}000-\$110{,}000=\$28{,}000 $$

Purchases are cost of goods sold plus that increase:

$$ \text{Purchases}=\$725{,}000+\$28{,}000=\$753{,}000 $$

For this question, the relevant payable is trade accounts payable. Its change is:

$$ \Delta AP=\$50{,}000-\$64{,}000=-\$14{,}000 $$

Accrued payroll is not an amount owed to inventory suppliers and is not included in this calculation. Therefore:

$$ \text{Cash paid}=\$753{,}000-(-\$14{,}000)=\$767{,}000 $$

Check. Inventory: $110,000 + $753,000 − $725,000 = $138,000. Trade payable: $64,000 + $753,000 − $767,000 = $50,000. The result is greater than purchases because the company paid $14,000 more than its current-period purchases, reducing the opening trade payable. Including the change in accrued payroll would incorrectly mix a different type of obligation into the supplier calculation.

Interpreting the Result and Avoiding Scope Errors

The calculation produces a positive amount of cash paid. In a direct-method statement of cash flows, that payment is presented as an operating cash outflow, often in parentheses or with a minus sign. The calculated amount itself should not be made negative merely because it is a cash outflow; presentation determines how the outflow sign is shown.

The method depends on consistent account definitions and clean rollforwards. In particular, the inventory account should reflect ordinary inventory additions and the cost of inventory sold, while the payable account should reflect amounts owed to those suppliers. If balances are affected by write-downs, returns, foreign-currency translation, noncash acquisitions, or reclassifications, the simple equations may need additional adjustments. Do not silently treat such changes as purchases or supplier cash payments.

A useful exam check is to reverse the calculation. Given purchases and cash paid, the payable rollforward must reproduce the ending trade accounts payable. Given purchases and cost of goods sold, the inventory rollforward must reproduce ending inventory. If either check fails, review the balance selected, the direction of the change, and whether an unusual adjustment was included.

Key takeaway: Calculate purchases as cost of goods sold plus the change in inventory. Then subtract the change in trade accounts payable from purchases to obtain cash paid to suppliers. Adding inventory increases and subtracting payable increases is not a memorized sign trick: each sign follows from its account balance rollforward.

Check Your Understanding

For each hypothetical business, use the stated assumptions of ordinary inventory purchases, no unusual adjustments, and trade accounts payable relating only to inventory suppliers. Calculate the requested amount before checking the answer.

  1. A retailer reports cost of goods sold of $250,000. Inventory rises from $40,000 to $46,000, and trade accounts payable rises from $31,000 to $35,000. How much cash did it pay suppliers? (Answer: $252,000)
  2. A parts seller has cost of goods sold of $515,000. Inventory falls from $88,000 to $73,000, and trade accounts payable rises from $44,000 to $49,000. Calculate purchases and cash paid to suppliers. (Answer: Purchases $500,000; cash paid $495,000)
  3. A wholesaler reports cost of goods sold of $620,000. Inventory increases from $120,000 to $132,000, while trade accounts payable decreases from $70,000 to $58,000. Calculate cash paid and verify the direction of the payable adjustment. (Answer: $644,000; the payable decrease increases cash paid relative to purchases)
  4. A company has cost of goods sold of $900,000, and inventory increases by $25,000. It pays suppliers $908,000 in cash. By how much did trade accounts payable change, and was it an increase or decrease? (Answer: Increase of $17,000)
  5. A business reports cost of goods sold of $410,000. Inventory decreases from $63,000 to $58,000, and trade accounts payable rises from $27,000 to $34,000. Calculate purchases and cash paid, then state the two balance changes used. (Answer: Purchases $405,000; cash paid $398,000; inventory decreased $5,000 and trade accounts payable increased $7,000)
Clinical Biostats