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.
- Accounting + Invoicing for Freelancers
- Data model and import order
The tables behind Accounting + Invoicing for Freelancers
Accounting + Invoicing for Freelancers 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
- Change it
- Add fields and tables in Proto
How the model is organised
Accounting documents:
Accounting documents connects Organization to Organizations, Owner to team members and Counterparty to business partners; record attachments retains supporting evidence.
Billable time:
Billable time connects Parent to accounting documents and Organization to Organizations, with Status and Revision for submission and review.
Clients and organization:
Organizations, business partners, team members and Users establish organization and user identity; team members.User references Users.
Ledger and balances:
Document lines links Instruction to accounting documents and Account to ledger accounts; account snapshots retains as of, ledger USD and available USD; exchange rates holds effective rates.
Cash reconciliation:
Cash receipts.Parent and cash applications.matched instruction connect cash evidence and applications to accounting documents; cash applications.Account references ledger accounts.
Review and evidence:
Review decisions links Parent and Reviewer to accounting documents and team members; operation receipts links the stable operation key and effect references to Parent; record attachments links uploaded by to team members.
Every table, by feature
- Accounting documents7
- Billable time5
- Clients and organization5
- Ledger and balances6
- Cash reconciliation6
- Review and evidence5
- Accounting documents
Accounting documents moving through preparation, independent review, posting and confirmation of their amounts.
Linked to Organizations, Team members, Business partners - Business partners
Clients, customers and other business partners eligible for accounting documents.
Linked to Organizations - Organizations
Organizations whose accounting, invoicing and time-tracking operations are run in this app.
- Team members
Preparers, reviewers, auditors and administrators working in the organization.
Linked to Users, Organizations - Record attachments
Supporting documents attached to an accounting document.
Linked to Accounting documents, Team members - Review decisions
Independent reviewer decisions recorded against a frozen document revision.
Linked to Accounting documents, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents
- Billable time
Billable time submitted against an accounting document for independent review and invoicing.
Linked to Accounting documents, Organizations - Accounting documents
Accounting documents moving through preparation, independent review, posting and confirmation of their amounts.
Linked to Organizations, Team members, Business partners - Organizations
Organizations whose accounting, invoicing and time-tracking operations are run in this app.
- Review decisions
Independent reviewer decisions recorded against a frozen document revision.
Linked to Accounting documents, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents
- Organizations
Organizations whose accounting, invoicing and time-tracking operations are run in this app.
- Business partners
Clients, customers and other business partners eligible for accounting documents.
Linked to Organizations - Team members
Preparers, reviewers, auditors and administrators working in the organization.
Linked to Users, Organizations - Users
Users
Linked to Users - Accounting documents
Accounting documents moving through preparation, independent review, posting and confirmation of their amounts.
Linked to Organizations, Team members, Business partners
- Ledger accounts
Ledger accounts and their positions, owned by a business partner.
Linked to Business partners - Document lines
Debit and credit line amounts that balance their accounting document.
Linked to Accounting documents, Ledger accounts - Account snapshots
Dated balance snapshots for a ledger account.
Linked to Ledger accounts - Exchange rates
Read-only effective exchange rates for this app.
- Accounting documents
Accounting documents moving through preparation, independent review, posting and confirmation of their amounts.
Linked to Organizations, Team members, Business partners - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents
- Cash receipts
Recorded statements, confirmations, settlement notices and corrections supporting an accounting document.
Linked to Accounting documents - Cash applications
Source-identified cash movements matched against accounting documents.
Linked to Ledger accounts, Accounting documents - Accounting documents
Accounting documents moving through preparation, independent review, posting and confirmation of their amounts.
Linked to Organizations, Team members, Business partners - Ledger accounts
Ledger accounts and their positions, owned by a business partner.
Linked to Business partners - Account snapshots
Dated balance snapshots for a ledger account.
Linked to Ledger accounts - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents
- Review decisions
Independent reviewer decisions recorded against a frozen document revision.
Linked to Accounting documents, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Accounting documents - Record attachments
Supporting documents attached to an accounting document.
Linked to Accounting documents, Team members - Accounting documents
Accounting documents moving through preparation, independent review, posting and confirmation of their amounts.
Linked to Organizations, Team members, Business partners - Team members
Preparers, reviewers, auditors and administrators working in the organization.
Linked to Users, Organizations
Keys and references
Preserve Id values across imports; exchange rates uses ID. Users uses its User reference and Email identity fields. Accounting documents.record number identifies the business document, while Revision identifies the version being reviewed. Review decisions.source revision must match the intended reviewed scope. Identify each billable time submission by Id as well as Parent and Revision. During setup, verify how the review operation key distinguishes submissions that share a parent and revision.
Keep provider event ID stable for cash receipts and cash applications. Provider snapshot ID identifies an account snapshots observation. Ledger accounts retains Provider and external account ID. Operation receipts.operation key identifies the attempted action; expected revision and effect references connect it to its intended and actual effects.
Amounts named amount USD, ledger USD, available USD and initial deposit USD use USD. Organization and account Currency values supply context; exchange rates.Currency, effective from and Rate require an agreed source and conversion policy. References must resolve by stable identity, never by a similar display name.
Migration order
- Load Organizations and Users with their approved identity mappings, resolving the Users.User reference through the platform’s identity process.
- Load team members and business partners, checking Organization references and active membership.
- Load ledger accounts, retaining provider identity. Reconcile exchange rates against its agreed read-only source and effective dates.
- Load accounting documents, then document lines, billable time and record attachments with their parent references and revisions.
- Load verified cash receipts, cash applications and dated account snapshots; reconcile source events and account positions.
- Retain existing review decisions and operation receipts as historical evidence without fabricating decisions or replaying old actions; reconcile totals before opening the pilot.
Set up Accounting + Invoicing for Freelancers your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.