Tenant Pro Support FAQ
How do I perform a bank reconciliation?
Printing Reconciliation Reports
Clicking on the Print button will generate a report based upon the selection chosen. These reports will be shown in the Report Viewer window which gives you options such as printing and exporting.
Identifying Transactions in Bank Reconciliation Reports
When you print a bank reconciliation report for either cleared or uncleared items it will display codes to identify the source of the transaction.
Verifying your General Ledger Bank Balance
The Bank Reconciliation Summary Report you printed will make reconciliation a simple process.
1. Compare the figure on the Bank Reconciliation Summary Report entitled “Current Bank Balance” with your current General Ledger balance.
If the two figures match, you are reconciled.
Making Adjusting Entries
You may find transactions on your bank statement that do not appear in the Bank Reconciliation window. Items such as bank service charges, ATM withdrawals, insurance premiums, or any other bank entries such as NSF returned items and their corresponding fees may have never been entered into Tenant Pro 7. You can do that during the bank reconciliation process by selecting the Add Transactions button. This will open a window that gives you multiple options.
If you simply need to add a Service Charge or Interest Earned you can Add a “Quick” Transaction to your Bank Account. Just select the checkbox for the type of transaction you want to add, and then select a Property to tie it to and enter the other information. Click Create Transaction to automatically add a Miscellaneous Bank Transaction using the information you just entered.
To add more complex transactions you will need to use another entry window. After selecting Add a Normal Transaction you can click one of the four available buttons to open the necessary window and add a transaction.
Reviewing Reconciliation History
The History button on the Bank Reconciliation window will allow you to review the reconciliation records that have already been created. You can review what the Opening and Ending Balance was for each record.
Reconciling After Skipping More Than One Month
If you have gone more than one month without reconciling, you should reconcile each month separately, starting with your earliest statement since you began using Tenant Pro 7, and working through your most recent statement.
Reconcile each month in order, following the instructions for “Performing the Reconciliation,” mentioned above. Repeat the process for each following month, using your bank statements in order.
Reconciling Transactions Added to Previous Periods
You may need to enter transactions for periods that you have already reconciled. Any transaction that includes a bank account and that has not already been marked as Clear in your bank reconciliation process will appear for reconciliation when you next perform that function. If the transaction actually cleared the bank, but you hadn’t recorded it, you should have been out of balance during your last reconciliation. It will be necessary for you to correct this by reversing whatever transaction you performed to bring things into balance during the last reconciliation.
Unlocking Transactions and Editing Bank Reconciliations
When you complete a Bank Reconciliation by clicking the Done button, all the transactions included in that reconciliation will be locked. Tenant Pro will not allow you to save changes to those transaction records and they will have the following message:
LOCKED: You cannot save changes to this transaction
This helps ensure that nothing changes once you have reconciled your accounts. Occasionally, you may need to unlock a reconciliation to make a minor change to a transaction. You must be aware that making any change to a previously cleared transaction can have an effect on your Opening Balance for subsequent bank reconciliations. The Opening Balance displayed will always be the Ending Balance reconciled on the last statement. If you need to make a change to correct financial information, such as correcting and adjusting an entry it would be better to correct the issue by making a new adjusting entry. If you still think it is necessary to edit your reconciliation record or one of the transactions in it, complete the following steps:
- Open the Bank Reconciliation window.
- Click the Modify button. This will unlock the reconciliation record, as well as all the transactions contained in it.
- Make your change to the bank reconciliation record, or to the other transaction you plan to change (in the window for that transaction). You can quickly go to another transaction record by double-clicking on that transaction from the Bank Reconciliation window.
- When finished click Done. This will save your changes to the reconciliation record and relock the associated transaction records.
If you have changed the amount that is cleared, you may need to make a change to the Ending Balance or Opening Balance of another record. To do so, simply click in the Opening Balance field and click Save after making the change.
Opening the Bank Reconciliation Window
To open the Bank Reconciliation window, select Accounting>Bank Reconciliation.
Preparing for Reconciliation
Before you begin, please understand that the only way to arrive at an accurate ending balance for your bank account is to begin with an accurate opening balance. The reconciliation function will take your bank statement’s ending balance and make adjustments to it in order to arrive at the balance in the General Ledger. These adjustments come primarily from checks you have written and deposits you have made of which the bank has no knowledge. These items are called “uncleared.” “Uncleared” or “outstanding” transactions are divided into two groups: those within the ending date of your bank statement, and those beyond the ending date of your bank statement.
Prior to reconciling, you should review your bank statement for any transactions that are not in your current records. Examples of items that you might not have entered are bank service charges, interest earnings, or an automatic withdrawal of an insurance premium. Create General Journal entries or Miscellaneous Transactions entries for these transactions.
Your First Reconciliation
Your first reconciliation may take some extra time, as you must enter any uncleared transactions from your last bank statement. You may have already done this as part of your Property Beginning Balance entries. These entries may take the form of individual outstanding checks and deposits, or may be part of a lump-sum journal entry created as the beginning balance in your cash account.
The Opening Balance field represents the sum of all transactions previously marked as “Cleared” during bank reconciliation. The Opening Balance field will show a zero for your first reconciliation. The property beginning balances will be showing as uncleared items which you will need to clear to bring your first reconciliation into balance. Successive opening balances will display the total of all cleared transactions, shown as the prior month’s ending balance.
Performing the Reconciliation
When you are ready to reconcile your bank account, use the following steps to clear entries in Tenant Pro 7 that appear on your bank statement. You may use the Add Transaction button for entering additional transactions during reconciliation. If you need to close the Bank Reconciliation window before you are finished, any changes that you have made will be retained, however.
- Open the Bank Reconciliation window
- Click Add.
- Select a bank account from the Account to Reconcile drop-down list. You will immediately be required to save the transaction in order to distinguish this reconciliation from others for this bank account.
- Verify the Opening Balance, which should be the ending balance from your last month’s bank statement. If you are performing your first reconciliation, your beginning balance will be zero so it can be modified as needed.
- Enter your Ending Balance from Bank Statement.
- Enter the closing date of your bank statement in the Statement Date field. The Show Transaction Thru field will pick up the same date, eliminating unnecessary entries dated after the statement ending date.
- Click Save. The record is now saved and ready for you to mark the transactions that have cleared.
- In the two scroll boxes titled Deposits and other Increases to Cash and Checks and other Decreases to Cash, mark the Clear checkbox for the transactions that appear as cleared on your bank statement. If you wish to remove a checkmark, click on the box item again. Use the Select All button if you wish to checkmark all transactions. After using the Select All button, it changes to Clear All for your convenience.
- If you need to stop before you have finished and you plan to complete the reconciliation at a later time, click Leave. This will allow you to save where you are without completing the reconciliation. Open the window again later to finish where you left off.
- After all cleared items appearing on your bank statement are marked, the Difference field should show $0.00. Click Done to complete the reconciliation.
How do I install Tenant Pro on my Windows Vista®, Windows 7®, or Server 2008® operating system?Windows Vista/Windows 7/Server 2008 and Tenant Pro 7
User Account Control
Windows Vista and Windows 7 has very strict security features, even when a user is set up as equivalent to an Administrator. For this reason almost anything you do relating to installations and the like, will generate a message asking if you are sure you want to Allow. This feature is designed to prohibit any uninitiated items from running on your computer. This can, however, block access to the SQL Server that Tenant Pro uses to store the database on your computer, as well as cause data corruption, so it is important that you disable it. This feature is the User Account Controls (UAC).
**Server 2008 users, follow instructions for Windows Vista**
To turn off your UAC, do the following:
1a. VISTA USERS: Start button>Control Panel>User Accounts>Turn User Account Control on or off.
1b. WINDOWS 7 USERS: Start button>Control Panel>System and Security>Change User Account Control Settings
2a. VISTA USERS: Uncheck the box to turn off UAC. Click OK.
2b. WINDOWS 7 USERS: Drag the bar all the way to the bottom, to “Never Notify.” Click OK.
3. A window will appear requesting that you Restart Now. Proceed with the restarting of your machine.
4. After restarting, you may proceed with your Tenant Pro 7 installation.
Installing Tenant Pro 7 on Vista and Windows 7
When you are installing Tenant Pro 7 on a computer with Windows Vista or Windows 7, it is important to initiate the installation in one of the following two manners:
1. From CD: When you insert the Tenant Pro 7 CD, a splash screen may launch automatically. You will need to close this screen. Then click the start button (round Windows button in lower left corner) and click on Computer. Next, right click on the CD drive which has the Tenant Pro 7 CD and click on Explore. You will see some files and you will right click on the Setup file. This will begin the installation of Tenant Pro 7.
During the Installation of Tenant Pro 7 you will be prompted to install the .NET Framework 1.1 as well as the Service Pack for .NET Framework; click OK. It will then prompt you again, asking if you want to install the .NET Framework. Click yes to allow. You will also be prompted to agree to the terms of installing the .NET Framework, required for installation. Throughout the installation of the .NET Framework you may have to reboot your computer – click Yes to allow. When rebooted the installation should pick up where it left off. It is possible that you will have to reboot multiple times.
Opening Tenant Pro 7 in Windows Vista and Windows 7
After you have installed Tenant Pro 7 you will need to perform one additional task to ensure that the program will open with Vista properly every time. First you will right click on the Tenant Pro 7 icon on the desktop (or wherever you normally open Tenant Pro 7). Then click on Properties. Next you will need to click on the Compatibility tab and under “Privilege Level” check the box “Run this program as an administrator.” Select OK to close the window. From now on, simply double click on the Tenant Pro 7 icon and it will automatically run as administrator which is required in Windows Vista.
I purchased the Quickbooks® add-on for use with my Tenant Pro – how do I make them work together?QuickBooks Integration with Tenant Pro
Activating Accounting Integration in Tenant Pro:
NOTE: The Quickbooks add-on is beneficial to those who are already using Quickbooks to track their accounting transactions. Only tenant charges and tenant payments will be exported from Tenant Pro, into Quickbooks, with the Quickbooks add-on for Tenant Pro.
Serial Number Window
For the Accounting Integration feature to be fully functional you must first activate this option in the Serial Numbers window, as outlined below.
- Go to Setup>Serial Numbers.
- Enter the appropriate serial number from your License Certificate into the QuickBooks field.
- Click Save.
Tenant Pro allows you to choose which property’s financial data will be exported to QuickBooks. That selection must be noted in the Property window for each participating property.
- Click on the Preferences icon.
- Click on QuickBooks Integration.
- Click to place a checkmark in the Integrate with QuickBooks field.
Limit To Transactions After Date
The date entered here should be the starting date for any periods that you want to include in the export. When exporting the system will automatically check for duplication and will not re-export duplicate data, so there is no need to continually change this date for future exports. If an edit alters data that has already been exported, the next update will include a transaction for the difference, either plus or minus, from the original exported transaction.
QuickBooks Update Reminder
If you want Tenant Pro to offer a reminder to run a QuickBooks update, place a check in the appropriate checkbox and enter a number in the Reminder Frequency (In Days) field. Your reminder will be included on the Reminders List any time there are transactions that have been entered and not yet exported within the number of days entered. (The Reminders List can be set to automatically display when you open Tenant Pro by clicking on Reminders in the Preferences list and checking the box to activate.)
Summarize Entries When Exporting
When transactions are exported from Tenant Pro to QuickBooks, you can choose to show each individual tenant charge and tenant payment transaction or you can simplify your records by exporting only the sum of each general ledger account with activity. Since Tenant Pro already retains a detailed transaction history, the default preference will be to send only a sum for each account. If you prefer to see a transaction level detail in QuickBooks, simply uncheck the Summarize Entries When Exporting checkbox.
By default, all properties in Tenant Pro are activated to export all income and expense account data. If you do not need all property data to be exported, you must de-activate the properties that are not needed.
- Open the Properties window with the desired property displayed. (Click the Properties icon and select the appropriate property from the list.)
- Click to remove the checkmark in the Export to QuickBooks field.
- Click Save.
- Repeat for each property that you do NOT want to export to QuickBooks.
In order to integrate, you must be running one of the following versions of QuickBooks: QuickBooks Pro, or QuickBooks Premier 2002, 2003, 2004, or 2005 (for Windows.) Your QuickBooks program has to be installed on your local machine and not on a server to successfully link to Tenant Pro.
- While Tenant Pro is still open and running, open a valid QuickBooks data file that you want to integrate with Tenant Pro.
- If you have multiple users, you must switch to single-user mode.
- If you operate on an accrual accounting basis, create a new account titled “Tenant Receivables” if one does not already exist. You must set this up using the “Other Current Asset” account type.
- Go back into Tenant Pro to the Preferences window and double-click on QuickBooks Integration then click on QuickBooks COA Mapping. That will trigger a connection between the two applications, causing a window like the one shown below to display in QuickBooks, and alerting you to the fact that another software application is trying to access your QuickBooks data file. Click on Yes, Always.
- You will receive a secondary warning message that Tenant Pro does not have a “signed digital certificate.” It is not needed. Click on Yes.
NOTE: TROUBLESHOOTING TIP: The message asking you if Tenant Pro can access QuickBooks will not appear if the Preferences window is open in QuickBooks (such as in step 8). If you are not prompted with this question make sure that the Preferences window in QuickBooks is closed, then go to Tenant Pro and click on one of the QuickBooks Integration preference windows to re-send the connection message.
- In QuickBooks go to Edit>Preferences from the Main Menu.
- On the left side is a list of icons. Click on “Integrated Applications.”
- Click on the “Company Preferences” tab.
- Verify within QuickBooks, that the Preference setting now includes Tenant Pro in its list of applications that will be allowed access to your QuickBooks data file. Click OK when you are finished.
End of Year Processing in Tenant ProEnd of Year Processing
In Tenant Pro 7, a “Property Close” can be done at any time. Use the Property Close command when all transactions for the year have been entered for the properties and you are ready to close your books. The Property Close command has no impact on your tenant ledgers, retaining all tenant records as they existed from the time the tenant moved in. Before proceeding with either form of property close procedure, you should make a backup copy of your data file.
Procedures to Complete Prior to Property Closing
You can continue with your day-to-day operations until ready to perform the close for your properties. All dates will be recorded appropriately, even after closing takes place.
There is no need to worry about the non-reversible affects of the property close feature because Tenant Pro 7 will allow you to make adjusting journal entries to modify the new year’s beginning balances if you have already closed your books. For example; if your accountant is reviewing your books, but won’t have the adjusting journal entries ready until after you have closed your year, you can go ahead and enter these transactions as General Journal entries that have any date up to the last day of the previous year.
Determine Which Properties will be Closing
When you perform an Annual Closing, the properties affected are only those which have a Current Fiscal Year Start Date (as shown in the Properties window) which is the same as that entered in the Property Close window. For example, only those properties using the calendar year (Jan-Dec) as their fiscal year will need to be prepared for closing when a January 1 date is entered.
Enter Closing Transactions
Closing transactions should be entered prior to executing the Property Close function. Some examples of closing transactions are journal entries for interest, amortization and depreciation.
Print Financial Reports
Tenant Pro 7 will let you print reports regardless of the fact that you have closed the property or period. If you want a paper history prior to the closing, then print reports in advance of the Close Property function.
Some reports you might consider printing are the detailed General Ledger, the December Balance Sheet and Operating Statement. You may also find it informative to print a 12 month Operating Statement. We suggest you consult with your tax accountant or CPA to help determine the financial reports that would be most useful to you. If you find later that you need a report you originally neglected to print, Tenant Pro 7 will still allow you to print it at that time.
Businesses are responsible to prepare IRS Form 1099 to any vendor or owner whose payments for the year total $600.00 or more. Typically, IRS Form MISC is used. Tenant Pro will print the necessary information on pre-printed IRS approved forms which can be purchased from Tenant Pro Forms Division at 800-544-3427.
To produce 1099s to Vendors, the Vendor window must be marked to Generate 1099 Forms. A valid taxpayer ID number for both Vendors and Owners will be required. These will need to be entered in the Vendors and Owners setup windows. Totals for 1099s are always based on a calendar year regardless of the fiscal year for your properties. It is possible to print 1099s either before or after you perform an annual closing.
- From the main menu, select Reports>Vendor Reports.
- Select Owner 1099 or Vendor 1099 as appropriate.
- Select Owners or Vendors for which 1099s are to be printed.
- Click View. You may want to print this to blank paper to verify proper alignment prior to printing on the actual 1099 forms.
- Make alignment adjustments, as needed.
- Click Print.
Backup Your Data File
We cannot stress enough the importance of making a backup copy of your data file prior to performing your end of year close. The purpose of this is to retain a historical record of the financial standing of your managed properties at a fixed point in time, namely: year end.
NOTE: We suggest that you make a minimum of two backup copies. One copy should be made to your hard drive and the other copy should be made to disk or tape. The hard drive copy is recommended as a convenience, because you may wish to extract detailed information from a copy of your old year data file. This will allow you an easy way to create reports, to print 1099s, and to make prior year adjustments after closing.
Performing Your Property Close
When all procedures to prepare for your year-end close have been finished, you may begin the actual processing.
NOTE: Before beginning, make sure that you are in the correct data file. You do not want to perform the End of Year closing procedure on the backup copy of the data file. The End of Year close must be performed on all data file(s) that you will continue to work from.
From the main menu, select Accounting>Property Close.
- Select Annual Closing or Periodic Closing.
- Annual Closing moves the Current Fiscal Year Began date of the property forward one year and updates the Year-to-Date totals on the tenant and vendor ledgers. This will occur for every selected property with a Current Fiscal Year Began that matches the date entered.
- Period Closing closes (locks) the financial transactions through the desired date for all selected properties. This may be done in conjunction with the annual closing to lock all entries for that annual period or at any other time you deem necessary.
- Enter the date.
- For Annual Closing this will be the Current Fiscal Year Began date for the properties you want to close. If you are unsure of this date, go to Setup>Property and look at the Current Fiscal Year Began field to identify the appropriate date. Tenant Pro allows you to operate several different fiscal years, but the only properties that will close, will be those that correspond to the date entered in this field.
- For Periodic Closing, it will be the date of the last day that you want to close (lock the transactions.)
- Enter your property selection. When selecting Annual Closing, All Properties refers to all properties whose current fiscal year start date corresponds to the date you entered in the uppermost field and which are NOT designated as “Inactive.” If you want to include Inactive properties, you must click to place a checkmark in the appropriate box. If you are not prepared to close all properties with corresponding dates, you must select from a list of properties.
- 4. Click Close Properties to process. When it is finished, a message will tell you how many properties were closed.
The following screenshot shows that the fiscal start date for a property changes automatically after you close it at the end of the year:
The below screenshot shows you what your General Ledger for the property will look like, post close:
Entering Prior Date Adjustments After Closing
If needed, you can still make adjusting entries after you have performed a property close. The manner in which you make adjustments will depend upon whether you have performed a property close or a periodic closing. Under either option, in order to keep your records accurate, it will require that you make adjusting entries twice — Once to the data file that you have copied on your hard drive, which will update your historical record, and once to your regular working data file.
For Property AND Periodic Closing
Open the backup copy of your data file made just prior to closing. Make any necessary entries using the original transaction date or the closing date. It is recommended that you use the Memo field to make note of the fact that the entry was made after the initial property close. If you want to ensure proper records, any changes you make to your backup data file will necessitate making new backups and printing new reports.
For Property Closing Only
Open your regular data file used for current transactions. Ideally, if the entry had been made prior to the property closing, it would have updated your beginning balances for the New Year. Since that did not occur, you will need to duplicate the entry in this data file to update it with the transaction that is missing. When recording the transaction, use the first day of the new period with Memo to make it easy to identify. Also, if the entry involves either an income or an expense account, you should use “Retained Earnings” or another Owner’s Equity account in its place, so the current period’s financials will not be affected.
For Periodic Closing Only
Remember that after a Periodic Closing, you will only be able to enter transaction with a current or future date. To make the necessary adjustment in the current data file, you will need to edit the freeze date.
- Locate the applicable property in the Properties List and open the Properties window.
- Make note of the Property Freeze Date displayed.
- Edit the Property Freeze Date to a date that precedes that of the adjustment entry.
- Make any necessary adjusting entries.
- Reprint reports, as needed.
- Go back into the Properties window and edit the Property Freeze Date back to its original date.
How do I restore my data file to a different computer?There may be an occasion when your computer has crashed, or you simply purchase a new, upgraded computer. In this event, it will be necessary to create a data file on the new computer so that the backup will have someplace to restore into.
Create a new data file to restore into. From the Tenant Pro menu, go to File>Data Files. Click the New button at the bottom of the window. Verify that you are in the directory where you want your data file to be stored. This will typically be the Database folder inside C:\Program Files\Tenant Pro 7. In the File name field, enter the new data file name. It must be the exact same name as the data file you are restoring from, including capitalization, punctuation and spacing.
How do I install a Tenant Pro 7 Access Version: Workstation?Tenant Pro 7 Access Version: Workstation Installation
Please Note: Ensure that you make a backup of your data file, if Tenant Pro 7 has been previously installed on the computer that you are attempting to install to currently. This would be the case if you are simply downloading a more recent service release of Tenant Pro 7.
***Before beginning the Workstation-type installation, insure you have properly installed the server version of Tenant Pro 7 and are able to access the network shared folder, established for Tenant Pro 7.***
1. Double-click Installer File that you downloaded, it will look similar to the image below.
2. You may get a Security Warning, please click Run.
3. Click Next.
4. After reading the License Agreement click Next.
5. Click Next To install, this step will install the Tenant Pro 7 software to your hard drive in the location that you have specified.
6. Click Next To Go To Next Step Of Installation:
7. Click Next To Continue Setup:
8. Enter the appropriate Tenant Pro 7 Product Serial Number (NOTE: do not enter the WorkstationSerial # here).
9. Select “c. Network workstation” for Type of Installation and click Next.
10. Click on Browse and click Next.
11. Then Browse through the Network to point to the TPCentral.mdb file. ***YOU MUST START WITH MY NETWORK PLACES, as shown below. The required path that you must use is… My Network Places > Entire Network > Microsoft Windows Network > Your Specific Workgroup > The Computer Name (This is the Server name) > Database > TPCentral.mdb.
***NOTE: Ensure that you actually click on My Network Places, if you deviate from the required navigation steps, Tenant Pro 7 will not install properly.***
12. Select the TPCentral.mdb file and click Open:
13. Click Next.
14. Click Next.
15. After the installation completes click finish. This step completes the Tenant Pro 7 workstation Installation.
How do I enter property beginning balances?
Property Beginning Balances
After having entered a property into your data file, you may need to enter beginning balances for the financial records of the property.
To do so; click on the Begin’g Bal button at the bottom of the property window, then the Beginning Balance window will be displayed. Information entered within this window will create a simple journal entry that reflects beginning balances for each account. Typically, accounts such as Cash and Security Deposit Liability will have beginning balances that need to be recorded when you start using Tenant Pro 7.
- If you are already in the property window, proceed to step 3, otherwise continue to step 2.
- From the toolbar, select the Properties List icon and select the property from the Properties List.
- Click the Begin’g Bal button at the bottom of the window.
- Choose the date of the transaction.
- Enter the appropriate balances for the general ledger accounts you desire.
- Click the green Save checkmark at the bottom of the window.
My Bank Reconciliation Summary Report does not match my Check Register / Bank Account Balance
List / or General Ledger.
The Current Bank Balance on the Bank Reconciliation Summary Report does not match the Check Register, Bank Account Balance List, or General Ledger. This can be caused by any of the following:
- The Bank Reconciliation Summary is a mathematical report: It is only valid at the time it is reconciled and printed. If you view a prior month AFTER creating a new bank rec and cleared items, the total for cleared and uncleared items changes the total of the Checkbook balance as of ‘m/d/y’ and the Current Checkbook balance. When balancing, you should always print a hardcopy or save an electronic copy of the balances at that point in time for future reference.
- Tenant Payments and Misc Bank Transactions dated in one month and the Deposit of those funds dated in a future month will cause this issue. For example, if a tenant payment made 12/28/09 is deposited on 1/3/10, the Bank Balance Summary Report, the Check Register, and the Bank Statement Reconciliation Summary as of 12/31/09 will not include the deposit and therefore will not match the General Ledger, Balance Sheet and Trial Balance cash account balance for the same date. The General Ledger displays as of the payment transaction date, not the deposit date.
- When selecting “All Properties” on the report selection criteria, it does not include Inactive Properties by default, but the check register will include all property balances including Inactives. In order to arrive at the same number, you would have to choose “Select Properties,’ then go in and choose “Select All” and “Include Inactives.”
- Transactions with a Bank Account as the offset to another Bank Account will not display in the Bank Reconciliation. For example, if a user mistakenly enters a Misc. Bank Transaction to account 1000 as an increase and uses the offset account of 1000, on the Increase half of that transaction shows on the bank rec. That means that the bank statement could be in balance, but it wouldn’t match the GL because the GL will show both a debit AND a credit to the same account. This also occurs if a bill or a check is written and inadvertently uses the 1000 account as the offset account.
- Verify that all Tenant Payment Credits use a Revenue or Liability account in the Acc to Apply Credit field. Using a Bank Account in the Acc to Apply Credit field will also cause this issue to occur. To locate these Credits, create a new Bank Reconciliation, and click the Select All button. This will clear all transactions except Credits applied to Bank Accounts. You can then search the Check Register for uncleared transactions.
- Migrated cash Beginning Balances from Tenant Pro 6.0 can cause the Bank Statement Reconciliation balance to differ from the General Ledger because without the individual outstanding checks being brought over from Tenant Pro 6.0 to Tenant Pro 7, the only way to fix this is for the beginning balance on the bank statement to be edited to take into account those transactions that were recording originally in Tenant Pro 6.0.
- Verify that the NSF Bank/Tenant Charges Account are set to a Revenue account and not a Bank Account.
- Verify that the Opening Balance of the very first Bank Rec match4es the Beginning Balance of the Bank account.
- Verify that the Opening Balance of each Bank Rec matches the Ending Balance on the previous Bank Rec.
- Verify that the Ending Balance Matches the Cleared Balance on each Bank Rec.