7 Tips on Preparing Commissions in QuickBooks: Setup, getting invoices by paid date and data extracton tools ...and much more!

This book was written to show you how to configure QuickBooks to be able to process commissions quickly and accurately for your sales reps. Clem Dominguez, the author, has spent fifteen years designing and developing software for the commission industry, specifically for QuickBooks Desktop. In that time he has sold and installed over twelve hundred software packages. With that many installations he has seen and solved just about every issue that a customer can have trying to do commissions with QuickBooks Desktop.
How do I get the proper costs when I’m calculating commissions using the gross profit method? Is there a way to just export paid invoices for a certain reporting period using the QuickBooks tools? When is it time to trade in my excel spreadsheet for a commission software package? And what about splitting commissions among reps, can I do it by percentage and amount? What about management overrides? Is that even possible in Quickbooks? You’ll not only learn all these things but you’ll see how to use various tools on the market that can help you process your commissions in a timely manner.
In addition you’ll find out how and why using Jobs can make calculating commission very difficult, and some solutions to help you.. You’ll also get some ideas on how commissions are done for the promotional industry, and what problems you could encounter along the way. You’ll learn about draws, recoverable and non-recoverable. And of course you’ll have a chance to see some commission statements and reports. What do reps like to see and what format do they like to see their reports in? The author also shows you some custom reports he has designed for customers over the years. This way you can design your own reports, or at least know what to ask before you purchase a software package to be sure it suits your needs. There are also tips and methods that show you how to send your data up to QuickBooks as a bill, so you can automate the payment process to save time and money. .
While this book was primarily written for the accounts payable person actually processing commissions, it is extremely useful for programmers or excel gurus assigned to develop a system for the company to do commissions. The author, a programmer with over thirty years’ experience, explains why he programmed certain features the way he did, using Commtrack, the commission program he developed. He shares with you some things he did well and some things not so good. Then he shows you other possible solutions to these problems which he believes are much better.
If you’re the one assigned to do commissions using QuickBooks Desktop, this book can make you a hero. Not only will it show you the best possible solutions available to you, but more importantly it will show you the many pitfalls to avoid trying to get commissions done with QuickBooks. Buy it; you’ll be glad you did!