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

DAShul · ‎March 30, 2026

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.

ZackE

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

@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.

Topics

Training

Community

Resources

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

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

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

Need to get in touch?