Skip to content
Workflow · Reconcile · Opening soon

Three-way trust reconciliation

Export the trust ledger, the client balance list, and the bank statement from QuickBooks. Mammoth totals the trust ledger by client, matches client names, totals the bank Amount column, and compares the three balance sets.

Early access opens shortly. Check back soon.

Someone typed

“check last month's trust account three ways: each client's ledger balance against the total of that client's trust ledger entries, and the bank statement ending balance against the trust ledger total”

The agent read it as

Check last month's trust account three ways: each client's ledger balance against the total of that client's QuickBooks trust ledger entries, and the bank statement ending balance against the trust ledger total, using the bank statement Amount total and using QuickBooks trust client ledger balances for the listed client ending balances.

What the agent built

6 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    QuickBooks trust ledger
    CSV export · 35 rows
  2. File
    QuickBooks trust client ledger balances
    CSV export · 10 rows
  3. File
    QuickBooks bank statement
    CSV export · 30 rows
  4. Step
    Total trust ledger by client
    Step 1
  5. Step
    Match client balance names
    Step 2
  6. Step
    Total bank Amount
    Step 3
  7. Join
    Add bank statement total
    10 of 10 paired
  8. Join
    Add client balances
    10 of 10 paired
  9. Step
    Compare the trust balances
    Step 6
  10. Result
    Trust Account Checks
    11 rows · 4 flagged
  11. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 11 rows came out, and the join paired 10 of 10 rows; the join paired 10 of 10 rows.

What you get back

The result of that run, the rows to look at first.

Trust Account ChecksSample data11 rows
7 agrees4 amount differs
CheckClientClient ledger balanceTrust ledger entries totalBank statement Amount totalTrust ledger totalDifferenceStatus
Bank statement···21,45021,975-525Amount differs
Client balanceAlder Bio3,2002,300··900Amount differs
Client balanceEmber Logistics4,1005,000··-900Amount differs
Client balanceHarborview Dev1,2501,625··-375Amount differs
Client balanceBlue Harbor1,4501,450··0Agrees
Client balanceCedar Peak2,7502,750··0Agrees
Client balanceDune & Co1,8001,800··0Agrees
Client balanceFalcon Retail950950··0Agrees
Client balanceGranite Health2,3002,300··0Agrees
Client balanceIon Legal1,6751,675··0Agrees
Client balanceJuniper Studio2,1252,125··0Agrees
11 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Trust Account Checks workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Trust Account Checks: questions

How do you do a three way trust reconciliation?
Export the trust ledger, the client balance list, and the bank statement from QuickBooks. Mammoth totals the trust ledger by client, matches client names, totals the bank Amount column, and compares the three balance sets. You see which rows agree and which ones differ, so you can review the mismatches.
What export should you use from QuickBooks?
Use the exported trust ledger, the client balances list, and the bank statement export. The files need to include the client names, amounts, and the bank ending balance or balance-related fields needed for the check.
What happens to rows that do not match?
Rows that do not match are flagged as differences. They stay in the results so you can see which client balances or totals do not line up with the trust ledger or bank statement.
How do you change the rules in words?
You can change the rules by editing the matching and comparison instructions in plain language. For example, you can change which columns are treated as names or amounts, or change which totals are compared against each other.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.