Rent Manager opening balances: properties not in balance

Rent Manager keeps a separate set of books for every property, so a journal has to balance inside each property, not just in total. "Properties not in balance for the journal" means at least one property in your CSV has debits that do not equal its credits, even though the whole file ties to the penny. Subtotal the file by property, find the one with a difference, and split the shared lines (usually the bank line) so every property carries its own side of the entry. Then load balances in a fixed order: properties and units, bank accounts, tenant balances, deposits held, vendor totals, and the opening journal last.

Why a balanced CSV still fails

Rent Manager's Balance Sheet, Profit & Loss and General Ledger reports all run by property or owner. That only works if every transaction line carries a property and every property's ledger balances on its own. A journal entry that moves money between bank accounts or properties is a normal Rent Manager transaction, and the program checks it the way it checks everything else: property by property.

Books from QuickBooks Online or Rentec rarely look like that, because the bank account was never split by property, so your opening file has debits on one property and credits on another.

Find the property that is off

1. Open the CSV in a spreadsheet and add a column for debit minus credit on every line.
2. Subtotal that column by property with a pivot table. Each property should net to zero. The ones that do not are the problem.
3. Check for lines with a blank property, or a property name that does not exactly match the name in Rent Manager. These are easy to miss because the file still totals correctly.
4. Look at lines coded to the management company or to one "main" property. That is where the shared bank account, the escrow account and the equity plug usually sit.

The usual causes

• One bank line for the whole batch: an operating account that holds money for ten properties entered on one property, while receivables, deposits and equity are spread across ten.
• Deposits held coded to the property, with the escrow bank balance coded to the company.
• A due-to and due-from pair that nets to zero across the company but not inside any one property.

Fix it

1. Split the shared line. The bank account gets one line per property, for that property's share of the balance, which is what a property balance sheet needs anyway.
2. Offset with a clearing account. If one property genuinely owes another, add a due-to line in one and a due-from line in the other, and clear it with a real transfer later.
3. Import one journal per property. Slower, but the error becomes impossible.

Do not use the Net Income account on any line. Rent Manager's own year-end guidance warns that a journal entry posted to Net Income shows on the Balance Sheet but not the Profit & Loss.

The cut-over order that avoids the problem

Most people hit the error because they tried to load the opening balance before the pieces it depends on existed.

1. Pick a cut-over date and finish the old system through it: every bank account reconciled, every tenant ledger reviewed, deposits held tied to the escrow balance. The last reconciled balance in the old system is your opening balance.
2. Set up properties, units and owners. Decide unit types first; one park owner was told by a trainer that changing a unit from lot to park-owned home rewrote that unit's history.
3. Build the chart of accounts, then bank accounts. Every bank and credit card account you reconcile is its own general ledger account in Rent Manager. Enter the reconciled book balance at the cut-over date, not the statement balance, then enter outstanding checks and deposits in transit so the first reconciliation can clear them.
4. Load tenants with one balance-forward charge or credit dated the cut-over date. Do not import the ledger history behind it. Prepaid rent goes in as a credit.
5. Enter security deposits held by tenant and unit. The total must equal the deposit liability on the old balance sheet and the escrow bank balance.
6. Enter vendors with year-to-date payments if you convert mid-year, so Rent Manager's vendor and owner 1099 reports are complete at year end. The 2026 threshold is $2,000.
7. Import the opening-balance journal last, for what the steps above did not create: fixed assets, loans, accumulated depreciation, equity. Date it the day before go-live and balance it inside every property.

What to export before the old system goes away

If you are buying a park whose seller will shut down his Rent Manager, or leaving Rentec when the subscription ends, pull these while you still can. Rent Manager report names are given where they exist.

Forum replies to a buyer added move-in and lease dates, rent-raise history and payment history per tenant. All correct. The general ledger detail and the bank reconciliations are the two nobody mentions until the first audit.

Pitfalls

• Importing full tenant ledgers and a balance-forward charge. The balance doubles, or a payment imported without its charge becomes a credit the tenant never had.
• Running two systems in parallel for months. One rent cycle is enough; after that every correction is made twice.
• Not deciding the basis. Rent Manager runs cash and accrual at the same time, and the opening entry must match the basis you report on. On cash basis, receivables and prepaid rent are not on your old balance sheet at all. Settle cash versus accrual before the import.
• Reusing the QuickBooks chart as is. The principles in our Buildium chart of accounts guide apply: few accounts, consistent types, nothing only one person understands.

How to prove the opening balances are right

1. Run the Rent Manager Balance Sheet for all properties at the cut-over date, on the same basis as the old system, and compare it property by property to the old balance sheet.
2. Run the General Ledger from the cut-over date with only the Net Income account included. It should be empty.
3. Compare the tenant balances total to the receivable account, and the deposits-held total to the deposit liability.
4. Reconcile each bank account for the first full month. The outstanding items you entered should clear. For trust accounts, this is the same three-way reconciliation you will do every month from now on.

If all four hold, the conversion is done and the old system can go read-only.

FAQ

Can I put the whole opening balance on one property and sort it out later? Only if you never run a balance sheet, owner statement or 1099 by property. Otherwise those reports are wrong until you move the balances, which is the work you are avoiding now.

Do I enter the bank statement balance or the book balance? The reconciled book balance at the cut-over date, then the outstanding checks and deposits in transit as their own transactions. Enter the statement balance and the first reconciliation is off by exactly those items.

Will Rent Manager's implementation team decide this for me? They show you the screens and the import. Which property owns which balance, and on which basis, is your accountant's call, which is what Rent Manager's own staff told people on the forum.

Key takeaways

• The error is about property-level balance, not the file total. Subtotal by property and the offender shows up.
• The bank line is the usual culprit. Split it by property.
• Load the modules first and the journal last.
• The old system's final reconciliation is the opening balance. Finish it before you start.

We convert property management books into Rent Manager, AppFolio and Buildium, including opening balances and the first reconciliations. If you want a second set of eyes on a cut-over, get in touch.