Follow

The finance charts

All key figures for the financial charts are issued in the standard currency in which you keep your accounting together with the gross prices (including VAT). In addition, all postings in a foreign currency (invoices, supplier invoices, etc.) are converted for the financial charts using the stored exchange rate. → “How does bexio handle foreign currencies?

Overview


The financial charts in the dashboard

The financial charts can be found in the dashboard under the “house symbol” and for the invoices under “Sales” → “Invoices” → “Overview”. Additional information about the dashboard: Dashboard - Financial cockpit & personal home page

Bildschirmfoto_2020-05-06_um_10.17.35.png


Open invoices (accounts receivable)

Total value of all unpaid invoices/accounts receivable (“Sales” → “Invoice”). The total or residual amounts of the invoices with the “Open”, “Partial”, and “Overdue” statuses are taken into account.

Status Description of criteria Period
Open

All unpaid invoices that have not reached the payment deadline.

All invoices that have ever been created in bexio and that satisfy the criteria.

Overdue

All unpaid invoices that have already exceeded the payment deadline.

All invoices that have ever been created in bexio and that satisfy the criteria.


Open supplier invoices (accounts payable)

Total value of all unpaid supplier invoices/accounts payable (“Purchasing” → “Supplier invoices”). The total or residual amounts of the supplier invoices with the “Open”, “Partial”, and “Overdue” statuses are taken into account.

Status Description of criteria Period
Open

All unpaid supplier invoices that have not reached the payment deadline.

All supplier invoices that have ever been created in bexio and that satisfy the above criteria.

Overdue

All unpaid supplier invoices that have already exceeded the payment deadline.

All supplier invoices that have ever been created in bexio and that satisfy the above criteria.


Cash or cash equivalents receipts and expenditures

Under "Income" & "Expenditures", the figures from postings to "Cash and cash equivalents" accounts are calculated based on the selected period. If a posting meets the following criteria, it appears in this calculation diagram:

  • One of the posted accounts must be assigned to the “Cash and cash equivalents” account group.
  • Bank to bank entries, are not shown because these entries cancel each other out. This means that if both accounts used are assigned to "Cash", they will not be included in this chart. However, in this case it is important that all the accounts of the "Cash" are registered in the banking.

Now we will show you an example:

Dashboard

As you can see from the slide, we have income at CHF 250.00. Expenses are at CHF 8550.00.

Balance sheet with carry forward to 01.01.2022

If we look at the current assets, we have an enormous listing of all liquid assets accounts. This seems a bit confusing at first if you want to see the key figures of the dashboard.

Balance sheet without carry forward to 01.01.2022

Therefore, we simply take away the carry forward to 01.01.2022. If we now look at the balance sheet or only the liquid assets account, we also have an amount of CHF -8330.00.

Transactions

When analysing the account 1020 in detail, we have CHF 250 on the debit side and CHF 8550 on the credit side. This is what the dashboard also reflects.

Important: If postings that meet the above criteria do not appear, please check whether the accounts used are also assigned to the "Cash and cash equivalents" account group. You can find the chart of accounts under “Settings” → “All settings” → “Accounting” → “Financial accounting chart of accounts”.


Top expenses (costs)

The 7 most frequently used “Expense accounts” are shown under “Top expenses”. The distribution is shown as a percentage. This is calculated based on the use of the expense accounts for all postings. The period can be determined by using the date range. If an account used for financial accounting belonging to the "Expense account" account type is used as follows, it will have the following effect in this diagram:

  • For a manual posting.
  • For a manual bank posting.
  • For an expenditure.
  • For a supplier invoice.

Bildschirmfoto_2020-08-12_um_09.59.28.png


Revenue

The “Revenue” category displays the expected monthly revenue value that is calculated based on the entered invoices with the “Open”, “Partial”, and “Paid” statuses and that are calculated for the selected period. This calculation is displayed on the basis of the data found under “Sales” → “Invoices”. The value in this calculation is the gross invoice amount (including VAT). The month for which the revenue is shown is dependent on which invoice date is set.

Bildschirmfoto_2020-08-12_um_09.59.54.png


Invoice overview tab

Under "Sales" → "Invoices" you can go to "Overview" to get an extended dashboard of the invoice overview. To obtain a detailed analysis of your sales data, read the following post: “Sales analysis”.

Bildschirmfoto_2020-08-05_um_13.59.09.png


Top customers

Total revenue of the top customers by invoices (top 4 customers + various).

  • Where does the data come from?: "Sales" - "Invoices".
  • What is taken into account?: All invoices with the “Open”, “Partial”, and “Paid” statuses.

Period: All invoices for the corresponding contacts that have ever been created in bexio and that satisfy the above criteria.

Bildschirmfoto_2021-03-01_um_09.48.45.png


Total by status

The total amounts of the invoices by status ("Draft", "Open", "Partial", and "Overdue").

  • Where does the data come from?: "Sales" - "Invoices" - values by status minus incoming payments
  • What is taken into account?: The effective values of all invoices excluding the payments (e.g., an open invoice for CHF 2,000 minus incoming payment (CHF 285.10) results in a total open amount of CHF 1,714.90.

Period: All invoices for each status (excluding “Paid”) that have ever been created in bexio and that satisfy the above criteria.

 

 

Was this article helpful?
4 out of 6 found this helpful
Have more questions? Submit a request