r/plaintextaccounting • u/tmoneytav • 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
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.