Tip #1206 – dynaMACS Quarterly Tax Reporting

In dynaMACS Sales IQ you can retrieve quarterly commission numbers which can assist you in expediting your tax reporting.  If you need to report by state, you can do so by using the Sales Analysis reports feature OR filter by state/region in Sales IQ.

Sales IQ Agency Comm (3Mos) – Example

In the following example we will generate a report using Sales IQ for quarterly commissions by manufacturer for commissions received July – September 2012.

  1. From Manufacturers tab in the Sales IQ screen select Commissions Received from the Source drop down list.Note: If you do not have the Commission Reconciliation module then you can pull the data from Shipments vs. Commissions Received.
  2. Select the Agency Comm (3 Mos)option from the Data drop down list.
  3. Select September from the As-of drop down list.
  4. Select 2012 for the As-of year from the drop down list.
  5. The quarterly commissions received will appear in the column Totals for Jul 12, Aug 12,u Sep 12.Sales IQ Home

Sales Analysis Commission Received by State – Example

In the following example we will generate a report using Sales Analysis for quarterly commissions by state for commissions received July thru September 2012.

  1. Select Commission Rec’d from the Selected Source of Data drop down list box.Note: If you do not have the Commission Reconciliation module then you can pull the data from Shipments vs. Commissions Received.
  2. Select Sales and Agency Commission from the Select Column Set (Headings) drop down list box.
  3. Select Customer State/Region from the Select Sub Totals Group drop down list box.
  4. Enter 09 and 2012 in the Print As-of Month/Year
  5. Select 3 Months from the Replace Current Month With drop down list box.
  6. Select the Print button.Sales Analysis Reports
  7. The following report is displayed showing the commissions received for Jul – Sept 12 by state.State Report

Case Study: PG Tool Sales Agency, LLC

“dynaMACS is always innovating and continually enhancing the software. I would recommend dynaMACS to anyone.”

Diane Geiger, Treasurer / Inside Sales
PG Tool Sales Agency

PG_Tool_LogoClient Challenge

PG Tool Sales Agency had been a customer of dynaMACS’ predecessor, MACS software, since 1989. When dynaMACS was introduced in 2003, PG Tool didn’t hesitate to upgrade. “We’d been happy with the software from the beginning. When dynaMACS came out, we wanted to have the newest product – the latest and greatest version,” says Diane Geiger, Treasurer and Inside Sales Director for PG Tool. “We went with dynaMACS because of our good track record with MACS – and we are glad we did. It’s been great.”

PG_Tool_StatisticsdynaMACS Solution

In fact, long-time customers like PG Tool have helped make dynaMACS the most powerful, easy-to-use software on the market. “The dynaMACS team is very open to input. They’ve listened to our feedback over the past 25 years, and they constantly work to improve the product based on how sales agencies like ours use the software on a day-to-day basis. dynaMACS is truly designed for professional sales agencies that need multi-level sales and commission analysis,” Geiger says.

Geiger says dynaMACS delivers intelligence on customers and manufacturers that help the sales team be more effective. “We can recognize trends by customer, manufacturer and sales reps. This helps us determine the types of promotions to offer based on the income generated. It also helps with up-sells and cross-sells.

The agency also knows who is not buying, or whose purchasing has dropped off, so salespeople can spend their time on the accounts that need the most attention. Salespeople can use their time more efficiently, by sorting customers by zip code, analyzing sales and setting up call days and planning the most efficient routes.  

What’s next? PG Tool is preparing to step into the next-generation of innovation. dynaMACS recently introduced processing on the Cloud. PG Tool will be among the first dynaMACS customers to process on the Cloud. This gives salespeople access to real-time data that is accessible from anywhere, on most smart devices, like smart-phones and tablets, at any time.