Recap supports integration with Swissborg via CSV files. Once set up, Recap will categorise all of your transaction history and calculate your tax position.
Step 1 - Download your Excel File from Swissborg
Swissborg enables you to download an Excel file containing all of your transaction history:
Go to the Account Statement menu and select the dates that you wish to be included.
Select the reference currency for the statement for equivalence e.g. GBP
Select 'Excel File'
Step 2 - Convert Swissborg Excel File to CSV
Follow these steps to convert your Swissborg file to CSV format before importing it into Recap:
Open your Excel file in MS Excel, it should look like this:
Delete the first 13 rows of data so that the headers on row14 now appear on row1. To do this:
Highlight the first 13 rows
Right-click and select delete, when prompted, select shift cells up.
Save the new file as a CSV file:
Click 'File', then 'Save As...'
Selecting 'CSV UTF-8' as the 'File Format'
💡 Microsoft Excel often automatically makes formatting changes that make the file unrecognisable to our software. Please ensure that your dates are in the format 'yyyy-mm-dd hh:mm:ss' before saving your changes.
Step 3 - Create your Swissborg Account in Recap and Upload your CSV
In Accounts, click the Add Account button, then select Exchange CSV, then Swissborg.
Give your account a name and click Next.
You'll return to Accounts, where you now have an empty Swissborg card.
Click the Settings Cog and then Import Swissborg CSV.
Click Browse to find your CSV file and then click Import.
Congratulations, your Swissborg transactions are now in Recap!
⚠️ Swissborg is currently in Beta
This means that not all of the usual Recap features are available for Swissborg quite yet. For example, you cannot reclassify your transactions. We will be adding these features in the future.
Click Support in the bottom left of the app to talk to us directly or join our telegram group to chat to other users.