Ongoing
Grok Bot Consulting
How Grok Bot Helped a CFO Rethink Her Workflow
Overview
We have been working with a CFO at a local firm that has several facilities. The work is Grok Bot: getting it set up, then using it on the reports and journal entries she was building by hand.
We started by installing Grok Bot and showing her the basics of the interface so she could get familiar with how it works. From there we took three of her routine processes and set them up with her, step by step. This is the Grok Bot consulting engagement.
The Challenge
Each month she built a report from her business management system, emails from her remote facilities, and historical spreadsheets. The result had to update an existing consolidated spreadsheet for all of her facilities, and the format of that spreadsheet could not change. That update was taking a couple of hours a month.
On paydays she built journal entries for her Microsoft accounting system. The inputs were her Paychex reports and the detailed account mapping in the accounting system. The accounting system needed those entries in its journal entry import format. At the same time she made a summary spreadsheet she uses to communicate with management. The whole process took an afternoon.
A third report used transaction data in the business management system. The vendor had built a custom report for them, but they had no way to change it, and she had to run it once for each location.
Services
- Grok Bot setup
- Monthly facility report
- Payday journal entries
- Paychex checks
- Custom report from the business management API
- Monthly report
- Done when she arrives on the last day of the month. It had taken a couple of hours.
- 15 min
- Weekly payroll entries, down from an afternoon.
- Accounting system
- Journal entries for her Microsoft accounting system, built from Paychex reports and her account mapping.
- Custom report
- Pulled through the existing API on the business management system, then scheduled to run on its own.
- Last day
- Monthly report is done when she arrives. It had taken a couple of hours.
- 15 min
- Weekly payroll entries, down from an afternoon.
Monthly report
The facility report, in the spreadsheet format that could not change
The report pulled from her business management system, emails she received from her remote facilities, and historical spreadsheets. The output had to update an existing consolidated spreadsheet for all of her facilities, and that format could not change. Together we walked through creating the output, testing the results, and automating the process. The update had been taking a couple of hours a month. It is now done when she arrives at work on the last day of the month.
Payday entries
Journal entries from Paychex into her Microsoft accounting system
The job was to take her Paychex reports, combine them with the detailed account mapping in her Microsoft accounting system, and produce the journal entry import format that system requires. A summary spreadsheet she uses to communicate with management is created at the same time. Once those two outputs existed, we taught Grok Bot how to confirm that the entries made it into the accounting system properly, and to compare Paychex reports for anomalies in pay rates, hours worked, and similar figures. We scheduled it to run once a week on her paydays. A process that took an afternoon is now done in about 15 minutes, automatically, with routine checks that look for mistakes.
Custom report
A report she no longer has to run once per location
This report used transaction data in their business management system. The vendor had created a custom report, but they had no way to change it, and she had to run it separately for each location. We taught Grok Bot to use the existing API on the business management system to pull the information the report needed. We made the changes the report needed and scheduled it to run automatically.
What we used
Grok Bot, the files and email she already had, Paychex, her Microsoft accounting system, and the existing API on the business management system.
- Business management system API
- Grok Bot
- Her Microsoft accounting system
- Paychex
- Spreadsheets
This work in service form
Services
Arts & Entertainment
Dallas Art Fair
Online ticketing, a custom CRM, and a dedicated Exhibitor Portal serving 90+ galleries annually, for one of the most celebrated contemporary art fairs in the country.
Grok Bot Consulting
A Texas political consulting firm
Twelve Texas counties, each posting early voting rosters its own way and on its own schedule. See how one firm put Grok Bot on the daily collection.