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

 

Extra PAYE Year End Support Hours
Support is available on the 18th & 19th of May

XML error message when filing payroll year end
Learn more about the HMRC server delays

HMRC Outages for PAYE Service
Learn about the outages

Install QuickBooks 2013
Instructions for Install and new Company File setup

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

Product updates
Download recent updates

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

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

Did this article help you?
Your Feedback
Cancel Submit