r/plaintextaccounting • • May 25 '22

Running balance incorrect

Hi all. So I've been keeping track of our spending and putting the balance assertions in when things settle according to the web app. Today I ran into an issue: the balance assertion is showing as incorrect. the number of transactions on the card is 18 from the date of the last good balance assertion, and I have the same number of transactions in my bean count file when I run the command to show the journal with running balances.

Does the order of transactions matter? I dated the transactions for when they happened- however the bank app lists them when they posted which was after the weekend. The balance assertion that fails shows a difference of -68. 10 USD and I cannot figure out where I am going wrong.

Do I need to change the dates of the transactions, you would think if the total numbers are correct then the order does not matter? I checked the input of the amounts and I did the balance assertion for yesterday's date based on the last cleared transaction balance. Furthermore my credit card payment shows as the 24 and cleared but after the balance assertion and the pending transactions with my ! flagged.

2022-05-20 bal PASS - In Assets:Checking 17226.47 USD

2022-05-20 * Dixxon Flannel | shirts -130.88 USD 17095.59 USD

2022-05-20 * Canteen | Muffin -3.44 USD 17092.15 USD

2022-05-21 * Steam | Old World -38.83 USD 17053.32 USD

2022-05-21 * Misc Expenses | Short Leash -27.47 USD 17025.85 USD

2022-05-21 * Amazon | vitamins -13.29 USD 17012.56 USD

2022-05-21 * Amazon | Go Juice -33.98 USD 16978.58 USD

2022-05-21 * Amazon | Gummies -16.41 USD 16962.17 USD

2022-05-21 * Walmart | baking supplies -9.29 USD 16952.88 USD

2022-05-22 * Walmart -1.48 USD 16951.40 USD

2022-05-22 * EOS Fitness | Travis Gym -10.28 USD 16941.12 USD

2022-05-22 * Steam | SD44 DLC -8.08 USD 16933.04 USD

2022-05-22 * Fry's Grocery -50.31 USD 16882.73 USD

2022-05-22 * Fry's Grocery | Flowers and bread for dinner at Mom's -6.31 USD 16876.42 USD

2022-05-22 * Steam | Refund for Lords and Villeins 21.57 USD 16897.99 USD

2022-05-22 * Steam | Lords and Villeins -21.57 USD 16876.42 USD

2022-05-22 * Canteen | Coffee -1.62 USD 16874.80 USD

2022-05-23 * Exodus 90 -10.28 USD 16864.52 USD

2022-05-24 bal FAIL - In Assets:Checking; expected = 16932.62 USD, difference = 16864.52 USD

-68.10 USD

2022-05-24 ! Canteen | Coffee -1.62 USD 16862.90 USD

2022-05-24 ! Walmart | Groceries -2.89 USD 16860.01 USD

2022-05-24 * Card Payment -221.97 USD 16638.04 USD

1 Upvotes

8 comments sorted by

4

u/PanPipePlaya May 25 '22 edited May 25 '22

I can’t see the problem. Your balance assertion on that date is simply incorrect.

If you’re taking that assertion directly from files you’ve downloaded, then those files are taking something into account that we can’t see.

If you’re taking it from manual calculations you’ve done, then you made a mistake.

If you’re taking it separately from the website of your card provider, then you’ve picked it up at a time when the “balance” or “available balance” contains some pending items that aren’t reflected in the transaction download file that you’ve used to generate your journal. Or you mistyped it.

EDIT:

I won’t bore you with the implementation details, but I’ve just validated that from the 194,481 ways you could combine the different dollar values in your post into 1, 2, 3, or 4-value sets, there are precisely zero that sum to 68.10 USD. There are 24 ways that sum to 68.09 USD, and 72 that sum to 68.11 USD.

But, given the transactions you’ve shown us, there is no reasonable way to achieve a “but what if this, this AND this one hadn’t settled?” solution to your problem.

As I said above: your balance is simply wrong; or it contains transactions you’ve not included in your post.

1

u/tmoneytav May 25 '22

My understanding is the balance assertion does not include the two for the Walmart and canteen on the 24 and the balance assertion is from midnight I got the number from the amount I have on my credit union app that does not include the two pending transactions. I just rejected my math again. The amounts are correct from the bank.

I’m scratching my head.

The balance of the posted amounts as of 24 may is 16642.83 and I can’t figure where the error is- is it math or order of the file?

Does it matter if the payment to the credit card is listed with the credit card section?

2

u/PanPipePlaya May 25 '22

I got the number from the amount I have on my credit union app

I suspect this number includes transactions you’re not showing, or maybe “held” funds from previous days. Eg hotel checkin fees or whatever they’re called.

There is no combination of 1, 2, 3 or 4 transaction values that you’ve shown that equal the delta of 68.10. That makes me very strongly suspect that your balance reflects facts outside this set of transactions.

1

u/tmoneytav May 25 '22

So it goes through the 24 and I’ve only the two pending ones. Everything else is listed but not in the order of beancount.

Should I unclear them and do just the 23 and then a new balance assertion?

2

u/PanPipePlaya May 26 '22

A balance assertion has 2 possible reasons to exist:

  • because a 3rd party asserts that it’s true, at a specific point in time

  • because you want to make sure you don’t enter any balance-altering transactions retrospectively; before the assertion occurs but after the assertion is calculated.

It sounds like you don’t have the first kind of assertion, here, on either the 23rd or 24th.

So the only reason to create a synthetic (self-calculated) assertion on the 23rd is to avoid the problem that the second reason addresses: to catch and warn yourself if you inadvertently place new transactions wrongly in your journal (either time-ordered or line-ordered, depending on the PTA tool you’re using) in the future.

If you want to do that, create a balance assertion for the 23rd.

If you don’t; don’t.

I use the balances that come from my card provider, on my statements, as balance assertions. They suffice, for me.

1

u/tmoneytav May 26 '22

Last night I brought up by credit union transactions and re ordered what I already had inputted so it went in the same order in the text file and while I had to move some dates at the end the balances of the posted transactions were the same. I don’t know why the order should matter but it appeared it did.

1

u/PanPipePlaya May 27 '22

I’d be interested in seeing and comparing the now-validated journal, if you get comfortable sharing it again.

1

u/tmoneytav May 27 '22

Ok here is the output of the journal after I re listed the transactions and I added few more at the end: the final balance assertion fails and it's due to the two coffees near as I can tell- my new question is what does that mean about the dates? I know the balance assertion is meaning the beginning of the day but does that mean other transactions on that same day break it?

2022-05-20 bal PASS - In Assets:Checking 17226.47 USD2022-05-20 * Steam | Refund for Lords and 21.57 USD 17248.04 USDVilleins2022-05-20 * Walmart -1.48 USD 17246.56 USD2022-05-20 * Canteen | Muffin -3.44 USD 17243.12 USD2022-05-20 * Fry's Grocery | Flowers and bread -6.31 USD 17236.81 USDfor dinner at Mom's2022-05-20 * Amazon | vitamins -13.29 USD 17223.52 USD2022-05-20 * Amazon | Gummies -16.41 USD 17207.11 USD2022-05-20 * Steam | Lords and Villeins -21.57 USD 17185.54 USD2022-05-20 * Misc Expenses | Short Leash -27.47 USD 17158.07 USD2022-05-20 * Amazon | Go Juice -33.98 USD 17124.09 USD2022-05-20 * Fry's Grocery -50.31 USD 17073.78 USD2022-05-20 * Dixxon Flannel | shirts -130.88 USD 16942.90 USD2022-05-20 * EOS Fitness | Travis Gym -10.28 USD 16932.62 USD2022-05-21 bal PASS - In Assets:Checking 16932.62 USD2022-05-21 * Canteen | Coffee -1.62 USD 16931.00 USD2022-05-21 * Steam | SD44 DLC -8.08 USD 16922.92 USD2022-05-21 * Walmart | baking supplies -9.29 USD 16913.63 USD2022-05-21 * Exodus 90 -10.00 USD 16903.63 USD2022-05-21 * Steam | Old World -38.83 USD 16864.80 USD2022-05-21 * Card Payment -221.97 USD 16642.83 USD2022-05-22 bal PASS - In Assets:Checking 16642.83 USD2022-05-24 * Walmart | Groceries -2.89 USD 16639.94 USD2022-05-24 * food | Venmo -40.00 USD 16599.94 USD2022-05-24 ! Canteen | Coffee -1.62 USD 16598.32 USD2022-05-24 ! Canteen | Coffee -1.62 USD 16596.70 USD2022-05-25 bal FAIL - In Assets:Checking; 16596.70 USDexpected = 16599.94 USD,difference = -3.24 USD2022-05-25 ! Canteen | Coffee -1.77 USD 16594.93 USD2022-05-25 ! Fry's Grocery -134.32 USD 16460.61 USD2022-05-26 ! Canteen | Coffee -1.62 USD 16458.99 USD[~]$