Outstanding By Bill (Payables)
Bills you still owe your suppliers, and when each falls due. There are two reports, both under:
Outstanding by Bill
Lists each supplier's unpaid purchase bills, oldest first, to plan payments by bill.
Set the filters and click Generate:
- Party, Group (starts at suppliers), Category, City and Sr (series).
- Ent Date – when the bill was entered; Doc Date – the date on the supplier's bill.
- Days >= / Days <= – bills at least / at most so many days old.
- Due Date – bills falling due in a period; Due next ___ days – bills due within the next few days, including any already overdue.
- Dues – All, Non-Zero (default), +ve Balance (we owe), -ve Balance (the supplier owes us).
- All / Cash / Credit and Sort By (name, city or collection group).
For each supplier you see the entry number, the supplier's own bill number, entry and document dates, Days (counted from the document date), the Site (credit days allowed), the Due Date, discount, Bill Amt, Paid Amt, Due Amt and a Running total per supplier. Credit days come from the bill when it carries them, otherwise from the day limit in the supplier's account. Rows with a negative bill amount (returns, credit notes) are red. Double-click a bill to open it, or the supplier name to open the account.
Outstanding Summary By Party
One line per supplier instead of one per bill: the date of the first bill, days since the last bill, number of bills, total billed and paid, the first unpaid bill and its age, the Due Amt, the number of unpaid bills, and the date and age of the last payment.
The filters are the same as above, plus Bill Days, First Unpaid >= and Last Pay >= (days) to find suppliers who have not been paid for a long time. Short Rep gives a shorter version of the summary.
Double-click the supplier name to see the ledger, the bill count to list the purchase bills, or anywhere else on the line to see that supplier's outstanding bills.