In the webinar demo, the P&L example used a simple =IP.GLBASEAMOUNT formula on its own, without any posting attributes (Cost Centre, Department, etc.) added — giving one unitary figure per account.
The question raised was: how do I adapt this if I want to break the P&L down by individual departments and by fund type (i.e. restricted / unrestricted charity funds)?
Please see the answer in the section below. If you require any further assistance, you can either add a comment or log a support ticket here.
0 Votes
Gabrielle Day posted
about 2 months ago
AdminBest Answer
Yes, this is possible. The Excel Add-in includes a range of formulas that allow you to retrieve and report on different attribute values from iplicit, such as departments, funds, projects and other analysis dimensions.
Note that fund type works a little differently to department: Department is added as a posting attribute on the general balance formulas (e.g. IP.GLBASEAMOUNT), whereas fund type reporting uses its own dedicated formula, IP.GLFTBASEAMOUNT, which still accepts Department (or other posting attributes) alongside it. So for a report broken down by both, IP.GLFTBASEAMOUNT is the one to use rather than adding Fund as a posting attribute on IP.GLBASEAMOUNT.
To see the full list of available formulas, their syntax, and examples of how they can be used, please refer to the Excel Add-in documentation here:
Using these formulas, you can build reports for individual departments, funds, or any other attributes captured within your iplicit environment.
0 Votes
1 Comments
Gabrielle Dayposted
about 2 months ago
AdminAnswer
Yes, this is possible. The Excel Add-in includes a range of formulas that allow you to retrieve and report on different attribute values from iplicit, such as departments, funds, projects and other analysis dimensions.
Note that fund type works a little differently to department: Department is added as a posting attribute on the general balance formulas (e.g. IP.GLBASEAMOUNT), whereas fund type reporting uses its own dedicated formula, IP.GLFTBASEAMOUNT, which still accepts Department (or other posting attributes) alongside it. So for a report broken down by both, IP.GLFTBASEAMOUNT is the one to use rather than adding Fund as a posting attribute on IP.GLBASEAMOUNT.
To see the full list of available formulas, their syntax, and examples of how they can be used, please refer to the Excel Add-in documentation here:
This query was raised during a recent webinar:
In the webinar demo, the P&L example used a simple
=IP.GLBASEAMOUNTformula on its own, without any posting attributes (Cost Centre, Department, etc.) added — giving one unitary figure per account.The question raised was: how do I adapt this if I want to break the P&L down by individual departments and by fund type (i.e. restricted / unrestricted charity funds)?
Please see the answer in the section below. If you require any further assistance, you can either add a comment or log a support ticket here.
0 Votes
Gabrielle Day posted about 2 months ago Admin Best Answer
Yes, this is possible. The Excel Add-in includes a range of formulas that allow you to retrieve and report on different attribute values from iplicit, such as departments, funds, projects and other analysis dimensions.
Note that fund type works a little differently to department: Department is added as a posting attribute on the general balance formulas (e.g.
IP.GLBASEAMOUNT), whereas fund type reporting uses its own dedicated formula,IP.GLFTBASEAMOUNT, which still accepts Department (or other posting attributes) alongside it. So for a report broken down by both,IP.GLFTBASEAMOUNTis the one to use rather than adding Fund as a posting attribute onIP.GLBASEAMOUNT.To see the full list of available formulas, their syntax, and examples of how they can be used, please refer to the Excel Add-in documentation here:
https://docs.iplicit.com/guide/downloads/excel_addin/index.html
Using these formulas, you can build reports for individual departments, funds, or any other attributes captured within your iplicit environment.
0 Votes
1 Comments
Gabrielle Day posted about 2 months ago Admin Answer
Yes, this is possible. The Excel Add-in includes a range of formulas that allow you to retrieve and report on different attribute values from iplicit, such as departments, funds, projects and other analysis dimensions.
Note that fund type works a little differently to department: Department is added as a posting attribute on the general balance formulas (e.g.
IP.GLBASEAMOUNT), whereas fund type reporting uses its own dedicated formula,IP.GLFTBASEAMOUNT, which still accepts Department (or other posting attributes) alongside it. So for a report broken down by both,IP.GLFTBASEAMOUNTis the one to use rather than adding Fund as a posting attribute onIP.GLBASEAMOUNT.To see the full list of available formulas, their syntax, and examples of how they can be used, please refer to the Excel Add-in documentation here:
https://docs.iplicit.com/guide/downloads/excel_addin/index.html
Using these formulas, you can build reports for individual departments, funds, or any other attributes captured within your iplicit environment.
0 Votes
Login to post a comment