Delete an ACH Payment

Owned by Kathleen Avery (Deactivated)
Last updated: Jun 09, 2016
1 min read
  1. Locate the file with the payment by going to KFS-Prod, Administration Tab, Batch column, Batch/Scheduled Jobs Section, Batch File link.  Navigate to staging/PDP/paymentExtract.  If file was sent to BottomLine, it will be found in staging/PDP/paymentExtract/Archive. 
  2. Download the file to your desktop and open it with an editor.
  3. Find the payment in question, first entry. 
  4. Delete the <check> through </check> lines for the payment, taking note of the RemitAmount (ex 3360.25).
  5. Find the payment in question, second entry.
  6. Delete the <NachaCCD> through </NachaCCD> lines for the payment.
  7. Go back to the top of the file and locate <TotalItemAmount>, found in <File>,<FileInformation>,<FileSubTotal> entry at the top of the file, just before <Transactions>. Reduce the amount by twice the RemitAmount (ex 6720.50).
  8. Locate <TotalItemCount> (next line) and reduce that amount by 2.
  9. Locate <TotalItemAmount>, found in <Batch>,<Batch Information>,<BatchSubTotal>.  Reduce the amount by the RemitAmount (ex 3360.25).
  10. Locate <TotalItemCount> (next line) and reduce that amount by 1.
  11. Locate <TotalItemAmount>, found in <Batch>,<Batch Information>,<BatchSubTotal>, just after </Transactions>.  Reduce the amount by the RemitAmount (ex 3360.25).
  12. Locate <TotalItemCount> (next line) and reduce that amount by 1.
  13. Save the modified file.
  14. If the file was not processed into BottomLine, replace the file on the server.  (May need Configuration Manager or Server Support to help).
  15. If the file was processed into BottomLine, replace the file at BottomLine.