Skip to content

Journal entry scenarios

What the subledger records for each kind of change. See How it works for the calculation, and Accounting state mappings for how stages map to states.

Example accounting state mappings

Stage Accounting state
Prospecting Uncommitted
Closed Lost Uncommitted
Pledged Committed
Closed Won Finalized

Allocation trigger scenarios

Trigger event Scenario Result
Insert New allocation is entered (amount must be positive) Credit journal entry for allocation amount
Update Allocation amount is increased Credit journal entry with delta
Update Allocation amount is decreased Debit journal entry with delta
Update Allocation GAU is changed Off-setting debit/credit journal entries for allocation amount
Update Allocation GAU is changed while amount is changed Debit journal entry with old GL for old amount (full), credit journal entry with new GL for new amount (full)
Delete Allocation is deleted (amount must have been positive) Debit journal entry for full amount

Receivable scenarios

While an opportunity is committed, its open amount (amount minus paid and written-off payments) is debited to receivable accounts: each allocation's proportional share goes to its GAU's Receivable GAU, or to the default receivables account when the GAU has none, and any unallocated amount goes to the default receivables account. Shares are rounded to the cent and always sum to the open amount. See Receivable GAUs.

Trigger event Scenario Result
Update Opportunity reaches a committed state Credit journal entry per allocation for the revenue account, debit journal entry per allocation for the receivable account
Update Opportunity leaves the committed and finalized states Off-setting journal entries for every recorded account, including each receivable account
Insert / Update Payment is paid or written off Debit journal entry for the payment or write-off account, credit journal entries releasing each fund's receivable in proportion to its allocation
Update Allocation is moved to a GAU with a different Receivable GAU Off-setting debit/credit journal entries for the old and new receivable accounts
Update GAU's Receivable GAU is set or changed Every committed opportunity allocated to the GAU is recalculated (real-time mode) or queued for the scheduled job (scheduled mode)
Update Opportunity amount exceeds its allocations The unallocated share of the open amount is debited to the default receivables account

Worked example: a $1,000 pledge allocated $600 to Fund A (Receivable GAU "Fund A Receivable") and $400 to Fund B (no Receivable GAU), with $300 paid.

Account Debit Credit
Fund A 600.00
Fund B 400.00
Payment account 300.00
Fund A Receivable 420.00
Default receivables account 280.00

Write-off scenarios

Trigger event Scenario Result
Update Payment is written off Debit journal entry per payment allocation for the GAU's Write-Off GAU, or the default write-off account; any amount the allocations do not cover goes to the default write-off account. The receivable is released by the written-off amount
Update Written-off payment is paid instead Credit journal entries for the write-off accounts, debit journal entry for the payment account

Payment trigger scenarios

Trigger event Scenario Result
Insert New payment is entered as paid Debit journal entry for payment account
Update Payment amount is increased Debit journal entry with delta
Update Payment amount is decreased Credit journal entry with delta
Update Payment method is changed Off-setting credit/debit journal entries for old/new payment accounts
Update Existing payment is marked as paid Debit journal entry for payment account
Update Paid payment is written off Credit journal entry for payment account
Delete Payment is deleted Credit journal entry for full amount
Undelete Paid payment is restored Debit journal entry for full amount