Accrual Reconciliation Report Format Discrepancies
Summary:
We observed discrepancies when running the standard Accrual Reconciliation Report in Excel versus CSV format.
- In Excel format for PO FHP013640:
- Line 1 net accrual balance = –$584.94
- Line 2 net accrual balance = –$240.45
- In CSV format, the lines are repeated, and same amounts are multiplied six times, showing inflated balances.
Business Requirement:
The business would prefer to use the report output in CSV format rather than Excel.
Request:
Please advise on the root cause of this discrepancy and provide a resolution so that the CSV output reflects the same values as the Excel output.
Content (please ensure you mask any confidential information):
Excel Format:
Tagged:
0