| How to set up bank reconciliation |
Resolution | Before you Begin- For the initial setup, you can only reconcile the account in the current fiscal year
- If you must reconcile outside of the current fiscal year:
- Do a manual bank reconciliation until the end of the previous fiscal year
- Continue with the bank reconciliation setup
Enable the Bank reconciliation
- In the Home window:
- In Enhanced View: Select Company, then double-click Chart of Accounts
- In Classic View: double-click on Chart of Accounts
- Double-click on your bank account.
- Select the Reconciliation & Deposits tab.
- Place a mark in Save Transactions for Account Reconciliation.
- Click the Set Up button at the bottom of the page.
- Set up revenue accounts for the following:
- Interest income
- Exchange gain
- Error - Gain
- Adjustments
- You can also set up expense accounts for:
- Bank Charges
- NSF Fee
- Interest Expense
- You can rename the Interest Expenses to agree with the bank statement.
- Click OK.
To set up Bank Reconciliation- In the Home window:
- In Enhanced View, go to the Banking tab and click Reconcile Accounts
- In Classic View, double-click on Reconciliation & Deposits
- Choose the bank account you’re reconciling.
- Enter the following from the report provided by your financial institution:
- Statement Start Date
- Statement End Date
- Reconciliation Date
- Statement Opening Balance
- Statement End Balances
- Select the Add Prior Outstanding button.
- If you receive a prompt to save changes, select YES when prompted to save changes.
- Click OK.
- Set the Show Resolved Trans. On or After: date to the oldest outstanding transaction.
- From the list of Resolved Transactions:
- Select outstanding transactions dated before the statement beginning date
- Click Add to move to the Outstanding Transactions list
- Select Insert Outstanding to add transactions that don’t appear in the list.
- When finished, click OK.
- Check if the discrepancy is zero before clearing transactions. If not zero:
- You missed adding outstanding transactions
- Added a wrong outstanding transaction on ‘Add prior outstanding window’
- The opening balance amount on bank reconciliation is incorrect
- If there’s no discrepancy, click Process to post the bank reconciliation.
- Print the Account Reconciliation reports.
[BCB:159:Chat 50 CA English:ECB]
|
|