I have a client that had their system set up that when a vendor invoice was posted, based on the payment method, BC automatically created the payment entry and posted. In this instance, the actual payment was not sent to the vendor. Since this was not created from a journal entry, I am unable to reverse the payment. I have unapplied it to the invoice on the vendor ledger and created a Cash Receipt "Refund" to apply against the auto-generated payment, but BC still has odd amount showing as remaining on the bank ledger entry side. Here's the breakdown of what happened.
- Invoice received and posted for $7473.10
- Auto payment created for $7473.10 but not sent to vendor - can't reverse due to not being created from a journal
- Created a Cash Receipt "Refund" for the auto-payment of $7473.10.
- BC bank ledger entries show that the payment entry has $30.61 remaining even after applying the full amount of the "refund"
Actual Vendor transactions:
- Invoice received for $7473.10
- Vendor re-issued invoice for $7442.49
- Credit Memo created for $30.61 and applied against the invoice
- Payment by check was issued to vendor for $1140.20
- payment created in BC and showing in the vendor ledger entries and bank ledger entries
- Final payment issued for vendor for balance $6302.29
- payment created in BC and showing in the vendor ledger entries and bank ledger entries
I am trying to complete a bank reconciliation, but receiving an allocation error from that auto created payment.
Any idea on how I can get this to clear out so I can post the bank reconciliation?