CSV Export for Daily ACH Payments

Hi @Erin_joyjoy, thanks for posting. 

We have a helpful page on report level export formula here that you might find helpful. 

To build this type of export, I'd recommend the following resources; report level export formulas and creating a custom export template,

The formula in particular that you'd want to use would be:

• Report Status = {report:status} would output Approved assuming that the report has been approved and not yet reimbursed.
• User (Person getting reimbursed)  = {report:submit:from:email} would output the email of the report submitter (person getting reimbursed).
• ACH Reimbursement Date = {report:achreimburse} would output 2011-09-25 assuming that is the date the report was reimbursed via ACH Direct Deposit.
• ACH Reimbursement Amount = {report:reimbursable} would output $143.43 assuming the report's reimbursable total was 143.43 US Dollars.

To make an export template that is specific to a policy and that policy's admins, head to Settings > Policies > Group > [Policy Name] > Export Formats.

To make an export template that is specific to your account only but that can be used with any policy, head to Settings > Account > Preferences > CSV Export Formats.

Cheers!