Peachtree and Sage 50 Forums      

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

Thread Tools Display Modes
Old 04-28-2014, 04: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?

Reply With Quote
Old 04-28-2014, 07:10 PM
jdierkhising jdierkhising is offline
Registered User
Join Date: Jun 2004
Location: Minneapolis
Posts: 428
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:
Reply With Quote
Old 09-21-2014, 08: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.
Reply With Quote

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 12:21 PM.

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