Unified Systems Consulting
Start a project
Unified Systems Consulting logo: three red runes above the company name on a slate gray tablet

Unified Systems Consulting

Make the systems you already have work as one.

Custom software, process automation, AI integration, financial models and accounting workflows for businesses that have outgrown spreadsheets and copy-paste, but don’t need an enterprise IT project.

Custom software Remote-first On-site by arrangement Fixed-scope pricing

01 Services

Seven lines of work, one goal: fewer manual steps.

Every engagement starts from how the work gets done today: which exports get pulled, which cells get pasted, which reconciliations get re-done every month. Then the repetitive parts get built out of the process.

1000 Software

Custom software development

Purpose-built applications, internal tools and integrations, written in Python and JavaScript, tested against your real data and documented so your team can run them.

  • Internal web apps, desktop tools and dashboards
  • API integrations between the systems you already use
  • Browser extensions and low-code apps around vendor software

2000 Automation

Process automation

Scripts, scheduled jobs and small services that take recurring work off people’s desks and run it the same way every time.

  • Report and file pipelines that run overnight
  • Data pulls from vendor portals and exports
  • Excel / VBA tools for teams without developers

3000 AI

AI integration

Practical use of AI models inside real workflows: reading invoices and documents, drafting entries, and checking the output before anyone relies on it.

  • Document and invoice extraction
  • AI assistants set up with your procedures
  • Guardrails and exception reports for review

4000 Finance

Financial modeling

Models built from your trial balance and operating data, structured so next month’s update is a refresh and not a rebuild.

  • Consolidated, multi-entity models
  • Budgets, forecasts and scenario tools
  • Pricing and margin analysis

5000 Accounting

Accounting and month-end close

Close checklists, reconciliations and journal entry packages designed to tie out, with the automation built in where it pays back.

  • Bank, GL and subledger reconciliations
  • Standard close templates per entity
  • Journal entry and payroll entry preparation

6000 Data

Dashboards and reporting

One view of the numbers people check every morning, fed from the systems that already hold them.

  • Operational and cash dashboards
  • Inventory aging and performance reports
  • Browser add-ons over existing web apps

7000 Process

Process design and streamlining

Mapping a workflow end to end, cutting the steps that don’t need to exist, and documenting what remains so it survives staff changes.

  • Workflow mapping and redesign
  • Low-code apps for intake and approvals
  • Procedures and handoff documentation

02 Selected work

Systems already running in production.

Work built for a multi-entity, multi-location organization with dozens of accounting entities, several banks and a locked-down IT environment. Client details are kept confidential; the problems are common to any growing business.

6+industries, from Fortune 500 retail to M&A advisory
3-waybank, DMS and GL reconciliation, packaged in Excel for teammates
93%smaller workbook after a dynamic-array rebuild (7.4 MB to 538 KB)
24/7scheduled jobs and nightly models on dedicated hardware

Accounting · Close

Month-end close automation

Close packages for affiliate entities generated from the month’s source files, so the accountant reviews instead of rebuilds.

  • Bad debt, WIP, revenue, sales tax, prepaids, depreciation and bonus schedules
  • Trial balance check, AR statements and a journal entry posting package
  • One standard close template per entity group, replacing one-off workbooks

Built · AI-assisted close, with a standard template rollout in progress

Treasury · Cash

Bank reconciliation and daily cash reporting

A zero-balance-account reconciliation that ties bank activity to the dealer system and the general ledger by entity, plus a daily cash position across multiple banks.

  • Bank portal, DMS and GL matched automatically, exceptions flagged
  • Packaged as an Excel macro tool for staff without AI access
  • Script-built cash workbook with forecast accuracy tracking, plus an offline executive dashboard

Built · cash report runs daily

Payables · Documents

Invoice-to-journal pipelines

Folders of vendor invoice PDFs, both digital and scanned, turned into ready-to-post journal entries.

  • Invoices matched to inventory by VIN and coded to the right accounts
  • OCR for scanned invoices, with VIN check-digit and subtotal validation and confidence flags
  • Cross-border tax rebate forms filled directly from line-item data

Built · freight, import and fleet invoices

Finance · Reporting

Consolidated financial model

A trial-balance-driven reporting model covering every entity and region, built for lender covenant reporting and management review.

  • GL mapping across several charts of accounts, grouped by region and entity
  • Acquired businesses mapped in from their own charts of accounts
  • Rebuilt from a bloated legacy file into a lean, repeatable monthly refresh

Built · rebuild in parallel testing

Operations · Inventory

Inventory, pricing and performance intelligence

Daily dashboards and analytics for vehicle inventory, acquisition and reconditioning teams.

  • New and used daily-huddle dashboards and a buyer performance report
  • Nightly machine-learning gross-profit model with seasonality
  • Market search tool over a vehicle-listings API with radius filtering

Built · unified pricing system in development

Apps · Workflow

Custom apps and browser extensions

Front ends that put structure around manual processes and add features to vendor web apps the business can’t change.

  • Power Apps for stock numbering and cross-border vehicle acquisition
  • Browser extensions for inventory aging, reconditioning bottlenecks and appraisal data entry
  • A compensation plan app replacing dozens of per-location payroll workbooks (in development)

Built · used by operations staff

AI · Agents

AI agents and a managed skill library

AI set up as a dependable part of the workflow, with written procedures, versioning and test folders, not as a chat window.

  • Administers an organization-wide library of AI skills for accounting and operations
  • AI agents for technician diagnostics and vehicle acquisition analysis
  • Point-of-sale-to-GL revenue reconciliation by location

Built · shared across departments

Excel · Engineering

Spreadsheet rebuilds and VBA repair

Fixing the workbooks a business already depends on, so they stay fast and stop failing quietly.

  • Lease accrual tracker rebuilt on a dynamic-array engine, checked against every historical lease
  • Shared-services expense reconciliation macros fixed for silent omissions and sign errors
  • Sales tax lookup tool that pulls every applicable rate by ZIP code
  • Payroll workbooks automated, with new SOPs written for the team

Built · validated against history

03 Expertise

Fluent in the books and the code.

Accounting knowledge decides what to build. Engineering decides how it holds up. Most of these tools were built for an environment with no installs and no outside services, so they run anywhere.

Software development

  • Python applications and services
  • JavaScript, HTML and CSS front ends
  • API and bank-file integrations
  • Chrome and Edge browser extensions
  • Power Apps and SharePoint lists

Automation, data and AI

  • Scheduled jobs and data pipelines
  • Excel: VBA, dynamic arrays, Power Query
  • PDF extraction and OCR
  • AI skills, agents and guardrails
  • Forecasting and machine-learning models

Accounting and finance

  • Multi-entity month-end close
  • Bank, GL and subledger reconciliation
  • Payroll and incentive compensation entries
  • Cash management and lender covenants
  • Consolidated models and acquisition mapping

Planning and analysis

  • Budgets, forecasts and variance analysis
  • Valuation and M&A models
  • Statistical analysis and forecasting
  • KPI reporting and executive presentations
  • Inventory forecasting and allocation

Industries

  • Automotive retail, fleet and collision repair
  • Insurance, warranty and rental
  • E-commerce and SaaS (M&A advisory)
  • Retail and apparel
  • Marketing services and higher education

How the work holds up

  • Tested against real prior months
  • Fails loudly on bad data, never silently
  • Live files never touched during testing
  • Documented for whoever runs it next
  • Built to need as little upkeep as possible

04 Background

A finance background, built into systems.

The work started on the numbers side and grew into building the systems behind them. That’s why the tools fit how finance and operations teams actually work.

Fortune 500 retail

Inventory forecasting and allocation across a national store network.

Corporate FP&A

Budgets, forecasts, variance analysis and executive reporting.

M&A advisory

Valuation and consolidated financial models for business sales.

Accounting operations

Month-end close, payroll entries, reconciliations and SOPs.

Software and AI

Custom software, automation and AI for a multi-entity organization.

05 Approach

Built by someone who does the work, not just the slides.

You get working tools, documented and handed over, with a clear owner on your side. Each phase ends with something you can use.

  1. I

    Discover

    A working session on the process as it runs today: the files, the systems, the people, the pain.

    Out: process map and a ranked list of fixes

  2. II

    Design

    A fixed-scope proposal for the fixes worth doing first, with the time they’ll save stated up front.

    Out: scope, price and timeline

  3. III

    Build

    Build against your real data, test against last month’s actuals, and review it with the people who’ll run it.

    Out: working tool, tested and tied out

  4. IV

    Hand off

    Documentation, a walkthrough, and a support window so the tool keeps working after I’m gone.

    Out: runbook, training, 30-day support

06 Engagements

Three ways to work together.

Most clients start with a single project and move to a retainer once the first tool is earning its keep.

Start here

Process assessment

A focused review of one workflow, such as month-end close, reporting or invoice processing, with a written plan of what to automate and what it’s worth.

Length
1–2 weeks
Format
Remote or on-site
Price
Fixed fee

Most common

Build project

A defined tool or automation, delivered working, tested on your data and documented for your team.

Length
2–8 weeks
Format
Remote, with check-ins
Price
Fixed scope and fee

Ongoing

Systems retainer

A monthly block of hours for maintenance, small builds and questions, for teams without an in-house developer.

Length
Month to month
Format
Remote
Price
Monthly fee

Community · Volunteer work

Nonprofit and volunteer projects

I take on a limited number of volunteer projects for nonprofits and community organizations, such as cleaning up their books, automating reporting or improving their websites and member systems. I also serve on the board of a regional arts nonprofit.

Ask about volunteer work

07 The mark

Carved to last.

The USC mark spells the company’s initials in the oldest runic alphabet, set the way runestones were: cut into stone and filled with red pigment so the message would read for centuries.

It’s the standard the work is held to. Systems should be built once, built plainly, and still make sense to the next person who has to read them.

08 About

Connor McMahon, founder

Business systems architect · Software developer

I design and build the systems a business runs on, drawing on a background in finance, accounting, automation, software engineering, AI implementation and statistical analysis. Close and reconciliation tools, financial models, data pipelines, forecasting models and AI workflows are all part of the same job: getting accurate numbers to the people who need them with as few manual steps as possible.

That mix comes from work that started on the finance side, in inventory planning at a Fortune 500 retailer, corporate FP&A, month-end close and M&A modeling, and grew into designing and engineering the systems behind it for a multi-entity, multi-location organization.

Unified Systems Consulting brings that same work to businesses that need it but don’t have a systems team. I speak both accounting and code, so nothing gets lost between the person who knows the process and the person who builds the fix.

09 Contact

Tell me what’s taking too long.

Describe the process in a few sentences. I’ll reply with whether it’s a good fit and what a first step would look like.