• Was this page helpful?
Intuit Blog
|
Support
Point of Sale
|
GoPayment
|
Payroll
|
Quickbooks
|
Website Services
Intuit
Sign In
Register
QuickBooks General Forum QuickBooks Payroll 3rd Party Apps that work with QuickBooks QuickBooks Accountant Edition QuickBooks Online for Accounting Professionals QuickBooks Enterprise Solutions QuickBooks Point of Sale
ProAdvisor Program & Certification
ProSeries DMS ProSeries Community
Lacerte DMS Lacerte Community
Intuit Tax Online Tax Research for Lacerte and ProSeries Tax Import for Lacerte and ProSeries Intuit Practice Management EasyACCT Intuit Statement Writer
Starting and Managing Your Practice Classifieds Intuit ProConnection Newsletter Intuit Academy Training Your Peers Recommend
  • QuickBooks & Payroll
  • ProAdvisors
  • Lacerte
  • ProSeries
  • Productivity Tools
  • Training & Resources
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help for Accountants   Training and Resources   QuickBooks and Payroll   QuickBooks General Forum  
hide
01/26/2012 at 02:08PM PST
We’ve seen a scam e-mail regarding Intuit tax information floating around today. This e-mail was not sent or authorized by Intuit. If you ever wonder whether an e-mail from Intuit is real or fake, please refer to the link below.

Thank you

http://security.intuit.com/security-alerts.php
1
60
bagvF8Y1er3QjyacfA8pyY
Subscribe RSS
GCBooks
GCBooks
Questions asked: 7
Questions answered: 10
Points earned: 20
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
GCBooks
GCBooks
Questions asked: 7
Questions answered: 10
Points earned: 20
New Member
11/06/09 7:56pm PST
Viewed by asker 11/07/09 4:42pm PST

CC account won't reconcile with partially paid bills

US QuickBooks Premier

Using QB 2010 (and earlier).

Regarding credit card accounts.

If you partially pay a bill due to the credit card vendor (the bank), then when you go to reconcile the account, the partial payment does not show up, and you cannot get a balanced reconciliation.

Any way to do this?

Solved!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
This post is closed to new replies
5 Replies
Accountant Man
Accountant Man
Questions asked: 128
Questions answered: 9845
Points earned: 27330
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Accountant Man
Accountant Man
Questions asked: 128
Questions answered: 9845
Points earned: 27330
Accountant Community AllStar
11/06/09 8:30pm PST

You may not be recording the charges correctly. When you record a CC charge, the account is the expense type(supplies, postage, etc). That is the expense. It is the same as recording a journal entry as DR Supplies   CR CC (a liability)

When you pay the CC bill, you do not use the account called "Supplies," you use the account called "CC," (the liability).  DR CC   CR Bank account(the payer of the check).

Does this help you?

If you use Pro Series Basic I might not be able to help you. If you use Turbo Tax I might refuse to help you. All others, watch out! ;-)
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11731
Points earned: 21140
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
LauraD
LauraD
Questions asked: 153
Questions answered: 11731
Points earned: 21140
Allstar, Accountant Community AllStar
11/07/09 6:20am PST

This sounds like you are entering a bill for the outstanding credit card balance (which QuickBooks gives as an option after reconciling the statement).

I don't recommend entering a bill for the credit card. 

However, if you did (or want to) enter a bill, edit that bill to the amount that you actually paid.  Then, it will flow properly to your next reconciliation.

Laura D

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
1
 Report Abuse
 
 
 
GCBooks
GCBooks
Questions asked: 7
Questions answered: 10
Points earned: 20
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
GCBooks
GCBooks
Questions asked: 7
Questions answered: 10
Points earned: 20
New Member
11/07/09 1:55pm PST

 When you get a credit card statement, it shows the amount of money due for the next month. Not the total credit card liability.

This is what I am referring to as the "bill". So a credit card with a balance of 10K might have a bill of $300.

If this $300 bill is partially paid, say $250, that is when the reconciliation does not work.

If the $300 bill is paid in full, the reconciliation works fine. If it is partially paid, then on the next reconciliation, it will not balance correctly. The reconciliation windows only show the bill amount, not the actual payment amount.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11731
Points earned: 21140
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
LauraD
LauraD
Questions asked: 153
Questions answered: 11731
Points earned: 21140
Allstar, Accountant Community AllStar
11/07/09 2:16pm PST
The solution

Trust me - you need to edit the bill to show the exact amount that was paid.

If you paid that bill with two bill payment checks, you need to enter another bill for the difference and apply the bill payment to that.

Perhaps this is difficult to explain on a forum setting, but, basically, you have three choices -

1)  Delete all bills and bill payment checks.  Then, enter all actual payments using the cc account on the expense tab.

OR

2)  Edit the bills to match the payments.

OR

3)  Reconcile the last cc statement and adjust the last partially paid bill to the actual amount paid.  Then, if there are more recent bills, delete those. 

Going forward, don't enter a bill for the credit card.  Simply post your check using the cc account on the expense tab.

If you really want/need to put the payment due in Accounts Payable, make sure that you edit the bill for the amount that you actually pay.

I hope this helps.

Laura D

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
11
 Report Abuse
 
 
 
GCBooks
GCBooks
Questions asked: 7
Questions answered: 10
Points earned: 20
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
GCBooks
GCBooks
Questions asked: 7
Questions answered: 10
Points earned: 20
New Member
11/07/09 4:41pm PST
Latest post

 OK, so I need to edit the bill to the unpaid amount, so that QB will still keep track of bills due and when, and make the partial payment a check instead of a bill payment.

Sort of a PITA, but I guess that is how you have to do it.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
   
 
 
Subscribe RSS
Tags for this topic
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
michelem1983
8 mins ago
michelem1983
posted
Are you using tax import? ...
ryanerikdaniels
12 mins ago
ryanerikdaniels
replied to
scorp negative retained ear...
jtgcpa
18 mins ago
jtgcpa
replied to
URRENT FORM DEFAULT VIEW
jtgcpa
24 mins ago
jtgcpa
replied to
Indiana S-Corp Slip Sheets
CMS_VA_CPA
41 mins ago
CMS_VA_CPA
replied to
medical insurance for s-cor...
Product Resources
QuickBooks Tax Products Payroll ProAdvisor Program Training and Certification Feedback Survey
Resources: Find Local ProAdvisor Tax Almanac Practice Resources
Support: QuickBooks Lacerte ProSeries EasyACCT
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business