ACCTivate!, Custom Reporting

New Customers by Month

This Acctivate Report is a rather simple one but can be quite useful. Do you want to send out monthly communications to your new customers?  Do you want to send a list of new customers to your sales staff with order totals so they can reach out and contact these new customers?  Or just report on new monthly sales?

Our Acctivate New Customers by Month Report looks for the date of a customer’s first invoice (not the date they were created but the first Invoice date) and if the date falls within the specified date range the customer is listed.  The original report was designed to show the Territory (or Sales Rep), customer name, phone number and amount of the invoice.  The amount displayed is the Invoice subtotal minus shipping.

The report is grouped by Month and Territory with a total new customer count and total sales amount at each level.

This report could be easily modified to add more contact info or be grouped differently to be more useful to your organization.  Maybe you need a report grouped by Rep then Date with page brakes after each Rep so you can easily distribute the report to supervisors.  Or maybe you want to take it one step further and add sales detail, or better yet add the ability to show or hide detail each time you run the report.

The foundation of this report is a simple one but is one that could be very helpful for your organization.  Please reach out to use if you are interested in this type of report, we’d be more than happy to help you get the data you need out of Acctivate.

new-customer-by-month-page-01

new-customer-by-month-page-02

new-customer-by-month-page-03

ACCTivate!, Custom Reporting

Multi Year Sales History/Forecasting Report

Knowing how your company is doing year over year is something every company wants to know.  You can look at a comparative P&L for this info but what if you want to know how sales for a specific customer are going, or maybe for a product?  Our Acctivate Multi Year Sales History/Forecasting Report was originally designed to group the results by Customer by Product.  Since the original design we have created a version that first groups by the Acctivate Product Class.  We could just as easily do this grouping by Sales Category.

This report shows sales history broken out by month for an entire year and when run for a range of years there is a row for each year, for easy month to month comparison.  Because the report is grouped by product we are able to show the sales amount total and the quantity total, which can be very helpful in giving you a quick way to identify possible trends and seasonality of your products.

The Forecast numbers are shown for future months and are based on Quotes that have been entered into the system.  This could be adjusted to use Booked Orders instead of Quotes if that makes sense for your organization.

As with any of our reports, this is a starting point and can be modified to meet your specific needs.  Just reach out to use and let us know how we can help.

sales-history