Select Interactive
Grok Bot Consulting

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
At a glance
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.
What changed
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
  • Email
  • Grok Bot
  • Her Microsoft accounting system
  • Paychex
  • Spreadsheets

This work in service form

Based in Fort Worth & Dallas, TX

Let's build something remarkable.

Start a Conversation