User Tools

Site Tools


academy:midyear_extracts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
academy:midyear_extracts [2021/11/16 16:07] apapeacademy:midyear_extracts [2021/12/10 19:48] (current) apape
Line 5: Line 5:
 \\   \\  
 <WRAP box>**CAUTION:** Each time you extract data using the **Delete ALL** and **Add** options, you overwrite the data in the frozen files (i.e., the State Reporting maintenance pages), including any data that was manually entered. If you extract multiple times, make sure to select one of the options to Add New records. It is recommended that all extracts are completed before making changes to the frozen file.</WRAP> <WRAP box>**CAUTION:** Each time you extract data using the **Delete ALL** and **Add** options, you overwrite the data in the frozen files (i.e., the State Reporting maintenance pages), including any data that was manually entered. If you extract multiple times, make sure to select one of the options to Add New records. It is recommended that all extracts are completed before making changes to the frozen file.</WRAP>
-\\  \\ +\\  
 +{{:images:screenshots:midyear_data_extract.png|Mid-Year Data Extract}} 
 +\\ \\
 ^Method|{{page>general:interchangefinanceextension_method_midyear}}| ^Method|{{page>general:interchangefinanceextension_method_midyear}}|
 ^Year 1\\  Year 2|{{page>general:interchangefinanceextension_year}}| ^Year 1\\  Year 2|{{page>general:interchangefinanceextension_year}}|
Line 32: Line 33:
  
 <div indent> <div indent>
-  * Repeat the extract for class 3xxx data only. +  * If needed, repeat the extract for class 3xxx data only.\\ 
-  * Go to [[maintenance:midyear:finance|State Reporting > Maintenance > Finance Actual]] where you can manually enter ending fund balances (3xxx) into frozen as reflected on schedule C-1 of the audit. The totals should match the audit report.+
  
-<div indent><WRAP Box>**Note**: Fund Balances should be entered with the opposite sign as displayed in Finance. For example, if the balance is -2,9750,000 in Finance, enter as 2,9750,000 in State Reporting. The extract automatically makes the change.+{{:images:screenshots:midyear_repeat_extract1.png|Setting parameters for Class 3 extract}}\\ 
 + 
 +{{:images:screenshots:midyear_repeat_extract1_report.png|Setting parameters for Class 3 extract report}} 
 +  * Or go to [[maintenance:midyear:finance|State Reporting > Maintenance > Finance Actual]] where you can manually enter ending fund balances (3xxx) into frozen as reflected on schedule C-1 of the audit. The totals should match the audit report.\\ 
 + 
 +{{:images:screenshots:midyear_repeat_extract2.png|Manually entering ending fund balances}} 
 +\\ 
 +<div indent><WRAP Box>**NOTE**: Fund Balances should be entered with the opposite sign as displayed in Finance. For example, if the balance is -2,9750,000 in Finance, enter as 2,9750,000 in State Reporting. The extract automatically makes the change.
 </WRAP> </WRAP>
 </div> </div>
Line 54: Line 61:
 \\ \\
  
-**NOTE:** You may run the extract a third time if you want to bring over the fund balance accounts. +<WRAP Box>**NOTE**You may run the extract a third time if you want to bring over the fund balance accounts. 
 +</WRAP> 
 <div indent> <div indent>
 </div> </div>
academy/midyear_extracts.1637078845.txt.gz · Last modified: 2021/11/16 11:07 (external edit)