web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Cash manager or bank r...
Microsoft Dynamics SL (Archived)

Cash manager or bank reconciliation

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Verified answer
    Erich Strelow F Profile Picture
    Erich Strelow F 16 on at

    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?  

  • Community Member Profile Picture
    Community Member on at

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

  • Community Member Profile Picture
    Community Member on at

    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 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans