Payment 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 HighlightRequired
No HighlightNot Required


FieldAdditional DetailsMax Character / Values
Order NumberLooks for an exact number match - if more than one exact match, choose first one, fails if no match found.

Payment Date

Payment TypeMust match an existing Payment Type in your DocketManager system.
Deposit TypeLooks 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.