# Data: Balancing Daily Expenses with Previous Day's Balance

**URL:** <https://community.glideapps.com/t/data-balancing-daily-expenses-with-previous-days-balance/72651>\
**Category:** Ask for Help\
**Created:** [April 17, 2024, 12:49pm UTC](https://community.glideapps.com/t/data-balancing-daily-expenses-with-previous-days-balance/72651 "2024-04-17T12:49:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raimundo\_Ladron\_de\_G](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raimundo_ladron_de_g/32/73733_2.png) [@Raimundo\_Ladron\_de\_G](https://community.glideapps.com/u/Raimundo_Ladron_de_G)\
**Post date:** [April 17, 2024, 12:49pm UTC](https://community.glideapps.com/t/data-balancing-daily-expenses-with-previous-days-balance/72651/1 "2024-04-17T12:49:07Z")

</div>

I’m building an expense tracking app that shows the user its daily cashflow or balance.

 ![Balance Diario](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d5ccc357b2d1bb243df061dfdad5e6f0271cd98c.jpeg)

The picture above shows the first version of the app which I made by connecting the app to formulas in a Google Sheet using the Legacy Free Plan.

Now I want to build that same app but in the current Free Plan. Therefore I can only use Glide tables - no connection to Google Sheets or Excel.

**My challenge**

I haven’t found a way for each day’s balance to come from the previous day’s balance.

Think of it like a waterfall: The balance on March 15th is equal to the previous day’s balance minus the expenses I made on that same day, March 15th.

Does anyone know how I could solve this?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 17, 2024, 12:54pm UTC](https://community.glideapps.com/t/data-balancing-daily-expenses-with-previous-days-balance/72651/2 "2024-04-17T12:54:30Z")

</div>

You can leverage the Query column. The below video should give you the general idea.

https://www.loom.com/embed/042be3be13004355b0dedec1be67b400

* * *
_If the above video won't play, paste the below URL into a browser:_

```auto
https://www.loom.com/share/042be3be13004355b0dedec1be67b400

```

---

<div class="post-metadata">

**Author:** ![Raimundo\_Ladron\_de\_G](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raimundo_ladron_de_g/32/73733_2.png) [@Raimundo\_Ladron\_de\_G](https://community.glideapps.com/u/Raimundo_Ladron_de_G)\
**Post date:** [April 17, 2024, 1:21pm UTC](https://community.glideapps.com/t/data-balancing-daily-expenses-with-previous-days-balance/72651/3 "2024-04-17T13:21:27Z")

</div>

You crazy MF!!!

You did it!

That was exactly what I needed. Thank you so much Darren!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 24, 2024, 1:22pm UTC](https://community.glideapps.com/t/data-balancing-daily-expenses-with-previous-days-balance/72651/4 "2024-04-24T13:22:07Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.