# Export CSV

Guide

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

<figure><img src="https://3692871117-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MHl0oXefaAKjpRLPnGw%2Fuploads%2F7OxiUxp2pWyCDOxOqC7K%2Fimage.png?alt=media&#x26;token=2dcfc29c-f2e5-4040-9e1d-7abbdad32d89" alt=""><figcaption><p>E-Faktur Page</p></figcaption></figure>

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

1. Click the **calendar** button.
2. Choose the period, as an example will be shown data in September 2023.
3. Then, click **Show**.

<figure><img src="https://3692871117-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MHl0oXefaAKjpRLPnGw%2Fuploads%2FuFC5xXJx7sJzY2zYgfRK%2Fchoose%20period%20of%20the%20time.png?alt=media&#x26;token=e9e0cd82-585f-43e7-9e01-a95f50a13f13" alt=""><figcaption><p>Choose Periode of the Time</p></figcaption></figure>

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

<figure><img src="https://3692871117-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MHl0oXefaAKjpRLPnGw%2Fuploads%2F3Blz3PDiiBCxj9tQFXki%2Fimage.png?alt=media&#x26;token=02263b35-87ef-4ee2-a01b-f8ac499c9ac8" alt=""><figcaption><p>List Invoice Data</p></figcaption></figure>

**Field Parameter Invoice Data**

<table><thead><tr><th width="247">Field Name</th><th>Description</th></tr></thead><tbody><tr><td>E-Faktur No</td><td>Invoice E-Faktur Number</td></tr><tr><td>Invoice No</td><td>Invoice number</td></tr><tr><td>Due Date</td><td>Invoice due date</td></tr><tr><td>Customer Name</td><td>Invoice customer name</td></tr><tr><td>NPWP Name</td><td>NPWP customer name</td></tr><tr><td>NPWP</td><td>NPWP customer number</td></tr><tr><td>Invoice Status</td><td>Invoice status: unpaid, partially paid, paid, overdue.</td></tr><tr><td>Export Status</td><td>Export Status:<br>1. Exported : Indicates that the CSV document has been exported<br>2. Not Exported : Indicates that the CSV document has not exported yet</td></tr></tbody></table>

## 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.**

<figure><img src="https://3692871117-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MHl0oXefaAKjpRLPnGw%2Fuploads%2F2picgEYDgTAsoapli0RQ%2Fchoose%20data%20to%20export%20csv.jpg?alt=media&#x26;token=f86593ff-0573-4412-bd56-92a221850a53" alt=""><figcaption><p>Choose Data to Export in CSV</p></figcaption></figure>

2. The CSV files have been successfully exported, click **OK** on the success notification.

<figure><img src="https://3692871117-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MHl0oXefaAKjpRLPnGw%2Fuploads%2F2l4CHVj4R019BYYODwEX%2Fsuccess%20download.jpg?alt=media&#x26;token=9fff878f-1b33-4641-a785-e17f77825839" alt=""><figcaption><p>Success Notification</p></figcaption></figure>

3. The Export Status has been changed to **Exported**.

<figure><img src="https://3692871117-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MHl0oXefaAKjpRLPnGw%2Fuploads%2Ft2CgxuCYbvaz7SIuo9Si%2Fstatus%20berubah%20ke%20exported.jpg?alt=media&#x26;token=71c63d24-1ae8-44a6-8391-fc3618130ba9" alt=""><figcaption><p>Export Status on E-Faktur Page</p></figcaption></figure>

This is what the CSV file looks like.

<figure><img src="https://3692871117-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MHl0oXefaAKjpRLPnGw%2Fuploads%2FyAqG304Gpw2ALAKIjnDW%2Ffile%20csv.jpg?alt=media&#x26;token=3dcda92f-a3b5-4a41-9246-f3eeefaea274" alt=""><figcaption><p>Invoice CSV file</p></figcaption></figure>

**Field Parameter CSV File**

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

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