Home Page link  

QB Credit Card reconciliation

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
QB Credit Card reconciliation Chips 07-03-2007
Posted by Chips on July 3, 2007, 2:47 pm
Please log in for more thread options
Using QB Contractor 2006

If we have a credit card where we made a payment that partially pays a bill
from that credit card company, then when I go to reconcile it, I can't get
it to balance correctly, because in the reconciliation form it only shows
bills, not actual payments made to the credit card company.

Is there a way to get this to reconcile correctly?

Thanks,

Greg Chapp



Posted by Joanne on July 3, 2007, 4:16 pm
Please log in for more thread options
Double check that the payment is recorded to the correct credit card General
Ledger account. If done correctly, it will appear on the reconciliation.

--
Sincerely,
Joanne


If it's right for you, then it's right, . . . . . for you!!!

http://www.jobird.com
Wonders of Western Washington Video collection:
http://www.jobird.com/private/wondersindex.htm


> Using QB Contractor 2006
>
> If we have a credit card where we made a payment that partially pays a
> bill from that credit card company, then when I go to reconcile it, I
> can't get it to balance correctly, because in the reconciliation form it
> only shows bills, not actual payments made to the credit card company.
>
> Is there a way to get this to reconcile correctly?
>
> Thanks,
>
> Greg Chapp
>



Posted by Scott on July 3, 2007, 6:12 pm
Please log in for more thread options
Only way I can think of is to change the bill to the amount paid (since
that's what shows up in the reconciliation) and add a bill for the balance.
Creating a bill for the full amount due upon reconciliation is awkward when
you plan on partially paying - for my clients I recommend not creating a
bill, instead just pay by check & charge against the credit card g/l account
(just as the bill does). If you insist on using a bill, you'll always need
to split it up when paying partial amounts.

Scott out.

> Using QB Contractor 2006
>
> If we have a credit card where we made a payment that partially pays a
> bill from that credit card company, then when I go to reconcile it, I
> can't get it to balance correctly, because in the reconciliation form it
> only shows bills, not actual payments made to the credit card company.
>
> Is there a way to get this to reconcile correctly?
>
> Thanks,
>
> Greg Chapp
>



Posted by Scott on July 4, 2007, 9:08 am
Please log in for more thread options
Just to clarify this, when you have QB create a bill upon reconciling, it
does so for the full amount due. If you open this bill, you'll see it posts
to the CC account (debit) and A/P CC company (credit). When you pay this
bill, either in full or in part, you're posting to A/P CC company (debit)
and Cash (credit). In other words, the bill PAYMENT doesn't affect the CC
account, only the BILL does. So when you reconcile, what shows up is
anything posted to the CC account, NOT what you paid via bill pay.

If you ignore the create bill for later/write check now (click on the "x" to
close the window without doing either) you can then write a check OR create
a bill any time for the amount you wish to pay, whether in full or in part,
posting to the CC account (debit) and either Cash or A/P CC company
(credit) - the credit will be automatic based on which method you use. This
will result in the correct amount paid being posted to the CC account &
that's what will show up on the reconciliation. You can track the balance
owed by looking at the balance left in the CC account.

Scott out.

> Only way I can think of is to change the bill to the amount paid (since
> that's what shows up in the reconciliation) and add a bill for the
> balance. Creating a bill for the full amount due upon reconciliation is
> awkward when you plan on partially paying - for my clients I recommend not
> creating a bill, instead just pay by check & charge against the credit
> card g/l account (just as the bill does). If you insist on using a bill,
> you'll always need to split it up when paying partial amounts.
>
> Scott out.
>
>> Using QB Contractor 2006
>>
>> If we have a credit card where we made a payment that partially pays a
>> bill from that credit card company, then when I go to reconcile it, I
>> can't get it to balance correctly, because in the reconciliation form it
>> only shows bills, not actual payments made to the credit card company.
>>
>> Is there a way to get this to reconcile correctly?
>>
>> Thanks,
>>
>> Greg Chapp
>>
>
>



Posted by Chips on July 6, 2007, 1:02 pm
Please log in for more thread options
Scott,

What happens is that I enter in the bill due for the next month (not the
total due), but sometimes the owner pays an arbitrary amount more than that.
This is what doesn't seem to show up in the reconciliation form.

I think the best way to do it is to modify the bill to match the payment, or
just delete the bill and show the payment as just a check, not a bill
payment.

Greg

> Just to clarify this, when you have QB create a bill upon reconciling, it
> does so for the full amount due. If you open this bill, you'll see it
> posts to the CC account (debit) and A/P CC company (credit). When you pay
> this bill, either in full or in part, you're posting to A/P CC company
> (debit) and Cash (credit). In other words, the bill PAYMENT doesn't affect
> the CC account, only the BILL does. So when you reconcile, what shows up
> is anything posted to the CC account, NOT what you paid via bill pay.
>
> If you ignore the create bill for later/write check now (click on the "x"
> to close the window without doing either) you can then write a check OR
> create a bill any time for the amount you wish to pay, whether in full or
> in part, posting to the CC account (debit) and either Cash or A/P CC
> company (credit) - the credit will be automatic based on which method you
> use. This will result in the correct amount paid being posted to the CC
> account & that's what will show up on the reconciliation. You can track
> the balance owed by looking at the balance left in the CC account.
>
> Scott out.
>
>> Only way I can think of is to change the bill to the amount paid (since
>> that's what shows up in the reconciliation) and add a bill for the
>> balance. Creating a bill for the full amount due upon reconciliation is
>> awkward when you plan on partially paying - for my clients I recommend
>> not creating a bill, instead just pay by check & charge against the
>> credit card g/l account (just as the bill does). If you insist on using a
>> bill, you'll always need to split it up when paying partial amounts.
>>
>> Scott out.
>>
>>> Using QB Contractor 2006
>>>
>>> If we have a credit card where we made a payment that partially pays a
>>> bill from that credit card company, then when I go to reconcile it, I
>>> can't get it to balance correctly, because in the reconciliation form it
>>> only shows bills, not actual payments made to the credit card company.
>>>
>>> Is there a way to get this to reconcile correctly?
>>>
>>> Thanks,
>>>
>>> Greg Chapp
>>>
>>
>>
>
>



Similar ThreadsPosted
Free to get your credit card report, will not even ask for your credit card number December 13, 2007, 1:20 am
Re: Credit Card February 26, 2007, 7:42 am
Credit Card February 26, 2007, 6:25 am
Credit Card deposit July 25, 2006, 5:03 am
Bill Pay With Credit Card? July 31, 2006, 8:28 pm
Credit Card (Tax Line) June 8, 2007, 9:55 am
POs and Credit Card Payments February 8, 2007, 12:36 pm
Credit Card RCPT September 1, 2008, 6:00 pm
Pay bills from credit card account? January 1, 2007, 8:31 pm
opportunity to credit card holder June 11, 2007, 9:40 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap