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.
- Rental Payment Platform
- Data model
The tables behind Rental Payment Platform
Rental Payment Platform 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, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and people
Organizations, team members, Users and business partners identify who owns work and its counterparty.
Obligation and review
Rent schedules, accounting documents, document lines, review decisions and record attachments retain the charge and its evidence.
Ledger
Accounting periods, ledger accounts, journal entries and journal lines record balanced posting.
Cash
Cash receipts and cash applications distinguish verified money from its application.
Operations
Operation receipts retain guarded action outcomes; exchange rates hold effective reference rates.
Every table, by feature
- Rent schedules5
- Cash receipts4
- Cash application5
- Document review6
- Journal posting7
- Operations oversight8
- Shared and settings4
- Rent schedules
Rent schedule extensions reconciled against captured cash evidence
Linked to Accounting documents, Organizations - Accounting documents
Rent invoices, credits, expenses and adjustments with lifecycle status
Linked to Organizations, Team members, Business partners - Business partners
Tenants, owners and counterparties linked to accounting documents
Linked to Organizations - Review decisions
Independent reviewer decisions on a document revision
Linked to Accounting documents, Team members - Record attachments
Supporting evidence files attached to accounting documents
Linked to Accounting documents, Team members
- Cash receipts
Verified provider cash receipts captured for a partner
Linked to Business partners - Business partners
Tenants, owners and counterparties linked to accounting documents
Linked to Organizations - Cash applications
Applications of verified cash receipts against accounting documents
Linked to Cash receipts, Accounting documents - Accounting documents
Rent invoices, credits, expenses and adjustments with lifecycle status
Linked to Organizations, Team members, Business partners
- Cash applications
Applications of verified cash receipts against accounting documents
Linked to Cash receipts, Accounting documents - Cash receipts
Verified provider cash receipts captured for a partner
Linked to Business partners - Accounting documents
Rent invoices, credits, expenses and adjustments with lifecycle status
Linked to Organizations, Team members, Business partners - Business partners
Tenants, owners and counterparties linked to accounting documents
Linked to Organizations - Operation receipts
Idempotent operation receipts recording guarded action results
Linked to Accounting documents
- Accounting documents
Rent invoices, credits, expenses and adjustments with lifecycle status
Linked to Organizations, Team members, Business partners - Document lines
Line items on an accounting document with quantity, price, tax and account
Linked to Accounting documents, Ledger accounts - Review decisions
Independent reviewer decisions on a document revision
Linked to Accounting documents, Team members - Record attachments
Supporting evidence files attached to accounting documents
Linked to Accounting documents, Team members - Business partners
Tenants, owners and counterparties linked to accounting documents
Linked to Organizations - Ledger accounts
Chart of accounts used by journal lines
Linked to Organizations
- Accounting documents
Rent invoices, credits, expenses and adjustments with lifecycle status
Linked to Organizations, Team members, Business partners - Document lines
Line items on an accounting document with quantity, price, tax and account
Linked to Accounting documents, Ledger accounts - Journal entries
Balanced journal entries posted against accounting documents
Linked to Accounting documents, Accounting periods - Journal lines
Debit and credit lines of a journal entry
Linked to Journal entries, Ledger accounts - Ledger accounts
Chart of accounts used by journal lines
Linked to Organizations - Accounting periods
Open, review and closed accounting periods
Linked to Organizations - Operation receipts
Idempotent operation receipts recording guarded action results
Linked to Accounting documents
- Operation receipts
Idempotent operation receipts recording guarded action results
Linked to Accounting documents - Accounting documents
Rent invoices, credits, expenses and adjustments with lifecycle status
Linked to Organizations, Team members, Business partners - Journal entries
Balanced journal entries posted against accounting documents
Linked to Accounting documents, Accounting periods - Journal lines
Debit and credit lines of a journal entry
Linked to Journal entries, Ledger accounts - Review decisions
Independent reviewer decisions on a document revision
Linked to Accounting documents, Team members - Rent schedules
Rent schedule extensions reconciled against captured cash evidence
Linked to Accounting documents, Organizations - Cash receipts
Verified provider cash receipts captured for a partner
Linked to Business partners - Cash applications
Applications of verified cash receipts against accounting documents
Linked to Cash receipts, Accounting documents
Keys and references
Each rent schedule points to a parent accounting document and an organization. Documents point to an owner and counterparty. Cash applications connect receipts with documents. Journal entries connect documents with periods, and their lines connect to ledger accounts. Review decisions and attachments point back to the document. Preserve these identities during import so a retry can find its prior effect.
Migration order
- Import organizations, users, team members and business partners.
- Add ledger accounts and accounting periods for each organization.
- Import documents, lines, rent schedules and attachments.
- Add review decisions and post approved documents.
- Import verified cash receipts, then apply them to eligible documents.
- Inspect operation receipts against posted journals and cash applications, then review the resulting reports.
Set up Rental Payment Platform your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.