Skip to main content
February 14, 2023
Question

Applying payments from multiple sources

  • February 14, 2023
  • 1 reply
  • 0 views

Using Quickbooks Desktop, I record a $100 as Statement Charges for a customer named Sam. Now Sam pays $40 and using Receive Payments I record the details. Now the remaining $60 is paid by a different organization named ABC (think it like a subsidy payment). One way to record this payment is via Receive Payments for Sam and then in memo field enter relevant details of ABC. But then one can't track the payments of ABC (or generate reports) as the payments from them could be for multiple customers and the details are buried in the memo field. So how can one achieve this?

 

My first thought was to do something like this i.e. create a credit for the payment from ABC but assign it to Sam.The journal entry to do this would be.

 

AccountDebitCreditName
Bank$60 ABC
A/R $60Sam

 

And then apply the credit using Receive Payments for Sam to the specific charge. However this is not possible since $60 does not show up as an outstanding credit for Sam. Given this limitation, how can one solve the underlying issue of applying payments from multiple sources and assign to a statement of charge while being able to track them.

 

1 reply

Rustler
February 15, 2023

QB does not work with journal entries very well, and especially not with A/R. A/P/ or Inventory. And man journal entries are not included in reporting.

All I can see to do is receive the 60 against Sam and make a note in the memo block.

 

You will have to check but you might be able to report and include the memo field.  

evitAuthor
February 24, 2023

Thank you for the note. I'm already doing what you've proposed but unfortunately it's clunky and was hoping there's a better solution. The consolation is after fiddling with different reports, I'm now able to at least filter on the memo field and create a customized report that shows all the transactions as long as there's consistency in entering the details in the memo field.