Confirming Bailment Interest Calculations (Data Logging)
Purpose
Data Logging
allows the user to prove interest calculations.
Timing
This
process may be run at any time.
Process
Select Start
logging interest calculations from the Data Logging Menu.
In the Save Log
As dialog select a location on your desktop and enter a File name.
The following
dialog will display in the top left corner of the user monitor.
To stop data
logging click on 
To stop data
logging and view the created file click on 
Data logging begins when the user clicks 
on a Bailment Account.
When the user 
a Bailment Account the interest
details will complete being logged for that Bailment Account.
The data log calculates the interest on a
daily basis for the number of days between transactions at the rate applicable
for those days.
Interest is calculated and logged separately
for each interest “stage” that a Bailment Account goes through:
|
Account BD1004:6L1 OUTBOARD MOTOR |
|
|
|
||||
|
Calculating Distributor Interest |
|
|
|
|
|||
|
Start Date |
End Date |
Days |
Balance |
Rate |
Interest |
Interest Profile |
|
|
21/09/2009 |
21/09/2009 |
0 |
0 |
0 |
0 |
D10% |
|
|
21/09/2009 |
30/09/2009 |
9 |
11408.18 |
10 |
28.13 |
D10% |
|
|
30/09/2009 |
30/09/2009 |
0 |
11380.05 |
0 |
0 |
D10% |
|
|
30/09/2009 |
31/10/2009 |
31 |
11408.18 |
10 |
96.89 |
D10% |
|
|
31/10/2009 |
31/10/2009 |
0 |
11311.29 |
0 |
0 |
D10% |
|
|
31/10/2009 |
30/11/2009 |
30 |
11408.18 |
10 |
93.77 |
D10% |
|
|
30/11/2009 |
30/11/2009 |
0 |
11314.41 |
0 |
0 |
D10% |
|
|
30/11/2009 |
20/12/2009 |
20 |
11408.18 |
10 |
62.51 |
D10% |
|
|
20/12/2009 |
20/12/2009 |
0 |
11345.67 |
0 |
0 |
D10% |
|
|
20/12/2009 |
20/12/2009 |
0 |
11408.18 |
0 |
0 |
D10% |
|
|
Calculating Bailment Interest |
|
|
|
|
|||
|
Start Date |
End Date |
Days |
Balance |
Rate |
Interest |
Interest Profile |
|
|
20/12/2009 |
20/12/2009 |
0 |
11408.18 |
0 |
0 |
BD10% |
|
|
20/12/2009 |
20/12/2009 |
0 |
11345.67 |
0 |
0 |
BD10% |
|
|
20/12/2009 |
31/12/2009 |
11 |
11408.18 |
10 |
34.38 |
BD10% |
|
|
31/12/2009 |
31/12/2009 |
0 |
11373.8 |
0 |
0 |
BD10% |
|
|
31/12/2009 |
31/01/2010 |
31 |
11408.18 |
10 |
96.89 |
BD10% |
|
|
31/01/2010 |
31/01/2010 |
0 |
11311.29 |
0 |
0 |
BD10% |
|
|
31/01/2010 |
18/02/2010 |
18 |
11408.18 |
10 |
56.26 |
BD10% |
|
|
Calculating Post Due In Full Bailment Interest |
|||||||
|
Start Date |
End Date |
Days |
Balance |
Rate |
Interest |
Interest Profile |
|
|
18/02/2010 |
8/04/2010 |
49 |
11408.18 |
10 |
153.15 |
BD10% |
|
|
Calculating Default Interest |
|||||||
|
Start Date |
End Date |
Days |
Balance |
Rate |
Interest |
Interest Profile |
|
|
21/09/2009 |
31/01/2010 |
N/A |
N/A |
N/A |
0.58 |
<Accrued Interest> |
|
|
31/01/2010 |
31/01/2010 |
0 |
34.38 |
0 |
0 |
BDD20% |
|
|
31/01/2010 |
31/01/2010 |
0 |
34.96 |
0 |
0 |
BDD20% |
|
|
31/01/2010 |
8/04/2010 |
67 |
131.85 |
20 |
4.84 |
BDD20% |
|
Related Articles
Post Interest on Bailment Accounts
Purpose Charge both Bailment Dealer Interest Due and Default Interest to Bailment Accounts. Also charges Free Floor Plan Interest to Distributor accounts and all Fee Types set up in the Fees Module. Timing This process must be run before the Bailment ...Bailment Dealer Details - Financial Data Tab
Purpose Facilitates the input of Financial Details supplied by a Bailment Dealer. Ratios are then calculated and evaluated to assist in determining the Credit Limits and Status that will be applied to the Bailment Dealer Access Bailment Dealer | ...Write off Bailment Interest
Purpose There may be instances when at month end the amount of accrued interest to be charged on either the future ledger or current ledger are too small to consider collecting. The Write Off Interest routine can be run against either or both ledgers ...Bailment Interest Charging Rules
Concept For each Bailment Dealer that is not closed, the interest posting routine finds all the Bailment Accounts that are not closed. For each account found, the interest posting routine does the following: On the Future Ledger: Calculates the ...Interest Calculation Issues
Concept Most interest calculations in Argos are calculated as ledger balance x interest rate / 365 x number of days since interest was last posted. If an accounts interest amount is vastly different from the expected calculation, the following steps ...