Reconciliation & Reporting Tools

Reconciliation using the aware3 reporting tools is quick and painless. Below, you’ll find an overview of the two types of deposits you’ll see in your bank account, steps to match up deposits to transactions, and several helpful real-world examples.

Review the process below, and then use the Reconcile report located here to view your transaction summaries.

Reconciliation Process

  1. Log into the aware3 portal and navigate to Giving > Reconcile in the top menu.
  2. Select the month to reconcile in the Reconciliation Month field.
  3. Each line item will represent a single day's settlements; refer to the above Deposit Overview to calculate the date that settled transactions will appear in your bank account.
  4. Clicking on any line item will show the set of transactions that settled on a particular day.
  5. For credit transactions, it is possible that more than one deposit will be made to your account on a given day; the total of a day's credit deposits will match the total shown.
    1. If a settlement day was broken into more than one batch to be deposited, three dots (•••) will appear under Batch. Hovering over the dots will show the individual batch totals.

 

Deposit Overview

  • ACH Deposits
    • Description will appear on your bank statement as “NTS”.
    • Settlement days are Monday – Friday.
    • Settlement date will be (1) business day prior to the date of deposit.  
      • Example, if your bank statement shows a $50 ACH deposit on Tuesday, March 8th, the settlement date provided in the aware3 portal will be Monday, March 7th.
  • Credit/Debit Card Deposits
    • Description will appear on your bank statement as “TSYS
    • Settlement days are every day except Saturday, as deposits are submitted on Sunday but banks aren’t open for business - so the Sunday settlements are reflected on Monday.
    • Settlement date will be (1) calendar day prior to the date of deposit.  The only exception is Monday.  Monday deposits can include deposits that settle on Friday & Sunday.

Examples

Scenario 1:  $50 deposit from NTS on Tuesday, March 8th

  • In aware3, choose the following filters:
    • Settlement Date =  Monday, March 7th
    • Payment Type = ACH

Scenario 2:  $100 deposit from TSYS on Friday, March 11th

  • In aware3, choose the following filters:
    • Settlement Date = Thursday, March 10th
    • Payment Type = Credit Card

Scenario 3:  $75 deposit from NTS on Monday, March 14th

  • In aware3, choose the following filters:
    • Settlement Date = Friday, March 11th
    • Payment Type = ACH

Scenario 4:  $125 deposit from TSYS on Monday, March 14th

  • In aware3, choose the following filters:
    • Settlement Date = Friday, March 11th and Sunday, March 13th
    • Payment Type = Credit Card
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk