
AI summarizes notable client sales changes, helping teams quickly detect important trends and anomalies.
1. Issue: Growth in client-specific sales data makes changes harder to detect
The accounting department of a cloud services company operated with a three-person team and had already systemized processes ranging from importing accounting data to generating monthly client-specific sales summaries and month-over-month comparisons. These routine operations were running stably, and the aggregated results were regularly shared with executive management and the sales department.
However, as the number of clients increased, the client-specific sales report with month-over-month comparisons grew to several hundred rows. Even when accounting staff manually reviewed the report, it became difficult to determine which clients required closer attention.
In actual monthly review operations, the team could still track sales amounts and month-over-month changes for a few major clients. On the other hand, for medium-sized clients, even significant month-over-month fluctuations tended to be buried within the large report, making it difficult to identify and share important changes with the sales department and executive management.
2. Solution: Use AI to Generate Narrative Explanations of Key Sales Changes
The process owner added an AI agent after the aggregation step so that, in addition to the numerical report, the details of sales changes are output as text.
Specifically, the AI agent was given a prompt to “briefly explain notable sales changes based on the difference data between the previous month and the current month.” This allows the AI to extract major changes and distinctive trends from the difference data. Each time the monthly process is executed, the AI summarizes changes in client-specific sales in narrative form.
AI highlights major client sales changes instantly before reviewing detailed reports.
Before




View details of workflow diagram
Register 2 files
Register the current month file and the previous month file, then start the monthly comparison process.
Pivot Aggregation
Aggregate sales amounts by business partner and subaccount, and list the monthly sales structure.
Pivot Merge
Join the current month and previous month aggregation results using common fields to create comparable data.
Calculate Differences and Change Rates
Calculate the month-over-month difference and change rate to clearly quantify sales changes.
The key points organized by AI are automatically notified and shared with executive management and the sales department.
After




View details of workflow diagram
Register 2 files
Register the current month file and the previous month file, then start the monthly comparison process.
Pivot Aggregation
Aggregate sales amounts by business partner and subaccount, and list the monthly sales structure.
Pivot Merge
Join the current month and previous month aggregation results using common fields to create comparable data.
Calculate Differences and Change Rates
Calculate the month-over-month difference and change rate to clearly quantify sales changes.
AI Agent
Based on the difference data, AI summarizes notable sales changes from the previous month to the current month in narrative form.
It extracts important changes not only for major clients but also for medium-sized clients.
The key points organized by AI are automatically notified and shared with executive management and the sales department.


3. Customers Case Study
Honda Motor Co., Ltd.
Used for Company-wide Approval Flows such as general affairs applications, training recepti…
View MoreToho Gas Network Co., Ltd. (Negotiation and Design Section)
500 Applications Per Month Completely Digitized! Reduced Labour and Eliminated Printing and…
View MoreNippon Light Metal Co., Ltd.
Enhanced Quality Assurance through Visible Progress: A Continuous Improvement Cycle
View More4. Other Business Applications
We will enable AI-based reviews for the following tasks:
Project progress tracking
HR and attendance data checks
Attendance Reporting Process, Automatic Overtime Calculation
5. Related Posts
-

How to Align Approval Standards
View More: How to Align Approval StandardsReturn-for-revision enables feedback, reduces rework, and improves organizational decision quality.
-

Approval Workflow Branch by Amount
View More: Approval Workflow Branch by AmountAmount-based routing reduces bottlenecks by limiting division manager approvals to high-value cases …
-

Resolving Assignee Changes Among Operators
View More: Resolving Assignee Changes Among OperatorsOperators can now manually reassign tasks to reduce supervisor workload.






































![[Case Study] Nippon Light Metal Streamlines Quality Assurance with Questetra, Eliminating Bottlenecks and Driving Business Process Reform](https://questetra.com/wp-content/uploads/2023/12/ogp-singlepage-en.png)

















