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.
Reference
The tables behind Construction Accounting and Progress Billing
Construction Accounting and Progress Billing ships with 16 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
- 16
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and parties
Organizations scope business partners, team members, ledger accounts and accounting periods.
Document source
Accounting documents hold the transaction identity; document lines carry account coding; record attachments and review decisions hold support and decisions.
Certified billing
Progress billings point to their parent accounting documents and organization.
Posting
Journal entries point to a source document and period; journal lines point to their journal and ledger account.
Settlement and evidence
Cash applications join cash receipts to accounting documents. Operation receipts keep action results against the parent document.
Every table, by feature
- Accounting documents4
- Progress billing4
- Ledger and periods6
- Cash application4
- Partners and organizations4
- Review and evidence5
- Shared and settings1
- Accounting documents
Construction billing and cost documents with lifecycle, gross amount and counterparty.
Linked to Organizations, Team members, Business partners - Document lines
Line-level quantity, unit price, tax and net amounts per accounting document.
Linked to Accounting documents, Ledger accounts - Record attachments
Uploaded evidence files linked to an accounting document.
Linked to Accounting documents, Team members - Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Accounting documents, Team members
- Progress billings
Certified progress claims raised against a parent accounting document.
Linked to Accounting documents, Organizations - Accounting documents
Construction billing and cost documents with lifecycle, gross amount and counterparty.
Linked to Organizations, Team members, Business partners - Record attachments
Uploaded evidence files linked to an accounting document.
Linked to Accounting documents, Team members - Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Accounting documents, Team members
- Ledger accounts
Chart of accounts used by document lines and journal lines.
Linked to Organizations - Accounting periods
Open, review and closed accounting periods governing posting eligibility.
Linked to Organizations - Document lines
Line-level quantity, unit price, tax and net amounts per accounting document.
Linked to Accounting documents, Ledger accounts - Journal entries
Balanced journal headers posted from approved accounting documents.
Linked to Accounting documents, Accounting periods - Journal lines
Debit and credit journal lines with account and dimension.
Linked to Journal entries, Ledger accounts - Accounting documents
Construction billing and cost documents with lifecycle, gross amount and counterparty.
Linked to Organizations, Team members, Business partners
- Cash receipts
Verified provider cash receipts awaiting application.
Linked to Business partners - Cash applications
Applications of verified cash receipts against posted accounting documents.
Linked to Cash receipts, Accounting documents - Accounting documents
Construction billing and cost documents with lifecycle, gross amount and counterparty.
Linked to Organizations, Team members, Business partners - Business partners
Owners, subcontractors, suppliers and other eligible parties.
Linked to Organizations
- Organizations
Construction company and contracting organizations using this workspace.
- Business partners
Owners, subcontractors, suppliers and other eligible parties.
Linked to Organizations - Team members
Active staff with organization membership, platform identity and business role.
Linked to Organizations, Users - Ledger accounts
Chart of accounts used by document lines and journal lines.
Linked to Organizations
- Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Accounting documents, Team members - Record attachments
Uploaded evidence files linked to an accounting document.
Linked to Accounting documents, Team members - Operation receipts
Idempotent operation receipts capturing action, expected revision and result state.
Linked to Accounting documents - Accounting documents
Construction billing and cost documents with lifecycle, gross amount and counterparty.
Linked to Organizations, Team members, Business partners - Team members
Active staff with organization membership, platform identity and business role.
Linked to Organizations, Users
Keys and references
Keep the source document’s record number and Revision stable through review. The reviewer decision uses source revision. Operation key identifies an attempted action and expected revision identifies the scope it checked. Provider event ID distinguishes cash events. The application records both its Receipt and Document. These references let the controller trace a result back to its source.
Migration order
- Operating scope. Add Organizations and Users, then team members with their organization links.
- Financial setup. Add business partners, ledger accounts and accounting periods.
- Source work. Add accounting documents, document lines, record attachments and progress billings.
- Decisions and postings. Add review decisions, journal entries and journal lines.
- Settlement and operations. Add cash receipts, cash applications and operation receipts after their parent records exist.
Set up Construction Accounting and Progress Billing your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.