MYOB Advanced — Architecture (Finance View)

The PWG MYOB Advanced tenant is one logical instance with two companies inside it. Each company has its own Chart of Accounts and its own set of branches; tax setup and ledgers are shared.

Chart of Accounts

The CoA is per-company — there are 582 AccountCD values shared between PWG and JV, 175 PWG-only accounts, and 48 JV-only accounts. JV carries a heavier EQUITY, LOANIC, and INTCOLN (intercompany loans) shape, reflecting the JV equity and intercompany lending structure.

Each account carries three classifications that drive reporting:

Field	Examples	Purpose
Type	Asset, Liability, Income, Expense	Top-level P&L / balance sheet split
AccountClass	CASHASSET, INCOME, EXPENSE, RECEIVABLE, EQUITY, LOANIC, INTCOLN, …	Finer grouping for reporting
AccountGroup	(used inconsistently)	Optional rollups

The full extracts are committed in the source repo under data/ as chart_of_accounts_pwg.csv and chart_of_accounts_jv.csv.

Branches and subaccounts

A transaction in MYOB is stamped with a Branch and a Subaccount in addition to the Account. Together these form the segment key that drives almost every report.

Ledgers

MYOB stores postings against six named ledgers:

LedgerID	Type	What it holds
ACTUAL	Actual	Real posted transactions. The book of record.
BUDGET	Budget	Annual budget
FORECAST	Budget	8 months actual + 4 months budget
ALLOCATION	Reporting	Overhead redistribution (head-office costs out to branches)
FPALLOC	Reporting	FP head-office allocation
PRIORYEAR	Reporting	Prior-year comparatives

ACTUAL is the source of truth for statutory reporting. ALLOCATION and FPALLOC are management-reporting overlays.

Tax setup

Tax codes and categories are tenant-wide — not per-company. Eighteen tax codes back twelve tax categories, all settling against the ATO with control accounts 240000 (GST claimable) and 220000 (GST payable). The full extracts are in taxes.csv and tax_categories.csv.