Help

Creating a billing schedule

1049 1
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Townsend
4 - Data Explorer
4 - Data Explorer

Hi,

I’m trying to think of the best way to replicate our billing schedule payment profiles where we have % of an annual fee to invoice each month. The below show how we capture this in excel:

image

At this stage, I’m just looking for ideas on how to structure this.

However, ultimately it would be nice to link opportunities to a payment profile and have each payment date shown in a calendar view.

Thanks!

1 Reply 1
Nathaniel_Grano
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi @John_Townsend ,
Unless I’m missing something, it seems like this would translate pretty directly into a table in an Airtable base where you %-type have columns representing months and each row represents a payment profile, just as you’ve shown here. In this case, you wouldn’t have FALSE in months with no payments, but rather just leave them empty or 0%.

If you later have an Opportunities table, each Opportunities record could link to a Payment profile and then you could start doing interesting things with lookup columns and formula fields to model things like amounts due each month or the next payment date.