A year of dividends in one table
Dividend income arrives in fragments. A voucher from one company, a statement from a broker, a notice from a registrar — each covering one payment, each in its own format, each landing at a different time of year. Individually they are trivial. Collectively they are a tax figure and an income stream, and reconstructing that from a pile of documents is genuinely tedious work.
FlowParse reads each dividend statement or voucher with AI and exports it as a structured row: the company, the payment date, the shares held, the rate per share, the gross dividend, any tax withheld, and the net amount received. A year of scattered documents becomes one sortable table.
From there the useful numbers are sums. Total dividend income for the tax year. Total withholding to reclaim or credit. Income by holding, so you can see which positions are actually paying you.
What FlowParse pulls from a dividend statement
Extraction is by meaning rather than by template, so the fields come out whether the document is a UK dividend voucher, a broker's income statement or a registrar's payment advice: the paying company and security, the payment date and the record date where shown, the number of shares held, the dividend rate per share, the gross amount, any tax withheld or credited, the net paid, and the currency.
Where the payment is a dividend reinvestment, the shares purchased and the price paid are captured too — which matters, because reinvested dividends are both income and an addition to your cost basis, and forgetting the second half is a classic way to overstate a future gain.
Amounts export as typed numbers with the currency preserved, so income in different currencies is never accidentally summed into a meaningless total.
Why dividend paperwork gets lost
The problem with dividend documents is not complexity, it is dispersion. They arrive one at a time, from different senders, throughout the year, and each one is small enough to feel unimportant on the day it lands. So they get filed, or they sit in an inbox, and nobody totals anything until a tax deadline forces it.
By then the work is archaeology. Which of these vouchers did I already record? Is this broker statement duplicating a payment I have as a separate advice note? Was this one gross or net? What was the withholding on the foreign holding?
Structuring them as they arrive — or in one batch at the end — removes the archaeology. Every payment is a row, duplicates are visible, and the totals compute themselves.
How to convert a dividend statement to Excel
Upload the statements
Drop in one or many dividend vouchers, statements or payment advices — digital or scanned.
Let AI extract them
Company, date, shares, rate, gross, withholding and net are read in seconds.
Review the preview
Check the editable preview; low-confidence figures are highlighted for a quick correction.
Export to Excel
Download a clean .xlsx — or CSV, Google Sheets or JSON via the API instead.
Gross, withholding and net — kept apart
The single most important thing a dividend document tells you is the difference between what was declared and what you received. Gross is the income. The gap is tax withheld. Net is what hit the account. Confusing them is how a tax return ends up wrong in a way that is genuinely hard to spot afterwards.
FlowParse keeps all three as separate columns. That sounds obvious, but it is precisely what gets lost when someone records dividends by looking at their bank statement — because the bank only ever shows the net, and the withheld tax simply vanishes from the record.
With the three columns present, the year's income is the gross total, the tax position uses the withholding total, and the reconciliation against your bank uses the net. Each question gets the right number.
Foreign withholding you may be able to reclaim
Dividends from foreign companies are usually taxed at source before you see them, at a rate set by the paying country and often reduced by a treaty. That withheld tax is frequently creditable against your own liability, and sometimes reclaimable outright.
It is also routinely forgotten, because it never appears as a payment — it appears as an absence, a smaller net than expected. The only place it is stated is the dividend document, and only if someone reads it.
As a structured column, withholding becomes a total you can act on: the amount to claim relief against, broken down by country and by holding, evidenced by the documents behind it. FlowParse does not calculate relief or file anything — it makes sure the number is not lost before whoever does that work sees it.
Reinvested dividends and cost basis
A reinvested dividend is two events wearing one coat. It is income — taxable in the year received, whether or not you saw the cash — and it is a purchase, adding shares at a known price and increasing your cost basis.
Recording only the income half is the most common mistake in dividend bookkeeping, and it costs money later: an understated basis becomes an overstated capital gain when the position is eventually sold.
FlowParse captures the reinvestment detail where the statement shows it — shares acquired and price paid — so both halves survive into the spreadsheet. The income totals for the year, and the basis additions are there for when the gain calculation needs them. See brokerage statement to Excel for the basis picture in full.
Building a dividend income tracker that maintains itself
People who live on dividend income keep a tracker, and most trackers are hand-typed — which means they are always slightly behind and occasionally wrong. Converting the documents rather than reading them turns the tracker into something that maintains itself from the source.
With payments as rows, the analysis is standard spreadsheet work: income by month, income by holding, year-on-year growth per position, and the proportion of total income coming from any single company — the concentration risk that matters most to anyone actually spending this money.
Because every row traces back to a document, the tracker is also evidence. A figure that looks wrong can be checked against the voucher it came from rather than argued about.
What an accountant actually needs
At tax time the request is simple and the compliance is not: a list of dividends received in the year, gross, with any tax withheld, by company. Most people answer it with a bank statement and a shrug, because the bank only shows net amounts and doesn't name the tax.
A structured dividend table answers it properly, in the form the request implies — every payment, gross, withheld, net, dated, with the security named and the source document identified.
FlowParse does not produce tax forms — no 1099-DIV, no filing — and does not compute your liability. It produces the evidenced dataset the person doing that work has been asking you for. The related bank statements for a tax return page covers how this fits the rest of the picture.
Multiple currencies, kept honest
An internationally diversified portfolio pays in several currencies, and a dividend received in dollars is not a dividend received in euros. Summing them without conversion produces a number that is worse than useless — it looks authoritative and means nothing.
FlowParse captures the currency of each payment as a field, so currencies never merge silently. Where the document also shows the converted amount and the rate applied, both are kept, giving you the payment in its own currency and in your reporting currency.
That is what lets you total income correctly, and what lets you see how much of your income depends on an exchange rate you don't control.
A folder of vouchers in one pass
Dividend documents are the definition of a batch problem — many small files, each carrying one payment. Batch processing takes up to 100 at once and merges them into a single sheet with duplicate detection and a source reference on every row.
Duplicate detection earns its place here specifically. The same dividend often appears twice in your records: once as a voucher from the company and once as a line on a broker statement. Counting it twice inflates your income and your tax; catching it is exactly what a merged, deduplicated table does.
Posted and scanned vouchers too
Dividend vouchers are still posted on paper by plenty of registrars, and older holdings often have years of paper behind them. Those documents are the only record of income received and tax withheld, and they cannot simply be skipped.
OCR runs first on scanned and photographed vouchers, then the AI structures the recognised text and flags any low-confidence figure for review — so a posted voucher becomes the same clean row as a downloaded PDF.
Income figures you can stand behind
Dividend data feeds a tax return, so a misread gross or a lost withholding line has consequences beyond a wrong spreadsheet. FlowParse reaches around 98% field-level accuracy on standard layouts and highlights low-confidence figures in the editable preview.
The document also checks itself: shares held times the rate per share should equal the gross, and gross minus withholding should equal the net. Both are computable the moment the data is in columns, which means an extraction error tends to announce itself rather than hide.
Your income data stays private
Dividend documents name what you own and what it pays you. Uploads run over TLS, processing is EU-hosted, and the original PDF is deleted immediately after processing.
Documents are never used to train AI models, and nothing is retained once your export is produced.
Dividends drawn from your own company
For company directors, a dividend statement is a document you issue as well as receive. Every distribution needs a dated voucher recording the shareholder, the shares held, the amount per share and the total — and those vouchers are the evidence that a payment out of the company was a dividend and not something else.
That distinction has real consequences. A payment taken without a proper dividend record can be recharacterised, with tax treatment that is considerably less favourable than the one that was intended. The paperwork is not a formality; it is the substance.
Converting those vouchers into structured rows gives you the register in a form that can be totalled and checked: distributions by date, by shareholder and by year, against the profits that were available to distribute. It is the record an accountant asks for and the one that has to hold up if it is ever examined.
Declaration, record and payment dates
A dividend has several dates, and they are not interchangeable. It is declared on one date, the shareholder register is fixed on another, and the cash arrives on a third — sometimes in a different tax year from the one in which it was declared.
That gap is where dividend accounting quietly goes wrong. Recording income by the date the money appeared in your bank account is easy and often correct, but it is not always correct, and a payment straddling a year end is precisely the case where it is not.
FlowParse captures the dates the document states rather than inferring them from a bank credit. Having the payment date and, where shown, the record date as separate fields means the year a dividend belongs to is a fact from the document rather than an assumption from your bank statement.
Who converts dividend statements to Excel
Income investors tracking what their portfolio actually pays, accountants assembling a client's dividend income for a return, company directors recording dividends drawn from their own company, and anyone holding foreign shares who would rather not donate their withholding tax to inertia.
If your dividend record is currently a folder of PDFs and an optimistic guess, converting them is how it becomes a number you can defend.
Convert your dividend statements to Excel
Upload your vouchers and statements and get one clean table — gross, withholding and net by company and date, ready to total and hand to an accountant.