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

  • Analysis cutoff (planning date): 2026-10-14
  • Payment window: payment dates from 2026-10-14 through 2027-01-12
  • Holdings (assumed eligible shares): MSFT 120, KO 300, O 500, RY.TO 200
  • Scope: ordinary cash dividends only.

Data rules

  • Use only the FMP calendar tool (endpoint dividends-company) and the FMP company tool (endpoint profile-symbol).
  • If a request fails, retry it once. If data is still missing, report Unavailable. Never treat a missing value as zero.
  • Report the dividend and adjDividend fields exactly as returned. If they differ, mark the row Review Required.
  • Do not estimate an amount for any payment without a declaration dated on or before the cutoff.
  • Treat the profile currency as the listing currency only, and mark each row's dividend currency “To verify”.
  • Keep currencies separate. No tax or currency conversion.

Steps

  1. For each holding, call profile-symbol and keep currency and exchange.
  2. For each holding, call dividends-company with limit 6. If no returned record has a payment date before 2026-10-14, raise the limit until one does.
  3. Keep date (ex-dividend date), recordDate, paymentDate, declarationDate, dividend, adjDividend and frequency.
  4. A record is In window if its payment date falls in the payment window.
  5. Declaration status for in-window records: Declared on or before cutoff, if declarationDate is on or before 2026-10-14; Declared after cutoff, if it is later (no amount); Review Required, if declarationDate is missing.
  6. Entitlement status: Assumed eligible, if the ex-dividend date is after 2026-10-14; Entitlement to confirm, if it is on or before 2026-10-14 or missing.
  7. From each holding's frequency and past payment months, list any payment expected in the window that has no FMP record, with Declaration status “Declaration not established from FMP” and the expected month only.
  8. Special-distribution screen: mark a record Review Required if its frequency differs from the frequency of the holding's other returned records, or if its dividend is more than double or less than half of the dividend in the holding's previous record.
  9. For rows declared on or before the cutoff, conditional projected receipt = assumed eligible shares × dividend, rounded to cents, in the listing currency marked “To verify”. No amount for other rows.

Output

  • Start with a run summary: run date, analysis cutoff, holdings, window, operations called, records returned and any data limitation.
  • Table 1 columns: Holding; Listing currency; Ex-dividend date; Record date; Payment date; Declaration date; dividend; adjDividend; Frequency; In window.
  • Show every in-window record, plus the most recent record before the window for any holding with none in it.
  • Table 2 columns: Holding; Assumed eligible shares; Dividend per share; Dividend currency; Ex-dividend date; Payment date; Conditional projected receipt; Declaration status; Entitlement status; Note.
  • After the tables, state in at most three sentences which rows need an issuer check. Do not comment on dividend levels or sustainability.

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

  • Use issuer sources: investor relations or newsroom pages, issuer releases published on a newswire, and SEC or SEDAR filings.
  • Do not use dividend aggregators or news summaries as evidence.
  • Count a declaration only if it was dated on or before 2026-10-14. State the search date separately.
  • Give the exact URL of every source used.
  • If a source cannot be opened, use another issuer source if available. Identify any evidence based only on indexed text.
  • Keep currencies separate. No tax or currency conversion.

Steps

  1. For each row declared on or before the cutoff, find the issuer announcement. Record its date, dividend per share, currency as stated, record date, ex-date if stated, payment date and source URL. Compare these with FMP and retain both values where they differ.
  2. Keep FMP's declaration-date field distinct from the issuer's announcement date. Mark Review Required if a difference changes the cutoff, payment-window or entitlement decision. Otherwise note the difference and explain why the decision is unchanged.
  3. For an expected payment without an FMP record, search issuer announcements for a declaration dated by the cutoff. If none is found, report “No declaration found as of 2026-10-14” and identify the latest relevant declaration found. Do not estimate an amount.
  4. Rows declared after the cutoff retain no amount.
  5. Confirm dividend currency from the announcement, a dividend note, or an applicable issuer payment policy available by the cutoff. A periodic report may support the check when its currency wording clearly applies to common-share dividend disclosures. Do not infer dividend currency from listing currency, a dollar sign, or an unrelated financial-statement unit. Record the source and the wording or dividend disclosure used. Verify the publication or filing date separately from period end. If currency is not confirmed, mark Review Required and exclude the amount from currency totals.
  6. Use FMP's dividend field only if it equals the issuer amount. Otherwise retain both and mark Review Required.
  7. Identify the source of each ex-date. An FMP ex-date not contradicted by the issuer remains FMP-sourced, not independently verified. Assume the stated shares are eligible only if the ex-date is after the cutoff and they are held as required before that date. Otherwise mark Entitlement to confirm.
  8. Preserve qualifications in issuer payment wording, including “on or after”. Do not treat an issuer payment date as a broker credit date.
  9. For a qualifying declaration with confirmed currency and no unresolved material discrepancy, calculate: amount = shares × dividend per share, rounded to cents. Put the amount under Conditional projected receipt when shares are assumed eligible, or Awaiting entitlement confirmation when account records must establish eligibility.
  10. Total the two amount columns separately by payment month and confirmed currency. Label months without qualifying declarations “No qualifying declared payment identified”; do not imply that future receipts are impossible.

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

September 15, 2026

0.98

2026-11-19

KO

October 15, 2026

0.53

2026-12-01

O

September 8, 2026

0.2715

2026-09-30

O

October 13, 2026

0.2715

2026-10-30

RY.TO

August 27, 2026

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.

About the Author
Pranjal Saxena

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.

Related

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