How to Upload Bulk Payments

Article author
Learning Center Mekari
  • Updated

After the Workflow for Bulk Payment has been configured and activated, as a Payment maker, you can start uploading payment files in CSV format through the Bulk payments menu. As a Payment Maker, you can upload up to 300 payments at once for various payment needs that require mass processing. 

Read the following guide to learn how to upload a Bulk Payment file and check the payment validation results.

A. How to Upload Bulk Payments

  1. Log in to your Mekari Expense account, then select the Bulk payments menu.
  2. Then click “Submit bulk payments”.
  3. On the “Upload CSV” tab, click “Download template” to download the payment file template that will be used.
  4. Complete the template according to the required payment data, subject to the following conditions:
  • Each row represents one payment to one bank account.

  • The payment amount must be a whole number in rupiah greater than zero, without periods, commas, or decimal numbers.

  • Each Reference ID must be unique within a file.

  • The payment recipient can be anyone who has a bank account; they do not have to be a company employee.

  • Avoid uploading the same file more than once because each upload will process the payments again.

  1. The CSV file must contain exactly six columns in the following order.
Column NameRequirements
Bank CodeMust contain a bank code supported by Mekari Pay.
Account NumberMust contain a bank account number consisting of numbers only and 6–20 characters in length.
Account Holder NameMust contain the account holder’s name as recorded by the bank. The name entered must match the name registered with the bank. See the Row Validation and Bank Account Verification sections for more information.
AmountMust contain the payment amount in rupiah as a whole number greater than zero. Do not use number separators, decimals, or currency symbols. There is no maximum payment amount.
NotesOptional. Can contain notes of up to 255 characters.
Reference IDOptional. Can contain a reference identifier of your choice, such as an invoice number or payroll number. This reference will be displayed on the payment row to facilitate reconciliation and can be used repeatedly within the same file or in different files.
  1. Convert the file to CSV. Save or export the file in CSV format before uploading it. 
  2. Click “Browse” to select the completed CSV file, or drag the file to the upload area. Make sure the file is in CSV format, is no larger than 5 MB, and contains no more than 300 payment rows.
  3. After the file has been successfully uploaded, review the payment data in the Review payment data section, then proceed according to the instructions on the page.

    Important
    You must upload the file in .CSV format.

  4. Click “Submit”.
  5. Next, you will be directed to the following screen. Please wait until the data has been successfully uploaded. 
  6. The Bulk payment status will then change to “Awaiting review”. In this case, review the data you uploaded. 

    You can also access the detail view of the Bulk payment upload through the ‘Upload log’ tab.

B. Monitoring the Status of Uploaded Bulk Payment Logs

  1. On the “Upload log” tab, you will see the following screen. If the data you uploaded is correct, click “Submit”.
  2. The following information pop-up will appear, stating that the payment details will be sent to the approver. Click “Submit” again.
  3. The upload status will then change to “Awaiting approval”. You can then monitor the Bulk payment status through Request history.
  4. To track the progress of the file upload process, you can view the upload statuses displayed in the system. Each status indicates the file processing stage and the actions you can take. The following is an explanation of each status: 
No.StatusExplanationAvailable Actions
1DraftThe file was successfully uploaded, and the system is checking each data row with the bank. This process usually takes a few seconds.No action is required. Reload the page to view the verification results.
2Awaiting reviewThe review is complete, and the system has identified valid (Ready) and invalid (Invalid) data rows. The file has not been submitted for approval.The Maker can select Submit to send the file for approval or Cancel to cancel the upload.
3Awaiting approvalThe Maker has submitted the file for approval. The file is going through the approval stages in the specified order.Only the Approver at the current stage can select Approve or Reject. The Maker cannot withdraw the file.
4Awaiting disbursementThe final approval stage has been completed and confirmed using the code sent by email. The payments are being processed.No action is required. Reload the page to view the process progress.
5CompletedAll payments were successfully processed with the status Paid.You can only view the upload status details.
6Partially completedSome payments were successfully processed with the status Paid, while others have the status Failed.You can only view the upload status details. Correct the failed data rows in the file, then upload them again as a new batch.
7FailedNo payments were successfully processed. This status may occur if all data rows are invalid, the file contains errors, or all payments failed to process.You can only view the upload status details. Correct the file, then upload it again.
8RejectedThe Approver rejected the batch at one of the approval stages and provided a reason for the rejection. The entire batch was rejected, and no payments were processed.You can only view the upload status details.
9CancelledThe Maker canceled the batch while it was still in the Awaiting review status. No payments were processed.You can only view the upload status details.

This concludes the explanation of how to upload Bulk Payments.