Enterprise Community - eReporting

Enterprise Community Investment - Reporting - Electronic Financial Reporting - Template Instructions

	eReporting

·	Home
·	Requirements
·	Sponsor Codes (PDF)
·	Template Instructions
·	Help / FAQs
·	Contact Us (PDF)

·	Download Template
·	SUBMIT

·	Reporting Home

Template Usage Instructions

SYSTEMS REQUIREMENTS

This template runs in versions of Microsoft Excel 97 and higher. If you are using a different spreadsheet application or older version of Excel, please contact us or email eReportingHelp@enterprisecommunity.com.

The template runs in most operating environments.

OPENING THE ENTERPRISE REPORTING TEMPLATE

Upon opening the file, click the "Enable Macros" button when prompted.

The first time you open the template you will be asked to provide your sponsor ID code. This code has been mailed to your office. If you do not have your code, contact us and we will provide you with one.

After entering your sponsor code, click "Begin". This will duplicate the original template file for each property that you act as General Partner. These files will reside in the same folder as the original template you downloaded. The file will automatically be named as "Limited Partnership name_month_year.xls" (for example, "Smitty McGee LP_6_2002.xls" would be for 2nd quarter 2002). If you get a file for a property for which you are not the General Partner, contact us for help. When this process is complete the file will close.

If you are ready to begin, open the file for the appropriate property. See the instructions below to begin reporting.

ENTERING DATA IN THE TEMPLATE

To navigate throughout the template, click on the links in the first column.

All data should be entered in white cells only. Several areas restrict data entry because they are totals, subtotals or they feed from secondary sub-schedules. Those line items where amounts feed from secondary sub-schedules will give you options when you click on them. You can stay on the current main schedule or you can go to the sub-schedule.

Enter all amounts in every worksheet as a positive value, unless the account balance is the opposite of its natural sign. The schedules calculate subtotals and totals based on each account's applicable natural sign. Therefore, amounts such as accumulated depreciation and accumulated amortization, which are contra assets, should be entered as positive amounts. Similarly, vacancies and concessions, contra revenue accounts, should also be entered as positive. The formulas are set up to calculate subtotals and totals accordingly. Therefore, in most cases, all amounts will be entered as positive values…assets, liabilities, partners' capital, revenue, expenses, etc. Only balances that are contrary to their natural sign should be entered as a negative amount. For example, a cash overdraft should be entered as a negative amount in the cash category.

ERROR MESSAGES

If some totals or subtotals show #VALUE!, this may mean that you have entered invalid data in an amount field. For example, you may have entered a character or space rather than a number. If this occurs, simply delete the invalid character or space, or if you prefer, enter a zero. The total (or subtotal) will now recalculate properly.

If some totals or subtotals show #REF!, this may mean that data you previously entered was "cut" and then "pasted" to another cell. Unfortunately, Excel will not let you do this without altering the formulas that are dependent upon those data entry cells. If this occurs, select "Undo" until you have reversed your "cut" and "paste" functions. If the template has been permanently changed, revert to the original blank template or download another one from our website. Reminder: do not use the "cut" function in Excel. The "copy" function, however, may be used.

SUBMITTING FILE BACK TO Enterprise Community Investment , Inc.

To send your file back to Enterprise Community Investment , Inc., save and close this file. Return to the Enterprise Community Investment , Inc. eReporting website. Follow the instructions on the "Submit Template" page.

INSTRUCTIONS FOR EACH REQUIREMENT

General Partner Certification		Select "Yes" or "No" as to whether you certify that the financial reports and supplementary information present fairly the financial condition and other matters of the Partnership for the period reported. Do the same for each subsequent question, filling in detail where applicable.

Unaudited Financial Statements		When preparing financial statements, present year to date amounts using the accrual method of accounting.

Income Statement		With links from the following supporting schedules:
		Loans and Interest (use this schedule for interest expense amounts).
		Presents outstanding loan balances, must pay interest expense, deferred interest expense, accrued interest payable and deferred interest payable for each Mortgage Payable, M/P Affiliate, Notes Payable, and N/P Affiliate. Click the blue banner at the top of the Loans Payable page to view help on classifying loans as mortgages vs. notes, interest expense as must pay vs. deferred, and interest payables as accrued vs. deferred. The worksheet provides space for 16 different loan facilities (i.e. 4 Mortgages Payable, 4 M/P Affiliates, 4 Notes Payable, and 4 N/P Affiliates). This should be ample space for your operating partnership. If not, contact us at http://reporting.enterprisecommunity.com/ereporting/. Management Fees - segregated into two separate categories for must pay management fees and management fees payable from cash flow or capital contributions.

Balance Sheet		With links from the following supporting schedules:
		Land, Building & Equipment - enter your beginning balance (i.e. ending balance per prior year audit) and any additions, re-valuations, write-offs or retirements during the period. Also, write-offs and sales/retirements should be entered as positive numbers. The totals will calculate properly by subtracting them. Loans and Interest (use this schedule for loans and interest payables) - see above for description. Partners' Activity - see below.

Partners' Activity		Summarizes cash activity (contributions, distributions and syndication costs) for General Partners and Limited Partners. You no longer need to specify each partner if there are more than one general or limited partner. Distributions and syndication costs should be entered as positive numbers. The totals will calculate properly by subtracting them.

Reserve Activity		Enter activity for each reserve account listed (if applicable). Withdrawals should be entered as positive numbers. The totals will calculate properly by subtracting them.

Status Report and Narrative Description of Material Developments		Complete Page 1 UNTIL every unit has been initially qualified. Complete Page 2 AFTER every unit has been initially qualified. If your comments are longer than the space provided below each question, click the green banner or go to the "Comments" page using the navigation links.

Vacancy Report		Enter items requested in white. Once you have entered all the appropriate information, the worksheet will calculate the year to date vacancy loss for you. Keep in mind that the vacancy date range should reflect the ENTIRE period of vacancy even if the vacancy began in the prior year. The formulas will take this into account and properly calculate the vacancy loss for the period of the report (i.e. it will exclude the prior years' vacancy). A warning will appear if the vacancy loss calculated per the spreadsheet is not within 5% of the vacancy loss reported on your income statement.

	Please note the following additional reductions in quarterly reporting requirements:
		Statement of Cash Flows is no longer required. Debt Service Coverage Ratio is no longer required. Bank Statements and Rent Rolls are required bi-annually rather than quarterly.


© 2008 Enterprise Community Investment, Inc. All rights reserved. Enterprise Community Investment is a for-profit subsidiary of Enterprise Community Partners, Inc. American City Building \| 10227 Wincopin Circle \| Columbia, Maryland 21044 \| phone: 410.964.0552 \| fax: 410.964.1376 Privacy Policy \| Conditions of Use