Hey all your Airtable users,
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
7 Nov
14 Nov
21 Nov
28 Nov
5 Dec
12 Dec
19 Dec
26 Dec
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:
31 Oct
7 Nov
14 Nov
21 Nov
28 Nov
5 Dec
12 Dec
19 Dec
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.