Turn a property bank statement PDF into clean spreadsheet rows for Yardi Voyager and Yardi Breeze bank reconciliation, trust accounting, and owner reporting. Built for property accountants, community association managers, and the bookkeepers who close their books by the tenth. Start free, no credit card.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Yardi reconciles by putting a GL column beside a Bank column, and it will not let you post until the Difference field reads zero. Automatic Bank Reconciliation clears the easy matches from a BAI2 file your bank sends, but plenty of community banks and credit unions do not offer BAI2, some charge for the SFTP delivery, and no file covers the periods before the feed existed. In those cases the statement PDF is the only source you have. Upload it here and every deposit, check, transfer, and bank fee comes back as a dated row with amount and running balance, so you can put it beside a Yardi export and find the difference with a formula. Last updated July 2026.
The three column layout is simple enough. It goes wrong when the bank side of the comparison is a document instead of data.
Automatic Bank Reconciliation is built around a BAI2 file. Large treasury banks deliver one by SFTP, often for a fee, while many community banks and credit unions offer nothing beyond a PDF statement and a short online download window.
Even with a good BAI2 file, the matching engine clears the items that agree on amount, date, and reference. The leftovers are the ones you have to chase by hand, and those are the ones that hold up the close.
Yardi will not post a reconciliation while a difference remains, so a single transposed digit or an unposted service charge stops the whole account until you find it.
Operating, security deposit, escrow, and reserve accounts each carry their own bank code, so a manager with fifty owners is closing dozens of accounts a month against dozens of separate PDFs.
Catch up work, a takeover portfolio, or an auditor asking about last year all mean months of statements that no bank file will backfill, whatever your bank supports going forward.
Uncleared checks sitting for 60 or 90 days need aging and a decision, and that is a filtering job, not a reading job.
The bank side of the reconciliation, turned into something you can sort, filter, and subtract.
Every deposit, check, ACH, transfer, and bank charge comes back with its date, description, amount, and the running balance, which is what makes a difference traceable rather than mysterious.
Put the converted statement beside a Yardi transaction export and a lookup formula finds the items on one side and not the other in seconds.
Convert operating, escrow, and reserve statements separately so each reconciliation stands on its own, or roll a full year of one account into a single sheet.
The converter reads the statement document itself, so an account at a community bank that has never heard of BAI2 works exactly like one at a national treasury bank.
An .xlsx workbook for the reconciliation working paper, or a CSV for owner reporting and downstream imports.
Nothing connects to your bank or to your Yardi database. You upload a statement you already have and download a spreadsheet.
The order that drives the difference to zero without reading the PDF twice.
Upload the month end PDF for the bank code you are closing and get back dated rows with amounts and the running balance.
Tip: Convert every trust account, not just the operating account.
Export the Yardi transaction list for the same GL cutoff period and match the two by date and amount. Items on one side only are your reconciling items.
Tip: Sort both by amount to surface duplicates fast.
Mark the matched items cleared, post the genuine bank items you had not recorded, and the Difference field should fall to zero.
Tip: Bank service charges and interest are the usual missing entries.
Anyone closing a real estate book where the statement is a PDF and the deadline is the tenth of the month.
Close operating and security deposit bank codes across a portfolio without keying deposits from a printed statement.
Reconcile association operating and reserve accounts and answer board questions from a sortable file rather than a PDF.
Handle several Yardi databases a month, including the takeover portfolios that arrive as a folder of statements and nothing else.
Test trust account compliance where state rules require that client funds reconcile to the penny every month.
You pick the bank code, enter a GL cutoff date, and type the ending balance from the bank statement. Yardi then shows a GL column and a Bank column side by side: the GL side totals the cash accounts tied to that bank code, and the Bank side starts from the ending balance you entered and adjusts for outstanding checks, deposits in transit, and reconciling items. You work through deposits, checks, other items, bank reconciling items, and book reconciling items, clearing what appears on the statement. The reconciliation cannot be posted until the Difference field is zero.
Yardi imports bank data as a structured file, not as a PDF. Automatic Bank Reconciliation reads a BAI2 file and auto clears transactions that match the GL on amount, date, and reference, and the Voyager Bank Book module also handles formats such as MT940. What Yardi will not do is read the statement document your bank puts in online banking. If your bank does not publish BAI2, or you are closing a period that predates the arrangement, converting the PDF gives you the same rows in a spreadsheet so you can do the comparison yourself.
| What you have | Does Yardi read it | Practical route |
|---|---|---|
| BAI2 file from the bank | Yes, this is what ABR is built for | Import it and clear the leftovers by hand |
| MT940 file | Handled by the Bank Book module | Import, or convert to a sheet for review |
| PDF statement | No | Convert to Excel and compare against a Yardi export |
| Online banking CSV download | Not a native reconciliation format | Usable, but the window is short and the balance is often dropped |
| Scanned or mailed paper statement | No | Convert the scan, then reconcile from the rows |
Automatic Bank Reconciliation is the Voyager feature that takes a BAI2 file from your bank and clears the transactions that already agree with the general ledger, leaving you to deal with the exceptions. It saves real time on high volume operating accounts. It also depends entirely on the bank supplying a clean file on a schedule, which is why it tends to cover the big treasury relationships in a portfolio and not the small community bank account attached to one association.
A non zero difference means something sits on one side and not the other. The usual causes are a bank service charge or interest posting that was never entered, a transposed digit in a keyed amount, a rent batch recorded twice or recorded but never banked, or a GL cutoff date that pulls in transactions from the wrong period. Working from a converted statement makes each of these a sort or a subtraction instead of a page by page read.
| Difference you see | Usual cause | Fix |
|---|---|---|
| Small odd amount, often under $50 | Bank service charge, wire fee, or returned item fee never posted | Post it as a bank reconciling item and clear it |
| Difference divisible by nine | Transposed digits in a keyed amount | Compare amounts against the converted statement column |
| Difference equals a deposit exactly | Rent batch posted twice, or recorded but never deposited | Sort both lists by amount and look for the pair |
| Everything looks right but the totals are off | GL cutoff date pulling the wrong period | Reset the cutoff to the statement end date and resubmit |
| Old uncleared checks piling up | Checks issued and never presented | Age them, then void or escheat under your state rules |
| Prior month no longer balances | A transaction was edited after that period was reconciled | Re-tie the earlier month before closing the current one |
Property management runs client money, so close enough is not a standard anyone accepts. Most states require that funds held for owners and tenants reconcile exactly every month and that no individual property goes negative inside a pooled account. In Yardi that means reconciling each bank code on its own rather than in aggregate, and being able to prove the position for a single owner or association if a board or a regulator asks. Once the statement is a spreadsheet you can filter by description or amount and answer that question directly.
Onboarding a portfolio from another manager usually arrives as a folder of PDFs and a spreadsheet of balances, with no bank file history and no ledger to inherit. The practical route is to convert every statement for the period you are picking up, build the opening position from the running balance, and reconcile forward month by month until you reach the current period. It is tedious the first time and then it is done, and a converted set of statements is also what an incoming owner or an auditor will want to see.
The same converted statement usually gets used twice, once for the tie out and once for owner reporting or a tax schedule at year end. If your bank does publish a treasury file, the BAI to Excel converter and the MT940 to Excel converter turn those into readable sheets too. Managers on other platforms can start from the AppFolio bank statement converter or the Buildium bank statement converter, and the general workflow for the role is on the bank statement converter for property managers page. Association work that needs a per association tie out is covered by the HOA bank reconciliation page, and client funds testing is on the three way trust account reconciliation page. If the books also run in QuickBooks alongside Yardi, the rows can be pushed across with a bank statement to QuickBooks converter instead of being keyed twice. For a national bank account, start from a page like the Chase bank statement to Excel converter, or use the general bank statement converter for any account.
Choose the bank code, set a GL cutoff date, and enter the ending balance from the statement. Yardi shows a GL column against a Bank column, and you clear deposits, checks, and other items that appear on the statement until the Difference field reaches zero, at which point the reconciliation can be posted.
No. Yardi reads structured bank files such as BAI2 for Automatic Bank Reconciliation and MT940 in the Bank Book module, not the PDF statement your bank publishes online. Converting the PDF gives you the same transactions as spreadsheet rows to compare against a Yardi export.
It is the Voyager feature that imports a BAI2 file from your bank and automatically clears transactions matching the general ledger on amount, date, and reference. It shortens high volume operating account reconciliations, and it leaves the exceptions for you to work through by hand.
Yardi blocks posting while the Difference field is anything other than zero. The cause is usually an unposted bank fee or interest entry, a transposed digit, a deposit recorded twice or never banked, or a GL cutoff date that is pulling in the wrong period.
That is common with community banks and credit unions, and some larger banks charge for the SFTP delivery. In that case you reconcile from the PDF statement, which is exactly what the converter turns into dated rows with amounts and running balances.
Yes. The converter produces a spreadsheet of the statement, so it is useful on both. Breeze and Voyager differ in how much they automate, but both still require you to match the statement against the ledger and drive the difference to zero.
Yes, and takeover portfolios are the usual reason. Upload the statements for the period you are picking up and they come back as one date ordered sheet with running balances, which is how you rebuild an opening position with no ledger to inherit.
No. Nothing connects to Yardi or to your bank. You upload a statement PDF you already have and download a spreadsheet, then do the comparison yourself inside Yardi.
The same workflow on AppFolio.
The same workflow on Buildium.
Built for rental portfolio bookkeeping.
Prove client funds tie out to the penny.
Read a BAI2 treasury file as a sheet.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
