• 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   Inventory  
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
239
blPp9Gu6yr4yUOacwZ5xHE
Subscribe RSS
Bucks13
Bucks13
Questions asked: 3
Questions answered: 10
Points earned: 10
Bucks13
Bucks13
Questions asked: 3
Questions answered: 10
Points earned: 10
New Member
02/09/12 9:15pm PST
Viewed by asker 02/10/12 2:49pm PST

Need help with inventory adjustment details

US QuickBooks Pro for Windows : 2011

I  have a "clean" QB Pro 2011 file that  was created using Intuit's procedure for creating a new, clean copy of a company file. It's empty in that there are no transactions, zero inventory, etc. But, the chart of accounts and item list is correct (in that all the accounts and items are there but with zero quantities).

I've learned that there is no way to import a beginning inventory if the inventory items are already in the item list. And I've learned that the only way I can enter my beginning inventory for my new company file is through inventory adjustments.

BUT all of the answers just say "do an item adjustment..." without much more in the way of detail and the same is true of the QB help files.

I need to get my beginning inventory and the average cost of that beginning inventory into QB.

Example: Looking at the item list I see Inventory Item A with a list cost of $2.00, average cost of zero and zero on hand. I need to enter my beginning inventory of 10 units with an average cost of $2.50 as of 1/1/12.

On the inventory adjustment screen, if I just enter 10 into the current quantity on hand, I see a "total value of the adjustment" of $20. That's not right. If I use Quantity&Value Adjustment, I see "total value of adjustment" of $25. But where is that value going? Where is that value coming from?   I also see a drop down list for "Adjustment Account" but I have NO idea what to select here. Do I have to create that account? What kind of account is it? How do I set that account up?

Any detailed help would be greatly appreciated!

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
1 Reply
Rustler
Rustler
Questions asked: 129
Questions answered: 41407
Points earned: 102634
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Rustler
Rustler
Questions asked: 129
Questions answered: 41407
Points earned: 102634
Allstar
02/10/12 3:13am PST
Latest post

 When you make a starting inventory adjustment and when the items are already created

1. set the type adjustment to qty and value
2. set the adjusting account to owner equity (if a sole-P) or opening balance equity if more than one owner

3. for each item

enter the total value in the new total value column, THEN enter the qty in the new total quantity column

 The total value of assets on hand is equity, as is the total value of liabilities owed (but they reduce equity)

If I've helped, mark it solved.

My QB tips Blog >> http://onsale-apparel.com/Rust...

When the majority, who cannot think for themselves, overwhelm the minority who can, you get ... convention.
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
  • 2011
  • us quickbooks pro for w...
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
reaston
1 min ago
reaston
posted
Weird files: what are they,...
ghlindacpa
3 mins ago
ghlindacpa
replied to
payroll report
Rutledge
7 mins ago
Rutledge
posted
QB 2012 To Do List due dates
GoPaySabrina
8 mins ago
GoPaySabrina
replied to
Change print color on recei...
Memere
9 mins ago
Memere
replied to
Payroll Limits
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