How to Mass Edit the Account Used on Transactions in QuickBooks
Published 12/31/2012 | 
Thanks
If not, the only way mass edit transactions is with client data review. Unfortunately, it’s only available in the QuickBooks Accountant edition.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
How to Handle Inventory Transactions Entered in QuickBooks in QuickBooks POS
Published 12/30/2012 | We are a screen printing business – have been doing this for 8 years. Have used quick books all along. Now I am on QuickBooks Premier Manufacturing and Wholesale 2012 addition. Works GREAT. Customer calls, orders shirts, we turn the estimate into a purchase order, do the job, turn the estimate into an invoice. Easy!!!
With the addition of retail area and adding QuickBooks Point of Sale –
I am being told by some –
(1) all inventory MUST run through QuickBooks POS.
(2) Others have said, no, you can run it like 2 businesses. Keep the “shop” part running exactly as we have for past 8 years. For the retail area – when you buy for retail, create PO, run through the defined process – sell using QuickBooks POS, the software will communicate with QuickBooks Premier and all is good. If someone decides they want embellishment on retail item, I do a work order – send it back to the shop, when done, run it through QuickBooks POS sale. Let the software communicate and all is good.
At the end of the year – give the accountant the copy of the books as normal.
In addition, give the account a “Inventory Valuation Report” from QuickBooks Point of Sale.
My question (or validation) is, are they right? Can I run it like scenario #2? I would hate to be doing that until tax time only to find out I am in deep water with the accountant!!!
Also, if you download your inventory from QuickBooks into QuickBooks POS, which is the easiest way to add your inventory, it’ll zero out your on-hand quantities in QuickBooks, in an attempt to stop you from using them in QuickBooks, so you don’t screw up your on-hand quantities in QuickBooks POS.
QuickBooks POS Pro has sales orders, work orders and layaways, so I recommend running your work orders through POS as well as your retail sales. If you’re using non-inventory or service items for your work orders, you can safely process them in QuickBooks because they have no on-hand quantities, but you’ll have difficulty reconciling sales in QuickBooks POS to sales in QuickBooks unless you use separate revenue accounts for retail and work orders.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
How to Edit Old Account Numbers in QuickBooks
Published 12/29/2012 | I am classing and merging accounts by transaction. I then also had to enter new account numbers to use instead of the old account numbers. In the middle of this moving and changing, which goes back to 2011, I was hoping for a more efficent way of doing this that would be more time effective.
If I edit the old account numbers and put in the numbers I am worried I might lose data. Also the names of the accounts are different too, so I really could lose data. The only way I know to do these changes is to go transaction by transaction, so I don’t lose any data.
I recommend backing up your file before starting so you can restore the backup if it doesn’t go well. Also, if you’ve already filed your 2011 taxes, make sure the trial balance as of 12/31/11 hasn’t changed. If it has, use a journal entry to restore the original balances and reverse it in 2012.
Good luck!
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
News Flash – Week 13 Winners Announced for Free QuickBooks 2013 Giveaway
Published 12/28/2012 | Enter to Win Free QuickBooks 2013 Software
We are thrilled to announce that once again Intuit has chosen us to give away free QuickBooks 2013!
Between Laura Madeira, Bonnie Nagayama, Michelle Long, Radio Free QuickBooks and I, we’re giving away nearly $65,000 in QuickBooks this year. I’m just blown away by Intuit’s generosity!
Here’s what you could win:
- 1 copy of QuickBooks Enterprise 13.0 5 users – MRSP $3,000.00
- 1 QuickBooks ProAdvisor with Payroll annual membership – MSRP $799.00
- 1 of 5 copies of QuickBooks Accountant 2013 – MSRP $499.95
- 1 of 5 copies of QuickBooks Premier 2013 – MSRP $399.95
- 1 of 5 copies of QuickBooks Professional Bookkeeper 2013 – MSRP $399.95
- 1 of 5 copies of QuickBooks Pro 2013 – MSRP $249.95
- 1 of 5 copies of QuickBooks Mac 2013 – MSRP $249.95
Our contest is over but here are more chances to win:
- Enter Laura Madeira’s Giveaway
- Enter Bonnie Nagayama’s Giveaway
- Enter Michelle Long’s Giveaway
- Enter Radio Free QuickBooks’ Giveaway
October 3rd winners:
- Ken Schupp – QuickBooks Accountant 2013
- Christy Fruits – QuickBooks Accountant 2013
October 10th winners:
- Dennis Finn – QuickBooks Accountant 2013
- Stan Gloekner – QuickBooks Professional Bookkeeper 2013
October 17th winners:
- Keith Gormezano – QuickBooks Accountant 2013
- Leslie Carney – QuickBooks Premier 2013
October 24th winners:
- Jeffrey Kaufman – QuickBooks Accountant 2013
- Timmerle Kelly – QuickBooks Premier 2013
October 31st winners:
- Kathy Tweeten – QuickBooks Pro 2013
- Paula Zirdung – QuickBooks Premier 2013
November 7th winners:
- Jeanne Ellenwood – QuickBooks Premier 2013
- Debi Paulen – QuickBooks Premier 2013
November 14th winners:
- Saroj Kalgaonkar – QuickBooks Pro 2013
- Renee Phillips – QuickBooks Professional Bookkeeper 2013
November 21st winners:
- Betty McMaster – QuickBooks Professional Bookkeeper 2013
- Jonathan Kaplow – QuickBooks Professional Bookkeeper 2013
November 28th winners:
- Catherine Colman – QuickBooks Professional Bookkeeper 2013
- Joe Ndile – QuickBooks Pro 2013
December 5th winners:
- Caren Schwartz – QuickBooks Pro 2013
- Ellen Bertram – QuickBooks Pro 2013
December 12th winners:
- Linda Looney – QuickBooks Mac 2013
- Howard Schoenfeld – QuickBooks Mac 2013
- Kelly Langlie – QuickBooks Mac 2013
- Lee Edwards – QuickBooks Mac 2013
- Linda Pitts – QuickBooks Mac 2013
December 12th winner:
- Jeffrey Wolter – QuickBooks ProAdvisor membership w/payroll
December 19th winner:
- Leah Hoffpauir – 5 user QuickBooks Enterprise 13.0
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.
Written by +Ruth Perryman, CMA, CFE, CFM, MBA
Ruth is the president of The QB Specialists, an Intuit Premier Reseller that offers huge savings and expert advice on QuickBooks POS and QuickBooks Enterprise. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks POS and QuickBooks Enterprise and has provided expert QuickBooks help to thousands of businesses all over the world since 1996.
Web Store | Price List | Free Trials | Newsletter
Recent Comments