I currently manage a budget on Airtable.
I have a list of all of my live expenses (In a table called live expenses) which I upload daily. E.g. supplies expense which the matching GL code.
I have another table called actual which I compare to the budget.
I’d like to have all transaction from the live table added in to this table.
For example all of the Sales income be added up and added into the actual Sales income line.
Any insights would be highly appreciated.