Skip to main content

Finalizing a Transaction & Posting Commissions to the General Ledger

Updated over a week ago

Getting started

The "Post to general ledger" window allows you to record all financial aspects of your commission transactions. This guide explains how to post commission transactions to your accounting general ledger and QuickBooks after they've been finalized.

What you can record

Basic information

  • Posting Date: The date the transaction will be recorded in your accounting system

Income (Accounts Receivable)

  • Commission Income: The total gross commission you've earned.

How the payer contact is selected

When you post a commission transaction, the system automatically selects a contact to associate with the Commission Income line item.

The payer is determined based on both (1) the side of the transaction (buyer or seller) and (2) the available contacts on that side. Here’s how it works:

  • If the transaction represents the seller, the system will attempt to populate the payer using the following order:

    1. Title Officer (if one exists)

    2. Seller’s Attorney

    3. Seller

  • If the transaction represents the buyer, the system uses the representing contact from the seller’s side (typically the seller's brokerage) as the payer. In this case, Title Officer or Buyer-side contacts will not auto-populate.

If no appropriate contact is found, the payer field may remain blank and should be completed manually.

  • Other Income: Any additional income related to the transaction, shown as separate line items.

Expenses (Accounts Payable)

  • Pre-commission deduction: The broker and agents share expenses before splitting the commission. This creates a separate bill payable to a third party.

  • Agent commission: The portion of commission paid to agents, minus any itemized deductions.

  • Post-commission deduction (broker): Expenses the broker pays after the commission split. Creates a separate bill payable to a third party.

  • Post-split deduction (agent to third party): Expenses the agent pays to a third party. Creates a separate bill payable to that third party.

  • Post-split deduction (agent to broker): An amount deducted from the commission after the commission split. This can be paid to any designated party. No separate bill is created; the amount is deducted from the commission.


What are item types?

Each line item posted to the general ledger falls under a predefined item type, which helps determine which memory or default rules to apply. These types include:

  • TGC (Total Gross Commission)

  • Shared Income / Unshared Income

  • Pre-commission Deduction / Pre-split Deduction

  • Post-split Deduction / Post-commission Deduction

  • Net Commission

  • Office Income

You don’t need to manage these item types directly, the system uses them internally to organize and map your posting logic.


How GL account memory works

When you post commissions to the general ledger, the system remembers which GL accounts you’ve previously selected for each type of income or deduction line. This helps you save time and stay consistent when posting future transactions.

The system uses this memory to automatically assign GL accounts to each line item using the following order of priority:

  1. Match by agent, item type, and item name

  2. If no match, it checks item type and item name

  3. If still no match, it checks agent and item type

  4. If no match is found, the system will assign a default GL account:

    • Other Income for income-type items

    • Other Expenses for deduction-type items

For example, if you previously selected a specific account for “Post-split deduction - Sign Install Fee” for Agent A, the system will remember that and reapply it automatically the next time.


Payments & Adjustments

You can record payments (either made or received) in two ways:

  1. Through the Action > Post to general ledger option

  2. In the transaction's Ledger submenu

Important: After clicking "Post" in the "Post to genera ledger" window, that window can no longer be accessed for that transaction. However, you can still record payments and adjustments through the Ledger submenu.

Handling "Paid at table" transactions

In "paid at table" scenarios, a title company, attorney, or other third party distributes commissions and expenses directly to all parties involved. As the broker, you only receive your net profit. However, for proper tax and financial reporting, you should still record the total income and expenses.

To handle this correctly:

  1. Click the "Pay at table" button in the Post Commissions to GL window

  2. This automatically creates payments to a clearing bank account to record all income/expense activity

  3. Select the specific bank account where your net profit should be posted

QuickBooks Integration

Please remember to check the QuickBooks V2 integration setup instructions for detailed configuration guidance.

To ensure proper syncing with QuickBooks:

For Invoices (Income)

  • Your system's GL Account Name must exactly match a QuickBooks service name

  • In QuickBooks, you can map this service name to a specific GL account

For Bills (Expenses)

  • Your system's GL Account Name must exactly match the QuickBooks GL account name

  • Unlike invoices, there's no intermediary mapping step

Did this answer your question?