Posts

Empowering Systems Account Reporter Analytics – POS Reports

Our advanced sales and commission tracking software enable you to see all the dashboards in AccountReporter Analytics. This analytics is like dynaMACS SalesIQ on steroids. You will be able to see end customer data and part number information if you need that.

With business needs changing all the time. You need to quickly analyze your business and get back to selling. Check out the video below that shows you quickly and easily Point-of-Sale information.

POS Video

Offering solutions that you requested

 

AccountManager 365 Add-In(CRM from your inbox):

  1. Sell from Microsoft Outlook. Update your opportunities, contacts, accounts and more right in your Outlook in-box on your PC, Mac or phone.
  2. Contacts in one place. Update your contacts in Outlook from the AccountManager Add-in and the other applications will update.
  3. Unclutter your Outlook folders. Email Attachments sync over to AccountManager. One place to find the information you are looking for.
  4. Use the Planner to help organize your team’s workflow. Use the planner to help your team work smarter not harder.

 

Missed the other blogs regarding our extended capabilities:

AccountManager (CRM)

SalesAnalysis (Sales, Commission and Order Management)

Contact us today to learn more!

 

Tip #1708 – Using dynaMACS’ SalesIQ to Analyze “House” Commissions

dynaMACS’ Sales IQ provides a unique method for analyzing your agency sales and commission numbers.  House commissions are the agency commissions remaining after paying all the sales reps their split of the commissions.

Use the “Data” Control to Display Your “House” Commissions.

In the following example we show data for Agency Commission + Agency Splits listed by manufacturer as of October 2019.  This allows you to examine the total agency commissions and the remaining “House” commissions.

  1.  From the dynaMACS main screen, select the Sales IQ button.
  2.  Select AgyComm + AgySplit from the Data drop down list in the Parameters section of the screen.
  3. We have selected October 2019 from the As-of drop down list in the Parameters section of the screen.
  4. Select the Manufacturers tab.
  5. This column represents the total agency commission amount for Jan-Oct 2019.
  6. This column represents the total agency “House” commission amount for Jan-Oct 2019 after paying the sales reps.

Tip #1703 – Transferring a Portion of One Sales Rep Territory to Another Sales Rep

dynaMACS makes it easy when you are changing your agency territories.  Instead of moving one customer at a time, dynaMACS can move multiple customers at one time.

In the following example we will transfer all of sales rep Jim Black’s accounts in the state of Kentucky to the new sales rep Rick White.

Customer Global Update

First you must run the Customer Global Update.

  1.  From the main dynaMACS screen select Edit>File Transfer/Combine>Customer Global Update.
  2. Select the Yes button from the Restore Point? dialog box to create a restore point.
  3. In the Customer Global Change screen enter the state code “KY” in the State field.
  4. Enter the “from” sales rep code “JB in the Sales Rep field (old rep).
  5. Enter the “to” sales rep code “RW” in the next Sales Rep field to the right (new rep).
  6. Select the Update button.
  7. Select the Print button from the Printing Options dialog box to print the Audit Trail report.
  8. This report shows a list of the customers that will be transferred from sales rep “JB” (Jim Black) to sales rep “RW” (Rick White).
  9. After reviewing the Audit Report select the Yes button to continue.

    Transfer Sales and Commission History to New Rep

    1.  From the main dynaMACS screen select Edit>File Transfer/Combine>Mfg/Cst/Rep Transfer (1).

    2.  From the Manufacturer/Customer/Sales Rep Transfer/Combine (1) screen select the Wizard button at the bottom right hand corner which will redirect you to the Wizard screen.  You will be prompted to create another Restore Point.

    3.  Select Sales Rep from the drop down list for the field: I want to transfer or combine all data for a:.  Select Sales Rep and for the field: To a different.  Then select the Proceed to Selection button.
    4.  Enter the Sales Rep code that you are transferring from under Transfer Data From i.e. “JB”.
    5.  If you wish to transfer the sales rep splits, check the box Transfer Commission Splits to this Sales Rep?
    6.  Select the Proceed button.
    7.  Select the Yes button on the Please Confirm dialog box.

    8.  From the Printing Options screen select your printer and then select the Print button.

    9.  Review the report and then select the Yes button to complete the transfer.

    10.  Select the OK button after all records have been transferred.

    11.  From the main dynaMACS screen select Edit>File Transfer/Combine>Mfg/Cst/Rep Transfer (2).

    12.  Print the report when prompted by selecting the Print button.
    13.  Select the OK button on the Please Confirm dialog box to complete the transfer.

Case Study: Mizzen Marketing

 “dynaMACS is an empowering tool for understanding sales and analyzing trends.”

Lisa Ortega, Operations Manager
Mizzen Marketing

Client Challenge

When it came to tracking sales and commissions, Mizzen Marketing had two primary issues: accuracy and visibility. The agency had used two different tools. With Excel, the agency noticed inaccurate sales numbers, likely due to accidental deletions. Over time, the file grew to a monster of a spreadsheet that was difficult to use and extract data from. Quickbooks provided a more accurate representation of the numbers, but data was only visible in basic reports and was stored on an accounting firm’s system, so Mizzen had to wait for information. Lisa Ortega, Mizzen Marketing’s Operations Manager, knew there must be a better way. “I mentioned to a colleague that I wanted software designed specially for sales agencies. He told me about dynaMACS.”

dynaMACS Solution

From the beginning, it was a smooth transition. “dynaMACS offered the best features minus the headaches. dynaMACS aligned perfectly with how we wanted to track sales and commissions,” Ortega says.

In the audiovisual space, many manufacturers sell products through distribution channels, so Mizzen Marketing must be able to track the distributors’ performance as well as the sales of the customers buying from them. With dynaMACS, the agency creates unique “Manufacturer/ Distributor” codes so they can easily evaluate the manufacturer as a whole or by individual distributor. We can also see the buying trends of the customers – who they buy from and at what volume.”

Because Mizzen Marketing can see trends, the agency is able to be proactive. “It’s insightful on so many levels,” Ortega says. “Everything we need is right at our fingertips.” Even the sales reps in the field have easy access and can pull up data on their laptops before going into a sales meeting.

Ortega calls dynaMACS an “empowering tool for understanding sales and tracking.”

Tip #1701 – Using the dynaMACS System Information Setup Screen to Pre-Select Reporting Options

In dynaMACS you can set defaults for some of the reporting options which will save you time by eliminating the need to set them each time you run a report.

  • You can choose to build State/Region codes on the fly when running a Sales Analysis report if they are missing from the customer record.  This feature will combine the State Code plus the first 3 digits of the zip code from the customer address.
  • When running Sales Analysis reports you can choose to automatically skip to a new page for select codes if the Customer ABC code contains any one of the pre-selected codes.
  • Print Sales Analysis reports sorted alphabetically by the Look-Up code rather than Customer code.
  • Set Agency Commission printing options to Print Always, Never, or Prompt the user.
  • Set default to turn off automatic page skipping on all general reports.

Access Reporting Options

  1. From the dynaMACS main screen select Other Functions> Administration>System Information Setup. 
  2. Select the Reporting Options tab from the System Information Setup screen.

Select Options for Sales Analysis Reports

  1. To build the State/Region code “on the fly” in Sales Analysis reports, select the checkbox.
  2. To set Page Skipping for customers with the pre-selected ABC codes, enter the ABC code here.
  3. To print Sales Analysis reports sorted in alphabetical order using the Look-Up code rather than the Customer code, select the checkbox.

Select Options for Sales Entry/Commission Reconciliation/Open Invoice reports

  1. Select your preference for Printing Agency Commission from the drop down box.
    • Prompt will prompt the user to print Agency Commission for users that can see commissions.
    • Never Print will set the default so Agency Commission will never print for all users.
    • Always Print will set the default so Agency Commission will always print for users that can see Agency Commissions.
  2. To disable automatic page skipping, check the box next to “Default for Don’t Skip Page on Level Break”.
  3. After all of your Reporting Options have been selected, click on the Save button.