Cash Flow Invoice Utilities

Navigate to the Utilities panel, and then select the Create CF Invoices menu option.

The Create Cash Flow Invoices Utility screen opens.

Complete a search to find the deals for which to create invoices:

1. Select the Year. The Year defaults to the current year, but you can select a previous year where an Annual Cash Flow Distribution record exists.

2. Optionally, filter the results by the Fund Tracker.

3. Optionally, filter the results by the Deal Name.

4. Optionally, filter the results by the Property Manager.

5. Select the Deal Phase. The default is "All."

6. Select the Assigned User. The default is "All."

   You can select whether the user should be the Deal Lead for the deals returned.

7. Click Search.

   Closed but active deals that meet the search criteria are listed in the grid. A deal is closed when a date is populated in the Effective Date column when the Admission Stage is equal to Actual Closing in the Status History grid of Deal Details.

   The grid lists deals with Annual Cash Flow Distribution records where the year of the distribution record matches the selected year in the utility.

Select the checkbox at the beginning of the row for the deal(s) to create invoices.

You can select the checkbox in the header row of the grid to select all deals on the current page of the grid. If the grid spans multiple pages, you will need to visit each page to make selections.

Click Create Invoice in the top toolbar. Then click OK to confirm.

The system creates invoice records for each Annual Cash Flow Distribution for the selected deals. The system creates a record for each Bank Affiliate entity that is displayed as a "Payable To" on a Fee Distribution record that has a Fee Amount Due not equal to zero for the year selected or any previous years.

If the same Payable To has multiple Fee Distributions, they are summed and included within the same Invoice record.

Navigate to the Utilities panel, and then select the Review CF Invoices menu option.

The Review Cash Flow Invoices Utility screen opens.

Complete a search to find the invoices to view.

1. Select the Year. The Year defaults to the most recent year with Annual Cash Flow Distribution records, but you can select a previous year where an Annual Cash Flow Distribution record with a Cash Flow Invoice exists.

2. Optionally, filter the results by the Fund Tracker.

3. Optionally, filter the results by the Deal Name.

4. Select the Recipient Entity. The default is "All."

5. Select the Deal Phase. The default is "All."

6. Select Include Approved Invoices checkbox to include Invoice records with an Approved Date.

7. Select the Assigned User ID. The default is "All."

   You can select whether the user should be the Deal Lead for the deals returned.

8. Select Include Sent Invoices to include Invoice records with a Sent Date.

9. Click Search.

Select the checkbox at the beginning of the row for the invoice(s) to work on.

Enter the Approved Date to indicate approval of the invoice(s).

When you enter and save an Approved Date, the system snapshots the following values by year for the Invoice Report: any active entities with the Deal Role of Accountant - Tax, General Partner, or Property Manager, and the primary contact for those roles; the billing date, name of the property; and for each year and fee type, the year and fee type, amount due, payment received balance due, payable to entity, and payable to entity address.

The system also snapshots the following fields for the Invoice record: ILP Fee Amount Expected, ILP Fee Amount Received, and ILP Fee Amount Due.

Enter the Sent Date to indicate distribution of the invoice(s).

Click Save.

Then click OK to confirm updating the dates on the selected invoices. The system populates the Approved Date, Sent Date, or both for the selected Cash Flow invoices. If the Approved Date or Sent Date was previously populated on the record, the system overwrites the date with the new value.