Verksamhetskoll Planning · Ledgers

Who pays late? The ledgers know.

Try it yourselfThe demo opens on the Health Check. Ledgers is under Analysis in the menu on the left.

Customer and supplier invoices are fetched from your accounting system every night and reconciled with the books. You see what customers owe, what is overdue, how quickly each customer usually pays and what you sell, item by item. The invoice and its attachment open directly in Verksamhetskoll.

The ledgers are included in Planning, for those with an integration to the books in Hogia, Fortnox or Spiris.

Updated · Written by Cenrotech AB

The demo opens in Swedish. Switch to English with the SV button at the bottom of the demo's menu.

0:00 / 1:43
From the real product, in 7 chapters, with narration. The film is in Swedish. Click the film for sound, or choose a chapter.Fictitious Installation AB in the real product.

What is a ledger?

The ledger is the list of invoices. The customer ledger shows what each customer has been invoiced, what has been paid and what is left, and the total of what is left should match the accounts receivable in the books. The supplier ledger is the same thing the other way round: supplier invoices and accounts payable.

The books tell you how much customers owe. The ledger tells you who, since when and how they usually pay. That difference is what makes follow-up of receivables possible in practice, and what lets you forecast cash from the invoices that are actually outstanding.

Customers: who owes what, and who pays late?

At the top is the position today: accounts receivable, what is overdue, what falls due within fourteen days and how large a share is paid on time. Below that:

  • The ageing analysis. The open invoices by due date, from those that fell due more than sixty days ago to those that fall due in more than a month. Click a bar and its invoices are listed.
  • To follow up. The overdue invoices, oldest first, with customer, amount and how many days ago they fell due.
  • Invoicing. Per month, per customer, item or account, and how large a share comes from the biggest customers.
  • The customer list. For each customer the amount invoiced, the open and the overdue amounts, the payment time and the share of invoices paid on time.

Click a bar or a row and the rest of the page shows only that selection: a month, a customer, an item. Opening the selection shows the key ratios and the invoices behind them, and a click on a customer opens the customer card with all its invoices.

Try it yourself

The ledgers in the demo

The demo opens Planning with the fictitious Installation AB. Click Ledgers under Analysis in the menu on the left. No registration, no figures of your own.

Try it yourself

Suppliers

The same picture the other way round: the unpaid invoices with the supplier's own invoice number, the ageing analysis, purchases per supplier and month and which cost account each supplier is booked to. The To pay list shows what falls due soonest first, so what has to be paid in the next few weeks is visible before it becomes urgent.

The Ledgers tab, Suppliers, for the fictitious Installation AB: accounts payable SEK 4,013,433 in 20 invoices, nothing overdue, SEK 1,757,472 to pay within 14 days and 70 per cent paid on time, the unpaid invoices by due date and the To pay list, soonest first, with the supplier's invoice number, and at the top the message that the ledger matches the accounts payable in the books
The suppliers in the same tab. Fictitious company. Click to enlarge.

What you sell, item by item

The Items tab reads the invoice lines: what you invoice per item, how the item mix changes month by month and which customers buy a given item. It is shown for companies that invoice with items.

The Ledgers tab, Items, for the fictitious Installation AB: invoiced via items SEK 58,776,860, 16 items sold, largest item 22 per cent, the invoicing per month as stacked bars per item and the list invoiced per item
The items from the invoice lines, with the item mix in the bars. Fictitious company. Click to enlarge.

The invoice and its attachment

Each invoice opens in its own window with amount, VAT, paid, remaining, terms, journal entry and the invoice lines, whichever period you are looking at. The invoice as it looks in the accounting system opens with one click.

The same goes for the books: the attachments to a journal entry open from the journal entry in Transactions and Month end, so the path from a figure in the report goes all the way down to the supporting document. Read more about the drill-down on the page about financial reporting.

Customer invoice 10400 to Klockarbyns Fastigheter AB in Verksamhetskoll, 35 days after the due date: the timeline invoiced, due date and not paid, the attachment Faktura 10400.pdf, the amounts and the invoice lines with item, quantity, price and account, and beside it the invoice as a PDF with Installation AB's logo
The invoice in Verksamhetskoll and its attachment beside it. Fictitious company and invented invoice. Click to enlarge.
The files are fetched from the accounting system when you open them and are not stored with us. Payroll attachments are shown only to the person who administers the account.

Reconciled with the books

A ledger that does not match the books cannot be trusted. That is why it is reconciled every night: the open customer invoices against the accounts receivable in the books, and the unpaid supplier invoices against the accounts payable. The result is shown at the top of the tab, so you know the list is the whole truth.

Cash is forecast from the invoices

The liquidity forecast places each open customer invoice on its due date, plus the delay that particular customer usually has, and each unpaid supplier invoice on its due date. What is already overdue is counted as coming in today at the earliest. The How the forecast is calculated box shows the line, how it is calculated and that it comes from the ledgers.

The liquidity forecast for the fictitious Installation AB with the How the forecast is calculated box expanded: the Customers line, kSEK 14,497 from 31 invoices of which kSEK 4,688 overdue, with the explanation that each invoice is placed on its due date plus the counterparty's usual delay, and the Suppliers line with 20 invoices, both marked as coming from the ledgers
The Customers line in the liquidity forecast, calculated from the ledgers. Fictitious company. Click to enlarge.

How the rest of the forecast is built is described on the page about the liquidity forecast.

Ask the AI adviser

"Which customers pay late?" or "How does Grävfast pay?" The AI adviser reads the ledgers: unpaid and overdue amounts, the ageing analysis, the payment pattern and the invoices per customer. In its analyses of the Health Check and the liquidity it brings up what is overdue and the customers who usually pay late without anyone asking, and suggests a follow-up question about the customer that stands out.

The figures are the same as in the tab, and the answer is checked against the data before you see it. How that works is described on the page about the AI adviser.

How you do it in Verksamhetskoll

Ledgers is a tab under Analysis in Verksamhetskoll Planning. It is fetched through the same connection as the books, with nothing to set up.

  • Customers, Suppliers and Items, with the position today, the ageing analysis, what to follow up and the invoicing or purchases per month.
  • A click in a chart or list selects a subset, and the customer and supplier cards show all invoices.
  • The invoice with its lines and attachment, and the journal entry's attachments from the journal entry.
  • Reconciled with accounts receivable and accounts payable in the books, every night.
  • The liquidity forecast counts the open invoices and the customers' payment patterns.
  • The AI adviser answers who pays late and what is overdue.

Storage and AI processing in Microsoft Azure Sweden Central. The connections are described on the page about integrations, and price and terms on the pricing page.

Common questions

Questions that often come up.

What is a customer ledger?
A customer ledger is the list of the company's customer invoices: what each customer has been invoiced, what has been paid and what is left. The total of the open invoices should match the accounts receivable in the books. The supplier ledger is the same thing for supplier invoices and accounts payable.
What is an ageing analysis?
An ageing analysis groups the unpaid invoices by how long ago they fell due, or how long is left until the due date. It shows at once whether the overdue amount is one old invoice or many new ones, and how much is expected in over the next few weeks.
Which accounting systems work?
Hogia, Fortnox and Spiris. The ledgers are fetched through the same connection as the books. A SIE file is not enough, because it contains only the books and not the invoices. SIE 4 is the Swedish standard format for exporting accounting data.
Do the ledgers cost extra?
No. They are included in Planning and in Planning for organisations.
How often are they updated?
Every night, together with the books.
Do you store the invoices?
The invoice data, such as amounts, dates and lines, is stored in your own database in Sweden, like the rest of the books. The files themselves, the invoice as a PDF and the attachments to journal entries, are fetched from the accounting system each time you open them and are not stored.

Further reading

See your own customers and invoices.

Book a walkthrough and we show you the ledgers on real figures and go through what it takes to connect your accounting system.

The demo opens in Swedish. Switch to English with the SV button at the bottom of the demo's menu.