Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

 

Excerpt

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
Image Modified
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
Image Modified
DissectionsIs a list of all the transactions that have been dissected against that Bank Account highlighted for the Period Range that has been set.
Image Modified
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
Image Modified
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
daily balance and budget
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 Movement
 
The 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
of the
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 Type
 
The unique field to stand for what the transaction is
Transaction NumberThis field contains a unique transaction number that identifies the dissection
Tender
 
Tender used at the time of the transaction 
Description
 
Description entered at the time of the transaction 
Debit ValueThis is the debit value of the dissection
Credit ValueThis
field shows
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

...

 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 Viewwindow, below it you will see in the Dissections Detail List a detailed break up of all transctions that actually make up that total transction type for that one day.From the Dissections Detail View, highlight one of the Open items, then click on 'Show Source Record'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.

    Image Removed
    Expand
    titleShow me

    Image Added

    Image Added



  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'

...

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

    Expand
    titleShow me

 

 

 

...