Sep 19, 2024 10:23 AM
Hi, community! I need some help with this. I'm setting up a bank reconciliation in Airtable and need a column to record all the transactions from my bank account. Additionally, I'd like another column that shows the running balance for each transaction, reflecting the total income and expenses up to that point. I'm not looking for a single overall balance, but rather a balance that updates with each individual transaction.
Sep 19, 2024 07:51 PM
re: I'm setting up a bank reconciliation in Airtable and need a column to record all the transactions from my bank account
What issues are you facing with setting this up?
---
re: Additionally, I'd like another column that shows the running balance for each transaction, reflecting the total income and expenses up to that point. I'm not looking for a single overall balance, but rather a balance that updates with each individual transaction.
Hmm I'd try:
1. Create a new table called "Summary" and link it to the table that contains all the transactions
2. Create a single record in "Summary" called "Helper" or something
3. In "Summary" create a rollup field to sum up the total of all the transactions
4. Create an automation that'll trigger when a new Transaction record gets created and its actions will be:
a. Update record - Link itself to the "Helper" record
b. Find record - Find the "Helper" record to get the updated balance data after the new Transaction was linked
c. Update record - Update itself with the new balance
The main problem with this setup is that if you create a bunch of transactions at once it'll probably give you the wrong numbers as the automations are all running in parallel. To get around that you could try to do this on Make.com instead and make the scenario run stuff sequentially
Sep 20, 2024 02:24 AM
Note that Fintable.io is built for this exact purpose, and it automatically syncs your current bank balance and transactions.