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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / 1st Bank Reconciliatio...
Microsoft Dynamics AX (Archived)

1st Bank Reconciliation after migration

(0) ShareShare
ReportReport
Posted on by Community Member

When we uploaded balances when we migrated to AX, the bank balances were uploaded as "Ledger" journal entries instead of "Bank" journal entries.   Now I have to correct this to get opening balances to show up in the bank reconciliation.  Instead of reopening June to do the correcting JE, I would like to do it as of July 1st.   I want to do the JE dated 07/01/17 then do a bank recon with a 07/01/17 statement date to get the opening balance to populate on my bank rec.   My question is will AX allow me to do two bank reconciliations for the same bank in the same month?  One dated 07/01/17 and the other will be dated the normal 07/31/17 statement date.

Anyone's input would be greatly appreciated.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Nagendra Varma K Profile Picture
    Nagendra Varma K on at

    Hi Saine,

    You can reconcile with same bank different cutoff dates.

    Thanks

    Nagendra Varma k

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi J. Saine,

    As Nagendra Varma K mentioned you can reconcile your bank in July - multiple times if you like with different dates.

    I am just wondering about your migration in June.

    If you do the correction in July, your bank and GL module won't match in June as you have the bank balances only sitting on your ledger accounts. Not sure whether this is a problem for you?!

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Thank you for your response!

  • Community Member Profile Picture
    Community Member on at

    Hello!   I did a General Journal dated July 1st to our bank account as a credit to the "Ledger" and a debit to the "Bank" transaction types using the June ending bank balance.   By doing this, it does not cause a change in the beginning balance just allows be to "reconcile" the beginning bank balance.    I then did a bank recon dated July 1st.  My starting balance was zero so I pulled in the bank transaction from the journal entry and reconciled the account.   We started a new bank recon and the beginning balance populated correctly.    So far, this seems like it will work to get things rolling.   As always, thank you for your response.   You have always been very helpful to me.    Have a great week!   Joy

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

News and Announcements

Season of Giving Solutions is Here!

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#3
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans