Reconciliation Function
Participants in the Electronic Funds Transfer (EFT)
Services MSA have several critical reconcilement
responsibilities that must be performed on a timely basis.
The procedures to be used depend upon the type of
participant and the type of payment - outbound or inbound.
|
Outbound ACH
Transactions |
- Wachovia Bank is the required
Originating Depository Financial Institution (ODFI) which
processes the outgoing ACH credit file on behalf of the
participant.
- The participant has a dedicated stand-alone settlement
account which must be funded with “immediately available funds”
by the participant on the settlement date.
- On settlement date (effective date denoted on the ACH file),
Wachovia debits the settlement account, based upon the ACH file
transmitted to the bank, either directly or via CPS.
- In the case of a participant having funds on deposit with
the State Treasurer, the participant uses DST’s Core Banking
System to have funds wired into the settlement bank account,
using the Funds Transfer feature (Electronic Warrant).
- In the case of a community college or LEA, the funding is
generally done with a combination of the unit's local bank check
and a State warrant. Since banks consider State warrants "next
day funds," it is permissible for the warrants to be deposited
one banking day prior to the settlement date. The State
Treasurer's publication entitled, "Banking Services Handbook,"
should be referenced (pages 44-45).
- Wachovia Connection is the tool used to access the account
activity.
- In addition to Wachovia Connection access, hard copy bank
statements are normally sent directly to the participant at
month-end, to assist in reconcilement.
- It is the participant’s responsibility to reconcile the bank
account statement to ensure that there are no unauthorized or
erroneous transactions.
- ACH Returns (payments sent out which bounce due to wrong
bank account info, “account closed,” etc.) are credited back to
the settlement account. A separate Returns Account is not need
for outbound transactions. Wachovia Connection is the tool used
to retrieve a daily “ACH Returns Report.”
- The credit balance in the settlement account created by
Returns can be cleared by a number of ways: 1) The bank can be
requested to remit the funds to the participant by "official
check" or by a "book transfer;" or 2) the funds can be used to
fund a subsequent outgoing ACH Credit file.
- “Notifications of Change” (NOC) are received by Wachovia for
any payments that were sent with the wrong bank account
information for the payee. The NOCs are contained on the ACH
Returns Report viewed through Wachovia Connection.
- ACH Origination Reports are also available through Wachovia
Connection. This report lists all transactions contained on an
ACH file submitted to Wachovia.
|
|
Inbound ACH
Transactions |
-
There are two types
of inbound transactions (collections). One is where the
participant initiates an “ACH debit” against a payor’s account
by creating an ACH debit file and transmitting it to Wachovia,
which then submits the debit though the banking system. The
other is where the payor initiates an “ACH credit” through its
own bank and submits the payment to the participant’s account at
Wachovia.
-
Wachovia Bank is the
required Originating Depository Financial Institution (ODFI)
which processes the ACH debit file on behalf of the participant.
While Wachovia is the depository for the receipt of ACH credits
submitted by payors, the payor can use his bank of choice as the
ODFI.
-
In the case of a
participant having funds on deposit with the State Treasurer, a
dedicated settlement bank account is established to facilitate
the receipt of inbound payments. The account is established as a
Zero Balance Account (ZBA), with the balance in the account
being swept to a DST bank account at the close of the banking
day. The deposit must then be certified on CMCS.
-
In the case of a
participant not required to “bank” with the State Treasurer, the
account for inbound payments does not necessarily have to be a
Zero Balance Account (ZBA).
-
In the case of a
State agency, where the settlement account is a ZBA account that
sweeps to a DST bank account, a separate Returns Account is
established at Wachovia, for which ACH debit Returns funds are
debited against, as specified in special instructions associated
with the settlement ZBA account. It is the responsibility of the
participant to clear any deficit balances in the Returns Account
timely.
-
Wachovia Connection
is the tool used to access the account activity, in both a
settlement account and a Returns account.
-
In addition to
Wachovia Connection access, hard copy bank statements are
normally sent directly to the participant at month-end, to
assist in reconcilement - for both the settlement account and
the returns account.
-
It is the
participant’s responsibility to reconcile the bank account
statements to ensure that there are no unauthorized or erroneous
transactions.
|
|
Reconciliation Tools -- Online
Systems |
- Wachovia Connection
- Web-based system provided by Wachovia Bank allowing the
participant banking at Wachovia to view settlement activity and
ACH returns activity in the bank settlement account(s).
http://www.wachovia.com/wachoviaconnection
- Cash Management Control
System (CMCS) - System provided by OSC to State agencies to
report deposits to its CIT bank account (for inbound
transactions). Amounts reported are to be the total of the
amount swept, as viewed on Wachovia Connection.
http://www.ncosc.net/sigdocs/sig_docs/cash_mgmt/sect_5.html
- Core Banking System -
System provided by DST allowing State agencies to view their CIT
bank account activity (for inbound transactions), which reflects
both: 1) the daily amount swept to the State Treasurer's bank
account; and 2) the daily amount certified by the agency on CMCS
to its CIT bank account. The system is also used (in the case of
outbound transactions) to initiate Electronic Warrants through
the Funds Transfer feature, to fund outgoing ACH credit files.
http://www.nctreasurer.com/dsthome/FinOperations/CoreBanking/
- Common Payment Service (CPS)
Reports - Available to those participants utilizing the
Common Payment Service (CPS).
http://www.ncosc.net/SECP/SECP_CPS.html
|
|
Most Commonly Used
Reconciliation Reports |
| System |
Report |
| Wachovia Connection |
Previous Day Transaction Report |
| Wachovia Connection |
EFT Advice Report (Same day - ACH) |
| Wachovia Connection |
Interim Account Statement |
| Wachovia Connection |
ACH Origination Report |
| Wachovia Connection |
ACH Returns Report |
| |
| Common Payment Service |
ACH Transactions - Settled |
| Common Payment Service |
ACH Transactions -
Failed to Settle |
| Common Payment Service |
ACH Files - Transmitted |
| Common Payment Service |
ACH Files - Failed to Settle |
| |
| DST Core Banking |
Account Activity (CIT bank account -
Inbound) |
| DST Core Banking |
Unmatched CIT/CMCS View (Inbound) |
| DST Core Banking |
Account Activity (Disbursing/STIF -
Outbound) |
| DST Core Banking |
View Funds Transfer (Outbound) |
| |
| CMCS |
Display List of Deposits - AK24
(Inbound) |
|
Reconciliation
Responsibilities of Participant |
-
Verify that the
batch total amount of an ACH file transmitted to Wachovia is the
amount that Wachovia either debits or credits to the bank
settlement account.
-
Verify that the
posting dates of transactions to the Wachovia settlement account
correspond to the effective date of the ACH file, to ensure
timely funding or reporting.
-
Perform a
reconcilement between internally-generated reports for ACH files
transmitted, to transaction reports received from CPS (if Common
Payment Service is used).
-
For inbound
transactions, perform a reconcilement between the amount of the
daily sweep from the participant’s settlement bank account to
the DST bank account, as viewed on Wachovia Connection, to
amount certified on CMCS, as viewed on DST’s Core Banking System
(certified to the CIT bank account).
-
For outbound
transactions, perform a reconcilement between the amount
remitted to the settlement bank account, as viewed on Wachovia
Connection, to the amount of the Electronic Warrant, as viewed
on DST’s Core Banking System.
-
Perform a
reconcilement between ACH Returns reflected on Wachovia
Connection to the amounts debited/credited to the settlement or
Returns account.
-
Perform a monthly
reconcilement of the monthly bank statement for the settlement
account to ascertain that there are no unaccounted for
transactions. (In the case of a ZBA account for inbound
transactions, the balance will always be zero at the close of
each day.)
-
Perform a monthly
reconcilement of the monthly bank statement of the Returns
account to ascertain that there are no unaccounted for
transactions.
-
Verify the accuracy
of the monthly Wachovia invoice before payment (unless fees are
paid by DST).
|
|