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 postings will not be shown. If both accounts used are "Cash or cash equivalent" accounts, these are not counted in this diagram.

Bildschirmfoto_2020-05-07_um_16.13.26.png

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 4 found this helpful
Have more questions? Submit a request