What can we do for you?
How do I calculate the costs of service accounts that have not yet been billed?
For this you will need to read the meters of the service to be paid, for example electricity.
First, you should check the meter of this service and take note of current consumption; then you should check the last paid service account and see the consumption indicator, then make a subtraction between both values ??resulting in the consumption pending invoicing.
Example: Last account consumption (bill/ticket): 145 kw/h, current consumption (meter): 180 kw/h.
Subtract: 180 - 145 = 35 kw/h, this was what was consumed in this last period.
Then you will have to calculate the value of kw/h, where you will take the amount paid in the last service account and divide it by consumption, that is, for example, amount paid: $ 12,760; it will be then, 12,760/145 = $ 88 the value of the kw/h.
Finally, you just have to multiply the consumption of the unbilled period by the value of the kWh and you will get the approximate value of the amount to be paid by the tenant, that is, $ 88 x 35 = $ 3,080. therefore, the value to be paid by the tenant will be $ 3,080.