# Twilio billing note
## Invoice overview


[invoice download link](https://console.twilio.com/us1/billing/manage-billing/billing-overview?frameUrl=%2Fconsole%2Fbilling%3Fx-target-region%3Dus1)

## Phone Number
### How to get price
1. Check at console [Active Number](https://console.twilio.com/us1/develop/phone-numbers/manage/incoming?frameUrl=%2Fconsole%2Fphone-numbers%2Fincoming%3Fx-target-region%3Dus1)
Note: API for type/locality is still under private development

2. Check price with Country, Type at [Number Prices CSV](https://console.twilio.com/us1/billing/manage-billing/pricing?frameUrl=%2Fconsole%2Fbilling%2Fpricing%3Fx-target-region%3Dus1)

---

### Information gap
Total price doesn't match our invoice because some number's information not recorded in Prices CSV.

Total price from invoice: 244
Calculated price without following numbers: 199

| Number | Country | Type | Service |
| ------------- | ------- | ------ | ----------------- |
| [phone] | MX | Mobile | N/A |
| [phone] | MX | Mobile | Gopro |
| [phone] | FR | Mobile | Tarte France |
| [phone] | MY | Mobile | Tarte Malaysia |
| [phone] | MY | Mobile | Tarte Singapore |
| [phone] | MY | Mobile | Tarte New Zealand |

However, we can get the actual charge of these numbers from invoice


199 + 15x2 + 2 + 5x3 = 246

---

### Match phone numbers to franchises
We have 112 active phone numbers and 32 of them don't have service id and MySQL records:

| Number | friendly name | Recently used in 2022 |
| ------------- | --------------------------------- |:--------------------- |
| [phone] | WhatsApp Dev Testing | No |
| [phone] | Sheplers Local | No |
| [phone] | Linc SMS Forwarder [phone] | No |
| [phone] | [phone] - IVR DemoStore | No |
| [phone] | Voice IVR Staging Testing | No |
| [phone] | Hourglass Angel | No |
| [phone] | Hugo Boss | No |
| [phone] | Better Braces US | No |
| [phone] | Loreal LaRoche Posay Toll Free | No |
| [phone] | P&G Shop | No |
| [phone] | Lime Crime | No |
| [phone] | Gentleman's Gazette | No |
| [phone] | eBags | No |
| [phone] | Reeds | No |
| [phone] | Sheplers Tollfree | No |
| [phone] | Country Outfitter Toll Free | No |
| [phone] | Boot Barn Toll Free | No |
| [phone] | Better Braces CA | No |
| [phone] | Lamps Plus | No |
| [phone] | Planet Blue | No |
| [phone] | Jockey | No |
| [phone] | SMB Phone Number | No |
| [phone] | Vega | No |
| [phone] | GoPro US | No |
| [phone] | Supercell | No |
| [phone] | N/A | No |
| [phone] | N/A | No |
| [phone] | N/A | No |
| [phone] | N/A | Yes |
| [phone] | Voice IVR testing | Yes |
| [phone] | Crazy 8 | Yes |
| [phone] | Pacsun | Yes |

---

## Messages
We can divide the SMS billing to franchises (Through API and service_id/MySQL), but SMS carrier fee can't map to each franchises:

---

## Should ask Twilio
- How to divide SMS carrier fee to each SMS log
- How to get type or monthly charge of each phone number
- Update the Phone Number Prices CSV