• 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   QuickBooks and Payroll   QuickBooks General Forum  
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
60
c6-2Me5CCr3QjyacfA8pyY
Subscribe RSS
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
Contributor
12/10/09 12:09pm PST
Viewed by asker 12/23/09 10:59am PST

How do I make an adjustment to COSG for a previous month?

US QuickBooks Pro for Windows : 2009

how do I make an adjustment to COGS for a previous month?

Solved!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
This post is closed to new replies
12 Replies
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar, Accountant Community AllStar
12/10/09 7:18pm PST

QuickBooks does not close the month. It allows you to enter any transactions for any dates. It is up to your company's policy if you should or should not modify last month's financial statements. If nobody looks at the end-of-month statements and reports, you just record the adjustment with last month's date. On the other hand if the company's management do look at/accept the end-of-month financial statements you should not change it by entering an adjustment for the last month. In this case you can record the transaction this month and in the memo field note that it adjusts last month's error/mistake.

Reka

Please mark the post Solved or give me a "thumbs up" if I could help.
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
 
 
 
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
Contributor
12/11/09 5:20am PST

Thank you, but I understand that part.  What I want to do is remove $159.00 from COGS in August because that amount was actually booked thru credit card charges as an inventory asset and now my COGS is overstated by that amount.  Do I use a journal entry to remove it and if so, how?

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
 
 
 
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar, Accountant Community AllStar
12/11/09 7:00am PST

So your COGS is overstated. What is understated? Your inventory?

Could you describe in more detail how did you booked the credit card charges?

Reka

Please mark the post Solved or give me a "thumbs up" if I could help.
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
 
 
 
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
Contributor
12/11/09 7:22am PST

Here's what I did. When I purchased this item (which was specific for a customers Job) I paid for it with my credit card, and thus entered the credit card charges.  I enter these purchases as Inventory Assets, but I mistakenly associated a cost with the item in my system so when I sold it it booked into COGS.  It should have been in the system as -0- cost, so now I have this amount in the COGS account and the credit card charges account as an Inventory Asset, does that help?  I can't figure out how to remove the amount from COGS. 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
 
 
 
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar, Accountant Community AllStar
12/11/09 9:03am PST

When you entered it as a credit card charge have you used the Expenses tab or the Items tab?

Please mark the post Solved or give me a "thumbs up" if I could help.
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
 
 
 
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
Contributor
12/11/09 9:08am PST

We used expenses tab

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
 
 
 
Mt Juliet CPA
Mt Juliet CPA
Questions asked: 62
Questions answered: 13754
Points earned: 29491
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Mt Juliet CPA
Mt Juliet CPA
Questions asked: 62
Questions answered: 13754
Points earned: 29491
Accountant Community AllStar
12/11/09 10:02am PST

Based upon the problem you have I would recommend that you make a journal entry to make the correction

I salute all our current Military and our Veterans.
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
 
 
 
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
Contributor
12/11/09 10:04am PST

That's my problem I don't know how to make a journal entry to correct it. 

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
 
 
 
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar, Accountant Community AllStar
12/11/09 10:44am PST

Sorry for the long delay - my boss took me out for lunch. I could not refuse.

As far as I understand now: when you purchased the item you debited (increased) your COGS, not inventory (because of using the Expenses and not an Item). I should have asked at the same time: how have you recorded the sale? Have you used a deposit? Have you used invoice/sales receipt? If you used invoice/sales receipt the item you used did have a cost associated with it or not? If you go to the invoice/sales receipt and click on Journal at the top (or Ctr + Y) you will see the journal entry. I would like you to look at that and check if there was anything put/taken away from Inventory. I would not mind if you could give me the accounts and the amounts with noting if it was a credit or debit.

I really would like to help but I cannot without knowing what is in your books.

Reka

Please mark the post Solved or give me a "thumbs up" if I could help.
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
 
 
 
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
Contributor
12/11/09 11:04am PST

Not a problem, I appreciate you trying to help, besides you can never turn down a lunch offer :)  I created an invoice for the sale of the product.  There was a cost associated with the sale, which is where I was wrong (I think).  Here is the transaction journal for this invoice:

Accounts Receivable $169.89

Merchandise sales  -$159.90

Inventory Asset         -$159.90

Cost of Good Sold    $159.90

Sales Tax Payable  $9.99

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
 
 
 
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
RekaUjj
RekaUjj
Questions asked: 2
Questions answered: 2938
Points earned: 8058
Allstar, Accountant Community AllStar
12/11/09 11:27am PST
The solution

You are right. You double - recorded COGS (once with the credit card charge and once with the invoice) and you have never put the item into inventory but you got it out from there (at least in QuickBooks - I don't think it is possible physically). So the journal entry is the following:

Inventory Asset   159.90

Cost of Goods Sold     -159.90

This should do the tricks.

Reka

Please mark the post Solved or give me a "thumbs up" if I could help.
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
 
 
 
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
kjw1998
kjw1998
Questions asked: 40
Questions answered: 4
Points earned: 5
Contributor
12/11/09 11:36am PST
Latest post

Thank you so much, that fixed my problem!!  I really appreciate your help, have a great weekend!

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
 
 
 
   
 
 
Subscribe RSS
Tags for this topic
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
John68
1 min ago
John68
replied to
Cash and Register
EricPOS
5 mins ago
EricPOS
replied to
Cost adjustments not showin...
PatrickCatIntuit
9 mins ago
PatrickCatIntuit
replied to
When will the 1065 be accep...
Kimmonroe625
16 mins ago
Kimmonroe625
posted
P & L Reports Changing
Skimper13
17 mins ago
Skimper13
replied to
POS TO QUICKBOOKS
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