Hello developer manager, can we change Cr in Balance Repoort to mines or ()
Hello @edwar_pangestu,
Why would you want to get rid of the Dr and Cr signs?
I say this because I think a simple minus sign would be a bit ambiguous in an accounting report so I’m curious about the reason behind this request–if I may ask
There is a more fundamental problem with your suggestion, @edwar_pangestu. The screenshot you show is a list of transactions contributing to a balance sheet figure, which in accounting records must be either debits or credits. By long-standing convention, negative signs are not used on balance sheets except when the total for an individual account is contrary to its normal sign. A loan liability, for example, is shown as a positive number, even though it has a credit balance and is represented in the database as a negative number. This is to reduce overall clutter on the financial statement. The only time that loan liability would have a negative sign is if you overpaid it. At that point, its balance would actually be in debit and, therefore, a positive number. But it would show on the balance sheet as a negative number because it is contrary to the ordinary sign of such an account balance.
The reverse is true of debit accounts, like bank accounts. There, a negative account balance would mean the bank had overpaid you by allowing you to withdraw more than you had deposited. And a transaction drill-down on that account would show more credits than debits. Yet on the balance sheet, your bank account balance would show as a negative number, the opposite of what happens with a liability account, which is a so-called credit account.
My message is that the context of an account controls whether it is displayed as a positive or negative number, not only whether the balance has a surplus of debits or credits. Therefore, to be unambiguous, it is necessary to show balance sheet transactions as credits and debits, not pluses and minuses.
the reason is we want to process it again in excel
You can use the Amount
column or the Debit
and Credit
columns in your case. Those will not have accounting signs.