Cover Page - NFIP Write Your Own Accounting Training Manual October 2005 NATIONAL FLOOD INSURANCE PROGRAM WRITE YOUR OWN (WYO) ACCOUNTING TRAINING MANUAL Eighth Printing October 1, 2005 Part A Monthly Financial Statement Package Reporting Requirements...................A-1 Part B Completion of Required Financial Statement Package Documents..............B-1 Part C Monthly Statistical Data Front-End Balancing Procedures ............................C-1 Part D NFIP Bureau and Statistical Agent Processing of Required Financial Documents.....................................................................................................D-1 Part E Supplemental Claim Payment Procedures....................................................E-1 Part F Cash Management Procedures.....................................................................F-1 Part G Stale-Dated Check Procedures .................................................................... G-1 Part H Credit Card Processing..................................................................................H-1 Part I Listing of Pertinent WYO Accounting/Financial Documents ........................... I-1 Table of Contents Effective: 10/1/05 EXHIBIT I Income Statement..............................................................................B-3 EXHIBIT II Reconciliation of Payable/Receivable Balance..................................B-4 EXHIBIT III Balance Sheet Items..........................................................................B-5 EXHIBIT IV Expense Allowance Calculation.........................................................B-6 EXHIBIT V-A Fee Schedule – Allocated LAE ..........................................................B-7 EXHIBIT V-B Fee Schedule – Allocated LAE ..........................................................B-8 EXHIBIT V-C Fee Schedule – Allocated LAE ..........................................................B-9 EXHIBIT V-D Fee Schedule – Allocated LAE ........................................................B-10 EXHIBIT V-E ICC Fee Schedule – Allocated LAE.................................................B-11 EXHIBIT V-F Fee Schedule – Allocated LAE ........................................................B-12 EXHIBIT V-G ICC Fee Schedule – Allocated LAE.................................................B-13 EXHIBIT VI Other Loss and LAE Calculation......................................................B-14 EXHIBIT VII Interest Income ................................................................................B-15 EXHIBIT VIII-A Letter of Credit Drawdowns..............................................................B-16 EXHIBIT VIII-B Cash Payments to the NFIP.............................................................B-17 EXHIBIT VIII-C Credit Card Payments to the NFIP...................................................B-18 EXHIBIT VIII-D Internet Payments to the NFIP ........................................................B-19 EXHIBIT VIII-E Wire Transfer Payments to the NFIP...............................................B-20 EXHIBIT IX Restricted Account Deposits Summary............................................B-21 List of Exhibits Effective: 10/1/05 MONTHLY FINANCIAL STATEMENT PACKAGE REPORTING REQUIREMENTS I. STATEMENTS REQUIRED On a monthly basis, a WYO Company is required to submit the following financial documents: A. Financial Statements (Contained in the WYO Accounting Procedures Manual) • Exhibit I – Income Statement • Exhibit II – Reconciliation of Payable/Receivable Balance • Exhibit III – Balance Sheet Items • Exhibit IV – Expense Allowance Calculation • Exhibit V-A – Fee Schedule - Allocated LAE • Exhibit V-B – Fee Schedule - Allocated LAE • Exhibit V-C – Fee Schedule - Allocated LAE • Exhibit V-D – Fee Schedule - Allocated LAE • Exhibit V-E – Fee Schedule - ICC Claims - Allocated LAE • Exhibit V-F – Fee Schedule - Allocated LAE • Exhibit V-G – Fee Schedule - ICC Claims - Allocated LAE • Exhibit VI – Other Loss and LAE Calculation • Exhibit VII – Interest Income • Exhibit VIII-A – Letter of Credit Drawdowns • Exhibit VIII-B – Cash Payments to the NFIP • Exhibit VIII-C – Credit Card Payments to the NFIP • Exhibit VIII-D – Internet Payments to the NFIP • Exhibit VIII-E – Wire Transfer Payments to the NFIP • Exhibit IX – Restricted Account Deposits Summary NOTE: Financial statements can be submitted either in hard copy or transmitted electronically via e-mail. For further instructions, please refer to the WYO Accounting Procedures Manual, Part G, Use of Preformatted Excel Financial Statement Spreadsheet for Monthly Financial Statement Reporting. • Monthly Reconciliation - Net Written Premiums • Monthly Reconciliation - Net Federal Policy Fees • Monthly Reconciliation - Net Paid Losses • Monthly Reconciliation - Special Allocated LAE • Monthly Reconciliation - Case Loss Reserve C. REPORTS CERTIFICATION STATEMENTS (Contained in the WYO Financial Control Plan) • Monthly Financial and Statistical Reconciliation Reports • Monthly Statistical Transaction Report II. DUE DATES FOR REQUIRED FINANCIAL DOCUMENTS All monthly financial statements, reconciliation statements, and certification statements must be received by the NFIP Bureau and Statistical Agent no later than the 21st day of the calendar month following each month's closing. Example: Financial statements for May's reporting period are to be received by the NFIP Bureau and Statistical Agent no later than June 21, 20XX. III. WHERE TO SEND REQUIRED FINANCIAL DOCUMENTS The required financial documents should be sent to the following address: National Flood Insurance Program Bureau & Statistical Agent ATTN: Finance & Statistical Control Department 7700 Hubble Drive Lanham, MD 20706-1833 E-mail: financials@nfipstat.com COMPLETION OF REQUIRED FINANCIAL STATEMENT PACKAGE DOCUMENTS I. MONTHLY FINANCIAL STATEMENTS As previously stated, the WYO Program requires the completion of certain accounting documents on a monthly basis. The following pages detail how each of the required documents should be completed. We start with the completion of the financial statements, then proceed to the financial/statistical reconciliation reports, and end with the completion of the certification statements. To better demonstrate how to complete each required document, a fictitious WYO Company (Harwell) has been established. This WYO Company is reporting financials for the second time. The next page gives "general, premium, claim, and financial" information for this fictitious WYO Company. This establishes the starting point for completing the required documents. NOTE: In this narrative portion, all credit entries are shown in parentheses. Following this information are completed samples of all the required documents, with figures representing data to be reported. Note that each line on these documents contains an identifier (for example, 1A, 2A, etc.). This line identifier corresponds with a subsequent narrative that describes what each figure represents and how it was developed. This method of presentation should greatly enhance your understanding of the Training Manual and lead to the proper completion of the required documents. Now let us proceed to the actual completion of the required documents. Good luck! • WYO Company is reporting financials for the second time. • The expense allowance is 31.2 percent. (This percentage is for illustrative purposeonly.) • WYO Company deposits into the Flood Insurance Restricted Account are made on adaily basis. • WYO Company uses the credit card payment mechanism. • Excess funds are transmitted at least weekly through the Automated Clearinghouse(ACH) mechanism, wire transfer, or Internet transfer. • Fiscal year-to-date (FYTD) totals for appropriate exhibits are developed by addingthe current month's figure to the prior month's FYTD total. PREMIUM INFORMATION Data Given Booked Net Written Premium Booked Net Federal Policy Fees Earned Premium Ending Unearned Premium Reserve Premium Not Booked (Suspense) Current Month $400,000$ 30,000$ 50,000$533,333$ 2,000 CLAIM INFORMATION Prior Month $ 200,000$ 15,000$ 16,667$ 183,333$ 1,000 Prior Month 2 0 2 $ 0 $ 0 $ 0 $ 40,000 Prior Month $ 201,000$ 0 $ 15,000 $ 0 $ 0 $ 145,680$ 1,200$ 400 $ 0 Data Given Claims ReportedClaims Paid and Closed Claims OutstandingPaid Loss Amounts Salvage CollectedSpecial Allocated LAEEnding Case Reserve Current Month 4 3 3 $ 169,000$ 100 $ 50 $ 60,000 FINANCIAL INFORMATION Data Given Premiums Collected in Form of Check/CashPremiums Charged on Credit CardFederal Policy Fees Collected in Form of Check/CashFederal Policy Fees Charged on Credit Card Cancellation Refunds Excess Funds Total Transferred Rating Organization ExpenseState Sales Tax Prior Term Refund Expense Allowance Due the NFIP Current Month $400,890$ 1,200 $ 29,910 $ 90 $ 1,200 $122,596$ 3,000$ 500 $ (300) 1A COMPANY (NAME) Harwell 1B COMPANY (NUMBER) 11111 1C PERIOD ENDING MAY 20XX CURRENT FISCAL– MONTH YEAR-TO-DATE REVENUE 1D 100. Net Written Premiums 400,000 600,000 1E 105. Change in Unearned Premium (350,000) (533,333) 1F 110. Earned Premium 50,000 66,667 EXPENSES 1G 115. Net Paid Losses 168,900 168,900 1H 120. Allocated LAE (Line 500) 5,160 5,160 1I 125. Other Loss and LAE Items (Line 660) 6,294 7,614 1J 130. Change in Loss and LAE Reserves(Lines 325 through 340, Col. C) 82,980 185,960 1K 135. Net Loss and LAE Incurred 263,334 367,634 1L 140. Expense Allowance (Line 430) 128,030 192,030 1M 150. Miscellaneous Expense 20 20 1N 155. Total Expense 391,384 559,684 1O 160. Operating Income (Loss) (341,384) (493,017) 1P 165. Interest Income (Line 710) - 0 -- 0 - 1Q 170. Net Federal Policy Fees 30,000 45,000 1R 175. Net Income (Loss) (311,384) (448,017) 1S PREPARER'S NAME Robert George 1T PHONE NUMBER 111-111-1111 2A COMPANY (NAME) Harwell 2B COMPANY (NUMBER) 11111 2C PERIOD ENDING MAY 20XX CURRENT FISCAL– MONTH YEAR-TO-DATE 2D 200. Beginning Payable/ Receivable Balance (Line 315, Col. B) (282,313) - 0 - 2E 205. Net Income (Loss) (Line 175) (311,384) (448,017) 2F 210. LOC Funds Received (Line 800) - 0 -- 0 - 2G 215. Disbursements to NFIP (Line 805) (122,596) (268,276) 2H 220. Ending Payable/ Receivable Balance (Line 315, Col. A) (716,293) (716,293) BALANCE SHEET ITEMS 3A PERIOD ENDING MAY 20XX ABC D INCREASE/ BEGINNING CURRENT PRIOR (DECREASE) OF FISCAL MONTH MONTH (COL. A-B) YEAR 3B 300. Cash 25,000 5,000 20,000 - 0 - 3C 305. Cash - Not Transferred To Restricted Account* - 0 -- 0 -- 0 -- 0 - 3D 310. Cash - Not Transferred From Restricted Account* (20,000) - 0 -(20,000) - 0 - 3E 315. Payable To (Receivable From) NFIP 716,293 282,313 433,980 - 0 - 3F 320. Unearned Premium Reserves (533,333) (183,333) (350,000) - 0 - 3G 325. Loss Reserves (Case) (60,000) (40,000) (20,000) - 0 - 3H 330. Loss Reserves (IBNR) (120,000) (60,000) (60,000) - 0 - 3I 335. LAE Reserves - Case (Allocated) (700) (300) (400) - 0 - 3J 336. LAE Reserves - IBNR (Allocated) (1,300) (700) (600) - 0 - 3K 340. LAE Reserves (Unallocated) (3,960) (1,980) (1,980) - 0 - 3L 345. Premium Suspense (Under 60 Days Old) (2,000) (1,000) (1,000) - 0 - 3M 346. Premium Suspense (60 Days and Older)* - 0 -- 0 -- 0 -- 0 - TOTAL - 0 -- 0 -- 0 -- 0 - Please show debits as positive numbers and bracket all credits. The columns must add to - 0 -. *Upon FEMA request, WYO Company must provide supporting aged detail for the reported balance. Companies will be notified when such a request is made. EXPENSE ALLOWANCE CALCULATION 4A COMPANY (Name) Harwell 4B COMPANY (Number) 11111 4C PERIOD ENDING MAY 20XX CURRENT FISCAL– MONTH YEAR-TO-DATE EXPENSE ALLOWANCE 4D 400. Net Written Premium (Line 100) 400,000 600,000 4E 405. Expense Allowance % x 31.2% x 31.2% 4F 410. Expense Allowance for Written Premium 124,800 187,200 4F1 411. For Future Reference - 0 -- 0 - 4F2 412. For Future Reference - 0 -- 0 - 4F3 413. For Future Reference - 0 -- 0 - 4F4 414. Subtotal Expense Allowance 124,800 187,200 4G 415. Cancellation Premium Refund Adjustment Base 200 200 420. Commission Allowance % 15% 15% 4H 425. Cancellation Commission Retention 30 30 4I 426. Expense Allowance Adjustment - 0 -- 0 - for Bonus Commission 4J 427. Rating Organization Expense 3,000 4,200 4K 428. State Sales Tax on Insurance Services 500 900 4K1 429. Prior Term Refund Expense Allowance Due to the NFIP (300) (300) 4L 430. Total Expense Allowance 128,030 192,030 EXHIBIT V-A FEE SCHEDULE - ALLOCATED LAE (USE FOR CLAIMS WITH LOSS DATE OF 9/30/90 AND PRIOR) COMPANY (NAME) COMPANY (NUMBER) PERIOD ENDING A ENTRY VALUE RANGE Erroneous AssignmentClosed Without Payment$ .01 -$ 200.00 200.01 -400.00 400.01 -600.00 600.01 -800.00 800.01 -1,000.00 1,000.01 -1,500.00 1,500.01 -2,000.00 2,000.01 -2,500.00 2,500.01 -3,000.00 3,000.01 -3,500.00 3,500.01 -4,000.00 4,000.01 -4,500.00 4,500.01 -5,000.00 5,000.01 -6,000.00 6,000.01 -7,000.00 7,000.01 -8,000.00 8,000.01 -9,000.00 9,000.01 -10,000.00 10,000.01 -15,000.00 15,000.01 -20,000.00 20,000.01 -25,000.00 25,000.01 -30,000.00 30,000.01 -35,000.00 35,000.01 -40,000.00 40,000.01 -45,000.00 45,000.01 -50,000.00 50,000.01 -75,000.00 75,000.01 -100,000.00 100,000.01 -125,000.00 125,000.01 -150,000.00 150,000.01 -175,000.00 175,000.01 -200,000.00 200,000.01 to Limits Harwell 11111 MAY 20XX B C D NUMBER FEES PAID CLOSED FEE (COLS. B X C) $ 40.00 70.00 70.00 90.00 110.00 130.00 150.00 180.00 200.00 220.00 240.00 260.00 280.00 300.00 320.00 350.00 370.00 380.00 400.00 420.00 460.00 490.00 520.00 550.00 580.00 610.00 640.00 670.00 800.00 950.00 1,100.00 1,250.00 1,400.00 1,550.00 1,700.00 500-A. Total Allocated LAE Fees Paid - Exhibit V-A* *Upon FEMA request, WYO Company must provide supporting detail for the reported expense. EXHIBIT V-B FEE SCHEDULE - ALLOCATED LAE (USE FOR CLAIMS WITH LOSS DATE OF 10/1/90 TO 10/31/96) COMPANY (NAME) COMPANY (NUMBER) PERIOD ENDING A B ENTRY VALUE RANGE ERRONEOUS ASSIGNMENT CLOSED WITHOUT PAYMENT MINIMUM FOR UPTON-JONES $ .01 -$600.00 600.01 -1,000.00 1,000.01 -2,000.00 2,000.01 -3,500.00 3,500.01 -5,000.00 5,000.01 -7,000.00 7,000.01 -10,000.00 10,000.01 -15,000.00 15,000.01 -25,000.00 25,000.01 -35,000.00 35,000.01 -50,000.00 50,000.01 -100,000.00 100,000.01 -150,000.00 150,000.01 -200,000.00 200,000.01 to Limits Excess Mileage Harwell 11111 MAY 20XX C D NUMBER FEES PAID CLOSED FEE (COLS. B X C) $ 40.00 125.00 800.00 150.00 175.00 225.00 275.00 350.00 425.00 500.00 550.00 600.00 __1 675.00 _675_ 750.00 1,000.00 1,300.00 1,600.00 2,000.00 5B 500-B. Total Allocated LAE Fees Paid - Exhibit V-B* __675___ *Upon FEMA request, WYO Company must provide supporting detail for the reported expense. FEE SCHEDULE - ALLOCATED LAE (USE FOR CLAIMS WITH LOSS DATE OF 11/1/96 TO 4/30/97) COMPANY (NAME) COMPANY (NUMBER) PERIOD ENDING A ENTRY VALUE RANGE ERRONEOUS ASSIGNMENT CLOSED WITHOUT PAYMENT MINIMUM FOR UPTON-JONES Harwell 11111 MAY 20XX B C D NUMBER FEES PAID CLOSED FEE (COLS. B X C) $ 40.00 125.00 800.00 150.00 175.00 225.00 275.00 350.00 425.00 500.00 550.00 600.00 675.00 750.00 __1 _ 3.0% _2,085__ 2.3%, BUT NOT LESS THAN $3,000 2.1%, BUT NOT LESS THAN $5,750 $ .01 600.01 1,000.01 2,000.01 3,500.01 5,000.01 7,000.01 10,000.01 15,000.01 25,000.01 35,000.01 50,000.01 100,000.01 -$ 600.00 -1,000.00 -2,000.00 -3,500.00 -5,000.00 -7,000.00 -10,000.00 -15,000.00 -25,000.00 -35,000.00 -50,000.00 -100,000.00 -250,000.00 250,000.01 and up 5E 500-C. Total Allocated LAE Fees Paid - Exhibit V-C* _ 2,085__ *Upon FEMA request, WYO Company must provide supporting detail for the reported expense. FEE SCHEDULE - ALLOCATED LAE (USE FOR CLAIMS WITH LOSS DATE OF 5/1/97 TO 8/31/04) COMPANY (NAME) Harwell COMPANY (NUMBER) 11111 PERIOD ENDING A ENTRY VALUE RANGE ERRONEOUS ASSIGNMENT CLOSED WITHOUT PAYMENT $ .01 -$600.00 600.01 -1,000.00 1,000.01 -2,000.00 2,000.01 -3,500.00 3,500.01 -5,000.00 5,000.01 -7,000.00 7,000.01 -10,000.00 10,000.01 -15,000.00 15,000.01 -25,000.00 25,000.01 -35,000.00 35,000.01 -50,000.00 50,000.01 -100,000.00 100,000.01 -250,000.00 250,000.01 and up MAY 20XX B C D NUMBER FEES PAID CLOSED FEE (COLS. B X C) $ 40.00 125.00 150.00 175.00 225.00 275.00 350.00 425.00 500.00 600.00 750.00 900.00 2 1200.00 2,400 3.0% 2.3%, BUT NOT LESS THAN $3,000 2.1%, BUT NOT LESS THAN $5,750 5H 500-D. Total Allocated LAE Fees Paid - Exhibit V-D* 2,400 *Upon FEMA request, WYO Company must provide supporting detail for the reported expense. INCREASED COST OF COMPLIANCE (ICC) FEE SCHEDULE - ALLOCATED LAE (USE FOR ICC CLAIMS WITH LOSS DATE OF 6/1/97 TO 8/31/04) COMPANY (NAME) Harwell COMPANY (NUMBER) 11111 PERIOD ENDING MAY 20XX A B C D NUMBER FEES PAID ENTRY VALUE RANGE CLOSED FEE (COLS. B X C) ERRONEOUS ASSIGNMENT $ 40.00 CLOSED WITHOUT PAYMENT $ .01 -$ 600.00 600.01 -1,000.00 1,000.01 -2,000.00 2,000.01 -3,500.00 3,500.01 -5,000.00 5,000.01 -7,000.00 7,000.01 -10,000.00 10,000.01 -15,000.00 125.00 150.00 175.00 225.00 275.00 350.00 425.00 500.00 600.00 (Use the following entry range only for ICC total claim payments greater than $15,000 but not more than $20,000, and with a loss date of 5/1/00 to 4/30/03) 15,000.01 -20,000.00 ________ 750.00 ________ (Use the following entry range only for ICC total claim payments greater than $15,000 but not more than $30,000, and with a loss date of 5/1/03 to 8/31/04) 15,000.01 -20,000.00 ________ 750.00 ________ 20,000.01 -30,000.00 ________ 900.00 ________ 500-E. Total Allocated LAE Fees Paid - Exhibit V-E* *Upon FEMA request, WYO Company must provide supporting detail for the reported expense. FEE SCHEDULE - ALLOCATED LAE (USE FOR CLAIMS WITH LOSS DATE OF 9/1/94 AND LATER) COMPANY (NAME) Harwell COMPANY (NUMBER) 11111 PERIOD ENDING MAY 20XX A B NUMBER ENTRY VALUE RANGE CLOSED ERRONEOUS ASSIGNMENT CLOSED WITHOUT PAYMENT $ .01 -$ 1,000.00 1,000.01 -2,500.00 2,500.01 -5,000.00 5,000.01 -7,500.00 7,500.01 -10,000.00 10,000.01 -15,000.00 15,000.01 -25,000.00 25,000.01 -35,000.00 35,000.01 -50,000.00 ________ 50,000.01 -100,000.00 ________ 100,000.01 -250,000.00 ________ 250,000.01 and up C D FEES PAID FEE (COLS. B X C) $ 60.00 225.00 300.00 425.00 500.00 575.00 650.00 750.00 850.00 1,000.00 1,250.00 ________ 3.0% ________ 2.3% but not less ________ than $3,000.00 2.1% but not less ________ than $5,750.00 500-E. Total Allocated LAE Fees Paid –Exhibit V-F* *Upon FEMA request, WYO Company must provide supporting detail for the reported expense. INCREASED COST OF COMPLIANCE (ICC) FEE SCHEDULE - ALLOCATED LAE (USE FOR ICC CLAIMS WITH LOSS DATE OF 9/1/04 AND LATER) COMPANY (NAME) Harwell COMPANY (NUMBER) 11111 PERIOD ENDING MAY 20XX A B C D NUMBER FEES PAID ENTRY VALUE RANGE CLOSED FEE (COLS. B X C) ERRONEOUS ASSIGNMENT $ 60.00 CLOSED WITHOUT PAYMENT $ .01 -$ 1,000.00 1,000.01 -2,500.00 2,500.01 -5,000.00 5,000.01 -7,500.00 7,500.01 -10,000.00 10,000.01 -15,000.00 15,000.01 -25,000.00 25,000.01 -30,000.00 225.00 300.00 425.00 500.00 575.00 650.00 750.00 850.00 1,000.00 500-G. Total Allocated LAE Fees Paid – Exhibit V-G 0 500-F. Total Allocated LAE Fees Paid – Exhibit V-F 0 500-E. Total Allocated LAE Fees Paid – Exhibit V-E 0 500-D. Total Allocated LAE Fees Paid – Exhibit V-D 2,400 500-C. Total Allocated LAE Fees Paid – Exhibit V-C 2,085 500-B. Total Allocated LAE Fees Paid – Exhibit V-B 675 500-A. Total Allocated LAE Fees Paid – Exhibit V-A 0 500. Total Allocated LAE Fees Paid* 5,160 *Upon FEMA request, WYO Company must provide supporting detail for the reported expense. 6A COMPANY (NAME) Harwell 6B COMPANY (NUMBER) 11111 6C PERIOD ENDING MAY 20XX CURRENT FISCAL– MONTH YEAR-TO-DATE UNALLOCATED LAE PAID 6D 600. Net Paid Losses (Line 115) 168,900 168,900 6E (Line 325, Col. C) 20,000 60,000 6F 610. Case Incurred Losses 188,900 228,900 615. Unallocated ExpenseAllowance % x3.3% x3.3% 6G 620. Unallocated LAE 6,234 7,554 605. Change in Case Reserves SALVAGE, SUBROGATION, AND RECOVERY 6H 625. Net Salvage Received 100 100 630. Salvage Allowance % x10% x10% 6I 635. Salvage Credit 10 10 6J 640. Net Subrogation Received - 0 -- 0 - 645. Subrogation Allowance % x25% x25% 6K 650. Subrogation Credit - 0 -- 0 - 6L 652. Recovery of Losses Paid - 0 -- 0 - SPECIAL ALLOCATED LAE 6M 655. Special Allocated Loss Adjustment Expenses 50 50 6N 660. Total Other Loss & LAE Items (Sum of Lines 620, 635, 650, and 655) 6,294 7,614 7A COMPANY (NAME) Harwell 7B COMPANY (NUMBER) 11111 7C PERIOD ENDING MAY 20XX CURRENT FISCAL– MONTH YEAR-TO-DATE 7D 700. Total Interest Received - 0 -- 0 - 7E 705. Restricted Account Charges - 0 -- 0 - 7F 710. Total Interest Income - 0 -- 0 - 8A COMPANY (NAME) Harwell 8B COMPANY (NUMBER) 11111 8C PERIOD ENDING MAY 20XX 8D DATE 8D AMOUNT 8E 800. TOTAL 0 CASH PAYMENTS TO THE NFIP 8AA COMPANY (NAME) Harwell 8BB COMPANY (NUMBER) 11111 8CC PERIOD ENDING MAY 20XX 8DD DATE 8DD AMOUNT 5/7/20XX 25,000 5/14/20XX 30,000 5/21/20XX 25,000 5/28/20XX 41,306 8EE 805-B. TOTAL CASH PAYMENTS 121,306 8FF 805-C. TOTAL CREDIT CARD PAYMENTS 1,290 8GG 805-D. TOTAL INTERNET PAYMENTS 8HH 805-E. WIRE TRANSFER PAYMENTS 8II 805. TOTAL PAYMENTS TO THE NFIP 122,596 8AAA COMPANY (NAME) Harwell 8BBB COMPANY (NUMBER) 11111 8CCC PERIOD ENDING MAY 20XX 8DDD DATE 5/12/20XX 5/19/20XX 5/26/20XX 8EEE 805-C. TOTAL 8DDD AMOUNT 430 430 430 1,290 8AAA COMPANY (NAME) Harwell 8BBB COMPANY (NUMBER) 11111 8CCC PERIOD ENDING MAY 20XX 8DDD DATE 5/12/20XX 5/19/20XX 5/26/20XX 8EEE 805-D. TOTAL 8DDD AMOUNT 430 430 430 1,290 8AAA COMPANY (NAME) Harwell 8BBB COMPANY (NUMBER) 11111 8CCC PERIOD ENDING MAY 20XX 8DDD DATE 5/12/20XX 5/19/20XX 5/26/20XX 8EEE 805-E. TOTAL 8DDD AMOUNT 430 430 430 1,290 9A COMPANY (NAME) Harwell 9B COMPANY (NUMBER) 11111 9C PERIOD ENDING MAY 20XX RESTRICTED ACCOUNT DEPOSITS 9D DATE 5/3/20XX 5/4/20XX 5/5/20XX 5/6/20XX 5/7/20XX 5/10/20XX 5/11/20XX 5/12/20XX 5/13/20XX 5/14/20XX 5/17/20XX 5/18/20XX 5/19/20XX 5/20/20XX 5/21/20XX 5/23/20XX 5/24/20XX 5/25/20XX 5/26/20XX 5/27/20XX 9D AMOUNT 20,000 20,000 20,000 20,000 22,000 19,000 19,000 19,000 19,000 22,000 20,000 20,000 20,000 20,000 24,000 25,000 25,000 25,000 25,000 26,990 9E 900. TOTAL DEPOSITS FOR THE MONTH 430,990 1A COMPANY (Name) -Insert WYO Company name. 1B COMPANY (Number) - Insert WYO Company's 5-digit NAIC number. Contact your WYO Program Coordinator if you cannot identify your NAIC number. 1C PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). Month must be in all capital letters. REVENUE 1D Line 100 - Net Written Premium (Current Month): The total of booked premiums less premium refunds for the reporting month. This total should represent the calculated value of each premium transaction (not the actual cash collected). As previously stated, Harwell Company booked $400,000 of net written premium. This amount includes cancellation transactions of $1,200. Line 100 - Written Premium (Fiscal-Year-to-Date [FYTD]): Add total of current month to last month's FYTD total. Therefore, the FYTD total is: Current Month = $400,000 Previous FYTD = + 200,000 Current FYTD = $600,000 1E Line 105 - Change in Unearned Premium (Current Month): Increase or decrease in the account balance of unearned premiums from prior month to current month's end. A WYO Company uses its own unearned/earned premium calculation. In the example, Harwell should have a balance of ($533,333) in the account at the close of the reporting period. The change from prior month ($183,333) to current month balance ($533,333) is ($350,000). This entry is taken directly from Exhibit III, Line 320, Column C. Add current month change ($350,000) to previous FYTD figure ($183,333) and insert total ($533,333). To validate this figure, subtract Exhibit III, Line 320, Column A ($533,333) from Exhibit III, Line 320, Column D, $0. 1F Line 110 - Earned Premium (Current Month): Line 100, $400,000, minus Line 105 ($350,000), equals $50,000. Line 110 - Earned Premium (FYTD): Add current month's $50,000 to prior month's FYTD $16,667 and insert the total, $66,667. To validate this figure, foot Exhibit I, Line 100, FYTD Column, $600,000, and Exhibit I, Line 105, FYTD Column ($533,333). EXPENSES 1G Line 115 - Net Paid Losses (Current Month): This line represents claim payments made during the reporting period less salvage, subrogation, and recoveries of losses paid. In the example, net paid losses were developed as follows: Claim Payment No. 1 $33,000 Covered Loss - $2,000 Deductible Salvage Received ($100) Claim Payment No. 2 $70,000 Covered Loss - $1,000 Deductible Claim Payment No. 3 $70,000 Covered Loss - $1,000 Deductible Total Net Paid Losses = $31,000 Payment Less ($100) = $69,000 Payment = $69,000 Payment = $168,900 1H Line 120 - Allocated LAE (Current Month): To develop this figure, refer to Exhibits V-A, V-B, V-C, V-D, V-E, V-F, and V-G. The total figure shown on Exhibit V-G, Line 500 ($5,160) is carried forward to Exhibit I, Line 120, Current Month Column. 1I Line 125 - Other Loss and LAE Items (Current Month): Refer to Exhibit VI for development. The figure indicated on Exhibit VI, Line 660 ($6,294), Current Month Column is carried forward to Exhibit I, Line 125, Current Month Column. 1J Line 130 - Change in Loss and LAE Reserves (Current Month): Refer to Exhibit III for development. The sum of Lines 325/Column C ($20,000), 330/Column C ($60,000), 335/Column C ($400), 336/Column C ($600) and 340/Column C ($1,980) = ($82,980). Bring this figure with the reverse sign, $82,980, to Exhibit I, Line 130, Current Month Column. 1K Line 135 - Net Loss and LAE Incurred (Current Month): Sum of Line 115, $168,900; Line 120, $5,160; Line 125, $6,294; and Line 130, $82,980 = $263,334. 1L Line 140 - Expense Allowance (Current Month): Refer to Exhibit IV for development. The figure ($128,030) developed on Exhibit IV, Line 430, Current Month Column, is carried forward to Exhibit I, Line 140, Current Month Column. 1M Line 150 - Miscellaneous Expense (Current Month): This item (Breakage) represents the net underpayment or overpayment for premiums submitted within $6.00 of the system-calculated amount. This applies to new business applications, endorsements, or renewals. In instances where a premium amount is calculated by the WYO Company and a payment notice is submitted to the payer (e.g., premium renewal notice), no underpayment or overpayment is allowed. In the following example, four new business applications for the current month had a calculated value as follows: Policy Number 1 -$ 425 Policy Number 2 -$ 410 Policy Number 3 -$ 425 Policy Number 4 -$ 405 Total Calculated = $1,665 Policy Number 1 -$ 420 Policy Number 2 -$ 404 Policy Number 3 -$ 421 Policy Number 4 -$ 400 Total Payments = $ 1,645 Since there is a difference between calculated and collected payments of no more than $6.00 for each of these four policies, the total breakage is $20 (calculated [$1,665] - collected [$1,645]). The $20 breakage is shown as an expense on Line 150. If breakage was the opposite (calculated amount $1,645, collected amount $1,665), the total breakage amount would be shown on Line 150 as a credit ($20). On a monthly basis, the WYO Company should send supporting detail to reconcile to the total amount reported for miscellaneous expenses. 1N Line 155 - Total Expense (Current Month): Sum of Line 135, $263,334; Line 140, $128,030; and Line 150, $20 = $391,384. 1O Line 160 - Operating Income (Loss) (Current Month): Line 110, $50,000 less Line 155, $391,384 = ($341,384) (Loss). 1P Line 165 - Interest Income (Current Month): Refer to Exhibit VII for development. The entry on Line 710, $0, is carried forward to Exhibit I, Line 165. Harwell had no interest income. 1Q Line 170 - Net Federal Policy Fees (Current Month): Harwell received $30,000 in Federal Policy Fees with booked premium of $400,000. Therefore, the net Federal Policy Fees booked for the month was $30,000. 1R Line 175 - Net Income (Loss) (Current Month): Sum of Line 160, ($341,384); Line 165, $0; and Line 170, $30,000 = ($311,384) (Loss). 1S PREPARER'S NAME: Insert your name. 1T PHONE NUMBER: Indicate your phone number so that you can be contacted if any questions arise concerning your submission. 2A COMPANY (Name) -Insert WYO Company name. 2B COMPANY (Number) -Insert WYO Company's NAIC number. 2C PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). 2D Line 200 - Beginning Payable/Receivable Balance (Current Month): Refer to Exhibit III, Line 315, Column B. Reverse sign and insert entry ($282,313) on Line 200. Line 200 - Beginning Payable/Receivable Balance (FYTD): Refer to Exhibit III, Line 315, Column D. Insert this entry, $0, on Line 200. 2E Line 205 - Net Income (Loss) (Current Month): Insert net loss amount from Exhibit I, Line 175, Current Month ($311,384). Net income should be shown as a debit. Line 205 - Net Income (Loss) (FYTD): Add Current Month ($311,384) to Prior Month's figure ($136,633) = ($448,017). 2F Line 210 - LOC Funds Received (Current Month): Refer to Exhibit VIII-A, Line 800, and carry forward this entry, $0, to this line. This entry is always shown as a debit. Line 210 - LOC Funds Received (FYTD): Add Current Month, $0, to Prior Month's fiscal year-to-date balance, $0 = $0. 2G Line 215 - Disbursements to NFIP (Current Month): Refer to Exhibit VIII-B, Line 805, and carry forward this entry to this line. This entry is always shown as a credit ($122,596). Add Current Month ($122,596) to Prior Month's fiscal year-to-date balance ($145,680) = ($268,276). 2H Line 220 - Ending Payable/Receivable Balance (Current Month): Sum of Current Month Column Line 200, ($282,313), Line 205, ($311,384); Line 210, $0, and Line 215, ($122,596) = ($716,293). Line 220 - Ending Payable/Receivable Balance (FYTD): Sum of FYTD Column Line 200, $0; Line 205, ($448,017); Line 210, $0; and Line 215, ($268,276) = ($716,293). NOTE: Line 220 - Current Month ($716,293) and FYTD ($716,293) totals should always agree. 3A PERIOD ENDING - Indicate the financial statement reporting period(MONTH YEAR). As you will note, this exhibit is broken down into four columns for each line item. Column A (Current Month) represents the balance for each line item as of the end of the reporting period (MAY 20XX). Column B (Prior Month) represents the balance that was previously reported in Column A for the prior month. Column C (Increase/Decrease) is the difference between the current month's balance (Column A) and the prior month's balance (Column B). Column D (Beginning of Fiscal Year) should indicate the starting balances for the beginning of each new fiscal year. The fiscal year starts as of October 1, 20XX. Therefore, the balances shown in this column are really ending balances for the September reporting period. In our example, Column D contains all $0's because the Harwell Company was not writing and reporting as of September the previous year. The exhibit reflects this condition. Let us proceed now to the completion of Column A (Current Month) for each line entry. 3B Line 300 - Cash (Column A): Indicate the ending general ledger cash balance reflected for the reporting period (MAY 20XX) in the Flood Insurance Restricted Account. This balance is $25,000. The balance is derived in the following manner: Gross Premiums Collected* Federal Policy Fees Collected** Salvage Received Less Disbursements: Cancellation Refunds Paid Losses Allocated LAE Unallocated LAE Salvage Credit Special Allocated LAE Expense Allowance NFIP Excess Funds - Cash Payments Only*** Total Cash at End of Reporting Period *Excludes credit card charges of $1,200. **Excludes credit card charges of $90. ***Excludes credit card payments of $1,290. April/May Total $601,890 45,000 100 (1,200) (169,000) (5,160) (7,554) (10) (50) (172,030) (266,986) $ 25,000 3C Line 305 - Cash–Not Transferred to Restricted Account (Column A): This line represents any flood insurance funds received by Harwell Company but not placed into the restricted account because of a timing problem. In this case, all funds were deposited timely into the restricted account. Therefore, the entry is $0. If money were owed the restricted account, the entry would be a debit. Upon FEMA's request, the WYO Company must provide supporting detail concerning the reported balance. This detail should include policy number or payer name and amount. The details should also age balances under the following time frames: 0-30 days; 31-60 days; 61-90 days; 91-180 days; 181-360 days; and over 360 days. The WYO Company will be notified when such a request is made. 3D Line 310 - Cash–Not Transferred from Restricted Account (Column A): This line represents the total amount due from the restricted account to pay various charges, e.g., expense allowances, premium refunds, etc., to the WYO Company. In this case, $20,000 is payable from the account to Harwell Company because only $108,030 of the current month expense allowance earned by the company was drawn. This payable is shown as a credit ($20,000). Upon FEMA's request, the WYO Company must provide supporting aged detail concerning the reported balance. The detail should include payee name or policy number and amount payable. The details should also age balances under the following time frames: 0-30 days; 31-60 days; 61-90 days; 91-180 days; 181-360 days; and over 360 days. The WYO Company will be notified when such a request is made. 3E Line 315 - Payable to (Receivable from) NFIP (Column A): Insert figure from Exhibit II, Line 220, Fiscal Year-To-Date Column, but with the reverse sign. This figure is $716,293. 3F Line 320 - Unearned Premium Reserves (Column A): This entry represents the balance of the unearned premium at the end of the current month reporting period. Since this is a liability, it is shown as a credit ($533,333). 3G Line 325 - Loss Reserves (Case) (Column A): This entry represents the balance at the end of the reporting month for all outstanding claim case reserves. This liability is shown as a credit ($60,000). 3H Line 330 - Loss Reserves–Incurred But Not Reported (IBNR) (Column A): This balance represents the balance at the end of the reporting month for all outstanding losses incurred but not yet reported. This liability is shown as a credit ($120,000). 3I This balance represents an estimate of allocated LAE reserves for open reported claims only. This liability is shown as a credit ($700). 3J Line 336 - LAE Reserves–IBNR (Allocated) (Column A): This balance represents an estimate of allocated LAE reserves for incurred but not reported claims only. This liability is shown as a credit ($1,300). 3K Line 340 - LAE Reserves (Unallocated) (Column A): This account represents the LAE reserve for unallocated loss adjustment expenses. It is developed by taking the reported IBNR (Line 330 - Column A) and multiplying it by 3.3 percent. In this example, ($120,000) x 3.3% = ($3,960). This liability is shown as a credit ($3,960). 3L Line 345 - Premium Suspense (Under 60 Days Old) (Column A): This balance represents the total of cash deposited in the restricted account for a period of less than 60 days for policies that have not been posted. In this example, $2,000 ($1,000 [current month] + $1,000 [prior month]) was deposited for policies not posted as written premium. This liability is shown as a credit ($2,000). 3M Line 346 - Premium Suspense (60 Days and Older) (Column A): This balance represents the total of cash deposited in the restricted account for a period of 60 days or more for policies that have not posted as written premium. All entries under Column B (Prior Month) were the previous month's (April 20XX) ending balances. Simply go to last month's Exhibit III and insert the Column A entries onto this month's Exhibit under Column B. Column C entries are the differences between Column A (current month) and Column B (prior month). NOTE: You have now completed Exhibit III. All entries for Columns A, B, C, and D should total to $0. If not, recheck your entries and make corrections as necessary. 4A COMPANY (Name) -Insert WYO Company name. 4B COMPANY (Number) -Insert WYO Company's NAIC number. 4C PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). 4D Line 400 - Net Written Premium (Current Month): Insert figure from Exhibit I, Line 100, Current Month. This figure is $400,000. 4E Line 405 - Expense Allowance % (Current Month): Insert the expense allowance 31.2 percent (percent selected for illustrative purposes only). This percentage will vary for each fiscal year. 4F Line 410 - Expense Allowance for Written Premium (Current Month): Line 400, $400,000 x Line 405, 31.2% = $124,800. 4F1 Line 411-This line item reserved for future use. 4F2 Line 412-This line item reserved for future use. 4F3 Line 413-This line item reserved for future use. 4F4 Line 414-Subtotal Expense Allowance Total of Line 410. 4G Line 415 - Cancellation Premium Refund Adjustment Base (Current Month): The Harwell Company may retain 15 percent of premium refunded (exclusive of the Federal Policy Fee) on policies canceled for the cancellation reasons 9 and 20. For more information, please reference the NFIP Transaction Record Reporting and Processing (TRRP) Plan, Revision 4, Change 5, October 1, 2003, Page 4-39, Case V. In this example, the Harwell Company had a policy in the current reporting month canceled because insurance is no longer required by the lender because the property is no longer located in a Special Flood Hazard Area. The premium refund adjustment total of $200 is the entry to be made on line 415. Line 415, $200 x Line 420, 15% = $30. 4I Line 426 - Expense Allowance Adjustment For Bonus Commission: Line 426 is used to record the annual adjustment to a WYO Company's expense allowance based upon achieving policy or contract-in-force goals. The adjustment can result in a WYO Company earning additional expense allowance. The calculation of the expense allowance adjustment will be performed by the NFIP Bureau and Statistical Agent, and the WYO Company will be notified of the additional expense allowance amount earned. The policy or contract-in-force goals and the formula used in calculating the expense allowance adjustment will be determined by FEMA. FEM will notify WYO Companies of their goals and the procedures used in calculating their expense allowance adjustment. Line 426 is also used as necessary to record the Expense Allowance Adjustment from Cancellation Reason Code 24. Cancellation Reason Code 24 was established to cancel/rewrite when converting a standard rated policy to a Preferred Risk Policy (PRP) as a result of a map revision, Letter of Map Amendment (LOMA), or Letter of Map Revision (LOMR). The expense allowance is retained by the WYO Company on both the standard policy being canceled and the PRP being written. For purposes of this Manual, assume that Harwell had a very successful year and achieved its policy or contract-in-force goals. In this case, Harwell will receive written notification from the NFIP Bureau disclosing the additional expense allowance amount earned and how it was computed. The notification will also provide instructions for how to take the additional earned expense allowance and for reporting the amount on Harwell's monthly financial statement. Since Harwell earned additional expense allowance, it can withdraw the additional expense allowance amount from the flood restricted account. If the account holds insufficient funds, Harwell may request LOC funds in the exact amount of the additional expense allowance earned. To report this transaction, Harwell will insert the amount of the additional expense allowance taken as a debit on Line 426, financial statement Exhibit IV (Expense Allowance Calculation). 4J Line 427 - Rating Organization Expense (Current Month): This line is to be completed whenever a WYO Company, with the prior written approval of FEMA, uses the services of a national rating organization. The rating organization must be licensed under state law. Its services must assist FEMA in performing studies and investigations on a community or individual risk basis to determine more equitable and accurate estimates of flood insurance risk premium rates. Harwell used the services of a national rating organization and incurred an expense of $3000, indicated on Line 427 for the rating organization services. The WYO Company may disburse funds directly from the restricted account. A WYO Company should then attach a copy of the paid bill to its monthly financial statements. 4K Line 428 - State Sales Tax on Insurance Services (Current Month): Background The Texas tax authorities have determined that the Texas sales tax on insurance services is applicable to all fees paid by WYO Companies to claim adjusters and/or adjusting firms for handling Texas NFIP claims. Because of this determination, the NFIP allotted the cost of the Texas adjuster services sales tax to Texas flood insurance policyholders. This was done by assessing an additional $5 charge to new business policies (effective 1/1/93) and renewal policies (effective 3/1/93). In addition, FEMA has determined it will reimburse dollar-for-dollar the expense incurred by a WYO Company that pays the Texas sales tax for adjuster services provided to Texas policyholders. Your WYO Company may take the reimbursement for the tax expense after the tax has been paid to the adjuster and/or adjusting firm. Procedure In order to be reimbursed for the Texas sales tax, a WYO Company must make the payment to the adjuster and then submit supporting documentation. Reimbursement procedure guidelines are as follows: 1. Indicate the total amount of Texas sales charges paid for the reporting month on financial statement Exhibit IV (Expense Allowance Calculation), Line 428. Please note, this entry should not include your WYO Company's allocated loss adjustment fee for the adjustment of claims cases. This expense must be indicated on the applicable Allocated LAE Fee Schedules. 2. Include with your financial statement package a listing that details the Texas sales tax paid for adjuster services on each payment made. The total of the individual tax payments on this listing should agree with total amount recorded on Exhibit IV, Line 428. The listing should contain the following information: the policy number (not claim number) associated with the paid adjuster expense; date of loss; name of adjuster and/or adjusting firm paid; date of the adjuster payment; total amount of payment to the adjuster (inclusive of the sales tax); and amount of Texas sales tax paid. 3. Maintain in your WYO Company's records all supporting documentation concerning the payment of the Texas sales tax. Harwell paid various adjusters and/or adjuster firms a total of $500 Texassales tax, indicated on Exhibit IV, Line 428. In this case, Harwell would include the payment of the tax ($500) as part of its expense allowance due forthe reporting month. In addition, Harwell must attach to its financial statement a listing indicatingthe specifics of the various payments as outlined in the aforementionedprocedure. 4L Line 429 - Prior Term Refund Expense Allowance Due To The NFIP: Line 429 is used to record the return of the expense allowance from the WYOCompany to the NFIP based on the refund amount and the expenseallowance in effect when the refund is processed. Effective October 1, 2003, changes were made regarding the NFIP's current refund and cancellation rules, in response to the WYO Companies' requests. These changes indicate that eligible Prior Term Refunds older than 2 years will be processed by the NFIP Bureau and Statistical Agent. To adhere to this procedure, please continue to follow the existing NFIP Underwriting procedures in the Flood Insurance Manual’s cancellation and endorsement sections when submitting your request for Prior Term Refunds. FEMA bills and notifies the WYO Company via the Prior Term Refund Expense Report (shown on the next page). This expense report is provided to the WYO Company on a monthly basis subsequent to the issuance of the prior term refund check to the insured. Upon receipt of the Prior Term Refund billing information, the WYO Company should reflect the return of the expense allowance to the NFIP Bureau by showing the amount as a credit on Exhibit IV, Line 429, and a debit on Exhibit VIII-B. The expense allowance adjustment should be made within 30 days of receipt of the Prior Term Refund billing information. When making the expense allowance adjustment, please send a copy of the Prior Term Refund billing information with your monthly financial statement package for proper tracking. PRIOR TERM REFUND EXPENSE REPORT WYO COMPANY POLICY NUMBER INSURED NAME Policy Term Original Premium New Premium Refund Amount Due Insured Expense Allowance Rate Applied Expense Allowance Adjustment Due NFIP 4M Line 430 - Total Expense Allowance (Current Month): Sum of Line 414, $124,800; Line 425, $30; Line 426, $0; Line 427, $3,000; Line 428, $500; and Line 429, ($300); = $128,030. Insert this figure, $128,030, on Exhibit I, Line 140, Current Month column. FEE SCHEDULES – ALLOCATED LAE NOTE: There are seven allocated Loss Adjustment Expense (LAE) financial statement fee schedules. Knowledge of the claim loss date is required for use of the proper fee schedule. Once the claim loss date is known, simply apply the following guide to determine what financial statement fee schedule you should use to report the allocated LAE on your financial statement: DATE OF LOSS 9/30/90 and prior 10/1/90 through 10/31/96 11/1/96 through 04/30/97 5/1/97 and later 6/1/97 and later 9/1/04 and later 09/01/04 and later FEE SCHEDULE EXHIBIT V-A EXHIBIT V-B EXHIBIT V-C EXHIBIT V-D EXHIBIT V-E Use only for Increased Cost of Compliance (ICC) claim expenses Exhibit V-F Exhibit V-G Use only for Increased Cost of Compliance (ICC) claim expenses FEE SCHEDULE PRINCIPLES • The allocated LAE fee can be taken at the time a final claim payment is made. The allocated LAE fee can also be taken at the time a partial claim payment is made. • Fees are not paid separately for building and contents losses. Rather, the sum of building and contents covered or gross losses is the basis for the fee. • The major task in using the various fee schedules is to determine the entry value for each claim. The entry value may be based on either the covered loss or the gross loss. In addition, the entry value will not, in all cases, equal the claim payment. • For fee schedule entry value calculations, based on covered loss, the standard deductible is subtracted from the covered loss amount, rather than the actual deductible amount shown on the policy. Covered loss is limited to the amount of insurance purchased. • Fee schedule entry value calculations based on gross loss pertain to all claims witha date of loss from 5/15/96 to 7/10/96, and all claims with a date of loss from 5/1/97and later. For these claims, all entry value calculations should be based on the grossloss. • Exhibit V-E is to be used to record and to report only LAE related to ICC claims witha loss date before 9/1/04. • Exhibit V-F is to be used to record and to report LAE related to claims with aloss date of 9/1/04 and later. • Exhibit V-G is to be used to record and to report only LAE related to ICC claims witha loss date of 9/1/04 and later. FEE SCHEDULE BACKGROUND On May 15, 1996, an interim final rule was issued concerning the NFIP Adjuster Fee Schedule. This rule did two things. First, it raised the fee amounts for entry values greater than $50,000. (The ranges and the fee amounts lower than $50,000 remained the same.) Second, it changed the basis of the fee schedule entry value from the "covered loss less the standard deductibles" to the "gross loss." On July 11, 1996, an amendment to the interim final rule was issued. The amended rule was effective for all losses dated 7/11/96 and later. This major revision calculated the LAE based on the "covered loss less standard deductibles." The prior rule, effective for cases with a date of loss of 5/15/96 through 7/10/96, based the calculation on "gross loss." On September 30, 1996, it was announced that another fee schedule would be in effect for all claims with loss dates of 5/1/97 and later. This fee schedule contained two major revisions. First, it revised the fees paid for certain entry value ranges. Second, it calculated the LAE based on the "gross loss." The prior rule, effective for cases with a date of loss of 7/11/96 through 4/30/97, stated that the calculation be based on "covered loss less standard deductibles." The announcement of these current and future fee schedule changes necessitated issuance of revised financial and statistical reporting procedures. These revised procedures are based on the claim loss date, and are as follows: • CLAIMS WITH LOSS DATE OF 9/30/90 AND PRIOR All fee schedule entry value calculations should be based on covered loss, not gross loss, less standard deductibles, if applicable, for building ($500) and contents ($500). Covered loss is limited to the amount of insurance purchased. The financial statement Exhibit V-A Fee Schedule should be used to report the appropriate allocated loss adjustment expense. Please refer to Example A. • CLAIMS WITH LOSS DATE OF 10/1/90 THROUGH 5/14/96 All fee schedule entry value calculations should be based on covered loss, not gross loss, less standard deductibles, if applicable, for building ($500) and contents ($500). Covered loss is limited to the amount of insurance purchased. The financial statement Exhibit V-B Fee Schedule should be used to report the appropriate allocated loss adjustment expense. Please refer to Example B. • CLAIMS WITH LOSS DATE OF 5/15/96 THROUGH 7/10/96 All entry value calculations should be based on the gross loss as described in the "footnotes" to the fee schedule in the May 1996 rule. (Please refer to the previously listed "footnotes.") If the loss exceeds the available coverage, gross loss will mean the total amount of coverage. For all claims, calculate the fee amount based on the financial statement Exhibit V-C Fee Schedule. The amount of fee in excess of the financial statement Exhibit V-B Fee Schedule (Basic LAE Fee) is to be processed as a Special Allocated Loss Adjustment Expense (SALAE) - Type 2. Prior FEMA approval (authorization letter) is not necessary. The excess fee amount, if any, should be reported as SALAE on Line 655 of financial statement Exhibit VI. In addition, please include the Gross Loss Amount on your required SALAE listing. For statistical reporting, the SALAE transaction code (71) should be used. The basic fee (amount per Exhibit V-B Fee Schedule) is to be reported on the financial statement Exhibit V-B. Please refer to Example C. • CLAIMS WITH LOSS DATE OF 7/11/96 THROUGH 10/31/96 All fee schedule entry value calculations should be based on covered loss, not gross loss, less standard deductibles, if applicable, for building ($500) and contents ($500). Covered loss is limited to the amount of insurance purchased. For all claims with a fee range value of $50,000.01 and above, calculate the fee amount based on the financial statement Exhibit V-C Fee Schedule. The amount of fee in excess of the financial statement Exhibit V-B Fee Schedule (Basic LAE Fee) is to be processed as a Special Allocated Loss Adjustment Expense (SALAE) - Type 2. Prior FEMA approval (authorization letter) is not necessary. The excess fee amount should be reported as SALAE on Line 655 of financial statement Exhibit VI. For statistical reporting, the SALAE transaction code (71) should be used. The basic fee (amount per Exhibit V-B Fee Schedule) is to be reported on the financial statement Exhibit V-B. Please refer to Example D. For all claims with a fee range value of $50,000 and below, calculate the fee based on the financial statement Exhibit V-C Fee Schedule. Then, use financial statement Exhibit V-B Fee Schedule to report the appropriate allocated loss adjustment expense. • CLAIMS WITH LOSS DATE BETWEEN 11/1/96 AND 4/30/97 All fee schedule entry value calculations should be based on covered loss, not gross loss, less standard deductibles, if applicable, for building ($500) and contents ($500). Covered loss is limited to the amount of insurance purchased. For all claims, calculate the fee amount based on the financial statement Exhibit V-C Fee Schedule. Then, use financial statement Exhibit V-C Fee Schedule to report the appropriate allocated loss adjustment expense. Please refer to Example E. NOTE: The Exhibit V-C Fee Schedule-Allocated LAE incorporates the revised fee amounts for the entry value ranges of $50,000.01 and above, and it eliminates the need to process the excess fee above the basic fee schedule as a SALAE. In addition, remember Exhibit V-C should be used only to report adjuster fees for claims with a loss date between 11/1/96 and 4/30/97. All fees for loss dates prior to 11/1/96 should be reported on financial statement Exhibits V-A or V-B. All fees for loss dates of 5/1/97 and later should be reported on financial statement Exhibit V-D. • CLAIMS WITH LOSS DATE OF 5/1/97 TO 8/31/04. All entry value calculations should be based on the gross loss as described in the "footnotes" to the fee schedule in the May 1996 rule. If the loss exceeds the available coverage, gross loss will mean the total amount of coverage. For all claims, calculate the fee amount based on the financial statement Exhibit V-D Fee Schedule. Then, use financial statement Exhibit V-D Fee Schedule to report the appropriate allocated loss adjustment expense. Please refer to Example F. • INCREASED COST OF COMPLIANCE (ICC) CLAIMS WITH A LOSS DATE OF 6/1/97 TO 8/31/04. All entry value calculations should be based on the ICC loss. The maximum loss limit is $15,000 up to loss date of 4/3/00. The maximum loss limit was increased to $20,000 with loss date of 5/1/00 to 4/30/03. The maximum loss limit was increased to $30,000 with loss date of 5/1/03 to 8/31/04. For ICC claims only, calculate the fee amount based on the financial statement Exhibit V-E Fee Schedule. Then, use financial statement Exhibit V-E Fee Schedule to report the appropriate allocated loss adjustment expense. Please refer to Example G. Now, let us begin to complete the appropriate fee schedules following the above rules. Please note that the Harwell Insurance Company incorporated only Examples B, E, and F into its financial statements for the reporting period of May 20XX. EXAMPLE A EXHIBIT V-A FEE SCHEDULE – ALLOCATED LAE NOTE: Remember to use Exhibit V-A Fee Schedule for only those claims with loss dates of 9/30/90 and prior. In this example, a contents claim of $6,000 was reported. The date of loss was 5/9/90. The insured's contents coverage is for $10,000 with a deductible of $1,000. The claim was approved and a final claim payment to the insured of $5,000 was made (covered loss of $6,000 minus the policy deductible of $1,000). Complete the Exhibit V-A Fee Schedule as follows: COMPANY (Name) -Insert WYO Company name. COMPANY (Number) -Insert WYO Company's NAIC number. PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). Line 500-A - Total Allocated LAE Fees Paid - Exhibit V-A: To determine the entry value on the Exhibit V-A Fee Schedule, take the covered loss of $6,000 and subtract the standard deductible of $500. This equals $5,500 and represents the entry value. Now go to the Fee Schedule Exhibit V-A and under Column A (Entry Value Range), find the range of "$5000.01 - $6,000.00." On this line, insert "1" under Column B. Complete Column D (Fees Paid) by multiplying Column B (1) with Column C (Fee = $350.00). The fee for this claim is $350. Total Column D and insert the amount of $350 on Line 500-A. Next, bring this number forward to Exhibit V-D, Line 500-A. NOTE: At FEMA's request, a WYO Company must provide supporting details for its fiscal year-to-date allocated loss adjustment expenses. The detail should include the policy number impacted by the claim, date of loss, total claim payments, and the total allocated loss adjustment expense. EXAMPLE B EXHIBIT V-B FEE SCHEDULE – ALLOCATED LAE NOTE: Remember to use Exhibit V-B Fee Schedule to report only those claims with loss dates of 10/1/90 through 10/31/96. In this example, a building loss of $28,000 and a contents claim loss of $5,000 were reported. The date of loss was 5/7/96. The insured's coverage is for $50,000 building and $10,000 contents. The insured also has a $1,000 deductible for each building and contents. The claim was approved and a final claim payment was made to the insured in the amount of $31,000 (building covered loss $28,000 minus policy deductible of $1,000 = $27,000; contents covered loss $5,000 minus the policy deductible of $1,000 = $4,000). Complete the Exhibit V-B Fee Schedule as follows: 5A PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). 5B Line 500-B -Total Allocated LAE Fees Paid - Exhibit V-B: To determine the entry value on the Exhibit V-B Fee Schedule, determine the date of loss and apply the appropriate rule: • If the date of loss is not between the period of 5/15/96 to 7/10/96, the entry value for the fee schedule will be based on the covered loss. • If the date of loss is between the period of 05/15/96 to 7/10/96, the entry value for the fee schedule will be based on the gross loss. Because the date of loss in this example is not between 5/15/96 to 7/10/96, the entry value for the fee schedule will be based on the covered loss. The next step in the fee schedule entry calculation is to take the covered loss for the building of $28,000 and subtract the standard deductible of $500, which equals $27,500. Now take the covered loss for contents of $5,000 and subtract the standard deductible of $500, which equals $4,500. Add the building and content figures for a total of $32,000. This amount represents the entry value for use on the Exhibit V-B Fee Schedule. Using Exhibit V-B Fee Schedule, under Column A (Entry Value Range), find the range of $25,000.01 - $35,000.00. On this line, insert "1" under Column B. Complete Column D (Fees Paid) by multiplying Column B (1) with Column C (Fee = $675). The fee for this claim is $675. Total all amounts under Column D. The total should be $675. Insert $675 on Line 500-B. 5C Next, bring this number forward to Exhibit V-D, Line 500-B. NOTE: At FEMA's request, a WYO Company must provide supporting details for its fiscal year-to-date allocated loss adjustment expenses. The detail should include: the policy number impacted by the claim, date of loss, total claim payments, and the total allocated loss adjustment expense. EXHIBIT V-B FEE SCHEDULE – ALLOCATED LAE NOTE: Remember to use Exhibit V-B Fee Schedule to report only those claims with loss dates of 10/1/90 through 10/31/96. In this example, a building claim of $70,000 based on covered loss was reported. The gross loss of the reported claim was $80,000. The date of loss was 07/04/96. The insured's building coverage is $100,000 with a deductible of $1,000. The claim was approved and a final claim payment of $69,000 was made to the insured (covered loss of $70,000, minus the policy deductible of $1,000). Complete the Exhibit V-B Fee Schedule as follows: PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). Line 500-B -Total Allocated LAE Fees Paid - Exhibit V-B: To determine the entry value on the Exhibit V-B Fee Schedule, determine the date of loss and apply the appropriate rule: • If the date of loss is not between the period of 5/15/96 to 7/10/96, the entry value for the fee schedule will be based on the covered loss. • If the date of loss is between the period of 5/15/96 to 7/10/96, the entry value for the fee schedule will be based on the gross loss. Because the date of loss was 7/4/96, the fee schedule entry value calculation will be based on the gross loss, not on the covered loss. Therefore, the entry value fee is $80,000, the gross loss. Now, go to the Exhibit V-C Fee Schedule and find the range of $50,000.01 - $100,000.00. Next, compute the loss adjustment fee by multiplying 3.0 percent times the gross loss ($80,000). The LAE fee is $2,400. Use financial statement Exhibit V-B Fee Schedule to record the basic fee. Do this by finding the line with the entry value of $80,000, with a corresponding fee of $1,000. Insert "1" under Column B. Complete Column D (Fees Paid) by multiplying Column B (1) with Column C (Fee = $1,000). The basic fee for this claim is $1,000. Next, bring this number forward to Exhibit V-D, Line 500-B. Because the total fee earned in this case is $2,400 and the basic fee reported by you is $1,000, the excess fee amount due your company is $1,400 ($2,400 - 1,000= 1,400). Procedures require that the $1,400 be reported as SALAE- Type 2. Do this by reporting the $1,400 on Line 655 of the financial statement Exhibit VI. Follow the SALAE reporting procedures and attach a listing, detailing the SALAE by policy number, date of loss, SALAE amount, and type code to your financial statements. Also, include on the listing the gross loss amount. Final points to remember are (1) this SALAE-Type 2 does not require prior FEMA approval (authorization letter), and (2) for statistical reporting, the SALAE transaction code (71) should be used. EXHIBIT V-B FEE SCHEDULE – ALLOCATED LAE NOTE: Remember to use Exhibit V-B Fee Schedule to report only those claims with loss dates of 10/1/90 through 10/31/96. This case represents the same facts as shown in Example C, except for the date of loss. You can contrast the difference in the entry value fee schedule amount based on either covered loss or gross loss and their respective financial statement reporting requirements. A building claim of $70,000 based on covered loss was reported. The gross loss of the reported claim loss was $80,000. The date of loss was 9/17/96. The insured's building coverage is $100,000 with a deductible of $1,000. The claim was approved and a final claim payment to the insured of $69,000 was made (covered loss of $70,000 minus the policy deductible of $1,000). Complete the Exhibit V-B Fee Schedule as follows: PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). Line 500-B -Total Allocated LAE Fees Paid - Exhibit V-B: Since the date of loss was 9/17/96, the Exhibit V-B Fee Schedule will be used and the fee schedule entry value calculation will be based on the covered loss, not the gross loss. To determine the loss adjustment entry fee value, take the covered loss of $70,000 and subtract the standard deductible of $500, which represents the entry value of $69,500. Now go to the Exhibit V-C Fee Schedule and find the line with the entry value range of "$50,000.01- $100,000.00." Next, compute the loss adjustment fee by multiplying 3.0 percent times $69,500 for a total of $2,085. Use financial statement Exhibit V-B Fee Schedule to record the basic fee. Do this by finding the line showing the range of "$50,000.01 - $100,000.00" and the corresponding fee of $1,000. Insert "1" under Column B. Complete Column D (Fees Paid) by multiplying Column B (1) with Column C (Fee = $1,000). The basic fee for this claim is $1,000. Next, bring this number forward to Exhibit V-D, Line 500-B. Because the total fee earned in this case is $2,085 and the basic fee reported by you is $1,000, the excess fee amount due your company is $2,085 ($2,085- $1,000=$1,085). Procedures require the $1,085 to be reported as SALAE- Type 2. Do this by reporting the $1,085 on Line 655 of financial statement Exhibit VI. Be sure to attach a listing, detailing this SALAE by policy number, date of loss, SALAE amount, and type code, to your financial statements. Because gross loss was not used as the basis for fee schedule entry value, the SALAE listing does not have to include the "gross loss amount." Final points to be noted are (1) because this is SALAE-Type 2, no prior FEMA approval (authorization letter) is necessary, and (2) for statistical reporting, the SALAE transaction code (71) should be used. EXHIBIT V-C FEE SCHEDULE – ALLOCATED LAE NOTE: Remember to use this Fee Schedule to report only those claims with loss dates between 11/1/96 and 4/30/97. This example represents the same facts as shown in Example D, except for the date of loss. You can contrast the difference in the financial statement reporting requirements even though the allocated loss adjustment expense is the same amount as in Example D. A building claim of $70,000 based on covered loss was reported. The gross loss of the reported claim was $80,000. The date of loss was 12/7/96. The insured's building coverage is $100,000 with a deductible of $1,000. The claim was approved and a final claim payment of $69,000 was made to the insured (covered loss of $70,000 minus the policy deductible of $1,000). Complete the Exhibit V-C Fee Schedule as follows: 5D PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). 5E Line 500-C -Total Allocated LAE Fees Paid - Exhibit V-C: Because the date of loss was 12/7/96, the Exhibit V-C Fee Schedule will be used and the fee schedule entry value calculation will be based on the covered loss, not the gross loss. To determine the loss adjustment entry fee value, take the covered loss of $70,000 and subtract the standard deductible of $500 for a total of $69,500, which represents the entry value. Go to Exhibit V-C Fee Schedule and find the line showing the range of $50,000.01 - $100,000.00. Enter the value of $69,500 on this line. Next, compute the loss adjustment fee by multiplying 3.0 percent times $69,500 for a total of $2,085. To report this fee, insert "1" under Column B in "$50,000.01 - $100,000.00" entry value range and insert under Column D the fee amount of $2,085. 5F Next, bring this amount ($2,085) forward to Exhibit V-D, Line 500-C. NOTE: Example E does not require SALAE processing and a SALAE statistical transaction need not be sent. EXHIBIT V-D FEE SCHEDULE – ALLOCATED LAE NOTE: Remember to use Exhibit V-D Fee Schedule to report only those claims with loss dates 5/1/97 to 8/31/04. This example represents the same facts as shown in Example D, except for the date of loss. You can contrast the difference in the entry value fee schedule amount based on either covered loss or gross loss. A building claim of $70,000 based on covered loss was reported. The gross loss of the reported claim was $80,000. The date of loss was 5/7/97. The insured's building coverage is $100,000 with a deductible of $1,000. The claim was approved with a final claim payment of $69,000 made to the insured (covered loss of $70,000 minus the policy deductible of $1,000). Complete the Exhibit V-D Fee Schedule as follows: 5G PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). 5H Line 500-D -Total Allocated LAE Fees Paid Because the date of loss was 5/7/97, the Exhibit V-D Fee Schedule is used, and the fee schedule entry value calculation is based on the gross loss, not the covered loss. Therefore, the entry fee value is $80,000. Go to the Exhibit V-D Fee Schedule and find the line with the range of $50,000.01 - $100,000.00. Next, compute the loss adjustment fee by multiplying 3.0 percent times $80,000. The LAE is $2,400. To report this fee, insert "1" under Column B in the "$50,000.01 - $100,000.00" entry value range and insert under Column D, the fee amount of $2,400. On the Fee Schedule, under Column D, total all the amounts. The sum amount is $2,400. Insert this amount on Line 500-D. 5I Next, sum the totals on Lines 500-D ($2,400), 500-C ($2,085), 500-B ($675), 500-A ($0), and 500-E ($0). The total is $5,160. After completion, bring this total ($5,160) forward to Exhibit I (Income Statement) Line 120 (Allocated LAE). NOTE: Example F does not require SALAE processing and a SALAE statistical transaction need not be sent. EXHIBIT V-E FEE SCHEDULE – ALLOCATED LAE NOTE: Remember to use Exhibit V-E Fee Schedule to report only Increased Cost of Compliance (ICC) claims with loss dates 6/1/97 to 8/31/04. When utilizing the ICC Fee Schedule, please remember that the limit of liability for an ICC claim is $15,000 before 5/1/00. Therefore, the maximum allocated LAE is $600. Now we will proceed to an example. An ICC loss of $27,000 with a loss date of 8/11/97 has been developed. Since the limit of ICC liability is $15,000 and since no deductible or depreciation is applicable, a payment of $15,000 was made. Complete the Exhibit V-E Fee Schedule as follows: PERIOD ENDING -Indicate the financial statement reporting period (MONTH YEAR). Line 500-E -Total Allocated LAE Fees Paid Because this was an ICC payment and the date of loss was 8/11/97, the Exhibit V-E Fee Schedule is used. The fee schedule entry value calculation is based on the ICC claim payment amount. Therefore, the entry fee value is $15,000. Now go to the Exhibit V-E Fee Schedule and find the line with the range of $10,000.01- 15,000.00. On that line, insert "1" under Column B. Next complete Column D (Fees Paid) by multiplying Column B (1) with Column C (Fee = $600.00). The fee for this ICC claim is $600. Total Column D and enter the amount of $600 on Line 500-E. Next, bring the number to Exhibit V-D, Line 500-E. NOW, LET US CONTINUE TO THE COMPLETION OF EXHIBIT VI - OTHER LOSS AND LAE CALCULATION. 6A COMPANY (Name) -Insert WYO Company name. 6B COMPANY (Number) -Insert WYO Company's NAIC number. 6C PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). UNALLOCATED LAE PAID 6D Line 600 - Net Paid Losses (Current Month): Go to Exhibit I, Line 115, Current Month Column, and insert that figure, $168,900, on Line 600. 6E Line 605 - Change in Case Reserves (Current Month): Go to Exhibit III, Line 325, Column C, and insert that figure, $20,000, with the reverse sign on Line 605. 6F Line 610 - Case Incurred Losses (Current Month): Add Line 600, $168,900, and Line 605, $20,000, and insert the total, $188,900, on Line 610. 6G Line 620 - Unallocated LAE (Current Month): For unallocated LAE, multiply Line 610, $188,900, by Line 615, 3.3%. Insert the total, $6,234, on Line 620. 6H Line 625 - Net Salvage Received (Current Month): This line represents the salvage collected, net of expenses. In the example, Harwell received $100 net of salvage costs for an item sold toa salvage company as a result of the contents claim settled in May. This net salvage received is recorded on Line 625. NOTE: The salvage amount of $100 has also been credited to the totallosses paid, $169,000, to give a $168,900 (Lines 115 and 600) figure for net losses paid. 6I Line 635 - Salvage Credit (Current Month): Multiply Line 625, $l00, by Line 630, 10 percent. Insert this figure, $10, onLine 635 as your Company's salvage credit for the reporting month. As noted, Harwell has earned 10 percent of all salvage funds collected. 6J Line 640 - Net Subrogation Received (Current Month): This line represents the subrogation amount collected, net of expenses. For the Harwell Company, no subrogation was collected. Therefore, Line 640 should indicate $0. 6K Line 650 - Subrogation Credit (Current Month): Multiply Line 640, $0, by Line 645, 25 percent. Insert this figure, $0, on Line650 as your Company's subrogation credit for the reporting month. As noted, a company earns 25 percent of any subrogation amount collected. 6L Line 652 - Recovery of Losses Paid (Current Month): This line is used to record the amount of recovery funds returned to therestricted account by Harwell for its erroneous payment of claim losses. Harwell booked no recoveries for erroneous claim payments. 6M Line 655 - Special Allocated Loss Adjustment Expenses (SALAE) (Current Month): This line represents adjustment expenses authorized by FEMA for reimbursement, exclusive of expenses based on the Fee Schedules. SALAEs are of the following types: • Expense Type 1 - Engineering Expense - WYO Company is authorized to approve up to $2,500 per claim without FEMA's approval. • Expense Type 2 - Adjuster Expense (in excess of the applicable Fee Schedule) - WYO Company is authorized to approve up to $500 per claim without FEMA's approval. • Expense Type 3 - Litigation Expenses - WYO Company is authorized to approve up to $5,000 per claim without FEMA's approval. • Expense Type 4 - Cost of Appraisal (implementation of the Standard Flood Insurance Policy’s appraisal clause) - WYO Company is authorized to approve up to $2,500 per claim without FEMA's approval. When approved, the SALAE can be drawn from the Flood Insurance Restricted Account. When a SALAE is incurred, it must be reported on the monthly financial statement, Exhibit VI, Line 655. In addition, the WYO Company representative must attach to its monthly financial statement a listing of all SALAEs taken in the reporting period. The listing should contain the following information: policy number, date of loss, SALAE amount, SALAE type code, and gross loss amount (when appropriate). The WYO Company representative must attach a copy of the FEMA approval letter for SALAEs that required approval. It should be noted that the SALAE statistical transaction and the appropriate monthly financial/statistical reconciliation form are also required from the WYO Company. In Harwell's case, a $50 expense for an appraisal was incurred for the adjustment of its claim case #2. Since the expense was a type 4 and below $2,500, no prior FEMA approval was required for expense reimbursement. This expense of $50 is shown on Line 655. 6N Line 660 - Total Other Loss and LAE Items (Current Month): The sum of Line 620, $6,234; Line 635, $10; Line 650, $0; and Line 655, $50 = $6,294. Enter this figure on Line 660 and on Exhibit I, Line 125, Current Month Column. 7A COMPANY (Name) -Insert WYO Company name. 7B COMPANY (Number) -Insert WYO Company's NAIC number. 7C PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). 7D Line 700 - Total Interest Received (Current Month): This line represents the interest, if any, that has been earned from NFIP funds deposited into the restricted flood account, or flood funds invested, or any other account(s). Any interest earned on NFIP processing accounts, restricted accounts, satellite accounts, lockboxes, or other accounts must be paid to the NFIP. These funds and their associated interest are flood insurance-related money. For Harwell, no interest was received. The entry on Line 700 is $0. 7E Line 705 - Restricted Account Charges (Current Month): This line is used to record charges, if any, for the utilization of the ACH, wire transfers, credit cards, internet charges, or other charges related to the restricted flood account that are levied by the bank. These reported charges must be offset by any interest earned. Funds exceeding $100,000 must be remitted by wire transfer. This method may require WYO Companies to transfer excess funds more frequently than once a week. It is FEMA’s understanding that wire transfers may be assessed an additional cost by your banking institution. Please negotiate with your banking institution to obtain the best possible per-transaction cost. For credit card processing, FEMA will absorb all bank service charges when using FEMA’s provider. The WYO Company will not be reimbursed by FEMA when using alternative credit card services other than FEMA’s provider. All other charges for hardware and software will be borne by the WYO Company. See Part H, Credit Card Processing, for additional information. These reported charges must be offset by any account earning credits. On a monthly basis, the WYO Company should send supporting detail to reconcile to the total amount reported for restricted account charges. For Harwell, there were no bank service charges. The entry is $0. 7F Line 710 - Total Interest Income (Current Month): The sum of Lines 700, $0, and 705, $0 = $0. Enter that figure on Line 710 and on Exhibit I, Line 165, Current Month Column. 8A COMPANY (Name) -Insert WYO Company name. 8B COMPANY (Number) -Insert WYO Company's NAIC number. 8C PERIOD ENDING -Indicate the financial statement reporting period (MONTH YEAR). LETTER OF CREDIT (LOC) DRAWDOWNS 8D Date/Amount Columns: Indicate in these columns every instance in which your WYO Company deposited LOC funds to your restricted account. The date should reflect the date of booking the deposit in your records. The Amount Column represents the dollars deposited in each instance. 8E Line 800 - Total: Total the individual LOC deposits. In Harwell's case, the sum is $0. Also, enter this figure on Exhibit II, Line 210, Current Month Column as a debit. Any LOC total recorded on Exhibit II should be shown as a debit. 8AA COMPANY (Name) -Insert WYO Company name. 8BB COMPANY (Number) -Insert WYO Company's NAIC number. 8CC PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). 8DD Date/Amount Columns: Indicate in these columns every instance in which your WYO Company transferred to the U.S. Government any excess funds exclusive of credit card payments from the restricted account. The date should reflect the date the disbursement was made. The amount column represents the dollars transferred to the U.S. Government in each instance. Excess funds must be transferred to the U.S. Treasury at least once a week. The weekly transfer of funds is indicated on Harwell's Exhibit VIII-B. NOTE: For procedures on how excess funds should be transferred to the U.S. Government, please refer to the appropriate section in the Write Your Own (WYO) Accounting Procedures Manual. Excess funds are defined as cash in the restricted account reduced by $5,000 and the established payable amount. In Harwell's case, the Company may maintain $5,000, plus the $20,000 payable amount for its undrawn expense allowance. Thus, the total excess funds amount for the month of May was $122,596. This total consisted of $1,290 of credit card payments and $121,306 of cash payments. The cash payments were computed as follows: April Restricted Account Balance May Cash/Check Receipts Premium Federal Policy Fees Salvage Total Restricted Account Balance Less May Disbursements Premium Refunds Claims Paid Allocated LAE Unallocated LAE Salvage Credit Special Allocated LAE Expense Allowance $ 5,000 $400,980 29,910 100 430,990 $435,990 $ 1,200 169,000 5,160 6,234 10 50 108,030 Restricted Account Balance Less Cash Reserve of $5,000 Less Payable due Harwell for Undrawn Expense Allowance of $20,000 Excess Funds Due U.S. Government (CASH PAYMENTS ONLY) 8EE Line 805-B – Total Cash Payments: ($289,684) $146,306 (5,000) (20,000) $121,306 Sum the individual payments (do not include credit cards) made to the NFIP. In Harwell's case, $121,306 of excess funds were sent to the Government. This figure, $121,306, is entered on Line 805-B. Please note that excess funds were sent on a weekly basis. Any WYO Company not making excess funds deposits at least once a week must be prepared to document for FEMA the reasons for its noncompliance. 8FF Line 805-C – Total Credit Card Payments: Brought forward from Exhibit VIII-C, Line 805-C. The amount is $1,290. 8GG Line 805 – D – Total Internet Payments: Brought forward from Exhibit VIII-D, Line 805-E. 8HH Line 805- E – Wire Transfers: Brought forward from Exhibit VIII-E. 8II Line 805 - Total Payments to the NFIP: The sum of Line 805-B, $121,306, and Line 805-C, $1,290, totals $122,596, Lines 805-D and 805-E . This total is then brought forward to Exhibit II, Line 215, and recorded as a credit. 8AAA COMPANY (Name) -Insert WYO Company name. 8BBB COMPANY (Number) -Insert WYO Company's NAIC number. 8CCC PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). 8DDD Date/Amount Columns: Indicate in these columns the date and amount of credit card payments made by the credit card bank to the U.S. Treasury. 8EEE Line 805-C: This line represents the total funds remitted to the U.S. Treasury through the use of the credit card payment mechanism. Sum the individual amounts and insert on Line 805-C. In Harwell's case, $1,290 was remitted. This total ($1,290) is then brought forward to Exhibit VIII-B, Line 805-C. For additional information on credit card processing, please refer to Part H of this Manual. 8FFF Line 805-D This line represents the total funds remitted to the NFIP. Sum the individual amounts and insert on Line 805-D. In Harwell’s case, $1290 was remitted. This total ($1290) is then brought forward to Exhibit VIII-D, Line 805-D. 8GGG Line 805-E This line represents wire transfers to the NFIP. Sum the individual amounts and insert on Line 805-E. In Harwell’s case, $1290 was remitted. This total ($1290) is then brought forward to Exhibit VIII-E, Line 805-E. NOTE: Exhibit VIII-C is to be completed by only those WYO Companies accepting credit card payments. 9A COMPANY (Name) -Insert WYO Company name. 9B COMPANY (Number) -Insert WYO Company's NAIC number. 9C PERIOD ENDING - Indicate the financial statement reporting period (MONTH YEAR). RESTRICTED ACCOUNT DEPOSITS 9D Date/Amount Columns: Indicate in these columns every instance in which your WYO Company booked a deposit into the restricted flood account, showing the date and amount. Please note that Harwell deposited funds into the NFIP restricted account every day. Credit card payments should not be included in the amount. 9E Line 900-Total Deposits for the Month: Sum the individual deposits, exclusive of credit card payments, and insert the figure $430,990 on Line 900. You have now completed all the financial statement exhibits. II. MONTHLY RECONCILIATION STATEMENTS The purpose of these monthly statements is to have a WYO Company reconcile its reported financial statement entries for five items (Net Written Premiums, Net Federal Policy Fees, Net Paid Losses, Special Allocated LAE, and Case Loss Reserve) with statistical totals generated from its system. The burden of identifying and resolving any variance between reported financial statement entries and corresponding statistical detail rests with each WYO Company. The following pages detail the completion of the five monthly reconciliation reports. A COMPANY NAME Harwell D CO. NAIC NUMBER B MONTH YEAR ENDING MAY 20XX E DATE SUBMITTED 6/20/XX C PREPARER'S NAME Robert George F TELEPHONE NO. 111-111-1111 25678 MONTHLY MONTHLY STATISTICAL FINANCIAL REPORT TRANSACTION REPORT K L G NET WRITTEN TRANS. RECORD PREMIUM PREMIUMS: $ 400,000 CODE COUNT AMOUNT (INCOME STATEMENT -11 997 $399,900 Line 100) H UNPROCESSED STATISTICAL: ( + ) PRIOR MONTH'S ( - ) CURRENT MONTH'S OTHER - EXPLAIN: (1) (2) 15 17 20 3 300 1,000 23 26 3 1,200 29 14 AND 81 99 12 J TOTAL: $399,000 M TOTAL: 1,003 $399,000* *(ADD 11 THROUGH 23 LESS 26 AND 29) N COMMENTS: A COMPANY NAME Harwell C CO. NAIC NUMBER 25678 B MONTH YEAR ENDING MAY 20XX D DATE SUBMITTED 6/20/XX MONTHLY MONTHLY STATISTICAL FINANCIAL REPORT TRANSACTION REPORT I J E NET FEDERAL TRANS RECORD FEE POLICY FEES: $ 30,000 CODE COUNT AMOUNT (INCOME STATEMENT -11 997 $29,910 Line 170) 15 F UNPROCESSED STATISTICAL: 17 ( + ) PRIOR MONTH'S ( - ) CURRENT MONTH'S 90 20 G OTHER - EXPLAIN: 23 (1) 26 (2) 29 H TOTAL: $29,910 K TOTAL: 997 $29,910 *(ADD 11 THROUGH 23 LESS 26 AND 29) L COMMENTS: A COMPANY NAME Harwell C CO. NAIC NUMBER 25678 B MONTH YEAR ENDING MAY 20XX D DATE SUBMITTED 6/20/XX MONTHLY MONTHLY STATISTICAL FINANCIAL REPORT TRANSACTION REPORT UNPROCESSED STATISTICAL: K L TRANS. RECORD LOSS/PAID E 100 NET PAID LOSSES $ 168,900 CODE COUNT RECOVERIES (INCOME STATEMENT - Line 115) F 140 (+)PRIOR MONTH'S G 150 (-)CURRENT MONTH'S H 160 SALVAGE NOT TO BE REPORTED BY TRANSACTION (EXPLAIN) 170 OTHER-EXPLAIN: (1) (2) 31 $ 34 37 40 43 3 169,000 46 AND 61 49 64 84 AND 87 52 RECOVERY 1 SALVAGE 100 SUBROGATION 67 RECOVERY SALVAGE SUBROGATION J TOTAL: $168,900 M TOTAL: 4 $168,900* (SUM OF Lines 100,140, *(ADD 31, 34, 40 THROUGH 64, 160, AND 170 LESS 150) LESS 52 AND 67) N COMMENTS: A COMPANY NAME Harwell C CO. NAIC NUMBER 25678 B MONTH YEAR ENDING MAY 20XX D DATE SUBMITTED 6/20/XX MONTHLY MONTHLY STATISTICAL FINANCIAL REPORT TRANSACTION REPORT I J E SPECIAL ALLOCATED TRANS. RECORD SALAE LOSS ADJUSTMENT CODE COUNT AMOUNT EXPENSES $ 50 (OTHER LOSS AND LAE CALC. - Line 655) 71 $ 74 F UNPROCESSED STATISTICAL: (+) PRIOR MONTH'S ( - ) CURRENT MONTH'S 50 G OTHER - EXPLAIN: (1) (2) H TOTAL: $ - 0 -K TOTAL: - 0 -$ - 0 - L COMMENTS: A COMPANY NAME Harwell C CO. NAIC NUMBER 25678 B MONTH YEAR ENDING MAY 20XX D DATE SUBMITTED 6/20/XX E NUMBER OF OPEN CLAIM F TOTAL AMOUNT CASES WITH RESERVES 3 OF RESERVES $60,000 (BALANCE SHEET ITEMS-LINE 325 CURRENT MONTH COLUMN) A COMPANY NAME -Insert WYO Company name. B MONTH YEAR ENDING -Indicate the financial/statistical reporting period (MONTH YEAR). C PREPARER'S NAME -Insert your name. D CO. NAIC NUMBER -Insert WYO Company's NAIC number. E DATE SUBMITTED -Indicate the month/day/year of completion of this form. F TELEPHONE NO. -Insert your telephone number. As you will note, there are two columns on this reconciliation, with totals for each at the bottom. The objective is to have the figures in the "Total" columns agree. G Net Written Premiums (Monthly Financial Report Column): From the financial statement Exhibit I, Line 100, Current Month column, insert the figure. In Harwell's case, it is $400,000. This represents the reported net written premium for the month. H Unprocessed Statistical (Monthly Financial Report Column): Under this header, you will note two line items. The first (+ Prior Month's) is to be used to record any booked premium for the prior month that is not included in the statistical detail for that month. In Harwell's case, there is no unprocessed statistical data for the prior month. The second line item (- Current Month's) is used to record any booked and reported premium for the current month that does not have a statistical entry in the current month's file. In Harwell's case, $1,000 of booked premium is not included in the statistical file for the month of May. Therefore, an entry is made on this line of $1,000. I Other - Explain (Monthly Financial Report Column): Under this header, you will note two lines. These lines are to be used to insert justifiable entries that do not involve unprocessed statistical items to account for any differences between the monthly financial report column entry and the monthly statistical transaction report figure. Examples of "Other-Explain" items would be resubmitted rejects, stale-dated checks, and breakage. J Total (Monthly Financial Report Column): Sum all the amounts in the column. The line items are "Net Written Premium": $400,000; "Unprocessed Statistical + Prior Month's": $0; "Unprocessed Statistical - Current Month's": ($1,000); and "Other - Explain": $0. Insert the figure $399,000 on the "Total" line. K Record Count (Monthly Statistical Transaction Report Column): For each transaction code, insert the total records submitted. For example, transaction 11 (New Business) had a total of 997 records submitted on the statistical tape. Premium Amount (Monthly Statistical Transaction Report Column): For each transaction code, insert the total premium value. For example, transaction 11 (New Business) premiums amount to a total of $399,900. M Total (Monthly Statistical Transaction Report Column): Sum all the lines in the Record Count Column. The entry is 1,003 (997 + 3 + 3). Sum all the lines in the Premium Amount Column. The entry is $399,000 ($399,900 + 300 - 1,200). N Comments: Use this space to explain your entries regarding financial and/or statistical submissions. In Harwell's case, there were no additional entries to report. Now, compare the figures in both columns. If they agree, the reconciliation is completed. If not, review for the difference and make the necessary corrections. A COMPANY NAME -Insert WYO Company name. B MONTH YEAR ENDING -Indicate the financial/statistical reporting period (MONTH YEAR). C CO. NAIC NUMBER -Insert WYO Company's NAIC number. D DATE SUBMITTED -Indicate the month/day/year of completion of this form. E Net Federal Policy Fees (Monthly Financial Report Column): From the financial statement Exhibit I, Line 170, Current Month column, insert the figure. In Harwell's case, it is $30,000. This represents the net Federal Policy Fees reported for this month. F Unprocessed Statistical (Monthly Financial Report Column): Under this header, you will again note two line items. The first (+ Prior Month's) is to be used to record any booked Federal Policy Fees for the prior month that are not included in the statistical file for that month. In Harwell's case, there is no unprocessed statistical data for the prior month. The second line item (- Current Month's) is used to record any booked and reported Federal Policy Fees for the current month that do not have statistical data for them included on the current month's file. In Harwell's case, $90 worth of booked Federal Policy Fees is not included in the statistical file for the month of May. Therefore, an entry of $90 is made on this line. G Other - Explain (Monthly Financial Report Column): For Harwell, this line does not need to be completed. H Total (Monthly Financial Report Column): Sum all the amounts in the column. The line items are "Net Federal Policy Fees": $30,000; "Unprocessed Statistical + Prior Month's": $0; "Unprocessed Statistical - Current Month's": ($90); and "Other - Explain": $0. Insert the figure of $29,910 on the "Total" line. I For each transaction code in which a Federal Policy Fee is applicable, insert the total of all records submitted. For example, Harwell has submitted a total of 997 statistical records that have a Federal Policy Fee amount. J Fee Amount (Monthly Statistical Transaction Report Column): For all applicable transactions, insert the net Federal Policy Fees total. For example, Harwell has submitted a net Federal Policy Fees total of $29,910. K Total (Monthly Statistical Transaction Report Column): Record the total in the "Record Count" column. The entry is 997. Record the total in the "Fee Amount" column. The entry is $29,910. L Comments: Use this space to report additional information regarding financial and/or statistical reporting. In Harwell's case, there were no pertinent comments to report. Now compare the figures in both columns. If they agree, this reconciliation is completed. If not, review for the difference and make the necessary corrections. A COMPANY NAME -Insert WYO Company name. B MONTH YEAR ENDING -Indicate the financial/statistical reporting period (MONTH YEAR). C CO. NAIC NUMBER -Insert WYO Company's NAIC number. D DATE SUBMITTED -Indicate the month/day/year of completion of this form. E Line 100 - Net Paid Losses: From Exhibit I, Line 115, Current Month column, insert the figure $168,900. F Line 140 - Unprocessed Statistical (+) Prior Month's: In Harwell's case, there are no unprocessed statistical transactions for the prior month. G Line 150 - Unprocessed Statistical (-) Current Month's: This line is to be used to account for statistical transactions that have not been processed and have not been included in the current month statistical file. In Harwell's case, all transactions have been processed. H Line 160 - Salvage Not to Be Reported by Transaction (Explain): This line is to be used in situations where a major catastrophe has occurred. Because of the number of losses paid in this occurrence, it is inefficient and impractical to assign salvage collected from a third party to each individual loss paid. Consequently, the salvage collected in this situation would not have a statistical transaction associated with it. However, in order to reconcile, this amount would be included on Line 160 with an explanation as to what it represented. I Line 170 - Other-Explain: In Harwell's case, this line does not need to be completed. J Total: Sum Line 100, $168,900; Line 140, $0; Line 160, $0; and Line 170, $0 = $168,900. From this total, $99,900, subtract Line 150, $0. Enter the amount, $99,900, on the "Total" line. K Record Count: For each transaction code, insert the total records submitted. For example, transaction 43 (Close Claim/Loss Payments) had a total of three records submitted on the statistical file. Loss/Paid Recoveries: For each transaction code, insert the total dollar value. For example, transaction 43 (Close Claim/Loss Payments) totaled $169,000. M Total: Sum all the lines in the Record Count column. The entry would be 4 (3+1). Sum all the lines in the Loss/Paid Recoveries column. The entry would be $168,900 ($169,000 - 100). N Comments: Use this space to explain your entries regarding financial and/or statistical submissions. In Harwell's case, there was nothing additional to report. Now compare figures in both columns. If they agree, this reconciliation is completed. If not, review for the difference and make the necessary corrections. A COMPANY NAME -Insert WYO Company name. B MONTH YEAR ENDING -Indicate the financial/statistical reporting period (MONTH YEAR). C CO. NAIC NUMBER -Insert WYO Company's NAIC number. D DATE SUBMITTED -Indicate the month/day/year of completion of this form. E Special Allocated Loss Adjustment Expenses: Insert in the Monthly Financial Report column the entry from Exhibit VI, Line 655, Current Month, $50. F Unprocessed Statistical (Monthly Financial Report Column): Since it was determined that there is no statistical entry on the monthly file (MAY 20XX) for current month expenses because of a processing error, $50 would be inserted on the "Current Month" line. It is imperative that when this entry is made, there is documentation for this expense and that it will be processed in the next month's statistical data. G Other - Explain (Monthly Financial Report Column): In Harwell's case, this line need not be completed. H Total (Monthly Financial Report Column): Sum all the amounts in the column. The line items are "Special Allocated Loss Adjustment Expenses": $50; "Unprocessed Statistical + Prior Month's": $0; "Unprocessed Statistical - Current Month's": ($50); and "Other - Explain": $0. Insert $0 on the "total" line. I Record Count: For each transaction code, insert the total records submitted. For example, transaction 71 (Special Allocated Loss Adjustment Expense) had no statistical records submitted. J SALAE Amount: For each transaction code, insert the total dollar value. For example, transaction 71 (Special Allocated Loss Adjustment Expense) had a dollar value amount of $0, since no transactions were submitted. K Total: Sum all the lines in the Record Count column. The entry would be 0. Sum all the lines in the Amounts column. The entry would be $0. L Comments: Use this space to explain your entries regarding financial and/or statistical submissions. In Harwell's case, there was nothing additional to report. Now compare figures in both columns. If they agree, the reconciliation is completed. If not, review for the difference and make the necessary corrections. A COMPANY NAME -Insert WYO Company name. B MONTH YEAR ENDING -Indicate the financial/statistical reporting period (MONTH YEAR). C CO. NAIC NUMBER -Insert WYO Company's NAIC number. D DATE SUBMITTED -Indicate the month/day/year of completion of this form. E Number of Open Claim Cases with Reserves: From your records, indicate the total number of "open case reserves" for each building and contents claim as of the end of the reporting period. F Total Amount of Reserves: From your records, indicate the total amount of the open case reserves for building and contents. Now compare this total amount with the figure shown on Exhibit III, Line 325, Current Month. If they agree, the reconciliation is completed. If not, review for the difference and make the necessary corrections. You have now completed the monthly reconciliation statements. III. CERTIFICATION STATEMENTS After the monthly financial statements and reconciliations have been prepared, the last items to be completed are certification statements. These statements should be signed by responsible officers within the WYO Company or their authorized signer(s). There are two certification statements to be signed. Below is a description of how each one should be prepared. In addition, examples of completed statements are presented. A. CERTIFICATION STATEMENT FOR MONTHLY FINANCIAL AND STATISTICAL RECONCILIATION REPORTS This statement relates to the entries recorded on both the financial statements and the reconciliation statements. It certifies that the entries on both documents have been reviewed and that all information included on these documents is the representation of the WYO Company. If a material modification is to be made, an explanation should be provided on this form. The form is to be completed by the responsible financial officer or authorized signer who inserts the WYO Company's name and the statement's reporting period (May 20XX) on the second line of the first paragraph. This form is then signed and dated by the financial officer or authorized signer who reviewed the documentation. Please review the example, and note that all information required to be completed is underlined. B. CERTIFICATION STATEMENT FOR MONTHLY STATISTICAL TRANSACTION REPORT This statement relates to the data contained on the monthly statistical data file from which certain balance totals (Net Written Premium, Net Paid Losses, Net Federal Policy Fees, and Special Allocated Loss Adjustment Expenses) are developed. It certifies that these balance totals used in the reconciliation statement processing are the representation of the WYO Company. If there is a material modification to be made, an explanation should be provided on this form. This form is completed by the responsible reporting officer or authorized signer who indicates the statistical transaction totals pertaining to the reporting period (May 20XX). On the last line, the WYO Company's name would be inserted. The form is then signed and dated by the responsible reporting officer or authorized signer who reviewed the statistical documentation. Please review the example, and you'll note that all information required to be completed is underlined. NOTE: Certification Statements can be signed only by those individuals so designated by the WYO Company. The lists (see examples on the following pages) of signers for each certification statements are completed by the WYO Company's appropriate authorization officer. A record of authorized signers is maintained by the NFIP Bureau and Statistical Agent. Any change or addition to the designated signer list must be communicated to the NFIP Bureau and Statistical Agent. This can be done by contacting your WYO Program Coordinator. A. CERTIFICATION STATEMENT FOR MONTHLY FINANCIAL AND STATISTICAL RECONCILIATION REPORTS I have reviewed the accompanying financial and statistical reconciliation reports of Harwell Company as of MAY 20XX . All information included in these statements is the representation of the Harwell Company. Based on my review (with the exception of the matter(s) described in the following paragraphs, if applicable), I certify that I am not aware of any material modifications that should be made to the accompanying reports. SIGNED Barbara Ann Gila (Responsible Financial Officer) DATE June 20, 20XX B. CERTIFICATION STATEMENT FOR MONTHLY STATISTICAL TRANSACTION REPORT I have reviewed the accompanying statistical transaction report control totals in conjunction with appropriate statistical reconciliation reports for the MAY 20XX reporting period. All information included in these reports is the representation of the Harwell Company. SIGNED Trisha Michelle Lore (Responsible Reporting Officer) DATE June 20, 20XX Write Your Own Company: I hereby designate the individual(s) listed below as the responsible financial officer to actas signatory for the Financial and Statistical Reconciliation Reports for my company. This individual(s) understands that he/she is responsible for the accuracy and completeness ofthese reports. Authorizing Officer of the Company: (Please type name and title) Signature and Date: Responsible Financial Officer(s): Company Individual(s) Vendor Individual(s) 1. 1. (Please type name) (Please type name) (Please type title) (Please type title) (Signature) (Signature) 2. 2. (Please type name) (Please type name) (Please type title) (Please type title) (Signature) (Signature) 3. 3. (Please type name) (Please type name) (Please type title) (Please type title) (Signature) (Signature) Return to: NFIP Bureau and Statistical AgentAttn: WYO Program Coordinator7700 Hubble Drive Lanham, MD 20706-1833 Write Your Own Company: I hereby designate the individual(s) listed below as the responsible reporting officer to actas signatory for the Statistical Transaction Report for my company. This individual(s) understands that he/she is responsible for the accuracy and completeness of these reports. Authorizing Officer of the Company: (Please type name and title) Signature and Date: Responsible Reporting Officer(s): Company Individual(s) Vendor Individual(s) 1. 1. (Please type name) (Please type name) (Please type title) (Please type title) (Signature) (Signature) 2. 2. (Please type name) (Please type name) (Please type title) (Please type title) (Signature) (Signature) 3. 3. (Please type name) (Please type name) (Please type title) (Please type title) (Signature) (Signature) Return to: NFIP Bureau and Statistical AgentAttn: WYO Program Coordinator7700 Hubble Drive Lanham, MD 20706-1833 MONTHLY STATISTICAL DATA FRONT-END BALANCING PROCEDURES As stipulated in the WYO Financial Control Plan and the Transaction Record Reporting and Processing (TRRP) Plan, each WYO Company is required to have its monthly statistical file received at the NFIP facility no later than the 21st day of the calendar month following each month's closing. For example, the statistical file for May's reporting period must be received at the NFIP facility no later than June 21, 20XX. According to the WYO Financial Control Plan and TRRP Plan, each WYO Company must submit with its file the reconciliation statements for net written premiums, net Federal Policy Fees, net paid losses, and special allocated loss adjustment expenses. For these statements, detailed statistical transaction information (transaction codes, record counts, and dollar amounts) must be provided. As an option, the WYO Company may submit a duplication of the reconciliation statements, which accompanies the financial statements (Exhibits I-IX), with the statistical file to satisfy this reporting requirement. The Harwell Insurance Company has opted to complete both the financial and statistical columns of the reconciliation statements. Copies of these pages were sent with the monthly statistical file, and a copy was submitted with the monthly financial statements. A full description of how to complete these reconciliation statements was previously presented in this Manual. When the NFIP Bureau and Statistical Agent receives the Harwell Insurance Company's statistical file and reconciliation statements, a front-end file balancing procedure is performed. The statistical file is first read to generate reports for net written premium, net federal policy fees, net paid losses, and special allocated loss adjustment expenses. Each report indicates record count for each transaction and a total record count. The report also shows the dollar value for each transaction and a total dollar amount. These reports are then compared with the reconciliation statements that Harwell submitted with the statistical file. Any discrepancy found in the dollar amount or record count will require Harwell to correct either the statistical file or the respective reconciliation statement before further NFIP Bureau processing will occur. The data on that file will not be included in various monthly statistical reports unless a corrected file and/or reconciliation statement is received by the required due date. The WYO Company will be notified by the NFIP Bureau accounting staff of a discrepancy in dollar amounts and record counts. Over-tolerance discrepancies will also be reported to FEMA representatives and to the WYO Standards Committee. Consequently, it is extremely critical that each WYO Company validate statistical transaction dollar amounts and record counts reflected on the reconciliation statements prior to submission. An excellent way to prevent a file rejection would be to submit the file to the NFIP Bureau and Statistical Agent 1 week or more before the month-end due date. If this is done and an error is detected, the WYO Company will still have enough time to correct the erroneous file and resubmit it. If the file figures correspond to the In Harwell's case, the statistical reports corresponded to the reconciliation statements in terms of both record counts and dollar amounts. Therefore, the statistical file was accepted and processed. NFIP BUREAU AND STATISTICAL AGENT PROCESSING OF REQUIRED FINANCIAL DOCUMENTS I. FINANCIAL STATEMENTS Upon receipt of the Financial Statements via e-mail, the NFIP Bureau and Statistical Agent's accounting personnel will review them for completeness and accuracy. If any problem is noted, a staff member will contact the preparer for clarification. After this review, Bureau personnel will upload statement entries from the financial documents to produce an individual WYO Company statement, formatted according to FEMA's reporting specifications. After all of the individual reports are produced, they will be combined into a WYO consolidated financial statement and formatted according to FEMA's specifications. The WYO consolidated statement is then combined with the NFIP Servicing Agent statement to produce a consolidated NFIP financial statement. II. RECONCILIATION STATEMENTS Upon receipt of the Monthly Reconciliation Statements, the Bureau Accounting staff will review them to ensure that explanations for differences and totals are valid. Financial figures are checked against the monthly statement, and statistical transaction totals are validated against report totals taken from the monthly run of the submitted statistical data. Any discrepancies or questions resulting from this review process will be directed to the WYO Company's preparer of the reconciliation statements. III. CERTIFICATION STATEMENTS Upon receipt of the Monthly Certification Statements, the Bureau Accounting staff will review them for authorized signers and appropriate date. If a problem is noted, Bureau staff will call the WYO Company. NOTE: The WYO Company representative must provide to its WYO Program Coordinator a list of individuals authorized to sign the Certification Statements. SUPPLEMENTAL CLAIM PAYMENT PROCEDURES On losses that require reopening, the additional loss adjustment expense (LAE) for the supplemental claim handling is calculated as follows: • It is the larger of the Closed Without Payment (CWOP) fee ($225.00), or the difference between the original LAE taken and the revised LAE based upon the total of all claim payments made (original + supplemental payment). With the use of either criterion, the minimum LAE to be paid for the handling of a supplemental claim will be the CWOP Fee Schedule amount ($225.00). To assist you in understanding the supplemental claim payment expense calculation and its associated financial and statistical reporting requirements, three examples have been developed. These examples should assist you in following the appropriate procedures when processing a supplemental claim payment expense. EXAMPLE A When the supplemental claim results in no additional claim payment, the minimum LAE amount (CWOP) fee ($225.00) is earned. For reporting and statistical reconciliation, this LAE ($225.00) is to be treated as a Special Allocated Loss Adjustment Expense (SALAE) - Type 2. Therefore, use Exhibit VI - Line 655 on your monthly financial statement to report the SALAE. Because this is SALAE - Type 2 and is not greater than $500.00, prior FEMA approval (authorization letter) is not needed. Next, follow the procedures outlined in the WYO Accounting Procedures Manual, Part F, which require that a listing be attached to your financial statement detailing all SALAEs by policy number, date of loss, SALAE amount, and type code. For statistical reporting, SALAE transaction (71) should be used. EXAMPLE B When the supplemental claim results in an additional claim payment and the calculated LAE for both the original and the supplemental claim payments is $225.00 or greater than the original LAE taken, reverse the LAE previously reported and insert the new LAE amount on the financial statement Fee Schedule (Exhibit V-A, B, C, D, E, F, or G of the Financial Statements). No SALAE financial and statistical reporting is required in this situation. When the supplemental claim results in an additional claim payment and the calculated LAE for both the original and the supplemental claim payment is less than $225.00 of the original LAE taken, the steps outlined below must be followed: • Reverse the LAE previously reported and insert the new LAE amount on the financial statement Fee Schedule (Exhibit V-A, B, C, D, E, F, or G of the Financial Statements). • Compute the difference between the new LAE (based on both the original and the supplemental claim payments) and the original LAE taken. Subtract this difference from $225.00. This amount should be treated as a Special Allocated LAE - Type 2. Therefore, use Exhibit VI- Line 655 on your monthly financial statement to report the SALAE. Since this is SALAE - Type 2 and is not greater than $500.00, no prior FEMA approval (authorization letter) is required. Next, follow the procedures outlined in the WYO Accounting Procedures Manual, Part F, which require a listing to be attached to your financial statement detailing all SALAEs by policy number, date of loss, SALAE amount, and type code. For statistical reporting, SALAE transaction (71) should be used. I. DEPOSIT OF NFIP FUNDS All premiums (net of expense allowances), Federal Policy Fees, and interest income relating to the WYO flood insurance program shall be deposited in a special account in an FDIC-regulated bank separate from all other WYO Company business. Premiums collected will also include all "suspense" items, not only posted policies. In addition, all premiums and Federal Policy Fees collected for policies with a future effective date must be deposited into the WYO Company's restricted account as soon as processing allows. A WYO Company may not use flood funds to earn interest for its company. Any interest earned on NFIP processing accounts, restricted accounts, satellite accounts, lockboxes, or other accounts must be paid to the NFIP. Using existing cash flow systems of each WYO Company, the flood insurance cash activity should be monitored on the same basis as all other company funds. To supplement this cash monitoring process, particularly the timely deposit of funds, WYO Companies are required to report all monthly restricted account deposits on Exhibit IX of the financial statements. The WYO Company must deposit flood insurance funds in the restricted account as soon as possible following collection of the premium. Each WYO Company must exert a good faith effort to comply with this intent. Each WYO Company must be prepared to document and explain how its individual procedures satisfy the intent. In order to facilitate timely deposit of WYO funds, a WYO Company may, at its discretion, operate more than one restricted account. The WYO Company will continue to supply FEMA with one (1) financial report encompassing all such accounts. In addition, the WYO Company will be allowed only one (1) SMARTLINK Letter of Credit. To ensure that the intent of overall proper cash management is achieved, each WYO Company shall outline its proposed cash management procedures for review by FEMA. These procedures shall be transmitted to the company's WYO Program Coordinator at the NFIP Bureau and Statistical Agent prior to the start of the company’s WYO operations. In addition, FEMA may request WYO Companies currently writing flood business to update or clarify their cash management procedures. To ensure the proper control and maintenance of the flood insurance account, WYO Companies must establish a general ledger to record transactions and provide supporting detail for the cash balances. In addition, monthly reconciliations between bank statements and the general ledger cash balances must be performed. II. TRANSFER OF EXCESS FUNDS Transfer of excess funds from the Restricted Flood Insurance Account to the U.S. Treasury is mandatory and should be performed at least once a week. Excess funds are defined as those funds in the restricted account less $5,000 and established payables (Exhibit III, Line 310). Funds in the premium suspense account are to be included in the excess funds calculation. In addition, premiums and Federal Policy Fees collected for policies with future effective dates should be included in the excess funds calculation. Established reserves for claim payments and claim loss adjustment expenses are not included when calculating the excess funds amount. The WYO Company or vendor must transmit excess funds to FEMA on at least a weekly basis. If weekly transfers are not made, a WYO Company must be prepared to document the reasons for noncompliance to FEMA. The Cash Management Procedure requires WYO Companies to remit funds as follows: • Through the use of the Automated Clearinghouse (ACH) established by FEMA for excess funds of $100,000 or less. • Funds exceeding $100,000 must be remitted by wire transfer. This method may require WYO Companies to transfer excess funds more frequently than once a week. It is FEMA’s understanding that wire transfers may be assessed an additional cost by your banking institution. Please negotiate with your banking institution to obtain the best possible per-transaction cost. FEMA’s agency location code for NFIP funds is 70-07-0005 and the Treasury appropriations code is 70X4236. • Funds may be transferred through the Internet. This process is part of an e- business initiative that allows customers to make flood insurance premium payments with paperless check transactions using the Internet. The WYO Program Coordinator assigned to each WYO Company should be contacted to coordinate the company’s access to the ACH. In rare situations and with FEMA’s permission, excess funds checks may be sent directly to the NFIP Bureau and Statistical Agent. For more details on the ACH, please refer to Part E of the WYO Accounting Procedures Manual. III. WYO COMPANY EXPENSE REIMBURSEMENT • The appropriate expense allowance for the WYO Company may be taken at the time the policy is processed and reported on the financial statement. • Allocated loss adjustment expenses based on the Fee Schedules can be taken at the time the claim payment is made. • Unallocated loss adjustment expenses may be taken at the time the reserve is established (with any necessary adjustments made as the incurred claim develops) or at the time the claim case is closed. • Special allocated loss adjustment expense reimbursement procedures are detailed in the WYO Accounting Procedures Manual, Part F. STALE-DATED CHECK PROCEDURES The following procedures should be used in processing premium and claim checks that are outstanding (not cashed) for 6 months and later: I. PREMIUM CHECKS A. Void the stale-dated check(s). B. Increase your net written premium (Exhibit I, Line 100) for the reporting month by the amount of the check(s). C. Increase your cash account (Exhibit III, Line 300, Column A) by the amount of the voided check(s). D. Your expense allowance for written premium (Exhibit IV, Line 410, Current Month Column) will be increased because of the increase in net written premium. E. On your "Net Written Premiums" monthly reconciliation statement, show in the "Other-Explain" line the amount ($1,000) of the voided check(s), and then subtract this figure from your net written premium total. Identify this entry on the reconciliation statement by the words "Stale-Dated Check(s)." This adjustment is required since no statistical transaction will be generated for the voided check(s). See EXAMPLE A on page G-2. F. Maintain, for 3 years, the details supporting the voided check(s). II. CLAIM CHECKS A. Void the stale-dated check(s). B. Decrease your net paid losses (Exhibit I, Line 115) for the reporting month by the amount of the check(s). C. Increase your cash account (Exhibit III, Line 300, Column A) by the amount of the voided check(s). D. On your "Net Paid Losses" monthly reconciliation statement, show in the "Other-Explain" line the amount ($2,000) of the voided check(s), and then add this figure to your reported net paid losses total. Identify this entry on the reconciliation statement by the words "Stale-Dated Check(s)." This adjustment is required since no statistical transaction will be generated for the voided check(s). See EXAMPLE B on page G-3. E. Maintain, for 3 years, the details supporting the voided check(s). COMPANY NAME Harwell MONTH YEAR ENDING MAY 20XX PREPARER'S NAME Robert George MONTHLY FINANCIAL REPORT NET WRITTEN PREMIUMS $ 401,000 (INCOME STATEMENT - LINE 100) UNPROCESSED STATISTICAL: (+) PRIOR MONTH'S(-) CURRENT MONTH'S OTHER - EXPLAIN: (1) STALE-DATED CHECKS (1,000) (2) TOTAL: $400,000 COMMENTS: CO. NAIC NUMBER 11111 DATE SUBMITTED 6/20/XX TELEPHONE NO. 111-111-1111 MONTHLY STATISTICAL TRANSACTION REPORT TRANS. RECORD PREMIUM CODE COUNT AMOUNT 11 998 $400,900 15 17 20 3 300 23 26 3 1,200 29 14 AND 81 99 12 TOTAL: 1,004 $400,000* *(ADD 11 THROUGH 23, LESS 26 AND 29) COMPANY NAME Harwell MONTH YEAR ENDING MAY 20XX 100 NET PAID LOSSES $ 166,900 (INCOME STATEMENT - LINE 115) CO. NAIC NUMBER 11111 DATE SUBMITTED 6/20/XX TRANS. RECORD LOSS/PAIDCODE COUNT RECOVERIES UNPROCESSED STATISTICAL: 140 (+) PRIOR MONTH'S 150 (-) CURRENT MONTH'S 160 SALVAGE NOT TO BE REPORTED BY TRANSACTION (EXPLAIN) 170 OTHER - EXPLAIN: (1) STALE-DATED CHECKS (2) + 2,000 31 34 37 40 43 46 AND 61 49 64 84 AND 87 52 RECOVERY SALVAGE SUBROGATION 67 RECOVERY SALVAGE SUBROGATION TOTAL: $ 3 169,000 1 100 3 $ 168,900TOTAL: $ 168,900 (SUM OF LINES 100,140,160, AND 170 LESS 150) COMMENTS: *(ADD 31, 34, 40 THROUGH 64, LESS 52 AND 67) CREDIT CARD PROCESSING In pursuit of the goal to simplify the NFIP and to promote policy growth, FEMA has approved the use of credit cards to pay flood insurance premiums. To encourage a company's implementation of credit card processing, minimum financial and statistical reporting requirements were established, and all bank service charges associated with credit card transactions will be paid by the U.S. Treasury when a WYO Company is using FEMA’s provider. All other expenses will be paid by the WYO Company. For more information on the use of the credit card payment mechanism and how to get started, please refer to the appropriate section of the WYO Accounting Procedures Manual. As stated earlier, the processing procedures and the financial and statistical reporting requirements for the use of the credit card payment mechanism are minimal. At this point, it will be helpful to note the processing procedures and the financial and statistical reporting requirements before completing an example. I. PROCESSING PROCEDURES To charge the purchase of a flood insurance policy to a credit card, the following billing information is required: • Date of charge • Name of cardholder • Account number • Card expiration date • Dollar amount of charge • Cardholder's signature If a credit card charge is taken by telephone, the cardholder's signature is not required. For credit card charges taken by means other than telephone, a printed charge authorization form must be used. On the form, the following cancellation disclaimer must be placed not more than one quarter of an inch below the cardholder's signature line. "This policy is not subject to cancellation for reasons other than those set forth in the National Flood Insurance Program rules and regulations. In matters involving billing disputes, cancellation is not available other than for billing processing error or fraud." For credit card charges taken by telephone, the cancellation disclaimer above must be read to the caller. Charge card billing information data must be attached to the new business application or included with the request for renewal update data. It is the WYO Company's decision as to how this billing information is obtained and in what format. However, this credit card bill information must be retained for at least 3 years for billing dispute purposes and for the creation of an audit trail. Funds generated through the credit card payment mechanism will be sent directly to the U.S. Treasury and not to the WYO Company's restricted account. The U.S. Treasury will receive the gross amount of the policy premium and the Federal Policy Fee. The funds received will include the bank discount charge. There will be a 2-day delay before the U.S. Treasury receives payment for an approved credit card transaction. For example, the funds for a transaction approved on Monday will be received by the U.S. Treasury by Wednesday. Reports for all credit card approval and payment transactions will be provided on a daily basis. II. FINANCIAL AND STATISTICAL REPORTING REQUIREMENTS For financial statement reporting, use Exhibit VIII-C, Credit Card Payments to the NFIP, to report all credit card payment transactions. This is the only additional financial statement reporting requirement. For Transaction Record Reporting and Processing (TRRP) Plan statistical reporting, there are two requirements. • The data element field entitled "Premium Payment Indicator" must be completed if a policy is paid by credit card. Indicator (C) must be used to identify flood policies that have been paid by credit card. • Use cancellation code (70) if the policy is canceled because of credit card processing error or fraud. NOTE: Since credit card proceeds will be sent directly to the U.S. Treasury, WYO Companies will have to build a mechanism to post those payments to their general ledger system. EXAMPLE As noted earlier, the Harwell Insurance Company has just established the credit card payment mechanism and has completed its first month of activity. For the month, one new business and two renewal policies were paid by credit card. The total amount of premium paid by credit card was $1,200. The total amount of Federal Policy Fee paid by credit card was $90. The total amount of all credit card payments for the month was $1,290. Remember that there is only one financial statement reporting requirement for credit card payments. In this case, simply go to Exhibit VIII-C, Credit Card Payments to the NFIP, and insert the date and the amount of the credit card payments. Then sum all the credit card payments for the month and insert the total ($1,290) on Line 805-C. Next, bring forward that total to the Exhibit VIII-B, Cash Payments to the NFIP, Line 805-C, NOTE: The total amount of credit card payments inserted on Line 805-C, Exhibit VIII-C, is a net figure. It will include any endorsement or cancellation refunds processed by credit card. The total will also include any credit card chargeback activity. Congratulations! You have finished the financial reporting of the credit card payments for a month. That is all you have to do! Please remember for TRRP Plan reporting to insert a "C" in the data element field entitled "Premium Payment Indicator" to identify those flood policies that have been paid by credit card. • Financial Assistance/Subsidy Arrangement • Write Your Own (WYO) Accounting Procedures Manual • Write Your Own (WYO) Accounting Training Manual (this document) • Write Your Own (WYO) Program Financial Control Plan • Transaction Record Reporting and Processing (TRRP) Plan for the Write Your Own (WYO) Program 593-9076B(10/05)