Foreign Affiliate Statement of Financial Position Report

The Foreign Affiliate Statement of Financial Position Report displays Asset, Liability, and Change in Net Position activities as of a selected period with foreign currency. Intended only for use by UCSF Global Programs accounting teams, the Business Units allow for the recording and reporting of transactions in each country's respective local currency. This step-by-step guide explains how to filter and run the report.

What Can I Learn from the Foreign Affiliate Statement of Financial Position Report?

Provides Asset and Liability balances from Levels B to F of the Account tree (defaults to Level C) along with the monthly changes in Net Position.

Report Date Filters

Use the Report Date as of drop-down menu to select the month. The report defaults to the current open month.

Chartstring Filters

  1. Business Unit (BU) is a required (*) Chartstring Filter. The filter page defaults to no BU selected, and only one BU can be selected at a time .
  2. In addition to the required filters on the filter page (*), at least one conditional filter with an orange triangle (▲) must be selected .

Account is not available as a chartstring filter to ensure all applicable rows of data are retrieved in the report.

Additional chartfield parameters may be selected as desired.

There are transactions with no department IDs for Assets and Liabilities. Under the Department ID filter, – Blank should be selected to include values with no department IDs .

See the Filtering and Running Reports in MyReports job aid for additional information and tips & tricks for using the filters to configure your report criteria.

Report Specific Filters

  1. Choose to Include (default) or Exclude the current open Accounting Period .
  2. Choose to change Account Level to B, C (default), D, E, or F .
  3. Display Codes and Descriptions – Display Codes Only, both Codes and Descriptions (default), or Descriptions Only .

Report Output Selection

  1. In addition to the report output selections of On Screen HTML (default), PDF, and Excel , you can choose Unformatted Data .
  2. The Unformatted Data output returns an Excel file that has no special formatting and a single row for column headings, making it the best source for pivot tables and other advanced spreadsheet analysis.
  3. Select your desired report output and click the Run Report button .
In both Excel outputs (standard Excel and Unformatted Data), the workbook will contain at least two tabs. The first tab/sheet always displays the entered filter criteria. The second tab/sheet displays the data and differs depending on whether you selected standard Excel or Unformatted Data.

Working in the Report View

  • The FA-Financial Position Report returns data grouped by Asset and Liability accounts, and monthly Changes in Net Position.
  • Drill-through functionality is indicated by blue hyperlinks. To view the details of the value, click the linked total to generate a Foreign Affiliate Transaction Detail Report in a new browser tab or window .
  • To select a different Account level, or change the Codes and Descriptions display, use the filters in the upper right-hand corner of the report:
    • Set your desired Account Level using the drop-down .
    • Change Codes and Descriptions display to the desired value .
    • Click Update .

Tips and Tricks

  • Beginning Net Position for the current Fiscal Year is not available until after the prior Fiscal Year’s final close.
  • If you choose to display open periods, the report output will show actuals as of the previous day.
  • The monthly amounts shown in the Beginning/Change in Net Position section represent the monthly Change in Net Position, which is calculated as Revenues – Expenses + Other Changes.
  • When running reports in Unformatted output, selecting Account Level F is recommended in order to display all Account Levels in the report output.
  • Net Position balances are not available for Unformatted output.
  • Data in MyReports are available starting from FY2023-24. Please use the nVision Reports for historical reports prior to FY24. For historical transaction details prior to FY24, please use the JRNL_LINE_DETAIL_LOCAL query in PeopleSoft.

Additional Information and Assistance

  • More information about MyReports, including how to request access and additional training, can be found in the MyReports section of the Controller’s Office website.
  • If you require help with a technical problem or have a question about a specific report, contact the Controller’s Office Solution Center at [email protected] or 415.476.2126.
  • To stay informed about MyReports news, follow the directions on the MyReports section of the Controller’s Office website to join the MyReports ListServ.​​​​

Give Us Your Feedback