Let’s have a look at the difference between the Cash flow and Profit (P&L) reports in the Analytics section.
Let’s start with the “Cash flow” report. “Cash flow” report grouped by statements on all your accounts, cards and cash registers.
- In this report, we can use a time filter and select the desired period for which we want to see information (for example, last month).
2. In the top box of the report, we see a graph that shows us the amounts of income, debts and balance (net cash flow, the difference between income and debts)
3. We will see the next block below, showing the structure of receipts and debits, for example, payments from customers, receipt of credit, etc.
On the right, we can see how we spend our money – salary payments, loan repayments, payments for electricity, etc. If you move the mouse over the sectors, you can see the specific amounts.
Also, by clicking on a category, you can see similar information about the subcategories in the payments.
4. Below are the blocks in which category, period, and amount displays income and expense.
5. At the bottom, you can see a list of all the payments that formed this report.
You can change the parameters of the schedules. There are filters at the top of the report: a filter by date, which displays the report by categories, projects, and counterparties.
Also, other types of criteria are to filter by clicking the “Filter” button.
7. You can view the report in both ways: graphically and in tabular form. There is a special switch button on the top panel of the report for this purpose.
We see that in the filtering section, you can include and exclude future payments in the report. You can use this functionality as a plan-fact and analyse how much money is already available and how much you can expect in the future.
Clicking on any data cell below will open a list of incoming payments.
Next step -we will talk about the next and probably the most important report, which is the Profit or P&L, or simply the Income statement.
- The Profit report only shows accrued income and expenses, i.e. data by the date of the agreement. For example, consider the Salary category. We accrue a payment to an employee for the previous month, but make the payment in the current month.
In the Cash report, we will see the amount written off in the current month (exactly when we gave these funds to the employee)
And in the “Profit” report you can see this expense in the last month because we paid the salary for the previous month.
2. The Profit report has the same filters and settings as the Cash report, as well as the ability to view information in both ways: graphically and in tabular form. So, not to be repetitive, let’s show how to filter “Salary” information in this report. Let’s set the display of information by the counterparty.
In the advanced filters, select the desired category – “Salary”.
We receive information on actual and planned expenses for salaries and wages.
3. Next step – let’s see how we can create our custom filter.
You need to specify the information you wish in the advanced filters, then click “Save Filter” and define its name.
Now, when you need to view exactly the information you specified in the filter, select it from the list. Well done!
Set up reports, analyse and make management decisions based on the numbers!