Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Jet Reports Fast Financials for NAV and Business Central data sources

Easy

How-To Video

Creating a Fast Financials report for Dynamics NAV

This video provides a quick overview of how to create your own financial report using the Fast Financials feature in the Jet Excel add-in.

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:

VarianceRpt.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 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 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. Now it's just a matter of clicking the Report button to run the report...

    NewFinReport15.png

  14. ... adjusting the Report Options...

    NewFinReport16.png

  15. ... and now we have a completed variance report based on our data:

    VarianceRpt.png

Published:

Jet Reports Fast Financials for NAV and Business Central data sources

Easy

How-To Video

Creating a Fast Financials report for Dynamics NAV

This video provides a quick overview of how to create your own financial report using the Fast Financials feature in the Jet Excel add-in.

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:

VarianceRpt.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 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 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. Now it's just a matter of clicking the Report button to run the report...

    NewFinReport15.png

  14. ... adjusting the Report Options...

    NewFinReport16.png

  15. ... and now we have a completed variance report based on our data:

    VarianceRpt.png

For an optimal Community experience, Please view on Desktop