4.4. Bank Account
4.4.1. Create bank account
- Step 1. Go to the Banking menu under the Accounting module in the left sidebar -> Select the Bank Accounts menu
- Step 2. Click on the Add Bank Accounts button
- Step 3. In the Account popup, fill in the following detail
1. Enter the Name
2. Select the Parent account
3. Enter Balance and as of
4. Enter the Bank name
5. Enter the Bank account
6. Enter the Bank Routing
7. Enter the Address
8. Enter the Description
If you want to enter the number for the bank account, and show the bank account number on the Banking , Reports and Transactions page, you must enable Enable account numbers and Show account numbers.
- Step 4. Click on the Save button
4.4.2. Delete bank account
Only bank accounts with no transactions can be deleted.
4.4.3. Banking Register
To display transactions related to bank accounts in the system.
– First you have to choose a bank account. Data will be obtained based on that bank account.
4.4.4. Posted Bank Transaction
To display bank account transactions taken from the bank. To get the data in this screen you can either get the transaction from the bank (by click Import new bank transactions button at Setup Your Bank Account) or import the transaction ( by click Import excel at Posted Bank Transactions)
– First you have to choose a bank account. Data will be obtained based on that bank account.
Transactions are taken from the bank (at Setup Your Bank Account): can only be deleted.
Transactions imported to the bank (at Posted Bank Transactions): can be edited and deleted.
Import transaction
- Step 1. Click Import excel button
- Step 2. To ensure successful import (correct format, full columns) you should download the template file by clicking Download a sample button.
- Step 3. Enter the data you need to import into the downloaded file and save it.
- Step 4. Select the Bank account-> Click the Choose File button under Select the excel file and choose a file -> click on the Import button
In case the import fails, the Error file download button will be displayed. To see the import error, click Error file download to download the file and see the error.
4.4.5. Reconcile Bank Account
– First you have to choose a bank account. Data will be obtained based on that bank account.
Click Match Transactions button
Click Make adjusting entry button
Select Add this transaction to the bank register
Select Adjust the transaction
4.4.6. Review your bank reconcile
Go to the Reports menu and select Bank Reconciliation Summary and Bank Reconciliation Detail