Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Credit Card Reconcilia...
Microsoft Dynamics NAV (Archived)

Credit Card Reconciliation & Entry into NAV 2013

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I am wondering if anyone has had experience implementing a credit card in NAV 2013? We are implementing a P-Card program that will be reconciled and an expense report will be populated from our Travel Management system - Concur. From there we are trying to have a csv file to somehow upload directly the expenses in the G/L or to a vendor card (the bank/credit card company). I'm just wondering if anyone has done this, how they have accomplished getting the information into NAV without a manual keying of information (before or after the statement is closed) and how the reconciliation has been accomplished in NAV? Has anyone used a clearing account to upload the transactions as they occur and then once they are approved and costed out removed them from the clearing account and put them to their final resting spot for expenses?

Any suggestions, ideas would be helpful.

*This post is locked for comments

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Credit Card Reconciliation & Entry into NAV 2013

    Hi,

    Exact timing depends on your source system, of course. I assumed that the transactions are already available.

    When you know the expenses before the actual payment is taken from your bank account - that's no problem. You can import into NAV and "let it wait there" until the payments are on the bank statement.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Credit Card Reconciliation & Entry into NAV 2013

    So how would you hit a liability before the payment is made?

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Credit Card Reconciliation & Entry into NAV 2013

    Hi,

    easiest would be when you import into a General Journal.
    Post a payment on a bank account with your expenses-G/L Account as the balance account.

    Then you can maintain the expenses in your G/L on the expense account.
    And you can use the bank reconcilition of NAV when you have the payments on the bank statement.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans