Let me see if I understand...

One table for balances. For simplicity's sake, just one account for now, with consecutive dates (say for August 2014 for now) and the balance for each date.

Second table is for bills: payee, due date, amount.

For each bill on this table, you want to display the balance for the date that equals the due date. Is that right?