Via the integration with TurboTenant, the system automatically imports a payment transaction as soon as the invoice is electronically paid or manually marked as paid in TurboTenant.
The payment transaction increases the 'Rent' (which recognizes the revenue) or 'Security Deposits Held' account. It is received in either the TurboTenant Electronic Payments account or the TurboTenant Manual Payments account, which are synthetic clearing accounts.
The TurboTenant Integration
When the deposit corresponding to a TurboTenant paid invoice hits your linked bank account feed in REI Hub, they should be booked using the 'TurboTenant Deposit' transaction type. This books a transfer transaction from the TurboTenant Payments account to your bank account, which shows the bank account as the final destination of funds without duplicating the revenue already accounted for through the integration.
However, sometimes the deposits corresponding to paid invoices in TurboTenant are booked as Revenues instead of TurboTenant Deposits (transfers). This is especially the case for deposits corresponding to manually marked as paid invoices in TurboTenant, which results in incorrect and overstated revenue numbers.
The system does attempt to prevent you from booking duplicate revenues. We display a flag on the Revenue transaction type to help prevent double-booking rent, so if you see the notice below when booking a rent deposit, you should likely switch to the TurboTenant Deposit option.
If a paid invoice exists in TurboTenant for the transaction in question, book it in your import feed as a TurboTenant Deposit, and balances will stay nice and clean.
โ
Do not book deposits in your import feed corresponding to paid invoices in TurboTenant as revenues, security deposits, or anything other than TurboTenant Deposits.
How To Identify Duplicate Revenues
Notice on Reports
Many of your reports will show if revenue has been marked twice. Reports like the Net Income by Period, Operating Cash Flow by Period, and Net Operating Income by Period will all show revenue monthly.
If these numbers look higher than anticipated, you can click the blue number that will populate all the transactions totaling that amount.
Filter Booked Transactions
The easiest way to see this is by navigating to your Booked Transactions page from the left-side menu, choosing 'Revenue' for the Transaction Type, and then using the Filter button to choose the 'Rent' account. Once filtered, you will see any transaction that was booked using the 'Revenue' transaction type in detail.
You can set the Partner Payment Account filter on the TurboTenant account screen (Click 'Account,' then 'TurboTenant' from your left-side menu) to focus on either the electronic or manual payments. This will then display a running balance column for that payment type that increases as payments are received and decreases as the funds are transferred.
For electronic payments, we automatically recognize the deposit in your bank account and book it as a transfer from the TurboTenant Electronic Payments account to your bank account. This updates your bank balances appropriately and ensures your revenue is not double booked (transfers do not impact revenues or expenses).
We don't have the same traceability in your bank account for 'manually marked as paid' payments, so we can't automatically book it on your behalf. For deposits in your bank feed that correspond to a paid invoice, you should use the TurboTenant Deposit transaction type to book the transaction. This will book a transfer from the TurboTenant Manual Payments account to your bank account.
How To Fix the Transactions
Generally speaking, you can edit transactions 'within' their transaction type but not between them. So you can edit a revenue transaction type to change the property or revenue account, but you can't change it into an entirely different transaction type like 'TurboTenant Deposit,' which is really a 'transfer between accounts.'
For these situations, we must delete or undo the transaction entirely and re-book it. If the transaction originated in the import feed from a linked bank account, deleting it from the 'Booked Transactions' page, as you see above, would revert to unbooked status in the Import Feed (the underlying imported record from the bank won't be removed).
The easiest way to do this is to find the transaction in your import feed and click the 'View' button on the transaction. That will allow you to view the booked transaction record and the option to 'Undo' it. Click the Undo button and confirm. Then click the Book button on the transaction to start over. Select the new transaction type and save. In these cases, it would be 'TurboTenant Deposit' for rent deposits corresponding to a paid invoice in TurboTenant or 'Transfer Between Accounts' for money moving between two bank accounts in REI Hub.
How to Prevent Future Revenue Duplication
Do Not Book Deposits as Revenue Transactions
If you marked the invoice as paid in TurboTenant, DO NOT record the corresponding deposit as revenue. The revenue has already been recognized, and we don't want to inflate it, so use the TurboTenant Deposit transaction type.
If you try to book a revenue over $100 from a TurboTenant-connected account, the system will display the following flag to help ensure that you do not accidentally double-book your revenues.
Still have questions? Reach out to our Support Team via email at [email protected] or call us at (888)939-6865.