A Purchase Bill is the supplier's invoice in Reyuko. Once you post it, it becomes a payable: money you owe the vendor, with a due date. This lesson shows how the bill creates the payable, how the due date is set, and how to read the payables aging report to see which vendors are late.
Illustration: Harbor Wholesale is a fictional business; numbers are examples.
Key takeaways
- A Purchase Bill creates the payable. A Purchase Delivery moves stock but does not create the payable.
- The due date comes from the payment terms on the document. You can change it on the document.
- Aging AR/AP shows vendor balances in five buckets, counted from the due date.
- The payables aging shows totals per vendor. It has no as-of date and no per-bill detail.
- Opening payables entered as one total do not show per vendor on the aging report.
From Purchase Delivery to Purchase Bill
In Reyuko, the Purchase Bill is created from a Purchase Delivery. The reference list shows Purchase Delivery numbers. When you pick one, the vendor and the lines are copied, and you can edit the quantities.
When you post the bill, the journal clears the goods-received-not-invoiced account (2-1103), records input tax if the bill has tax, and credits accounts payable (2-1001 in the standard chart).
Due dates from payment terms
The Purchase Bill has a Payment Terms card. Choose the terms, and Reyuko fills in the Due Date as the document date plus the grace period of those terms. You can overwrite the due date on the document.
For example, a bill dated 1 October on Net 30 terms is due on 31 October. The terms themselves are set up in Payment > Payment Terms. See supplier payment terms.
Reading Aging AR/AP for payables
Open Payment > Aging AR/AP and select Payable (AP). The report uses the same five buckets as the receivables side: Not Due, 1-30 days, 31-60 days, 61-90 days and >90 days. Age is counted from the Due Date, against today.
Here is an example for three vendors:
| Vendor | Not Due | 1-30 days | 31-60 days | 61-90 days | >90 days | Total |
|---|---|---|---|---|---|---|
| Ricefield Mill | 6,000,000 | 0 | 2,000,000 | 0 | 0 | 8,000,000 |
| Spice Trader | 0 | 1,500,000 | 0 | 0 | 0 | 1,500,000 |
| Packaging Supplies | 0 | 0 | 0 | 0 | 900,000 | 900,000 |
| Total | 6,000,000 | 1,500,000 | 2,000,000 | 0 | 900,000 | 10,400,000 |
Ricefield Mill owes 8,000,000, of which 2,000,000 is 31 to 60 days late. Packaging Supplies is more than 90 days late on its whole balance. Overdue money is the total of the four late buckets: 10,400,000 minus 6,000,000, which is 4,400,000.
What the report does not show
The report has one filter, a search box for the vendor name. It has no as-of date and no per-bill detail. Use Export to save the table as CSV. The reminder tools on the Aging page, Bulk reminders and Prepare collection, work on the receivables side only.
- Open Purchase > Purchase Bill and check the Due Date on any bill that looks wrong.
- Open Payment > Aging AR/AP.
- Select Payable (AP).
- Sort the table by >90 days or 61-90 days to see the oldest vendor balances first.
- Note the vendor name, then open Payment > Payable and search for that vendor to see the bills.
- Click Export if you need a CSV copy.
Entering last year's unpaid bills as one payable total in Opening Balances. That total is posted as one line, so the vendor does not appear on the payables aging. Reyuko does not currently provide an opening payable per vendor. Check your version before you choose a method for old bills.
Check yourself: which bucket?
A bill dated 1 September is on Net 30 terms, so it is due on 1 October. Today is 24 October. Which bucket is it in?
It is 23 days past the due date, so it is in 1-30 days. The bill date does not matter. Only the Due Date counts.
Reyuko