When you end up looking at using accounts 
this is something allong the lines you might want to look to do.
Its more than what you need as does bookings and rooms but main thing for your use would be the second entity screen with grid formatting to show balance.