The Treasury Reports page answers the questions that a treasurer asks each week. How fast do your clients pay you? How much of what they owe is late? When do your cheques and bills of exchange fall due, and how fast does the bank pay them? How much of your bank statements have you matched?
You type nothing on this page. Beelocity works out each figure from your sales invoices, your receipts and payments, your cheques and bills of exchange, and your bank statements. It shows every amount in your base currency, which is your organization’s Default currency.
Opening the page
Open Treasury → Cash forecast in the sidebar, and then its Treasury Reports tab. The reports sit on four tabs of their own: Working Capital, Collections, Instruments and Reconciliation. You see a tab only if your role can read what it counts:
- Working Capital needs your sales invoices.
- Collections needs your sales invoices and your payments.
- Instruments needs your cheques.
- Reconciliation needs your bank statements.
The Treasurer, the Cashier and the owner of your organization see all four tabs. If your role can see only some of the invoices or payments, each figure counts only those.
Working Capital
How long your money stays with your clients.
- Days to pay says about how many days your clients take to pay you. Beelocity divides what your clients owe today by what you invoiced in the window, and multiplies by the days in the window. So it is a ratio, and not a delay that Beelocity measured on each invoice. For example, clients who owe 2,400,000 DA after you invoiced 6,000,000 DA in 90 days give 36 days. A rising figure means that money stays longer with your clients. If you invoiced nothing in the window, the card shows —. The Sales tab of the dashboard shows the same figure, over the dashboard’s own dates.
- Open receivables is what your clients still owe today on invoices that are Sent, Partially paid or Past due, for example 2,400,000 DA. The window does not change it.
- Credit sales over the window is the total of the invoices dated in the window, paid or not, for example 6,000,000 DA. An invoice that is a Draft, Cancelled or Void does not count.
Use the From and To dates to set the window. If you leave them empty, the window is the 90 days up to today. The same dates appear on the Instruments tab. They reach Days to pay, Credit sales over the window, and the three figures under How quickly cheques are paid. Every other figure on this page is as of today.
What the page does not show. How long you take to pay your suppliers, what you owe them by age, and the cash conversion cycle are not on this page. Beelocity records your supplier invoices, but it does not work out these figures.
Collections
What your clients owe, by age, and the money that no document holds.
- Total receivables is what your clients owe today on every open invoice. Its badge counts the invoices.
- More than 90 days overdue is the part that is more than 90 days late, for example 85,000 DA on three invoices. It is the money that is hardest to collect, so chase it first.
- Receivables by age splits what your clients owe by how late it is, in five bands. The bands are Not yet due, 1 to 30, 31 to 60 and 61 to 90 days overdue, and More than 90 days overdue. Press a bar to open the list of its invoices.
Pick a client in Client to see what that client alone owes. This filter does not reach the money on account below.
If an invoice is in a currency with no rate on file for today, the ageing still counts it in its band. It leaves the invoice’s amount out, and a note above the cards says how many invoices it left out.
Under Money not yet matched to a document, the tab shows the money on account:
- On account in total is the money on confirmed payments that no allocation ties to a document. The receivables ageing does not take it off what your clients owe.
- From clients is money that clients paid you and that no invoice holds. It is often a payment that named no invoice.
- To suppliers is money that you paid to suppliers and that no document holds. It is often a payment larger than its bills.
- Waiting to be matched lists each payment that holds money on account, largest first, up to 100 of them. Press a payment’s number to open it.
The label says waiting, but nobody can match this money later. A payment’s allocations change only while it is a Draft, and each payment here is Confirmed, Cleared or Reconciled. So the money stays on account. To keep it off this list, allocate each payment to its documents before anyone confirms it. Wages and declaration payments never count here, because they settle a payslip or a declaration.
Instruments
When your cheques and bills of exchange fall due, and how fast the bank pays them.
Pick an account in Deposit or drawing account to see the paper on that account alone. This filter does not reach the figures on how quickly cheques are paid.
Under Cheques and bills of exchange coming due:
- The card Held, coming due adds up the received cheques and bills of exchange that are still in your hands or at the bank. Their status is Received, Remitted for collection or Remitted for discount.
- The card Issued, coming due adds up the paper that you issued and that your bank has not paid yet. Its status is Issued or Presented.
- Held paper by due date and Issued paper by due date group the same paper by its due date. The bands are Past due, Due within 7 days, 8 to 30 days, 31 to 60 days and More than 60 days. Each band gives a count and an amount.
Past due means that the due date has passed and the paper has not cleared yet. If you still hold a received cheque that is past due, put it on a deposit slip. If it is already on a slip, ask the bank. Issued paper that is past due is for the supplier to present, or for your bank to pay.
Under How quickly cheques are paid:
- Average days to be paid is how many days pass, on average, from a slip’s Deposit date to the day its paper cleared. For example, it can read 5.5 days. It counts the received paper that cleared in the window, cheques and bills of exchange alike. Paper that cleared without a slip does not count, and neither does paper that you recorded by hand. The forecast does not allow for this delay, because it counts received paper on its due date.
- Share returned unpaid is the share of the paper on slips with a Deposit date in the window that came back Bounced. For example, it reads 10% when 2 pieces of 20 came back. A high share is a credit risk.
- Speed by account gives the average days to be paid for each deposit account, because banks differ.
Reconciliation
How far your records agree with the bank.
Pick an account in Account to see its figures alone.
- Share matched is the share of your statement lines that you matched to cash-ledger entries, for example 92.31%. It counts lines, and not amounts. It reads every statement, whatever its dates, because this tab has no window. A statement that you set aside, with Active switched off, does not count. Lines that you ignored count on neither side. A low share means that your ledger may not agree with the bank.
- Still to be matched is what the unmatched lines add up to. You cannot lock a statement while one of its lines is unmatched.
- Average certainty says how sure Beelocity was, on average, about the lines that Match automatically matched. The amount always agrees, so a lower figure means that the dates or the references agreed less. Lines that you matched by hand do not count. The figure under it counts the lines that you ignored.
- Matched by account gives, for each account, how many lines are matched, how many are not, and the share matched.
Where the numbers come from
Each report counts what you already keep:
- Days to pay and the receivables ageing read your sales invoices that are Sent, Partially paid or Past due. Days to pay also reads every invoice dated in the window, paid or not.
- Money on account reads your confirmed receipts and payments that name a partner, for the part that no allocation covers.
- Paper coming due reads your cheques and bills of exchange. Average days to be paid also reads your deposit slips, and the day that each piece cleared.
- Share matched reads the bank statements that you keyed in, and how many of their lines you matched.
Beelocity converts each foreign amount at the latest rate on file on or before today. So these are figures to read, and not fixed values. If a rate is missing, the cards that need it show no figure, and a note names the currency and the day. The receivables ageing is the one exception, as Collections says above. The Treasurer or the owner of your organization can enter the rate on the Exchange rates page.
“Data as of” — how fresh the numbers are
The badge at the top of the page reads Figures as of and a time, such as Figures as of 10:42. It gives the time when Beelocity worked out the oldest figure on the page.
Beelocity keeps each figure for five minutes at most, so that moving between tabs and changing filters stays fast. Most steps that move money or change what clients owe make it work the figures out again at once. A new or changed exchange rate does the same. If you have just confirmed a receipt and you do not see it yet, reload the page in your browser.