Alex, Lucas, Julia, and I have a “family” plan with Verizon wireless. Each month Lucas, the designated “bill reconciler,” is in charge of summarizing the month’s cell phone bill and allocating the appropriate charges to each member. The allocations are complex, and the inputs and nature of charges often changes from month to month.
Lucas is consistently late with his duties. We always get a last-minute text, 5 days after the bill is due (the day before late charges begin accruing), telling us to “hurry and logon to the Verizon site and pay $XX.XX before 5:00.”
My VBA code logs onto the Verizon site, downloads all appropriate information, calculates and allocates the bill, reconciles it to the total, and then sends a text message to each person informing them of their charge, along with relevant usage data. The text also includes the due date of the bill.
No comments:
Post a Comment