News & Special Offers

QuickBooks Sale!

Dell All-in-One w/touchscreen

Dell Inspiron One All-In-One Computer / AMD Athlon II X2 Processor

QuickBooks

QuickBooks Help

How to Reconcile your 1099-K to your QuickBooks Data

Hi Ruth-

We received our 1099K from the QuickBooks Merchant Providers (Innovative Merchant Solutions LLC). We also see on our corporate return (IRS Form 1120) that starting next year we will need to enter the amount of funds we received from the merchant provider per the 1099K, then also enter the amount received through non-merchant transactions. Since we are on an accrual basis, have a huge amount of accounts receivable per month and also deal with sales tax, going from our bottom line on our P and L to calculating the amount received through non-merchant transactions and the amount on the 1099K will be an astronomical task. The IRS’ definition of Gross Sales will also make this task difficult. We will be required to add back in each return. This will have to be done with a review of each days receipts. Fortunately we have not done summary entries into QuickBooks financial and have all the detail there. Is QuickBooks working on a solution for this? Especially since we have QuickBooks POS, QuickBooks Financial and QuickBooks Merchant Services, we are hoping there is a work around or a report that calculates this in our future. Fortunately it is not required this year or we would be scrambling to reconcile things. Given our volume of transactions, we cannot wait until the end of next January, when we receive our 1099K, to reconcile this amount and have our information to the CPA by mid February, in order for them to do our return by 3/15. We will probably tackle this as each merchant statement posts, but this is still a HUGE task. Please review form 1120 and the instructions as needed. Having a work around available would be a HUGE incentive to going 100% QuickBooks (Financial, POS and Merchant Services). A big selling point I would think. Since you are so well connected with QuickBooks I thought I’d start by asking you.

Trying not to panic…

You can change the reporting basis on your reports to cash by selecting Customize Report and then select Cash. Even better, you can also create a custom transaction detail report, filter for Sales Receipts and Payments, add a Payment Method column, and then Total by Payment Method. That should give you what you’re looking for.


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, Inc. and has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.


QuickBooks price list | QuickBooks Sale | Free trial of QuickBooks POS | Free trial of QuickBooks Enterprise

How to Get an Account Report in QuickBooks

I’ve signed up for a 30-day trial of QuickBooks 2012. I want to know how to get the information about expenses that I’ve inputted organized into reports by account; I’ve set up several custom accounts.

I am happy to pay for this information and instruction on how to create these reports. If I can make this system work for me, I’ll buy the software from you. Otherwise, I’ll have to move on to another solution, even though my accountant has told me I ‘have to’ use QuickBooks!

I’d like help ASAP – my deadline for getting this project done was end of this weekends, and it doesn’t look like I’m going to make it! Many thanks –

If these are revenue or expense account, go to the chart of account and double-click on the account to bring up a Quick Report.  If these are balance sheet accounts, you’ll get a register instead but you can double-click on the amount next to an account on Balance Sheet report.  You can do this on pretty much any report to get a list of the transactions making up the amount.

 


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, Inc. and has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.


QuickBooks price list | QuickBooks Sale | Free trial of QuickBooks POS | Free trial of QuickBooks Enterprise

How to Change your Update Name and Spelling Preferences in QuickBooks

Dear Ruth. I presently have QuickBooks 2011. When I am in invoices and go to print off the invoice a text box will come up before I close to tell me I changed the information and I have to go through all the spelling changes and what not…is there a way to avoid this? Thank you very much for your time.

Go to Edit > Preferences > General, select the Company Preferences tab and check the box next to Never update name information when saving transactions.

quickbooks sale

You can also change your spelling preferences in Edit > Preferences > Spelling, select the My Preference tab and uncheck the box next to Always check spelling printing, saving or sending supported forms.

quickbooks sale


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, Inc. and has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.


QuickBooks price list | QuickBooks Sale | Free trial of QuickBooks POS | Free trial of QuickBooks Enterprise

How to Use QuickBooks for Job Costing

Hey Ruth, How have you been?

What in your opinion is the best way to job cost in as much detail as possible in QuickBooks Enterprise? I am having some issues getting it to all come out right

It’s all about the items. Here’s a blog series I wrote about job costing in 2009. Not much has changed since then:

How to Setup Preferences and Items for Job Costing in QuickBooks
How to Work with Estimates for Job Costing in QuickBooks
How to Setup Payroll for Job Costing in QuickBooks


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, Inc. and has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.


QuickBooks price list | QuickBooks Sale | Free trial of QuickBooks POS | Free trial of QuickBooks Enterprise