Accrual Reconciliation Report Format Discrepancies — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Accrual Reconciliation Report Format Discrepancies

edited Sep 5, 2025 5:18AM in Costing 4 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!