FTP
The following folders should be utilized for file transfers: Payments, Archive, and Balances. These are the standard folders configured for all Paystar clients; however, your implementation may call for more or less folders.
info
Please contact your Paystar Account Manager to coordinate the folder names and file delivery times specific to your needs.
Balances Folder
- The account balance file should be uploaded to the Balances folder daily in the morning hours. Implementations usually call for this file to be delivered by 5:00 AM CST.
- The files will be picked up by Paystar within 15 minutes, processed, and then moved to the Archive folder.
Payments Folder
- A file in the format provided by Billing System containing Paystar payment records will be placed in the Payments folder every day after the daily batch closes. Implementations usually call for this file to be delivered by 3:00 AM CST covering online payments from the previous day.
- After you retrieve this file, it should be moved into the Archive folder (removing it from the Payments folder).
Archive Folder
- This folder should be used to archive old balance and payment files.
- Paystar will perform housekeeping on this folder as needed and may delete files at any time.
Data Files
Below are examples of a Standard Account Import File and a Generic Payment File Export. Paystar flexibly accepts many data types and sets, however, these are examples of the most generic forms of the data we accept.
Account Import Data
Account Number | Customer Number | Balance | Issue Date | Due Date | Name | Email Address | Phone Number | Allow Online | Block Credit card | Block ACH | Account Locked | 1234 | 1 | ($3.25) | 12/1/2023 | 12/31/2023 | Customer One - Property One | TRUE | FALSE | FALSE | FALSE | 1245 | 1 | $45.54 | 12/1/2023 | 12/31/2022 | Customer One - Property Two | TRUE | FALSE | FALSE | FALSE | 5678 | 2 | $25.31 | 12/1/2023 | 12/31/2022 | Customer Two - Property One | TRUE | FALSE | FALSE | FALSE |
---|
Generic Payment File Export
Paid Item | Account Name | Amount | Date | Reference # | Auth Code | Type | Status | Channel | Payment Method | Account Holder Name | User | 3778 | Emily Johnson | $19.96 | 10/24/2023 13:22 | PGJJQE-5P7Z | PPS010 | Sale | Approved | QuickPay | MC - **5454 | Emily Johnson | QuickPay | 1226 | John Smith | $16.80 | 10/24/2023 13:22 | PGJJRQ-5P8F | PPS010 | Sale | Approved | QuickPay | MC - **5454 | John Smith | QuickPay | 1246 | Jane Doe | $38.38 | 10/24/2023 13:23 | PGJJT3-5P8V | PPS010 | Sale | Approved | QuickPay | MC - **5454 | Jane Doe | QuickPay | 1298 | Michael Brown | $50.81 | 10/24/2023 13:27 | PGJK2B-5P9B | PPS010 | Sale | Approved | POS | MC - **5454 | Michael Brown | [email protected] |
---|