Use this checklist when importing monthly, daily, quarterly, or NAV data for one program.
Use the correct import page and sample file
Open the relevant section under Performance Data and download its sample file. Do not reuse a sample prepared for another data type or for a mass import.
Keep the spreadsheet structure and formatting
Do not rename or remove required columns. Keep date cells as real Excel dates and preserve the formatting from the sample file. See Prepare dates in Excel import files.
Check the program identifier
The identifier in the spreadsheet must match the program identifier in TopSheets.
Remove invalid or duplicate dates
Dates must follow the frequency of the selected import, appear in the correct order, and not repeat the same period.
Choose Full or Incremental import deliberately
Incremental import adds or updates the records in the file. Full import also removes existing records that are not included in the uploaded file.
Use the correct percentage scale
Enable Multiply returns by 100 only when the source stores 5% as 0.05. Leave it disabled when the file already contains 5.
Review calculated related data
Options that calculate monthly or quarterly returns from a more frequent series can overwrite values already stored for those periods. Review the options before saving.
For the complete workflow, see Update and import performance data for a single program. For company-wide files, see Common mistakes when importing performance data for multiple programs.
Continue your fund reporting workflow
Use this guidance as part of a controlled fund factsheet data import and validation workflow. Continue with Update or import fund data and Fund factsheet production software.