Liquidity report
See which incoming and outgoing payments are coming up and how the balance on your bank accounts is expected to develop.
The liquidity report gathers what Kleer already knows about your incoming and outgoing payments: authorised customer invoices, authorised supplier invoices, salaries, taxes and VAT.
Choose how the report is shown
| Field | What it controls |
|---|---|
| Number of periods | How many periods ahead the report shows. |
| Period | The resolution: day, week or month. |
| Total overdraft facility | Filled in by you. If you enter an amount, the report shows an extra column for closing balance with the overdraft facility included, and the chart shows two lines, with and without the overdraft facility. |
| Excluded bank accounts | Bank accounts that should not be included, if an account does not belong to the liquidity you are following. |
| Start date | Todayâs date by default. If you choose an earlier date, the report shows how the total of the companyâs own bank accounts has developed from that date until today, with the change in a column of its own, Change for the period. |
| Show diagram | Clear it if you only want to see the table. |
Number of periods, period, overdraft facility and excluded bank accounts are saved for the next time you open the report.
The columns in the report
Each row in the report is a period. The columns show what is expected to come in and go out during the period.
Year and period
The year the period falls in, and then the period itself: the week number with a date range, the date for the day, or the name of the month, depending on the period you chose.
Opening balance
The total of the companyâs own posted bank accounts on the first day of the period.
Overdue customer invoices
Authorised customer invoices where the due date has passed. Either the payment is coming soon, or it is a receivable that is unlikely to be paid.
Doubtful receivables are currently included in this column. Contact your Kleer consultant if you want to reserve an invoice as a doubtful receivable.
Customer invoices for the period
Authorised customer invoices with a due date within the period that have not yet been paid.
Overdue supplier invoices
Authorised supplier invoices where the due date has passed, that is, the ones that should probably be paid straight away.
Supplier invoices for the period
Authorised supplier invoices with a due date within the period. Both those that have been sent for payment and those that are authorised but not paid are included.
Salary
Payroll runs within the period, plus the calculated amount from open payslips with a calculated payment date within the period.
Tax and social security contributions
Tax and social security contributions on salary payments with a payment date the month before. The payment is expected on the 12th or 17th of the month. When the employer declaration has been filed and the invoice to the Swedish Tax Agency has been created, the amount moves from this column to the supplier invoices.
Preliminary tax (F-tax)
Charged preliminary tax to pay, expected on the 12th or 17th of the month. When the invoice to the Swedish Tax Agency has been created, the amount moves to the supplier invoices. Your own decision from the Swedish Tax Agency shows what applies to you.
VAT
Calculated from the field VAT to pay or get back in the VAT report. The dates follow the companyâs VAT period, which can be monthly, quarterly or yearly. When the VAT has been declared and the invoice to the Swedish Tax Agency has been created, the amount moves to the supplier invoices.
VAT is affected by authorised invoices and receipts, so it can change from day to day until it has been declared.
Closing balance
The opening balance plus incoming payments from customer invoices, minus supplier invoices, payments to the Swedish Tax Agency and salaries.
The report as a widget
The chart can also be added as a widget on the start page in Kleer. Go to the start page and add a new widget.
Good to know
The report is based on what has been authorised and created in Kleer. It cannot know anything about what you have not yet registered, and it becomes more accurate the more up to date the authorisation is.
You can download the report to Excel if you want to keep working with your own assumptions.