Skip to main content

Bulk Import Payment Confirmations (Excel)

Overview​

This feature allows you to create multiple payment confirmations at once by downloading an Excel file (.xlsx) for payment confirmation import, entering data into the file, and then importing it.

Purpose​

The primary purpose of bulk payment confirmation import is to reduce the effort of registering payment confirmations individually for each Buyer and make it possible to reconcile billing balances in bulk.

Importing multiple payment confirmations at once also helps reduce the effort required for payment confirmation operations.

Feature Description​

What is a Payment Confirmation?​

A payment confirmation is a document used to reconcile the billing balance held by a buyer.

It is a system to reconcile the billing balance, which was recorded as an uncollected amount based on an invoice, by creating a payment confirmation.

Row Data in the XLSX File for Import​

Rows in the XLSX file are prepared for each combination of the target buyer and billing balance.

If billing balance data exists in multiple currencies, the combination of buyer and currency is treated as one row.

Billing balance data includes 0 and negative amounts.

Required Input Items and Items Not to Be Edited​

  • Required Input Items
    • Payment Confirmed Amount
  • Items Not to Be Edited
    To avoid import errors or discrepancies between the import target and the input data, please do not edit the following items.
    • Entire Column A
    • Customer Code
    • Customer Name
    • Currency

Payment Confirmation Number​

You can enter any value for the Payment Confirmation Number.

If imported while blank, it will be automatically numbered.

Automatic numbering is performed based on the standard rules of DEXTRE or the document number numbering rule settings.

For details on document number numbering rules, please refer to Configure Document Numbering Rules.

Payment Confirmation Date​

For the Payment Confirmation Date, you can enter any date in yyyy-MM-dd format or yyyy/MM/dd format.

If imported while blank, the date the file was imported will be registered as the payment confirmation date.

Rows Targeted for Payment Confirmation Creation​

Rows where an amount greater than 0 is entered in the Payment Confirmed Amount will be targeted for the creation of payment confirmations.

Rows where the Payment Confirmed Amount is blank or 0 will be excluded from creation.

Instructions​

Bulk import of payment confirmations is performed using the following steps.

  1. Download the XLSX file for payment confirmation import
  2. Enter data into the XLSX file for payment confirmation import
  3. Import the XLSX file for payment confirmation import

1. Download the XLSX file for payment confirmation import​

Navigating to the File Download Screen​

  1. Click the Transactions menu > Billing Management.
  2. Click the Payment Confirmations tab.
  3. Click the Import button.
    The "Import Payment Confirmation" modal opens.
  4. Click Download XLSX File.
    You will be transitioned to the "Payment Confirmation Import File Download" page.

Downloading the XLSX File​

  1. Specify the Target Language from the pull-down menu.

  2. Select the buyers for whom you want to create payment confirmations by checking their checkboxes.

    • You can narrow down buyers by entering conditions in the Search Buyers.
    • To select all buyers that match the search criteria, click Select All.
    • To uncheck all, click Remove All Selections.

  3. After confirming the input details, click the Download button.
    The "XLSX File for Import" will be downloaded.

2. Enter data into the XLSX file for payment confirmation import​

Open the downloaded "XLSX File for Import" and enter the data.

Do not rewrite the column names and the following items.
Rewriting the column names and the following items will cause import errors.

  • Entire Column A
  • Customer Code
  • Customer Name
  • Currency

Enter the following items as needed.

  • Payment Confirmation Number (Optional)
    Enter any value. If blank, it will be automatically numbered.

  • Payment Confirmed Amount (Required)
    Enter the amount for the payment confirmation.

    If blank or 0 is entered, it will be excluded from creation.

  • Note (Optional)
    Enter any value.

  • Payment Confirmed Date (Optional)
    You can enter any date in yyyy-MM-dd format or yyyy/MM/dd format.

After completing the data entry, please save and close the "XLSX File for Import."

3. Import the XLSX file for payment confirmation import​

  1. Click the Transactions menu > Billing Management.

  2. Click the Payment Confirmations tab.

  3. Click the Import button.
    The "Import Payment Confirmation" modal opens.

  4. Click Select File and select the file to upload.
    You can also select a file by dragging and dropping it.

  5. Click the Import button.

    If the process is successful, payment confirmations will be created in bulk.

Important Notes​

Handling of Column A and Row Data​

Column A is a column that is hidden by default in the XLSX file and contains identifiers necessary for import.

  • Do not perform copy, cut, or paste on a cell basis. The correspondence between the identifiers in Column A and the data in other columns may become misaligned row by row.
  • When changing the order of rows, please select the entire row to cut and move, or perform a sort.
  • Do not enter data into new empty rows.

Invalid Input of Payment Confirmation Amount​

The following types of input will result in an error during import.

  • When a negative value is entered in the Payment Confirmed Amount
  • Amounts that do not correspond to the currency (e.g., a numerical value including decimals for Japanese Yen, a numerical value including the third decimal place for US Dollars)
  • Invalid input as a format, such as full-width characters