I’m trying to use AirTable to do some of my accrual accounting for a small school, we used to do it via Google Sheets in a relatively manual process.
I want to recreate something like this, but using a webhook to receive information from stripe, and automatically filling up the amount received, split into the months according.
The problem lies therein.
The students pay in a lump sum of 8 lessons, and each lesson is, for example every Monday of the month.
The students can join at any point of the month.
So for example:
Student A goes to class on Mondays and joins us on 7 Nov 2022
So on 7 Nov 2022, Student A pays us let’s say $80
This $80 covers the dates
So on the accounting, it should show that Student A paid $40 in Nov and $40 in Dec
But let’s say Student B joins us in 31 Oct, and pays $80. This $80 should cover:
Meaning, Student B’s $80 should be accounted as $10 in Oct, $40 in Nov, and $30 in Dec
How should I work this out keeping in mind that the lessons are on a fixed day of the week.
Thanks for your response, I’m not sure I fully understand how what you mean.
Field 1: Student ID
Field 2: Start Date
Field 3: Formula of start date + 7days(?)
Field 4: Formula of start date + 14days(?)
Field 9: Formula of start date + 56days(?)
But I don’t understand what Fields 10 - 17 would be.