The Accounts Payable and Retainage Payable amounts shown on my Balance Sheet have an identical variance to what is shown for Net Unpaid Balance and Retainage Payable amounts shown on the Invoice Aging w/ Cut-off Date report. The total AP/Retainage amounts match, but the splits are different. I have tried various ways of researching this but can not narrow down the source of the issue. Any suggestions on how to properly research and correct this variance?

Ex:

Balance Sheet: Accounts Payable - $1,500,000

Balance Sheet Retainage Payable - $250,000

Invoice Aging Rpt: Net Unpaid Balance - $1,525,000

Invoice Aging Rpt: Retainage Payable: $225,000