Not-for-profit, events and professional training

Three to five hours a week that nobody has to spend

Nothing was broken. Every order was invoiced, every invoice was coded, and the accounts were clean. It simply took a person three to five hours a week to keep them that way, on a job that follows a rule.

ClientA growing not-for-profit running events, symposiums and paid training courses

SizeChapters in several states, plus national activity

EngagementA custom WooCommerce to Xero integration, automated invoice coding, and the account, job and chapter structure behind it

The practice publishes this case study today. The organisation is described by its work and never named, and no member, order or event detail appears.

The situation

Where they started

This organisation was growing quickly. Events, symposiums and paid training courses were running across several state chapters, and every one of them produced orders through WooCommerce that had to arrive in Xero coded correctly.

Correctly means three things at once. The right income account, whether that is course registration, event registration, symposium or sponsorship. The right job, meaning the specific event or course the revenue belongs to. And the right chapter, meaning the state the activity sits in, or national. Two out of three still produces a report nobody can use.

The reference for all of that was a coding spreadsheet supplied from outside the finance team. When payment processing on the platform changed, the spreadsheet stopped matching what was coming through, and the work fell back to a person. Our bookkeeper was logging into WooCommerce for every order, reading the description, checking it against the spreadsheet, then creating and coding the invoice in Xero by hand.

Nobody had raised it as a problem. It had always been done that way, which is the most common reason a manual process survives a growing organisation.

The challenges

What we found when we opened the file

01 Coding in three dimensions at once Account, job and chapter all had to be right on every single invoice. Getting two of the three right still leaves reporting that cannot be relied on.

02 The rule lived outside the systems The coding rules sat in a spreadsheet supplied from outside the finance team. A rule kept beside a system rather than inside it is current only until something moves.

03 A platform change broke the process When payment processing on the platform changed, the spreadsheet stopped lining up with what was arriving, and the only fallback available was manual work.

04 Every order opened by hand Each order meant logging into WooCommerce, reading the description, cross-referencing the spreadsheet, then creating and coding the invoice in Xero.

05 Three to five hours a week, every week That is bookkeeping time spent on a process that follows a completely predictable pattern, which is the definition of work software should be doing.

06 Reporting the chapters could not lean on Because the coding depended on a manual step, reporting by state chapter and by event was only ever as good as the most recent catch-up.

What we did

What we built

Started with the pattern rather than the workload. Every product in WooCommerce already knew what it was; that information simply was not reaching Xero in a form anything could act on.

Designed a short accounting code carrying three pieces of information: the chapter, the job, and the chart of accounts allocation.

Embedded that code directly on each WooCommerce product, so the coding rule travels with the product instead of sitting in a document beside it.

Built a custom integration that reads the code the moment an order is placed and creates the invoice in Xero against it.

Coded every invoice to the correct income account, the correct chapter and the correct job at the point of creation, with no manual step in between and no spreadsheet to consult.

Built it properly rather than quickly. It took a couple of days, and it has run reliably since.

The outcome

What it changed

Where a figure is not on record, the change is described in words. No percentage is estimated and no metric is invented.

3 to 5 hours Bookkeeping time returned every week, on a process that never needed to be manual in the first place.

Every order An invoice exists in Xero, correctly coded, from the moment an order is placed. There is no queue and no catch-up.

No backlog Receivables stay clean. There is no catch-up coding and no month end scramble to reconcile what came through the platform.

Audit ready Every invoice is correctly coded from the moment it is created, so the year end audit has a complete trail to work from rather than one to reconstruct.

By chapter Reporting by state chapter is reliable, because the chapter is set at the point of entry rather than applied to a pile of invoices afterwards.

By event Revenue by event and by course can be reported accurately, which the organisation had never been able to do dependably before.

Is this you

Could your systems be doing more

If somebody spends hours each week on work that follows a rule, the rule can usually be written down and handed to the software. That is the whole test.

Does anyone in your business open a sales platform to read an order before they can code it?
Is the rule for coding your sales held in a spreadsheet rather than inside the systems themselves?
When a new product, course or event is created, does somebody have to remember how it should be coded?
Can you report revenue by location, by event or by funding stream without a manual exercise first?
Does your sales platform have a Xero integration that stops short of the coding your reporting actually needs?

More case studies

Other work

National not-for-profit How we modernised a national not-for-profit and made audit season effortless Withheld, to keep the client unidentifiable Three accounts marked reconciled, and none of them were Marine electrical, trades and services How we uncovered a $416,000 fraud and helped a family business survive Migration agency, professional services One system instead of three, and a report the business can trust Pharmaceutical manufacturing and distribution 25-30 hours a week getting orders out and invoices paid, now less than eight NDIS and disability support The SCHADS increase used to take a full day. Now it is one pass down a list

Book a Call Today

The free Xero Health Check from NN Accountability

The free checklist

Download Your FREE Xero Health Check

Identify common bookkeeping errors and discover simple fixes for smoother financial management, written in plain English.