In the Vault: Bank Detail File ACH
Does your department receive payments via ACH? Treasury shares with departments the daily bank transactions in an effort to correctly identify incoming payments. If your department receives ACH transactions but is not set up with Treasury to review this file in Teams; let us know and we will add you to the shared file in Teams!
The following are some quick reminders for the ACH Bank Detail file:
- transactions are posted with a one day lag. Example: all banking data from 8/13 will post to the bank detail file on 8/14
- departments should let Treasury know if expecting an ACH payment so the payment can be applied to the correct dept/fund. Email UND.treasury@UND.edu to let us know about an incoming payment!
- if the department does not let Treasury know of an incoming payment and it is not a re-occurring payment, Treasury will return the funds to the sender or code to the Treasury central fund
- when working in the bank detail file, please do not delete any data. Fields that the department can edit are marked as such
- Treasury may tag you in the bank detail file if there is a question about an incoming payment. Please respond to these tags in a timely manner
- Use the filters in the bank detail file to narrow down the transaction you are looking for or to filter for the transactions that have been tagged as your department
- At month end, Treasury sends a notice in the Teams channel requesting that the bank detail file be reviewed for any transactions that are tagged as your department or for any transactions that belong to your department but are mistakenly tagged as another department. This is an important review; please let us know if you find discrepancies!
- The ACH transactions post to the general ledger once per month in a journal entries with naming convention similar to “ACHJULFY26”
If you would like additional training on the bank detail file or would like to be added to the bank detail file, please let us know and we will set up a time to meet with you!
Questions? UND.treasury@UND.edu