# To show current balance after Partial payment **URL:** \ **Category:** Ask for Help\ **Created:** [March 18, 2025, 9:40pm UTC](https://community.glideapps.com/t/to-show-current-balance-after-partial-payment/80828 "2025-03-18T21:40:31Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Mehmet\_Karaca](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mehmet_karaca/32/84984_2.png) [@Mehmet\_Karaca](https://community.glideapps.com/u/Mehmet_Karaca)\ **Post date:** [March 18, 2025, 9:40pm UTC](https://community.glideapps.com/t/to-show-current-balance-after-partial-payment/80828/1 "2025-03-18T21:40:31Z")
**Hello Glide Community,** I’m new to Glide, and this is my first post—hoping someone can assist me! In my app, I’m facing an issue with the **Current Balance** column when handling partial payments. I have a **Due Balance** of **$1,000** and a **Payment Made** column. When I receive a **partial payment** of **$400** , the balance correctly updates to **$600**. However, if I receive another **$200** , instead of subtracting it from the remaining balance ( **$600** ), it deducts it from the original due balance ( **$1,000** ), leaving me with an incorrect balance of **$800** instead of **$400**. How can I ensure that each payment is subtracted from the updated remaining balance rather than the original due amount? ![glide help](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/ee4295cf9014873dd68521295b1f552286efa22d.png) ![glide help2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5ca927a7b8e24b17d83ad51a34fa2bb9edadcf4a.png) ---
**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:** [March 18, 2025, 11:22pm UTC](https://community.glideapps.com/t/to-show-current-balance-after-partial-payment/80828/2 "2025-03-18T23:22:54Z")
It looks like you are recording payments in the same table? I would not do that, I would record them in a separate table, with one payment per row, and include a column that relates to the original sales order. Then you can easily calculate an outstanding balance at any time by doing a rollup-\>sum of related payments, and subtracting that from the original purchase price. ---
**Author:** ![Mehmet\_Karaca](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mehmet_karaca/32/84984_2.png) [@Mehmet\_Karaca](https://community.glideapps.com/u/Mehmet_Karaca)\ **Post date:** [March 19, 2025, 6:34am UTC](https://community.glideapps.com/t/to-show-current-balance-after-partial-payment/80828/3 "2025-03-19T06:34:15Z")
Thank you for your kind response! That’s correct—I’m trying to save the payment data in the same table. Previously, I had a separate **Payments** table, but I struggled to link the **Sales Order ID** to it whenever a new entry was created in the **Sales Order** table. However, I believe I’ve now managed to solve this using workflows. When a new sales order is created, I add its **Row ID** to the **Payments** table through a workflow, allowing me to retrieve all related data via relationships. I appreciate your help—thanks again! ---
**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:** [March 26, 2025, 6:34am UTC](https://community.glideapps.com/t/to-show-current-balance-after-partial-payment/80828/4 "2025-03-26T06:34:52Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.