The following will assist your Finance team with reconciling deposits. Before starting this process, you must have appropriate permissions to access the Finance menu.
Step One: Export the Deposit Report
- Point to Finance.
- Select Deposits.
- Open the Advanced Search option by selecting the magnifying glass icon in the upper right.
- Set the filter to show the date range you will be reconciling. (i.e. change the word Choose to Date then set is (=) between to reflect the 1st date to the last date of the month).
- Set the filter to exclude cash, check, money order and other deposit methods that you may not want to include in this bank reconciliation report (OPTIONAL).
- To export the filtered list to Excel, select the Reports button in the top left (near your name)
- Select the List Data Export from the left column.
- Select Run Selected Reports.
- Select Continue.
- When the Download button changes to green, select it to download the Excel file.
Step Two: Compare the Actual Deposits against the Eleyo Deposit Report
If the total bank deposits for the date range equals the total represented within the Deposit report then you can move on to the next step. If the totals do not match, please contact Support for further investigation.
NOTE: The Deposit dates within the reports are estimates. The most important element is that the net totals for the date range are equal.
Step Three: Compare the Total Bank Deposits for the Date Range to Budget Codes
This report provides the budget code breakdown of a transaction from the date it attached to a deposit. The report data will not change if it is run after any changes have made to the original deposit. This allows for consistency in reporting. (Changes made to budget code allocations may be tracked by exporting the Finance Ledger Details report through the Reports > Reports system menu.
- From the Deposits List View (Finance > Deposits) using the same filter set above, select Reports in the top left (near your name).
- Select the Finance Deposit Summary Report.
- Select Run Selected Reports.
- If you wish to create this as an Excel or CSV file, change the format from PDF to Excel or CSV.
- Select Continue.
- When the Download button changes to green, select it to download the Excel file.
- Compare the List Data Export previously exported with the Finance Deposit Summary Report.
- (Optional) Use the Budget Code Fee Allocation Calculator (Deposits) attached to this article to distribute fees owed by each budget code. Enter the "Total Deposits (for month)" at the top of the page and paste the summary (total dollar amounts by budget code) at the bottom of the Finance Deposit Summary Report into the table.
Select this link to reconcile transaction fees to budget codes