Build a Declared Dividend Receipt Schedule for Your Portfolio With Claude MCP
A dividend calendar shows what companies plan to pay. A portfolio receipt schedule connects those payments to the shares in an account, showing how much cash may arrive and when. Building that schedule requires more than multiplying the latest dividend by a share count: the payment must be declared, the shares must qualify, and the amount must be assigned to the correct currency.
This walkthrough uses Claude and FMP's MCP server to build a declared-dividend schedule for Microsoft, Coca-Cola, Realty Income, and Royal Bank of Canada. The planning cutoff is October 14, 2026, and the payment window runs through January 12, 2027.
The workflow retrieves dividend records from FMP data, compares them with issuer disclosures, and calculates conditional gross receipts by payment date and month. It keeps payments awaiting an account entitlement check separate from those associated with shares assumed eligible.
For this example, conditional projected receipts total USD 253.35 and CAD 352.00. Another USD 135.75 depends on confirming entitlement to a Realty Income payment whose ex-dividend date preceded the planning cutoff.
These are gross planning amounts. They exclude withholding tax, fees, currency conversion, and dividend reinvestment. Issuer payment dates may also differ from the dates a broker credits an account.
Key Takeaways
- Declaration, entitlement, and currency are separate checks. Establishing one does not establish the others.
- A regular payment pattern does not replace a dividend declaration. The schedule includes amounts only for payments declared by the planning cutoff.
- Portfolio share counts are inputs. Payments remain conditional on those shares qualifying under the applicable entitlement rules.
- Dividend currency must be supported by issuer documentation. Listing currency alone is insufficient.
- A completed schedule can include excluded payments and amounts awaiting an account check without treating either as zero.
Define the Portfolio and Planning Window
The four holdings illustrate different scheduling conditions. Microsoft has a declared quarterly payment after the cutoff. Coca-Cola's next announcement falls just after it. Realty Income pays monthly, including one payment whose ex-dividend date has already passed. Royal Bank of Canada introduces a Canadian-dollar amount that must remain separate from the US-dollar receipts.
|
Input |
Value |
|
Planning cutoff |
October 14, 2026 |
|
Payment window |
October 14, 2026 through January 12, 2027 |
|
Microsoft |
MSFT, 120 shares |
|
Coca-Cola |
KO, 300 shares |
|
Realty Income |
O, 500 shares |
|
Royal Bank of Canada |
RY.TO, 200 shares |
|
Scope |
Regular common-share cash dividends |
The share counts are hypothetical account positions. They represent shares assumed eligible when the ex-dividend date is still ahead, provided the account holds them as required.
The cutoff and retrieval date serve different purposes. The cutoff determines which declarations qualify for the schedule. The data was retrieved on October 22, 2026, so the returned records could include announcements made after October 14. Exclude those later declarations from the cutoff-based amounts.
This reconstructs a schedule using declarations dated by the cutoff. It does not reproduce exactly what FMP's database contained on that earlier date. Keeping the planning cutoff, declaration date, and payment date separate follows the same discipline used when aligning financial events with their reporting dates.
Establish Which Shares Qualify
For regular cash dividends, investors generally need to purchase shares before the ex-dividend date to receive the payment. A purchase on or after that date does not qualify for that dividend, while a sale on or after the ex-date generally preserves the seller's entitlement. The SEC's ex-dividend explanation distinguishes these rules from the treatment of certain large distributions and stock dividends.
A position recorded on the planning date therefore cannot settle entitlement to a payment whose ex-date has already passed. That requires the account's transaction or corporate-action history.
|
Situation |
Schedule treatment |
|
Ex-date after the cutoff |
Assume the stated shares qualify, conditional on holding them as required before the ex-date |
|
Ex-date on or before the cutoff |
Keep the amount separate pending confirmation from account records |
|
Ex-date not established |
Require an entitlement check |
|
Special distribution, stock dividend, or due-bill arrangement |
Review separately; outside this workflow's scope |
An ex-date supplied by FMP remains identified as FMP-sourced unless independently confirmed. An issuer announcement's silence about the ex-date is not independent verification.
Confirm the Amount and Currency
The schedule uses:
Gross receipt = eligible shares × declared dividend per share
The result is rounded to cents, and amounts are totaled only within the same currency.
FMP supplies dividend and adjDividend fields. This workflow retains both, compares them, and checks the selected per-share amount against the issuer's declaration. Equal values establish agreement between the returned fields; the issuer comparison establishes whether the amount matches the announced dividend.
Currency requires a separate check. A company profile identifies listing currency, which may differ from the dividend's denomination. Confirm the declared dividend currency from the announcement, a dividend disclosure, or an applicable issuer payment policy. A periodic report can support this check when its currency statement clearly applies to its dividend disclosures. A general reporting-currency label elsewhere in the statements is not sufficient by itself.
The declared currency also differs from the account's settlement currency. A broker may convert a payment, apply withholding, or reinvest it. Those account-level effects are outside this gross receipt schedule.
Connect FMP to Claude
The workflow uses FMP's company dividend records and company profile data. The dividend calendar provides a broader view of events across companies.
|
MCP tool and operation |
Inputs |
Role |
|
calendar / dividends-company |
Symbol; initial limit of 6 |
Dividend amounts, dates, and frequency |
|
company / profile-symbol |
Symbol |
Listing currency and exchange |
|
Claude web search |
Issuer announcements and filings |
Declarations, amounts, dates, and currency |
The operation names are MCP identifiers used in the example, rather than literal REST URL paths.
Follow the FMP MCP setup documentation to connect the server to Claude. Add the connector URL with your FMP API key:
https://financialmodelingprep.com/mcp?apikey=YOUR_FMP_API_KEY
Run both prompts in the same conversation. The first uses FMP only. Enable web search before the second prompt so Claude can examine issuer sources.
Retrieve the Dividend Records
The first prompt establishes the events and applies the cutoff. Currency remains provisional until the issuer check.
|
Using the connected FMP MCP server, build the first pass of a dividend receipt schedule for the portfolio below. Do not search the web in this step. Inputs
Data rules
Steps
Output
|
Records Returned
The October 22 run made eight FMP calls and returned 24 dividend records, six per holding. Five records had payment dates within the selected window. No requests failed, and no limit increases were needed.
The dates and amounts appear in separate tables below.
|
Holding |
Ex-date |
Record date |
Payment date |
|
MSFT |
2026-11-19 |
2026-11-19 |
2026-12-10 |
|
KO |
2026-12-01 |
2026-12-01 |
2026-12-15 |
|
O |
2026-09-30 |
2026-09-30 |
2026-10-15 |
|
O |
2026-10-30 |
2026-10-30 |
2026-11-13 |
|
RY.TO |
2026-10-26 |
2026-10-26 |
2026-11-24 |
|
Holding and payment |
Listing currency |
FMP declaration date |
dividend |
adjDividend |
|
MSFT, December 10 |
USD |
2026-09-14 |
0.98 |
0.98 |
|
KO, December 15 |
USD |
2026-10-15 |
0.53 |
0.53 |
|
O, October 15 |
USD |
2026-09-08 |
0.2715 |
0.2715 |
|
O, November 13 |
USD |
2026-10-13 |
0.2715 |
0.2715 |
|
RY.TO, November 24 |
CAD |
2026-08-26 |
1.76 |
1.76 |
Source: FMP records retrieved October 22, 2026. Listing currencies are not used as final evidence of dividend currency. MSFT, KO, and RY.TO are quarterly payers; O is a monthly payer.
The two amount fields matched in all 24 returned records, and the frequency-and-amount screen flagged no potential special distributions. That screen is a prompt for further investigation when triggered, rather than proof of distribution type.
The first pass identified three scheduling conditions:
- Coca-Cola: Its December declaration was dated after the cutoff, so no amount entered the schedule.
- Realty Income's October payment: Its ex-date preceded the cutoff, so the amount required an account entitlement check.
- Realty Income's December payment: The monthly pattern suggested a payment to investigate, but no FMP record established a qualifying declaration.
Verify the Events Against Issuer Sources
The second prompt checks the payment evidence and calculates totals in confirmed currencies. It also distinguishes an expected payment from an established declaration.
|
Continue the dividend receipt schedule. Check issuer sources for every row in Table 2. Objective Confirm each row's declaration, amount, dates and dividend currency from issuer documentation available on or before 2026-10-14, then produce the final schedule and monthly totals. Data rules
Steps
Output Return an issuer evidence table with source URLs, announcement dates, amounts, payment details and comparisons with FMP; a currency evidence table; the final payment schedule; monthly totals by currency, with conditional receipts and amounts awaiting entitlement confirmation in separate columns; and a concise exception list. Do not comment on dividend levels or sustainability. |
Issuer Payment Evidence
|
Holding |
Issuer announcement |
Amount per share |
Record date |
|
MSFT |
0.98 |
2026-11-19 |
|
|
KO |
0.53 |
2026-12-01 |
|
|
O |
0.2715 |
2026-09-30 |
|
|
O |
0.2715 |
2026-10-30 |
|
|
RY.TO |
1.76 |
2026-10-26 |
Microsoft's announcement also states the November 19 ex-dividend date. The ex-dates for Realty Income and Royal Bank of Canada in the schedule come from FMP; their cited announcements establish the record and payment dates. The final schedule below preserves the issuer payment wording.
The issuer amounts match the FMP amounts used in the calculations. Coca-Cola's October 15 announcement falls one day after the cutoff and therefore contributes no receipt amount. Realty Income's September and October releases support its two scheduled payments.
Two date differences remain visible. FMP's MSFT declaration-date field is September 14, while the issuer announcement is dated September 15. For RY.TO, FMP returns August 26 and the issuer announcement is dated August 27. Both dates in each comparison precede the cutoff, so neither changes the schedule's inclusion decision. The comparison does not establish the cause of those differences.
Currency Evidence
|
Holding |
Supporting issuer disclosure |
Currency |
|
MSFT |
FY2026 10-K dividends-declared detail, which identifies common-share dividend amounts in USD |
USD |
|
O |
June 2026 10-Q, whose dollar convention applies to its dividend disclosures unless otherwise indicated |
USD |
|
RY.TO |
Q3 2026 report, which states Canadian-dollar units and includes common-share dividend disclosures |
CAD |
|
KO |
No currency applied to a receipt amount because its declaration falls after the cutoff |
Not used |
Microsoft's dividend disclosure supplies more direct currency evidence than an income-statement label alone. Realty Income's filing was submitted on August 6, 2026, before the cutoff; its June period end is not used as a substitute for that filing date. RBC's report is dated August 27 and identifies Canadian-dollar amounts.
These currencies describe the gross dividend amounts used in the schedule. They do not establish what currency a particular account will receive after broker processing.
The Declared Dividend Receipt Schedule
The final schedule separates amounts associated with shares assumed eligible from amounts awaiting an account check. Payment details and receipt amounts are shown separately so each table remains readable.
|
Holding |
Ex-date |
Ex-date source |
Issuer payment date |
|
O |
2026-09-30 |
FMP |
2026-10-15 |
|
O |
2026-10-30 |
FMP |
2026-11-13 |
|
RY.TO |
2026-10-26 |
FMP |
On or after 2026-11-24 |
|
MSFT |
2026-11-19 |
Issuer |
2026-12-10 |
|
Holding and payment |
Shares |
Per share |
Currency |
Conditional receipt |
Pending entitlement |
|
O, October 15 |
500 |
0.2715 |
USD |
0.00 |
135.75 |
|
O, November 13 |
500 |
0.2715 |
USD |
135.75 |
0.00 |
|
RY.TO, November 24 or later |
200 |
1.76 |
CAD |
352.00 |
0.00 |
|
MSFT, December 10 |
120 |
0.98 |
USD |
117.60 |
0.00 |
All four payments have qualifying declarations dated before the cutoff. Conditional receipt means the stated shares are assumed eligible; pending entitlement means account records must establish eligibility. Zero means no amount is assigned to that category among the included payments. It does not represent a missing dividend value.
The calculations are:
- Realty Income: 500 × 0.2715 = USD 135.75 for each included payment.
- Royal Bank of Canada: 200 × 1.76 = CAD 352.00.
- Microsoft: 120 × 0.98 = USD 117.60.
Realty Income's October amount remains separate because the account's entitlement was not established. Its payment date also preceded the October 22 retrieval date, so this row represents a historical planning amount, not confirmation that cash was received.
|
Expected payment |
Treatment at the October 14 cutoff |
|
KO, December 15 |
Declaration dated October 15; excluded |
|
O, December 2026 |
No qualifying declaration found in the issuer search; no amount estimated |
A monthly payment pattern gives the workflow a reason to search for a declaration. It does not supply a declared amount or payment date.
Monthly Gross Receipts by Currency
|
Payment month |
Currency |
Conditional receipts |
Pending entitlement |
|
October 2026 |
USD |
0.00 |
135.75 |
|
November 2026 |
USD |
135.75 |
0.00 |
|
November 2026 |
CAD |
352.00 |
0.00 |
|
December 2026 |
USD |
117.60 |
0.00 |
|
Window total |
USD |
253.35 |
135.75 |
|
Window total |
CAD |
352.00 |
0.00 |
No qualifying declared payment was identified for January 1-12, 2027. That describes the cutoff-based schedule; it does not rule out a later announcement or a change to a payment timetable.
The USD conditional total is 135.75 + 117.60 = 253.35. CAD 352.00 remains separate. Adding Realty Income's October amount to the conditional column would obscure the unresolved entitlement question, so it stays in its own total.
Use and Maintain the Schedule
The schedule identifies which declared payments can support cash planning under the stated share assumptions. It also shows exactly what still depends on the account: entitlement to Realty Income's October payment and the continued eligibility of shares associated with future ex-dates.
For each payment, retain the dividend amount, currency, ex-date source, issuer payment wording, share count, and entitlement status. At payment time, compare the projected gross amount with the broker's transaction record. That record establishes the actual credit date, withholding, fees, conversion, or reinvestment.
Moving the cutoff forward brings newly declared payments into consideration. Recheck issuer dates and amounts rather than carrying forward the last dividend automatically. Keep any payment without a qualifying declaration outside the receipt totals, even when the company has a long payment history.
The same records can support automated market-intelligence briefings that flag new declarations for review. Assessing whether those dividends can be maintained requires a separate cash-flow and balance-sheet analysis.
A useful receipt schedule preserves these boundaries: the issuer establishes the declared payment, the account establishes entitlement and actual receipt, and the calculation connects the two through a documented share count.

Financial APIs, Claude MCP, and AI-driven research workflows
Pranjal Saxena writes technical content focused on financial data APIs, Claude MCP workflows, AI-driven research systems, and Python-based market analysis. For FMP, his work centers on turning structured financial data into practical, workflow-driven content for developers, analysts, and fintech teams. He combines experience in data science, NLP, generative AI, and financial API workflows to show how APIs, automation, and AI-assisted systems can support modern financial research and analysis.
Financial data for every need
Real-time quotes and 30+ years of historical data, including prices, fundamentals, and insider transactions — all accessible via API.
Create Free Account