Follow

What information is contained in the finance charts?

General information on finance charts

  • All key figures are displayed in the standard currency that is used by your accounting and with gross prices (including VAT).
  • All postings in a foreign currency (invoices, supplier invoices, etc.) are converted before being displayed in the finance charts using the stored exchange rate "Foreign currencies - How does bexio do that?"

Where can I find the finance charts?

The finance charts can be found on the Dashboard (Home icon) and under the invoices at "Sales" - "Invoices" - "Overview".

For more information about the Dashboard, see the "Dashboard - Finance cockpit & personal start page" article.

What will the respective finance charts show me?

Dashboard

Receivables (debtors)

What are debtors?

Total value of all unpaid invoices/debtors ("Sales" - "Invoice"). 
The total or balance amounts of the invoices with an "Open", "Partially Paid" or "Overdue" status are taken into account.

  • Open: All unpaid invoices that have not exceeded the allowed payment period
  • Overdue: All unpaid invoices that have already exceeded the allowed payment period

Period: All invoices ever created in bexio that meet the above criteria.

Liabilities (creditors)

What are creditors?

Total value of all unpaid supplier invoices/creditors ("Purchasing" - "Supplier Invoices"). 
The total or balance amounts of the supplier invoices with an "Open", "Partially Paid" or "Overdue" status are taken into account.

  • Open: All unpaid supplier invoices that have not exceeded the allowed payment period
  • Overdue: All unpaid supplier invoices that have already exceeded the allowed payment period

Period: All supplier invoices that were ever created in bexio and that meet the above criteria.

Revenue and expenditures

In bexio we present revenue and expenditures in two places:

  • In the reports ("Accounting" -> "Reports" -> "Revenue" or "Expenditures")
  • On the Dashboard ("Home icon" in the main navigation to the left of "Contacts")

The displayed figures are taken from the Financial Accounting ("Accounting" -> "Reports" -> "Journal") of your bexio account. There are various criteria determining what is displayed, depending on the location, that may lead to differences between what is displayed in the reports and the Dashboard.

Revenue/expenditures criteria

Reports

  • Posting on the debit side (revenue) and credit side (expenditure) for accounts in the "Cash" group.

Dashboard

  • Posting on the debit side (revenue) and credit side (expenditure) for accounts in the "Cash" group.
  • No bank for bank posting.
  • At least one account in a posting should come from the "Banking" section.

As you can see, the Dashboard has more criteria than the reports that are factored in the calculation. For this reason, the reports sometimes indicate a higher number than the Dashboard.

If, therefore, there are no postings that fulfill the above criteria, please check that the used accounts are also assigned to the "Cash" account group.

The chart of accounts can be found under "Settings" -> "All Settings" -> "Accounting" -> "Chart of Accounts – Financial Accounting".

The reports also show account transfers as revenue or expenditures. Of course, this is not optimal, because in principle only income-earning postings should be taken into account in the revenue and expenditures.

The product management is aware of this issue, and we are examining how we can present this better in the future.

Period: Can be defined by yourself.

Top expenses (expenditures)

Here you can see the top expenditures per financial account (Top 7 + Miscellaneous) expressed as a percent.

Where does the data come from?:

  • "Purchasing" - "Supplier Invoices" - "FA Accounts" for the individual items: All supplier invoices in the status "Open", "Partially Paid" or "Paid"
  • "Purchasing" - "Expenditures" - "FA Accounts" for the respective expense. All expenses

Period: Can be defined by yourself.

Tab "Overview" for invoices

Revenue

Total revenue per month from the current fiscal year/calendar year of the invoices ("Sales" - "Invoices")

What is revenue?: The total of all issued invoices in Open, Partially Paid or Paid status. The invoice date is decisive, and the figures are calculated including VAT.

Period: Can be defined by yourself.

Top customers

Total revenue of the top customers who received invoices (Top 4 customers + Miscellaneous).

  • Where does the data come from?: "Sales" - "Invoices".
  • What is taken into account?: All invoices in "Open", "Partially Paid" or "Paid" status.

Period: All invoices for the corresponding contacts that were ever created in bexio that meet the above criteria.

Total per status

The total amounts by status ("Draft", "Open", "Partially Paid", and "Past Due").

  • Where does the data come from?: "Sales" - "Invoices" - Values by status less incoming payments
  • What is taken into account?: The effective values of all invoices that have not been paid. (e.g., if there are open invoices of more than CHF 2,000, then the total open amount less incoming payments (CHF 285.10) would be CHF 1,714.90).

Period: All invoices per status (except "Paid") that have ever been created in bexio and meet the above criteria.

 

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