cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
VIJAI
Level 1
posted
‎February 19, 2020 02:33 AM
last updated ‎October 05, 2020 8:22 PM

Import invoice Payment through CSV (Against invoice Number)

How do i import Invoice payments through CSV, as we do for Invoices. 

The invoice payment CSV contain the payment made against the each invoice number. 

Reply
1 Comment 1
Fiat Lux - ASIA
Level 15
‎February 19, 2020 04:48 AM

Import invoice Payment through CSV (Against invoice Number)

You need an importer tool to do so.

https://transactionpro.grsm.io/qbo

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template should be like this

RefNumberTxnDatePaymentRefNumberCustomerPaymentMethodDepositToAccountInvoiceApplyToLineAmountPrivateNoteCurrencyExchangeRate
128/11/202050245Janice JohnsonCheckChecking101100.00   
228/11/20204908Leonard Walker IncCheckChecking102138.78   
328/11/20204908Lisa SmithCheckChecking103126.50   
Reply