Plastiq has its own formats for Committed Reports that we provide to businesses, which include all the important information we have about a given payment in the Plastiq system. It is available in two formats, described below.
By default, reports can be downloaded in .csv format which can be opened with Excel or any spreadsheets tool. To download as a .csv file, simply select the "Download as CSV" option in the upper right corner.
Plastiq JONAS File
Plastiq has developed a JONAS-specific file format integration within our Business Portal, which would allow any club employee to upload the Plastiq JONAS file via the user interface.
To utilize this feature, simply make sure Plastiq JONAS file is selected in the "Report Settings Page". From there, you simply have to run any Committed Report and select "Download as: Plastiq JONAS File" in the upper right corner. You can then upload this into JONAS (see screenshot below) to upload all Plastiq payments into JONAS.
Go the Upload Cash Receipts Files program on the menu and enter/select the appropriate values.
You can key in the Batch# to be whatever you want.
Select ‘Plastiq’ as the Interface
Select the .CSV file that contains the upload information.
If you want, you can select the Preliminary Check. This will just validate the upload file (eg if the member exists) but isn’t required and prints a status report. Even if you select Upload Receipt Batch you get a status report.
This process replaces the ‘Fast Entry – Cash Receipts’ program.
Note: the Batch Date is used as the Payment Date if the date in the upload file is invalid Also, if the member number is invalid, the member number 99999 will be used instead so maybe make sure this member exists as a ‘catch all’. But most users will run the Preliminary check to ensure all member numbers in the upload refer to valid members.
After this is complete, you can go directly to ‘Update of Fast Entry Receipts’.