Reports

What has been invoiced over recent months and which customers the outstanding amounts sit with.

Sales invoices per month

Total of invoices issued, gross. July is not yet complete — as at 31 July.

February: $198,450.00
March: $243,180.00
April: $221,740.00
May: $187,920.00
June: $256,310.00
July: $169,480.00

Customers with the largest outstanding amounts

No rating of customers — only totals, item counts and due dates.

Account no.	Customer	Outstanding	Items	Oldest item due	Agreed payment terms	Status
10255	CustomerWinstanley Metalwork	Outstanding$31,204.80	Items3	Oldest item due10 Jul	Agreed payment terms45 days net	Statuscomplaint open
10088	CustomerRadcliffe Motors	Outstanding$19,004.30	Items2	Oldest item due26 Jun	Agreed payment terms30 days net	Statusinstalment agreement
10247	CustomerAshcombe Engineering	Outstanding$18,750.00	Items1	Oldest item due14 Aug	Agreed payment terms30 days net, 2 % discount	Statusnot yet due
10064	CustomerFairbrook Farm Machinery	Outstanding$14,821.75	Items1	Oldest item due22 May	Agreed payment terms30 days net	Statusreminder level 2
10429	CustomerCarrow Electrics	Outstanding$12,980.00	Items2	Oldest item due3 Jul	Agreed payment terms30 days net	Statusreminder level 1
10390	CustomerThorncroft Plant Services	Outstanding$4,980.00	Items1	Oldest item due8 May	Agreed payment terms14 days net	Statuslevel 3 proposed

6 of 23 customers with outstanding items · shown total $101,740.85 of $182,417.60

Reports on demand

Every list can be output as a table and handed to the tax firm.

Outstanding items at a cut-off date
as at 31 July · 47 items
Grouped by due date, with reminder level, payment terms and agreed instalments.
List
Ageing structure by age band
not yet due through over 60 days
The same bands as on the overview, broken down by customer as well.
Report
Early-payment discounts
taken and not taken
Which customers took the discount and on which invoices the discount period lapsed unused.
Report
Credit notes and cancellations
current financial year
Every credit note with its reference to the sales invoice and the reason captured when it was raised.
List
Reminder history per customer
last 24 months
Which levels were created when, and how many days passed afterwards until payment arrived.
Report

The project frame

How Awelior would approach this project

Colworth Plastics is invented — the way it is built is not. None of this is work delivered for a client. It is the shape we would give such a project — with the same depth, but without a client who would have to answer for it.

Where it starts

At Colworth Plastics the outstanding items sit in a spreadsheet, the reminder run in a handwritten calendar, and when sales want to know whether a customer has paid, they phone accounts. The question is not whether reminders go out but whether they go out in time — and whether anyone knows first that a customer is in the middle of a negotiation.

Decisions

The reminder run is a process with an approval
A list is proposed and sent after approval. Chasing automatically is technically easy and commercially risky: one reminder to the wrong customer costs more than the entire time saved.
Invoice records, not invoice rows
Every invoice has a view of its own with lines, steps and history. Only there does it say why an item is open — and that is the answer sales need on the phone.
Reporting on its own screen, not as the entry page
The entry screen shows what has to happen today. Reporting sits alongside because it answers a different question — key figures as a start screen are the fastest route to a system that looks good and helps nobody.

Deliberately left outNo bookkeeping. This is the receivables view and not a finance ledger: chart of accounts, VAT and year-end stay where they belong, and this system feeds them.

What is in it

Screens: 5
Content blocks: 18
Languages: 4

Five screens, in all four languages, with sidebar, header and stated role. Navigation works; tables, board, calendar, charts, step chains and forms are rendered and inert. Invoice numbers, customers and amounts are invented.

How it would go on

Payment matching
Importing bank statements and allocating payments — automatically where it is unambiguous, and with a worklist for the rest.
Connection to the ledger
Invoices, payments and reminder stages have to flow both ways, or a second version of the payment status appears.
Escalation
What happens after the third reminder: delivery stop, debt collection, court proceedings — with clear responsibilities.

Talk through your project

Sample data

An application like this for your business?

Ledger Book is invented — the way it is cut is not. Applications like this come out of the processes a business already runs.

Talk about a solution Back to the software solutions The service page: Business software

Sample application by Awelior. Invented business, invented data, nothing stored.