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. 

 

Screen_Shot_2023-04-27_at_5.07.29_pm.png

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.

 

Screen_Shot_2023-04-27_at_5.07.43_pm.png

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

Screen_Shot_2023-04-27_at_5.08.02_pm.png

 

Quarterly Profit and Loss

Compares quarterly Actuals with Budget and Variance

 

Screenshot

Monthly Profit and Loss

Monthly Actuals 

Screenshot

 

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.

Screen_Shot_2023-04-27_at_5.08.49_pm.png

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

Screen_Shot_2023-04-27_at_5.09.05_pm.png

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.

 

Screen_Shot_2023-04-27_at_5.09.23_pm.png

Income Vs Expense

Screen_Shot_2023-04-27_at_5.09.41_pm.png

Income Bar Chart

Screen_Shot_2023-04-27_at_5.12.03_pm.png

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

 

Screen_Shot_2023-04-27_at_5.12.17_pm.png

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

 

Screen_Shot_2023-04-27_at_5.12.32_pm.png

9

 

 

 

 

 

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?