Your Answer
print

Credits still appear as Credits even after they have been applied to Bills. A/P Aging Summary is not matching Supplier Balance Summary.

In QuickBooks 2010, you should not use A/P to apply credits to Bills. Instead, use a Bank account. This problem is fixed in QuickBooks 2012.

Solution if you applied credits from Cheques to Accounts Payable:

NOTE: Take care of your data and company file. You must perform steps 1 and 2 below before proceeding.

  1. Before any fixes are done - Make a backup of the file.
  2. Before any fixes are done - Run the following reports for all dates and print them off. (This is the base line of transactions as they exist now)
    1. Balance Sheet and Trial Balance
    2. Aging and Supplier Balance Summary reports
       
  3. Go to Advanced Find (Edit/Find/Advanced tab), select the following, then click Find:
    1. Transaction Type = Cheque
    2. Account = Accounts Payable
    3. Name = (Supplier with the problem)
       
  4. Select the first Cheque, then click Go To.
  5. Change the Accounts Payable account line to be a new Bank account. (This will break the links between the bills and credits.)
  6. Go to Pay Bills, change the Bank account to the new Bank account …

    a)    Change the date, and repay the Bills and
    b)    Pay only the amount that is in the bank account;
     
  7. Return to Advanced Find, and select the next Cheque - Repeat steps 4 and 5 until each Cheque has been used to Pay Bills.
  8. Return to Advanced Find, and change the Name to the next Supplier with a problem.
  9. Work through each Cheque, for each Supplier with this problem, until there are no more Cheques to accounts payable
  10. Once all fixes are done - Run the Vat 100 report for all dates and print it off AGAIN (This report should now be accurate)
  11. If the differences are not too great, you can file correctly with the next filing period. If they are great you may want to speak to your Accountant or HMRC.

 




Bookmark and Share

 

Join the conversation and exchange ideas & solutions with others.

  Ask questions
  Discover answers
  Help others

QuickBooks Community

Fake QuickBooks Security Update Email
Customers have reported receiving a fake QuickBooks Security Update.

QuickBooks 2012 is NOW AVAILABLE
Learn more about the Best QuickBooks yet!

Install QuickBooks 2012
Instructions for Install and new Company File setup

Upgrading to QuickBooks 2012
If you are using an old version, watch this video for guidance

Product updates
Download recent updates

Credits still appear as credits after being applied to bills
Use a Bank Account to apply credits

Product updates
Manually download updates

Password Reset Tool
Password issues? Reset it with our new FREE tool.

Connection Diagnostic Tool
Helps troubleshoot network & multi-user errors

Customized templates
Download templates for QuickBooks

Manuals
View online manuals

Tutorials
View tutorials

VAT
VAT explained

Find a ProAdvisor
Talk 1-on-1 with an accounting professional

Tina, our QuickBooks Interactive Agent, can answer your Customer Service and Support questions 24/7.

Did this article help you?
Your Feedback
Cancel Submit