Add "Planned/Expected Payment Date" and Column Customisation on Aged Creditors

Idea suggested by Gareth Ricketts 6 days ago

Hi Clearbooks Team,

First off, love using the platform—it keeps our daily bookkeeping so clean and straightforward!

I wanted to post a suggestion regarding the Aged Payables / Aged Creditors reporting view that I think would bring huge value to anyone running weekly supplier pay runs.

The Current Challenge: When conducting a weekly or monthly supplier payment run, we frequently run into invoices that are under query or dispute (e.g., missing delivery tickets, incorrect pricing, or waiting on a credit note).

Right now, there isn't a native way to flag these invoices on the Aged Payables summary screen without manually altering the actual Due Date (which distorts true credit term reporting) or exporting the data to Excel every week to filter out queried items manually.

Proposed Feature / Functionality Request: "Planned / Expected Payment Date" Field on Bills:

Add an optional Planned Payment Date field to incoming supplier bills.

When an invoice is queried, we can set the planned payment date into the future (or set a status to On Hold).

On the Aged Payables report, allow users to filter or sort by Planned Date rather than just the strict Invoice Due Date.

Visible Notes / Status Column on Aged Payables Report:

Allow users to customize columns on the Aged Payables detail view to display the Invoice Note / Reference / Status field.

This allows us to see why an invoice is sitting on the report (e.g., DISPUTE: Missing PO) directly from the top-level list without opening each bill individually.

Why This Helps the Community: Prevents Payment Errors: Stops accounts teams from accidentally paying queried/disputed invoices during batch payment runs.

Saves Weekly Admin Time: Eliminates the need to export payment runs to CSV/Excel just to apply basic filters.

Preserves Accounting Integrity: Keeps original invoice due dates accurate for auditing while offering flexibility for real-world payment scheduling.

Would love to hear if other users would find this useful, or if the dev team has any plans for enhanced payment run controls on the roadmap!

Thanks!

Reply to this idea

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are