This will sometimes occur when starting a new fiscal year. When opening the new report, NTS will sometimes ask if transactions from the previous fiscal year should be included. Answer Yes to this question. If you don't get this question, you don't have to do anything. All transactions will be included automatically.
If you answered yes, or if that doesn't resolve the problem, you need to check for unreconciled transactions. As an example, let say you just started the 2017/2018 fiscal year. If there is a check in the 2015/2016 fiscal year that has not marked as reconciled, then the balance will be off. NTS will only carry unreconciled transactions forward to the next year. After one year, the transactions are dropped.
To check for this situation:
- You need to look for tranactions two years prior to the new fiscal year that just began. Change the fiscal year to 2 years prior. In the example, this would be the 2015/2016 fiscal year.
- Pick a transaction, any transaction, that is already reconciled and then right click on the 'X' in the reconciled column.
- This will reorganize the transaction register such that all unreconciled transactions will be listed at the top of the register.
- Look for any non-zero transactions that are not reconciled. Any voided checks or other transactions with a zero amount can be ignored. All other transactions will need to be reconciled and accounted for.
- Record the amount and internal category/account for each transaction.
Mark each non-zero transaction as reconciled and add it to the last reconciliation report of the
following fiscal year. In the example, the following year would be the 2016/2017 fiscal year.
If the last month of the fiscal year is March, these transactions would need to be added to the
report dated March 2017. If you have NTS version 5.50 or above and you have already created
a reconciliation report for the month following the end of the fiscal year, do the following
- Open the reconciliation report for the last month in the following fiscal year.
- Press the F9 key or Ctrl + R on the keyboard to enter Reconciliation Report repair mode.
- Reconcile all non-zero transactions.
- Close the report and change the fiscal year to the following year. In our example, that would be the 2016/2017 year.
- An income adjustment will need to be entered into account for these transactions that never cleared the bank. Enter a positive adjustment to account for any checks, e-checks or other transactions that reduced the account balance. Credit the same internal account that was used on the original transaction that was recorded above. Enter a negative income adjustment for any deposits or other transactions that increased the balance of the account. Multiple checks or deposits can be entered in on one income adjustment.
- Reconcile the adjustment(s) from the prior step on the same report as the old transactions.
- Change the fiscal year back to the current/new fiscal year. In the example, this would be the 2017/2018 year. Upon changing the year, you will likely get a message indicating that the fiscal start balances don't match the prior year ending balances. Click Yes or OK on this message so that the system can update the balances automatically. Please contact us if you don't get this message or if you get a message saying the balances could not be updated.
After correcting these issues, the previous balance on the reconciliation report should be correct. If it is not, please contact us for additional assistance. Our contact information is at the bottom of this page.