Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

How to create a Jet Reports Financials Report


Easy

How-To Video

 
Creating a Jet Reports Financials sample report

This video provides a quick overview of how to create your own financial report using the Jet Reports Financials extension to Dynamics 365 for Finance and Operations.

Goal

Here we have an Operating Expense Variance Report showing - for a specific period of time - the actual balance of each of our GL Operating Expense accounts, the budget associated with each account, and the variance between the two:

NewFinReport1.png

Let's build this...

 

Step-by-Step

  1. To start, let's select the Fast Financials tool.

    NewFinReport2.png
  2. This displays our entire chart of accounts along with the balance for each account.

    NewFinReport3.png
  3. We'll want Budget and Variance information, as well as balance, so let's adjust the Columns to include those, as well...

    NewFinReport4.png
  4. We're also going to want to Include column headers to make our report more readable.

    NewFinReport5.png
  5. Now, let's go select our Operating Expense accounts. We'll scroll down to where that category starts, select the beginning account...

    NewFinReport6.png
  6. ... and then scroll down and - while pressing the SHIFT button on the keyboard - select the totaling account.

    NewFinReport7.png
  7. Next, we'll drag the selected accounts over to the worksheet...

    NewFinReport8.png

     and Jet Reports Financials performs the formatting of the data.

  8. We can close the Fast Financials window... and we see that we have all the selected accounts along with the amounts, budget, and variance:

    NewFinReport9.png
  9. Going to the Options sheet, we see that Jet Reports Financials has automatically created the report options that we will need to run our report.

    When we do run the report, we'll be prompted to enter the information we want:

    NewFinReport10.png
  10. The Options have been named for us so that it will make it easier to design our report.

    NewFinReport11.png
  11. Let's add some extra information to our report so that it's just the way we need it.

    We'll give the worksheet a more descriptive name...

    NewFinReport12.png
  12. ... add a title - which we'll format to the size and style we want...

    NewFinReport13.png
  13. ... and we'll want to see the date range we're reporting on... and we can access that information directly from the Options sheet. We'll bring over both the start date and the end date:

    NewFinReport14.png
  14. Now it's just a matter of clicking the Report button to run the report...

    NewFinReport15.png
  15. ... adjusting the Report Options...

    NewFinReport16.png
  16. ... and now we have a completed variance report based on our data:

    mceclip0.png

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments