Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Bank Cashflow

253 2
cancel
Showing results for 
Search instead for 
Did you mean: 
FundacionFormar
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

2 Replies 2

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

fintable
6 - Interface Innovator
6 - Interface Innovator

Note that Fintable.io is built for this exact purpose, and it automatically syncs your current bank balance and transactions.