Enhanced QuickBooks Reporting

Challenge: Reports from QuickBooks often do not provide sufficient analysis, and clients are exporting QuickBooks report data into Microsoft Excel for further processing. This client, a bond agency, had a QuickBooks report which detailed all the bonds for which commissions were paid - but the QuickBooks report did not provide a report detailing which bonds had not been paid commissions. The client was manually reviewing the QuickBooks report line by line to determine commissions owed.

Solution: A Microsoft Excel VBA program to take the QuickBooks export and provide three views into the data - a total Commissions Summary report, a Commissions Owed report and a Commission Paid Report.

The programming takes less than 5 seconds to run, and totally eliminates manual review of hundreds of lines of bonds.