Financial Reports

Financial Reports allows users to create, maintain, view, and print Reports that they have designed.

To view Financial Reports, navigate to the images/financialreports/generalledger-1.jpg tab and click on the images/financialreports/financialreportsicon-2.jpg icon. This will open the Financial Reports Lookup screen.

../_images/financialreportslookupscreen-3.jpg

Now, users will be able to view all of the Financial Reports available in the system.

Users can either double-click on the appropriate Financial Report to view it.

../_images/financialreportsviewandemail-4.jpg

They can also edit the Report by clicking on the images/financialreports/editbutton-5.jpg button.

../_images/editscreen-6.jpg

Creating a New Financial Report

There are three different ways to add a new Financial Reports to the system. The first way is to press the Ctrl + Shift + U keys. The second way is to navigate to File > New > Financial Report.

../_images/filenewfinancialreports-7.jpg

The last way is to click on the images/financialreports/newbutton-8.jpg button, and then on the Financial Report option.

../_images/newfinancialreport-9.jpg

All of these options will open a new Financial Report screen.

../_images/newfinancialreportscreen-10.jpg

Fill in the fields such as Report Name, Title, Description, and Company.

Adding a Group to a Financial Report

To add a group to a Financial Report, make sure that the images/financialreports/accountstab-11.jpg tab is selected.

There you will find the list of your Chart of Accounts under Assets, Liabilities, Equity, Income, and Expenses. These are known as Chart of Account Types.

../_images/listofgroups-12.jpg

Click on the images/financialreports/addgroupbutton-13.jpg button to add a group to the Report Layout section. If you are adding a group to an existing group, make sure the existing group is highlighted in the Report Layout section. Then click on the images/financialreports/addgroupbutton-13.jpg button.

Note

You can only add one group at a time.

Group Properties

Once you have clicked on the images/financialreports/addgroupbutton-13.jpg button, the Group Properties window will appear.

../_images/grouppropertieswindow-14.jpg

Fill in the Group Header information such as selecting the group to Show in Header, the Header Text, and the Padding Before and After.

../_images/groupheader-15.jpg

Note

Padding Before and After refers to the spacing before the Header Text and the spacing after the Header Text.

Fill in the Group Footer information such as selecting the group to Show in Footer, the Footer Text, and the Padding Before and After.

../_images/groupfooter-16.jpg

Note

Padding Before and After refers to the spacing before the Footer Text and the spacing after the Footer Text.

Fill in the Appearance information such as the Indent Level, Underline, and selecting a Custom Font if necessary.

../_images/appearanceinformation-17.jpg

Note

The Indent Level refers to the number of indents you would like the group to be when viewing it on the Financial Report.

Next, you have the option to select or de-select Show Total, Show Accounts, and This group is a sub-group of.

../_images/selectingdeselecting-18.jpg

Once the relevant information has been filled out, click on the images/financialreports/okbutton-19.jpg button to add the group to the Financial Report layout.

../_images/groupaddcomplete-20.jpg

Note

To remove a group, simply highlight the appropriate row according to the group you would like to remove and click on the images/financialreports/removegroupbutton-21.jpg button. The group will be removed.

Adding a Sub-Group

To add a sub-group to a group, make sure to highlight the head group on the Financial Report layout. Then, highlight the sub-group that you wish to add to the Financial Report layout under the images/financialreports/accountstab-11.jpg tab. Click on the images/financialreports/addgroupbutton-13.jpg button. The Group Properties window will appear again.

../_images/grouppropertieswindow-14.jpg

In the Group Properties window, the sub-group that you have selected will automatically default to the group that you highlighted on the Financial Report layout.

../_images/defaultsubgroup-22.jpg

Click on the images/financialreports/okbutton-19.jpg button when you have finished filling in the necessary fields within the Group Properties window.

Note

For more guidance on navigating the Group Properties window, please see the above section on Group Properties.

Note

To remove a sub-group, simply highlight the appropriate row according to the sub-group you wish to delete and click on the images/financialreports/removegroupbutton-21.jpg button. The group will be removed.

Re-organizing Groups

Once all of the appropriate groups have been added to the Financial Report layout, users are then able to re-organize the order in which the groups go in (if necessary).

To do so, make sure to highlight the appropriate group and then click on the images/financialreports/uparrow-24.jpg button or the images/financialreports/downarrow-25.jpg button to move the group to where you would like it to be.

Adding a G/L Account to a Group

To add a G/L Account to a group, make sure that the images/financialreports/accountstab-11.jpg tab. Click on the plus sign located beside the appropriate Account Type that you would like to add a G/L Account from. This will expand the group so users are able to view all of the G/L Accounts within that particular Account Type.

../_images/groupexpanded-26.jpg

Make sure to highlight the appropriate row of the group that you would like to add the G/L Account(s) to in the Financial Report layout.

Now, select the G/L Account you wish to add.

Note

If you would like to add more than one G/L Account, hold the Ctrl key as you make your selection.

Once you have selected the appropriate G/L Accounts, click on the images/financialreports/rightarrow-27.jpg button and the G/L Account(s) will now be shown on the Financial Report layout under the group that you highlighted.

../_images/glaccountsadded-28.jpg

Note

If users have selected the wrong G/L Account, they can click on the images/financialreports/leftarrow-29.jpg button to list it back under the images/financialreports/accountstab-11.jpg tab.

Re-organizing G/L Accounts in a Group

Once all of the appropriate G/L Accounts have been added to the Financial Report layout, users are then able to re-organize the order in which the G/L Accounts go in (if necessary).

To do so, make sure to highlight the appropriate G/L Account and then click on the images/financialreports/uparrow-24.jpg button or the images/financialreports/downarrow-25.jpg button to move it to where you would like it to be.

Note

If you would like to re-organize multiple G/L Accounts, simply hold the Ctrl key while selecting the ones you wish to move.

Make sure to save all of your changes before exiting the screen.

Selecting which Fields to Show on a Financial Report

Users also have the ability to select which Fields to display on the Financial Report layout. The Fields that are available to choose from are:

  • Current Month: the account total for the current month
  • Current Month %: the account total as a percentage of income for the current month
  • Current Month Budget: the budget amount for the account for the current month
  • Current Month Budget %: the budget amount for the month divided by the period income
  • YTD Actual: the year to date actual amount for the account
  • YTD Actual %: the year to date actual amount as a percentage of the year to date income for the account
  • YTD Budget: the year to date budget amount for the account
  • YTD Budget %: the year to date budget amount divided by the year to date income amount
  • Current Month Budget Variance: the difference of the current month amount minus the current month budget amount
  • YTD Budget Variance: the year to date current amount minus the year to date budget amount

Note

The income amount used for the percentage calculations is a total of the G/L Accounts with an Income type.

To select which Fields to include or not include, make sure that the images/financialreports/fieldstab-30.jpg tab is selected.

Users will be able to view the above listed Fields. To the left of each Field, there is a box which can be checked or unchecked depending on whether or not users would like them shown in the Financial Report layout.

Users also have the ability to change the Width of each Field as well as the Group Width and Row Height.

../_images/selectingfields-31.jpg

Once the appropriate Fields have been selected, make sure to save your changes before exiting the screen.

Now that the Financial Report layout settings have been saved, users can click on the images/financialreports/previewtab-32.jpg tab to view it.

Modifying a Financial Report

To modify a new or existing Financial Report, navigate to the images/financialreports/generalledger-1.jpg tab and click on the images/financialreports/financialreportsicon-2.jpg icon. Locate the Financial Report you wish to edit and click on the images/financialreports/editbutton-5.jpg button.

This will open the Financial Report detail screen.

../_images/financialreportdetailscreen-33.jpg

Users can modify all relevant information by following the steps above for Creating a New Financial Report.

Once all necessary changes have been made, make sure to save before exiting the screen.

Printing a Financial Report

To print a Financial Report, navigate to the images/financialreports/generalledger-1.jpg tab and click on the images/financialreports/financialreportsicon-2.jpg icon. Select the Financial Report you wish to print by double-clicking on the appropriate row. This will open the Financial Report View screen.

../_images/financialreportsviewscreen-35.jpg

Select the Financial Report and the Fiscal Period and then click on the images/financialreports/viewbutton-36.jpg button to view the Report. The system will populate the Financial Report.

../_images/financialreportsview-37.jpg ../_images/reportpopulated-38.jpg

The menu bar located above the Financial Report allows users to refresh, print, print layout, page setup or export. Select the Print button in order to print the Financial Report.

../_images/previewmenu-39.jpg

The Print window will appear. Make sure to select the appropriate printer and printer setting and then click on the images/financialreports/printbutton-40.jpg button.

../_images/printwindow-41.jpg

Your Financial Report will be printed.

Emailing a Financial Report

To email a Financial Report, navigate to the images/financialreports/generalledger-1.jpg tab and click on the images/financialreports/financialreportsicon-2.jpg icon. Select the Financial Report you wish to Email by double-clicking on the appropriate row. This will open the Financial Report View screen.

../_images/financialreportsviewscreen-35.jpg

Select the Financial Report and the Fiscal Period and then click on the images/financialreports/viewbutton-36.jpg button to view the Report. The system will populate the Financial Report.

../_images/financialreportsview-37.jpg ../_images/reportpopulated-38.jpg

You will notice that the images/financialreports/emailbutton-42.jpg button will now be available to click on.

Click on the images/financialreports/emailbutton-42.jpg button and a new Email message window will appear with the Financial Report as an attachment.

Complete your Email and send.