Bailment Account Status Report

Bailment Account Status Report

Purpose

Provides an overview of the position of the Bailment ledger at a set point in time. Accrued Interest and Cash Suspense amounts can be included.

Timing

Must be run during the Month End process for reconciliation to the General Ledger

May be run at any other time

May not be printed as at a date prior to today’s date

Access

  1. Bailment | Reports | Bailment | Print Account Status Report

Report

Report Specific Parameters

Field
Explanation
Free Floor Plan Date
Identifies Bailment Accounts where the Free Floor Plan period will end within the date range specified
Due in Full Date
Identifies Bailment Accounts where the Due in full date will occur within the date range specified 
Open Date
Identifies Bailment Accounts where the open date will occur within the date range specified
Termination Date
Identifies Bailment Accounts where the Termination date will occur within the date range specified
Show Accrued Interest
Check this on if accrued interest should be included in the report output
Show ESR
Export Report Data option only

Check this on if ESR accruals should be included
Calculate Accruals/ESR to
Specify the date that the accruals should be calculated for

Note: The accrual calculation is based on the balance at the time the report is run
Credit Balances (Current)
Check this flag on to report only clients with credit current ledger balances
Debit Balances (Current)
Check this flag on to report only clients with debit current ledger balances
Credit Balances (Future)
Check this flag on to report only clients with credit future ledger balances
Debit Balances (Future)
Check this flag on to report only clients with debit future ledger balances
Future Zero
Check this flag on to report only clients with future ledger balances of zero

Can be used in conjunction with the current balance flags
Include Cash Suspense
Check this flag if the Bailment Dealers cash suspense account should be included in the Account status report



    • Related Articles

    • Bailment Credit Status Report

      Purpose This report prints the credit status of Bailment Dealers, by Credit Risk if required Timing This report may be run at any time Access Bailment | Reports | Bailment | Credit Status Report Report Report Order Options Columns Reported Field ...
    • Distributor Account Status Report

      Purpose Provides details of the Distributor account current and future ledger balances Accrued Interest may also be included Timing Account Status Reports may be run at any time Mandatory reporting for Month End processing Access Bailment | Reports | ...
    • Bailment Credit Facility Report

      Purpose Provide details of credit limits by Bailment Dealer Included are the limit types, amount of the limit, utilised credit, utilised credit percentage and the credit status for each bailment dealer Timing This report may be run at any time Access ...
    • Account Status Report

      Purpose Provides details of the account current and future ledger balances Accrued Interest may also be included Timing Account Status Reports can be run at any time Mandatory reporting for Month End Processing Access Accounts | Print Account Status ...
    • Variable Loan Account Status Report

      Purpose This report provides a snapshot of the Variable Loans Accounts within the selected parameters. It can be run in detail to provide an account by account overview or in summary It includes details such as: Account Balance Current (Arrears and ...