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 Accounting Document and Account Reconciliation
Accounting Document and Account Reconciliation ships with 15 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
- 15
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Documents
Accounting documents is the parent for document lines, record attachments, review decisions, cash receipts and operation receipts.
Organization
Organizations, team members, Users and business partners establish ownership and access context.
Accounts
Ledger accounts links document lines, account snapshots and reconciliation items.
Provider evidence
Reconciliation items links source movements to a matched document, while cash receipts retains event evidence on the parent.
Other records
Statement matches links a parent document and organization; exchange rates holds dated read-only rates.
Every table, by feature
- Accounting documents5
- Review and evidence5
- Provider instructions4
- Account reconciliation5
- Balances and accounts6
- Operations control4
- Shared and settings3
- Accounting documents
Accounting documents prepared, reviewed and linked to provider outcomes.
Linked to Organizations, Team members, Business partners - Document lines
Line-level amounts recorded against an accounting document.
Linked to Accounting documents, Ledger accounts - Business partners
Suppliers and business partners eligible for purchase and reconciliation activity.
Linked to Organizations - Ledger accounts
Ledger accounts referenced by document lines and posted journals.
Linked to Business partners - Record attachments
Supporting files attached to an accounting document.
Linked to Accounting documents, Team members
- Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Accounting documents, Team members - Record attachments
Supporting files attached to an accounting document.
Linked to Accounting documents, Team members - Accounting documents
Accounting documents prepared, reviewed and linked to provider outcomes.
Linked to Organizations, Team members, Business partners - Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents
- Accounting documents
Accounting documents prepared, reviewed and linked to provider outcomes.
Linked to Organizations, Team members, Business partners - Cash receipts
Provider event evidence linked to accounting documents.
Linked to Accounting documents - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Accounting documents, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents
- Reconciliation items
Source-identified provider movements matched against banking instructions.
Linked to Ledger accounts, Accounting documents - Accounting documents
Accounting documents prepared, reviewed and linked to provider outcomes.
Linked to Organizations, Team members, Business partners - Document lines
Line-level amounts recorded against an accounting document.
Linked to Accounting documents, Ledger accounts - Ledger accounts
Ledger accounts referenced by document lines and posted journals.
Linked to Business partners - Cash receipts
Provider event evidence linked to accounting documents.
Linked to Accounting documents
- Ledger accounts
Ledger accounts referenced by document lines and posted journals.
Linked to Business partners - Account snapshots
Dated provider balance snapshots for a financial account.
Linked to Ledger accounts - Reconciliation items
Source-identified provider movements matched against banking instructions.
Linked to Ledger accounts, Accounting documents - Document lines
Line-level amounts recorded against an accounting document.
Linked to Accounting documents, Ledger accounts - Exchange rates
Read-only effective exchange rates for this app.
- Business partners
Suppliers and business partners eligible for purchase and reconciliation activity.
Linked to Organizations
- Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents - Accounting documents
Accounting documents prepared, reviewed and linked to provider outcomes.
Linked to Organizations, Team members, Business partners - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Accounting documents, Team members - Cash receipts
Provider event evidence linked to accounting documents.
Linked to Accounting documents
Keys and references
Keep the document number, operation key, provider instruction identifier, provider event identifier and provider snapshot identifier distinct. Each answers a different question about the source of an action or observation. Confirm organization and account references during import. The review decision’s source revision should identify the exact document version checked.
Migration order
- Load Organizations and Users, then team members and business partners.
- Load ledger accounts and any dated exchange rates used by the finance team.
- Load accounting documents with their organization, owner and counterparty references.
- Load document lines and record attachments under their parent documents.
- Load review decisions, cash receipts, operation receipts and statement matches with their parent links.
- Load account snapshots and reconciliation items after account and document identities are stable.
Set up Accounting Document and Account Reconciliation your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.