How to Reconcile your 1099-K to your QuickBooks Data
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…
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 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 –
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
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.
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
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
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
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



