[Format Request] Lime.co

[leppa]

Format Name

Lime.co

Export Instructions

1. Sign in to your Lime.co account.
2. Go to the Overview page.
3. Expand the Transaction History section.
4. Select the dates you're interested in.
5. Click the Excel icon and save the file.

Format Description

Relatively simple, mostly row-to-row mapping, but has some special cases that need to be handled. E.g., dividends are split into two rows that can't be mapped to each other - one for the dividend itself and another for the withholding tax; also, dividends don't have a symbol or quantity in the dedicated columns, but there's company name and quantity in the transaction description.

Some known quirks:

• Starts with sep=; line, uses ; as separator.
• Dividends are missing symbol and quantity. Those need to be extracted from the transaction description.
• Dividend tax rows cannot be reliably linked to dividends as they don't contain any identifiable information that could link them.
• Forward and reverse splits need to be calculated from paired in and out records.

Sample CSV Data

Only quirks, rest to be filled:

sep=;
Date;Description;Symbol;Direction;Quantity;Price;Fees;Amount
2019-02-27 00:00:00;Qualified Dividend APPLE INC 100;;deposit; 0; 0; 0; 25.00
2020-08-31 00:00:00;Stock Split STOCK SPLIT;AAPL;in; 400; 124.81; 0; 0
2020-08-31 00:00:00;Stock Split STOCK SPLIT;AAPL;out; -100; 499.23; 0; 0
2021-03-01 00:00:00;Qualified Dividend APPLE INC 100;;deposit; 0; 0; 0; 12.50
2021-03-01 00:00:00;Qualified Dividend MICROSOFT CORP 80;;deposit; 0; 0; 0; 9.20
2021-03-01 00:00:00;Foreign Tax Withholding NRA WITHHOLD: DIVIDEND;;withdrawal; 0; 0; 0; -1.88
2021-03-01 00:00:00;Foreign Tax Withholding NRA WITHHOLD: DIVIDEND;;withdrawal; 0; 0; 0; -1.38

Documentation or Resources

None

Format Variations

No known

Contribution

Yes, I can contribute code

Additional Context

Note: This issue is mainly for tracking and visibility purposes, so it's not filled up-to-standard. I know the format and its quirks and it's already under development.

Terms

• I have read and agree to follow the project's Code of Conduct
• I have read and agree to follow the project's Contribution Guidelines
• I have checked existing format requests and confirmed that this format has not already been requested
• I have provided all requested information and agree to answer any follow-up questions