Skip to main content
November 19, 2018
Solved

link bill to credit card or journal entry

  • November 19, 2018
  • 1 reply
  • 0 views

I accidentally entered credit card bill (which has been paid and cleared) instead of reconciling it then entering it.  Is there a way to link the bill to the credit card (so the balance will go down).  If not I am not sure what other account to use besides the credit card when doing the journal entry.

Best answer by qbteachmt

The expenses on the bill need to be categorized correctly.  


With this comment: "The expenses on the bill need to be categorized correctly."

Let's start Over.

 

The only reason the card account in QB is seen as increasing is because you entered the individual Purchases as "expense" from the Credit Card. If you did this, there are the details, already. The entry of the payment is against the Card account, because this is when you paid down that Debt Balance. The Check Expense lists only Credit Card Account as the category or detail type.

 

If you use a Bill to reflect the credit card balance, you are hiding CC debt in AP liability. If you never pay that bill or partially pay that bill, the reconciliation of the credit card account to its statement is impossible, because the Bill is treated as Paying the CC balance in full; you hid the rest in AP.

 

If you used a bill instead of entering the individual charges, then the Bill is where you broke out your spending details. However, you did not buy anything from VISA or AMEX; they are your Lender. They do not sell Office Supplies. You also did not buy everything on that one date. If you did this "batched bill" method and also paid it and all the purchases fall entirely in your fiscal year, then make sure this is now a Paid Bill and never do this part, again. And this method does not affect the Credit Card Account in the data file, so if you already put the details in as individual credit card charge expenses, this Batched Bill would have Duplicated these details and that is an error; the bill in this example is supposed to show only the CC account.

 

If you made a bill to pay the CC account after reconciling, and you didn't pay it, then it is safe to delete it. When you enter your real payment, simply do that correctly, as a check or paperless check Transfer, between Checking and CC. There is no AP involved.

 

If you made a Bill and also made the credit card charges, and also already Paid that bill, then you have an AP check and the bill needs to show only the CC account is being paid. Never have the spending details in two different entries.

 

If you entered a Batched bill, breaking out and categorizing the spending on that bill, and have not yet paid it, and did not put that in Credit Card Charge expense, then delete the bill and do the entries properly, for each purchased From name and each Purchased date. If you also already paid that batched bill, then do not also put the spending in your Credit Card account as expense entries.

 

The question here asked how to get a Bill to reduce the credit card account balance: if the bill is not paid, Delete it, since it isn't the right entry type. If it is Paid, then the check is linked to the bill and the Bill is supposed to show the CC account, which will reflect it reducing the CC account, even if the bill Never Gets Paid.

 

And this is why there is no Bill. That is your account activity statement.

 

Hope that helps.

1 reply

November 20, 2018

Hello there, Allied3.

 

To link Credit Card Charges or Journal Entries to a bill, you’ll have to use the Accounts Payable as your account.

 

Since the bill has already been paid, you'll just need to click Pay Bill and apply the credit. This will now link the bill to the credit card. Let me show  you how:

 

  1.  Open the Bill.
  2. Click Pay Bill at the top.
  3. Check the box beside the credit you want to apply.
  4. Click Pay Selected Bills.
  5. Click Done.

For Journal Entries, you'll have to change the account to Accounts Payable to change your vendor balance. 

 

Feel free to reach out to me if you have additional questions about linking bills to credit card in QuickBooks. I'll be sure to answer them for you.

Allied3Author
November 20, 2018

This does not work on desktop.  Also, the bill has already been paid and cleared by the bank.  The vendor name of the credit card is not linked to the credit card.  Only when I reconcile the credit card and then go on to enter the bill does it link it to the vendor name.

November 20, 2018

Thanks for getting back and clarifying things out, llied3.

 

I want to make sure your concerns about linking bill to credit card or journal entry will be taken cared of. I've updated the steps above specific for QuickBooks Desktop for you to follow. 

 

I'd still be around if there's anything else you need. Drop me a reply and I'll get back to you. Have a good day.