Making sure the information in Aplos is accurate is extremely important, and bank reconciliation is an essential tool to accomplish this. If your accounting software doesn’t accurately reflect your bank’s statement, you could be headed for trouble.
How To Do A Bank Reconciliation
Bank Reconciliation is specifically designed for the purpose of reconciling your bank statement with the information in Aplos. Here is how you would go about completing a Bank Reconciliation. See the step-by-step instructions below.
- Access your Bank Reconciliation: Fund Accounting > Transactions > Bank Reconciliation.
- Pick which Cash account you’ll be reconciling. The opening balance will remain 0.00 for your first Bank Reconciliation. The opening balance will be automatically calculated for all following reconciliations.
- Select the statement ending date. For instance, if you’re looking at a bank statement that ends on May 31, select that as the ending date.
- Enter the statement ending balance. This is the balance of the account at the ending date of the statement. Click “Start Reconciliation.”
The transactions shown on the next screen are the entries you’ve entered into Aplos. On the bottom right of the screen you will see your Beginning Balance, and then Checks and Payments, Deposits and Other Credits, and your Statement Ending Balance. As you click through the transactions, you will be marking the payments and deposits as cleared, with the goal of arriving at your Statement Ending Balance.
Beginning Balance – Checks and Payments + Deposits and Credits = Statement Ending Balance
Here are the steps on how to proceed once you’ve set your ending date and balance (picture below). The best way to go about this is to print a bank statement for the period you’re reconciling, get a highlighter and pen, and follow these steps:
- Check the transactions on your bank’s statement by going down the list. If something appears on both your bank statement and Aplos, check the box next to the transaction and cross it off your paper bank statement. If this is your first reconciliation, you’ll also need to check off your starting balances. As you check things off, you’ll notice the difference either increases or decreases. To finish and complete a bank reconciliation, the difference must be 0.00.
- If you find a transaction that does not appear on the statement or in the software, highlight them and do some further research. It’s possible something cleared your bank that was never entered in Aplos or something was entered in Aplos that never cleared your bank. Select “Finish Later” if you need to come back at another time, or “Edit Statement Details” if you need to change the statement ending date or balance.
- Once you’re finished, click “Finish Now” to complete your first bank reconciliation.
- When you click “Finish Now,” you can view the report and print or export your completed bank reconciliation. You may notice that you have a list of uncleared transactions. That’s okay. They’ll most likely be included in your reconciliation the following month.
5. If at some point down the road you need to make changes to your reconciliation, you can click the “Re-open this rec” button (shown below) to edit details of the reconciliation or transactions.
Note: Re-opening a bank reconciliation will delete any bank reconciliations that are currently in progress for this account. You will need to re-reconcile each reconciliation after making changes.
It may be helpful to print out a Bank Reconciliation report before opening up multiple Bank Reconciliations so you have a hard copy of the Checks/Payments and Deposits/Other Credits for your reference.
Congratulations! You’ve finished your first bank reconciliation. This process is very important and should be done often. For most organizations it is a monthly process, but that could vary depending on your needs.