BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

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.

Reply to message

View discussion in a popup

Replying to:
Harish0412
Level 1

Reply to message

I'm trying to import customer payment through excel import, We have received a check from parent customer for two different sub customer. If I import this, I'm getting an error that customer's invoice can't be found. But on changing the Ref No in the first column I'm able to import. But each row is considered as different payments. Please provide the right format of excel file to import payments received from single parent customer to different sub customer invoices.

Ref NoPayment DateCustomer Payment methodDeposit To Account NameInvoice NoJournal NoAmountReference NoMemoCurrency CodeExchange Rate
100110-9-2024Partnership Healthplan of CA:Aya AngelesCheckPayments to deposit1001 12TY37465   
100110-9-2024Partnership Healthplan of CA:Cristy JamesCheckPayments to deposit1003 35TY37465   
100310-9-2024UBH Claims Dept:Gabriel NavarroCheckPayments to deposit1002 25AR25441   

Need to get in touch?

Contact us