# Simple balance sheet not working **URL:** \ **Category:** Ask for Help\ **Created:** [August 24, 2021, 12:46pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878 "2021-08-24T12:46:24Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Unity\_Play](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/unity_play/32/30887_2.png) [@Unity\_Play](https://community.glideapps.com/u/Unity_Play)\ **Post date:** [August 24, 2021, 12:46pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/1 "2021-08-24T12:46:25Z")
Good morning I am trying to make a simple balance sheet. The columns are: debit . credit . balance . balance . They are not working because in the balance column it does not keep the amount that happens to come from the debit and credit. It would be very helpful and thank you in advance if you could please tell me or guide me how to do it. Thanks again. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 24, 2021, 12:54pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/2 "2021-08-24T12:54:40Z")
Is the first balance column your previous rows final balance? How are you calculating the balance? ---
**Author:** ![Unity\_Play](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/unity_play/32/30887_2.png) [@Unity\_Play](https://community.glideapps.com/u/Unity_Play)\ **Post date:** [August 24, 2021, 12:59pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/3 "2021-08-24T12:59:43Z")
thank you for your interest and help. Here is a screenshot [index.7|690x469](https://community.glideapps.com/uploads/short-url/7G8ZmioOGlQleZAgJ4SE9RiCHeF.jpeg) ---
**Author:** ![Unity\_Play](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/unity_play/32/30887_2.png) [@Unity\_Play](https://community.glideapps.com/u/Unity_Play)\ **Post date:** [August 24, 2021, 1:11pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/4 "2021-08-24T13:11:30Z")
to calculate the balance I use the credit column when amounts come in and I use the debit column when amounts go out. This is not reflected in the balance column, as the correct balance does not remain. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 24, 2021, 1:23pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/5 "2021-08-24T13:23:17Z")
Can you explain what you mean when you say it’s not keeping the balance amount? I see an amount in your screenshot which matches the math that you set up to calculate the balance. It’s calculating that balance in real time for that row only. What do you expect to happen? ---
**Author:** ![Unity\_Play](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/unity_play/32/30887_2.png) [@Unity\_Play](https://community.glideapps.com/u/Unity_Play)\ **Post date:** [August 24, 2021, 1:45pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/6 "2021-08-24T13:45:11Z")
I am uploading a short video to youtube, in a while I will send you the link so you can see it. ---
**Author:** ![Unity\_Play](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/unity_play/32/30887_2.png) [@Unity\_Play](https://community.glideapps.com/u/Unity_Play)\ **Post date:** [August 24, 2021, 1:59pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/7 "2021-08-24T13:59:19Z")
[![]( " - YouTube") ](https://www.youtube.com/watch?v=XQqgfTTQCng) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 24, 2021, 3:21pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/8 "2021-08-24T15:21:54Z")
It’s working how your have it set up. Subtracting debits from credits gives you the difference between those two numbers as that’s how you have the math set up. A-B=C I guess I’m not clear on what you are expecting to happen? You entered credits of 100, 200, and 300, but that doesn’t equal 600. It equals 300, because you overwrote it and that’s the last value you put in that cell. Math columns are constantly calculating in real time based on the inputs you give it. So what I’m trying to understand is what you are expecting. Based on your video it’s working correctly based on how you have it set up. If you are expecting something different, then you’ll have to explain what it is that you are expecting to happen. Are you planning to keep a log of all transactions, or is it just going to just be one row? If it’s bonky one row, then you should have another balance column that’s a number column and add it’s value in with you math column. Once you enter your credits and debits, you’ll need a button to write that calculated balance to the number column balance. Then it’ll be ready for the next entry. ---
**Author:** ![Unity\_Play](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/unity_play/32/30887_2.png) [@Unity\_Play](https://community.glideapps.com/u/Unity_Play)\ **Post date:** [August 24, 2021, 4:02pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/9 "2021-08-24T16:02:23Z")
Well, what I’m waiting for is for the balance sheet to show the amount that is the balance sheet to show the amount that is left over as a function of the the values that are added in the credit or subtracted in the debit. For example: If I have 100 in the balance when I add 100 in credit the balance should be 200 If I have 200 in the balance sheet when I subtract 50 from the debit the balance should be 150 If the balance is 150 when I add 100 of credit the balance should be 250 This is not happening Note: Yes, it is as you say, I need to keep the records in a single row. in a single row. From what you indicate, it seems to be possible Thanks again ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 24, 2021, 4:46pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/10 "2021-08-24T16:46:18Z")
That’s what I thought you mean, but that’s not how it works. If you had 100 credit and you added 200, then you would have to type in 300. The math column doesn’t know what you intended. All it knows is that it has a current credit value - the current debit value. Like I said, you’ll have to have a second balance column to store the balance, then make that stored balance part of your math Balance+Credit-Debit. A button action can then save that result into the second balance column. ---
**Author:** ![Unity\_Play](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/unity_play/32/30887_2.png) [@Unity\_Play](https://community.glideapps.com/u/Unity_Play)\ **Post date:** [August 24, 2021, 4:50pm UTC](https://community.glideapps.com/t/simple-balance-sheet-not-working/30878/11 "2021-08-24T16:50:20Z")
Ok, I’ll get to work on your suggestion. As soon as I do, I’ll let you know how it turns out or if I have any doubts, I’ll get back to you. Thank you very much!