BookKeeping

Go into Aplos

Fund Accounting > Transactions > Bank Integration

Make sure "checking" account is selected and then click "retrieve transactions"

In Aplos:

• "Fund Accounting" Tab -> Transactions -> Bank Reconciliation

• Pick which Cash account you’ll be reconciling.

Enter opening balance, statement end date, and ending balance

• • • Both can be found on top of page 2 of Huntington statement

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 

1. coding/tagging the transactions

Many of our transactions are set as "recurring transactions, therefore they should come to you auto-tagged. But for others, you will have to assign them a fund, tags, etc.

1st, double check those that are auto tagged and ensure they are correct, edit if necessary.

For transactions coded "STRIPE TRANSFER"

• Donations (Net of Fees}

For transactions coded "MOBILE DEPOSIT"

• Pull up Huntington Account and look at the check image to see what the transaction is. If you are still unsure, ask Cassie.

For transactions you don't know how to code, contact Cassie

2. marking the payments and deposits as cleared, with the goal being to arrive at your Statement Ending Balance. In order to finish and complete a bank reconciliation, the difference must be 0.00. 

• • • 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:

3. Check which transactions show on your bank’s statement. Basically, just go down the list. 

1. • If something appears on your bank statement and on Aplos, check the box next to the transaction and then cross it off your paper bank statement.    

   •  If you find a transaction that does not appear on the statement or in the software, you’ll want to highlight it and do some further research. 

     1. • It’s possible something cleared your bank that was never entered in Aplos, or something was entered in Aplos that never cleared your bank. 

        • You can 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.

4. Once you’re finished, click "Finish Now" to complete your Bank Reconciliation.

You’ll be taken in View Reports where you can print/export your completed bank reconciliation. You’ll 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. Export the report and save it to this drive folder.

fund accounting > transactions > registers