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
Double check that the payment is recorded to the correct credit card General Ledger account. If done correctly, it will appear on the reconciliation.
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.
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.
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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.