# Export T3's to Excel? **URL:** \ **Category:** T1\ **Created:** [April 1, 2017, 12:29pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265 "2017-04-01T12:29:16Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![kevin](https://avatars.discourse-cdn.com/v4/letter/k/2acd7d/32.png) [@kevin](https://www.protaxcommunity.com/u/kevin)\ **Post date:** [April 1, 2017, 12:29pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/1 "2017-04-01T12:29:16Z")
Like the T5008 forms, is it possible to export the T3’s to an Excel file? Even with the ability to aggregate T3’s in the AFR, I’m finding some clients with crazy #'s of T3’s from many issuers difficult to aggregate to match the T3 slips. I want to export to an Excel file so I can group the slips using the SUMIF function in Excel to match up the data with the slips. It would be so much easier to do it that way, at least for me. ---
**Author:** ![james1](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/james1/32/47_2.png) [@james1](https://www.protaxcommunity.com/u/james1)\ **Post date:** [April 1, 2017, 2:52pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/2 "2017-04-01T14:52:15Z")
You can aggregate the T3 and T5008’s in Taxcycle. you just keep selecting the same slip if you need to match them to your current slip and they will add them together. ---
**Author:** ![kevin](https://avatars.discourse-cdn.com/v4/letter/k/2acd7d/32.png) [@kevin](https://www.protaxcommunity.com/u/kevin)\ **Post date:** [April 1, 2017, 3:16pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/3 "2017-04-01T15:16:04Z")
Yup, I realize that, and it works fine for most clients. I have some clients, such as the one I’m working on, who have many (25 in this case) T3 slips from RBC Direct Investing, RBC Dominion Securities, RBC Investor Services, and many other issuers. It is difficult to match them in the AFR screen because many of them just say “RBC”. It would be helpful in a situation like this to be able to export into Excel. I can match them up easier using the SUM(IF function. That’s what I did in this case. ---
**Author:** ![james1](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/james1/32/47_2.png) [@james1](https://www.protaxcommunity.com/u/james1)\ **Post date:** [April 1, 2017, 4:54pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/4 "2017-04-01T16:54:01Z")
> [@kevin](#): > > d it works fine for most clients. I have some clients, such as the one I’m working on, who have many (25 in this case) T3 slips from RBC Direct Investing, RBC Dominion Securities, RBC Investor Services, and many other issuers. It is difficult to match them in the AFR screen because many of them just say “RBC”. It would be helpful in a situation like th In those cases, I use the actual T3 slip to assist me in the grouping since the details are on each slip. ---
**Author:** ![kevin](https://avatars.discourse-cdn.com/v4/letter/k/2acd7d/32.png) [@kevin](https://www.protaxcommunity.com/u/kevin)\ **Post date:** [April 1, 2017, 5:59pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/5 "2017-04-01T17:59:43Z")
I use the details, too, but this client detached all the T3’s and gave me the part without the details. Old habits die hard for some people. ---
**Author:** ![james1](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/james1/32/47_2.png) [@james1](https://www.protaxcommunity.com/u/james1)\ **Post date:** [April 1, 2017, 6:07pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/6 "2017-04-01T18:07:58Z")
Yes, I know the client you speak of. Did you know that if you click on Data and then the AFR icon, ![](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex016/uploads/taxcycle/original/1X/ec454c2d7a103d7362e089166506881e1f734405.png) The last import screen pops up and you can change where you imported a slip if it turns out you made a mistake and re import them. I just did this with some T3 and T5 that were posted twice without having to download them again. ---
**Author:** ![kevin](https://avatars.discourse-cdn.com/v4/letter/k/2acd7d/32.png) [@kevin](https://www.protaxcommunity.com/u/kevin)\ **Post date:** [April 1, 2017, 6:14pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/7 "2017-04-01T18:14:36Z")
Yup, thanks. Just used that this morning for the first time. I guess I’m just too used to Excel or need a lot more patience. ---
**Author:** ![james1](https://sea2.discourse-cdn.com/flex016/user_avatar/www.protaxcommunity.com/james1/32/47_2.png) [@james1](https://www.protaxcommunity.com/u/james1)\ **Post date:** [April 1, 2017, 6:17pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/8 "2017-04-01T18:17:42Z")
Ok, Sounds good. BTW, I do agree having the T3 slips export to Excel would helpful at times. Back to tax returns I guess. ---
**Author:** ![kevin](https://avatars.discourse-cdn.com/v4/letter/k/2acd7d/32.png) [@kevin](https://www.protaxcommunity.com/u/kevin)\ **Post date:** [April 1, 2017, 6:20pm UTC](https://www.protaxcommunity.com/t/export-t3s-to-excel/1265/9 "2017-04-01T18:20:13Z")
Thanks for your help. Back to work … and watching my step-son’s lacrosse game.