ERS NCUA Reports Resources.

These are resources that will assist you in completing the NCUA 5300 reports. Most of the files are in .PDF format, however there are few that are Excel Spreadheets.

If you need to download Acrobat Reader Click here

1. REQUIREMENTS - Things you must have to be able to produce the NCUA Reports
2. ERS STANDARD CHART OF ACCOUNTS - Your chart of accounts must agree with these.
3. INVESTMENTS BY MATURITY - Use these account numbers to indicate remaining maturity
4. REQUIRED COLLATERAL CODES - Codes to be placed in the 4th Collateral Code position.
5. PREPARATION - Help preparing your GL Accounts and loans.
6. GL WORKSHEET - Click here to download an EXCEL GL account conversion worksheet.
7. OPTION V DEFAULTS - After you change GL account numbers be sure to check your defaults.
8. OVERVIEW - A quick explanation of how the spreadsheets create the reports.
9. SAMPLE STATEMENT OF FINANCIAL CONDITION - Takes a few seconds to display.
10. SAMPLE STATEMENT OF INCOME & EXPENSE - Takes a few seconds to display.
11. SAMPLE STATEMENT OF MEMBER EQUITY - Takes a few seconds to display.
12. SAMPLE 5300 CALL REPORT WORKSHEET - Be patient. Takes several seconds to display.
13. Click here to download the "NCUAMONTHLY.xls" masterfile.
14. Click here to download the 5300.XLS masterfile.