# Export CSV

Guide

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

<figure><img src="/files/GhAAQ93uhBZvZINTTq5G" 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="/files/J46wqOvHCR7hgwE4noqH" 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="/files/yNmkK2gvf5TuK4qamb4g" 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="/files/rQ5JrXcqge9L9HTOsVs2" 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="/files/3615K6V3aW3GXHWVP2ai" alt=""><figcaption><p>Success Notification</p></figcaption></figure>

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

<figure><img src="/files/3g8gF7aRbkpNTTD7jSxt" alt=""><figcaption><p>Export Status on E-Faktur Page</p></figcaption></figure>

This is what the CSV file looks like.

<figure><img src="/files/Mxt4iJdB4wzJC50ldsvp" 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.faspay.co.id/getting-started/faspay-billing-2.0/how-to-use/e-faktur/export-csv.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
