Difference in getbalance and sum(listtransactions) amounts (testnet) #7054

I have bunch of wallets which i import in fresh and empty bitcoind via importwallet. After this i issue getbalance, which shows me 0.00000000, but if i perform listtransactions and sum all amounts and fees(single fee per tx) i've got 0.00004137. Why?

Bitcoin Core Daemon version v0.11.1.0-gcf33f19

check_tx.py.txt listtransactions.json.txt unspent.json.txt

I shortly checked your receiving addresses over an testnet API, seems to be 0 balance. Could be a mistake in your script (fees correctly handled?!) or a missing transaction in your listtransaction.txt

I've checked again, listtransactions.txt is fine. Script also should be ok, but i'll be glad if someone more experienced check it.

Some transactions have negative "fee", that's weird.

I'm think it happens because this addresses are part of larger wallet, and positive fees are "change", am i right?

No, change is already considered in the "amount" value. @asfin I guess you forgot to import some keys of some of the transactions. (Maybe coinjoin?) Could you try again and assert that you have all addresses in you wallet?

Fee is computed as (sum of outputs)-(sum of inputs that are ours)... that is meaningless if not all inputs are ours.

@sipa Yes, and it's in there since at least 2011™

@MarcoFalke OK, I'll try to import complete wallet and attach result. But i've found this problem on it, and after this tried to split wallet on small parts, to isolate error. It seems to be weird, if after importing privkey my balance doesn't match transaction history.

@asfin Yes, if you don't import all private key related to all transactions, you will get a difference when summing up the values reported by listtransactions in current versions of bitcoin.

Replaced wallet.dat with backup of original, and performed reindex. Script reports:

unspent     :   12.33503283
total income:   12.34391710
total fee   :   -0.00884290
diff        :   12.33507420

but in attached version of script, diff doesn't include unspent balance so diff-unspent=error; 12.33507420-12.33503283=0.00004137. How correctly find tx, which broke this?

listtransactions.json.txt unspent.json.txt

How correctly find tx, which broke this?

Should be at least all those with negative fee

But here all fees < 0.

Yes, listtransactions always should return a negative fee. (Internally they are handled positive: nFee in https://github.com/bitcoin/bitcoin/blob/776848acefa8345c7e510d31406160c4a1a24bca/src/wallet/wallet.cpp#L969)

Not clear this is an issue

I am facing same issue after importwallet. It show wallet got 302 txs, but listtransactions only return 285 txs

bitcoin-cli -version

Bitcoin Core RPC client version v0.16.3

bitcoin-cli listtransactions "*" 999999 | grep txid | wc

285 570 22800

bitcoin-cli getwalletinfo

{ "walletname": "wallet.dat", "walletversion": 159900, "balance": 0.02000434, "unconfirmed_balance": 0.00000000, "immature_balance": 0.00000000, "txcount": 302, ... }

bitcoin-cli getbalance

0.02000434

bitcoin-cli listunspent | grep amount

"amount": 0.01000216, "amount": 0.01000218,

I get it. It is not importwallet problem. The real issue is listtransactions does not return amount=0 transactions, for example sendtoaddress to a internal addresses within the wallet , even the transaction fee is non zero.