Turn a property bank statement PDF into clean spreadsheet rows for AppFolio reconciliation, trust accounting, and owner reporting. Built for property managers, HOA managers, and the bookkeepers who close their books. Start free, no credit card.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
AppFolio reconciles by having you enter the statement ending balance and then tick off cleared items against the AppFolio ledger until the ending balance, the cleared balance, and the adjusted cash balance agree. That triple tie out is a comparison between two lists, and one of them is a PDF you cannot sort or filter. Upload the statement here and every deposit, check, and fee comes back as a dated row with amount and running balance, so you can line it up beside an AppFolio ledger export and find the missing or duplicated item in a formula instead of by eye. Last updated July 2026.
The process itself is straightforward. It goes wrong when the statement side of the comparison is a document rather than data.
AppFolio connects to a set of partner institutions, including Alliance Association Bank, Pacific Premier Bank, First Citizens Bank, and SmartStreet powered by Banc of California. Accounts held anywhere else are reconciled from the statement by hand.
Operating, escrow, security deposit, and reserve accounts each reconcile separately, and a manager with fifty owners can be closing dozens of accounts every month against dozens of PDFs.
The reconciliation will not finalize until the ending balance, cleared balance, and adjusted cash balance match exactly, so one transposed digit means scanning the whole statement again.
A rent batch posted twice, or a deposit recorded in AppFolio that never cleared the bank, is invisible on a printed page and obvious the moment both sides are columns you can total.
Catch up work, a takeover portfolio, or an owner asking about last year all mean months of statements that no feed will backfill, whatever the bank supports going forward.
Owners and HOA boards ask about specific line items, and answering from a PDF means reading rather than filtering.
The bank side of the reconciliation, turned into something you can sort, filter, and subtract.
Every deposit, check, ACH, transfer, and bank fee comes back with its date, description, amount, and the running balance, which is what makes a tie out checkable.
Put the converted statement beside an AppFolio ledger 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 stays clean, or convert a year of one account into a single sheet.
The converter reads the statement document, so an account at a community bank or credit union with no AppFolio integration works exactly like one at a partner institution.
An .xlsx workbook for the reconciliation working paper, or a CSV for owner reporting and downstream imports.
Nothing connects to your bank or your AppFolio database. You upload a statement you already have and download a spreadsheet.
The order that gets the triple tie out to balance without reading the PDF twice.
Upload the month end PDF for the account 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 AppFolio transaction list for the same 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 in AppFolio, post the genuine bank items you had not recorded, and the ending, cleared, and adjusted cash balances should agree.
Tip: Bank fees and interest are the usual missing entries.
Anyone closing a property management book where the statement is a PDF and the deadline is the tenth of the month.
Close operating and security deposit accounts across a portfolio without keying deposits from a printed statement.
Reconcile association operating and reserve accounts and answer board questions with a sortable file rather than a PDF.
Handle several client 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.
Open the reconciliation from the Accounting area, choose the bank account and the statement period, and enter the ending balance from the bank statement. Then tick off each deposit and payment that appears on the statement so it is marked cleared, review anything still uncleared, and finalize once the ending balance, the cleared balance, and the adjusted cash balance all agree. The software handles the arithmetic. The work is the matching, and that is a comparison between the AppFolio ledger and a PDF.
The triple tie out is the point where three figures agree: the ending balance you typed from the bank statement, the cleared balance AppFolio calculates from the items you ticked, and the adjusted cash balance for the account. When all three match the reconciliation is complete and the account is proven. When they do not, something is on the statement and not in the ledger, in the ledger and not on the statement, or recorded twice, and finding which is far quicker when the statement is rows you can filter.
| Difference you see | Usual cause | Fix |
|---|---|---|
| Small odd amount, often under $50 | Bank service charge or returned item fee never posted | Post the fee to the account 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 |
| 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 |
AppFolio pulls transactions through bank connections with partner institutions rather than by taking a statement file you upload, and it has partnered with banks including Alliance Association Bank, Pacific Premier Bank, First Citizens Bank, and SmartStreet powered by Banc of California for automated bank statement and reconciliation features. If your operating or trust account is at a bank outside that group, or you are reconciling months that predate the connection, the statement PDF is the source you actually work from. Converting it does not import anything into AppFolio. It gives you the second list in a form you can compare against the first.
Property management runs client money, so the standard is not close enough. Most states require that funds held for owners and tenants reconcile exactly every month and that the account never goes negative for any individual property. That means reconciling each trust account separately rather than in aggregate, and it means being able to prove the position for a single owner 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 instead of paging through a PDF.
Onboarding a portfolio from another manager usually arrives as a folder of PDFs and a spreadsheet of balances, with no feed 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 you are also running books in QuickBooks alongside the property software, the rows can be pushed across with a bank statement to QuickBooks converter instead of being keyed again. Managers on other platforms can start from the Buildium bank statement converter, and the general workflow for the role is on the bank statement converter for property managers page. Community association work that needs a per association tie out is covered by the HOA bank reconciliation page, and if the statement is at a national bank you can start from a page like the Chase bank statement to Excel converter or use the general bank statement converter for any account.
Start the reconciliation from Accounting, pick the bank account and period, and enter the ending balance from the statement. Mark each deposit and payment that appears on the statement as cleared, review what is left uncleared, then finalize once the ending balance, cleared balance, and adjusted cash balance agree.
It is the point where the statement ending balance, the cleared balance, and the adjusted cash balance all match. AppFolio will not let you finalize until they do, which is why an unexplained difference of a few cents can hold up an entire month end close.
AppFolio brings in transactions through bank connections with partner institutions rather than through a statement file you upload. For accounts at other banks, or for periods before the connection existed, you reconcile from the PDF statement, which is what the converter turns into usable rows.
AppFolio has partnered with institutions including Alliance Association Bank, Pacific Premier Bank, First Citizens Bank, and SmartStreet powered by Banc of California for features such as automated lockbox, bank statements, and reconciliation. Accounts elsewhere are handled from the statement.
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.
Yes. Convert each association account separately so every reconciliation stands on its own, which is what a board or an auditor will expect to see. Reserve accounts convert the same way, including interest postings.
Most often a bank service charge or returned item fee that was never posted in AppFolio. If the difference is divisible by nine it is usually transposed digits, and if it equals a deposit exactly it is usually a rent batch recorded twice or recorded but never banked.
No. Nothing connects to AppFolio or to your bank. You upload a statement PDF you already have and download a spreadsheet, then do the comparison yourself inside AppFolio.
The same workflow on Buildium.
Built for rental portfolio bookkeeping.
Association operating and reserve accounts.
Prove client funds tie out to the penny.
From the same family of tools
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 |
