To know what a company is owed and what it owes this month, three lists need to come together, the sales invoices still to be collected, the supplier invoices still to be paid and the balance of every bank account. The invoice lists are only reliable once they have been checked against the bank statement, because that is where payments actually show up. Finally, what falls due this month is separated from what is already overdue, and the gap between money in and money out shows whether the month has headroom or a shortfall.
The difficulty is that the answer is usually scattered across the invoicing software, the inbox where supplier invoices arrive and the online banking portal of each bank.
What are accounts receivable and accounts payable?
Accounts receivable are the money customers owe the company, in other words the sales invoices issued and not yet paid, in full or in part. Accounts payable are the reverse, the supplier invoices received and not yet settled.
To answer the question for the month, outgoings with a fixed date that do not come with an invoice are added too, such as salaries, social security contributions, taxes and loan repayments, because they leave the same accounts in the same month.
Three definitions help to read the figures.
- Open. An invoice issued or received that has not yet been paid in full.
- Not yet due. An open invoice whose due date has not passed.
- Overdue. An open invoice whose due date has already passed.
Why is the bank statement the point of control?
The invoicing software knows what the company has invoiced, but it does not always know what has been collected. If nobody records the receipt, the invoice stays open for months after the money has arrived. The same happens with suppliers.
The bank statement is the source that records what actually came in and went out. That is why the lists of open invoices can only be trusted once each transaction has been linked to the invoice it pays, which is what bank reconciliation means. This is where the most common errors appear.
- Unmatched receipts. The customer has paid, but the invoice is still open, and the company chases someone who has already paid.
- Partial payments. A customer pays part of an invoice and the remainder is forgotten.
- One transfer for several invoices. The amount received does not match any single invoice and stays unidentified.
- Credit notes and duplicate invoices. An invoice that was cancelled or recorded twice makes it look as if more is owed, in either direction, than really is.
How do you work out what is owed and what is due, step by step?
- Gather the sales and purchase invoices. Sales invoices come from the invoicing software and purchase invoices arrive by email, on paper and as PDFs. Those from earlier months that are still open are included.
- Import the statements for every account. A forgotten account hides receipts and payments and leaves invoices open that have already been paid.
- Reconcile. Link each transaction to the matching invoice, with the right amount for partial payments and for payments covering several invoices. Anything without a match goes to a separate list to be cleared up.
- List what is still open. Sort sales invoices by customer and purchase invoices by supplier, with the amount outstanding and the due date.
- Separate this month from the arrears. In each list, distinguish what falls due before the end of the month from what is already overdue.
- Work out the month's position. Take the balance of every account, add what is expected to come in during the month and subtract the invoices due for payment in the month and the other outgoings with a fixed date.
After that, only the new transactions need handling, and in months when the balance is tight it is worth repeating the routine every week.
How should overdue amounts be handled?
Grouping overdue amounts by how long has passed since the due date, in an aged debtors and creditors report, shows where the risk lies and where to start.
| Status | Customer side | Supplier side |
|---|---|---|
| Due this month | Counts towards the month's inflows | Counts towards the month's outflows |
| Up to 30 days overdue | Remind the customer and confirm the invoice was received | Pay, or agree a new date with the supplier |
| 31 to 90 days overdue | Contact the customer and agree a payment plan | Settle before it affects supply |
| More than 90 days overdue | Review with management and the accountant | Check whether the invoice is correct or in dispute |
As a matter of prudence, overdue amounts on the customer side should not enter the month's figures as if they were certain, because they may arrive tomorrow or not at all. Showing them on a separate line gives management two figures, the month's position without the arrears and what would come in if they were recovered. It is the same principle behind the 12-month cash flow forecast, which extends this view to the months ahead.
It is also worth reading overdue amounts customer by customer, because arrears concentrated in a single customer are also a case of dependence on the largest customers.
How does EngiFinance help track what is to be collected and paid?
EngiFinance is an online treasury management application for SMEs. It imports the company's bank statements and documents, categorises and reconciles the transactions, shows the cash flow and what is still to be collected, and prepares the monthly export for the accountant.
- Statements from several banks and accounts, imported by file, in CSV, Excel, CAMT.053 or MT940, with PDF statements read by artificial intelligence and no access to the bank accounts. The treasury view shows the consolidated balance and the balance per account.
- Sales and purchase invoices. The Portuguese tax authority's QR code is read directly and, on documents without a QR code, the AI reads the number, the dates, the tax numbers, the totals and the description. Whether a document is a purchase or a sale is identified by the company's tax number.
- Reconciliation. Suggestions use the amount, the date and the tax number, number or name in the bank description, and reconciliation is automatic only when the match is clear and has no close alternative. Partial payments and payments of several invoices keep the amount of each link.
- Outstanding and overdue. The application shows the outstanding and overdue balances for each customer.
- Forecast. The 12-month forecast counts inflows from invoices to be collected and outflows from invoices to be paid, VAT and regular payments, with overdue amounts kept apart, outside the forecast balance.
EngiFinance does not issue invoices. It reads the sales invoices issued in the invoicing software the company already uses.
A practical example
Imagine an electrical supplies distributor with 15 people and accounts at two banks. At the start of November, the invoicing software shows €48,000 in sales invoices still to be collected, and the two accounts hold €32,000 between them. When she reconciles October's statements against the invoices, the office manager finds two items to deal with.
- One customer paid two invoices in a single €6,000 transfer that nobody had matched.
- Another customer paid €2,000 of a €5,000 invoice, and the remaining €3,000 is still open.
Once the links are made, the amount to be collected falls to €40,000. Of this, €26,000 falls due in November and €14,000 is already overdue, including €9,000 from a single customer that is more than 60 days late. On the outgoing side, there is €17,000 in supplier invoices due in November and €25,000 in salaries and contributions.
Leaving the overdue amounts aside, the month's position is €16,000, the result of €32,000 plus €26,000, less €17,000 and less €25,000. If the overdue amounts were recovered, it would rise to €30,000. With these two figures, management decides three things.
- Contact the customer with €9,000 overdue and agree a payment plan.
- Pay suppliers in order of due date.
- Repeat the reconciliation every week until the end of the month.
Done this way, the answer to the question "how much do we have to collect and pay this month" stops being a one-off calculation and is ready whenever management asks it.
Frequently asked questions
What is the difference between invoiced and collected?
Invoiced is the value of the invoices issued. Collected is what has already reached the bank accounts. The difference between the two, invoice by invoice, is what is still to be collected, and it is only certain once the statement has been reconciled.
How often should receivables and payables be reviewed?
At least once a month, before the close. In months when the balance is tight, a weekly review leaves time to collect, negotiate terms or reschedule payments.
Should overdue amounts count towards the month's inflows?
Not as certain amounts. It is more prudent to show them on a separate line, so that management sees the month's position without them and what would come in if they were recovered.
What is an aged debtors report?
It is the list of open amounts grouped by how long has passed since the due date, for example up to 30 days, 31 to 90 days and more than 90 days. It shows where the risk lies and where to start collecting.
Does EngiFinance show what each customer still owes?
Yes. It shows outstanding and overdue balances per customer. EngiFinance does not issue invoices and reads the sales invoices issued in the invoicing software the company already uses.
Is access to the bank accounts required?
No. In EngiFinance, statements are imported by file, in CSV, Excel, CAMT.053 or MT940, and PDF statements are read by artificial intelligence.