Contents
Where it is and who can use itHow the shortfall is foundSources and their costsHow the plan is builtParts of the screenTrying it in the simulationWarnings and notificationsOn the phoneGood to knowWho can change the settings in this windowFinancing Need: which source should close the cash shortfall?
The window finds the weeks in the 13-week cash forecast where cash falls below the minimum level and suggests the sources that close the shortfall in order of cost: credit line, cheque discounting, cheque factoring and invoice factoring.
The suggestion is calculated from existing records: the 13-week cash forecast, the Credit and Limits register, the cheque portfolio and the rates of Cheque/Note Decisions. The screen does not draw any loan, discount any cheque or create documents; it only saves its own settings.
Where it is and who can use it
Open it from the Finance / Bank group in the bottom bar. The cash simulation or financing need permission is enough to view it; cheque numbers and drawers are shown with cheque permission, loan names with credit permission. Settings are changed by an administrator or a user with the financing need permission (Settings › Users › Financing Need).
How the shortfall is found
The base is the same items as Reports › 13-week cash forecast: open receivable and payable invoices, cheques and notes, payment promises, loan instalments, payroll and taxes. A week whose closing cash falls below the minimum cash is a shortfall; the need is the minimum cash minus that week’s cash. If the minimum cash is empty, only a negative balance counts as a shortfall.
Sources and their costs
- Credit line: the available part of the overdraft and credit card limits in the Credit and Limits register. The cost is the loan’s effective annual cost (tax and commission included); interest is added to the debt for the weeks it is used. Limits under a general limit share what is left of the general limit; foreign currency limits are not included.
- Cheque discounting: customer cheques held in the portfolio whose due date comes after the shortfall week. The cost uses the Cheque/Note Decisions formula: interest (amount × rate × days / 360) plus tax, commission and fees. If the cheque bounces, the bank claims the amount back from you (recourse).
- Cheque factoring: the same cheques go to a factoring company without recourse; the bounced-cheque risk passes to the company and the cost is usually higher. If the drawer or the customer who gave the cheque has a bounced-cheque history, the cheque is not discounted and only factoring is suggested.
- Invoice factoring: open sales invoices due within 13 weeks. The factoring company pays the advance rate of the invoice today; the cost is interest on the advance plus a commission on the invoice amount. The rates are entered on the Settings tab; without them invoice factoring is not suggested.
How the plan is built
- Weeks are processed in order. In a shortfall week, sources are used from the lowest effective annual cost upwards; a credit line is drawn only as much as needed, cheques and invoices are used whole.
- If using a large cheque or invoice for a small need costs more than borrowing on a credit line for the same period, the credit line is used first.
- The collection of a discounted cheque or factored invoice does not arrive on its due date; the plan calculates that week accordingly and uses sources again if needed.
- When cash rises above the minimum level, the most expensive credit line is repaid first. If the sources are not enough, the remaining shortfall is shown as Not covered; no figure is invented.
Parts of the screen
Cash shortfall: summary boxes, a 13-week chart (forecast and after the plan, minimum cash line) and the week table. Suggestion: the source steps (week of use, cash received, cost, effective annual cost, collection not arriving on the due date) and credit line usage. Funding sources: all sources in order of cost, with the reason why some cannot be used. Settings: minimum cash, notification threshold, source types and invoice factoring rates.
Trying it in the simulation
The Try in the simulation button passes the plan to the Cash Simulation window as assumptions: for each cheque and invoice the cash received now and the collection that will not arrive on the due date, and one limit assumption for the credit lines. There you can change the plan and see its effect. In the simulation the limit is used when cash falls below zero; the minimum cash is not applied there.
Warnings and notifications
If there is a shortfall, a warning appears in the Attention box of the Owner Dashboard; it is red if the first shortfall is within two weeks or the sources are not enough. If the automatic notification task is on, the shortfall is checked every morning and sent to users subscribed to the Financing need alert in the Notification and Approval Center and to administrators; a shortfall of the same size in the same week is notified once, and again if it doubles. Shortfalls below the notification threshold are not notified.
On the phone
On the phone (Garden and Step interface) the sections are chosen from the step bar at the top: Cash shortfall, Suggestion, Funding sources, Settings. Weeks and suggestion steps are listed as cards in a single column; buttons are sized for finger taps.
Good to know
- The suggestion is a calculation: drawing credit, discounting cheques or factoring is done separately with the bank and the factoring company; as the transaction is recorded in HNR, the cash forecast and the suggestion update by themselves.
- Opening a new loan and postponing supplier payments are not part of the suggestion; you can try them in Cash Simulation.
- If a rate is not set, that source is not suggested; no rate is invented. Cheque rates come from Cheque/Note Decisions › Rates, loan interest from the credit record.
- Figures may come from a cache up to one minute old; the Refresh button recalculates from scratch.
Who can change the settings in this window
The company-wide settings in this window can be changed only by an Administrator. A user with the module right can see the setting, but Save is disabled and the reason (“Only an Administrator can change this company-wide setting — Settings › Users.”) is written next to the button. An empty or incomplete settings request does not reset the setting: an empty request returns 422 and a partial request changes only the setting that was sent. Details: Who can change company-wide settings.
Related guides
- Settings and Log — Making the Program YoursThe Settings window holds two kinds of setting side by side: those that are yours alone (theme, window layout, shortcuts) and those that affect company.
- Finance Module — A Guide from Scratch for Cashiers and AccountingThis guide is for someone who has never used accounting software. You know how to count money; what you will learn here is which document each movement of.
- Bank Transactions — A Guide from ScratchEvery sum that moves through the bank is a collection from a business partner, a payment to a supplier, a bank fee or a transfer between your own accounts.
- Live Bank Connection — A Guide from ScratchIf you have an agreement with your bank, you can receive account transactions directly from the bank without downloading a statement file.
- Late Payment Interest, Collection Reminders and Sales Representative CommissionA late-paid invoice creates three jobs: working out the cost of the delay and passing it on to the customer, reminding the customer of invoices that are.
- Cash simulation (what if I pay this?)The cash forecast for the next 13 weeks already exists in the reports. Cash Simulation puts a "what if I do this?" question on top of that forecast.