Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Pro Forum

Reply
 
Thread Tools Rating: Thread Rating: 5 votes, 5.00 average. Display Modes
  #1  
Old 04-13-2010, 09:19 AM
KFowler KFowler is offline
Registered User
 
Join Date: Apr 2010
Posts: 2
How to clean up accounts payable?

The accounts payable report shows journal entries dating back for several years, all year-end entries from audit. They net to zero, except for the last posting. How do I clear the old entries that net to zero and clean up the report?
Reply With Quote
  #2  
Old 04-14-2010, 12:53 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,902
They should use a unique vendor, I hope. If they do, then go to Pay Bills and select that vendor and apply the credits to the "bills".
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #3  
Old 04-14-2010, 06:40 AM
LauraD's Avatar
LauraD LauraD is offline
Moderator
 
Join Date: Jun 2006
Location: Rhode Island
Posts: 1,196
Edit>Preferences>Bills>Company preferences.

Set your preferences to automatically use discounts and credits.

Go to Pay Bills and select all of the bills that have adjusting entries. The credits will be applied when you check the bill.

This way, you don't have to apply the credits to each one manually.

I hope this helps,

Laura D
__________________
Laura Dion
Advanced Certified QuickBooks ProAdvisor
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
_______________________________
Reply With Quote
  #4  
Old 04-14-2010, 08:33 AM
KFowler KFowler is offline
Registered User
 
Join Date: Apr 2010
Posts: 2
Thanks Joe. Most of the "vendor" names were unique, like "year end adjustments- AP". For those that weren't, I edited the original transaction for vendor name only, then did as you said and cleared them out by applying the corresponding credit in the 'pay bills' transaction. Wonderful! Now I am going to work on cleaning up the accounts receivable.
Reply With Quote
  #5  
Old 04-14-2010, 05:12 PM
mijoe mijoe is offline
Registered User
 
Join Date: Apr 2010
Posts: 1
Quote:
Originally Posted by ldion4 View Post
Edit>Preferences>Bills>Company preferences.

Set your preferences to automatically use discounts and credits.

Go to Pay Bills and select all of the bills that have adjusting entries. The credits will be applied when you check the bill.

This way, you don't have to apply the credits to each one manually.

I hope this helps,

Laura D
Hi Laura, I am sure this is a very dumb question, but what would the default discount account be here? I am trying to sort through undeposited funds and accounts receivable to get all my ducks in a row. My bank balance is correct, but I deposited some funds manually and I'm having trouble matching the deposits to the invoices now...
Reply With Quote
  #6  
Old 04-15-2010, 06:13 AM
LauraD's Avatar
LauraD LauraD is offline
Moderator
 
Join Date: Jun 2006
Location: Rhode Island
Posts: 1,196
I would use and income account called Customer Discounts & Adj.

If you have payments in Undeposited Funds that you have already accounted for in the Make Deposit form, do this:

Select all of the payments and pull them into one deposit form. (batch these by month, or year) Then, minus that total using the account that you used when posting your manual deposits (most likely your income account)

Laura D
__________________
Laura Dion
Advanced Certified QuickBooks ProAdvisor
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
_______________________________
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Tags
accounts payable, clean up, clear

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 02:31 AM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.
You Rated this Thread: