Trust account reconciliation with no new software to learn
Every month you have to explain why the trust balance in your books differs from the bank statement, and the explaining is quick once you know which transactions caused it. Finding them is the slow part, and that is the part we do. Send us the bank statement and an export from Clio or QuickBooks, and we aim to have a spreadsheet in your hands within two business days, listing the specific entries that account for the difference. You look over the list, make the corrections you think are right, and sign off.
How it works
- Export the month’s statement from online banking as a CSV or OFX file, and export the same account and month from your ledger: Clio, TrustBooks, QuickBooks, or a spreadsheet.
- When you have both files, send them through the channel your engagement terms name.
- We aim to send back the workbook and the Word document within two business days of getting them. In the first month, that count starts once we have set up for your bank’s and ledger’s exports.
What you receive
Each month you receive an Excel workbook and a Word document. The workbook lists ledger entries the bank has not shown, bank transactions with no ledger entry, and near matches for you to decide, each with its date and amount. For a trust account it also sets the bank balance beside the ledger and the sum of your client ledgers at month end.
The Word document sets out possible explanations for the difference. Each one is a lead to check against your records, to narrow down where to look, and you decide which, if any, applies.
[Screenshot of an anonymised report]
Price
$50 a month, paid by bank debit or card. How the price works