GetbeelDocs
Analytics

Spending analytics

The Analytics page: spending, earnings, vendors and profit and loss by period, calculated from the bank transactions in Reconciliation.

Analytics shows the trend of the transactions in Reconciliation: how much went out, how much came in and whom you paid. The numbers come from bank transactions, not from invoices.

Before you start

  • Bank transactions in Getbeel: upload a statement or connect your bank. Without transactions the page is empty.
  • The Owner or Member role. The Accountant does not see Analytics.
  • No need for the transactions to be matched to invoices yet.
  • Cost: the page is free (Pricing).

Steps

Open Analytics

Open Analytics in the sidebar. It opens on This month.

Choose the period

Choose This month, Last month, This quarter, This year or All time. For other dates, pick a range in the calendar.

Read the totals

At the top you find Total spent, Total earnings, Total transactions and Unique vendors. Spent and earnings show the percentage change against the previous period.

Look at spending and profit and loss

Monthly spending splits each month's payments out by vendor. Profit and loss compares Revenue and Expenses, with Net profit / loss. Open an expense line to see the vendors.

Compare vendors

All vendors lists whom you paid, with Total spent, Avg transaction, Count and Last transaction.

What just happened

  • You opened the page on the current month's transactions.
  • The chosen period applies to all totals, charts and the list.
  • The totals show whether you spend or earn more than in the previous period.
  • Profit and loss shows the balance between money in and money out of the account.
  • The vendor list shows where the spending goes.

How Getbeel counts

  • Money out: every transaction with a negative amount. Money in: every positive transaction.
  • Revenue is grouped by counterparty. Expenses by the bank's transaction type, not by invoice category.
  • Previous period: the month before, the quarter before or the year before. All time and hand-picked dates have no comparison.
  • Currency: amounts are added up as they are, without conversion.

Not the profit and loss from your invoices

These numbers are cash movements, VAT included. For the accrual profit and loss, from invoices and net of VAT, use the management reports.

If it fails

MessageCauseFix
"Upload a bank statement to generate your profit and loss statement"There are no bank transactionsUpload a statement or connect your bank
"No data available"No transactions in the chosen periodChoose All time or another range
"No revenue recorded"No money came in during the periodCheck that the statement also contains money coming in
A month is missingThat month's statement was not uploadedUpload the missing statement in Reconciliation

Next steps

On this page