FCC Admin Tasks - Booking UCF Investments Gains or Losses

Booking UCF Investments Gains or Losses

The balance we carry in the General Ledger investment asset accounts correspond to the “Market Value” of the investment accounts at United Church Funds. The balance of the asset accounts should be made to match the balances reported by United Church Funds. This is done on a quarterly basis by calculating the "Net changed in Market Value derived from gains or losses stemming from market fluctuation and reinvested dividends that appear in the quarterly reports on the UCF website.

Step By Step Procedure

1. Download Quarterly Statements from United Church Funds

Login to United Church Funds Website.
Browse to “STATEMENTS & DOCUMENTS” page (see Figure 1)
Download the quarterly report PDFs for each investment account for the quarter being booked. In Figure 1 the highlighted PDF for the Trustee Investments is named “700530_0001_QMJSD_2025-03-31.PDF” (Note that having “QMJSD” in the name is the naming convention used to identify quarterly reports).
Upload the reports to the folder corresponding to the year in the UCF Investments Quarterly Reports folder and rename each consistent with prior reports.

2. Copy Values from Quarterly Reports

Open the Booking UCF Investments Journal Entries Google sheet.
From each downloaded quarterly report-
1. locate and enter quarter ending "MarketValue" for each asset account (see Figure 3).
2. locate and enter "Dividend Reinvestment" for each asset account (see Figure 4).
3. locate and enter all investments added to or monies drawn from, if any, investments for each asset account (see Figure 5)

3. Export the Journal Entry CSV and PDF

Pulldown the "Script Menu" and select "Finish Up".
Reply with "OK" to the confirmation message.

Note: When the script completes, a sidebar (see Figure 6) appears from which you can download/import transactions into QuickBooks. The sidebar will be active for a few seconds to complete the following download/import steps below. If you need more time, reply with a "No" to the "Confirm Import" popup that appears.

4. Download the CSV File and Import into QuickBooks

Click on "Download the CSV File" link in the sidebar to copy the CSV file to your downloads folder. A browser tab will temporarily appear during the download.
Click on "QuickBooks Import Journal Entries" in the sidebar.
Browse and select the downloaded CSV file, then click "Next".
Select the column "AccountName" for the QuickBooks field "Account Name", then click "Next".
Acknowledge the successful import into QuickBooks.

5. Confirm that the Journal Entries have been Imported

Return to the spreadsheet tab in the browser window.
If the import is complete, reply "Yes" to the "Confirm Import" popup.
Reply "OK" to the "Processing Complete" popup.
Close the spreadsheet tab.

Figure 1: Statements & Documents Page on UCF Website

Figure 2: Booking UCF Investments Journal Entries Google Sheet

Figure 3: Market Values from UCF Quarterly Report Being Booked

Figure 4: Dividends Reinvested from UCF Quarterly Report Being Booked

Figure 5: Record Added Investments or Draws

Figure 6: Download/Import Sidebar