A wholesaler can be profitable and still run out of cash. The usual cause is timing: customers pay on 30-day terms, suppliers want payment sooner, and stock sits in between. This lesson shows how to compare receivables with payables, see where cash is tied up, and find the Reyuko screens that give you each number.
Key takeaways
- Working capital is cash, plus what customers owe you, plus stock, minus what you owe suppliers soon.
- Payment > Receivable shows customer invoices. The payable screen under Payment shows supplier bills. All the Payment screens in this lesson are on the Advanced level.
- Aging AR/AP shows how old each balance is, from its due date.
- Reyuko has no working capital report. You compare the figures yourself.
- A cheque recorded against an invoice settles that invoice before the cash reaches the bank.
Receivables are money customers owe you. Payables are money you owe suppliers. If you collect more slowly than you pay, you need cash from somewhere else to cover the difference. Stock adds to the gap, because cash spent on goods is not back in the bank until you sell and collect.
Read the receivable side
Illustration: Harbor Wholesale is a fictional business; numbers are examples.
Open Payment > Receivable. It lists unpaid customer invoices with Amount, Paid, Balance and Due Date. The status chips include Unpaid, Partial, Paid and Overdue. Overdue is worked out live: an invoice that is Unpaid or Partial and past its due date.
Then open Payment > Aging AR/AP and choose Receivable (AR). Reyuko ages each balance from its due date, not its invoice date. Harbor Wholesale's receivables look like this:
| Bucket | Amount |
|---|---|
| Not Due | 70,000 |
| 1-30 days | 30,000 |
| 31-60 days | 12,000 |
| 61-90 days | 5,000 |
| Over 90 days | 3,000 |
| Total | 120,000 |
Overdue money is the total minus Not Due: 50,000, or about 42 percent of the book. The aging screen groups by customer and has no as-of date, so use Payment > Receivable to see the invoices behind a bucket.
Read the payable side
Open Payment > Aging AR/AP and choose Payable (AP). Harbor owes suppliers 85,000 in total. Put the two sides together:
| Item | Amount |
|---|---|
| Receivables (customers owe you) | 120,000 |
| Payables (you owe suppliers) | 85,000 |
| Net trade credit Harbor funds (receivables minus payables) | 35,000 |
The 35,000 is not a deficit. Receivables are larger than payables, so 35,000 of Harbor's own cash is tied up as credit to customers. Harbor must fund it from cash or from stock turning into sales. Check the stock too: Inventory value by location in the Reports shows how much money sits in goods. High stock plus old receivables makes the gap larger than it looks.
Where a cheque can mislead you
A cheque recorded against an invoice is treated as paying that invoice at once, but the cash has not reached the bank. The cheque shows as Pending in Payment > Cheques & Giro. The cash account rises only when you click Confirm Clearance. An invoice can leave the receivable list while the money is still in transit. Count pending cheques as cash you do not have yet.
Forecast the next 30 days
The Dashboard's 30-Day Cash Projection widget (Advanced, off by default, turned on with Customize) adds cash and bank to receivables due in 30 days and subtracts payables due. It leaves out wages, rent, tax and unbilled purchases, so treat it as an upper estimate; the real figure is likely lower.
- Open Payment > Receivable and choose the Overdue chip to see late invoices.
- Open Payment > Aging AR/AP, choose Receivable (AR), and note the Total Outstanding card.
- Switch to Payable (AP) and note the total owed to suppliers.
- Open the Reports for Inventory and run Inventory value by location.
- Open the Dashboard, click Customize, and add the 30-Day Cash Projection widget.
Reyuko's Sales Return may not reduce the balance shown in Payment > Receivable. Test one return and check the balance before you use return figures in planning.
Check yourself: the gap grows
Receivables rise from 120,000 to 150,000 while payables stay at 85,000. What is the gap, and what do you check first? Answer: the gap is 65,000. Check the 31-60, 61-90 and over 90 day buckets first, because the new money is probably late.
Reyuko