# Bed and Breakfast help **URL:** \ **Category:** šŸ¤ Help\ **Created:** [November 20, 2021, 2:45pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912 "2021-11-20T14:45:04Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 20, 2021, 2:45pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/1 "2021-11-20T14:45:04Z")
Iā€™m in Bed and Breakfast hell thanks to myself and trading too often on the phone. I have acquired and sold shares a few times and Iā€™m not too sure how to report this oneā€¦ | | | Shares | Price | Total | | --- | --- | --- | --- | --- | | 30/09/2020 | SELL | 86 | 3.3 | 283.8 | | 30/09/2020 | SELL | 2 | 3.2 | 6.4 | | 17/09/2020 | BUY | 50 | 3 | 150 | | 10/09/2020 | SELL | 25 | 2.9 | 72.5 | | 10/09/2020 | BUY | 41 | 2.5 | 102.5 | | 08/09/2020 | BUY | 11 | 2.5 | 27.5 | | 08/09/2020 | BUY | 11 | 2.5 | 27.5 | In this other real example I have acquired 510 shares in different operations, then sold the 510 then bought 1433 and added moreā€¦ again a cellphone app mess but how would I proceed for this too ? | | | Shares | Price | Total | | --- | --- | --- | --- | --- | | 18/03/2021 | SELL | 1238 | 0.333 | 412.25 | | 10/03/2021 | SELL | 700 | 0.335 | 234.50 | | 25/02/2021 | BUY | 331 | 0.302 | 99.96 | | 22/02/2021 | BUY | 174 | 0.287 | 49.94 | | 12/02/2021 | BUY | 1433 | 0.279 | 399.81 | | 29/01/2021 | SELL | 191 | 0.256 | 48.90 | | 28/01/2021 | SELL | 191 | 0.267 | 51.00 | | 05/01/2021 | SELL | 128 | 0.244 | 31.23 | | 21/12/2020 | BUY | 116 | 0.257 | 29.81 | | 01/12/2020 | BUY | 118 | 0.252 | 29.74 | | 19/11/2020 | BUY | 127 | 0.235 | 29.85 | | 09/11/2020 | BUY | 123 | 0.203 | 24.97 | | 09/11/2020 | BUY | 26 | 0.200 | 5.20 | If you could help with those two calculations it would be amazing, I just need to grasp the way HMRC wants itā€¦do they want a line for each disposale(sale) ? ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 20, 2021, 3:56pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/2 "2021-11-20T15:56:10Z")
Maybe this [http://www.cgtcalculator.com/](http://www.cgtcalculator.com/) ? Please helpā€¦ is a bit of a convoluted one. ---
**Author:** ![Dougal1984](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/dougal1984/32/14304_2.png) [@Dougal1984](https://community.trading212.com/u/Dougal1984)\ **Post date:** [November 20, 2021, 8:44pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/3 "2021-11-20T20:44:24Z")
> [@dropbrick](#): > > Iā€™m in Bed and Breakfast hell > **[BNB Hell (2017) ā­ 4.5 | Horror, Thriller](https://www.imdb.com/title/tt5639410/)** > > 1h 23m | TV-MA Which one are you, doesnā€™t get a very good rating šŸ™ƒ ---
**Author:** ![Richard.W](https://avatars.discourse-cdn.com/v4/letter/r/b782af/32.png) [@Richard.W](https://community.trading212.com/u/Richard.W)\ **Post date:** [November 21, 2021, 8:01am UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/4 "2021-11-21T08:01:22Z")
My thinking is the 25 shares sold 10/9 have the basis cost of 25 shares bought the same day. The sales 30/9 have the basis cost of the all the others. But since you have bought and sold 113 shares in total and have no residual it wonā€™t really make any difference how you compute it. In the second example the 05/01 sale takes its cost basis from average price of all previous purchases. Those are a. Section 104 holding. The 28/01 and 29/01 sales take cost basis from the 12/02 purchase because of 30 day bnb rule. The March sales take their cost basis from the average price of all other purchases, excluding those which have already been matched against the previous sales. What remains is a Section 104 holding with a certain price per share you can compute. Also, yes, **try the calculator, it is good**. (See below - it took me less than 10 minutes to format and run your data through the calculator). Yes, HMRC wants a line in your attachment for each disposal. The calculator produces exactly the information you need for each line. But the information that goes in the body of the return is only the summary totals. The calculator shows this in its final line of output. If ABC and XYZ had been your only traded investments, the calculator would do them together and summarise as ![image](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/3X/2/e/2ed3f141ac1a5df53890ee1ada065be08e99858c.png) ---
**Author:** ![Richard.W](https://avatars.discourse-cdn.com/v4/letter/r/b782af/32.png) [@Richard.W](https://community.trading212.com/u/Richard.W)\ **Post date:** [November 21, 2021, 8:17am UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/5 "2021-11-21T08:17:19Z")
The calculator gives this for the second example. It is as I posited in my post above. ![image](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/3X/0/7/07f2454f056e7b8b2da75d4aacb26e1903375c4d.png) It also shows that you have sold all your shares and provides this summary ![image](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/3X/c/9/c99c5f89de382b929ed7989d556ded4b6dfdf1a5.png) I hope you feel you are no longer in BNB HELL . Output for the first example is: ![image](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/3X/d/a/da20e56c2a9146066c32c1b549f8af4252cd94ce.png) ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 21, 2021, 1:44pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/6 "2021-11-21T13:44:53Z")
The last exampleā€¦ shall I report it like this 5 lines in an XLS for HMRC ? > **[TEST\_CGT](https://docs.google.com/spreadsheets/d/11vREMfkN4NLpjfqT3sY2TbbbMhKciSZ9eP-iNklYKto/edit?usp=sharing)** > > Result CGT\_CALC > > > B/S,Date,Company,Shares,Price,Charges,Tax,Op... ![image](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/3X/f/7/f72b7ca4456424368ddac6227bfaa7000814dd10.png) Iā€™ve used the CGT calculator, tax and fees kept at 0 to make things clearer. Maybe I shouldnā€™t add the number of shares bought as the figures are how the CGT calculator is bundling them. ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 21, 2021, 1:53pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/7 "2021-11-21T13:53:06Z")
Also the calculator seems wrongā€¦ why is it taking the 2 and 3 sale from the buy of 1433 shares that happens in future ? It should take them from the first Section 104 holding which is 510 shares. Shouldnā€™t be like this instead ? @Richard.W ![image](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/3X/8/5/8563ed0dbdc05b38c28f8f75b2dcb257d6b761b5.png) ---
**Author:** ![MatthewLM](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/matthewlm/32/18169_2.png) [@MatthewLM](https://community.trading212.com/u/MatthewLM)\ **Post date:** [November 21, 2021, 2:39pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/8 "2021-11-21T14:39:10Z")
I created a calculator for cryptocurrencies called PyCryptax which was forked by someone for use on stocks. It might be useful though Iā€™ve not used it: [GitHub - mgalushka/StocksTax: UK Capital Gains Tax Calculator for Stocks](https://github.com/mgalushka/StocksTax) Coincidentally, Iā€™m now working on a new calculator that will handle Excess Reportable Income on ETFs. It will work for individual stocks too. It will be a python calculator like my last one. @dropbrick Iā€™m not sure how to help you as I donā€™t know much about this calculator you are using but I know the 30 day rule will match disposals (sells) against acquisitions (buys) made 30 days afterwards and this is before any remaining amount is matched against the section 104 holding rules. ---
**Author:** ![Richard.W](https://avatars.discourse-cdn.com/v4/letter/r/b782af/32.png) [@Richard.W](https://community.trading212.com/u/Richard.W)\ **Post date:** [November 21, 2021, 2:46pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/9 "2021-11-21T14:46:01Z")
@dropbrick The calculator is right. It is matching the sale first to purchases the same day, then to any purchases that take place within 30 days after, and finally matching to any Section 104 holding of previous purchases. | | | Shares | Price | Total | | --- | --- | --- | --- | --- | | 12/02/2021 | BUY | 1433 | 0.279 | 399.81 | | 29/01/2021 | SELL | 191 | 0.256 | 48.90 | | 28/01/2021 | SELL | 191 | 0.267 | 51.00 | 12/02 is within 30 days after 28/01 and 29/01 ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 21, 2021, 2:51pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/10 "2021-11-21T14:51:25Z")
Ok, how would you structure the XLS to attach to HMRC then to make it clear ? > **[TEST\_CGT](https://docs.google.com/spreadsheets/d/11vREMfkN4NLpjfqT3sY2TbbbMhKciSZ9eP-iNklYKto/edit)** > > Result CGT\_CALC > > > B/S,Date,Company,Shares,Price,Charges,Tax,Op... ---
**Author:** ![Richard.W](https://avatars.discourse-cdn.com/v4/letter/r/b782af/32.png) [@Richard.W](https://community.trading212.com/u/Richard.W)\ **Post date:** [November 21, 2021, 2:55pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/11 "2021-11-21T14:55:41Z")
You do not need to report to HMRC all your buys. I think all you need is one line for each sale. You put down for each sale: Ticker, number of shares, date bought, date sold, cost, proceeds and gain/loss. There is no need to detail the price per share. The figure for cost is something you have your own working for, do not include in your tax return, but could explain to HMRC if ever they were to ask. HMRC will not fine you for lack of information. They will simply ask for more. You only need to be sure you can answer their questions from you records, if asked. The date bought figure is most usually ā€œSection 104ā€, but could be a same day, or future day if BNB rules applied to that sale. I am not an accountant, but this is the way I have been doing it. I am sure I am paying the right tax. You can only incur a penalty if you are late or do not pay enough tax. ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 21, 2021, 3:07pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/12 "2021-11-21T15:07:45Z")
Right, this then ![image](https://europe1.discourse-cdn.com/flex013/uploads/trading212/original/3X/9/a/9a7c44d248dc258c68e81bca4af483ab74a2f3e5.png) ---
**Author:** ![Richard.W](https://avatars.discourse-cdn.com/v4/letter/r/b782af/32.png) [@Richard.W](https://community.trading212.com/u/Richard.W)\ **Post date:** [November 21, 2021, 5:19pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/13 "2021-11-21T17:19:15Z")
Looks good. šŸ™‚ \_\_\_\_\_\_\_\_\_\_\_\_ ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 21, 2021, 5:55pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/14 "2021-11-21T17:55:29Z")
Thanks for the help @Richard.W . ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 28, 2021, 8:41am UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/15 "2021-11-28T08:41:30Z")
If Iā€™m dealing with shares priced in EUR or USDā€¦ how would you feed the data into the calculator ? Using the exchange rate provided in the statement to feed price per share in GBP ? ---
**Author:** ![Dougal1984](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/dougal1984/32/14304_2.png) [@Dougal1984](https://community.trading212.com/u/Dougal1984)\ **Post date:** [November 28, 2021, 11:44am UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/16 "2021-11-28T11:44:16Z")
> [@dropbrick](#): > > Using the exchange rate provided in the statement That would make the most sense. Must be a nice feeling to make more than the free CGT allowance. My only other thought for myself when I get to that threshold, is do I crystallise losses to offset some of the gains, and then re buy the stock after a set period. Problem being the odd chance you miss any recovery on the loss side. I havenā€™t worked out how much the buffer could be worth. The CGT saving could be a small buffer I guess. ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 28, 2021, 12:05pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/17 "2021-11-28T12:05:25Z")
I wish I was over CGT! šŸ˜ƒ But Iā€™ve traded so much thanks to my phone that I went over the 4xCGT total sellā€¦ I actually made a loss for the tax year ---
**Author:** ![Dougal1984](https://dub1.discourse-cdn.com/flex013/user_avatar/community.trading212.com/dougal1984/32/14304_2.png) [@Dougal1984](https://community.trading212.com/u/Dougal1984)\ **Post date:** [November 28, 2021, 12:10pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/18 "2021-11-28T12:10:13Z")
> [@dropbrick](#): > > 4xCGT Ouch! Yeah my work doesnā€™t allow me to trade in the opposite direction in a 60 day period, so I doubt I would ever get that far. It has however made me think I want to spread my ISAā€™s but I only like opening up an ISA when I can in specie in or out. ---
**Author:** ![Richard.W](https://avatars.discourse-cdn.com/v4/letter/r/b782af/32.png) [@Richard.W](https://community.trading212.com/u/Richard.W)\ **Post date:** [November 28, 2021, 4:59pm UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/19 "2021-11-28T16:59:08Z")
> [@dropbrick](#): > > If Iā€™m dealing with shares priced in EUR or USDā€¦ how would you feed the data into the calculator ? Using the exchange rate provided in the statement to feed price per share in GBP ? Yes, you could use the rate in the statement. But no rate is given for dividends. I like to convert non-GBP currency to GBP using a vlookup into a Google sheet that has the whole year of daily exchange rates, produced with a one line googlefinance() function. I find this helpful for tax computations and keeping track of basis costs. ---
**Author:** ![dropbrick](https://avatars.discourse-cdn.com/v4/letter/d/8baadc/32.png) [@dropbrick](https://community.trading212.com/u/dropbrick)\ **Post date:** [November 30, 2021, 11:39am UTC](https://community.trading212.com/t/bed-and-breakfast-help/52912/20 "2021-11-30T11:39:03Z")
Hi @Richard.W youā€™re the resident expert! The calculator for these trades TAX\_YEAR 20-21 1. SELL: 25 ISHARES on 10/09/2020 at Ā£87.85 gives LOSS of Ā£1.25 SAME DAY TRADE Matches with: BUY: 25 shares of 41 at price Ā£87.90 RESULTANT TRADE: B ISHARES 10/09/2020 16 87.90 0.00 0.00 CALCULATION: LOSS = Ā£1.25 = ( 25 \* 87.85 - 0.00) - ( 41 \* 87.90 + 0.00 + 0.00) \* ( 25 / 41 ) 1. SELL: 88(2) ISHARES on 30/09/2020 at Ā£89.08977 gives GAIN of Ā£84.94 Matches with: BUY: SECTION 104 HOLDING. 88 ISHARES shares of 88 bought at average price of Ā£88.12455 CALCULATION: Gain = Ā£84.94 = ( 88 \* 89.08977 - 0.00 ) - ( 88 \* 88.12455 ) CURRENT PORTFOLIO Your portfolio is currently empty STATISTICS Total amount paid in stamp duty = Ā£0.00 Total amount paid in brokerā€™s fees = Ā£0.00 Total number of trades = 7 Total number of buys = 4 Total number of sells = 3 * * * How do I report the 3 sells ? Ahall I just make two lines in the XLS for HMRC and report the 88 sell as 2 sells ? [Next page](https://community.trading212.com/t/bed-and-breakfast-help/52912.md?page=2)