[eluser]jedd[/eluser]
Credit card bills are a curious one, to be sure.
They're actually two bill amounts on one bit of paper - there's the total that you owe the credit card issuer, and there's the minimum amount they're willing to accept from you this month.
Of course, that those two numbers are different is what keeps them in business, but that's beside the point.
The
bill you should be tracking is actually for the total amount owing. You might need to track the two things as separate entities - the monthly 'minimum' as one bill, the total credit debt as another.
I think this assertion:
Quote:... doesn't show up on the list because my payments exceed my total due to company ...
demonstrates a profound misunderstanding of the nature of the arrangement. Again, though, the wilful and convenient obfuscation of the usury arrangement is why lenders remain wealthy, and it's why sensible people will always recommend that you pay the full amount, on time every month ... but it's kind of skewing off-topic.
Quote:
Plus, in all actuality, I don't think my current table structure will work anyway. I need to have an Account table in between Companies and Bills. I have one company that I have several accounts with.
Replace companies with accounts, then. You could normalise so common company information is kept in a company table, but ultimately you're just shifting the bill:company relationship to a bill:account one.
Personally I think you're making this way more complex than it needs to be. Considering your geographical limitation, I'd suggest a google-apps spreadsheet, separate page for each account, a row for each bill & payment. Your credit card(s) can then be handled as a special case on their own page(s), and a summary page would be almost trivial to design.
