Page Comparison

...

1. Click to download the spreadsheet template for Financial Detail Template with Running Fund Balance. This template will support approx. 50,000 entries. The formulas used to calculate totals can be modified if more entries are needed.
   1. NOTE: If opening the template spreadsheet directly from this web page, the spreadsheet may open in Protected View. Click 'Enable Editing' on the yellow bar across the top of the spreadsheet.
2. In USAS-R, click to generate SSDT navigate to the Report > Financial Detail Report July 1 Cash Balances. on the drop down.
3. Enter Report Parameters
   1. Enter Start/End dates for the fiscal year
   2. Format: HTML-Table
   3. Include specific Fund(s) or Fund-SCC(s) if desiredReport for a specific posting period can be used to generate report for previous Fiscal Years if needed. See  the Reports Manager section on Query Parameters options included on SSDT Template Reports for additional detail on how to use this parameter.
      Image Removedaccount parameters or a filter
      Image Added
4. Save the report parameters using the Save and Recall option.
   1. Select the blank option and enter a save name. 
      Image RemovedImage Added
      
      
      
   2. Once you tab off the field, the 'save' icon will be active.  Click on  to save your report and parameter settings. 
      Image Removed
      Image Added
   3. Your saved report name will now be included in the 'save and recall' drop down menu. 
5. Once the report parameters have been saved, the link icon Image Removed Image Addedwill become available. Click the link icon to open the Report Direct Link pop up window. 
   

   1. Right click on the URL link that appears in the pop up window. Choose to copy the link address.
      Image Removed
      Image Added
      
      

      Note
      Do not check the box for 'Include parameters?' when using the Report Direct Link with Excel. This option adds to the length of the link that could cause issues with the Excel character limit.

      
      

6. Open the Financial Detail Template with Running Fund Balance spreadsheet in Excel. Navigate to the Data Tab. Click 'Get External Data from Web.'
   
   
   
   
   1. Paste the Link into the Web Address field. Click Go. 
      
      
      

   2. Enter username and password for USAS-R. 

      Note
      If you are not prompted for credentials after you click 'Go' then Excel has not started loading the data. If this happens, close the pop up window and click on 'Get External Data from Web' again.

      
      

      Warning
      It is common for this step to take time to load - specifically when pulling a large set of data (full Fiscal Year). The HTML Table to show in the preview window and the 'Import' option to become available when Excel has finished loading.

      
      

   3. Once data from link loads, click Import.

   4. Click on cell A3 to select where to put the imported data.
      
      
      

      Warning
      It is common for this step to take time to load - specifically when pulling a large set of data (full Fiscal Year). Excel will indicate in the bottom left corner of the window that it is running a query in the background.

      
      

7. Enter the Beginning Fund Balance in cell E2.
   
   
   
   
   1. The Beginning Fund Balance can be found on the Fund Account page or the SSDT Cash Summary report can be generated for the same parameters used when generating SSDT Financial Detail July 1 Cash Balances (fund, posting period, etc.). Once the Beginning Fund balance is entered, the SSDT Cash Summary report is also useful for balancing the other calculated fields on the Financial Detail spreadsheet. 
   2. When the Beginning Fund Balances has been entered Column J will populate with the running Fund Balance for each transaction.
8. Save the Excel spreadsheet to your computer.

...