Reconcile bank accounts
- SelectActions, thenReconcile Bank Accounts.note
- The Reconciliations list includes all current, finalized, and pending reconciliations (indicated by status icons).
- You can use the filter and search to find a specific reconciliation.
- Bank accounts have to have a GL account assigned before you can do a reconciliation.
- Go to theGeneral Informationtab and select the account to reconcile in the Reconciliations list.
- Enter the following information from your bank's statement:
- Statement beginning/end date
- Beginning balance
- Deposits and additions
- Checks and payments
- Ending balance
- (Optional) Use theBank Statement Importtab to import transactions from the bank.
- (Optional) SelectEditand thenInitial Open items. You can use the Initial Open Items screen to enter transactions that won’t affect the bank account balance but are needed for reconciliation purposes only. In other words, the transactions you enter in this window were already accounted for at some point in the account balance, but they are not listed with the other transactions available for clearing in the reconciliation. This feature is typically used to correct or enter outstanding transactions from previous reconciliations that were completed in your previous accounting application.
- Use theDeposits & Additions tab, theChecks & Payments tab, and theDirect Deposit tabto clear the transactions from the application that appear in those tabs. Mark the checkbox in the transaction row to clear a single transaction or selectEditthenClear Allto mark all transactions as cleared. The Total row shows the statement amount, selected amount, checks and other payments amount, cleared total, adjustment total, and unreconciled amount based on the information you entered in the grids.tip
- In theChecks & Paymentstab, you can use theClear Range of Checksscreen to clear multiple checks at once by specifying ranges of checks to clear. Use the Checks Ranges grid to enter the starting reference number and ending reference number for the range of checks to clear. You can clear multiple ranges by specifying each range in a separate row.
- Select the hyperlinked amount for a transaction to go to the source transaction. The application opens that transaction on the Enter Transactions screen where you can review details about the original transaction.
- SelectEditin the toolbar to enter initial open items, adjustments, and to clear a range of checks.
- If you need to have your client make adjustments to their bank account, use theClient Adjustment Transmittal tabto describe those adjustments. This doesn't affect any balances, but will appear on theBank Account Reconciliation Transmittalreport you can provide to your client.note
- The Balance row shows the Corrected ending balance, the Adjust your bank account balance by, and the Difference amounts based on the information you enter in the grid.
- You'll need to mark theClient Adjustment Transmittalcheckbox in the Sections to Include section of thePrint Reportsscreen for these adjustments to show on the Bank Account Reconciliation Transmittal report.
- Go to theAccount Summarytab and review the balances and differences in the reconciliation. SelectAdjustmentto make an adjusting entry for the unreconciled amount, if necessary. This tab provides an overview of the balances based on the transactions on the bank statement compared to the balances based on the transactions entered or imported for the bank account, displaying any unreconciled amount.
- Use theReconciliation Analysistab for suggestions on how to balance the reconciliation. The suggestions are grouped in the following categories: checks and payments, deposits and additions, general ledger balance, and notes.tipYou can right-click in this tab and selectPrint Notesto reference back to them more easily.
- When the unreconciled amount for the bank account is zero, selectFinalizeto finalize the bank reconciliation for this account.
- Before you can close the reconciliation or move to another screen, you'll need to selectFinish Later,Finalize, orCancel.
- If you need to edit a reconciliation that's already been finalized, select it in the Reconciliations list, selectEdit, and thenUnfinalize Reconciliation. This will change the reconciliation status to Pending for the selected reconciliation and any reconciliations completed after the newly unfinalized statement. After you make the necessary corrections, be sure to finalize the statement and all subsequent pending reconciliations.