How to Troubleshoot and Resolve Owner Balance Discrepancies in Rentvine
Owner balance discrepancies in Rentvine can arise from various issues, such as suppressed fee mismatches, escrow mismatches, or reserve settings. This guide outlines common problems and provides actionable steps to resolve them.
Common Issues and Resolutions
1. Suppressed Fee Mismatches
Suppressed fee mismatches can distort owner statement balances and available distribution amounts.
Symptoms: Differences between owner statement ending balances and available distribution amounts, or small negative balances on statements.
Resolution: - Open the Diagnostics page for the affected portfolio. - Identify positive or negative suppressed fee mismatches. - Correct the mismatches and regenerate the owner statement to align balances.
2. Escrow Mismatches
Escrow mismatches occur when funds are incorrectly classified as escrow, making them unavailable for distribution.
Symptoms: Ledger shows sufficient funds, but the Pay Owners page shows nothing to distribute.
Resolution: If the bank transfer did not occur in real life, void the transfer in Rentvine. - If the transfer did occur, record an offsetting transfer to move funds out of escrow.
3. Owner Credits and Refunds
Owner credits do not carry cash value and cannot be paid out directly.
Symptoms: Owner credits appear on the ledger but cannot be distributed.
Resolution: Apply credits to offset bills with matching GL codes and payees. - For refunds, manually record the inflow and issue a payment to the owner. Void related credits to prevent future application
Additional Tip: To reimburse an owner for multiple items, transfer the total amount from your business operating account to the trust account, record a single Other Receipt in Rentvine for the total, and distribute funds to the owner accordingly. Void any unnecessary vendor credits to prevent future application.
4. Reserve Settings
Reserves can withhold funds from distributions.
Symptoms: Distributions are lower than expected due to reserve amounts.
Resolution: To release reserves, clear or reduce the reserve amount in the property settings. - For temporary holdbacks, set an additional reserve amount and update it back to $0 after the distribution.
5. Undeposited Funds
Tenant receipts not included in a bank deposit can create holds.
Symptoms: "Additional Holds" amounts match undeposited funds.
Resolution: Record the corresponding bank deposit to release the hold and make funds available for payout.
6. Negative Balances After Distributions
Negative balances may appear due to prepayment allocations or mismatched billing.
Symptoms: Statements show negative balances after distributions.
Resolution: - Regenerate statements for the correct date range. - Run a Prepayment Report to identify and apply prepayments.
7. Voiding Uncleared Checks
Uncleared checks migrated as balance-forward journal entries can cause discrepancies.
Symptoms: Ledger shows uncleared checks affecting balances.
Resolution:
Create reversing journal entries by flipping the original debits and credits.
Use the same accounts and details as the original entry to zero out the balance while maintaining a clear audit trail.
8. Reconciling Operating and Ledger Balances
Discrepancies between the operating balance on the Pay Bills screen and the ledger can occur.
Symptoms: Operating balance differs from ledger balance.
Resolution:
Use the dropdown on the Pay Bills screen to view Available Funds (bank balance, undeposited funds, liabilities).
Run a Bank Balance Breakdown Report for the specific bank account and portfolio.
Reconcile by adjusting the bank balance with undeposited funds and liabilities.
9. Adjusting Returned Bill Payments
Returned bill payments can create ledger discrepancies.
Symptoms: Ledger shows original payment, return/NSF, and reissued payment.
Resolution:
Review the bill’s timeline and ledger line items to understand the adjustments.
Ensure the corrected payment is accurately recorded.
10. Recording Bills for Portfolios with Insufficient Funds
Portfolios with insufficient funds can cause temporary negative balances.
Symptoms: Unable to record bills due to insufficient funds.
Resolution:
Adjust the portfolio’s Override Amount to allow a temporary negative balance.
Offset the balance when the portfolio receives income.
Best Practices
Regularly review Diagnostics for suppressed fees or escrow mismatches.
Verify transaction classifications to ensure accurate ledger balances.
Adjust reserve settings as needed to align with distribution goals.
Record Zelle expenses individually to ensure one-to-one reconciliation with bank activity.
By following these steps, you can effectively troubleshoot and resolve owner balance discrepancies in Rentvine.