Skip to main content

​
What are account mappings?

An account mapping is a rule that says: “When this event happens, debit this account and credit that account.” Each mapping consists of three parts:
  1. Mapping Type — The category of event (e.g., Loan Property, Revenue Line Item, Commission Role)
  2. Mapping Key — The specific event within that category (e.g., “brokerCompensation,” “loanOfficer”)
  3. Debit Account / Credit Account — The chart of accounts entries to use for the journal entry
When the mapped event occurs (for example, a loan is funded), Keystone looks up the corresponding mapping and creates a journal entry using the specified debit and credit accounts. Account mappings are configured in Accounting > Account Mappings. Mappings are grouped by type, with dropdowns to select the debit and credit accounts for each.

​
How account mappings automate journal entries

Without account mappings, every financial event would require someone to manually create a journal entry — selecting the right accounts, entering the right amounts, and ensuring everything balances. Account mappings eliminate this by pre-configuring the accounting treatment for each event type. The automation flow works as follows:
  1. A loan event occurs (e.g., loan funded, check received, commission calculated).
  2. Keystone checks whether an account mapping exists for that event.
  3. If a mapping is found, the system creates a journal entry using the mapped debit and credit accounts.
  4. The entry is created as a Draft, so it can be reviewed before posting.
  5. The entry is linked to the source loan for traceability.
If no mapping exists for an event, no automatic journal entry is created. The event can still be recorded manually.

​
Mapping types

Account mappings are organized by type:

​
Loan Properties

These mappings handle financial events tied to loan-level properties:

​
Revenue Line Items

These mappings handle specific revenue components that may be tracked separately:

​
Commission Roles

These mappings handle commission payouts by role:

​
Setting up account mappings

Step-by-step:
  1. Navigate to the Account Mappings configuration page.
  2. Mappings are displayed in groups by mapping type (Loan Properties, Revenue Line Items, Commission Roles).
  3. For each mapping row:
    • The Mapping Key column shows the name of the event (e.g., “Broker Compensation”).
    • The Debit Account dropdown shows all accounts from your chart of accounts. Select the account that should receive the debit.
    • The Credit Account dropdown shows all accounts from your chart of accounts. Select the account that should receive the credit.
  4. Click the Save button (disk icon) on each row after making changes. The button is only enabled when you have unsaved changes.
  5. A success notification confirms the mapping was saved.

​
Debit and credit account selection

When choosing accounts for a mapping, follow the standard double-entry bookkeeping rules:
  • When money comes in (revenue earned, check deposited): Debit an asset account, credit a revenue account.
  • When money goes out (commission paid, expense incurred): Debit an expense account, credit an asset account (usually cash).
  • When an obligation is created (accrued expense, payable): Debit an expense account, credit a liability account.
  • When an obligation is settled (payable paid): Debit a liability account, credit cash.
If you are unsure which accounts to use, consult the Chart of Accounts documentation for account type descriptions.

​
Common mapping configurations for mortgage companies

Here is a typical set of account mappings for a mortgage brokerage:

​
When a loan is funded

This records the revenue earned and the amount owed by the lender.

​
When a lender check is received

This deposits the check and clears the receivable.

​
When commissions are paid

These record the commission payments as expenses against cash.

​
When a draw payment is issued

This records the draw advance as an asset (money owed back to the company).

​
When a draw is repaid

This reduces the draw advance balance when commissions exceed the draw.

​
Tips

  • Set up mappings before processing loans — If mappings are not configured, no automatic journal entries will be created. Set them up as part of your initial accounting configuration.
  • You can change mappings at any time — Updating a mapping affects only future events. Existing journal entries are not modified.
  • Use specific accounts for clarity — Rather than mapping everything to a generic “Revenue” account, use specific accounts like “Broker Compensation Revenue” and “Processing Fee Revenue” so your reports show detailed breakdowns.
  • Review generated entries — Automatic entries are created as Drafts. Build a habit of reviewing and posting them regularly.