Share
Report
475I have a few different solutions but was wondering how someone else handles this.
Customer has a balance of $10,000 and wires payment for $10,000 which shows up in our bank account as $9,990 because the bank charges a $10 wire fee.
I want to cleanly reflect that the Customer paid their entire balance. I say our books should match theirs. They sent a payment for $10,000 Dollars, we should reflect on their account that they paid $10,000. But if I do the cash receipt for $10,000 dollars, it hits the checkbook at $10,000 when the real amount to clear is $9,990. Then I have to charge a bank fee in Bank Transaction Entry, but then remember that the two combined (10,000 and (10,00)) need to be cleared together to represent the $9990 that is on my bank statement. That could be confusing, especially with heavy transactions.
I do the Cash receipt for $9,990, and there is a $10 remaining balance on the invoice for the Customer. I could do a credit memo or a write off, but that clutters up the customer account with Write Off Documents and Credit Memos which isn't really accurate, because we aren't actually writing off a balance or giving them credit. If they called one day to reconcile, our A/R person would say, well I show a payment of $9990, and a credit memo of $10, and then this got applied to that, etc..., and it would lead to confusion. I also thought of working it through the distributions of the Cash receipt, total cash distribution is Debit $9,990 (CASH), Credit 10,000 to A/R (REC), Debit $10 to Bank Fees (WRITE?). But that won't work because not only does it require the "Cash Receipt" to be 10,000, (not what I want), but messing with the distributions is always suspect and it gives errors that it won't post anyway.
Any Help out there. It's sort of like Credit Card Payments, buyt they hit at the actual amount, and then they charge us a lump sum fee at the end of the month. Easy to Reconcile because they are separated out.
Thanks,
Kevin
*This post is locked for comments
All responses (
Answers (
