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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Configure Credit Cards - Questions

(0) ShareShare
ReportReport
Posted on by

Hello,

First, thank you to Jennifer Reinhardt for the configuration instructions below.  

Just a couple of questions for anyone that has setup credit card payments using this configuration. 

I'm sure I’m taking the instructions too literally, but does the Bank Acc Posting Group in the setup below reference a new asset account (ex., Acct No. 10XXX), or a liability account, like the default G/L Credit Cards liability account (No. 20500)?

Since Credit Cards are a liability, I've configured the new posting group to point to the default Credit Cards liability account. I tried using an Asset account for the Credit Card bank account, but it appears from my testing that I'd have to change the Balance Sheet and the Cash Flow Statement because the results in the report is misleading. 

When using the liability account, the balance owed is not displayed in the Bank Account but in the Credit Card Liability account, so you'll probably want to create a liability account for each credit card. 

Does this configuration make sense, or will I encounter issues down the road?

Thank you, 

Ian

 

Jennifer Reinhardt responded on 21 Apr 2017 9:22 AM

Hello!

I believe a similar question was asked on a previous Forum post, here's the link to that post: community.dynamics.com/.../622740

I have also pasted the details of the response below, hope this helps!

From my testing you would set up everything as you normally would for a Vendor with one exception, a different Payment Method.

You setup the Bank Account as the Credit Card so you manage the Payment posting through this.  You would set up a Payment Method with a Balancing Account to the Bank Account for the Credit Card. So on the Payment Method, there should be a Bal. Account Type = BANK and Bal. Account No. would be the Bank Account you created that is your CC company, you will likely need to set up a new Payment Method.  

You assign the Payment Method to the Vendors which you pay with your Credit Card, the Payment Method is on the Vendor Card under the Payment section.  When you post an invoice for this vendor, the vendor balance would be $0, the Bank Account for the credit card would contain the outstanding balance.

You would then use a General Journal to move the money from the Main Bank Account into the Credit Card Bank Account to essentially "pay off" the credit card.

Here's some detail steps:

1. Setup a Bank Account for the Credit Card, you will need to specify a Bank Acc Posting Group here too specify an account where you want the balance to be stored.

2. Create a Payment Method (use the search and type Payment Methods to open this window). Create a new Payment Method that has a Bal. Account Type as Bank Account and the Bal. Account No, would be your Credit Card Bank account from number 1 above.

3. Assign this Payment Method to your Vendor, on the Vendor Card under the Payments section.

4. When you post a Purchase Invoice for this Vendor, the Vendor Balance will not change. Instead, the balance will show in the Credit Card Bank Account as a negative.

5. Using a General Journal post money from the main bank account into this Credit Card Bank Account to essentially pay the credit card.

There may be someone working on a customization to accomplish this differently, but I haven't seen a specific one, maybe someone in the community has heard of something?

The steps above are just one way I have seen people work through this type of process, but you will want to do these steps in a test company to make sure that appropriate accounts, etc. are affected and will work for your process.

Regards,

Jennifer Reinhardt

Please see our Dynamics 365 Financials Support Team Blog for helpful information:

blogs.msdn.microsoft.com/dyn365finsupport

  • Verified answer
    Community Member Profile Picture
    on at

    Ian,

    Yes, use a liability account.

    Let's say the liability account for a Visa account is 20100. You would enter 20100 into the Bank Account Posting Group used for the bank account associated with the payment method.

    However, it is odd that the (negative) balance isn't showing for the bank account; it should be. Does the bank account have the new posting group assigned to it?

  • Verified answer
    Community Member Profile Picture
    on at

    Hi Ian,

    Thank you for the confirmation about the liability account. All my testing shows it to be the best method. However, I don't think I'd want it to appear in the bank account, because then it would show up on both sides of the accounting equation. The Bank Account Posting group stores the balance in the liability account, and I’ve assigned the Posting Group to the bank account. When I make a payment to the credit card, I can post the usual debit liability and credit cash.

    I tried the bank reconciliation for a credit card account and it was successful. When making a payment, I debited the bank account document type for the credit card and credited the bank account document type for my checking account. Do not use G/L Accounts, because you want the actual entries posted to the bank accounts, in addition to the respect G/L accounts. The posting groups for the bank  and credit card accounts will manage the G/L entries. 

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans