Hello Martin,
Thank you for posting on the Micrsoft Dynamics NAV Forum.
The Bank Reconcilation question is assumed to be the Norh America Version Localized Bank Reconciliation in NAV 2009 R2 or 2009 SP1.
I think the issue here is that you have multiple checks summarized into one Payment in NAV - e.g. a posting to Payroll Expense includes many checks to individual employees. However, if you don't post each check in NAV to the Bank Account, but rather there is one single summarized posting in NAV from the other system , the system has no way of documenting the detailed checks.
In your scenario, the system posts one Payment Amount as a total check. Now, if only a partial number of those checks are cleared in a period, then there isn't a clean way to track it. The system doesn't track the Cleared Amount vs. Total Amount difference in the Bank Ledger.
From a theoretical perspective, I would think that the process would be:
1) You would enter the Cleared Amount and process the Adjustment for the difference as a journal entry on the Adjustments Tab. This would add back the amount to the G/L entries Balance for the outstanding check portion.
2) The Cleared Flag would clear the full amount with the total of all checks but we've added back the outstanding amount to balance the entries. On the Adjustment Tab, we could document which Payroll Document Check No or Nos didn't clear.
3) In the following Bank Reconciliation period, we would review the prior adjustments and confirm that the remainder of the checks cleared and would reverse the Adjustment from the previous period to balance out to the G/L.
The challenge is that this is viewed as all one check. Typically, a difference would be the result of something where a manual check was incorrectly input into the system - for example, we post a check for 10,000 but it was written for 10,100 and cleared as such on the Bank Statement. Therefore, the difference of 100 is a permanent adjustment that gets posted to the G/L Balance to match with the Bank balance. We clear what was a 10000 check for 10100 and record the G/L Adjustment to correct the amount for the G/L to correctly reflect the wrong check amount entered in the system. The check is cleared and we are done with it.
In your scenario, you may have what appears to be a single check of say 10,000 for all Payroll. Of the 10,000, only 9,500 clears because a separate check is outstanding. However, there is nothing in NAV Bank Ledger Entries to track this. We can clear the 10000 by using the Cleared Amount and posting the adjustment for the 500.00 difference added back. However, that one single check posting of 10000 is now closed. If and when the last check clears for 500, we need to reverse the G/L Adjustment of 500.00 that was recorded to manage the balance difference between what cleared on the Bank and G/L Entries in the previous period.
These are my thoughts on the process. I hope it helps.
Best Regards
Tom
