ERP Business Analyst in Edinburgh

Edinburgh organizations whose rules live in documents

Business analysis is often described as mapping processes. In many Edinburgh organizations the process is the easy part; the difficulty is the set of rules behind it. Edinburgh is a UNESCO City of Literature and home to a cluster of publishers and literary agencies. It has a large independent school sector, and it hosts several long-established professional bodies and royal colleges whose members and exam candidates live around the world. In each case, money moves according to rules written in contracts, terms and conditions or formal regulations.

Those rules rarely survive a standard requirements template. A generic list says that the system must produce invoices or report on contracts. It does not say that a paperback royalty steps up once sales pass an agreed level, that a sibling discount applies only while an older child remains enrolled, or that a candidate who defers an exam keeps part of the fee only under certain conditions.

My approach is to read the documents with the people who administer them, turn each rule into a requirement with a worked example, and then test candidate systems against those examples. UK-wide topics, such as VAT treatments and Making Tax Digital, are covered on the UK ERP business analyst page, and the broader city picture is on the Edinburgh ERP consultant page. The sections below stay with the Edinburgh situations.

Publishers: advances, royalties and rights income

A publishing house holds contracts with authors, illustrators and translators, and almost every contract differs. Royalties may be calculated on the recommended price or on net receipts, with different rates for hardback, paperback, ebook and audio, for home and export sales, and with escalators once sales pass agreed levels. Advances must be recouped before royalties are paid, and a reserve against returns is often held back for a period. Subsidiary rights, such as translation, serial and film rights, bring income that is split between author and publisher in proportions each contract sets.

Many smaller publishers manage this in a specialist royalty system, or in spreadsheets maintained by one person, beside an accounting package. When the business considers an ERP, the first question is whether royalties move into it, stay in a specialist tool linked to it, or remain separate with a clean interface. That decision cannot be made without a full picture of the rules.

I build a royalty rules catalog from a sample of real contracts, covering every variation that appears, then write requirements for sales and returns data from distributors, reserves, statement production and author payments. Each requirement carries a worked example, so a vendor demonstration either calculates the right figure or visibly fails to. The tax and accounting treatment of advances and rights income stays with your accountant.

Independent schools: fees, bursaries and the bursar's office

Edinburgh has a large independent school sector for a city of its size, with day and boarding schools, many of them registered charities. Their bursar's offices handle billing that looks simple from outside and rarely is. Fees are charged termly in advance at different rates by stage and boarding status. Discounts apply for siblings and staff children, extras such as music lessons, trips and exam entries are added during term, and deposits are taken on acceptance and credited when a pupil leaves. Invoices may go to parents, to an employer or to a relative who pays on the family's behalf.

Means-tested bursaries add another layer. Applications include sensitive financial information, awards are reviewed regularly, and the bursary must appear correctly on the invoice without exposing details to staff who do not need them.

Schools also run a management information system for pupils and admissions, so the requirements must say which system is the record for each pupil, family and fee, and how changes pass between them. I map the fee cycle from acceptance to leaving, write requirements for billing, credit control, bursaries and deposits, and define that interface. Charity reporting, Gift Aid on donations and the tax treatment of fees remain with your accountant and auditor; the requirements make sure the data they need exists. The education ERP page covers the wider sector.

Professional bodies and royal colleges: members, exams and subscriptions

Edinburgh is home to several long-established professional bodies and royal colleges, some with members and exam candidates in many countries. Their membership and finance teams apply rules that a generic membership module rarely covers in full: grades with different subscription rates, reduced rates for particular career stages or for members in certain countries, joining fees, part-year subscriptions for people who join after renewals, and lapsed members who later rejoin.

Examinations add another layer. Candidates book sittings at centers at home and abroad, pay in several currencies, and may defer or withdraw under published regulations with partial refunds or credits. Examiners claim fees and expenses. Courses, events and continuing professional development bring their own bookings and charges, and journal or publishing income may sit alongside. When these rules live partly in a membership database, partly in finance and partly in staff memory, renewal and exam seasons become the busiest and most error-prone weeks of the year.

I document each rule with a worked example, from a member changing grade during the year to a candidate deferring a sitting, and write requirements for the membership system, the finance system and the interface between them. Subscriptions, exam fees and events may each have a different VAT treatment, which your advisor confirms; the requirements make sure every charge is classified so that treatment can be applied. The multi-currency ERP page covers the currency side.

Running the analysis remotely with small specialist teams

In these organizations the knowledge sits with very few people: a royalties manager, a bursar and fees assistant, a membership or examinations manager. They are busy at predictable times, such as royalty statement runs, the start of each school term or the annual renewal season, so I plan workshops around those peaks rather than through them.

Sessions are short and focused, held over video with shared screens so we can walk through real contracts, invoices and reports together. Between sessions I write up rules and examples for review, so the specialist's time goes on checking rather than explaining from scratch. Confidential material, such as bursary applications or member records, is handled through redacted samples agreed with you in advance.

At the end you hold process maps by role, the rules catalog, the requirements document, a platform-by-platform fit-gap matrix and acceptance test scripts. You own all of it, so any vendor or implementer can work from it. The BRD consulting service explains the document structure, and the Edinburgh freelance ERP consultant page covers what happens once a platform is chosen. A visit to Edinburgh is possible by arrangement, though nothing in the analysis requires one.