FWS Monthly Reconciliation Worksheet

The FWS Monthly Reconciliation Worksheet is designed to assist your
school with the monthly reconciliation process. If your school has been
reconciling monthly, the year-end process should\
be easier.

These instructions should help your school understand how to use the FWS
Monthly\
Reconciliation Worksheet.

-   **Offices involved in the process:** Financial Aid Office, Business
    Office, and Financial Aid Systems.

-   **Financial Aid Office Column:** Determine the amounts disbursed
    each month (according to Financial Aid Office records). Calculate
    the totals in the last row.

-   **Business Office Column:** Determine the amounts disbursed
    (according to Business Office records, ledger, bank statements,
    etc). Calculate the totals in the last row.

-   **G5:** Record the amounts in each column as reported in G5
    (Formerly GAPS).

-   **Administrative Cost Allowance Column:** Use this column to
    determine any Administrative Cost Allowance claimed by the school.
    If none was claimed, this column can be skipped. For more
    information, use the link to the Administrative Cost Allowance
    exercise available on the worksheet.

-   **Program Transfers Column:** Use this column to record and track
    any transfers from the FWS program to any other Campus-Based
    Program.

-   **FWS Matching Column:** Use this column to ensure that FWS Matching
    was done correctly.

Month of:      

  ------------- ---------- ---------- ---------- ------------- ---------- ---------- ------ ------------- ---------- ----------
  Financial Aid                       Business                                       G-5                             
  Office                              Office                                         GAPS                            
  Records                             Records                                                                        

  Distributed   Adjusted   Net                   Distributed   Adjusted   Net               Distributed   Adjusted   Net
                           Expended                                       Expended                                   Expended

                                                                                                                          

                                                                                                                          

                                                                                                                          

                                                                                                                          

                                                                                                                          

                                                                                                                          

                                                                                                                          

                                                                                                                          

                                                                                                                          

  Totals:                                                                                                                 

                                                                                                                     
  ------------- ---------- ---------- ---------- ------------- ---------- ---------- ------ ------------- ---------- ----------

Explanation of differences in amounts reported by Financial Aid Office,
Business Office, or

G5:

  ----------------- ----------------- ----------------- -------------------
  Administrative                                        
  Cost Allowance                                        
  Claimed\*                                             

  Program Transfers                                     

  From                                                       

  Amount                                                     

  To                                                         

  Amount                                                     
  ----------------- ----------------- ----------------- -------------------

  ----------------- ----------------- ----------------- -------------------
  FWS Matching \*\*                                     

  Date                                                       

  Gross Comp                                                 

  Inst. Share                                                

  Federal Share                                              
  ----------------- ----------------- ----------------- -------------------

Tools for FWS Administrative Cost Allowance and Non-Federal Share:

\*Complete the [FWS Administrative Cost Allowance
Activity](http://ifap.ed.gov/qadocs/FWSModule/Activity2FWS.doc)
(Activity 2) from the FWS Assessment.

\*\*Complete the [FWS Non-Federal Share and Community Service
Activity](http://ifap.ed.gov/qadocs/FWSModule/Activity5FWS.doc)
(Activity 5) from the FWS Assessment.