CSV Mapping Emulator
Try our interactive tool to see how your data maps to DyerPay's format. No account required. Learn more
DyerPay allows your staff to simply upload a CSV file an the Balances, Customer Account Numbers, and your data will be used to
generate a customized payment page for your customers to pay their balances. These Payments will be Processed through Stripe.
You simply download the CSV file showing any payments and errors and process them through your existing office processes same as you have always done.
Select Data Type
Source CSV Data
| CustomerNumber | Full Name | Amount Owed | PayBy | Category | ContactEmail | ContactPhone | MailingAddr |
|---|---|---|---|---|---|---|---|
| 10001 | John Smith | 245.50 | 2024-03-15 | Utility | john.smith@email.com | 555-0101 | 123 Main St |
| 10002 | Jane Doe | 1250.00 | 2024-03-20 | Property Tax | jane.doe@email.com | 555-0102 | 456 Oak Ave |
| 10003 | Bob Johnson | 89.99 | 2024-03-25 | Water | bob.j@email.com | 555-0103 | 789 Pine Rd |
Field Mapping
Field Reference
Unique identifier for the account
Name on the account
Current balance due (numeric)
Payment due date (YYYY-MM-DD)
Type of account (e.g., utility, tax, fine)
Contact email address
Contact phone number
Mailing address
Mapped Data Preview (DyerPay Format)
8 fields mapped| Account ID * | Account Name * | Balance Amount * | Due Date | Account Type | Phone | Address | |
|---|---|---|---|---|---|---|---|
| 10001 | John Smith | 245.50 | 2024-03-15 | Utility | john.smith@email.com | 555-0101 | 123 Main St |
| 10002 | Jane Doe | 1250.00 | 2024-03-20 | Property Tax | jane.doe@email.com | 555-0102 | 456 Oak Ave |
| 10003 | Bob Johnson | 89.99 | 2024-03-25 | Water | bob.j@email.com | 555-0103 | 789 Pine Rd |
| 10004 | Alice Williams | 567.25 | 2024-04-01 | Electric | alice.w@email.com | 555-0104 | 321 Elm St |
| 10005 | Charlie Brown | 2100.00 | 2024-04-10 | Tax Lien | charlie.b@email.com | 555-0105 | 654 Maple Dr |
Ready to Export?
Your mapping is complete! Download your DyerPay-formatted CSV file.
How CSV Integration Works
Upload Your Data
Export data from your existing system as a CSV file. Any column headers work - we'll help you map them.
Map Your Columns
Use our visual mapping tool to connect your column names to DyerPay's standardized fields. Auto-mapping helps speed this up.
Export & Integrate
Download your mapped CSV or save your mapping configuration. Upload to DyerPay and start processing payments.
Ready to integrate DyerPay with your agency?