Cash manager or bank reconciliation

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi, I'm new in the blog, hope to be in the right one to post my question....I´m also new using Dynamics SL and I need to know which module to use to do the bank reconciliation, Cash Manager or Bank Reconciliation (module 20* or BR*)...thanks!!

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Cash manager or bank reconciliation

Another doubt is if I can don only 1-1 match or if it is possible to match multiple bank lines with one transaction in SL and vice versa
Community Member Microsoft Employee on at

Like (0)

Report

RE: Cash manager or bank reconciliation

Hi Erich, I think the best combination would be to use Cash Manager with BR module for the reconciliation functionality, but apparently BR module does not read transactions from the Cash Manager module or I'm doing something wrong?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Cash manager or bank reconciliation

Thanks a lot, very clear your answer!!....and the question now is, can I use cash manager other functionality and BR for reconciliation?
Verified answer

Erich Strelow F 1,642 on at

Like (1)

Report

RE: Cash manager or bank reconciliation

The BR module is a reconciliation focused on a by-transaction approach. To take full advantage, you should be able to import transaction data from your bank. If you are inside the US or Canada, it's likely your bank can feed you with the BAI2 format, which SL understands. Since SL started as a US based product, US oriented bank reconciliation is pretty much built in.

The Cash Manager reconciliation, on the other hand, is a by-total reconciliation. You enter a checkpoint date in which a bank-to-book reconciliation is performed as a balance total. There can be offsets, but those are to be matched to well known transactions (like AP or AR payments not yet collected).

So, the questions you should ask yourself are:

1. Am I in a business in which regulations force me to perform by-transaction reconciliation?

2. Am I inside US or Canada?

3. If not, can my bank produce the BAI2 format anyway, or some csv file that make sense?

4. If the bank won't help, do I have a small volume of monthly bank transactions so doing it by hand is not so crazy?

5. Are there any business related procedures that would prevent a meaningfull by-transaction reconciliation? Like branch office consolidating deposits from many AR transactions, or a non-SL POS software, or a voucher delay issue?