# Interactive Brokers: reports for tax declaration **URL:** \ **Category:** Taxes\ **Created:** [August 5, 2020, 2:43pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270 "2020-08-05T14:43:01Z")\ **Posts on this page:** 20\ **Page:** 7
**Author:** ![FunnyDjo](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/funnydjo/32/3216_2.png) [@FunnyDjo](https://forum.mustachianpost.com/u/FunnyDjo)\ **Post date:** [March 10, 2023, 7:55am UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/126 "2023-03-10T07:55:35Z")
you could also create a **flex query** with the dividends and the number of shares. You can then execute it for the month you want to retrieve the number of shares. In my case, I declare each VT purchase and the tax software will compute the accurate dividend amounts. ---
**Author:** ![Dr.PI](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/dr.pi/32/5299_2.png) [@Dr.PI](https://forum.mustachianpost.com/u/Dr.PI)\ **Post date:** [March 10, 2023, 12:30pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/127 "2023-03-10T12:30:08Z")
If you look at “Open Dividend Accruals” or “Change in Dividend Accruals” fields of an activity report for suitable dates, the number of shares is there. ---
**Author:** ![anneb](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/a/8797f3/32.png) [@anneb](https://forum.mustachianpost.com/u/anneb)\ **Post date:** [March 12, 2023, 6:32pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/128 "2023-03-12T18:32:29Z")
Thank you very much everyone for the comments on this topic. It’s the first time I’m doing the actions tax declaration and took me a few hours to get it. @San_Francisco your proposal of custom layout for the report was super helpful. A last question (& sorry in advance if it was covered already): where should I declare the cash “trésorerie” account I hold a IBKR. I’m using Vaud Tax and unsure where and how to add the info. Thanks all in advance for your kind help ---
**Author:** ![jmp](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/jmp/32/8768_2.png) [@jmp](https://forum.mustachianpost.com/u/jmp)\ **Post date:** [March 12, 2023, 6:39pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/129 "2023-03-12T18:39:49Z")
Have a look at [this thread](https://forum.mustachianpost.com/t/impots-en-suisse-interactive-brokers/9747), you’ll find explanations and screenshots for Vaudtax. ---
**Author:** ![mabi](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/mabi/32/3568_2.png) [@mabi](https://forum.mustachianpost.com/u/mabi)\ **Post date:** [March 12, 2023, 7:14pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/130 "2023-03-12T19:14:25Z")
Under Sections wouldn’t you also have to include “Cash Reports”? Because as far as I know you would have to declare in your taxes all cash accounts you have at IBKR just like a bank account. I suspect most of us having at least 2 cash accounts, if buying VT that would be CHF and USD. ---
**Author:** ![San\_Francisco](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/s/ea5d25/32.png) [@San\_Francisco](https://forum.mustachianpost.com/u/San_Francisco)\ **Post date:** [March 12, 2023, 7:45pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/131 "2023-03-12T19:45:27Z")
Possibly, if you declare all items and all cash balances in different currencies separately - but I don’t. I just declare the aggregated total from the Net Asset Value section (plus interest of course, if applicable) - which appears as a split between cash & stock (plus dividend accruals) in that section. I think I’ve had cash balances in 9 currencies last year. ---
**Author:** ![San\_Francisco](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/s/ea5d25/32.png) [@San\_Francisco](https://forum.mustachianpost.com/u/San_Francisco)\ **Post date:** [March 12, 2023, 7:57pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/132 "2023-03-12T19:57:45Z")
> [@anneb](#): > > A last question (& sorry in advance if it was covered already): where should I declare the cash “trésorerie” account I hold a IBKR. I’m using Vaud Tax and unsure where and how to add the info. Not familiar with that particular tax software (mine’s very similar to the Zurich one, I believe), but I don’t think anything would anything wrong with declaring it as a personal or current account (that’s _compte privé_ or _compte courant_, isn’t it?), as shown in the thread linked by @jmp. ---
**Author:** ![mabi](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/mabi/32/3568_2.png) [@mabi](https://forum.mustachianpost.com/u/mabi)\ **Post date:** [March 12, 2023, 8:04pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/133 "2023-03-12T20:04:16Z")
> [@San\_Francisco](#): > > I just declare the aggregated total from the Net Asset Value section (plus interest of course, if applicable) - which appears as a split between cash & stock (plus dividend accruals) in that section. That’s an excellent idea, I am all in about simplifying the tax declaration whenever possible. ---
**Author:** ![Le0](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/le0/32/4821_2.png) [@Le0](https://forum.mustachianpost.com/u/Le0)\ **Post date:** [July 12, 2023, 7:21pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/134 "2023-07-12T19:21:46Z")
Anyone ever had to provide more information to the tax office? I provided the report as specified by San\_Francisco and I just received a letter asking for my full IBKR report. Whatever that is… I sent a mail to try to clarify what they want. This is in Neuchatel btw. ---
**Author:** ![Patirou](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/p/439d5e/32.png) [@Patirou](https://forum.mustachianpost.com/u/Patirou)\ **Post date:** [July 12, 2023, 7:34pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/135 "2023-07-12T19:34:26Z")
I guess they want to have the activity report over a year. ---
**Author:** ![nabalzbhf](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/nabalzbhf/32/3277_2.png) [@nabalzbhf](https://forum.mustachianpost.com/u/nabalzbhf)\ **Post date:** [July 12, 2023, 7:45pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/136 "2023-07-12T19:45:39Z")
I’ve always only included the dividend report (in tax document), since I figured it documents all the DA-1 relevant items. Never had questions. edit: but if they ask for full report, I’d send them the full activity report. ---
**Author:** ![AnarquiaJoker](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/a/6bbea6/32.png) [@AnarquiaJoker](https://forum.mustachianpost.com/u/AnarquiaJoker)\ **Post date:** [August 29, 2023, 7:36am UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/137 "2023-08-29T07:36:48Z")
Can someone help me? I only have VT (arka) on IBKR, what would be the process to have a tax return attached to my due date on September 30th? Thank you. ---
**Author:** ![AnarquiaJoker](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/a/6bbea6/32.png) [@AnarquiaJoker](https://forum.mustachianpost.com/u/AnarquiaJoker)\ **Post date:** [August 29, 2023, 6:02pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/139 "2023-08-29T18:02:21Z")
in the custom statement section where it asks for the period at the bottom of the page, it gives me only daily or monthly, it doesn’t allow me to enter precise dates. ![Immagine 2023-08-29 200112](https://forum.mustachianpost.com/uploads/default/original/2X/0/042dec05e409de64cb06b405bb22e4999ee504a5.png) ---
**Author:** ![jay](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.mustachianpost.com/u/jay)\ **Post date:** [August 29, 2023, 7:04pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/140 "2023-08-29T19:04:20Z")
> [@AnarquiaJoker](#): > > it gives me only daily or monthly, it doesn’t allow me to enter precise dates. It’s a bit confusing but you can ignore that setting and specify a custom date range when you manually ‘Run’ the statement after the creation. As far as I can tell, the setting is relevant only if you want to have automated periodic delivery of that custom statement (and the only possible periods for automated delivery are daily and monthly). ---
**Author:** ![user137](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/user137/32/15454_2.png) [@user137](https://forum.mustachianpost.com/u/user137)\ **Post date:** [October 22, 2023, 9:30pm UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/141 "2023-10-22T21:30:59Z")
let me bump this up as a late filer each year. I have a bunch of ETF’s, Funds and individual stocks (20+) in my IB account that I’m also trading relatively actively. As I found no easy way of telling “how much of what did I own on the 31.12.2022”, I’ve just taken the NLV from the 2022 tax report and have put it into my declaration without any detailing on the individual positions (I did put in “Diverse” 🙂 ). Obviously I’m attaching the tax report, so not trying to hide anything, just trying to save us both time. As long as I’m not after dividend tax returns (which were \<100 USD last year), would that be enough? I guess I’m compliant with declaring my wealth, and I also assume the tax authorities are not going to actually care which stocks and ETF’s are holding that said wealth, are they? ---
**Author:** ![FunnyDjo](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/funnydjo/32/3216_2.png) [@FunnyDjo](https://forum.mustachianpost.com/u/FunnyDjo)\ **Post date:** [October 23, 2023, 2:01am UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/142 "2023-10-23T02:01:14Z")
IB send you by email a detail annual report of all your lines. You can print it as pdf and attach it to your tax reclamation. You can also build your annual report or flex queries with an annual frequency. Not sure if what I receive is built in or customised. In your tax software, you can declare a fund RF for your IB portfolio and just declare the total amount in chf and annual dividend. ---
**Author:** ![user137](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/user137/32/15454_2.png) [@user137](https://forum.mustachianpost.com/u/user137)\ **Post date:** [October 23, 2023, 7:13am UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/143 "2023-10-23T07:13:31Z")
> [@FunnyDjo](#): > > In your tax software, you can declare a fund RF for your IB portfolio and just declare the total amount in chf and annual dividend. that’s what the annual report does as well on IB, no? Gives you - NLV - total proceeds - total dividends But it doesn’t give you each position you had at 31st Dec of last year. ---
**Author:** ![Dr.PI](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/dr.pi/32/5299_2.png) [@Dr.PI](https://forum.mustachianpost.com/u/Dr.PI)\ **Post date:** [October 23, 2023, 7:41am UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/144 "2023-10-23T07:41:17Z")
Even if the default report doesn’t provide it (I think it does), you can always make your custom report template. You need “Positions” or something like that. [https://forum.mustachianpost.com/t/tax-declaration-list-your-deductions/3103/149](https://forum.mustachianpost.com/t/tax-declaration-list-your-deductions/3103/149) > [@Interactive Brokers: reports for tax declaration](https://forum.mustachianpost.com/t/interactive-brokers-which-reports-needed-for-tax-declaration/4270/2): > > I’m guessing they want one document per date on which you bought shares? They want to see when and at what price you bought your shares. ---
**Author:** ![FunnyDjo](https://forum.mustachianpost.com/user_avatar/forum.mustachianpost.com/funnydjo/32/3216_2.png) [@FunnyDjo](https://forum.mustachianpost.com/u/FunnyDjo)\ **Post date:** [October 23, 2023, 8:48am UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/145 "2023-10-23T08:48:57Z")
I got a report by email for each quarter with the total amount for each position with the current market value. ---
**Author:** ![jay](https://forum.mustachianpost.com/letter_avatar_proxy/v4/letter/j/ed8c4c/32.png) [@jay](https://forum.mustachianpost.com/u/jay)\ **Post date:** [October 23, 2023, 9:55am UTC](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270/146 "2023-10-23T09:55:10Z")
> [@user137](#): > > total dividends Keep in mind that dividends of accumulating funds are not included in the IBKR reports. That’s never an issue for US-domiciled funds, though. [Previous page](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270.md?page=6) [Next page](https://forum.mustachianpost.com/t/interactive-brokers-reports-for-tax-declaration/4270.md?page=8)