• Was this page helpful?
Intuit Blog
|
Support
Point of Sale
|
GoPayment
|
Payroll
|
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   Importing & Exporting Data  
hide
02/10/2012 at 03:34PM PST
Emails titled "QuickBooks security notice," "Quickbooks update" or "Tax Information Needed within 30 days" were not sent from Intuit and should be considered harmful. If you ever wonder whether an e-mail from Intuit is real or fake, please refer to the link below.

Thank you

http://security.intuit.com/security-alerts.php
70
214
cX8M0J1wer3QjyacfA8pyY
Subscribe RSS
TeriChemtech
TeriChemtech
Questions asked: 4
Questions answered: 3
Points earned: 3
TeriChemtech
TeriChemtech
Questions asked: 4
Questions answered: 3
Points earned: 3
New Member
11/19/09 3:25pm PST
Viewed by asker 11/23/09 1:43pm PST

Entering Inv detail from MAS90 to Quick BOoks

US QuickBooks Pro for Windows

How do I enter Begin. inv. items from MAS90 to QB in detail? Moving from MAS90 to QB and I have all beg bal entered except this.

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
2 Replies
gusb83
gusb83
Questions asked: 5
Questions answered: 341
Points earned: 999
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Allstar
Allstar
Advisory council of community power users.
gusb83
gusb83
Questions asked: 5
Questions answered: 341
Points earned: 999
Allstar
11/20/09 3:16am PST
Best Answer - Chosen by the Community

 There are two ways to do this: one you can make a bill for the items from a vendor and include the original price of the items that you paid or you can enter the amount manually for every item and change the cost.

When you make the original items for your inventory parts be sure that you leave the section that says "cost" at 0 and only include a number in the "sales" section or your revenue will not carry over. When you purchase the item for the first time a little pop up will ask you if you want to update the value and click yes. Enter all of the items in the bill and select close. If you pull up your inventory item, the cost will be updated. When you purchase another item from vendor, the average cost will be calculated based on the purchase price and the amount currently in inventory. 

The best way is to do an inventory adjustment. After you have your items set up click on the inventory adjustment window and select the value adjustment box, enter the current quantity on hand and total value from your inventory valuation report. For the adjustment account choose "Owner's Equity", ignore the warning that will pop up and quickbooks will automatically calculate the average charge of the item.

Here are a few tips for you to keep in mind when you set this up on QuickBooks. Start by entering the balances from your Balance Sheet (minus A/R, A/P, Inventory, Sales Tax Liabilities). Second enter the balances from your P&L minus revenue and use retained earnings as your credit offset. The only accounts that you CANNOT do a journal entry to enter beginning balances for are Accounts Payable, Accounts Receivable, Sales Tax Liability, Payroll Liabilities (if you use QuickBooks Payroll) and Inventory. For A/R find the open customer invoices, make an other charge item called "opening balance" and link that up to your retained earnings (or income/sales if you want to be specific). Use this item for every open invoice that you have. With Open A/P use the same item "opening balance" just be careful not to post the expense twice. Subtract the amount of revenue from the open invoices from the total revenue (Open-Total) and use this amount to credit Sales/Income and debit retained earnings. If you run your P&L you should see that everything should be there. Next thing you are going to do is do an adjustment for sales tax owed. (the hard part) You have to set up all of your taxable and non-taxble items as well as sales tax amounts. Click on the icon that says "pay sales tax" and select the sales tax liability account as the adjustment account and enter the amount that is due for every agency as well as when they are due. Finally you have to reconcile your payroll liabilities and expenses through various journal entries.

I do installs/troubleshooting for a living and the first time is always a pain because if you don't have all of the information nothing is going to show up on your reports properly and 9 times out of 10 the retained earnings doesn't balance. There is a big learning curve with QuickBooks. Dont be afraid to ask questions and good luck.     

Hope this helps. If so please mark as SOLVED and rate the answer. If you live in LA look me up on the ProAdvisor website.
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
5
Reply to this Answer
 Report Abuse
 
 
 
TeriChemtech
TeriChemtech
Questions asked: 4
Questions answered: 3
Points earned: 3
TeriChemtech
TeriChemtech
Questions asked: 4
Questions answered: 3
Points earned: 3
New Member
11/20/09 2:38pm PST
Latest post

I believe I understand what you are saying but since I have already done everything using the opening equity account which is zeroed out after all the beginning information is input, do I select that as my offset account rather than Owner's equity?    I have six inventory accounts so how do I know that this adjustment is going to the correct inventory account.

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
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
woneill1450
10 mins ago
woneill1450
replied to
Password
woneill1450
12 mins ago
woneill1450
replied to
registration of qb 2010 tha...
woneill1450
14 mins ago
woneill1450
replied to
multiple computers
AngelBK
14 mins ago
AngelBK
posted
what quickbook product is b...
AngelBK
15 mins ago
AngelBK
posted
what quickbook product is b...
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