A monthly bill tracking system that keeps each bill's contact information and due date in separate linked libraries is a relational database design, not an administrative overcomplication.
The contact information for your electricity provider doesn't change every month. The due date reminder structure for your mortgage doesn't change every month. What changes is the amount due and which month you're recording. Storing the stable data once — in the Bill Contacts library and the Bills Due Date/Notes library — and linking to it from each monthly record is exactly how you avoid re-entering the same utility company's customer service number twelve times per year.
How the Three-Library System Works
Each monthly record carries a Month and Year identifier — one record per month, containing up to ten bills. Each bill position carries three linked fields: Contact Information (linking to the Bill Contacts library), Due Date/Notes (linking to the Bills Due Date library), and an Amount Due currency field.
The Contact Information link pulls the payee name, account number, customer service phone, and payment portal directly from the Bill Contacts library. When your internet provider changes their billing contact number, you update it once in Bill Contacts and every monthly record that references it reflects the change immediately — without editing twelve months of historical records.
The Due Date/Notes link from the Bills Due Date library carries recurring due date information, autopay status, and payment notes. The note that your landlord requires a bank check rather than online payment, that the student loan servicer applies payments to interest first unless you specify principal, that the credit card minimum is due on the 14th but the full statement balance on the 22nd — those notes live once in the due date library and surface in every monthly record.
The Total Field Is the Point
The calculated Total field sums Amount Due through Amount Due 10 — up to ten bills per month record, all added automatically. At the start of any month, entering the variable amounts (utilities with usage-based billing, credit card balances that change monthly) against the fixed amounts (rent, loan payments, subscriptions) produces the month's total obligations in a single record.
Comparing January through December by opening each monthly record shows the full year's billing pattern. The months where the total spikes — December with holiday credit card balances, August with back-to-school costs — become visible as data rather than as a vague feeling that something was expensive.
The system requires all three libraries to function. The Bills Record is the monthly log. The Bill Contacts library is the payee directory. The Bills Due Date/Notes library is the calendar and annotation layer. Installed together, they create a household billing system where every question — who do I call about this charge, when is this due, what did I pay last March — has a direct answer.