Difference between revisions of "Bank Account Report"
From TrueERP wiki
(Created page with "<menu name=myMenu align=center> More Detail= Accounts Receivable Report Accounts Payable Report Bank Account Report Bank Codes Banking Reports Cheque [[Ch...") |
|||
| Line 17: | Line 17: | ||
[[To Be Deposited]] | [[To Be Deposited]] | ||
</menu> | </menu> | ||
| − | ==Overview== | + | == Overview == |
| + | |||
| + | The Bank Account Report button takes you straight into your Bank Account Report instead of selecting it via the Report Selector. The Bank Account Report displays a list of all transactions relating to all of your Bank Accounts entered into ERP. Here you can view the total balance of 'All' accounts, or 'Individual' accounts simply by utilising the Filter function. The Report can be viewed by Date Range or Custom Range, and you can view the reconciled quantities as a combined total with the un-reconciled, or as a stand-alone figure. To allow more flexibility you can also Export the list to a spreadsheet for further manipulation if required. | ||
| + | |||
| + | To create Bank Accounts within ERP, refer to Accounts for instructions on the correct set-up. | ||
| + | |||
| + | ==== How To view and use the Bank Account Report ==== | ||
| + | |||
| + | Select the 'Bank Account Report' button within the Banking tab. | ||
| + | |||
| + | The Bank Accounts Report displays as a list of all transactions relating to all Bank Accounts in your ERP database. | ||
| + | |||
| + | *Standard ERP functions like Filtering, Searching, Date Range selection, Sorting apply in the Bank Accounts Report. | ||
| + | |||
| + | *Select the 'Show Reconciled Details' radio button to display the reconciled column that marks the items reconciled with a tick. | ||
| + | |||
| + | *Select the Date Range required, e.g. 1/7/06 to 20/12/06 | ||
| + | *This will load all transactions for all bank accounts between these dates. Note that with the date range expanded there are now transactions displayed for the Payroll Bank account. | ||
| + | *The total balance is displayed at the bottom of screen beneath the 'Amount' column. To display the balance for each individual account, use the Filter function to load the Account you wish to view. | ||
| + | *Select the Account you want the Total Amount for and 'Add to Filter' then 'Execute Filter', e.g. Payroll Bank. | ||
| + | |||
| + | Note that the only Account that is listed is the one you filtered on, and the balance of this account | ||
| + | is displayed at the bottom of the 'Amount' column. | ||
| + | |||
| + | *The 'Total Records' notation has been altered accordingly, i.e. 2 | ||
| + | |||
| + | *Select the 'Clear Filter' button to return to the full list of Accounts. | ||
| + | *Drill into (double-click) any amount to load the transaction it relates to, e.g. Double clicking on £2,690.00 will load | ||
| + | |||
| + | the Customer Payment relating to this transaction. | ||
| + | |||
| + | *The Bank Accounts Report is also Customisable; Exportable; and can be Printed as per the standard ERP functions for lists. Refer to Global Features for further instructions. | ||
Revision as of 11:08, 27 February 2011
Overview
The Bank Account Report button takes you straight into your Bank Account Report instead of selecting it via the Report Selector. The Bank Account Report displays a list of all transactions relating to all of your Bank Accounts entered into ERP. Here you can view the total balance of 'All' accounts, or 'Individual' accounts simply by utilising the Filter function. The Report can be viewed by Date Range or Custom Range, and you can view the reconciled quantities as a combined total with the un-reconciled, or as a stand-alone figure. To allow more flexibility you can also Export the list to a spreadsheet for further manipulation if required.
To create Bank Accounts within ERP, refer to Accounts for instructions on the correct set-up.
How To view and use the Bank Account Report
Select the 'Bank Account Report' button within the Banking tab.
The Bank Accounts Report displays as a list of all transactions relating to all Bank Accounts in your ERP database.
- Standard ERP functions like Filtering, Searching, Date Range selection, Sorting apply in the Bank Accounts Report.
- Select the 'Show Reconciled Details' radio button to display the reconciled column that marks the items reconciled with a tick.
- Select the Date Range required, e.g. 1/7/06 to 20/12/06
- This will load all transactions for all bank accounts between these dates. Note that with the date range expanded there are now transactions displayed for the Payroll Bank account.
- The total balance is displayed at the bottom of screen beneath the 'Amount' column. To display the balance for each individual account, use the Filter function to load the Account you wish to view.
- Select the Account you want the Total Amount for and 'Add to Filter' then 'Execute Filter', e.g. Payroll Bank.
Note that the only Account that is listed is the one you filtered on, and the balance of this account is displayed at the bottom of the 'Amount' column.
- The 'Total Records' notation has been altered accordingly, i.e. 2
- Select the 'Clear Filter' button to return to the full list of Accounts.
- Drill into (double-click) any amount to load the transaction it relates to, e.g. Double clicking on £2,690.00 will load
the Customer Payment relating to this transaction.
- The Bank Accounts Report is also Customisable; Exportable; and can be Printed as per the standard ERP functions for lists. Refer to Global Features for further instructions.
