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.