Reconcile athenaOne Deposits to Bank Activity

On the left side of the Review Activity tab, a window displays the live bank feed that athenaOne receives from U.S. Bank. This bank feed is uploaded between 9 a.m. and 10 a.m. each business day with bank deposits from the previous banking day. Therefore, all live feed confirmation data received in athenaOne from U.S. Bank is generally one business day behind your actual bank activity.

The window on the right side of the Review Activity tab displays the athenaOne deposit batch data. Because athenaOne receives this live feed confirmation insight for U.S. Bank, it performs the deposit reconciliation for you and automatically matches the bank activity to the deposit batches in athenaOne. To ensure that all bank deposits and athenaOne deposit batches are matched appropriately, it is a good practice to review this activity regularly.

On the Review Activity tab, you can match:

• Many athenaMailbox deposits to many deposit batches
• One athenaMailbox deposit to many deposit batches
• One deposit batch to many athenaMailbox deposits

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the Review Activity tab.
3. Select Match next to the athenaMailbox deposit and the deposit batch in question.
4. Click Mark as Matched.
   The items will not actually be matched until you click Save Matches.
5. Click Save Matches.
   The items are matched.

Once matched, any conflicting values change to correlate with the athenaMailbox deposit. These values include deposit date, deposit type, and bank account. If there are different deposit dates in the athenaMailbox deposits selected, the deposit date of the deposit batches is updated to reflect the earliest athenaMailbox deposit in the group. You cannot match athenaMailbox deposits in different months in the same group.

If the amounts of the athenaMailbox deposits differ from the amount of the deposit batches that are matched, a new deposit batch is created for the difference and matched to the group. This athenaMailbox deposit will contain a TOS Discrepancy unpostable.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the Review Activity tab.
3. Select Match next to the athenaMailbox deposit in question.
4. Click Save as non-athenaOne.
   This marks the deposit as non-athenaOne and unmatches it from the deposit batch.

This downloadable report can assist in your daily reconciliation workflow by allowing you to download your U.S. Bank athenaMailbox deposits and deposit batches information in a single, easy-to-understand format. 

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. On the Review Activity tab, select date filters for both athenaMailbox Deposit Dates and Deposit Dates.
3. Click Go.
4. Review all activity to ensure that all deposit batches and deposits match appropriately.
   If there is a large amount of data, it may be difficult to review it in athenaOne. In this case, you can download the report as a CSV file. 
5. Click Download as CSV.
   Note: If the Download as CSV button is disabled and you cannot click it, you have not selected any data. Select some data to enable the button.
   A File Download window appears.
6. Click Open.
   The downloaded report opens in Microsoft Excel and shows you both athenaMailbox deposits and deposit batches.
7. If an athenaMailbox deposit and a deposit batch are matched, athenaOne automatically assigns them the same Group ID, which appears in the first column.
8. The second column is labeled Type and indicates whether a batch is an athenaMailbox deposit or a deposit batch.
   When there is a match, athenaOne shows the athenaMailbox deposit first and then the related deposit batch or batches.

The other columns display the same information that is shown on the page.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. From the Bank Account menu at the far right, select the bank account for the deposit batches.

Search for the deposit batches that match the daily bank activity information

3. The Match Deposit Batches tab shows unmatched athenaOne deposits to this bank account month-to-date. To change the date range, enter new dates in the Deposit Dates fields at the top of the page and click Go.
4. For a more detailed search of deposit batches, click the advanced search link to display additional fields. Set the criteria for your advanced search and click Search. The page refreshes with the search results.
5. To search deposit batches by deposit amount or refund check number, you can use the search tool at the upper right.
   
6. Select the appropriate option, enter the deposit amount or refund check number, and click Go. The page refreshes with the search results.

Match deposit batches to the bank account

7. Under the Match column, click the checkbox to match a deposit batch to this bank account. If a deposit batch is incorrectly matched to this bank account, click the checkbox again to clear the match. 
   Note: If a deposit batch is reconciled to another bank statement, you must un-reconcile it from that bank statement before you can reconcile it to this bank statement.
8. Click Save at the bottom of the page.

To make it easier for you to create and reconcile your U.S. Bank account bank statements, athenaOne autopopulates many elements of the bank statement. However, you will need to enter data from your actual bank statement into some fields.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the Reconcile a Bank Statement tab.
3. Statement Date — Enter the statement date as shown on your bank statement.
4. Statement Period — Enter the date range as shown on your bank statement.
   athenaOne calculates all other values automatically based on the athenaMailbox deposits and matched deposit batches within the statement period for that bank account.
   athenaOne then automatically marks all the deposit batches that were matched through automated processes and the Review Activity tab as matched.
5. Check to see that the Target athenaOne Amount is equal to the Amount Reconciled and that there is a zero dollar Difference.
   The statement should have these values if all athenaMailbox deposits are matched or marked as non-athenaOne through the Review Activity tab.
6. Click Save.

When creating a bank statement for a U.S. Bank account, make sure that you have worked your Review Activity tab fully before reconciling the statement. If you realize that you made a mistake on the Review Activity tab after you start reconciling a bank statement, you can delete that bank statement, make the appropriate changes to the Review Activity tab, and then re-create the bank statement.

A bank statement in athenaOne is created when you enter and save bank statement information. You can have only one unreconciled bank statement per bank account. In other words, to record a new bank statement, you must first reconcile any previous statements for that bank account.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the tab to Reconcile a Bank Statement.
3. Bank Account — Select the bank account that corresponds to your paper bank statement.
4. Enter the bank statement information into the fields provided.
5. Click Save & Reconcile Later. This action creates the bank statement in athenaOne. You can return to the bank statement later using the View Statements tab.

Record the information from the paper bank statement

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the tab to Reconcile a Bank Statement.
3. Bank Account menu (at the upper right) — Select the bank account that corresponds to your paper bank statement.
4. Date — Enter the statement date from the paper bank statement.
5. Period date fields — Enter the statement date range from the paper bank statement.
6. Beginning Balance — Enter the beginning balance amount from the paper bank statement.
7. Ending Balance — Enter the ending balance amount from the paper bank statement.
8. Non-athenaOne $ — Enter the total amount of non-athenaOne credits and non-athenaOne debits. Non-athenaOne credits and debits are transactions that you do not expect to appear in athenaOne, for example, a transfer of money from one bank account to another, a rent payment, or payroll checks written.
9. In-Transit Amount — Enter the sum of any athenaOne bank deposit or withdrawal that has not been opened as a deposit batch in athenaOne.
10. Notes — Enter any notes about this bank statement.
11. Target Amount — Note the amount. This number is automatically calculated based on the beginning balance, ending balance, and total non-athenaOne credits/debits. You will reconcile athenaOne deposits to this amount.
12. Click Save & Reconcile Now. The tab to Reconcile a Bank Statement refreshes, with the bank statement information at the top of the page.

Search for the deposit batches that match the paper bank statement

13. The default display is deposit batches with deposit dates one month prior to the statement period start date through one week after the statement period end date. To change the date range, enter new dates in the Deposit Dates fields and click Go.
14. For a more detailed search of deposit batches, click the advanced search link to display additional fields. Set the criteria for your advanced search and click Filter.
15. To search deposit batches by deposit amount or refund check number, click the appropriate option on the right end of the green bar, enter the deposit amount or refund check number, and click Go. This action searches for exact matches to the deposit amount or refund check number. Matching deposit batches appear below.

Mark deposit batches as reconciled to the paper bank statement

16. Reconcile? — Select this option to reconcile a deposit batch to this bank statement. If a deposit batch is incorrectly reconciled to this bank statement, click the Reconcile? checkbox to clear the reconciliation.
    Note: If a deposit batch is reconciled to another bank statement, you must un-reconcile it from that bank statement before you can reconcile it to this bank statement.
17. Click Save at the bottom of the page to save the work in progress. As you work, the amounts in the Amount Reconciled field and the Difference field are updated automatically.
18. If you need to stop and finish the task later, click Save.

Finish and close the bank statement

19. When you have completed reconciliation for this bank statement, click Save & Close Bank Statement. The bank statement status is updated. If the Difference field is $0, the status is Reconciled; otherwise, the status is Discrepancy. A Re-Open Bank Statement button appears so that you can re-open the bank statement and make changes.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the tab to Reconcile a Bank Statement.
3. Bank Account — Select the bank account that corresponds to your paper bank statement. Unreconciled statements are listed under the heading Continue Reconciling an Existing Bank Statement.
4. Click the icon to re-open the bank statement. The bank statement information appears at the top of the page, with the deposit batches listed below.

Search for the deposit batches that match the paper bank statement

5. The default display is deposit batches with deposit dates one month prior to the statement period start date through one week after the statement period end date. To change the date range, enter new dates in the Deposit Dates fields and click Go.
6. For a more detailed search of deposit batches, click the advanced search link to display additional fields. Set the criteria for your advanced search and click Filter.
7. To search deposit batches by deposit amount or refund check number, click the appropriate option on the right end of the green bar, enter the deposit amount or refund check number, and click Go. This action searches for exact matches to the deposit amount or refund check number. Matching deposit batches appear below.

Mark deposit batches as reconciled to the paper bank statement

8. Reconcile? — Select this option to reconcile a deposit batch to this bank statement. If a deposit batch is incorrectly reconciled to this bank statement, check the Reconcile? checkbox to clear the reconciliation.
   Note: If a deposit batch is reconciled to another bank statement, you must un-reconcile it from that bank statement before you can reconcile it to this bank statement.
9. Click Save at the bottom of the page to save the work in progress. As you work, the amounts in the Amount Reconciled field and the Difference field are updated automatically.
10. If you need to stop and finish the task later, click Save.

Finish and close the bank statement

11. When you have completed reconciliation for this bank statement, click Save & Close Bank Statement. The bank statement status is updated. If the Difference field is $0, the status is Reconciled; otherwise, the status is Discrepancy. A Re-Open Bank Statement button appears so that you can re-open the bank statement and make changes.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the tab to Reconcile a Bank Statement.
3. Bank Account — Select the bank account that corresponds to your paper bank statement. Unreconciled statements are listed under the heading "Continue Reconciling an Existing Bank Statement."
4. Click the icon to select the bank statement. The bank statement information appears at the top of the page, with the deposit batches listed below.
5. Uncheck the deposit batch that you want to un-reconcile.
6. Click Save.  
   Note: If the bank statement was previously saved as reconciled, this action will change the reconciliation status.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the tab to View Statements. From the Bank Account menu, select the bank account that corresponds to the bank statements that you want to view.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Bank Account — Select the bank account that corresponds to your paper bank statement.
3. Click the icon to re-open the bank statement that you need. The Reconcile a Bank Statement tab appear, with the bank statement information at the top and the deposit batches listed below.
4. At the top of the Reconcile a Bank Statement tab, click the icon again to display the bank statement fields in edit mode, where you can make changes.
5. Click Save.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the tab to View Statements.
3. From the Bank Account menu, select the bank account that corresponds to your paper bank statement.
4. Click the icon to delete the bank statement. A warning message appears.
5. Click OK to delete the statement or Cancel to preserve it. If you click OK, the status changes to Deleted, and an undelete icon appears so that you can restore the bank statement if needed.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the Reconcile a Prior Period tab.
3. The default display is deposit batches with post dates in the last 30 days. To change the date range, enter new dates in the Post Dates fields and click Go.
4. Click the checkbox to include the Deposit Batch(s) in the statement displaying above it
5. Click Save.

1. Display the Reconcile athenaOne Deposits to Bank Activity page: On the Main Menu, click Financials. Under MONEY MANAGEMENT, click Reconcile Deposits to Bank Activity.
2. Click the Associate Deposit Batches tab.
3. The default display is deposit batches with deposit dates in the last 30 days. To change the date range, enter new dates in the Deposit Dates fields and click Go.
4. Choose a Bank Account from the menu for a given Deposit Batch row
5. Click Save.