Account Profit & Loss with Trends

The Account Profit & Loss with Trends Workbook provides an overview of Company Performance for activity to Year to Last Month. 

The workbook analyses Profit and Loss  across the following several tabs.

Overview - Year to Year

The Overview  tab graphically presents Income v Profit This Year v Last and below this, Expense and COGS for the full year. To the right  KPI of YTD Income , Expenses and Profit  The report utilises colour coded trend indicators and values present on a bar charted background to highlight their contribution. 



Overview - Year to Budget

If you have budgets in the connected accounting system then this visualisation will show Actual vs Budgets and has similar KPI to the above tab.



Year to Date Profit and Loss

This is  traditinal profit and Loss or Income Statement. The example shows % and trend icons are available for Actual / Budget, Variance to Budget  and Actual Last Yr % variance



Quarterly Profit and Loss

Compares quarterly Actuals with Budget and Variance



Monthly Profit and Loss

Monthly Actuals 



Transactions By Month Profit and Loss

The example shows the flexibility of Bi4Cloud in that the rows can even nearly any dimension even calendar months.


Expense Sources

This radar chart shows Top 20 Expense Sources - This Year vs Last Year and the quantum if the expense particularly clear. The top 20 is chosen so minor expenses don't clutter the chart


Income Sources

This radar chart shows Top 20 Income Sources - This Year vs Last Year.

The top 20 is chosen so minor expenses don't clutter the chart

When Inventory system are used there will often be few Income Account because the analysis detail is in the Inventory Sub Ledger. For non-inventory systems the income detail is often coded to the GL accounts making this visualisation quite useful.



Income Vs Expense


Income Bar Chart


Profit and Loss by GL Tag

This shows a Profit and Loss by GL Tag.  GL Tags in Bi4cloud Accounts allow you to categorise account into groups or costs centres. An example in a restaurants, GL Account for beverage income and expense can be assigned a GL Tag Beverage  and  Accounts for food iassigned Food. After that when this report is run then it will show these tags a Income and Expense by this cost centre.

Learn about GL Tags



Profit and Loss by Flexi Level

Flexi Levels are Account Groups which allow the order and summary level of a Chart of Accounts (COA) to be re-organised.  When these Flexi Levels are created then Profit and Loss reports can be produced with Summary and Sorting different to the underlying COA.

Learn about Flexi-Levels









Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Ask the BI4 Community
Need help using this report or feature?