How To: Set Up Financial Settings on Power BI Reports
Each BI Report in TapGoods PRO allows you to specify Financial Settings that will impact how data is pulled. The Financial Settings on BI Reports allow you to specify when Revenue will be recognized and pulled for the Report. It is important to note that BI Reports will only display Revenue that is Recognized, so it is important to be accurate when you set up the Financial Settings.
BI Reports are on the Custom Export page, which is found under Admin on the TapGoods PRO menu.
On the Custom Export page, click on the dropdown menu and select a Power BI Report.
The Financial Settings on a BI Report are set up using the Recognize Revenue By field that is located at the top right-hand side of the report. In this field, you can specify whether revenue will be recognized by one of the following options:
- Order Start Date: Revenue is recognized after the Order Start Date.
- Order End Date: Revenue is recognized after the Order End Date.
- Order Close Date: Revenue is recognized after the Order Close Date.
- First Payment Date: Revenue is recognized after the first Payment is made on an Order.
To set up the Financial Settings for a BI Report, simply select one of the options listed above in the Recognize Revenue By field.
It is important to keep your selection in mind when you are ready to generate a Power BI Report. If you do not select the correct Financial Setting, the report will not generate accurate information.
Suppose you want to create a BI Report that displays the Revenue earned on all orders for which a payment has been made. If you have selected the "Order Start Date" option, the report will only show the revenue from Orders for which the start date has already passed. This means you might miss important data if you have selected the wrong Financial Setting. Therefore, it is essential to choose the appropriate financial setting every time you generate a BI Report.