Follow

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?"

Übersicht

 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".

Bildschirmfoto_2020-05-06_um_10.17.35.png

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

 

What will the respective finance charts show me?

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.

 

Receipts and withdrawals of cash and cash equivalents

Bildschirmfoto_2020-05-07_um_16.13.26.png

The displayed figures are taken from the Financial Accounting ("Accounting" -> "Reports" -> "Journal") of your bexio account.

Revenue/expenditures criteria

  • 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.

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".

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.

 

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.

 

Tab "Overview" for invoices

Bildschirmfoto_2020-08-05_um_13.59.09.png

 

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