Issue 11846

support rounding the end balance
Nosy list
ced, pocock
Assigned to

Created on 2022-10-31.22:14:21 by pocock, last changed 1 month ago by ced.


Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-11-01.11:56:09

I will not discuss design until we have the official rules.

Author: [hidden] (pocock)
Date: 2022-11-01.11:51:54

This could be broken down into multiple components

For example, for the currencies, Tryton could record the characteristics of each type of cash (coin/note, value)

The size of the smallest coin or note would then be used by any other module that may need to do rounding. E.g. in CHF, an electronic payment can be any multiple of 0.01 but cash payments must be multiples of 0.05.

In the account_statement module there is a configuration screen for each statement journal. Some extra attributes could be placed there so the administrator can define which boxes appear on the statement matching tab. For example, a checkbox to permit rounding to the local cash. The default value would be off.

Finally, it depends on the file format. The banks mentioned here are giving statements in MT940 and CAMT formats for the regular bank accounts but for the credit cards, they only give CSV files and paper/PDF statements. The values used in the rounding need to be manually copied from the paper/PDF statements. I already extract those values with a script.

Looking at the current MT940, CAMT and OFX specs, none of these would permit a rounded end balance unless the journal entry for rounding is in the file too. Therefore, if my script converts CSV to OFX files, it needs to add a rounding transaction to the file before the Tryton import.

There is ongoing effort to make CAMT work for everything like credit cards too. Maybe they will add extra fields for this problem or they will stop doing the rounding. Or they will give us invalid CAMT files.

Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-11-01.11:17:09

It is not possible to include a design in Tryton only by example. We need formal official rules.

Author: [hidden] (pocock)
Date: 2022-11-01.09:34:34

On the first example I looked at, they are rounding the balance down, removing 0.02 for example

People can take the credit card statement to any post office and pay it with cash. That is probably why they have a rounded balance.

One of the banks has a subsidiary called "Card Center" in Glattbrug. They do outsourced card processing services for multiple banks including their parent company and the Postfinance from the same center. Therefore, people using any of those banks may have the same issue.

I've seen card statements from both the parent company and Postfinance and both of them do this. These are two of the most common cards here.

Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-11-01.09:13:18

Under which law can they round amount? In EU only cash payment can be rounded this way and obviously bank statements are not cash.

Author: [hidden] (pocock)
Date: 2022-11-01.08:48:19

We are not going to adapt the statement for one bad bank.

bad? I never mentioned the name of the bank

Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-11-01.08:21:25

We are not going to adapt the statement for one bad bank.

Author: [hidden] (pocock)
Date: 2022-11-01.08:19:13

I agree this is ugly

But the bank created the statements like this.

Looking at the statement more closely, I see that they print some other values:

  • sum of all payments to the card account (e.g. 1000)

  • sum of all purchases (not rounded) (e.g. 499.95)

  • end balance (rounded) (e.g. 499.90)

If the user is forced to enter all these values into the statement window then Tryton can calculate that there is rounding of 0.05 and the balance check can be exact.

Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-11-01.08:12:42

I disagree with such feature because it will kill the balance check of the statement.

Author: [hidden] (pocock)
Date: 2022-10-31.22:14:21

Bank statements for credit cards and prepaid cards are sometimes rounding the final balance. In one case, I saw the value rounded to a multiple of 0.10

This requires a journal entry / account move for the rounding amount. There is no line in the statement itself for the rounded amount.

It would be useful to be able to flag the accounts that permit this type of rounding.

For those accounts, if the flag is set to permit rounding, when the start and finish balance is entered, if the transactions sum to a value that is very close to the end balance then it would be useful to have a box to type in the rounded amount and automatically create the account move.

Date User Action Args
2022-11-01 11:56:09cedsetmessages: + msg79879
2022-11-01 11:51:54pococksetmessages: + msg79878
2022-11-01 11:17:09cedsetmessages: + msg79876
2022-11-01 09:34:34pococksetmessages: + msg79874
2022-11-01 09:13:18cedsetmessages: + msg79873
status: invalid -> need-eg
2022-11-01 08:48:19pococksetmessages: + msg79872
2022-11-01 08:21:25cedsetmessages: + msg79870
2022-11-01 08:19:13pococksetmessages: + msg79868
2022-11-01 08:12:42cedsetmessages: + msg79866
nosy: + ced
status: unread -> invalid
2022-10-31 22:14:21pocockcreate

Showing 10 items. Show all history (warning: this could be VERY long)