# Double entry system accounting

**URL:** <https://community.glideapps.com/t/double-entry-system-accounting/73291>\
**Category:** Ask for Help\
**Created:** [May 12, 2024, 2:28pm UTC](https://community.glideapps.com/t/double-entry-system-accounting/73291 "2024-05-12T14:28:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dhruv\_Agarwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dhruv_agarwal/32/72108_2.png) [@Dhruv\_Agarwal](https://community.glideapps.com/u/Dhruv_Agarwal)\
**Post date:** [May 12, 2024, 2:28pm UTC](https://community.glideapps.com/t/double-entry-system-accounting/73291/1 "2024-05-12T14:28:49Z")

</div>

Dear Gliders,

I am new to glide and automatic my business needed. I am creating a app to manage cash in cash at different business locations. I want to create this system according to double entry system of accounts. If we debit one account the other one is automatically credit. I want to relate it like if we edit one account, the other one is automatically edited.

I was able to create it using 2 tables and use add row custom action but this is not auto updating when modifying. Also, we would need to create as many table as there are accounts. 1 table of each account which is not practical.

Also we need to make a account wise statement showing debit and credit entry and finally balance column showing remaining net balance.  
I want to make it like this so that in future i can connect my orders and sales app to get balance pending from each customer and send them payment reminders. That all is a story of another development that I will work in future.

Current requirement is to find a solution to this accounting app.

---

<div class="post-metadata">

**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:** [May 12, 2024, 4:25pm UTC](https://community.glideapps.com/t/double-entry-system-accounting/73291/2 "2024-05-12T16:25:46Z")

</div>

I think you could have one transaction log table with a column for each party. A Sender ID and a Receiver ID. Then use Relation columns to link the user table to the transaction log table and Rollup columns to get the amount sent or received.