• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
QuickBooks General Forum QuickBooks Payroll 3rd Party Apps that work with QuickBooks QuickBooks Accountant Edition QuickBooks Online for Accounting Professionals QuickBooks Enterprise Solutions QuickBooks Point of Sale
ProAdvisor Program & Certification
ProSeries DMS ProSeries Community
Lacerte DMS Lacerte Community
Intuit Tax Online Tax Research for Lacerte and ProSeries Tax Import for Lacerte and ProSeries Intuit Practice Management EasyACCT Intuit Statement Writer
Starting and Managing Your Practice Classifieds Intuit ProConnection Newsletter Intuit Academy Training Your Peers Recommend
  • QuickBooks & Payroll
  • ProAdvisors
  • Lacerte
  • ProSeries
  • Productivity Tools
  • Training & Resources
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help for Accountants   Training and Resources   Intuit ProConnection Newsletter   Accountant Community Allstars Forum   Getting Started   Intuit Academy Training   Starting and Managing Your Practice   Archive: General Forum   Private Forums   Archive: Document Management System   Your Peers Recommend  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
1
9354
bvMjuUnZqr4yUOacwZ5xHE
Subscribe RSS
ansonaccounting
ansonaccounting
Questions asked: 5
Questions answered: 2
Points earned: 2
ansonaccounting
ansonaccounting
Questions asked: 5
Questions answered: 2
Points earned: 2
New Member
01/04/12 4:29pm PST
Viewed by asker 02/03/12 3:58pm PST

1120 Tax Filing vs General Ledger for S Corp

US QuickBooks Enterprise Solutions : 12.0: Contractor

I was asked to review the 1120 tax filing information on a cash basis for our company that was done 6 years ago. I had to compare this with the financials (PnL, Bal Sheet) and general ledger for that year, which I have extracted from QB report as cash basis reports.  However, there are a lot of variances and finding the groups and categories is taking too much of my time. I need suggestions on how to approach this project efficiently and effectively. Thank you.

Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
5 Replies
PhoebeRoberts
PhoebeRoberts
Questions asked: 81
Questions answered: 9535
Points earned: 34949
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
PhoebeRoberts
PhoebeRoberts
Questions asked: 81
Questions answered: 9535
Points earned: 34949
Accountant Community AllStar
01/04/12 5:06pm PST

 That's an inherently time-consuming task, and since the statute's run on a 6 year old return, it may not make sense to even start the project.

That aside, I set up an Excel with per QB and per TR columns, use Excel to figure the discrepancies, and move rows out of the field of work as I manage to lump things together. Watch out for book-tax differences and tax AJEs never booked.

If I wanted phone calls, my phone number would be in my profile. If you have a question, post it in the applicable forum.
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
ansonaccounting
ansonaccounting
Questions asked: 5
Questions answered: 2
Points earned: 2
New Member
01/05/12 9:24am PST

That's what I am currently doing.  The tax years are actually for 2006 through 2010.  I never thought of the tax AJE until you mentioned it. Thank you.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43424
Points earned: 106555
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43424
Points earned: 106555
Allstar, Accountant Community AllStar
01/04/12 5:11pm PST

If you think the file was set up well and used correctly, then look at Reports menu > Accountant and Taxes, for the Tax reports here. This might get you close.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
ansonaccounting
ansonaccounting
Questions asked: 5
Questions answered: 2
Points earned: 2
New Member
01/05/12 9:21am PST

Unfortunately, we didn't use the tax line mapping features in QB so it's not summarized.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43424
Points earned: 106555
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43424
Points earned: 106555
Allstar, Accountant Community AllStar
01/05/12 9:48am PST
Latest post

You can map accounts now, and then the report will work for you. That only takes about 5 minutes.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • 12.0: contractor
  • us quickbooks enterpris...
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
JamesFMorgan
22 mins ago
JamesFMorgan
replied to
The Scoop on Making Changes...
Adityaa
1 hr ago
Adityaa
has a new Spotlight
Commodity brokers
JamesFMorgan
1 hr ago
JamesFMorgan
replied to
The Scoop on Making Changes...
JamesFMorgan
1 hr ago
JamesFMorgan
replied to
The Scoop on Making Changes...
DocRicketts
3 hrs ago
DocRicketts
posted
Non-profit organization 990...
Product Resources
QuickBooks Tax Products Payroll ProAdvisor Program Training and Certification Feedback Survey
Resources: Find Local ProAdvisor Tax Almanac Practice Resources
Support: QuickBooks Lacerte ProSeries EasyACCT
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business