Why sign in to the Community?

  • Submit a question
  • Check your notifications
Sign in to the Community or Sign in to TurboTax and start working on your taxes
Level 2
posted Aug 23, 2021 1:30:17 AM

Import transaction data from excel to Turbotax

Hello, 

 

I've worked a lot on an excel to categorize all my transactions from my self-employed business. 

 

Is there a way to import them directly on Turbotax? So that I don't have to write them again: it's quite painful, especially that categories are a bit different from Schedule C to Turbotax

 

So, I'm lost!! 

 

Thanks in advance

 

Pierre

0 5 2595
5 Replies
Level 7
Aug 23, 2021 1:43:36 AM

The is no easy way to import from Excel to TurboTax.  But you can use Quickbooks and import your Excel into Quickbooks.  Then Quickbooks will let you import your tax data into TurboTax.  

Level 15
Aug 23, 2021 7:01:32 AM

You don't need to enter all the transactions.   I just enter the category totals into Schedule C from my listing.  There's not very many categories.  Why aren't you using the Schedule C categories?  Mainly like Supplies?   Most stuff can go in there.   Are you making a lot of misc categories to go on line 27a from Part V?  

Do you need to see a Schedule C to help properly categorize your expenses?

https://www.irs.gov/pub/irs-pdf/f1040sc.pdf 

Level 15
Aug 23, 2021 7:08:02 AM

If you have them all in excel I assume you have a Category Column?   Did you sort by the Category column?   Then add a couple rows between the Categories and enter a sum for each category.

Level 2
Aug 23, 2021 9:25:37 AM

Hi @VolvoGirl , 

 

Yes I have computed the sum of transactions and split them between categories

 

But there are probably some tax rules that I don't master (for example for home office and assets depreciations). So I would prefer to go with Turbotax but I've the feeling that for most of categories, I just have a copy paste to do

 

So I was wondering if I could import a CSV file to go faster without errors

Level 15
Aug 23, 2021 9:44:22 AM

No to the CVS file and be very careful with the "cut & paste" function.  

 

Assets will have to be entered individually if you don't expense them.