create new ticket
check ticket statusPayment Import CSV
The table below outlines each column included in the Payment-Template.csv file available at the bottom of the page. Additional Details are provided as well as Max Character/Values. Some fields are required for a successful import, these fields are color coded as follows:
Required Fields
| Blue Highlight | Required |
| No Highlight | Not Required |
| Field | Additional Details | Max Character / Values |
| Order Number | Looks for an exact number match - if more than one exact match, choose first one, fails if no match found. | |
| Payment Date | ||
| Payment Type | Must match an existing Payment Type in your DocketManager system. | |
| Deposit Type | Looks for an exact name match; if more than one exact match, choose first one fails if no match found - once an exact name match looks for an open deposit with that name, if no open deposit, creates a new one. | |
| Reference Number | 30 character max | |
| Payment Amount |
Formatting Guidelines
Trim leading and trailing spaces from the entire sheet. If available, we recommend using the Excel add-in Ablebits to do this.
Column header names must follow the exact same naming scheme as provided or the import upload will fail.
Blank rows are considered empty and skipped by the importer.
It is possible to successfully upload 0 rows of information, as long as all required columns are present, the importer will still “succeed”.
Overwrites will be performed on any data that has been changed between exporting/importing.