Reporting
      Back to home
      1. Dye & Durham Knowledge Base
      2. Unity® Accounting
      3. Reporting

      Overview of a Bank Journal Report

      Includes Bank Journal Report Overview and How To Print Report

      The “Bank Journal” report provides a chronological list of transactions that affect the bank balance. The Bank Journal can be run for an individual bank account, for multiple or all bank accounts where the account is set to active. Inactive accounts will not display in the report filters. The Bank Journal report may be required to be printed/saved on a monthly basis depending on the Law Society rules in your province.

      The report includes the following information:

      • Batch Date
      • Transaction date
      • Audit Number
      • Description
      • Ref/Chq/EFT Number
      • Rec / EFT Number
      • Payment type
      • Client/Matter or GL Number
      • Name
      • G/L Account
      • G/L Description
      • Amount
      • Entry Total
      • Running Balance

      To print report:

      1. Click on Banking & Reconciliation
      2. Select the Bank Journal report
      3. Report Year - Select the report year for transactions to include in the report.
      4. Transactions From - Select the date range for transactions to include on the report.

      Note:

      • Default range is 01/01/1980 to current date. The From date is critical and must be before  any data has been entered that may affect the report as opening balances will not be included.

         5.   Bank Account - To report for a specific Bank Account, click on “Select” and select the relevant           Bank   Account. To report on all Bank Accounts, leave the default setting to “All.”

        6.    From Audit - Enter the audit number range to report on.

      Note: 

      • Default selection is “1 to 999999.” (All audit numbers)

           7.    Output Options - Select “View” to display the report on your screen, “Export to CSV” to export the   report or “Print” to print the report.

      Note:

      • The report can be exported to Excel or PDF from the “View” screen.

       

       Sample Report – Bank Journal Report 

       

      To Consider:

      Cheques that are displayed in the report will produce individual lines detailing the breakdown of how the cheque was expensed/disbursed.

       Receipts that are displayed in the report will produce individual lines detailing the Accounts Receivable Fees and Disbursement breakdown.


      Tips:

      • Select memorize to add the report with the current options to the memorized reports.  Report can only be added once to the memorized reports.