How to Create and Export a Transaction Report
Filtering and exporting your transaction data allows you to generate accurate reports for reconciliation, accounting, and business analysis.
Before You Begin
- You must be logged into the Facilipay Business Portal with reporting access.
- Decide on the date range and filters you want to apply before running the report.
Step-by-Step: Create and Export a Transaction Report
-
Go to Reports → Transactions
From the main menu of your Facilipay Dashboard, select Reports, then Transactions. Transactions are listed from newest to oldest by default.

-
Filter by Date Range
Use the date picker to select your desired start and end dates, or manually enter a date range and click Search. -
Filter by Payment Type
Select the relevant payment type(s) from the available options to narrow the report to specific payment methods. -
Filter by Transaction Type
Choose between:- Add — money added to a customer's account (e.g. gift card loads, loyalty rewards, balance top-ups)
- Redeem — money removed from a customer's account (e.g. gift card redemptions, loyalty usage, stamp or credit spend)
-
Export the Report
Once your filters are applied, click the Export button in the top-right corner. A confirmation will appear on the left-hand side of the screen.

-
Open the File
A .csv file will automatically download to your computer. Open it in Microsoft Excel or upload it to Google Sheets to review your data.
Tips & Best Practices
-
Apply filters before exporting: The export reflects exactly what is visible on screen — refine date and filters first to avoid unmanageable files.
-
Use shorter date ranges: For high-volume businesses, exporting week by week keeps files easier to review and reconcile.
-
Know your transaction types: Filtering by Add vs. Redeem separately helps isolate top-up activity from spend for cleaner reporting.
What You Can Do With Your Export
-
Reconcile transactions with your accounting system or POS records
-
Identify high-value customers or top-up patterns over time
-
Share financial summaries with your accountant or finance team
-
Build custom dashboards or reports for business reviews