How to report invoice due dates against a chosen date
A due-date report helps identify which invoices need attention under a specific cutoff rule. It is useful when the payment status and date basis are clear.
Start with the right material.
- What you provide
- a visible invoice list with statuses and due dates.
- The intended result
- Create an unpaid-invoice due-date list ordered by explicit date.
How the workflow works.
Choose a reference date and separate unpaid, paid and unknown-status invoices. Compare explicit due dates with that reference, retaining original invoice identifiers so exceptions can be investigated.
What to check in the result.
Check the treatment of invoices due on the reference date and those without a due date. Missing dates or payment information should be flagged rather than converted into assumed overdue balances.
Import the CSV with a consistent delimiter and inspect text identifiers, dates and amounts before using spreadsheet totals. Keep the original file available while checking any automatic type conversion.
Learn from the worked example.
The downloadable CSV example uses these columns: Invoice, Status, Due date. Compare a complete record with the source before sorting, combining or importing your own output.
The supplied example is illustrative. It is not a recorded run on your data.
Download the example ↓Use it with your own material.
- Open the source you want to work with and activate WebAct on that tab.
- Copy the task from the hero, add any required fields or preferences, and review the proposed actions.
- Compare the first result with your source. Ask for a specific correction or refinement where needed.