Steps to Upload a Historical Cash Flow
Navigate to the Data Upload tab on the left hand side of your portal
From there you will see three upload options: Entities, Statements, and Historical Cash Flows
Select the upload button in the bottom left corner of the Historical Cash Flows box
Once you have clicked into this you will see a page titled Upload Historical Cash Flows with three icons showing options to upload cash flows
The icons are a document with a plus sign for a file, a plus sign to manually add cash flows, and a box showing CSV
Click on the icon listing the option you would like to use
Once you have uploaded the cash flow or selected the plus sign you will see a row with the following headings: Holding, Date, Type, and Amount
If leveraging the CSV template and there are multiple cash flow types that occurred on the same date, please add additional columns with the titles "Type" and "Amount" to ensure all cash flows are included in the same activity
Enter the appropriate cash flow information into the row only using positive values
It is important to note that each cash flow type impacts the holdings value on Arch in a different way. For more information on cash flow impacts, check out the Arch Transaction Guide.
Lastly, click save on the left hand side of your screen below the icons you used to upload the cash flows and you are done
The CSV template for a Historical Cash Flow Upload is attached below!
IMPORTANT NOTE: In the CSV file, no changes to formatting are necessary. For the "Date" column, please use the format "MM/DD/YYYY". For the "Type" column, please make sure the wording is an exact match with the cash flow types found in the Historical Cash Flows Upload portal. A full list of these types can be found below.
Cash Flow Types: Buy, Capital Call, Carried Interest, Cash Distribution, Cash Distribution - Income, Cash Distribution - Return of Capital, Cash Distribution (Recallable), Contribution, Dividend, Expenses, Federal Tax Withheld, Income Distribution (Decreases Value), Interest (Decreases Value), Interest Income, Internal Transfer, International Tax Withheld, Long Term Capital Gains, Management Fees, Miscellaneous Fees, Redemption, Reversed Contribution, Sale, Short Term Capital Gains, State Tax Withheld, Stock Distribution, Stock Distribution - Return of Capital, Subsequent Close Interest (Paid), Transfer In, Transfer Out