| 1.1. Prerequisites for the Bank Accounts Setup |
Complete the attached worksheet and " Mark as Completed RoadMap Section C Item 4-a" before continuing the setup.
General Ledger Accounts must be completed before using this section. It is very important that the Bank Account number is unique. Same BANK ACCOUNT NUMBER CAN NOT be assigned to more than one bank name. This could cause incomplete or duplicate transactions.
|
| 1.2. Introduction for the Bank Accounts Setup |
Enter all checking, savings, and other accounts where funds are deposited and disbursed. Each Bank account must have an individual general ledger number assigned to it. The Interest and Bank Charges from the bank accounts can be the same for each bank, if desired.
When setting up a new Bank Account the beginning balance will be 0.00. If the Bank Account being setup in the ManEx system carries a Balance the Bank Balance within the setup will be 0.00. Then, the user will be required to generate a so called "OPENING" Journal Entry which will Debit the Bank Account General Ledger number. Once the Journal Entry is posted to the General Ledger, both the Bank Setup Balance and the General Ledger Account number Balance will be updated and should match.
|
| 1.3. Fields & Definitions for the Bank Accounts Setup | |
Bank Accounts
| Bank |
The name of the bank. |
| Account Title |
The exact same as the G/L account title |
| Type of Account |
Checking, Savings, Money Market, etc |
| Account Number |
The Bank’s account number, not the G/L account number.
|
| Balance |
The bank balance is maintained in a real-time mode by ManEx. This balance is updated for deposits to or checks written from the account even though the data is not yet posted into the General Ledger. The balance will also pick up any Journal Entry into the bank account once the Journal Entry is posted. |
| Name of the Bank |
The name of the bank. |
| Inactive |
This will allow the users the ability to mark a Bank Account as Inactive. Any Bank Account with an Inactive status will no longer be available for selection when processing new records throughout accounting, yet the data associated with this Bank Account will still be available for transaction history purposes. |
| Virtual |
used in currency transfer and check module (if FC installed) Only the banks that are not virtual can be selected in currency transfer, Check Batch Scheduling and Check maintenance |
| Preferred |
Not used at this point in time |
| Preferred for Deposits |
Not used at this point in time |
Preferred for Withdrawal
|
Used in currency transfer and check module (if FC installed). Only the banks that are preferred for withdrawal can be selected in currency transfer and Check Batch Scheduling. |
| |
|
| Account Title |
The exact same as the G/L account title |
| Account Type |
Checking, Savings, Money Market, etc |
| Account Number |
The Bank’s account number, not the G/L account number.
|
| Bank Account G/L Number |
The General Ledger number as assigned in the General Ledger Account Setup screen. |
| Bank Charges G/L Number |
The General Ledger number as assigned in the General Ledger Account Setup screen. |
| Interest Earned G/L Number |
The General Ledger number as assigned in the General Ledger Account Setup screen. |
| Check Numbering |
Select whether or not you want the Manex system to automatically assign the check number. |
| Last Check Number Used |
Type in the last check number used. |
| Bank Balance |
This field is NOT editable, even when setting up a new Bank Account. When setting up a new Bank Account that has never been used by the user, the Bank Balance needs to be 0.00 at initial setup and any Deposits or Checks written from this account (even though the data is not yet posted into the General Ledger) from this Point forward processed through the ManEx System will properly update the Bank Setup Balance at the same time it updates the General Ledger Account number balances, keeping the two balances in sync.
If the Bank Account being setup carries a balance, but has never been used in the ManEx system before, the Bank Balance within the Setup needs to be 0.00. Then the user will be required to generate an "OPENING" Journal Entry which will Debit the Bank Account General Ledger number. Once the Opening Journal Entry has been posted to the GL, both the Bank Setup Balance and the GL Account number Balance will be updated keeping the two balances in sync.
|
| |
|
| e-Bank Information |
will open screen that will allow you to populate the e-Banking information for the Highlighted Bank. See Article #5979 |
| |
|
| |
|
|
| 1.3.1. eBank Setup Directive Button | Fields and Definitions for eBank Setup
| Originator (Name on Account) |
This would be the your name associated with your Bank Account |
| Address |
The bank institution address information |
| City |
The bank institution City |
| State |
The bank institution state |
| Postal Code/Zip |
The bank institution zip code |
| Country |
The bank institution country |
| Phone |
The bank institution phone number |
| Fax |
The bank institution fax number |
| Attention |
Person or department at bank institution |
| E-Mail |
email address for the bank institution |
| Originator Bank Name |
This is the Bank name carried forward from the prior screen for highlighted record. |
| Originator Bank Account Number |
This is the bank account number carried forward from the prior screen for the highlighted record |
| Bank Branch |
The bank institution branch |
| Bank Routing |
The bank institution routing number |
| Bank ID/SWIFT |
international bank code that identifies particular banks worldwide. It's also known as a Bank Identifier Code (BIC). CommBank uses SWIFT codes to send money to overseas banks. A SWIFT code consists of 8 or 11 characters |
| Country Code |
The bank institutions country code |
| Default Payment Type |
Choose from the following options:
|
| |
CHECK
WIRE TRANSFER
ACH
ONLINE BANKING
CREDIT CARD, BANK DRAFT |
| Next E-Reference # |
The next desired reference number that will be assigned to the next e-record |
| Automatic Number |
if checked the system will assign the next reference number automatically |
|
| 1.4. Fields & Definitions for the Bank Accounts Setup - Foreign Currency | 
Bank Accounts
| Bank |
The name of the bank. |
| Account Title |
The exact same as the G/L account title |
| Type of Account |
Checking, Savings, Money Market, etc |
| Account Number |
The Bank’s account number, not the G/L account number.
|
| Balance |
The bank balance is maintained in a real-time mode by ManEx. This balance is updated for deposits to or checks written from the account even though the data is not yet posted into the General Ledger. The balance will also pick up any Journal Entry into the bank account once the Journal Entry is posted. |
| Name of the Bank |
The name of the bank. |
| Inactive |
This will allow the users the ability to mark a Bank Account as Inactive. Any Bank Account with an Inactive status will no longer be available for selection when processing new records throughout accounting, yet the data associated with this Bank Account will still be available for transaction history purposes. |
| Virtual |
used in currency transfer and check module (if FC installed) Only the banks that are not virtual can be selected in currency transfer, Check Batch Scheduling and Check maintenance |
| Preferred |
Not used at this point in time |
| Preferred for Deposits |
Not used at this point in time |
Preferred for Withdrawal
|
Used in currency transfer and check module (if FC installed). Only the banks that are preferred for withdrawal can be selected in currency transfer and Check Batch Scheduling. |
| |
|
| Account Title |
The exact same as the G/L account title |
| Account Type |
Checking, Savings, Money Market, etc |
| Account Number |
The Bank’s account number, not the G/L account number.
|
| Bank Account G/L Number |
The General Ledger number as assigned in the General Ledger Account Setup screen. |
| Bank Charges G/L Number |
The General Ledger number as assigned in the General Ledger Account Setup screen. |
| Interest Earned G/L Number |
The General Ledger number as assigned in the General Ledger Account Setup screen. |
| Check Numbering |
Select whether or not you want the Manex system to automatically assign the check number. |
| Last Check Number Used |
Type in the last check number used. |
| Bank Balance |
This field is NOT editable, even when setting up a new Bank Account. When setting up a new Bank Account that has never been used by the user, the Bank Balance needs to be 0.00 at initial setup and any Deposits or Checks written from this account (even though the data is not yet posted into the General Ledger) from this Point forward processed through the ManEx System will properly update the Bank Setup Balance at the same time it updates the General Ledger Account number balances, keeping the two balances in sync.
If the Bank Account being setup carries a balance, but has never been used in the ManEx system before, the Bank Balance within the Setup needs to be 0.00. Then the user will be required to generate an "OPENING" Journal Entry which will Debit the Bank Account General Ledger number. Once the Opening Journal Entry has been posted to the GL, both the Bank Setup Balance and the GL Account number Balance will be updated keeping the two balances in sync.
|
| |
|
| Currency |
Bank Currency |
| Home Bank Balance |
Same as the Bank Balance but it would be for the Home Bank currency |
| Exchange Rate |
Exchange Rate |
| Last Update |
Would be the last time the Exchange Rate was updated |
| |
|
| e-Bank Information |
will open screen that will allow you to populate the e-Banking information for the Highlighted Bank. See Article #5979 |
| Add Cash Book Records |
Calculates and generates Summary records of all checks, deposits, and currency transfer transactions for each FY/period for each bank. It shows the beginning balance, end balance of each period for all banks.
Usually, when user close a period, the cashbook record will be updated to save the end balance for this period and create a new record for next period. But sometimes, the user adds a new bank, the new bank won't have all the cashbook records (even the balance should be 0). Click this "Add cashbook records", the system will add new cashbook records for this new bank if it any period is missing.
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| 1.4.1. eBank Setup Directive Button | Fields and Definitions for eBank Setup
| Originator (Name on Account) |
This would be the your name associated with your Bank Account |
| Address |
The bank institution address information |
| City |
The bank institution City |
| State |
The bank institution state |
| Postal Code/Zip |
The bank institution zip code |
| Country |
The bank institution country |
| Phone |
The bank institution phone number |
| Fax |
The bank institution fax number |
| Attention |
Person or department at bank institution |
| E-Mail |
email address for the bank institution |
| Originator Bank Name |
This is the Bank name carried forward from the prior screen for highlighted record. |
| Originator Bank Account Number |
This is the bank account number carried forward from the prior screen for the highlighted record |
| Bank Branch |
The bank institution branch |
| Bank Routing |
The bank institution routing number |
| Bank ID/SWIFT |
international bank code that identifies particular banks worldwide. It's also known as a Bank Identifier Code (BIC). CommBank uses SWIFT codes to send money to overseas banks. A SWIFT code consists of 8 or 11 characters |
| Country Code |
The bank institutions country code |
| Default Payment Type |
Choose from the following options:
|
| |
CHECK
WIRE TRANSFER
ACH
ONLINE BANKING
CREDIT CARD, BANK DRAFT |
| Next E-Reference # |
The next desired reference number that will be assigned to the next e-record |
| Automatic Number |
if checked the system will assign the next reference number automatically |
|
| 1.5.1. Bank Accounts Setup |
|
Enter SQLACCTSETTING.EXE (within the ManEx root directory)
This action will then prompt the user for a password
|
 |
| The following screen will be displayed, enter the Bank Setup |
 |
The following screen will be displayed:
Banks may be added by pressing the Add button.
Enter all checking, savings, and other accounts where funds are deposited and disbursed. Each Bank account must have an individual general ledger number assigned to it. The Interest and Bank Charges from the bank accounts can be the same for each bank, if desired.
NOTE: The GL account fields must be populated, if left blank this could cause incomplete transactions. Same GL account numbers cannot be used in more than one Bank account. NOTE: The accounts selected as defaults must have the class of posting in the General Ledger Account Setup screen.
Depress the Save button to Save the New Bank Account, depress the Abandon Changes button to abandon the Changes.
This field is NOT editable, even when setting up a new Bank Account. When setting up a new Bank Account that has never been used by the user, the Bank Balance needs to be 0.00 at initial setup and any Deposits or Checks written from this account (even though the data is not yet posted into the General Ledger) from this Point forward processed through the ManEx System will properly update the Bank Setup Balance at the same time it updates the General Ledger Account number balances, keeping the two balances in sync.
If the Bank Account being setup carries a balance, but has never been used in the ManEx system before, the Bank Balance within the Setup needs to be 0.00. Then the user will be required to generate an "OPENING" Journal Entry which will Debit the Bank Account General Ledger number. Once the Opening Journal Entry has been posted to the GL, both the Bank Setup Balance and the GL Account number Balance will be updated keeping the two balances in sync.
The bank balance is maintained in a real-time mode by ManEx. This balance is updated for deposits to or checks written from the account even though the data is not yet posted into the General Ledger. The balance will also pick up any Journal Entry into the bank account once the Journal Entry is posted.
Once one or more banks are entered, they may be edited or deleted by selecting the bank and pressing the Edit or Delete button. After using Add, Edit or Delete, the user must Save or Abandon changes.
User may inactivate a Bank, by selecting the bank and pressing the Edit button, then check the Inactive box. This will filter out the inactive bank accounts on all pulldown screens except for the pulldown located on the check register screen. User may view the check register for an inactive bank.
Where Used: This Setup is used in Accounts Payable, Check writing, Deposits and as the balance used in the Bank Reconciliation module.
After completing this section; «Mark as Completed in RoadMap in Section C Item 4-a»
|
|
