Working with Financial Reporting

Use this window to generate, update, create, and delete financial reports including GASB and FASB standard reports, such as Statement of Net Assets; Statement of Revenues Expenses, and Changes in Net Assets; Statement of Financial Position; Statement of Activities; Statement of Cash Flows, and customized versions of these reports.

Generating Reports

Use the Run Reports tab to generate an existing report. You can specify the report parameters, such as fiscal year and month and/or month-to-date or year-to-date, review the report template in the Excel template pane, and send it to Excel for review, customizing, and distribution.

Creating, Updating, and Deleting Reports

· Access the Review/Add Report Line Items tab where you can correlate report line items to specific template report cells while updating a report template

Associating Line Items

Use the Review/Add Report Line Items tab to correlate report line items to specific Excel template cells. This tab allows you to:

· Select a different line item to be associated with an existing Excel template cell

· Access the Manage Report Line Items window where you can create, update, and delete report line items to be available for the financial report

Utilizing Excel

You can access Excel capabilities by utilizing the Excel template pane in J1 Excel mode or opening the report template in Excel. Excel capabilities allow you to:

How To

1. Open the Financial Reporting window.

2. On the Run Report tab, select a specific report type or All to select from all available reports.

3. Select the report you wish to run from the Report Name drop-down list.

4. Click Show Report Template. The Report Parameters group box and the Excel template pane appear on the window.

5. Make any needed changes to the reporting criteria in the Report Parameters group box, such as report title, fiscal year, and fiscal month, and choose to run the report on month-to-date or year-to-date data.

Some report templates list multiple variable posted balances, while others may not list any. Modify the report parameters for each as needed.

6. Click Run Report in Excel to generate the report. The report opens in Excel.

Any changes made in Excel will not be reflected in J1.

1. Open the Financial Reporting window.

2. On the Manage Report tab, select the Create Report option.

3. To use an existing report template to create your report, select the Base new report on existing report checkbox and select the report upon which you are basing your new report from the Existing Report Name drop-down list. You can filter the reports in this drop-down list by choosing a report type from the Filter by Report Type drop-down list.

4. Select your new report's type.

5. Enter a name for your new report.

If your report is closely based on an existing report, you may want to copy and paste the existing report's name and add an identifying appendage to it.

6. If you do not need to modify the template, click Create Template and Remain in J1 Mode. Your new report template is created.

7. If you want to modify or review the template, click Create Template and Edit in Excel Mode. Your new report template is created and you can proceed to review or modify your new report template. Once the report template is updated, click Return to J1 Mode.

Jenzabar provided reports cannot be modified.

1. Open the Financial Reporting window.

2. On the Manage Report tab, select the Modify Report option.

3. Select the report you wish to modify from the Report Name drop-down list. You can filter the reports in this drop-down list by choosing a report type from the Filter by Report Type drop-down list.

4. Open and modify the report.

· To modify the report in the Excel template pane:

a. Click Edit in Excel Mode. The Excel tool bars are displayed in J1 Desktop and the Excel template pane is active.

b. Make your changes in the Excel template pane.

c. When you are finished making changes, click Return to J1 Mode. A Do you want to save changes? message displays.

d. Click Yes to save changes or No to abandon them.

· To open the report in Excel and modify it there:

a. Click Open Report in Excel. Excel opens the report workbook displaying the template as the active tab.

b. Make your changes in Excel.

c. When you are finished making changes, return to the Financial Reporting window.

d. To save your changes, click Yes to the message, Do you want to save your modified Excel Report? The Excel report closes automatically, if it has not already been closed, and your changes are saved in J1 Desktop.

Jenzabar provided reports cannot be deleted.

1. Open the Financial Reporting window.

2. On the Manage Report tab, select the Delete Report option.

3. Select the report from the Report Name drop-down list. You can filter the reports in this drop-down list by choosing a report type from the Filter by Report Type drop-down list.

4. Click the Delete Report button and Yes to the message, Are you sure you want to delete?

1. Open the Financial Reporting window.

2. On the Manage Report tab, select the report you want to work with.

3. Click the Review/Add Report Line Items tab.

4. Click Edit in Excel Mode to modify the report template in the Excel template pane.

5. In the report template, insert rows where you want to add line items.

To add a description to your new report line item, double-click in the description cell and type a description of the report line item.

6. Double-click the cell where the report line item will be inserted.

7. Click Return to J1 Mode to begin adding your report line item in J1 Desktop.

8. Click Yes to the message asking if you want to save your changes. This saves the value of your cursor's last cell position in the Specify Excel Cell Location column, which is where your report line item will be inserted.

9. Verify that the Specify Excel Cell Location cell is where you want to add the new report line item. Update if needed.

10. Select the report line item type in the Filter by Line Item Type drop-down list.

11. Select the report line item and line item balance you wish to insert.

12. Click Apply Line Item Update. The report line item is inserted into the selected cell.

If you are ever uncertain about a modified report template's integrity, you can create a new customized report template based on the original J1 Desktop report template.

To edit a report line item you are working with on the Review/Add Report Line Items tab, click the Manage Report Line Items link. The Manage Report Line Items window opens in modify mode and modify line item view displaying the selected report line item.

1. Open the Financial Reporting window.

2. On the Manage Report tab, select the report you want to work with.

3. Click the Review/Add Report Line Items tab.

4. Click Edit in Excel Mode to modify the report template in the Excel template pane.

While in Excel mode, you can edit and delete text and delete report line items.

5. If you want to insert a report line item, double-click in the cell where you want it inserted.

6. Click Return to J1 Mode and Yes to the message asking if you want to save your changes. The value of your cursor's last cell position is saved in the Specify Excel Cell Location column, which is where any new report line item will be inserted.

7. To add a report line item, select the appropriate report line item and line item balance under Select New Line Item.

8. Click Apply Line Item Update. The report line item is inserted into the selected cell.

If you are ever uncertain about a modified report template's integrity, you can create a new customized report template based on the original J1 Desktop report template.

1. Open the Financial Reporting window.

2. On the Manage Report tab, select the report you want to work with.

3. Click the Review/Add Report Line Items tab.

4. Click Edit in Excel Mode to modify the report template in the Excel pane.

5. Remove the report line item or the entire row from the report template.

6. Click Return to J1 Mode and Yes to the message asking if you want to save your changes.

7. On the displayed Modified Line Item Details window, choose Proceed To Save to remove the report line item or Cancel to keep the line item. If you cancel, you must click Return to J1 Mode again and choose whether or not to save the change. If you choose Proceed to Save, the change will be saved on the report template.

If you are ever uncertain about a modified report template's integrity, you can create a new customized report template based on the original J1 report template.