Skip to main content

Notifications

Microsoft Dynamics SL forum
Answered

Cash manager or bank reconciliation

Posted on by 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!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Erich Strelow F 1,642 on at
    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?  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans