Bank Reconciliation is specifically designed for the purpose of reconciling your bank statement with the information in Aplos. See the step-by-step instructions below:

Start a New Bank Reconciliation

1. Access your Bank Reconciliation screen: Fund Accounting > Transactions > Bank Reconciliation.
   
    
2. Pick which Register account you’ll be reconciling, and select “Reconcile” to begin.
   • The opening balance will remain 0.00 for your first Bank Reconciliation and will be automatically calculated for all following reconciliations.
3. Select the statement ending date.
   • Ex: if you’re looking at a bank statement that ends on December 31, 2024, select that as the statement ending date.
4. Enter the statement ending balance.
   • This is the balance of the account at the ending date of the statement.
5. Click "Start Reconciliation.​​"

Select Cleared Transactions

The transactions shown on the next screen are the entries you’ve entered in Aplos. On the bottom row of the screen, you will see:

• Opening Balance
• Payments: the total dollar amount of payment transactions that have been selected
• Deposits: the total dollar amount of deposit transactions that have been selected
• Cleared Balance: Calculating the Opening Balance - Payments + Deposits
• Statement Ending Balance
• Difference: Calculating the Cleared Balance - 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.

Here are the steps for how to proceed once you’ve set your ending date and balance. The best way to go about this is to print a bank statement for the period you’re reconciling and follow the steps below.

​

1. Select Cleared Transactions: Check the transactions on your bank’s statement by going down the list. If something appears on both your bank statement and in 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. Note: If you have not set up starting balances, refer to our resource on How to Set Your Starting Balances to learn about this process.
2. Research Missing Transactions: If you find a transaction that does not appear on the statement or in the software, highlight it 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. Click the ^ button in the bottom row next to the “Reconcile” button and select “Save & Close” if you need to come back at another time or "Edit Statement Info" in the top right corner if you need to change the statement ending date or balance.
   
    
3. Finish Your Bank Reconciliation: To finish and complete a bank reconciliation, the difference must be 0.00. Once you’re finished, click "Reconcile" to complete your first bank reconciliation.
   
    
4. When you click "Reconcile," you will get a Congratulations modal that will allow you to easily click to view the report or start a new reconciliation.
   

Attach Your Bank Statement

To improve your internal controls and record-keeping, attach your bank statement for the closed period to your bank reconciliation. Under the “Reconciled” tab, you can see in-progress and closed reconciliations. If you click the Actions button, you will be able to Add Attachment.