Custom Inventory Report with Sales History for QuickBooks

Case Study: Inventory Intelligence

Client overview

Counterpoint Musical Services is a Canadian company dedicated to serving music retailers with fast, efficient and friendly personal service. They have built their business on the premise that nothing is more important than getting orders to their customers quickly:

We strive to ship all orders placed by noon on the same day. Think of us as your warehouse: we have no minimum orders you can order as little and as often as you need.” – Counterpoint Musical Services website

The Problem

Given their need for fast shipping, having sufficient inventory is crucial to Counterpoint’s operations. The question is always “How much product do we need to order today?” They’ve been using QuickBooks for over a decade and QuickBooks keeps very accurate inventory, but there is no way to see an item’s inventory levels alongside its sales history information. Without this supporting data, determining optimal ordering quantities is nearly impossible.

Here is an inventory report in QuickBooks:

 

Sample of an Inventory Report from QuickBooks

 

Kathleen Stokholm, manager and buyer for Counterpoint, had to order blindly for a decade! The company even attempted to implement Fishbowl Inventory hoping to get the data they needed – but after a year of struggling and $10,000 in lost capital, the attempt was abandoned.

 


The Solution

To provide their customers with the level of service that is central to their brand, Kathleen needs to know how much inventory to have on hand. The best way to determine this is to use historical trends – and this is where Clearify’s QQube really shines. QQube combines all transactions that affect inventory into a single subject area – making it possible to view sales AND inventory data together!

Custom Inventory Reports = Intelligent Purchasing

QQube even takes the sales orders for an assembly and calculates the number of individual parts needed to fulfill the assemblies on sales orders. This feature is what makes intelligent purchasing possible. And because many of Counterpoint’s products are sold both individually and as part of more than one assembly, we were able to display assembly sales history adjacent to the parts’ history.

With a spreadsheet mock-up of Kathleen’s ideal report, Datisfy experts got to work. We built the report of her dreams using QQube for QuickBooks as the data source and Crystal Reports to design the layout. We were even able to add Assemblies that use the specific parts – to look at their sales and inventory levels too. As an added bonus, Counterpoint can access the report with Logicity – a free Crystal Reports viewer – so they do not have to purchase SAP Crystal Reports.

 

Custom Inventory Report details side by side with Sales History on QuickBooks data

 


Testimonial

Wish I’d found Datisfy sooner! Datisfy has saved me hours of work and frustration. Thank you! – Kathleen’s Facebook comment

Datisfy created the report I’ve been wanting for years! This report saves me countless hours combining reports, cutting and pasting data together in Excel. I only wish I’d know this was possible sooner. Thanks.

Photo of happy Kathleen after she got her custom inventory report

Kathleen Stockholm
Manager and Buyer, Counterpoint Musical Services

 

 

 

 

Case Study: Consolidated Financials

The Problem

Client overview

Cochner Garvey Capital Partners, Inc. (CGCPI) is a Wichita-based private equity firm with an investment history of over 50 years, focusing its investment on middle market companies. CGCPI holds nine separate entities, each with its own QuickBooks company file.

 

QuickBooks limitations

CGCPI recently moved to QuickBooks Enterprise from Sage and FRX Reports and discovered a showstopper limitation. Within QuickBooks, it is not possible to get consolidated reports from more than one company file. Nor could QuickBooks be customized to provide financials for a partial owner entity.

CGCPI’s situation was even more complex because the account groupings needed to display in a different order and with different labels than in their chart of accounts.

With QuickBooks alone, the only way to consolidate financial reports for multiple company files is to export each P & L and Balance Sheet to a spreadsheet, manually cobble together the pieces and create conditional calculations. This would have to be done every month, a massive waste of time, with a process rife with the potential for error – and fraud.

 


The Solution

Single-click reporting

QQube for QuickBooks handles the issue of consolidation very simply: all QuickBooks company files loaded into the QQube data warehouse are available for reporting.

Once CGCPI provided their report layout sample, along with the custom account groupings, Datisfy used Crystal Reports to build the formulas and structure that result in an accurate, single-click consolidated income statement and balance sheet – including budgets. With the QQube Multiple Company Add-On, any number of company files can be accommodated.

If and when CGCPI invests in new entities, only minor edits will be required to include these new entities in the reports. This solution saves the team at CGCPI at least two days of effort every month, and enhances the reputation of the Director of Financial Reporting when she delivers the financials with such velocity, reliability and accuracy, month after month.

 


Testimonial

The Datisfy team was very successful in building the custom reports that we now use to consolidate several wholly-owned subsidiaries, one controlling interest, and a joint-venture with their respective parent companies. They were a very quick study once we finalized our requirements.

The reports are now in production and working as expected. Datisfy’s team members were always patient, very professional, and quite pleasant to work with.  I highly recommend Datisfy and their solution.

cindy

Cindy Ascanio
Director of Financial Reporting
CGCPI

 

Split Commissions – really

Companies have all kinds of ways of splitting and calculating commissions. The reason Datisfy exists today is because of an initial customer’s need to split commissions in QuickBooks data – without any manual involvement. We have now worked with three commission splitting situations that QB couldn’t handle internally. Nor could Xpanded Reports, which has now been defunct for just over a year.

Crystal Reports and QuickBooks

Just finished creating what I consider a simple report for a customer who uses QuickBooks. He was spending at least 5 hours a month manually generating commission reports for each member of the small group of sales reps in the company. It was extremely onerous. With a quick bit of research, I designed a report that he can run that does all the calculations, creates one page per rep, and then automatically emails the report to each rep – with a total of 3 clicks.

We get it, At this point in your career, every hour, even every minute you spend wrestling with a spreadsheet is costing your company a pretty penny. Datisfy is here to give you back what you need most - your time, improve your bottom line, and make you and your data look even more competent. Just like we did for these fine folks: