1. Petty Cash Management
  2. Data model
Reference

The tables behind Petty Cash Management

Petty Cash Management 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 and Users identify entity and membership; business partners identify counterparties.

Source expense:

Accounting documents carries the revision and status; document lines detail amounts; cash vouchers carries custody and receipt reference.

Review and evidence:

Review decisions, record attachments and operation receipts preserve decisions, files and action outcomes.

Posting:

Accounting periods, ledger accounts, journal entries and journal lines connect an approved source to ledger effects.

Received cash:

Cash receipts and cash applications distinguish receipt verification from application to a document. Exchange rates holds effective rate records.

Every table, by feature

Cash vouchers

3 tablesAbout this feature
  • Cash vouchers

    Petty cash vouchers with custodian custody and approval

    Linked to Accounting documents, Organizations
  • Accounting documents

    Core accounting documents with lifecycle and revision

    Linked to Organizations, Team members, Business partners
  • Record attachments

    Evidence files attached to accounting documents

    Linked to Accounting documents, Team members

Accounting documents

5 tablesAbout this feature
  • Accounting documents

    Core accounting documents with lifecycle and revision

    Linked to Organizations, Team members, Business partners
  • Document lines

    Line items belonging to an accounting document

    Linked to Accounting documents, Ledger accounts
  • Record attachments

    Evidence files attached to accounting documents

    Linked to Accounting documents, Team members
  • Business partners

    Vendors and counterparties for petty cash spend

    Linked to Organizations
  • Cash vouchers

    Petty cash vouchers with custodian custody and approval

    Linked to Accounting documents, Organizations

Review and evidence

5 tablesAbout this feature
  • Review decisions

    Independent reviewer decisions per document revision

    Linked to Accounting documents, Team members
  • Record attachments

    Evidence files attached to accounting documents

    Linked to Accounting documents, Team members
  • Operation receipts

    Idempotent operation receipts for guarded commands

    Linked to Accounting documents
  • Accounting documents

    Core accounting documents with lifecycle and revision

    Linked to Organizations, Team members, Business partners
  • Team members

    Staff with organization membership and role scope

    Linked to Users, Organizations

Journal and periods

6 tablesAbout this feature
  • Journal entries

    Balanced journal entries posted from documents

    Linked to Accounting documents, Accounting periods
  • Journal lines

    Debit and credit lines of a journal entry

    Linked to Ledger accounts, Journal entries
  • Ledger accounts

    Chart of accounts for journal posting

    Linked to Organizations
  • Accounting periods

    Open, review and closed accounting periods

    Linked to Organizations
  • Accounting documents

    Core accounting documents with lifecycle and revision

    Linked to Organizations, Team members, Business partners
  • Operation receipts

    Idempotent operation receipts for guarded commands

    Linked to Accounting documents

Receipts and applications

5 tablesAbout this feature
  • Cash receipts

    Verified cash receipts from providers

    Linked to Business partners
  • Cash applications

    Applications of receipts against documents

    Linked to Accounting documents, Cash receipts
  • Accounting documents

    Core accounting documents with lifecycle and revision

    Linked to Organizations, Team members, Business partners
  • Business partners

    Vendors and counterparties for petty cash spend

    Linked to Organizations
  • Operation receipts

    Idempotent operation receipts for guarded commands

    Linked to Accounting documents

Operations overview

6 tablesAbout this feature
  • Accounting documents

    Core accounting documents with lifecycle and revision

    Linked to Organizations, Team members, Business partners
  • Journal entries

    Balanced journal entries posted from documents

    Linked to Accounting documents, Accounting periods
  • Journal lines

    Debit and credit lines of a journal entry

    Linked to Ledger accounts, Journal entries
  • Operation receipts

    Idempotent operation receipts for guarded commands

    Linked to Accounting documents
  • Review decisions

    Independent reviewer decisions per document revision

    Linked to Accounting documents, Team members
  • Cash vouchers

    Petty cash vouchers with custodian custody and approval

    Linked to Accounting documents, Organizations

Shared and settings

3 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Organizations

    Legal entities operating petty cash

  • Users

    Users

    Linked to Users

Keys and references

Accounting documents is the parent of document lines, cash vouchers, review decisions, record attachments, operation receipts, journal entries and cash applications. Journal lines belongs to journal entries and references ledger accounts. Cash applications also references cash receipts. A reviewer and attachment uploader reference team members. These links let a document number lead to its decisions and effects.

Migration order

  1. Prepare Organizations, Users and team members, then business partners and ledger accounts.
  2. Set accounting periods and any required exchange rates records.
  3. Bring in accounting documents, document lines and record attachments.
  4. Add cash vouchers and review decisions with their parent references.
  5. Add journal entries and journal lines, then cash receipts and cash applications.
  6. Preserve operation receipts with their source keys and effect references.

Set up Petty Cash Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started