These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Royalty Accounting
- Data model
The tables behind Royalty Accounting
Royalty Accounting ships with 17 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 17
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Usage and documents
Usage statements attaches contract and period basis to accounting documents; document lines carries quantity, price, tax and account allocation.
Review and evidence
Review decisions and record attachments retain the decision basis, while operation receipts records guarded action outcomes.
Ledger and cash
Journal entries and journal lines hold posting effects; cash receipts and cash applications hold verified cash and allocations.
Reference scope
Organizations, business partners, team members, Users, ledger accounts and accounting periods establish identity and book context. Exchange rates holds effective read-only rates.
Every table, by feature
- Usage statements5
- Accounting documents7
- Ledger posting7
- Cash and reconciliation5
- Partners and access8
- Evidence and exceptions8
- Usage statements
Royalty usage statements with contract, period, eligible units and rate.
Linked to Accounting documents, Organizations - Accounting documents
Invoice, credit, expense and adjustment documents that carry royalty operations.
Linked to Organizations, Team members, Business partners - Record attachments
Evidence files attached to accounting documents.
Linked to Accounting documents, Team members - Review decisions
Independent reviewer approvals, rejections and returns per source revision.
Linked to Accounting documents, Team members - Operation receipts
Stable operation keys and result states for every guarded action.
Linked to Accounting documents
- Accounting documents
Invoice, credit, expense and adjustment documents that carry royalty operations.
Linked to Organizations, Team members, Business partners - Document lines
Line items with quantity, unit price, tax and net amount for an accounting document.
Linked to Accounting documents, Ledger accounts - Business partners
Licensees and counterparties that royalty documents are issued to.
Linked to Organizations - Ledger accounts
Chart of accounts used by document lines and journal lines.
Linked to Organizations - Record attachments
Evidence files attached to accounting documents.
Linked to Accounting documents, Team members - Review decisions
Independent reviewer approvals, rejections and returns per source revision.
Linked to Accounting documents, Team members - Usage statements
Royalty usage statements with contract, period, eligible units and rate.
Linked to Accounting documents, Organizations
- Accounting documents
Invoice, credit, expense and adjustment documents that carry royalty operations.
Linked to Organizations, Team members, Business partners - Accounting periods
Open, review and closed posting periods per organization.
Linked to Organizations - Journal entries
Balanced journal entries generated from approved accounting documents.
Linked to Accounting documents, Accounting periods - Journal lines
Debit and credit lines that make a journal entry balance.
Linked to Journal entries, Ledger accounts - Ledger accounts
Chart of accounts used by document lines and journal lines.
Linked to Organizations - Operation receipts
Stable operation keys and result states for every guarded action.
Linked to Accounting documents - Document lines
Line items with quantity, unit price, tax and net amount for an accounting document.
Linked to Accounting documents, Ledger accounts
- Cash receipts
Verified cash receipts imported from provider payment events.
Linked to Business partners - Cash applications
Applications of verified receipts against posted accounting documents.
Linked to Cash receipts, Accounting documents - Accounting documents
Invoice, credit, expense and adjustment documents that carry royalty operations.
Linked to Organizations, Team members, Business partners - Business partners
Licensees and counterparties that royalty documents are issued to.
Linked to Organizations - Operation receipts
Stable operation keys and result states for every guarded action.
Linked to Accounting documents
- Organizations
Licensing organizations that own royalty contracts and accounting books.
- Business partners
Licensees and counterparties that royalty documents are issued to.
Linked to Organizations - Team members
Preparers, reviewers and administrators scoped to an organization.
Linked to Organizations, Users - Users
Users
Linked to Users - Ledger accounts
Chart of accounts used by document lines and journal lines.
Linked to Organizations - Accounting periods
Open, review and closed posting periods per organization.
Linked to Organizations - Exchange rates
Read-only effective exchange rates for this app.
- Accounting documents
Invoice, credit, expense and adjustment documents that carry royalty operations.
Linked to Organizations, Team members, Business partners
- Record attachments
Evidence files attached to accounting documents.
Linked to Accounting documents, Team members - Review decisions
Independent reviewer approvals, rejections and returns per source revision.
Linked to Accounting documents, Team members - Operation receipts
Stable operation keys and result states for every guarded action.
Linked to Accounting documents - Accounting documents
Invoice, credit, expense and adjustment documents that carry royalty operations.
Linked to Organizations, Team members, Business partners - Journal entries
Balanced journal entries generated from approved accounting documents.
Linked to Accounting documents, Accounting periods - Journal lines
Debit and credit lines that make a journal entry balance.
Linked to Journal entries, Ledger accounts - Cash applications
Applications of verified receipts against posted accounting documents.
Linked to Cash receipts, Accounting documents - Usage statements
Royalty usage statements with contract, period, eligible units and rate.
Linked to Accounting documents, Organizations
Keys and references
A statement refers to its parent document and organization. Review decisions, attachments and operation receipts refer to the accounting document, so statement evidence is followed through that parent. A document refers to organization, owner and counterparty. Journal entries refer to the document and period; journal lines refer to accounts. Cash applications refer to a receipt and document. The operation key links a guarded action to its result. Preserve these references when importing or correcting records.
Migration order
- Load organizations, users and team members, then business partners.
- Load ledger accounts, accounting periods and effective exchange rates.
- Load accounting documents, document lines, statements and attachments.
- Bring in decisions and operation receipts with source revisions intact.
- Bring in journals and verified receipts, then applications, reconciling each effect.
Set up Royalty Accounting your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.