Usage Based Billing

[otel]

Hello

 

I have an Internet Bandwidth service at a provider. There is no fixed fee for this service as dependent on usage, i get billed accordingly (pay as you go). there is no fixed rate per month per gb as its volume based.

I share this bandwidth with multiple clients and bill them as per use.

 

Therefore i have created a product/service, and have signed up 8 clients to the service.

 

I need a facility to:

1- manually enter my suppliers charge to me for the month (including my profit)

2- manually enter my clients usage of the bandwidth (supplier sends to me which client used what derived from IP monitoring)

3- the module must compute the charges ( my selling price of bandwidth divided by the usage of/from clients) and send the figure to Billable Items so it can be invoices on next cron.

 

===============================================

EG: Supplier charges me $100 for 10gb. I sell for $120. Thats $12 per GB

I have 10 clients, each using 1GB, so: 10 clients x $12 for the 1gb usage = Each client gets billed $12 for the month.

I used simple numbers above, but each clients usage is different , and supplier charge to me varies monthly (based on volume).

 

Any module which are available which I can mold to use as the facility above?

 

Currently, I'm computing it via an excel spreadsheet :-(

 

Am willing to pay for a module program...