Peachtree and Sage 50 Forums      

Go Back   Peachtree and Sage 50 Forums > Peachtree and Sage 50 software > Premium Accounting forum

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2014, 03:53 PM
dwdwone dwdwone is offline
Registered User
 
Join Date: May 2010
Location: Fort Worth, TX
Posts: 27
Vendor ledger and cleared payments

Am wondering if there's a way to display a vendor ledger that indicates whether or not a cash disbursement has been marked as cleared in the reconciliation? I know that the ledger indicates if a purchase journal has a zero balance but I'm concerned with checks that show as cleared. If not, is there a similar report out there?

Thanks,
Dan
Reply With Quote
  #2  
Old 04-28-2014, 06:10 PM
jdierkhising jdierkhising is offline
Registered User
 
Join Date: Jun 2004
Location: Minneapolis
Posts: 416
If you go to Reports/Account Reconciliation and choose the Outstanding Checks report, you should be able to get what you are looking for. You may need to go to Options and edit the Filter to show Cleared checks.
__________________
I'm an independent Sage50 (Peachtree) Master Certified Consultant, please contact me if you are in need of assistance (input @ and .):

John [at] bottomline-acctg (dot) com

Please leave me a review if you appreciated my assistance: http://bottomline-acctg.com/reviews/
Reply With Quote
  #3  
Old 09-21-2014, 07:56 AM
surendra87 surendra87 is offline
Registered User
 
Join Date: Dec 2007
Posts: 15
might need to export two files:
Payment journal
Outstanding checks (with cleared column)

If you know ms access, this would be easy...
Essentially what you have to do is open ms access, link the two files as tables then query the by matching the checks paid to cleared items.

you will also be able to see what invoices those checks are for... so ultimately you will get what invoices are paid but haven't cleared the bank.
__________________
Surendra

http://www.nybookkeep.com/
Reply With Quote
Reply


Thread Tools
Display Modes

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 Off

Forum Jump


All times are GMT -7. The time now is 07:40 PM.


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
all contents copyright (c) by AccountingUsers Inc.