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

How To Create A Jet Express Financial Report


Easy

How-To Video

 
Creating a Jet Express Fast Financials report

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

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 Express 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 Express 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
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments