Skip to main content
All CollectionsPayment
Update Bulk Payment via CSV
Update Bulk Payment via CSV

Update the payment from customer invoices using csv files in a bulk way

Teguh Warsono avatar
Written by Teguh Warsono
Updated over 4 months ago

When you create a customer invoice, you can input an unpaid payment. "Unpaid" means that the payment is being processed or waiting for you to process it. If you have large data of customer invoices, you might want to input the payment by using bulk way with CSV file import. To import the payment note by using a CSV file, you can follow the steps below:

Step 1. Go to Payment, then Click Import

Import Payment

Step 2. Download Sample File

Download Template

Step 3. Submit Payment Information on Excel File

Open the downloaded CSV file, and fill in the Outlet name, Date Invoice payment, Invoice numbers, Payment Method, Amount and Payment note as in the example file.

Payment CSV

Step 4. Upload / Import Payment to System

Import the saved CSV files in the import payment, then click the upload button.

Upload CSV File

Step 5. CSV File was Imported Successfully

There will be a green notification when the upload process is succeed.

Upload succeed

Step 6. Recheck Payment in Order Detail

Go to the orders menu and check on one of the customer invoices that the payment, date, amount, method and note is uploaded by CSV File.

Payment Note Displayed

Notes:

  • Ensure that there are no duplicate invoice numbers in the CSV file.

  • Ensure all CSV formats are correct.
    โ€‹


You might also like to read these related articles below :

  • If you want to add the payment to the unpaid customer invoices in a bulk way, you can follow the steps on this page : Add Bulk Payment

  • If you want to show the payment note in the printed customer invoice, you must activate the configuration on the Setup menu. For further information about the configuration, you can go to this page : Config Payment Note Printing Visible

  • You can add payment methods to your DealPOS account as much as you need. To add new payment methods, you can follow the steps on this page : Add Payment Methods


dealpos-trial-indonesia

Did this answer your question?