How to run General Ledgers (written)

About the Ledger Cart

Your Ledger Cart is like an online shopping cart for reports. When you print or export ledgers, it is the reports in the Ledger Cart that are printed or exported.

To put reports into your Ledger Cart, you search for them or browse all of the reports available to you. While you search or browse, selecting a report puts that report into the Ledger Cart.

To remove reports from your Ledger Cart, you select the Ledger while searching or browsing. Then, you select which reports to remove. You can also clear all of the reports from your Ledger Cart at once.

The reports that you've placed into your Ledger Cart remain there from one session to another. If you log out and return to the Ledger Cart, the reports will still be in your Cart.

To Run Ledger Reports

To run reports:

1. Search or Browse the ledgers.
2. Select the reports you want to include in your Ledger Cart.
3. Print or Export the reports in your Ledger Cart.

Search Ledgers

Set Search Criteria

1. From the Sinai Central home page, select Finance > General Ledgers.
   
   The General Ledgers menu displays in the left column.
2. Select Search Ledgers.
3. If you do not want to limit the search to specific funds, leave the Fund Number field blank. If you do want to limit the search to specific funds:
   
   a. Select one of the options from the drop-down menu:
   
   
   b. Enter all or part of the fund number into the Fund number field:
4. If you do not want to limit the search to a specific department, leave the Department drop-down field set to All. If you do want to limit the search to a specific field, select it from the drop-down list.
5. If you want to limit the search to funds owned by a specific person, enter all or part of that person's last name into the Owner's Last Name Field.

Select the Report(s)

1. Click to place a check mark next to each report you want to include in your Ledger Cart.
   
   Clicking the Report Types button displays a pop-up window with a list of the report types.
2. If you do not select a Beginning Month and Ending Month, all time periods will be retrieved. To limit the search to a specific time period, select the Beginning Month and Ending Month from the drop-down lists.
3. Click the Search button.
   
   All reports that meet your search criteria are listed at the bottom of the window. You might need to scroll down to see them.
    
4. Click to select each report you want to include in your Ledger Cart.
5. Click the Update View button.
   The reports that you selected are added to your Ledger Cart. At the top of the window, the Current Report Selection area informs you how many reports are in your Ledger Cart.
   

Print Ledgers

You can print or export the reports in your Ledger Cart.

1. From the General Ledgers menu, select Print.
   The list of reports in your Ledger Cart displays. All of them have check marks next to their names.
2. To remove a report from your Ledger Cart, click the check box to clear the check mark next to the report.
3. To sort the reports, use the drop-down menus.
   
4. Click the Print button.
   A popup window appears, informing you that a .pdf (Adobe Acrobat) file is being generated.
5. When the report is generated, click the link that reads Download the PDF from here.
6. A separate window appears, with the .pdf file displayed in that window.
   
7. Using icons at the top of the window, you can save and print the report. If you save the report to your personal computer, remember that if the report is updated later you will have saved an outdated version.

Export Ledgers

1. From the General Ledgers menu, select Export.
   The list of reports in your Ledger Cart displays. The list is sorted by report name. Next to the name of each report, the number of time periods for that report is displayed.
   
2. To export a report, click the page icon next to the report name.
   The complete list of reports displays.
3. From the Format drop-down menu, select Excel or csv.
4. Select the form of worksheet to create. Each selection represents a different way of sorting the data in the worksheet.
    
5. Select the fields to export. To select multiple fields that are next to each other, click on the field that is first in the list, and then Shift-click on the field that is last. To select multiple fields that are not next to each other, Control-click on each field.
6. Click the right arrow to include the selected fields in the report.
7. Click the execute button.
   If you exported as an Excel worksheet, the worksheet opens in Excel. If you exported as a CSV file, a Save dialog box enables you to select the location to save.