[Solved] Different values running `listtransactions` and `getbalance`

[dbt]

Hi all,

Running `listtransactions "*" 99999` and adding up all the `amount` and `fee`(fee only for send category) fields
I have a different value that running `getbalance "*"` in my testnet and mainnet nodes.

I don't have pending confirmation transactions.

Has anyone ever experienced this?

[HCP]

Do you have any "incomplete" (for instance conflicted or abandoned) transactions in your transaction list? These look like "greyed out" transactions with an "X" next to it and the amount in []'s like this:


If so, that is likely to be your problem... those transactions still display in the listtransactions output but are not included when running getbalance


You can probably filter it out by knowing this:

"confirmations": n,       (numeric) The number of confirmations for the transaction. Available for 'send' and
                                         'receive' category of transactions. Negative confirmations indicate the
                                         transaction conflicts with the block chain

So, any of the transactions output by listtransactions that has a negative value for "confirmations" should be ignored and the "amount" and/or "fee" record should not be included in your totals.

[dbt]

Do you have any "incomplete" (for instance conflicted or abandoned) transactions in your transaction list? These look like "greyed out" transactions with an "X" next to it and the amount in []'s like this:
https://i.imgur.com/1QssvAe.png

If so, that is likely to be your problem... those transactions still display in the listtransactions output but are not included when running getbalance


You can probably filter it out by knowing this:

"confirmations": n,       (numeric) The number of confirmations for the transaction. Available for 'send' and
                                         'receive' category of transactions. Negative confirmations indicate the
                                         transaction conflicts with the block chain

So, any of the transactions output by listtransactions that has a negative value for "confirmations" should be ignored and the "amount" and/or "fee" record should not be included in your totals.

Thanks for the response,

In my list of transactions, for all them:

walletconflicts = []
abandoned = false (for the biggest part of them I don't have this field)
confirmations > 0

I don't have access to a GUI client to use that, but I believe that these fields must means the same thing.

[HCP]

It also appears that any "Pay To Many" transactions you may have sent, will also show up as separate records in listtransactions... so the "fee" will be shown twice and could throw off your calculations if you're not careful.

I just spent 5 minutes trying to figure out why my total was off by around 7000 sats

[dbt]

It also appears that any "Pay To Many" transactions you may have sent, will also show up as separate records in listtransactions... so the "fee" will be shown twice and could throw off your calculations if you're not careful.

I just spent 5 minutes trying to figure out why my total was off by around 7000 sats

Yep, that is the solution, thank you for your time!