Export CSV

Guide

Click on Export CSV tab menu, to show Export CSV page.

Before exporting the invoice data to CSV format file, user needs to show the list of invoice data on the Export CSV page, as follows:

1. Click calendar button.

2. Choose the period of time, as example will be shown data at September 2023.

3. Then, click Show.

Choose period of the time

4. So, the list of invoice data in September 2023 successfully showed.

List invoice data

Field Parameter Invoice Data

Field Name	Description
E-Faktur No	Invoice E-Faktur Number
Invoice No	Invoice number
Due Date	Invoice due date
Customer Name	Invoice customer name
NPWP Name	NPWP customer name
NPWP	NPWP customer number
Invoice Status	Invoice status: unpaid, partially paid, paid, overdue.
Export Status	Export Status: 1. Exported : Indicates that the CSV document has been exported 2. Not Exported : Indicates that the CSV document has not exported yet

Export Invoice Data to CSV File

Data that can be seen before and having tax invoice/E-Faktur numbers can be exported into CSV file, by following steps:

1. Checklist on the list of data that you want to export, then click Export CSV.

Choose data to export in CSV file

3. The CSV files has been successfully exported, click OK on success notification.

4. The Export Status has been changed to Exported.

This is how the CSV file looks like.

Invoice CSV file

Field Parameter CSV File

Field Name	Description
KD_JENIS_TRANSAKSI	Transaction Code 01: To Parties Who Are Not VAT Witholder 02: To the Treasurer's Witholder 03: To the Witholder except Treasurer's 04: DPP Other Values 06: Other submissions, including submission to foreign tourists in the context of VAT refunds 07: Submission of which VAT is not collected 08: Submission of VAT Exemption 09: Delivery of Assets (clause 16D of the VAT Law)
FP_PENGGANTI	Replacement status of tax invoice, if there replacement FP_PENGGANTI = 1, vice versa FP_PENGGANTI = 0
NOMOR_FAKTUR	Tax invoice serial number
MASA_PAJAK	Reporting tax period = month of invoice period
TAHUN_PAJAK	Year tax period = year of invoice period
TANGGAL_FAKTUR	Invoice date
NPWP	NPWP customer number
NAMA	NPWP Customer name
ALAMAT	NPWP customer address
JUMLAH_DPP	Subtotal before tax
JUMLAH_PPN	Total tax
JUMLAH_PPNBM	Amount of PPNBM tax(if nothing filed by 0)
ID_KETERANGAN_TAMBAHAN	Additional information (optional)
FG_UANG_MUKA	Filled by 0, if normal payment (without down payment/terms/repayment) Filled by 1, if there is a down payment or terms Filled by 2, if settlement
UANG_MUKA_DPP	Amount of down payment before tax(if nothing filled by 0)
UANG_MUKA_PPN	VAT down payment amount(if nothing filled by 0)
UANG_MUKA_PPNBM	Amount of PPNBM down payment(if nothing filed by 0)
REFERENSI	Invoice number

On the Export CSV page, user can also Generate E-Faktur No on the invoice data that don't have an E-Faktur number.