Capitally provides you with a variety of in-built import templates for common brokers and apps.
If your specific broker isn't listed, don't worry. You can easily create a custom template yourself – or you can send us a sample CSV/XLS/JSON file at email@example.com. Include as many transaction types as possible, randomize your actual number, and provide us with a brief description of how to export the data from your broker.
Next, export your transactions from your broker as per the instructions provided. After exporting, all you have to do is drag and drop the file into Capitally or open it directly.
It's worth noting, that whatever file you drop on Capitally it will always be handled locally. It doesn't have to be sent to our servers or elsewhere. Plus the transactions that you decide to import out of it will be encrypted.
Once you've imported the file, Capitally will start matching the data to the existing assets in your project or find them on the market. If your broker doesn't provide an ISIN number in their export, Capitally will require your confirmation to verify if the proposed assets are correct. You can manually select from other matches or search for another symbol if needed. Creating a custom asset is also an option.
Once you select an asset or click ✔ the proposal will be accepted and we won't ask about it next time (if you save the template).
Take some time to review the data in the table. You can modify any value if necessary.
If you don't want to import a certain transaction - just uncheck the checkbox next to it. Some of the transactions can be already ignored - either because they're not supported, or they're already imported - you can check the reason by hovering on the icon above the checkbox.
Additionally, the rows can be sorted by clicking on the column headers for easier review.
If you have made changes, it's advisable to store your personalised template for future use.
Upon importing your transactions, confirm your account balances are correct. Ensure everything aligns with your actual records. If there are any discrepancies, simply use the
Undo option from the menu in the top-right corner to rectify the error. This command will undo only the import operation but not the creation of templates – hence you can make corrections in the template and try again.