Expensify Report Export

Authentication Method:

API Credentials

authToken

Filters:

Report State

Open Submitted Approved Reimbursed Archived

ReportID List

PolicyID List

Start Date

End Date

Approved After

Mark As Exported

Output/Finish Settings:

File Extension

Email List

Mark As Exported

Export Template:

<#if addHeader>
Report ID,Merchant,Amount,Category,Expense Date
</#if>
<#list reports as report>
    <#list report.transactionList as expense>
        <#if expense.modifiedCreated?has_content>
            <#assign created = expense.modifiedCreated?date("yyyy-MM-dd")>
        <#else>
            <#assign created = expense.created?date("yyyy-MM-dd")>
        </#if>
        <#if expense.modifiedMerchant?has_content>
            <#assign merchant = expense.modifiedMerchant>
        <#else>
            <#assign merchant = expense.merchant>
        </#if>
        <#if expense.convertedAmount?has_content>
            <#assign amount = expense.convertedAmount/100>
        <#elseif expense.modifiedAmount?has_content>
            <#assign amount = expense.modifiedAmount/100>
        <#else>
            <#assign amount = expense.amount/100>
        </#if>
        ${report.reportID},<#t>
        ${merchant},<#t>
        ${amount?string("0.00")},<#t>
        ${expense.category},<#t>
        ${created?string("yyyy-MM-dd")}<#lt>
    </#list>
</#list>

Response: