--- title: "Portfolio Investments: Uploading Portfolio Investment Data" description: Learn how to upload portfolio investment data into ark using CSV templates, including assets, securities, purchase transactions, and non-purchase transactions. This guide covers upload prerequisites, recommended upload order, validation workflows, error handling, upload monitoring, rollback functionality, and links to detailed upload-specific documentation. --- [Skip to content](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#main-content) English - United States Show submenu for translations [Submit a Ticket](https://connect.arkpes.com/knowledge/kb-tickets/new?hsLang=en-us) [My Tickets](https://connect.arkpes.com/tickets?hsLang=en-us) [![ark](https://connect.arkpes.com/hs-fs/hubfs/ARK__Logotype_fullcolor.png?width=200&height=68&name=ARK__Logotype_fullcolor.png)](https://connect.arkpes.com/knowledge?hsLang=en-us) Open main navigation Close main navigation - English - United States Show submenu for translations - [Submit a Ticket](https://connect.arkpes.com/knowledge/kb-tickets/new) - [My Tickets](https://connect.arkpes.com/tickets) - [Email Ark Support](mailto:support@arkpes.com) [Email Ark Support](mailto:support@arkpes.com) Search the knowledge base - There are no suggestions because the search field is empty. 1. [Ark Knowledge Center](https://connect.arkpes.com/knowledge?hsLang=en-us) 2. [NEW Portfolio Investments](https://connect.arkpes.com/knowledge/new-portfolio-investments?hsLang=en-us) 3. [Portfolio Investment Uploading Guides](https://connect.arkpes.com/knowledge/new-portfolio-investments?hsLang=en-us#portfolio-investment-uploading-guides) # Portfolio Investments: Uploading Portfolio Investment Data ###### **Portfolio Investments: Uploading Portfolio Investment Data** ###### **Table of Contents** 1. [Overview](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#overview) 2. [Who Can Use This Feature](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#who-can-use-this-feature) 3. [Before You Begin](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#before-you-begin) 4. [Recommended Upload Order](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#recommended-upload-order) 5. [Supported Upload Types](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#supported-upload-types) 6. [Download Upload Templates](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#download-upload-templates) 7. [Upload Processing and Validation](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#upload-processing-and-validation) 8. [Monitoring Upload Progress](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#monitoring-upload-progress) 9. [Handling Upload Errors](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#handling-upload-errors) 10. [Downloading Original Files](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#downloading-original-files) 11. [Rollback Functionality](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#rollback-functionality) 12. [Related Upload Guides](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#related-upload-guides) 13. [Best Practices](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#best-practices) 14. [Next Steps](https://connect.arkpes.com/knowledge/uploading-portfolio-investment-data#next-steps) --- ###### **Overview** The CSV Upload feature allows users to bulk upload Portfolio Investment data into ark. Users can upload: - Assets - Securities - Purchase Transactions - Non-Purchase Transactions Uploads are processed asynchronously and validated before records are created. If any row fails validation, the entire upload fails. Partial uploads are not supported. Uploads that support General Ledger workflows may also create Journal Entries using Save & Send to GL functionality. --- ###### **Who Can Use This Feature** This feature is available to: **Ark Client Admin users** Ark Client Admin users can upload and manage all supported upload types across their client. **Basic Admin users with appropriate fund access** Basic Admin users can upload transactions only for funds assigned to their Fund Team. --- ###### **Before You Begin** Before uploading data: - Assets must exist before Securities can be uploaded. - Securities must exist before Transactions can be uploaded. - CSV files must follow ark formatting requirements. - Users should download the template from the applicable ark upload page before preparing upload files. --- ###### **Recommended Upload Order** Portfolio Investment uploads should generally be completed in the following order: | **Step** | **Upload Type** | | --- | --- | | 1 | Assets | | 2 | Securities | | 3 | Purchase Transactions | | 4 | Non-Purchase Transactions | This ensures all required relationships already exist before dependent uploads are processed. --- ###### **Supported Upload Types** **Assets** Users can upload: - Corporations - Partnerships - LLCs - Other **Securities** Users can upload: - Equity - Preferred - Equity - Common - Equity - Interest - Equity - Commitment Based - Convertible Security - Warrants & Options - Debt - Digital Tokenized - REIT - Other **Purchase Transactions** Purchase uploads create holdings/lots for securities. Supported Purchase transaction types include: - Purchase - Equity - Purchase - Debt - Purchase - Commitment - Purchase - Secondary Commitment - Purchase - Unit **Non-Purchase Transactions** Users can upload the following Non-Purchase transaction types: - Acquisition - Capital Gains Distribution - Contribution - Conversion - Distribution - Escrow - Expense - Income - Realization - Return of Capital - Sale - Equity - Sale - Debt - Sale - Commitment - Sale - Unit - Sale - Commitment Transfer - Stock Distribution - Stock Split - Valuation - Write Off - Airdrop - Gas and Transfer Fees - Transfer --- ###### **Download Upload Templates** Always begin with the latest upload template. Templates include: - Required columns - Correct header formatting - Required Portfolio Attributes - Optional Portfolio Attributes **Steps** 1. Navigate to the appropriate Portfolio Investments page. 2. Click Upload. 3. Select the upload type. 4. Click Download Template. 5. Save the CSV template locally. Templates are available for: - Assets - Securities - Purchase Transactions - Non-Purchase Transactions --- ###### **Upload Processing and Validation** All uploads follow the same validation workflow. **Phase 1: Pre-Flight Validation** The system validates: - CSV structure - Header formatting - Required columns - Date formatting - Attribute requirements - Unknown columns **Phase 2: Business Logic Validation** The system validates: - Entity existence - Fund access permissions - Security relationships - Allocation reconciliation - Intermediary relationships - Client isolation rules If any validation fails: - The entire upload fails. - No records are created. --- ###### **Monitoring Upload Progress** Users can monitor uploads from the Upload History page. **Upload Statuses** | **Status** | **Meaning** | | --- | --- | | Uploading | Upload is processing | | Upload Successful | Upload completed successfully | | Upload Failed | Validation or processing failed | | Rolling Back | Rollback is in progress | | Rollback Successful | Uploaded records were removed | | Rollback Failed | Rollback encountered issues | The Upload History page refreshes automatically while uploads are processing. --- ###### **Handling Upload Errors** If validation fails: - Upload status changes to Upload Failed on the Upload History page - An error report becomes available on the Upload History page **Error Reports Include** - Row Number - Column Name - Input Value - Failure Reason **Common Error Types** - Invalid date formatting - Missing required values - Asset not found - Security not found - Fund access restrictions - Allocation reconciliation failures - Lot Group mismatches --- ###### **Downloading Original Files** Users can download the original uploaded CSV file at any time from the Upload History page. Original files may be downloaded for: - Audit purposes - Validation review - Error correction - Rollback review --- ###### **Rollback Functionality** Successful uploads may be rolled back from the Upload History page. Rollback removes uploaded records created by the upload. **Important Notes** - Basic Admin users can only rollback files that they uploaded. - Rollback is all-or-nothing. - Rollback may fail if dependencies were created afterward. **Steps** 1. Navigate to Upload History. 2. Locate the successful upload. 3. Click Rollback. 4. Confirm the rollback. 5. Monitor rollback progress. --- ###### **Related Upload Guides** For detailed upload instructions, see: - [Uploading Assets and Securities](https://connect.arkpes.com/knowledge/uploading-assets-and-securities?hsLang=en-us) - [Uploading Purchase Transactions](https://connect.arkpes.com/knowledge/uploading-purchase-transactions?hsLang=en-us) - [Uploading Non-Purchase Transactions](https://connect.arkpes.com/knowledge/uploading-non-purchase-transactions?hsLang=en-us) --- ###### **Best Practices** - Always use the latest upload template. - Validate data before uploading. - Upload Assets before Securities. - Upload Securities before Transactions. - Confirm entity allocations reconcile correctly. - Review upload validation errors carefully before re-uploading files. --- ###### **Next Steps** After uploads are completed successfully, users can: - Record additional investment activity - Generate Schedule of Investments reporting - Send transactions to arkGL - Manage investment reporting workflows Further workflows are covered in the Portfolio Investments guides. - [NEW Portfolio Investments](https://connect.arkpes.com/knowledge/new-portfolio-investments?hsLang=en-us#main-content) - [Portfolio Investment Uploading Guides](https://connect.arkpes.com/knowledge/new-portfolio-investments?hsLang=en-us#portfolio-investment-uploading-guides) - [Client Management](https://connect.arkpes.com/knowledge/client-management?hsLang=en-us#main-content) - [Client Portal Setup](https://connect.arkpes.com/knowledge/client-management?hsLang=en-us#client-portal-setup) - [Branding & Communication Settings](https://connect.arkpes.com/knowledge/client-management?hsLang=en-us#branding-communication-settings) - [Transaction & Metric Mapping](https://connect.arkpes.com/knowledge/client-management?hsLang=en-us#transaction-metric-mapping) - [Report Configuration](https://connect.arkpes.com/knowledge/client-management?hsLang=en-us#report-configuration) - [Feature Configuration](https://connect.arkpes.com/knowledge/client-management?hsLang=en-us#feature-configuration) - [Client Onboarding & Go-Live](https://connect.arkpes.com/knowledge/client-management?hsLang=en-us#client-onboarding-go-live) - [Data & Transaction Management](https://connect.arkpes.com/knowledge/data-transaction-management?hsLang=en-us#main-content) - [Transactions & Metrics](https://connect.arkpes.com/knowledge/data-transaction-management?hsLang=en-us#transactions-metrics) - [Fund Allocations](https://connect.arkpes.com/knowledge/data-transaction-management?hsLang=en-us#fund-allocations) - [Document Management](https://connect.arkpes.com/knowledge/document-management?hsLang=en-us) - [Financial Management](https://connect.arkpes.com/knowledge/financial-management?hsLang=en-us#main-content) - [General Ledger & Chart of Accounts](https://connect.arkpes.com/knowledge/financial-management?hsLang=en-us#general-ledger-chart-of-accounts) - [Journal Entries & Entity Tagging](https://connect.arkpes.com/knowledge/financial-management?hsLang=en-us#journal-entries-entity-tagging) - [Bank Integrations](https://connect.arkpes.com/knowledge/financial-management?hsLang=en-us#bank-integrations) - [Cash Receipts](https://connect.arkpes.com/knowledge/financial-management?hsLang=en-us#cash-receipts) - [GL Reports & Reporting Tools](https://connect.arkpes.com/knowledge/financial-management?hsLang=en-us#gl-reports-reporting-tools) - [Fund & Investor Management](https://connect.arkpes.com/knowledge/fund-investor-management?hsLang=en-us) - [Investor Communications](https://connect.arkpes.com/knowledge/investor-communications?hsLang=en-us#main-content) - [Capital Calls & Distributions](https://connect.arkpes.com/knowledge/investor-communications?hsLang=en-us#capital-calls-distributions) - [General Mailings](https://connect.arkpes.com/knowledge/investor-communications?hsLang=en-us#general-mailings) - [Product Updates](https://connect.arkpes.com/knowledge/product-updates?hsLang=en-us#main-content) - [Release Notes](https://connect.arkpes.com/knowledge/product-updates?hsLang=en-us#release-notes) - [User & Access Management](https://connect.arkpes.com/knowledge/user-access-management?hsLang=en-us#main-content) - [Admin Users & Teams](https://connect.arkpes.com/knowledge/user-access-management?hsLang=en-us#admin-users-teams) - [Contacts & Impersonation](https://connect.arkpes.com/knowledge/user-access-management?hsLang=en-us#contacts-impersonation) - [Authentication & Login](https://connect.arkpes.com/knowledge/user-access-management?hsLang=en-us#authentication-login) - [Audit & Activity Reporting](https://connect.arkpes.com/knowledge/user-access-management?hsLang=en-us#audit-activity-reporting) - [LP Portal](https://connect.arkpes.com/knowledge/lp-portal?hsLang=en-us) [![ARK\_\_Logotype\_fullcolor-1](https://connect.arkpes.com/hs-fs/hubfs/ARK__Logotype_fullcolor-1.png?width=200&height=68&name=ARK__Logotype_fullcolor-1.png "ARK__Logotype_fullcolor-1")](http://arkpes.com) [mailto:support@arkpes.com](mailto:support@arkpes.com) Copyright © 2025, Ark PES