Purpose: This guide is designed to support church administrators and volunteers in completing accurate bank reconciliations using QuickBooks and online banking portals. A companion video, Reconciling Bank Accounts, is available for visual reference.
Click on Pending.
Use the pulldown to filter for Suggested matches.
If the dates are identical or pretty close and the bank description is consistent with the transaction description in QuickBooks, click on the Match link on the far right to confirm the suggested match.
Use the pulldown to filter for All transactions.
If QuickBooks identified 2 or more existing transactions that could match a bank transaction, click on ?LINK? and pick the existing QuickBooks transaction that most closely matches the bank date and bank description.
Click on Match.
Repeat until all suggested matches whether single of multiple are posted.
For any of the remaining bank transactions that you determine to be legitimate, create the appropriate QuickBooks expense, deposit or bank transfer and match it to the bank transaction.
If a bank transaction is clearly an Amazon purchase follow the steps for Recording Amazon Purchases.
Any bank transaction that you cannot substantiate should be brought to the attention of the Treasurer immediately.
Simmons Bank:
Log into Simmons Bank.
Download the statements for each account.
PNC Bank:
Navigate to Account Activity page at PNC Bank.
Download the bank statement.
Move all downloaded PDF files to the Bank Statements folder on Google Drive.
Navigate to the Banking transactions page in QuickBooks.
Match all transactions for the month just ended (see above).
Watch the training video Reconciling Bank Accounts again for visual guidance.
Still stuck? Contact the church finance administrator or designated support person.
