Huge Savings
Get our price list!
Buy with Confidence
from a Premier Intuit Reseller
Free Shipping
Direct from Intuit
No Sales Tax
(in some states)
Try it free for 30 days

Monthly Archives: January 2012

How to Find your Cost of Inventory in QuickBooks Point of Sale

How do I find my cost of inventory in QuickBooks Point of Sale for the end of the year?

The inventory valuation report (in Reports > Items) will tell you the value of your inventory as of a certain date. Make sure to change the date to 12/31/11 if you want the year-end valuation.

Get free QuickBooks support and training!
LinkedIn   Google+   FaceBook

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.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman

Ruth is the an Intuit Premier Reseller that offers great deals on QuickBooks POS and QuickBooks Enterprise. She has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Visit our webstore for great deals on QuickBooks and QuickBooks POS!

How to Find a Missing Invoice in QuickBook

Hi Ruth. We cannot find an invoice in the system; ie invoice 549. What does it mean?

Thanks for your help.

It usually means it was deleted, but it’s possible someone changed the invoice number skipping 549. You can get a report of deleted/voided transactions by user in Reports > Accountant & Taxes.

Are you positive it’s missing? The easiest way to get a list of all your invoices, go to the Customer Center, select the Transactions tab and then select Invoices. Click on the Num column to sort by Invoice #.


Get free QuickBooks support and training!
LinkedIn   Google+   FaceBook

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.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman

Ruth is the an Intuit Premier Reseller that offers great deals on QuickBooks POS and QuickBooks Enterprise. She has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Visit our webstore for great deals on QuickBooks and QuickBooks POS!

How to Reduce the Burden of Doing Payroll and Still Be Able to Do Job Costing in QuickBooks

Hello Ruth,

I came across some of your blogs online and am wondering if you can help me.

I own a paint company. Since starting the business, all I’ve ever used was QuickBooks. We’ve grown over the past 8 years to 44 employees and now I’m using QuickBooks Enterprise Solutions: Contractor 12.0. Another thing to note is that we are performing work on projects that require us to submit weekly Certified Payroll Reports every week. For this I have been using Sunburst Software Solutions-Certified Payroll Solution (this software pulls the data from QuickBooks and puts everything into the Certified Payroll Reports so that all I have to do is print them out). Everything was going fine with that except for the fact that it was always me doing the payroll every week. To take some of my workload off of me, I ended up deciding to go with an outside company to do all of the payroll (ADP). They assured me that I would be able to easily import the data into QuickBooks as if I had done the payroll myself. This sounded awesome to me seeing that they would be printing/stuffing the checks, paying all of the payroll liabilities, garnishments, filing all of the tax reporting and offering their HR resources to keep up compliant. All I would have to do is enter the employee time online, along with any changes.

Well, this week will be our 3rd payroll that ADP will have completed for us. The implementation process (where ADP works to matchup lines in the Chart of Accounts so that the report that is imported into QuickBooks can be read by the QuickBooks file) took a while for them to complete, but was finally done this past Friday. I came in this past Saturday to import these into QuickBooks to find that it was all under a General Ledger. So far, it appears that the job costs are matching up to the correct jobs, but the problem that I’m having now is that the software that I was using to do the Certified Payroll Reporting is not picking up the data from QuickBooks. I called tech support for the Certified Payroll Software this morning. The lady that I spoke with advised me that the software only works if you are doing your payroll from QuickBooks, not if you’re using an outside payroll service. She then went on to tell me that more than likely the reports that I’m importing into QuickBooks from ADP are not accurately assigning the job costs.

Right now, I’m totally lost. I feel like I may have made a big mistake that cost me a lot of time to get set up to begin with, but now is going to cost me even more time, headache and confusion.

Please help me.

I have an accountant that I use, but he just does our corporate return and helps me out from time to time when I have questions. I’m waiting for him to call me, but he won’t be free to talk til sometime later this afternoon.

Any help, advice or suggestions would be greatly appreciated.

Unfortunately, Nancy is correct. ADP can map payroll only to the GL not items, and most job costing requires the use of items.

However, Intuit’s Assisted Payroll handles jb costing perfectly, and like ADP will take much of the payroll burden off you.


Get free QuickBooks support and training!
LinkedIn   Google+   FaceBook

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.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman

Ruth is the an Intuit Premier Reseller that offers great deals on QuickBooks POS and QuickBooks Enterprise. She has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Visit our webstore for great deals on QuickBooks and QuickBooks POS!

How to Print a Picking Ticket for a Portion of a Sales Order in QuickBooks

Ruth, Is it possible for me to print a picking ticket for a portion of a sales order?

If you check the box in the Clsd column, it won’t print the item on the pick list. However, make sure to select No when it asks you if you want to save the sales order before printing it. If you accidentally select Yes, make sure to uncheck the box to open it again.

Get free QuickBooks support and training!
LinkedIn   Google+   FaceBook

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.

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman

Ruth is the an Intuit Premier Reseller that offers great deals on QuickBooks POS and QuickBooks Enterprise. She has provided expert QuickBooks help to thousands of businesses all over the world since 1996.

Visit our webstore for great deals on QuickBooks and QuickBooks POS!