Plan this week’s vendor payments around cash in hand
Pay the right bills first when cash is short.
- ForOwners and accountants juggling due dates with a tight balance.
- HelperPayables
- ModeBerri Mango 1
- AttachExcel sheet
Copy the prompt
I have Rs [amount] for vendor payments this week. Here are my payables with vendor, amount, due date and any late fee. Suggest what to pay, on which day, and what to hold, with a reason for each.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Payables helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Mode Mango is worth it here: it weighs fees, dates and cash together.
- Ask for a reminder on each payment day.
Plan this week’s vendor payments around cash in handPayables
XLSpayables.xlsx
I have Rs 2,40,000 for vendor payments this week. Here are my payables with vendor, amount, due date and any late fee. Suggest what to pay, on which day, and what to hold, with a reason for each.
Reading payables.xlsx
This plan uses Rs 2,36,500 and avoids every late fee:
| Vendor | Amount | Pay on | Why |
|---|---|---|---|
| Raw material | Rs 1,20,000 | Tue | Late fee 2% |
| Electricity | Rs 38,500 | Wed | Due Thu |
| Packaging | Rs 52,000 | Fri | Due Sat |
| Courier | Rs 26,000 | Fri | Small, keeps credit |
| Printing | Rs 44,000 | Hold | Due in 12 days |
Figures here are made up to show the shape of the answer. Yours come from your own file and words.