Figure 16 To get the Bank Account, left on the spyglass (see figure 17) Figure 17 Select the relevant Bank Account and left click on the button (see figure 18) “Select” Figure 18 Only the date is required in the Transaction Date. Then select (see figure 19) “to” “OK” Figure 19 Select the export file icon on the top right hand side of the screen (indicated by a red circle in figure 20) Figure 20 Select Body”, then select 4.0” from the Format dropdown box. Select (see Figure 21) “Main “Excel “OK” Figure 21 Save the file in the Files” folder that you created on your desktop. Save the file using the naming convention number-UI-P “Exports “DFE and period number” eg. 2042861-UI-P07 or 2042861-UI-P11 for period 11. (See figure 22) Click on save and then close the report window Figure 22 PROCEDURE FOR EMAILING THE REPORTS Open the Excel file for emailing the monitoring reports”. See Screenshot below. “Utility
Figure 16 To get the Bank Account, left on the spyglass (see figure 17) Figure 17 Select the relevant Bank Account and left click on the “Select” button (see figure 18) Figure 18 Only the “to” date is required in the Transaction Date. Then select “OK” (see figure 19) Figure 19 Select the export file icon on the top right hand side of the screen (indicated by a red circle in figure 20) Figure 20 Select “Main Body”, then select “Excel 4.0” from the Format dropdown box. Select “OK” (see Figure 21) Figure 21 Save the file in the “Exports Files” folder that you created on your desktop. Save the file using the naming convention “DFE number-UI-P and period number” eg. 2042861-UI-P07 or 2042861-UI-P11 for period 11. (See figure 22) Click on save and then close the report window Figure 22 PROCEDURE FOR EMAILING THE REPORTS Open the Excel file “Utility for emailing the monitoring reports”. See Screenshot below.
Monthly%20Reporting%20Procedure%20Notes%20-%20v3.docx