Skip to main content
Question

Architecture sanity-check — 55-account CoA + 2-segment sub-account key for a single-entity distribution/light-manufacturing build. Anything obviously missing before we lock the segment layout?

  • August 7, 2026
  • 3 replies
  • 32 views

Wrapping up Chart-of-Accounts design on a 2026 R1 build (clean-slate migration off a legacy ERP whose chart had grown past 400 accounts) and would like outside eyes on the overall shape before we lock the sub-account segment layout — that part is effectively set-once (segments can be appended later but not removed, reordered, or shortened).

 

Company profile: single CAD legal entity, USD as a meaningful secondary transaction currency, ~15–20 ERP users, business mix of distribution + light assembly + full manufacturing across roughly 7–8 product families.

 

Chart: 55 GL accounts total (roughly 14 Asset / 9 Liability / 4 Equity / 2 Revenue / 10 COGS / 8 Operating Expense / 7 Other Income-Expense / 1 Income Tax). Design philosophy throughout: push repeatable detail into a sub-account dimension or the relevant sub-ledger module rather than adding GL accounts — e.g. Fixed Asset CCA classes live in the FA module per-asset rather than as separate GL lines; product-family detail on COGS/Revenue lives on sub-account.

 

Sub-account key: 2 segments x 3 characters, FUNCTION-DETAIL. FUNCTION = who earns/spends (Corporate & Finance / Manufacturing / Sales & Marketing / Admin-G&A / Warehouse & Distribution). DETAIL = within-account breakdown, mainly product family, with a handful of accounts carrying their own list (e.g. counterparty identity on the long-term-debt and shareholder-loan accounts).

 

Example: 50100 . MFG-PF1 = COGS for product family 1, incurred in Manufacturing. On the related-party side, 24100 . COR-L01 (loan principal) and 80200 . COR-L01 (interest expense) share the same DETAIL value for lender 1 — filtering sub-account *-L01 pulls the whole lender relationship across the balance sheet and P&L with no dedicated GL account per lender.

 

One open question we haven't closed: for a related-party financing balance (e.g. a shareholder loan) where the counterparty's identity matters for reporting, is it better practice to carry that as sub-account detail under a liability control account (as above), or as a vendor record? We've found documentation supporting both mechanically, but the vendor route seems to force a fabricated AP document for something that isn't a real trade payable, and either way the balance shows up in AP aging. Curious if anyone's built this before and which way they landed.

 

Questions for the group:

1. Does a 55-account chart at this scale sound in the right range, or does something read as under- or over-built?

2. Anything structurally we're likely to regret not having in the 2-segment layout before we lock it?

3. Any pattern for "loan-like" related-party liabilities that avoids both the AP-document workaround and the AP-aging pollution?

 

Happy to share more detail on any piece.

3 replies

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • August 10, 2026

Hello,

It’s most helpful to see a Chart of Accounts that I’m reviewing.  I recommend that your Acumatica Partner and your CPA, who are familiar with your business, review details of your Chart of Accounts and provide the most meaningful feedback.

Most Charts of Accounts that I’ve reviewed are American; if there are different Canadian rules, I don’t know them.

That said, 

  1. 55 accounts seems extremely small.  Acumatica has no limit on COA size.   
    • Consider making the 55 accounts your Account Classes for easy summary reports
    • Create 2 sets of Financial reports; the Summary version will not expand the Account Classes and the Detail version will expand the Account Classes by GL Account.
  2. Have Acumatica-required accounts like PO Accrual, Landed Cost Accrual, Cash in Transit, Inventory in Transit, Gain/Loss on Currency, etc. been included?
  3. Avoid this situation:  “with a handful of accounts carrying their own list”.  Where a subaccount only pertains to a specific account…. use separate Accounts, not subaccounts. 
  4. Loans to related parties could be tracked in Accounts Payable and can be reported separately in both AP Aging and GL when you give them a separate AP account.  (‘Due to Related Parties’, for example.)

I hope this helps you.


  • Author
  • Freshman I
  • August 10, 2026

Really appreciate the detailed read, Laura — a few quick responses:

 

On the required-accounts check: good prompt to double-check, and it turns out we're already covered on that list — PO Accrual, Landed Cost Accrual (confirmed required under our costing method), Cash in Transit, and a realized/unrealized FX split are all in the 55. Inventory in Transit is the one we deliberately left out — single warehouse, no inter-location transfers, so there's nothing for it to track. The original post just gave the category breakdown rather than the full account list, so that's on us for not being clearer.

 

On chart size / Account Classes: appreciate the reporting-layer idea. We went the other way deliberately — using the sub-account key to carry the granularity instead of expanding the GL, with Generic Inquiries doing the reporting cut. Different philosophy, but a considered one rather than an oversight.

 

On the related-party loan — that's genuinely the part we went back and forth on longest. We landed on sub-account detail under the liability account rather than AP, mainly because the AP route seems to force a fabricated purchase document for a balance that isn't a real trade payable, and it still shows up in AP aging either way regardless of which account carries it. Curious if you've seen a shop actually run the AP route cleanly in practice, or if that AP-aging pollution is just accepted as a cost of doing it that way.

 

Thanks again for taking the time — genuinely useful to get an outside set of eyes on this before it locks in.


Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • August 10, 2026

Hello,

AP Aging can be modified to add AP Account Parameter - that’s how we exclude some Payables detail (non-trade).