Skip to main content

Customer Monthly Analysis

Jeremy Johnson avatar
Written by Jeremy Johnson
Updated over 4 years ago

The Business Edge has a new report that will allow you to easily account for seasonality in your business, as well as surges or contractions in sales. Awareness of these leading indicators in your business can help you make proactive decisions, taking advantage of opportunities and avoiding potential pitfalls. The Customer Monthly Analysis report is a trailing twelve-month calculation and is located below:

Sales Analysis System 
Customer Sales Analysis
Customer Sales Summary Inquiries
Customer Monthly Analysis

The Customer Monthly Analysis report is run by an as of date allowing you to customize a date range for the data. If you are running your trailing twelve-month reports for 2019, you can select an as of date that will start from the beginning of the current month and work backward

In the Customer Monthly Analysis report, you can compare your current trailing twelve-month (Trailing twelve months-often abbreviated as TTM) sales figures

The Optional fields in the Customer Monthly Analysis report are below.

If you would like to see a summary, on the right-hand side of the report there is also an option to show sales totals. This will calculate the Quantity, Cost and Sales for the Trailing Twelve Months as well as the Current year to date, Month to date, Previous Month to Date and Prior Year Month and Year as seen below

If you answer Yes to both Summarize Branches (if you have multiple branches) and Summarize Products you will see a summarized version of the report without the individual products listed

Did this answer your question?