I’m new around here, but I’m trying to set up a base that automatically breakdowns revenue, profit, owner’s page, expenses, etc using the Profit First methodology by Mike Michalowicz.
I feel like I’ve done pretty well so far. Here’s a look at the most important table that I’m trying to create.
And now I want to automate it more. So, here’s a link to the whole base so you can see how it’s set up (so far):
I’ve set up a Zapier connection so that Stripe automatically updates payments in the first table, labelled “Client Payments.”
Then the next table (“Monthly Revenue Totals”) calculates the total revenue for each month, based on what Stripe has recorded in the first table.
The last table (“Profit First calculations”) takes the total revenue for each month & applies the Profit First formulas to it, so that I can easily see how much I’ve got to, say, take as my own wage from the business bank accounts.
But there’s still too much manual work involved for my liking. That’s where I’m stuck & would love your advice…
Stripe records the date of the transaction. But to get AirTable to calculate the total earned for the month, I have to manually tag the correct month in another column. I’m wondering if there’s a formula or something to do that automatically.
Something like: if the date is 18 September 2017, select “Sep” in the next column.
If there’s a better / smarter way to achieve that, I’m all ears
P.S. If you want to know more about the Profit First methodology, it’s all outlined in this book: