Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forΒ
BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months* Ends 11/30
Buy nowI'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 No | Payment Date | Customer | Payment method | Deposit To Account Name | Invoice No | Journal No | Amount | Reference No | Memo | Currency Code | Exchange Rate |
| 1001 | 10-9-2024 | Partnership Healthplan of CA:Aya Angeles | Check | Payments to deposit | 1001 | 12 | TY37465 | ||||
| 1001 | 10-9-2024 | Partnership Healthplan of CA:Cristy James | Check | Payments to deposit | 1003 | 35 | TY37465 | ||||
| 1003 | 10-9-2024 | UBH Claims Dept:Gabriel Navarro | Check | Payments to deposit | 1002 | 25 | AR25441 |