On this page
10.14Collection Register: Bills Due, Supplier Bills, Agents
The Outstanding Report gives one balance per party. The Collection Register breaks it into bills: which bill is unpaid, how much of it is left, when it was due and how many days late it is. It works for parties kept bill by bill, so first tick Maintain Bill By Bill Balance in the account and fill Credit Days for Sale (customers) or Credit Days for Prch (suppliers) (4.7). The due date of a bill is the bill date plus those credit days.
- Open Reports → Bill-By-Bill Reports → Bill By Bill Collection Register. The screen is headed COLLECTION REGISTER.
- Choose how From and To are read: Bills Made within (bill dates, the default), Bills Due within (due dates) or Due Upto Date (everything due on or before the To date).
- Tick the kind of bills: Receivable (customers, on by default), Payable (suppliers), Cleared (fully paid). Due keeps bills due on or before the To date; Undue keeps bills not yet due.
- Press OK. Each row shows the bill with Bill Amt, Adj. Amt (paid so far), Balance, Due Dt. and Days (days past the due date). Total Amt. is at the bottom.
| Question | Set the register like this |
|---|---|
| Which supplier bills fall due this week? | Untick Receivable, tick Payable. Choose Bills Due within. In From press W (Monday), in To press K (Sunday). |
| Which customer bills fall due in the next 30 days? | Receivable, Bills Due within, From = today, To = 30 days ahead. Keep the To date inside the financial year. |
| Which salesman's customers are not paying? | Due Upto Date, To = today. Press Search, type the agent's name in Agent and press Search in the panel. |
| Everything overdue today | Due Upto Date, To = today, Receivable and Due ticked. |
Read every step in the guide: Financial Accounting, section 10.14
Questions and answers
A customer does not appear in the Ugrahi Register.
Tick Show Debtors Only, and check the customer's balance is above zero (or tick Show Parties With Zero or Negative Balance Also {All}). If an account brought in by import still does not show, open it once in Masters → Accounts and press Update.
Can I charge interest on each late bill from its own due date?
Yes. In the Collection Register type the yearly rate in Interest @ and press OK. Each late bill shows its interest (10.15). Book it with a Journal if you decide to charge it.
How much money will come in over the next 30 days?
Reports → Bill-By-Bill Reports → Aging Analysis, Bills yet to Due, Receivable: read the (0-30) Days total. Run it again with Payable for what goes out (10.19).