<#if addHeader == true> Invoice Date,Merchant,Amount,Tax Amount,Tax Name,Tax Rate Name,Tax Code,Tax Rate,Has Tax,Currency,Category,Description,Receipt ID,Expense ID,Reimbursable,Billable,Original Receipt,Attendees,GL_Code Main Account,Payroll_Code Expense Type,Project,Bank,MCC,Report ID,Report Name,Report Status,Report Created Date,Report Submitted Date,Report Approved Date,Report Final Approved Date,Report Reimbursed Date,Report Exported Date,User Email,Personnel No.,Report Submitted to,Report Approved by,Report Final Approved by,Report Policy,Report Currency,Report Total,Report Number,Expense Number <#assign reportNumber = 1> <#list reports as report> <#assign expenseNumber = 1> <#list report.transactionList as expense> ${expense.created},<#t> <#if expense.modifiedMerchant?has_content> <#assign merchant = expense.modifiedMerchant> <#else> <#assign merchant = expense.merchant> ${merchant},<#t> <#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> ${amount},<#t> <#if expense.modifiedTaxAmount?has_content> <#assign taxAmount = expense.modifiedTaxAmount> <#else> <#assign taxAmount = expense.taxAmount> ${taxAmount},<#t> ${expense.taxName},<#t> ${expense.taxRateName},<#t> ${expense.taxCode},<#t> ${expense.taxRate},<#t> ${expense.hasTax},<#t> ${expense.currency},<#t> ${expense.category},<#t> ${expense.comment},<#t> ${expense.receiptID},<#t> ${expense.transactionID},<#t> ${expense.reimbursable},<#t> ${expense.billable},<#t> ${expense.receiptObject.url},<#t> <#assign attendeesList = ""> <#list expense.attendees as attendee> <#assign attendeesList = "${attendeesList} ${attendee.email};"> ${attendeesList},<#t> ${expense.categoryGlCode},<#t> ${expense.categoryPayrollCode},<#t> ${expense.tag},<#t> ${expense.bank},<#t> ${expense.mcc},<#t> ${report.reportID},<#t> ${report.reportName},<#t> ${report.status},<#t> ${report.created},<#t> ${report.submitted},<#t> ${report.approved},<#t> "report final approval",<#t> ${report.reimbursed},<#t> ${.now?date?iso_utc},<#t> ${report.accountEmail},<#t> ${report.employeeCustomField1},<#t> "submitted to",<#t> <#assign approverList = ""> <#list report.approvers as approver> <#assign approverList = "${approverList}; ${approver.email}"> ${approverList},<#t> ${report.managerEmail},<#t> ${report.policyName},<#t> ${report.currency},<#t> ${report.total/100},<#t> ${reportNumber},<#t> ${expenseNumber},<#lt> <#assign expenseNumber = expenseNumber + 1> <#assign reportNumber = reportNumber + 1>