Auto Payment Posting File Format

Owned by Amber Jones (Unlicensed)
Last updated: Sept 18, 2020
1 min read

Below is the key that details the four items needed for importing into the Auto Payment Post tab. An easy option to build the file is to have an excel spreadsheet with the information laid out as below (With no column headers) and saved in CSV comma delimited format.

 

Item

Keys To

Example

Reference #

Reference field in A/R

201542

Check Date

Payment Date

10/29/2018

Check Amount

A/R Payment Amount and invoice amount (always one entry)

2150.11

Invoice Number

Invoice Number

611-10884

 

 

Carvin Software LLC