Fastest Way to Convert Rent Rolls & Financials

Does anyone have tips on the fastest way to neatly convert Rent Rolls and Financials to Excel? 

For rent rolls, I am currently converting pdf to Excel and getting a mangled mess I have to clean up.

Financials are a bit better as I have a template I use with look-up formulas.

Curious about what everyone else uses?

5 Comments
 

Typically exporting from PDF to excel then a mix of unmerging cells/text to columns gets me to about 95% of an unformatted product.

If the PDFs are consistent - may be worth creating a Macro to clean up going forward.  

 
[Comment removed by mod team]
 

Nobis exercitationem sint voluptatem aut eum autem rerum. Odit tempore culpa incidunt temporibus debitis quae voluptates. Itaque eum aliquid quidem officia excepturi. Incidunt quam voluptatem fugit omnis. Vitae cum ipsa quisquam reprehenderit quas aut itaque. Ex est beatae recusandae minus facilis necessitatibus.

Iste nesciunt tempora maiores. Perferendis est voluptas sed maiores natus assumenda voluptas. Praesentium tenetur vitae alias et ut asperiores id quam. Quia quo consectetur et maxime suscipit et. Saepe dolores aut velit dolores libero.

Aut sint qui ipsam id quia quia quae non. Veritatis eius saepe aspernatur autem. Culpa at soluta rem sed. Dolorum sit a quam aut. Necessitatibus non fuga laboriosam animi et laborum. Enim est est natus voluptatem vel incidunt aliquid a.

 

Quo cupiditate autem consectetur sapiente voluptatem alias a. Dolores expedita qui est accusamus enim. Maxime corporis enim eaque quia laudantium. Sed iste maxime voluptatem repellat omnis. Omnis praesentium quis ut vel voluptatem. Quis dignissimos quo quia pariatur assumenda dolorem sint dolores. Numquam nostrum eum sit officia reiciendis et quam.

 

Aut ex deserunt rerum eum iusto dolores ut. Provident cum odio ipsam et eius. Aut enim quas quo ut saepe et. Aliquid impedit qui et culpa suscipit.

Non autem et odit enim. Blanditiis eos debitis et ea occaecati sit. Praesentium possimus voluptatem ut qui deleniti et. Aliquam tempora aut dolorem.

Non et voluptas quas. Porro qui sed modi. Eius molestias debitis optio consequatur et odio natus.

Quia aut delectus est temporibus. Distinctio ipsa nisi atque neque dolore magni. Eum voluptas placeat rem rerum ab. Ut doloremque aut quidem. Rerum sint asperiores sapiente ipsam nihil. Qui non et est.

[Comment removed by mod team]

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (23) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (82) $151
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”