Account Transaction Projections

Account Transaction Projections

Purpose

To allow the projection of interest to be charged and account balances to a date in the future based on the current interest rate

Timing

This report may be run at any time

Access

  1. From the  button on any Call, Deposit or Variable Loan Account

Report


Report Specific Parameters

Field
Description
Account Number

Display field showing the account code, client coded and account description 

Start Accrued
Display field showing the last date interest was posted to this account
End Accrued
Defaults to todays date

Enter a future date interest to be projected to
Rate
Display field showing the interest rate applicable to this account determined from the interest profile

For Variable Loan Accounts this will be the Future Ledger Interest Profile

Click this button to display the projected transactions

Allows the printing of the projection details displayed



View Report
Selecting the ‘View Report’ option will open the resulting report in the Report Preview dialog
Print Report

Selecting the ‘Print Report’ option will send the resulting report directly to the default printer set up on the workstation and will print the specified number of copies.   

Create Communication

This option allows for the report to be created as a PDF communication file attachment, rather than a report file. 

Export Report

Selecting the ‘Export Report’ option allows the user to create an electronic file of the resulting report with all formatting, grouping and headings.  The user can select the format of the file and the location and filename. 

This allows the file to be saved in PDF for future reference or Excel formats for manipulation of the data

With this option the report is not shown on screen

Currently the export options available are:

  1. PDF
  2. Excel 2003 (.xls)
  3. Excel 2007+ (.xlsx)

The file name and path must also be entered so the file can be exported and saved

Export Report Date

This option allows the raw report data to be exported to a .csv file which can then be used as a data source. In most instances, additional columns of data will be included, and can be useful for custom reporting  or interfacing with a third party application (for example, an Excel pivot table).

Notes:

  1. With this option the report is not shown on screen
  2. If the option is disabled on the report parameters dialog then it is not available for the report  

Report Interpretation

Details displayed will depend on the module the report is run from and setup parameters

Call and Deposit Modules

For each interest posting date up to the End Accrued Date specified transactions that will display include:
  1. Expected interest transaction for the amount of interest that will post to the account based on the Next Interest Date and Interest Posting Frequency
  2. Expected Withholding Tax transaction for the amount of withholding tax to be deducted based on the withholding tax rate associated with the account client
  3. If the Interest Action is Direct Credit, Cheque or Transfer Account, there will be a debit withdrawal transaction for the net interest amount.  The running balance will remain the same after the posting of these transactions
  4. If the Interest Action is Reinvest, the running balance will increase by the net interest

Variable Loan Module

For each interest posting date up to the End Accrued Date specified transactions that will display include:
  1. Expected interest transaction for the amount of interest that will post to the account based on the Next Interest Date and Interest Posting Frequency
  2. If the Interest Action is Reinvest, the account balance will increase by the amount of the expected interest
  3. If the interest action is Transfer Account, the expected interest amount will be credited out and the running balance will remain the same
  4. If the Interest Action is Reinvest, and Instalments are to post, there will be a credit for the instalment amount and the running balance will be reducing.



    • Related Articles

    • Account Transaction Type Details

      Purpose Vault is an integrated system through to the General Ledger. Each Transaction Type affects two General Ledger Codes. The transaction value associated with the Transaction Type will post in summary form to the General Ledger Code specified on ...

    • Account Transaction Type Browse

      Purpose To provide a list of account transaction types that have been established Access Accounts | Edit/View Account Transaction Types [F2] lookup field on any dialog or report where the label is Transaction Type Beside on the Account Transactions ...

    • [Edit] Account Transaction Details

      Purpose Allows the Transaction Reference and/or Description to be changed. All other transaction details are display only fields. Timing A transaction can be edited at any time. Access From within an Account Details dialog | | Highlight the ...

    • [Add] Account Transaction Details

      Purpose This function allows a user to add a transaction to an account Timing A transaction can be added at any time. The selected Value Date may impact on the accounts interest calculation. Access From within an Account Details dialog | | Process ...

    • Print Account Transaction Listing

      Purpose Print a list of account transactions as displayed on the Account dialog. Any search criteria or column sorting applied to the transaction list will be applied to the displayed report. The Report will display the value date, transaction type, ...