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
9
