Rent roll PDF → Excel
Convert rent rolls from Yardi, AppFolio, RealPage, Buildium — or any property software, even scans — into clean Excel: every unit, tenant, rent, deposit and balance on its own row. No template setup.
Northbank
Current account · GB29 NWBK 6016 1331 9268 19
STATEMENT
| Date | Description | Out | In | Balance |
|---|---|---|---|---|
| 01/03 | SALARY — ACME LTD | 3,200.00 | 4,061.20 | |
| 03/03 | TESCO STORES 2841 | 84.30 | 3,976.90 | |
| 05/03 | SHELL FUEL BRISTOL | 61.75 | 3,915.15 | |
| 07/03 | RENT — HARBOUR LETTINGS | 1,150.00 | 2,765.15 |
The Excel you get back
| Date | Description | Out | In | Balance | Category |
|---|---|---|---|---|---|
| 01/03/2026 | Salary — Acme Ltd | 3,200.00 | 4,061.20 | Income | |
| 03/03/2026 | Tesco Stores 2841 | 84.30 | 3,976.90 | Groceries | |
| 05/03/2026 | Shell Fuel Bristol | 61.75 | 3,915.15 | Fuel | |
| 07/03/2026 | Rent — Harbour Lettings | 1,150.00 | 2,765.15 | Rent |
Drop your rent roll PDFs or scans
PDF · photo · iPhone HEIC · scan · zip · Word — mix them freely, no sign-up to try
Free to try, no sign-up. Pay $7 for a batch, or sign in for 10 free pages.
How it works
- 1
Drop the scan
A flatbed scan, a phone photo, a fax that became a PDF in 2009. All fine.
- 2
It reads the layout
Columns stay columns. A number in the debit column does not wander into credit.
- 3
Take the table
Excel, CSV or XML — with the amounts as numbers, not as text that looks like numbers.
No text layer needed
Traditional extractors look for text hiding under the image. When there is none — a scan, a photo — they return an empty table. This one looks at the page.
Crooked, creased, badly lit
A receipt photographed at a till is none of the things a parser wants. It is read anyway, because that is the form these documents actually arrive in.
Columns survive
OCR-then-parse flattens a page to a line of words and loses which column a number was in. The layout is read as a layout, so debit stays debit.
Questions people ask
- Can it read a scanned or photographed document?
- Yes. Scans and phone photos are read the way a person reads them — a crumpled receipt or a skewed scan still works, and there is no template to configure for each bank.
- What if one PDF holds many receipts?
- It splits them apart. Fifty receipts scanned into a single PDF become fifty rows; a twelve-page statement stays one document.
- Are the amounts real numbers in Excel?
- Yes. Amounts and balances arrive as numeric cells, so a column sums the moment you open the file.
- How are foreign currencies handled?
- Each amount is converted at the published rate for the date of that transaction — not today's rate. The rate and its date sit beside the figure so you can check it.
- Do I need an account?
- No. Convert a batch, pay once, download it. An account is only for a monthly page allowance.
- Does it work with QuickBooks and Xero?
- Yes. Alongside Excel, you can download a statement as OFX — the standard bank-data format both read — or as a ready-made CSV laid out the way each one expects: Date, Amount, Payee, Description, Reference for Xero, and the three-column Date, Description, Amount for QuickBooks, with money out already signed negative. Invoices and receipts can also come out as UBL XML for an ERP or an e-invoicing system.