Trust reconciliation in 4 steps before you close

• Select the correct bank account before starting, as PracticePanther instructs users to ensure the correct Bank Account is selected.
• Check the difference status frequently; if the Difference is not zero, your reconciliation is incomplete according to PracticePanther.
• Record any missing transactions in the software to match the bank records, following the solution provided by PracticePanther.
• Complete the process each month to ensure financial records are accurate and complete, which PracticePanther notes helps identify and resolve discrepancies.

This workflow identifies discrepancies and finalizes monthly trust reconciliations.

Smokeball's article will guide you through the core components of trust accounting with links to more in-depth resources where applicable, according to Smokeball. In Smokeball, trust transactions are handled from within a client's matter, according to Smokeball. Administrators can review these matter-based transactions to confirm that all client funds are accounted for correctly. The goal is to match these internal records against the bank statement to verify accuracy. This alignment is the foundation of a compliant trust account management process.

The following table documents specific trust accounting capabilities for three legal software publishers, based strictly on their supplied descriptions. Each row lists the publisher and the exact functional scope they claim for their trust accounting features.

These capabilities vary by platform, so verify which features align with your firm’s specific reconciliation workflow before selecting a tool. See Online retainer requests on 4 billing tools when you set up how clients send retainers.

Begin the monthly trust reconciliation by confirming the specific financial source you are reviewing. According to PracticePanther, ensure the correct Bank Account is selected before proceeding with any data entry or verification tasks. This initial selection prevents the risk of matching internal records against the wrong external statement, which is a common source of reconciliation errors in legal practice management.

Once the correct account is active, use the available navigation tools to sort the transaction list efficiently. According to PracticePanther, by using the Reconciled Status filter at the top of the page, you can navigate between your Payments that have been reconciled, and those not yet reconciled. This filter allows you to isolate the specific subset of transactions that require your attention for the current period, separating them from those already verified in previous cycles.

Focus your review on the items marked as not yet reconciled, as these represent the outstanding work for the current month. The Reconciled Status filter provides a clear visual distinction between completed and pending items, streamlining the workflow for administrators managing multiple client matters. By applying this filter, you limit the visible list to only those payments that need verification against the bank statement, reducing the time spent scanning through historical data.

Select the date range that corresponds to the current reconciliation period to ensure all relevant transactions are captured. While the filter helps organize the payment status, the date range defines the scope of the reconciliation task. Aligning the software’s date selection with the bank statement’s period is essential for an accurate comparison.

Reviewing discrepancies is a critical part of the reconciliation process. If the balances still don't match, revisit each step, carefully reviewing for any discrepancies, according to PracticePanther. This iterative check helps ensure that every transaction is accounted for before moving forward.

To verify the total amounts involved in your reconciliation, use the filters available in your software. Based on the filters selected, the data bar at the top of the page will display the total amount of deposits and withdrawals, according to PracticePanther. Comparing these totals against your bank statement is a practical way to spot large variances quickly.

Once you have reviewed the individual transactions and the total amounts, check the difference status. If the Difference is not zero, your reconciliation is incomplete, according to PracticePanther. Do not finalize the reconciliation until this difference is resolved.

When you find a discrepancy, take the following actions:

• Check the date range: Ensure you are looking at the correct month. A transaction might be recorded in the wrong period.
• Verify the amount: Look for typos or incorrect amounts entered in the software.
• Match the description: Compare the description in your software to the bank statement to ensure they refer to the same transaction.
• Look for missing entries: Check if a transaction is in the bank statement but not in your software, or the reverse.

If you cannot find the source of the discrepancy, contact your bank or review your original transaction records. It is better to take extra time to find the error than to finalize an incorrect reconciliation.

Remember, the goal is to have a zero difference. If you are stuck, consider asking a colleague to review your work. A fresh set of eyes can often spot the error that you have missed.

When your internal records do not align with the bank statement, you must address the specific gaps before proceeding. According to PracticePanther, the solution is to carry these outstanding withdrawals forward into the next reconciliation. This approach keeps the current month’s books accurate. Do not delete or ignore these items; instead, retain them in the outstanding list so they appear again during the following month’s review.

Conversely, if the bank statement shows a transaction that is missing from your software, you must create the record manually. According to PracticePanther, the solution is to record the missing transaction(s) in PracticePanther to match the bank records. This step ensures that your internal record reflects every movement of funds documented by the bank. When entering these missing entries, verify the date, amount, and description against the bank statement to prevent new discrepancies.

Carrying forward outstanding withdrawals and recording missing transactions are distinct actions with different outcomes. Outstanding withdrawals remain on the books as pending items until they clear, while missing transactions become permanent entries in your historical record. By handling these two types of discrepancies separately, you maintain a clear audit trail. If you skip the step to record missing transactions, your total trust balance will remain incorrect, potentially leading to compliance issues. If you fail to carry forward outstanding withdrawals, you may double-count them in the next month or lose track of pending client payments.

Completing this process each month ensures that your financial records are accurate, complete, and that any discrepancies are identified and resolved, according to PracticePanther. The finalization step requires confirming that the reconciliation difference is zero before closing the period. This verification confirms that the internal trust account record matches the bank statement exactly for the selected date range.

Jurisdiction-specific rules may impose additional documentation requirements beyond the software reconciliation itself. For example, the North Carolina State Bar notes that this requirement has been around since the adoption of the original Rules of Professional Conduct in 1985, according to North Carolina State Bar. The revisions to these rules went into effect when approved by the North Carolina Supreme Court on May 4, 2000, according to North Carolina State Bar. The revised rules can be found in the complete Revised Rules of Professional Conduct on the State Bar’s website, www.ncbar.com, and in the 2001 Lawyer’s Handbook which will be distributed this spring to all active members of the Bar, according to North Carolina State Bar.

Firms should also verify that specific bank directives are on file, as compliance audits may check for these documents. Bruno’s report to the Ethics Committee frequently mentions that a significant number of the lawyers he audits do not have on file a copy of the bank directive required by Rule 1.15-2(k), according to North Carolina State Bar. This highlights the importance of maintaining supporting documentation alongside the reconciliation record.

To finalize the reconciliation, confirm that all outstanding items from the previous month have been resolved or properly carried forward. Ensure that no missing transactions remain unrecorded. Once the difference is verified as zero and all required documentation is confirmed, mark the reconciliation as complete in your legal practice management software. This closes the accounting period for that month and prepares the account for the next cycle.

A bank statement shows deposits of 980 and withdrawals of 450. The software, on the same filters, shows deposits of 980 and withdrawals of 490. The difference is not zero, so the reconciliation is incomplete. The 40 gap is on the bank statement and missing from the software, so you record it. Both sides then show withdrawals of 490 and the difference is zero. An outstanding withdrawal of 70 is carried forward until it clears. These figures are illustrative only.

Today, confirm the correct bank account and the month's date range, then review only the payments that are not yet reconciled.

What should I do if the reconciliation difference is not zero?

You must revisit the previous steps to review any discrepancies before proceeding. This status indicates that the internal records do not yet match the bank statement totals.

How do I handle outstanding withdrawals that do not match?

The solution is to carry these outstanding withdrawals forward into the next reconciliation according to PracticePanther. This practice keeps the current month's balance accurate while tracking pending items. Do not delete these entries from the current period's records.

Can I view in-progress reconciliations in PracticePanther?

By using the Reconciled Status filter at the top of the page, you can navigate between your Payments that have been reconciled, and those not yet reconciled according to PracticePanther. This filter helps you identify which items still require attention. It allows you to focus on incomplete tasks without reviewing the entire account history.

What is the benefit of completing this process each month?

Regular verification prevents small errors from compounding over time. It supports the ongoing integrity of your trust account management.

How do I see what should have been in the trust account for a month?

The data bar at the top of the page shows the total deposits and withdrawals for the filters you selected, according to PracticePanther. Compare those totals with the bank statement for that month.