• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
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 with Intuit Products   Quickbooks Tasks   Journal Entries & Accounting Tasks  
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.
70
242
atTIJzkIqr4kAbacfA8pyY
Subscribe RSS
rosel
rosel
Questions asked: 98
Questions answered: 29
Points earned: 29
rosel
rosel
Questions asked: 98
Questions answered: 29
Points earned: 29
Contributor
01/27/11 6:46am PST
Viewed by asker 11/29/11 4:20am PST

CHANGING REPORT FIGURES

US QuickBooks Pro for Windows : 2007

I REALLY need help!!! regarding reports

My employer needs me to help him (get back to an original amount for consulting income for year 2009 before he does the taxes for 2010.) There is a difference of $1325.93 which I do not know HOW to retrieve!!! HELP!!!...rosel

Solved!
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
10 Replies
mbw33701
mbw33701
Questions asked: 15
Questions answered: 273
Points earned: 635
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
mbw33701
mbw33701
Questions asked: 15
Questions answered: 273
Points earned: 635
Contributor
01/27/11 6:57am PST

You might be able to find what changed in the reports>Accountant>audit trail, but since it's so far back that might be information overload.

If you have a copy of the prior year balance sheet, I'd check to see if you are equally as off on the balance sheet somewhere.

 

 

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
 
 
 
rosel
rosel
Questions asked: 98
Questions answered: 29
Points earned: 29
Contributor
01/27/11 7:34am PST

 

Thanks for such quick response. No, accountant>audit trail didn't really help me, and I wasn't off by the same amount the prior year. I do know where a possible missing amount is....but, I can't get to it. You see, several invoices were credited after my employer paid 2009 taxes, which now show up as that. In my attempts to get back to original amount for him, I voided the credited ones....all except for one amount (which I can't get a hold of)

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
 
 
 
mbw33701
mbw33701
Questions asked: 15
Questions answered: 273
Points earned: 635
Contributor
01/27/11 8:35am PST

OK - then you have a cash vs accrual issue.   If the company was cash basis, then you probably just needed to change the basis of the report if it is currently showing accrual.   

 

To look for a specific dollar amount in a deposit, go to reports>banking>deposit detail and look for the date range in question.

To look for a specific invoice amount, go to reports> customers and receivables> customer balance detail and you can either sort the report by dollar amount or modify the report for the amount range you are looking for.

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
 
 
 
rosel
rosel
Questions asked: 98
Questions answered: 29
Points earned: 29
Contributor
01/27/11 11:19am PST

Thanks for the help. My employer said it was accrual.

So, you see, I assigned an invoice number to the avail credit (leftover). MY employer said that money should be used as consulting income. Well, that's why I put it into an invoice number and it went into the next year's income. Now, I know I can change the date and put it back into 2009, but that will increase the total consulting amount by that much ($1325.93) again! And, I need that total amount to decrease. I am so sorry I don't know enough to make this clear. But, any other thoughts? And, thanks for all your consideration/patience!!!...rosel 

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
 
 
 
mbw33701
mbw33701
Questions asked: 15
Questions answered: 273
Points earned: 635
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
mbw33701
mbw33701
Questions asked: 15
Questions answered: 273
Points earned: 635
Contributor
01/27/11 12:18pm PST

If you know the client that it goes to and the amount, you could try entering a credit memo to that client for 2009 or create a journal entry dated 12/31/09 debiting consulting fees (if you need it to go down) and post a credit to a/r if that's where the issue was.  You can also create a liability account for "Due to customers" to credit that amount to.   I would lable it PPA (prior period adjustment) and make sure the description is clear.   Might be too simple of a solution - I don't know. 

FYI - At the end of every year I print out a P&L and Balance sheet when I do the tax return so I know exactly what was there when I did the return.  That way, any changes can at least be narrowed down to the accounts involved so if I do need to make a journal entry, I know what accounts to use.  

Hopefully this helps.

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
 
 
 
rosel
rosel
Questions asked: 98
Questions answered: 29
Points earned: 29
Contributor
01/28/11 4:57am PST

Dear mbw33701... I DO think this is the answer I needed...And, if I need help doing a journal entry, I may be back asking questions there. (I've never done one before, but I will follow instructions)...THANK YOU SO VERY MUCH...rosel

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
 
 
 
mbw33701
mbw33701
Questions asked: 15
Questions answered: 273
Points earned: 635
Contributor
01/28/11 5:43am PST
The solution

Glad to be of assistance.  If this solved your issue, please be sure to check solved. 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
10
 Report Abuse
 
 
 
rosel
rosel
Questions asked: 98
Questions answered: 29
Points earned: 29
Contributor
01/28/11 7:47am PST

Dear mbw33701...Yes, I have what I needed. I will mark this solved, but I'm wondering...The amount of $1325.93 originally was left as avail. cred., but PO closed, etc. and I then changed the amount to an invoice number, using it as consulting income, dated in 2010.  (The amount is still in 2010 as #2221 for $1325.95.) What I need to know is, since my problem is solved by a journal entry whereby I debited that amount in consulting income (taking it out) and then credited it to accounts receivable in the year of 2009 (which, really is where I needed it to be placed in the first place...NOT in 2010!) what do I do with #2221 in 2010 for $1325.93? Note: There is only one amount listed as $1325.93 and that is registered in accounts receivable in 2009 where it needs to be! AND THANKS SO VERY MUCH!!!

 

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
 
 
 
mbw33701
mbw33701
Questions asked: 15
Questions answered: 273
Points earned: 635
Contributor
01/28/11 8:40am PST

I'm not sure I'm following you, but you could go back in to the adjusting entry you made and click on the box to reverse it so it posts the opposite entry as of 1/1/10.  Again, I'm not sure I'm following you, but if you don't need invoice #2221, then you can void the invoice.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
5
 Report Abuse
 
 
 
rosel
rosel
Questions asked: 98
Questions answered: 29
Points earned: 29
Contributor
01/28/11 8:51am PST
Latest post

Dear mbw33701...I know I sound so convoluted! I will think about this answer and let you know.....I kind of don't think I need inv.#2221, so that might be the answer there! Once again, THANKS SO MUCH!...rosel

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
  • quickbooks pro for windows
  • 2007
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
Clydie
1 min ago
Clydie
posted
When can I expect my websit...
knuffmdl
2 mins ago
knuffmdl
replied to
getting started
RussJK
3 mins ago
RussJK
just received a solution to
Need to add additional LLC ...
Gaca
4 mins ago
Gaca
replied to
Setting up a vehicle loan
knuffmdl
4 mins ago
knuffmdl
replied to
New Hire Form
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