Bank Client/Trust Account Reconciliation Report

  • Updated

For our Asia-Pacific customers, the term "Trust Account" is used, while European customers refer to it as "Client Account". It's important to mention that the Client/Trust Accounting functionality does not apply to customers in North America. For further information on regional terms, check out our Glossary of Regional Terminology.

Whether you're wrapping up an accounting period or just keeping tabs on your account status for a specific timeframe, the Bank Trust Account Reconciliation Report is a fundamental resource for keeping your financial records precise and compliant. In this article, we'll demystify this report and guide you on how to use it effectively to reinforce your financial integrity.

 

What is the Bank Trust Account Reconciliation Report?

The Bank Trust Account Reconciliation Report is a vital document that aligns your accounting records in three crucial areas: 1) the cashbook, 2) the bank statement that's been reconciled, and 3) the ledger balances. This trinity of consistency is the backbone of a well-maintained Client/Trust Account, with matching figures signalling a correctly balanced account.

Though primarily produced at the end of an accounting period, this report can also be accessed at any time for custom date ranges through the Client/Trust Accounting Reports section, based on process dates.

 

Generating the Report at Close of a Period

Included in the suite of documents for the End-of-Accounting-Period activities, this report encompasses all transactions up to the point of closure. Upon completion of an accounting period, the system automatically produces the Bank Trust Account Reconciliation Report, which comprehensively includes all pertinent financial transactions.

 

Generating the Reporting Outside the Close of a Period

For report generation at times other than the period closing:

  1. Go to Reporting via the main menu.
  2. Click on Client/Trust Accounting and locate Reconciliation to find the Bank Client/Trust Account Reconciliation report.
  3. In the Report For section, select the company.
  4. Pick the applicable Bank Account (Client or Trust Account).
  5. Finally, choose the timeframe you wish to cover in the report.

Screenshot of Trust Accounting_ Bank Trust Account Reconciliation - Re-Leased (1).jpg


Report Details

The report includes several key figures:

  • The opening cashbook balance at the beginning of the period.
  • Total processed transactions within the period.
  • The closing cashbook balance at the period's end.
  • The bank statement balance as of the closing date.
  • Adjusted bank balance after all presented items.
  • Total ledger balances as of the closing date.

When these numbers match, you can rest assured that your Trust/Client Account is in good order and accurately reconciled.

 

Screenshot of Trust Accounting_ Bank Trust Account Reconciliation - Re-Leased.jpg

 


With your filters set, you have a couple of options:

  • Generate the report for immediate viewing by selecting Generate Report on Screen.
  • To obtain a copy file, Download as CSV or PDF (Portrait / Landscape), respectively.

chrome_IPKuMJMubV.png

 

Complementary Reports for Thorough Analysis

To gain a more detailed financial understanding, refer to these accompanying reports:

  • The Cashbook Report, which reflects the cashbook section for the selected period.
  • Bank Statement Reports that confirm the opening and closing balances for your statements.
  • The Trial Balance Report that showcases ledger balances as of your report's end date.

 

Regularly producing and reviewing your Bank Trust Account Reconciliation Report, along with its related financial statements, enhances your capacity for maintaining impeccable records and preparing for audits or financial assessments.

Was this article helpful?