4. Start by looking at Vendor 0 (zero) (transactions without vendor numbers). You could have conversion transactions with the source of Payables-New and Ledger. These conversion entries should net to zero. If not, you will need to make the necessary adjustment to correct these conversion entries. If your 2015 is currently in balance, you will need to do an adjustment to 2014 and then reverse it out in 2015 so 2014 is back in balance and 2015 stays in balance.
5. If the out of balance issue is not found here (or only partially here), keep this List open for comparison purposes and return to the Control Account Reconciliation and Click the hyperlink in the Open column. A new tab labeled Payables will open.
Be sure the ending custom date is 12/31/2019.
Be sure the ending custom date is 12/31/2019.
Follow the same steps to group this report by “Name” (Vendor Name)
Compare the two lists vendor by vendor to see which do not match.
Once the vendor is located, the Account List can be grouped further by “Bill Invoice” and the Payables List can be grouped further by Reference to determine the exact vendor bill that is causing the discrepancy.
Once the vendor is located, the Account List can be grouped further by “Bill Invoice” and the Payables List can be grouped further by Reference to determine the exact vendor bill that is causing the discrepancy.