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:

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.

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