Convert a Bank Statement to Reconcile in Propertyware

Reconciling across properties in Propertyware

Propertyware is property-management software, so a reconciliation there is rarely one plain checking account. A firm carries operating money, owner funds, and security deposits across many properties, and each bank account still has to be reconciled so the ledger matches the bank. Propertyware's reconciliation shows cleared and uncleared transactions and lets you manage each account on its own. Feeding it an accurate list of what actually hit the bank is the starting point, and a PDF statement is not that list until it is converted into structured rows.

The Upload Bank Statement and Match tools

Reconcile in Propertyware includes an Upload Bank Statement tool, and its Match workflow lets you bring your statement in and match its transactions against the register rather than clearing every line by hand. Propertyware compares the two sides and marks what agrees, so the manual clearing is minimized and you focus on the items that do not line up. That comparison is only as good as the statement data you give it, which is where converting the PDF into a clean, sortable file pays off over reading figures off a page.

Why a clean CSV helps the match

The Upload Bank Statement and Match steps work from the transactions in your statement, so the cleaner that list, the better the match. A PDF hides each transaction inside a page layout; converting it pulls them out into rows with a date, an amount, and a description you can save as a CSV. With the statement as structured data you can sort it, scan it, and let Propertyware line it up against the register, instead of comparing a printout line by line and hoping nothing is missed.

Cleared, uncleared, and discrepancies

Propertyware's reconciliation reports separate cleared from uncleared transactions and highlight where a difference remains, which is how you catch a missed entry, a duplicate, or a transposed figure. Most discrepancies trace back to the data going in, so starting from a converted file where every transaction is accurate keeps the uncleared list short and the reconciliation honest. For a firm holding owner and deposit funds, that clean starting point is what keeps each property's books defensible.

Accuracy and privacy

Because property managers reconcile owner and deposit money that has to balance to the bank, every transaction is reviewable in the converter before export so a misread figure does not enter the match. The output arrives as a clean CSV ready to reconcile against. Since a statement holds real account activity, the file is processed to build the CSV and then deleted automatically, with nothing kept on a server afterward.

Frequently Asked Questions