Skip to main content

Export Billing List Data (Excel)

Overview​

You can export and download Billing List data in Excel file format.

Purpose​

The primary purpose of billing list export is to list billing amount trends, recent payment status, balance brought forward, and Credit Note amounts in Excel so they can be checked and compared.

Since export targets can be filtered by period, Buyer, and other criteria, only the billing data that needs to be reviewed can be handled together.

Feature Description​

What you can do with Export Billing List Data​

With this feature, you can export Billing List data in Excel file format and download it.

The data export process is performed in the background, and a notification email is sent upon completion.

What is the Billing List?​

The Billing List is data that summarizes, in a single row, the Billing Amount, balance brought forward, and offset/refund amounts for each Invoice, as well as the Last Billing Amount from the perspective of each invoice and the most recent amount confirmed in the Payment Confirmation.

The terms used in the Billing List are as follows:

  • This Billing Invoice: The Invoice corresponding to the Invoice No. in each row of data.
  • Billing Amount: The Billing Amount of the current Invoice.
  • Last Invoice: Refers to the Invoice one record prior to the current Invoice. Which invoice is considered "Last" is determined by the Invoice date filter.
  • Last Billing Amount: The Billing Amount of the Last Invoice.
  • Last Payment Confirmed Amount: The amount confirmed in the most recent Payment Confirmation from the perspective of the current Invoice. Which Payment Confirmation is targeted is determined by the date filters for Invoices and Payment Confirmations.
  • Carryover Amount: The amount of the Billing Balance applied to the current Invoice.
  • Credit Note Amount: The total amount of Credit Notes applied to the current Invoice.

Filtering and Export Content during Data Export​

When exporting data, you specify the target language, period, and Buyer to filter the data to be exported.

All eligible Invoices within the period will be exported.

Furthermore, you can record internal memos regarding the export in the Description. The description will be exported to the Excel file.

Instructions​

Exporting the Billing List is performed through the following flow:

  1. Specify export conditions and start data export
  2. Download the Excel file

1. Specify export conditions and start data export​

Navigating to the Data Export screen​

  1. Click the Data Export menu.
  2. Click the Billing List tab.
  3. Click the Data Export tab.
    *It is open by default.

Filling in the form​

  1. Target Language
    Select the language for the Excel file to be exported from the dropdown.

    Languages enabled in the Core Preferences can be used.

  2. Period
    Specify the period targeted for data export.

    From the following date filters, select the type of date to be used as the base:

    • Billing Invoice Date Filter: Select either Issue Date (document date) or Create Time from the dropdown.
    • Payment Confirmation Date Filter: Select either Confirmed At (document date) or Create Time from the dropdown.

    Additionally, enter the start date/time and end date/time for the period. Dates can be selected from the calendar.

  3. Email For Notification
    Enter the email address where the download URL will be sent.

  4. Description
    Enter as needed. The description will be exported to the Excel file.

  5. Select the Buyers to be included in the data export by checking them.

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

Executing the Data Export​

Once all items are filled in, click the Submit button.
The data export process will begin in the background.

When the process is complete, a download URL will be sent to the specified notification email address.

To download from the screen, proceed to the next step.

2. Download the Excel file​

Navigating to the download screen​

Once the data export process is complete, download the Excel file using the following steps:

  1. Click the Data Export menu.
  2. Click the Billing List tab.
  3. Click the Downloads tab.

Downloading the file​

  1. Click the Update button to check the completion status of the data export.
    If the process is not complete, the Download button will not be displayed.

  2. As soon as the process is complete, click the Download button.

    You can download the Excel file (.xlsx).

Important Notes​

Data export processing time and downloading​

Since data export is processed in the background rather than immediately, Download may not be displayed immediately after opening the screen.

To check if the file is ready, either Update the screen or check the completion email (containing the download URL) sent to the specified notification email address.

Date filters for Invoices and Payment Confirmations​

When using the Invoice Issue Date or the Payment Confirmation Confirmed At as the base for the date filter, documents without a registered date will not be included in the export.

Interpretation of "Last" and "Last Payment Confirmed Amount"​

The Last Invoice, Last Billing Amount, and Last Payment Confirmed Amount are determined by the date filters for Invoices and Payment Confirmations.

Changing the date filter specifications may change how "Last" records or payment confirmed amounts are handled, even for the same Invoice.