Bank Accounts

Overview

 Bank Accounts are a List of only the General Ledger Bank Accounts that have been set up within the Chart of Accounts and are flagged as 'Is Bank'.

If a 'New' or 'Additional Bank Account' needs to be set up, please ensure that it is set up firstly from within the 'General Ledger Chart of Accounts' in the right area.
Creating/ Modifying a general ledger account
There is a check box 'Is Bank' on all general ledger accounts within the settings tab. If this tick is ON that determines if this bank account is going to be reconciled and the account is a type of BANK.
If this tick is ON, then all transactions linked to the tender that points to this bank account will flow through to the Banking Module.
If this tick is OFF, then all transactions linked to the tender that points to this bank account will not flow through to the banking module.
If the transactions are not in the relevant bank account, then these transactions will not be part of that bank account bank reconciliation.

All transactions to any general ledger account, that is flagged as 'IS BANK' must come from a source transaction.

You should never have to adjust a bank account via a general ledger journal.
If you do insert a journal against a bank account and you are using Bank Reconciliations, you can expect to have a General Ledger Variance.

If you should have to ever insert a journal entry against a type of Account that that has 'Is Bank' turned on, please ensure you do so when no one is on the system.
Turn the tick off quickly, save the account.
Insert the Journal against this bank account.
Ensure to turn the tick back on 'IS BANK" and click on Save

The Bankings Module gives you a History in Detail and Summary for each Bank Account for all Movements and Dissections from each source transaction.

 

From within the Bankings Module the Bank Accounts can be drilled down further see Point Forms in summary below:

Reference

Buttons 

Refer to Common Buttons.

ImageFieldDescription
Set Period RangeSet the Period by Clicking on 'Set Period Range' (top task bar)  'SET PERIOD RANGE' . By Setting the Period Range, the system will display the values calculated for all movements for that Period range. These Values are shown in the fields of  'Acutal Opening Balance'; 'Actual Movement'; 'Actual Closing Balance'.

Fields

FieldDescription
Account IDGeneral Ledger Bank Account
DescriptionThe Name of the Bank Account 

Account Sites tab

Button

Account Site ID Tab: Is The General Ledger Bank Account with the Site Code. Transactions that affect any Bank will have a movement and dissections.

ImageFieldDescription
DissectionsIs a list of all the transactions that have been dissected against that Bank Account highlighted for the Period Range that has been set.
Daily TotalsShows you a Total Dollar Value Summarised by Date,Transaction Type for all transactions for that one Account Site.


FieldDescription
Account Side ID Is The General Ledger Bank Account with the Site Code.

Status tab

FieldDescription
Actual Opening BalIs the total sum of all Movements for the Prior Periods to the Period that has been set.
Actual Closing Balis the Difference between the Actual Opening Balance - Actual Movements.
Actual Movementis the Sum of all movements for all transactions transactions for the Period Range Selected.

Balance and Budgets tab

Button
ImageNameDescription
Set Budget Value
Reference
FieldDescription
Period Period YYYYMM
Actual Movement Total Value of the movements for the accountsite for the period for the account 
Budget Movement Total value of the budger for the accountsite for the period for the account
Variance Difference between Actual Movement and Variance for the period for the account
Daily Balances tab
FieldDescription
DateThe date and time for the $sum of the transactions for that account for the date
Actual MovementThe actual movement is the total of all the debit less credit postings to one general ledger account site
Budget MovementThe budget movement is the total value of the budget to one general ledger account site
Variance The $sum of the actual movements - budget movement for the date
Dissections
FieldDescription
DateThe date and time for each dissection
Card IDThis is a unique code that identifies the card
NameThis field shows the name of the customer, supplier or manufacturer.
Transaction TypeThe unique field to stand for what the transaction is
Transaction NumberThis field contains a unique transaction number that identifies the dissection
TenderTender used at the time of the transaction 
DescriptionDescription entered at the time of the transaction 
Debit ValueThis is the debit value of the dissection
Credit ValueThis is the Credit value for this dissection

General Tab

FieldDescription
Bank Account Name Name that stands for the general ledger bank account set up
Bank Account BSB BSB assigned to this account
Bank Account Number Bank account number assigned to this account

Bank Account

  1. If you highlight a bank account, then click on 'Account sites' tab, then on the balance and budgets tab highoight a period.
    Click on the action button 'Daily Totals'.
    A window will open to show you in detail a list of transactions for that account for the period selected

  2. If you highlight a transaction from within the Daily Totals window, you will see in the detail area below what transations make up the header value.
    From here if you click on 'Source Record' you can go back to the original transaction.

     Show me



  3. If you highlight a bank account and click on Account Sites Tab and select a account site>click Balance and Budgets  and highlight a period > click Dissections Tab you can see in details what  a list of the source transactions that make up the general ledger dissection.
    You can also navigate back to the source record from here.

    You are taken back to the original transaction itself.
    A Date and/or Period range can be set before hand for the Daily Totals.

  4. From within 'Daily totals' if you click on 'Set Date Range'  'SET DATE RANGE'
  5. From within 'Daily totals' if you click on 'Set Period Range'.  'SET PERIOD RANGE'

You can Export the result to one of the Following formats if you wish. Export To Button

 Show me

Balance and Budgets Tab:

  1. The Balance and Budgets tab contains the Movement for the period and the Budget for the Period. 
    The 'Variance' is the difference between the Movement and Budget for the period set.
    The Period range that is set,whether it be at the header level or detail level is global.

     Show me

    As you highlight each Period within 'Balance and Budgets' a Daily Balances Summary View displays below.

    This view show you the sum of all Movements and Budgets by Date Range for that Period highlighted.

     Show me

    As you highlight anywhere within the Daily Balances detail view, then click on Dissections button, you will see the break up for that makes up that whole period highlighted.

     Show me

    Once again if you highlight one of the transactions within the Dissections Detail View and click on 'Show Source Record' you will see the original transaction itself. 

     Show me

Setting up a Budget Value

  1. To set up a Budget for a Bank Account.
  2. Click on the Account> 'Balance and Budgets'>Period
  3. Click on 'Set Budget Value'
  4. Enter The budget value and click on OK to accept

     Show me