I’m a small law firm using QBO with a credit card processor. Funds flow through a merchant clearing account before hitting our IOTA trust account.Setup:Merchant clearing account (bank-type) used as pass-throughIOTA trust account (real bank)Client Trust Money liability sub-accounts per clientIOTA balance must always equal total trust liabilityWhat happened:11/11/2025: $2,000 client payment recorded as a deposit into the merchant clearing account, credited to the appropriate Client Trust Money sub-account (unreconciled)11/14/2025: $2,000 hit IOTA, but bank feed recorded it as a deposit into IOTA, not a transfer from the merchant clearing account (reconciled/locked)That 11/14 deposit reduced the merchant clearing account during reconciliation, even though it’s not a true transfer entryCurrent state:Cash is correct (funds are in IOTA)Client trust liability is correct (now $0 after proper disbursement)The 11/14 deposit is locked and cannot be changedThe 11/11 deposit in the merchant clearing account remains as a phantom unreconciled $2,000What I tried (unsuccessfully):Attempted to edit the 11/14 deposit into a transfer (blocked due to reconciliation lock)Created journal entries to simulate the transfer (caused liability duplication or distorted balances)Tried reconciling the 11/11 deposit in a later period (created a $2,000 discrepancy)Attempted to pair entries across accounts (resulted in double-counting in IOTA)Ultimately reversed all attempted fixes to return to the current stateGoal:Clear the unreconciled $2,000 in the merchant clearing account without:Changing IOTA balanceAffecting Client Trust Money liabilityReopening prior reconciliationsQuestion:What is the cleanest way to eliminate the unreconciled merchant clearing entry?Specifically:Is the correct approach to offset it with a journal entry to an equity or clearing account?Or is there a better way to simulate the missing transfer without duplicating the IOTA deposit?How would you handle this while preserving a clean audit trail?Looking for the simplest correction that keeps trust accounting intact and avoids reopening reconciliations.

Question

Merchant clearing → trust transfer entered as deposit (locked) — clearing unreconciled intake without breaking trust balances

Forum|Forum|3 months ago
March 30, 2026
2 replies
7 views

I’m a small law firm using QBO with a credit card processor. Funds flow through a merchant clearing account before hitting our IOTA trust account.

Setup:

Merchant clearing account (bank-type) used as pass-through
IOTA trust account (real bank)
Client Trust Money liability sub-accounts per client
IOTA balance must always equal total trust liability

What happened:

11/11/2025: $2,000 client payment recorded as a deposit into the merchant clearing account, credited to the appropriate Client Trust Money sub-account (unreconciled)
11/14/2025: $2,000 hit IOTA, but bank feed recorded it as a deposit into IOTA, not a transfer from the merchant clearing account (reconciled/locked)
That 11/14 deposit reduced the merchant clearing account during reconciliation, even though it’s not a true transfer entry

Current state:

Cash is correct (funds are in IOTA)
Client trust liability is correct (now $0 after proper disbursement)
The 11/14 deposit is locked and cannot be changed
The 11/11 deposit in the merchant clearing account remains as a phantom unreconciled $2,000

What I tried (unsuccessfully):

Attempted to edit the 11/14 deposit into a transfer (blocked due to reconciliation lock)
Created journal entries to simulate the transfer (caused liability duplication or distorted balances)
Tried reconciling the 11/11 deposit in a later period (created a $2,000 discrepancy)
Attempted to pair entries across accounts (resulted in double-counting in IOTA)
Ultimately reversed all attempted fixes to return to the current state

Goal:
Clear the unreconciled $2,000 in the merchant clearing account without:

Changing IOTA balance
Affecting Client Trust Money liability
Reopening prior reconciliations

Question:
What is the cleanest way to eliminate the unreconciled merchant clearing entry?

Specifically:

Is the correct approach to offset it with a journal entry to an equity or clearing account?
Or is there a better way to simulate the missing transfer without duplicating the IOTA deposit?
How would you handle this while preserving a clean audit trail?

Looking for the simplest correction that keeps trust accounting intact and avoids reopening reconciliations.

QuickBooks Online

Z

ZackE_

Moderator

Thanks for reaching out to the Community, DAShul. I appreciate your detailed information.

To properly identify which way you should clear an unreconciled amount from a specific clearing account, I'd recommend working with an accounting professional.

If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

I've also included a couple detailed resources about reconciling and creating journal entries which you may find useful moving forward:

Please feel welcome to send a reply if there's any additional questions. Have a wonderful Monday!

Rainflurry

Level 11

@DAShul

"That 11/14 deposit reduced the merchant clearing account during reconciliation, even though it’s not a true transfer entry"

If the 11/14 deposit reduced the merchant clearing account, then how is the merchant account overstated by $2,000?

What account (category) is assigned to the 11-14 deposit? QB uses double-entry accounting, so if the merchant clearing account is $2,000 overstated, then there must be another account that is also $2,000 under/overstated. You will need to find that entry, then you can clear the $2,000 balance in the clearing account by creating a journal entry that debits the other under/overstated account and credits the clearing account. Or, use an expense or check transaction - use the clearing account as the payment account and the other under/overstated account as the category. A check/expense transaction does the same as a journal entry, and they show on some reports that ignore JEs.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded