How To Enter Financial Statements Faster
Any tips on excel functions or methods to quickly AND ACCURATELY input financial statements into Excel models?
Trending Content - Investment Banking Forum
| +272 | Earliest you can get fired | 58 | 1d |
| +251 | Investment Banking is Divine | 40 | 1d |
| +214 | Another $115bn Mega deal for these banks. Congrats! | 45 | 1d |
| +213 | US 2027 SA IB worried about background check | 53 | 22h |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 1d |
| +131 | Is UBS really that bad? | 38 | 1d |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 10h |
| +27 | FIG Pigeonholes you - is it true? | 8 | 1d |
| +27 | 2026-27 IB Energy Top Banks | 8 | 1d |
| +24 | How do you manage nerves in IB technical interviews? | 6 | 3h |
Career Resources
FactSet codes
I've found these are often wrong when spot checking though - shares outstanding will be off, enterprise value won't have minority interest or preferreds, etc etc etc.
Bump
data -> export data -> export from PDF
feel like this would be inaccurate as fcuk
BamSec for public US companies
am I doing someting wrong? That shit still take an hour or 2 to plug in historical financials.
BamSec needs an API
Refinitiv has its own excel extension. Capiq has macros that export data too
The closest I’ve gotten is doing the filing wizard on FactSet to have raw output sheet then linking to my groups spread format. Marginally faster and is more open to errors. Still prefer entering manually.
Download financial statement from BamSEC into Excel -> link / copy + paste what you need
I've been using Quill AI - can ask it to pull out the info you want in csv format. You gotta pay for it tho
Deserunt harum voluptatem iusto nam officiis. Harum ut vitae vitae dolores. Explicabo dolores impedit est porro neque accusantium. Enim perspiciatis ad itaque placeat qui blanditiis voluptas. Sapiente beatae aperiam ut quasi eos enim fugit. Fugiat commodi quibusdam autem voluptatem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...