Kind of work 3 of 4

Checking and matching

Checking and matching is the work of holding one record against another: a bank line against the books, a delivery ticket against an invoice, a payout against the sales behind it, a customer's request against the price list. People still do it by hand because the records never line up exactly, and someone has to decide what each mismatch means.

From first principles

What has to be true, whatever the industry.

Before we build anything, we take the work down to what has to be true. What is left over is habit. Habit gets deleted, not automated.

  1. What has to be true

    • Every line on one side needs a match on the other, or a reason it has none.
    • The match follows the company's own rules, such as its coding, its price list and its client terms.
    • A person decides what a mismatch means before anything is booked.
  2. What is only habit

    Re-typing a line from a PDF or a bank feed into QuickBooks is habit, not judgment. So is saving every open question for month-end and then chasing the owner, the driver or the customer all at once.

  3. What we delete before building anything

    We delete the re-entering first, meaning the copying between bank feeds, portal exports and spreadsheets that exists only to get two numbers side by side. If QuickBooks bank rules or a channel's own payout report already does the match, we say so and the business should use it.

  4. What is left

    The agent. We build an agent that follows the company's own rules from day one to propose each match, flag each gap and draft the follow-up, and when someone on the team adjusts its work, that change is saved as a rule, an example or an exception that the team decides to keep.

    A person. A person reviews the agent's work at first, decides every mismatch that needs a decision, and sets the limits within which the agent works on its own.

Signs you have it

How this work shows up in a working day.

  • Two windows sit open side by side while someone checks off one line at a time.
  • A list of unexplained items grows all month until someone clears it at month-end.
  • The same follow-up question goes to the same person every month.

The use cases

Four jobs of this kind.

Each one comes from a request a business posted. The full write-up takes it down to first principles, then shows what the agent does and what stays with a person.

Accounting and bookkeeping

From a request a business posted

Bank and card transactions matched to the books

Which account, class and job does this line belong to, and is there anything we already know about it?

The bookkeeper codes every bank and card line by hand, then chases the owner about the charges nobody explained.

Read the full write-up

Freight and hauling

From a request a business posted

Delivery tickets matched to invoices

Does every delivery we made have a document behind it, and does the invoice say the same thing the document does?

Month-end reconciliation of PODs and scale tickets against invoices, chasing lost paperwork and weights that do not match the load.

Read the full write-up

E-commerce bookkeeping

From a request a business posted

Sales payouts reconciled across every channel

Does each deposit in the bank equal the sales, minus the fees, refunds and holds that channel took, booked once and only once?

Bookkeepers spend hours in spreadsheets breaking each Shopify, Amazon, PayPal and Square payout into sales, fees and refunds.

Read the full write-up

Distribution and manufacturing

From a request a business posted

Quote requests matched to the price list

Which catalog item and approved price does each line the customer asked for match?

Re-typing every line of a customer's PDF request, hunting each part in the catalog, then looking up the approved price.

Read the full write-up