Itemized Fee Worksheet at a glance
What it is: The Itemized Fee Worksheet is for use with Service Providers and Investors.
A filled-in Itemized Fee Worksheet example: a lender estimates fees for a home purchase

How to fill out Itemized Fee Worksheet, box by box
Loan Number, Interest Rate, Type of Loan and Loan Amt
Items Payable in Connection with Loan and Title Charges

Under 800, Items Payable in Connection with Loan, enter Loan Origination Fees (% and $), Application Fees, Processing Fees, Underwriting Fees, Broker Fees (% + $) and 802 Credit or Charge for Interest Rate.
Enter 803 Adjusted Origination Charges.
Under 1100, Title Charges, enter 1102 Settlement or Closing Fee, 1103 Owner's Title Insurance, 1104 Lender's Title Insurance, 1109, 1110, 1111, 1112, 1113 and 1114.
Enter Total Title Charges.
Government Recording and Transfer Charges and Appraisal Fee

Under 1200, Government Recording and Transfer Charges, enter 1202 Recording Fees, 1203 Transfer Taxes, 1204 City/County Tax/Stamps, 1205 State Tax/Stamps, 1206, 1207 and 1208.
Enter 804 Appraisal Fee to, 805 Credit Report to, 806 Tax Service to, 807 Flood Certification, 808, 809, 810, 811, 812, 813, 814, 815, 816 and 817.
Enter Total Recording/Transfer Charges.
If your situation is different
Estimated charges
The information provided reflects estimates of the charges that are likely to be incurred at the settlement of this loan. The fees listed are estimates; some actual charges may be more or less. This transaction may not involve a fee for every item listed.
Additional Settlement Charges
Under 1300, Additional Settlement Charges, enter 1302, 1303, 1304, 1305, 1306, 1307, 1308 and 1309.
Enter Total Estimated Closing Costs.
Estimated Reserve/Prepaid Costs
Under Estimated Reserve/Prepaid Costs, 900, Items Required by Lender to be Paid in Advance, enter 901 Daily Interest (Days @ $), 902 Mortgage Ins Premium to, 903 Homeowner's Insurance to, 904, 905 VA Funding Fee, 906 Flood Insurance, 907, 908 and 909.
Under Reserves Deposited with Lender, enter 1001 Initial Deposit into Escrow Account, 1002 Homeowner's Ins (mths @ $), 1003 Mortgage Ins (mths @ $), 1004 Property Taxes (mths @ $), 1005 City Property Tax (mths @ $), 1006 Flood Reserve (mths @ $), 1007, 1008 and 1009 (mths @ $) and 1010 Aggregate Adjustment -.
Enter Total Estimated Reserve/Prepaid Costs.
Transaction Summary
Under Transaction Summary, Total Estimated Monthly Payment, enter Principal and Interest, Other Financing (P & I), Hazard Insurance, Real Estate Taxes, Mortgage Insurance, HOA Dues, Other and Total Monthly Payment.
Under Total Estimated Funds Needed to Close, enter Purchase Price/Payoff (+), Total Estimated Closing Costs (+), Total Estimated Reserve/Prepaid Costs (+), Discounts (if borrower will pay) (+), FHA UFMIP/VA Funding Fee (+) and Total Costs (c), then Loan Amount (-), Non-Borrower Paid Closing Costs (-), FHA UFMIP/VA Fee Financed (-), First Mortgage (-), Second Mortgage (Sub Financing) (-), Closing Costs from (-) and Total Credits (d).
Closing Costs Summary
Under Closing Costs Summary, enter Borrower Paid Closing Costs (a) and Total Non-Borrower Paid CC (b).
Enter Total Closing Costs (a + b).
Paid by Seller, Broker, Lender or Other
S - Paid by Seller; S/ - Split by Seller & Others; B - Paid by Broker; L - Paid by Lender; A - APR Affected by Cost; O - Paid by Other; P - Paid Outside Closing (POC).
Sources
[1] Itemized Fee Worksheet (For Use with Service Providers and Investors), 02/2010 (the Official source link on this page).


