A big bank earnings tracker in Excel is one scorecard row per bank that shows the consensus EPS estimate, the actual EPS you enter when it prints, the surprise percentage, and valuation metrics (forward P/E, price-to-book, ROE) pulled by MarketXLS formulas such as =EPSEstimate("JPM") and =PriceToBook("JPM"). For Q2 2026, Citigroup, Wells Fargo, Goldman Sachs, Morgan Stanley and Bank of America report on July 14, 2026, and JPMorgan Chase reports on July 15. This guide explains how the scorecard works, which metrics matter most for banks this quarter, and links a free template in static and live-formula versions.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
MarketXLS access: Downloading a workbook does not include live data access. Refreshing MarketXLS formulas requires a paid MarketXLS subscription.
This is educational analysis, not investment advice. The bank tickers below are used to demonstrate how the formulas and the tracker work, not as recommendations to buy or sell anything.
Big Bank Earnings Tracker Excel: The Q2 2026 Reporting Calendar
The reason a tracker matters this week is timing. Six of the most important financial institutions in the world report inside 48 hours, and the market reprices the entire sector off their combined tone. Analysts head into the quarter with S&P 500 earnings expected to grow roughly 24% year over year, and the banks are the tell for whether that optimism holds. Here is the group the template is built around and why each one moves the sector.
| Ticker | Bank | Report Date | Why it matters |
|---|---|---|---|
| C | Citigroup | Jul 14, 2026 | Turnaround story, EPS growth expected near 39% year over year |
| WFC | Wells Fargo | Jul 14, 2026 | Deposit-funded lender, asset-cap and NII commentary in focus |
| GS | Goldman Sachs | Jul 14, 2026 | Investment banking and trading bellwether |
| MS | Morgan Stanley | Jul 14, 2026 | Wealth management plus markets, fee-income read |
| BAC | Bank of America | Jul 14, 2026 | Rate-sensitive giant, EPS growth expected near 27% |
| JPM | JPMorgan Chase | Jul 15, 2026 | Largest US bank, sets the tone for the whole group |
The template also tracks two super-regionals, U.S. Bancorp and PNC Financial, that report later in the week, so you can compare the money-center names against a more traditional lending model.
What Is Different About Q2 2026 Bank Earnings
Every earnings season has a theme, and the Q2 2026 theme for banks is the recovery in capital markets. For most of the last two years, net interest income carried bank profits while trading desks and investment banking sat quiet. That balance is shifting. Consensus points to growth coming from the core banking and trading franchises this quarter, with investment banking activity described as largely stable rather than depressed. Loan growth is expected to accelerate from an already strong prior quarter.
That matters for how you read the prints. A pure spread-lender like Wells Fargo lives on net interest income and deposit costs. A markets-and-advisory house like Goldman Sachs lives on trading revenue and deal fees. Bank of America and JPMorgan blend both. So a headline EPS beat from Goldman means something very different from a headline beat at Wells Fargo, and a good tracker forces you to look past the single number to the driver underneath it. The scorecard in the template puts EPS surprise next to valuation and profitability so you are never reading one metric in isolation.
The banking group has already run ahead of the reports. The Invesco KBW Bank ETF gained roughly 9% year to date through early July and about 12% over the trailing three months, so expectations are elevated going in. When a sector rallies into earnings, the bar to keep climbing rises with it, which is exactly why the surprise percentage and the price reaction are the two columns worth watching most.
How the Big Bank Earnings Tracker Excel Scorecard Works
The big bank earnings tracker template uses a single scorecard row per bank. You type a ticker into the yellow input cell and the rest of the row fills in from live MarketXLS formulas: company name, current price, intraday change, the consensus EPS estimate, forward P/E, price-to-book and return on equity. As each bank reports, you type the actual reported EPS into one more yellow cell, and the sheet calculates the surprise percentage and flags the result as a beat, an in-line print or a miss.
The surprise math is deliberately simple and honest:
Surprise % = (Actual EPS - Estimate EPS) / Estimate EPS
A surprise above +2% flags as a beat, below -2% flags as a miss, and anything in between reads as in line. Those thresholds are a convention, not a rule, and you can edit them in the formula. The point is to standardize the read across six banks so JPMorgan and Citigroup are scored on the same scale.
The EPS estimate itself comes straight from MarketXLS so you are not hand-entering consensus for each name:
=EPSEstimate("JPM") Consensus EPS estimate for the quarter
=EarningsPerShare("JPM") Trailing-twelve-month EPS for context
Formula documentation: EPSEstimate, EarningsPerShare
Building the Tracker With MarketXLS Formulas
The whole value of an Excel-native tracker is that the data refreshes without you touching it. Instead of copying numbers out of a website into a spreadsheet, you write a formula once and it pulls live. Here are the core MarketXLS functions the scorecard is built on, each verified against the function library.
| Metric | MarketXLS Formula | What it tells you |
|---|---|---|
| Company name | =Name("GS") | Confirms the ticker resolved |
| Current price | =QM_Last("GS") | Last trade (real-time on Advanced and Business plans, 15-min delayed on Standard) |
| Intraday change | =QM_ChangePercent("GS") | Percent move on the day |
| EPS estimate | =EPSEstimate("GS") | Consensus estimate for the print |
| Forward P/E | =ForwardPE("GS") | Valuation on forward earnings |
| Price to book | =PriceToBook("GS") | The core bank valuation metric |
| Return on equity | =ReturnOnEquity("GS") | Profitability of shareholder capital |
| Return on assets | =ReturnOnAssets("GS") | Efficiency of the balance sheet |
| Dividend yield | =DividendYield("GS") | Trailing income yield |
| Beta | =Beta("GS") | Sensitivity to market moves |
For banks specifically, price-to-book and return on equity do more work than the price-to-earnings ratio you would lean on for an industrial or a tech name. A bank is essentially a leveraged pool of assets and liabilities, so book value is a meaningful anchor and the return the bank earns on that book (ROE) tells you whether it is creating or destroying value. A cheap price-to-book combined with a rising ROE is the classic profile that value-oriented bank investors hunt for, while a rich price-to-book demands a high and durable ROE to justify it.
To see how to combine these into a broader screen, the MarketXLS stock screener and the MarketXLS formula library walk through the same building blocks applied to other sectors.
Reading an Earnings Print: Beat Does Not Always Mean Up
The single most common mistake around bank earnings is assuming an EPS beat guarantees the stock goes up. It does not. A bank can beat on the bottom line and still fall hard if the beat came from a one-time item, if net interest income guidance disappointed, or if management built larger credit reserves signaling caution about the consumer. The reverse happens too: a headline miss can be shrugged off if it was driven by a conservative reserve build that the market reads as prudence rather than weakness.
That is why the template pairs the surprise flag with a Scenario Analysis sheet. It lays out five outcomes, from a big beat to a big miss, and maps each to an illustrative price move so you can pressure-test your own expectations before the report. The moves in that grid are placeholders for education, not forecasts, and you should overwrite them with your own assumptions. The value is in the structure: it forces you to separate the earnings surprise from the price reaction, which are two different things that only sometimes move together.
The Reaction Playbook sheet extends this into a checklist across three phases:
- Pre-earnings. Where does the bank trade on forward P/E and price-to-book versus its peers? A name going in cheap has a lower bar to clear.
- The print. EPS surprise first, then revenue and net interest income trajectory, then trading and investment-banking fees. This quarter that last line is the swing factor.
- Post-earnings. Profitability quality via ROE and ROA, and any change to the dividend or buyback, which is management voting with capital.
None of these are signals to trade. They are a framework for studying why a bank stock did what it did after a report, so that over time you build a real feel for the sector.
Position Sizing and Comparing the Group
The template does two more things beyond the scorecard. The Position Sizing sheet lets you set a portfolio budget and a risk weight for each bank, then splits your dollars across the basket and converts each allocation into an approximate share count using the live price. This is a mechanical exercise in how a basket would be constructed, not a suggestion to buy any of these names. It is useful for understanding how position weights translate into real dollars and shares.
The Valuation Comparison sheet is a color-coded matrix that ranks the eight banks on forward P/E, price-to-book, ROE, ROA and dividend yield at once. Lower valuation multiples shade green, higher profitability shades green, and a simple composite Value Score summarizes the trade-off. Again, this is an educational composite, not a rating. Banks trade at different multiples for good reasons, business mix, credit exposure and capital levels all differ, and the matrix is there to make those differences visible rather than to pick a winner.
Here is the kind of comparison the matrix surfaces:
| Ticker | Model | What the multiples usually say |
|---|---|---|
| JPM | Money-center | Premium price-to-book, justified by high ROE |
| C | Turnaround | Lowest price-to-book, market waiting on ROE proof |
| GS | Markets/advisory | Multiple swings with the capital-markets cycle |
| MS | Wealth + markets | Rewarded for stable wealth-management fees |
| WFC | Deposit lender | Re-rating story as the asset cap narrative evolves |
The Free Template: What Is Inside
The workbook has six sheets and follows the same structure as our other MarketXLS earnings trackers so it feels familiar if you have used one before.
- How To Use - a plain-English tour of every sheet and the formulas behind it.
- Main Dashboard - the earnings scorecard with EPS estimate, actual, surprise percentage and a beat/miss flag for all eight banks.
- Scenario Analysis - a beat-to-miss grid mapping EPS surprise to an illustrative price move for any anchor bank.
- Reaction Playbook - the three-phase educational checklist for reading a bank earnings report.
- Position Sizing - a risk-weighted allocator that converts a budget into share counts at live prices.
- Valuation Comparison - a color-coded matrix across P/E, P/B, ROE, ROA and yield with a composite score.
Every sheet lists the exact MarketXLS functions used at the bottom, so you can see precisely which formula produces each number and rebuild any part of it yourself.
Download the templates:
- - Pre-filled with reference data as of July 11, 2026, with the formula behind every cell shown
- - Live-updating formulas that refresh with the MarketXLS add-in
The static version is the lead magnet you can open in any spreadsheet program to see the layout and the formula references. The formula version comes alive when you open it in Excel with the MarketXLS add-in installed, pulling live prices, estimates and ratios every time you refresh.
Frequently Asked Questions
When do the big banks report Q2 2026 earnings?
The money-center banks kick off the season on July 14 and 15, 2026. Citigroup, Wells Fargo, Goldman Sachs, Morgan Stanley and Bank of America report on July 14, and JPMorgan Chase reports on July 15. Super-regionals such as U.S. Bancorp and PNC Financial follow later in the same week. The template is dated to this calendar so you can track the prints in order.
What is an earnings surprise and how is it calculated?
An earnings surprise is the gap between a company's actual reported EPS and the consensus analyst estimate, expressed as a percentage. The tracker calculates it as (actual minus estimate) divided by estimate. A positive surprise means the bank earned more than expected; a negative surprise means it earned less. The template flags anything above +2% as a beat and below -2% as a miss, thresholds you can adjust.
Why does the tracker use price-to-book instead of just P/E for banks?
Banks are leveraged balance sheets, so book value is a meaningful anchor for what the equity is worth, and price-to-book is the metric analysts reach for first. Pairing price-to-book with return on equity tells you whether a bank is cheap relative to the capital it earns on. The =PriceToBook() and =ReturnOnEquity() MarketXLS formulas pull both live.
Does a big bank always rise when it beats earnings?
No. A bank can beat on EPS and still fall if net interest income guidance disappoints, if the beat came from a one-off item, or if management builds larger credit reserves. The template deliberately separates the earnings surprise from the price reaction so you study the driver behind the move rather than assuming a beat means the stock goes up.
Can I add other banks to the tracker?
Yes. Every sheet is formula-driven off the ticker in the input column. Type any bank ticker into the yellow cell and the row repopulates with live data. You can swap in regional banks, trust banks or foreign banks that trade in the US and the scorecard math works the same way.
Why is trading revenue the theme for Q2 2026 bank earnings?
For most of the past two years, net interest income drove bank profits while trading desks and investment banking stayed quiet. That is changing. Consensus expects Q2 2026 growth to come from the core banking and trading franchises, with investment banking activity described as stable rather than depressed and loan growth accelerating. So the trading and fee lines in each release, especially at Goldman Sachs and Morgan Stanley, are the swing factor this quarter and worth reading before you react to the headline EPS number. The Reaction Playbook sheet puts that line item on your checklist.
The Bottom Line
A big bank earnings tracker in Excel turns the two-day Q2 2026 reporting window into a single scorecard. Instead of chasing six separate press releases, you watch EPS surprise, valuation, profitability and price reaction line up in one table, with the trading and investment-banking recovery that defines Q2 2026 sitting right there in the numbers. The template is built entirely on verified MarketXLS formulas, so it refreshes on its own and you spend your time thinking about the reports rather than copying data.
To build your own live financial models on the same engine, explore MarketXLS or book a demo to see how the formulas power everything from earnings trackers to full portfolio models.
Educational content only. Nothing here is investment advice or a recommendation to buy or sell any security. Always do your own research.
