We use a sync application to pull in credit card authorize.net transactions. I am having lots of trouble clearing the transactions using the bank matching function.
Bank Deposit 2307.92
Entries generated by the app sync:
Refund Receipts (75.99)
I can see the transactions reconcile to zero (Invoice 2383.91=bank deposit 2307.92+refunds 75.99).
The issue is when I try to match the items via the Bank Matching functionality the two refunds are not options. I can match to the invoice but not the two refunds. The two refunds appear as payments in the register.
I am working with sync app who claims there is a bug in the system and the payment should be 2307.92. I can change the payment to 2307.92 but I still do not know how to clear the transactions.
I have attached the data mapping.
How should this transaction be posted and cleared?
Based from the scenario you've laid out, the system won't be able to match a deposit to the refund receipts and an invoice payment. I've also made it sure that I got it right by replicating in my QuickBooks account.
For now, I'd suggest excluding the bank transaction and marking the refund receipts and deposits as Reconciled or Cleared by putting the letter R or C, respectively. Let me also share the steps on how to exclude a deposit from the banking page:
From the Banking page, go to the ForReview tab.
Select the transactions and click on Batchactions.