Understanding Your Customers Export

You must have already exported your customer list from the Facilipay Business Portal. (See How to Export a List of Your Customers.)
Open the file in Microsoft Excel or Google Sheets to view the columns.

When you open the exported file, each column represents a specific data field associated with the customer account.

ID – Internal identifier used by Facilipay to reference the customer account.
Name – Full name associated with the customer account.
First Name – Customer's first name.
Last Name – Customer's last name.
Email – Email address linked to the account.
Username – The original card ID associated with the account.
Status – Indicates whether the account is active or disabled:
- 1 = Active
- 0 = Disabled
Nickname – Optional nickname assigned to the account.
Phone_Number – Customer's phone number, if provided.
Date_Birth – Customer's recorded date of birth.
Date_Add – The date the account was first associated with your business.
Date_Edit – The most recent date the account was updated.
Account_Number – All card IDs currently linked to the account. Multiple numbers indicate multiple linked cards.
Gender – Customer's selected gender, if provided.
Card_Brand – Brand of the payment card linked to the account (e.g. Visa or Mastercard).
Expiry_Date – Expiry date of the linked payment card.
Cash_Balance – The available balance the customer has to spend with your business.
Stamp_Balance – The number of loyalty stamps currently on the account.
Role_Name – Role assigned to the customer (if roles are used for segmentation or campaigns).

Handle data responsibly: The export contains personal information — store and share files in line with your privacy policies.
Use spreadsheet filters: Apply column filters in Excel or Google Sheets to slice the data without altering the source.
Need help? If a column doesn't match what you expect, contact support@facilipay.io.

The Customers Export lets you download a report of your full customer database. Each column in the file represents a different field associated with customer accounts, helping you analyse your customer base, review balances, and filter account information as needed.