Currently, when auditors want to reconcile Trial balances with Purchase accruals ( Purchase order receipts) with a report in the system there is very limited option available causing huge challenges with reconciliation of data.

The report-Accrued Purchases Excluding Sales Tax report although it gives data but it does not help with reconciliation as lot of manual effort is required to tidy up the data from this report. It would be good if this particular report also includes the below:

-The Accrued PO report displays data without sales tax and it shows only the net value, whilst the GL balance from the accrual account holds the gross amount.

-The report uses Cutoff date and no date range to be able to reconcile with actual Period balances. It would be good for this report to include correct filter criteria to be able to reconcile the report data with Trial balances.