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.
2. In USAS-R, click to generate SSDT Financial Detail Report July 1 Cash Balances. 
3. Enter Report Parameters
   1. Format: HTML-Table
   2. Include specific Fund(s) or Fund-SCC(s) if desired
   3. Report 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.
      
4. Save the report parameters using the Save and Recall option.
   1. Select the blank option and enter a save name. 
      
      
      
      
   2. Once you tab off the field, the 'save' icon will be active.  Click on  to save your report and parameter settings. 
      
      
   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 will 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.
      
      
      
      

      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.
      
      
      

   5. Enter username and password for USAS-R. 

      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 in USAS-R for the same parameters used when generating SSDT Financial Detail July 1 Cash Balances (fund, posting period, etc.) to get the Beginning Fund Balance. Once the beginning Beginning Fund balance is entered, this the SSDT Cash Summary report is also useful for balancing the other Calculated calculated fields on the Financial Detail spreadsheet - Ending Fund Balance, Total Received Amount, Total Expended Amount.Once . 
   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.

...