Skip to main content
November 17, 2020
Question

Tax-Line Mapping

  • November 17, 2020
  • 3 replies
  • 0 views

How do I set  tax-line mapping for an account to Form 4797?

 

3 replies

DivinaMercy_N
November 17, 2020

Thank you for posting here, @User44.

 

In QuickBooks, the option to edit the selections under the Tax-Line Mapping when creating an account is unavailable. To ensure you select  the  accurate tax line mapping in an account, I'd recommend reaching out to your accountant. If you don't have one, you may use our Find an Accountant tool. Then, here's how to set up an account in QuickBooks Desktop:

 

  1. Go to the Accountant menu.
  2. Click Chart of Accounts.
  3. Press and hold Ctrl+N on your keyboard to create a new account.
  4. Select How do I choose the right tax line? There will be a help article that will explain why you need to consult your accountant in using the tax line mapping. 

 

For your future reference, I've added an article that will guide you in setting up sales tax for specific goods and services that you offer: Set up sales tax in QuickBooks Desktop

 

Feel free to post a comment below if you have other questions about tax line mapping. I'd appreciate any response and I'm always here if you need more help. Take care always.

User44Author
January 18, 2021

Divina,

 

I want to print out a full list of all available tax-line mapping options.  When editing an account I see a drop down, but I need to capture/print the full list and the drop down gives only limited visibility.  It shows only about 20 items.  I need to capture/print them all so I can send it to my accountant.  Thanks.

Kristine Mae
January 18, 2021

You can pull up the Account List report, User44. Let me guide you.

 

It will show you the list of all accounts in QuickBooks. Here's how:

  1. Click Reports.
  2. Go to List.
  3. Select Account List.

You can customize the report so you can focus on the details that matter to you.

 

Feel free to get back to this thread if you have more questions. We'll reply as soon as we can. Keep safe!

January 20, 2022

ANY UPDATE TO THE 2022 QB Desktop Accountant version to handle "Tax Line Mapping" for form 1065 or form 1041?

 

Thanks 

January 20, 2022

Thanks for checking this with us, TAX15

 

We don't have an exact time frame as to when will the Tax Line Mapping option for Form 1065 or Form 1041 will be available. Once this is available, it will be included in the QuickBooks updates.

 

To give you more insight and visual guide on how to update QuickBooks Desktop, please check out this article: Update QuickBooks Desktop to the latest release.

 

While we continue making improvements with the product, I want you to be updated with the new features added to the software by following the steps below:

 

Here's how:

 

  1. Go to the Help icon.
  2. Click New Features.
  3. Choose either New Feature Tour or What's New.

     

Another way to get you in the loop about the latest news and product developments in QuickBooks Desktop is to visit our Firm of the future site. To narrow down your search, you can go to the Product & Industry News tab.

 

As always, you can find me here if you have any other concerns or further questions about Tax Line Mapping. Have a great rest of the day.

April 4, 2023

I don't see any Tax Line Mapping to any of the accounts that were set up by Quickbooks for my LLC that rents residential property.  My Quickbook Desktop 2022 also does not have an "Accountant" drop down menu (or at least I'm unable to find it).  My accountant has given me the tax lines I should map to, but I don't see anyway to do this, and as best as I can tell, none of my accounts are mapped to Schedule E which is where all my expenses and revenue goes.  Can you clarify how I might map to Schedule E?

Bryan_M
April 4, 2023

I appreciate you for joining this thread, @ptyler441.

 

The Accountant tab in QuickBooks Desktop is only available to the users who subscribed to QuickBooks Desktop Accountant. Since you're using the regular version of it, that's the reason why the option isn't available on your end.

 

If you want to use the accountant version of QuickBooks, you can install and activate it. To get started, you can open this link: https://downloads.quickbooks.com/app/qbdt/products.

 

To get started with QuickBooks Desktop Accountants, check out the topics from this link: Find QuickBooks help articles for QBDT Accountants.

 

If you're now in QBDT Accountant, you can start the schedule E mapping. Here's how:

 

  1. Go to the Accountant menu.
  2. Click Chart of Accounts.
  3. Press and hold Ctrl+N on your keyboard to create a new account.
  4. Select How do I choose the right tax line? There will be a helpful article that will explain why you need to consult your accountant in using tax line mapping.

 

For your future reference, I've added an article that will guide you in setting up sales tax for specific goods and services that you offer: Set up sales tax in QuickBooks Desktop

 

If you have additional questions about managing your QBDT account, never hesitate to reply to this thread again. We'll be willing to help you. Keep safe, and have a good one!

September 8, 2024

I guess my biggest question, Thank you for the full Tax-line list, is how do each of the QB tax line items equate to how TurboTax sees them? TT for me is showing a random Insurance Premium item, that I can't locate even after reviewing all the mappings of the chart of accounts. So it is hard to know how TT will see from how QB is mapped. Is there a super secret translation table of