1. A vendor reaches out to you about their outstanding balance claiming we owe them money. Given the data on the Vendor X A/P tab, reconcile the account (Invoice amounts vs. Payments made) and identify the true outstanding balance, if any. **Assume that all payments are made the month following the invoice date.
   1. Present the data in a way that will make the result clear for internal management as well as the vendor.

Month Invoices Received from Vendor X Amount Invoice # 5/31/19 $338,207.75 6/30/19 $326,178.25 7/31/19 $226,871.00 8/31/19 $297,285.00 9/30/19 $287,393.25 1125 1289 1347 1443 1592 Cirkul Payments to Vendor X - Payment Date Amount 06/06/2019 75,000.00 06/07/2019 75,000.00 . 06/11/2019 75,000.00 06/17/2019 150,000.00 07/12/2019 82,020.25 07/25/2019 75,000.00 08/07/2019 75,000.00 09/11/2019 227,563.50 09/30/2019 287,389.25 - 10/10/2019 378,995.75