Highest and Lowest Value Transactions

The Highest and Lowest Value Transactions report provides Ledger-wise Highest and Lowest Amount transactions along with the Difference Range and Difference Range Percentage.

To view Highest and Lowest Value Transactions report,

Go to Gateway of Tally > Audit & Compliance > Audit & Analysis > Other Analysis > Highest and Lowest Value Transactions

Note:

 

1. Difference Range: It is arrived by considering the Highest and Lowest Value Transaction of each ledger. Example: For ABC Bank Ledger,

 

* Highest Value Transaction is 1000

* Lowest value transaction is 200

 

Difference Range of ABC Bank (800) = Highest Value (1000) - Lowest Value (200)

 

2. Difference Range Percentage: it is arrived by dividing the Difference Range by Lowest value of a Ledger. Example: For ABC Bank Ledger,

 

* Lowest value transaction is 200

* Difference Range is 800

 

Difference Range Percentage of ABC Bank (400%) = Difference Range (800)/ Lowest Value (200)

The report displays the Highest Transaction Amount, Lowest Transaction Amount, Difference Range and Difference Range Percentage of all Ledgers. Users can drill down from the above report to view Ledger-wise Highest and Lowest Value Transactions.

To view the Ledger-wise Highest and Lowest Value Transactions report,

The basis for display of Highest and  Lowest transactions for a Ledger is also displayed on top of the screen.

Note:To display the Highest and Lowest Value Transactions for a Ledger by default 5 Highest value and 5 Lowest value transactions has been set.

 

Users can configure the display of Highest and Lowest Transactions by clicking on F12: Configure and alter the numbers to show highest and lowest transactions.

Button options in Highest  and Lowest Value Transactions report

F1: Detailed

Click on F1: Detailed or press Alt+F1 keys to view the detailed Highest  and Lowest Amount Transactions report.

F2: Period

Click on F2: Period or press F2 key to change the selected period.

F4: Ledger

Click on F4: Ledger or press F4 to select a different Ledger and display the Highest and Lowest Amount Transactions report for the selected ledger.

F8: Show Ledger

Click on F8: Show Ledger or press F8 to display the default Ledger Vouchers report for the selected Party along with the details of the Opening Balance, Current Total and Closing Balance.

F9: Audit

Click on F9: Audit or press Alt+F9 to audit the selected Voucher/Vouchers.

Note: The F9: Audit button will be highlighted when one or more Vouchers is/are selected for auditing using the spacebar key.

Ctrl+F10: Remove Audit

Click on Ctrl+F10: Remove Audit or press Ctrl+F10 to change the Audit Status for the selected Vouchers as Unaudited (blank).

S: Set Manual Sampling

Click on S: Set Manual Sampling or press Alt+S to mark the selected Vouchers (using spacebar) as sampled. The manual sampling method will get applied to all such Vouchers and they will appear under the sampled column on the dashboard.

D: Delete Manual Sampling

Click on D: Delete Manual Sampling or press Alt+D to delete the Manual sampling method already applied for the selected Vouchers (using the Spacebar key).

W: Working Note

Click on W: Working Note or press Alt+W keys to specify the working note details at Company or Group or Ledger or Voucher level. The details provided in working note will be captured in Audit Working Paper along with the details of User Name, Working Note Date & Time, Status, Note etc.

Ctrl+W: Audit Wkg Paper

To view the Audit Working Paper during Auditing, click on Ctrl+W: Audit Wkg Paper or press Ctrl+W keys. The details displayed in Audit Working Paper will be relevant to report from where it is triggered.

F9: Inv Reports

Click on F9: Inv Reports or press F9 key to navigate to the default Inventory Reports like Godown Summary, Movement Analysis, Stock Summary etc

F10: Acc Reports

Click on F10: Acc Reports or press F10 key to navigate to the default Accounting Reports like Balance Sheet, Cash Flow, Trial Balance etc.

F10: Audit Reports

Click on F10: Audit Reports or press Alt+F10 keys to navigate to the other Audit Reports within Statutory Audit and 44AB Audit (Tax Audit).

F12: Configure

Click on F12: Configure or press F12 to change the default view for the above report.

F12: Range

Click on F12: Range or press Alt+F12 to use the Range Filter option to search the specific Vouchers from the list of Vouchers under each Voucher Type.

Ctrl+F12: Value

Click on Ctrl+F12 or press Ctrl+F12 to filter the Vouchers and calculate the balances as per the specified conditions.