LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
evit
Level 1

Applying payments from multiple sources

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.

 

2 Comments 2
Rustler
Level 15

Applying payments from multiple sources

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.  

evit
Level 1

Applying payments from multiple sources

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us