Trust account reconciliation
We compare your bank statement against your ledger and list the specific entries that produce the difference between them. You decide what corrections to make.
What we do not do
We do not record entries, prepare financial statements, or express an opinion on your records. We do not touch your books: corrections happen in your own system, made by you or your bookkeeper. We are not a CPA firm, and the report is not an audit, review, or compilation.
Why a Virginia firm needs this each month
Since 15 March 2020, Rule 1.15(d)(3) has required Virginia lawyers to reconcile trust accounts monthly and to approve an explanation of any discrepancy. Clio and TrustBooks show that a difference exists. Finding the entries behind it means someone going through the month line by line.
We send you those entries. The lawyer still approves the reconciliation, and the approval is a check of the named entries instead of a search through the month.
What you send
Two files for the same account and month:
- the bank statement, exported from online banking as CSV, OFX, or QFX;
- the ledger, exported from Clio, TrustBooks, QuickBooks, or a spreadsheet.
We use four columns from each: date, amount, check or reference number, and payee. We do not ask for memo fields, matter descriptions, or account numbers.
What you receive
Each month you receive an Excel workbook and a Word document.
The workbook has one sheet per list. Amounts and dates are stored as Excel numbers and dates, so you can sort and filter them.
- The bank’s balance and your ledger’s balance at each month end, and whether they agree.
- Ledger entries the bank has not shown yet, such as uncashed checks, with the number of days each has been outstanding. Entries outstanding more than 90 days are marked.
- Bank transactions that have no entry in your ledger.
- Near matches: a bank transaction beside the ledger entries it could be, with how many days apart they are and the words they share, for you to decide.
- For a trust account, the bank balance, the ledger’s trust balance, and the sum of your client ledgers at each month end, set side by side.
- Any client balance that went below zero during the month, and the entry that took it there.
- What changed since the previous month’s report.
[Screenshot of an anonymised report]
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.
In a month when the accounts match, the workbook says so and lists any items that have not cleared yet.
How long it takes
Once your setup is done, we aim to have the report in your hands within two business days of receiving the two exports.
Setup happens once, in the first month. We learn the export formats of your bank and your ledger and build the import for them. If we have worked with your bank and ledger before, setup is short. Every month after that starts from the finished setup.
What happens after the report is yours. In a month when the accounts agree, you read a short list of uncleared items and approve. In a month with many unmatched entries, the corrections take as long as there are entries to correct, and you work from a list of named transactions.
How we handle your files
Before you send anything, we sign a written confidentiality agreement with you and send our data terms. We delete your files [30 days] after the report is delivered, or sooner if you ask.
[Planned: this script is not written yet.] If you would rather we never see payee names, we supply a short script that replaces each payee with a code before you send the files, and you keep the key. In that mode we can match only identical spellings, so “J. Doe” and “John Doe” come back as two unmatched payees. The price is the same.