Skip to main content

Export Transactions and Generate a Report

To get a report of your payments, export the transactions table of a plugin to a CSV or Excel file. The export contains exactly the transactions the table is showing, so filter first if you only want some of them, for example only the unpaid ones.

Who can do it: any dashboard user. You export the transactions you are allowed to see. If transactions are missing, see Why can't I see all the transactions?

tip

Need the same report every day, week or month, sent by email or SFTP? Set up a scheduled transaction report instead.

How do I export my transactions?​

  1. In the sidebar, open the plugin, for example Payment Request, and click Transactions.

    The dashboard sidebar with Payment Request open and Transactions selected
  2. Optional: click Filter, choose what you want to see, for example a Created period or a State, and click Search. The export keeps your filters and your search.

    The Filter panel with State, the other filters, Search and Reset
  3. Click Export Transactions above the table.

    The Export Transactions button above the transactions table, next to Filter
  4. Under Timezone, pick a timezone in Select timezone if the dates in the file should use a specific one.

    The export options with Timezone and Select timezone
  5. Under Select file type, choose CSV or XLSX.

    The export options with Select file type: CSV or XLSX
  6. Click Export.

    The Export button at the bottom of the export options
  7. The Generated Reports page opens. The file is prepared in the background: when your export shows a download icon in the Download column, click it.

    The Generated Reports table with the Available until and Download columns

You can leave the page while the file is prepared. To come back later, click Generated Reports in the sidebar. Each file stays there until the date in its Available until column. You see only your own exports.

The file has one row per payment. Refunds, voids and captures made on a payment are not separate rows.

How do I export only the unpaid transactions?​

  1. Open the plugin's Transactions table.

    The dashboard sidebar with Payment Request open and Transactions selected
  2. Click Filter.

    The Filter button above the transactions table
  3. In State, choose All Unpaid.

    The State filter open, with All Unpaid at the end of the list
  4. Click Search. The table now shows only unpaid transactions.

    The Search button at the bottom of the Filter panel
  5. Click Export Transactions, choose CSV or XLSX, and click Export.

    The Export Transactions button above the transactions table
  6. Download the file from the Generated Reports page.

    The Generated Reports table with the Download column

All Unpaid covers the states Created, Pending, Attempted, Failed, Expired and Unavailable. To export the paid ones, choose Paid in step 3. See Transaction States for what each state means.

If there is no State filter, your administrator has removed it. Ask them to add it back in the filters configuration.

My export takes too long or never finishes​

A large export can take a long time, and an export that runs for more than an hour is stopped. Export a smaller set of transactions each time:

  1. Open the Transactions table and click Filter.
  2. In the Created filter, set a period of one month, then click Search.
  3. Click Export Transactions and export that month.
  4. Repeat for the next month.

Other things that help:

  • Choose CSV instead of XLSX. An Excel sheet cannot hold more than 1,048,576 rows, and rows above that limit are left out of an XLSX file.
  • Add more filters, such as State or the connector, so that fewer transactions are exported.
  • If the Download column shows a red X, the export failed. Hover over it to read the reason, then try again with a shorter period.

Choose the columns of the file​

The columns come from the plugin's dashboard report configuration. An administrator sets them in Administration panel > Report > Dashboard report configs: see Dashboard Export.

Users with the Can view export settings permission also see the list of columns in the export window and can untick the ones they do not want.

What's Next?​