Online calculation of the interest payment as banks do, help


Field Remark
Savings deposits / withdrawals (Max. 1000) Enter on each line a value date followed by a delimiter and than a savings deposit / withdrawal.

Max 1000 rows allowed.
The rows are automatically sorted by date.

If a line begins with a # symbol, then the entire line is considered a comment.
  • The value date is the date on which a withdrawn amount ceases to earn interest or a deposited amount start to earn interest.

    The value date is not the same as the posting date.
    The posting date is the date on which deposits on the account is credited and withdrawals debited from the account.

    Allowed value date formats:
    • dd-mm-yyyy (24-11-2013) or dd/mm/yyyy (24/11/2013)
    • mm-dd-yyyy (11-24-2013) or mm/dd/yyyy (11/24/2013)

    If the day or month has only 1 digit, then you do not need to prefix the number with a 0.

    Allowed: 24-01-2013 or 24-1-2013
    Allowed: 1-12-2013 or 01-12-2013

    The date of the first savings deposit / withdrawal should start earlier than the final date.

  • A delimiter. Allowed delimiters:
    • ;
    • [tab]
    • |
    • ~
    • =
    • ^
    • _

  • A savings deposit / withdrawal
    • Max 2 digits after decimal point (17.05)
    • A comma (,) or point (.) may be used as decimal point
      (1125,01 or 1125.01)
    • If it is a savings deposit, do not prefix the amount with the + sign (+235.12)
    • If it is a savings withdrawal, prefix the amount with the - sign (-2342.25)
    • Do not use a currency symbol ($2342.25)
    • On 1 day several savings deposits / withdrawals can take place.
      Put each on a separate line, eg:
      24-01-2013;100.24
      24-01-2013;200.25
      24-01-2013;-10.00
Correct examples:
  • #24-03-2013; 10000
  • 24-03-2013; 10000
  • 24/03/2013; 10000
  • 24-3-2013; 10000
  • 1-3-2013; 10000
  • 03-24-2013; 10000
  • 03/24/2013; 10000
  • 28-03-2013; -500
  • 28-03-2013; 500.56
  • 28-03-2013; 500,56
Incorrect examples:
  • 2013-03-23; 10000 -> Date has incorrect format (yyyy-mm-dd)
  • 35-03-2013; 10000 -> Date does not exists
  • 24-03-2013; 10,000.56 -> No thousand separator allowed
  • 24-03-2013; 10000,561 -> Max 2 digits after decimal point
  • 24-03-2013; +500 -> No + sign allowed
  • 24-03-2013; $500 -> No currecy symbol allowed