business, information, new year's day, year, accounting, application, computer, finance, mock-up, laptop, notebook, office, papers, technology, workplace, accounting, accounting, accounting, accounting, accounting. What four invented businesses reveal about real accounting software needs
Photo by geralt on Pixabay

Costs

Part of Accounting software: the properties nobody actually demonstrates

What four invented businesses reveal about real accounting software needs

Accounting software examples from four invented businesses, showing how transaction shape rather than size decides what each of them actually needs.

"Which package should I use" has no answer without knowing what the business does, because the requirement is set almost entirely by transaction shape. Two businesses of identical size can need completely different things.

Below are four invented businesses, each with the transactions that define its requirement and the specific capabilities those transactions demand. None of them is a recommendation and no product is named. Read the one closest to your own shape and take the reasoning rather than the conclusion.

What to take away

  • Requirements come from transaction shape, not from headcount or turnover. Ask what kinds of entry the business makes rather than how many.
  • The capability that decides the choice is usually one awkward thing: stock, jobs, deferred income, or money collected on behalf of others.
  • Every one of these businesses needs the same reconciliations. What differs is what has to be reconciled.

A one-person consultancy

Transactions: a handful of customer invoices a month on terms, a dozen supplier costs, a bank account, an occasional payment in a foreign currency, and the owner taking money out.

Consultancy software needs

  • Invoicing with payment terms
  • Bank feed connected
  • Owner drawings kept separate from costs
  • Foreign currency rate difference recorded

What it actually needs is small: invoicing with terms, a bank feed, and a clean separation between owner drawings and costs. That separation is the single distinction most often got wrong at this size.

When it fails, the profit and loss statement becomes meaningless.

Over-buying is the trap. A consultancy with twenty invoices a month does not need a stock module, job costing or an approval workflow, and paying for them buys complexity rather than capability.

The foreign currency payment is the awkward case. Check how the package records the difference between the rate on the invoice and the rate on the day it was paid, because doing that by hand every month is unpleasant.

A shop holding stock

Transactions: many small sales through a till or a card reader, settlements arriving net of fees, supplier deliveries, and stock sitting on shelves.

The first is decomposing a settlement: a deposit arriving net of fees and refunds splits into gross takings, the fee as a cost, and refunds against sales. Without that split, a business never sees what its payment costs are.

The second is stock: a valuation adjustable after a count, with the difference landing in cost of sales in the right period.

Everything else is secondary. A shop that gets those two right can run on a modest package. A shop that gets either wrong will have a gross margin that moves for reasons nobody can explain, and the reconciliation that catches it is the dull one of agreeing the stock figure to a physical count.

A trades business working in jobs

Transactions: quotes that become jobs, materials bought per job, subcontractors invoicing per job, staged customer invoices, and retentions held back until work is signed off. Whether a person working on a job is a subcontractor at all is a separate question with its own consequences, and the federal guidance on independent contractor or employee is where to settle it.

Job tracking tests

Can one supplier invoice split across three jobs and one overhead line?

Yes

total must still agree

No

job profitability stays a spreadsheet exercise

The defining requirement is a tracking dimension that reaches every transaction: purchase invoices, subcontractor costs, employee time and sales, all taggable to a job. Without it, job profitability is a spreadsheet exercise repeated forever.

Two specific tests. Can a single supplier invoice be split across three jobs and one overhead line, and does the total still have to agree. And can a deposit taken before work starts be held as a liability and applied to a staged invoice later, which is the treatment described in the revenue recording guide.

The reconciliation this business most often skips is the sum of job costs back to the ledger. Job reports and the ledger drifting apart is the standard failure, and it always comes from a cost coded to an overhead account because nobody knew the job.

A subscription business

Transactions: recurring billing, payments collected automatically, failed collections, upgrades and cancellations mid-period, and money taken in advance for a year.

Deferred income release

  1. On receipt
    Money billed for twelve months is a liability
  2. As delivered
    Releases into revenue
  3. Monthly
    Release schedule must be visible and checkable
  4. Ongoing
    Failed collections need an owner

The defining requirement is deferred income. Money billed for twelve months is a liability on receipt, releasing into revenue as the service is delivered. The release schedule must be visible and checkable, not buried in a billing platform.

The statutory requirement, that a method of accounting clearly reflect income, is at 26 U.S. Code section 446. How it applies to advance payments is a question for your accountant.

The second requirement is the failed collection list. These do not appear as aged invoices, so the ordinary aged report is not the control here; the exception list in the billing system is, and it needs an owner. The measurement habits in the accounts receivable guide still apply, but the report they apply to is a different one.

Where the billing system is separate from the ledger, the joint between them is the thing to design first: what posts across, how often, and which balance is agreed to which.

The four side by side

Decides the choice

Consultancy
Owner drawings kept apart from costs
Shop
Settlement decomposition and stock valuation
Trades
A job dimension on every transaction
Subscription
Deferred income schedule

Reconciliation most often skipped

Consultancy
Amounts owed to and from the owner
Shop
Stock to a physical count
Trades
Job costs back to the ledger
Subscription
Deferred income to services still owed

The right hand column is the more useful one. Each of these businesses can be run adequately on a modest package and none of them can be run on any package without the reconciliation beside it.

Four businesses compared

Business

Consultancy
Owner drawings apart
Shop
Settlement and stock
Trades
Job dimension everywhere
Subscription
Deferred income schedule

Decides the choice

Consultancy
Amounts owed to owner
Shop
Stock to physical count
Trades
Job costs to ledger
Subscription
Deferred income to services

Reconciliation skipped

Consultancy
Shop
Trades
Subscription

What all four have in common

The same monthly joints: bank, receivables, payables, and whatever is held on behalf of an authority. The same requirement for a period that can be closed and not silently changed. The same need for an account structure that means something, which is a chart of accounts decision rather than a software one.

And the same order of work: settle the structure, then test the awkward transactions, then choose. That sequence is set out in the guide to accounting software, and it applies whichever of these four you resemble.

Common questions

My business is two of these at once. What then?
Take the union of the requirements and expect to pay for it. A shop that also does installation work needs both the settlement handling and the job dimension, and packages strong at one are often weak at the other.
Does a bigger package handle all four shapes?
Usually, at a cost in setup and daily friction. The question is whether the capability you would be buying is one you will use monthly or once a year.
How do I know which shape I am before choosing?
List the last month's transactions by kind and count them. The kind you have most of, and the kind that took longest to record, are your requirement. It is a half hour exercise and it is more reliable than any description.
What if my accountant works in one particular system?
It is a real consideration, since their familiarity saves you money. It is not decisive if that system cannot handle your defining transaction, and the routine it has to support is the same either way, as the bookkeeping foundations guide sets out.

More in Costs

Latest from Costs Desk