Household detail ledger report

[patjjensen]

Note: This post is applicable in the Cloud database's Windows App as well as in the Legacy database.

My wife collects a check or checks from a parent for their clubber's fee and/or inventory bill and then writes up a PO to deposit the check(s) into the bank. She creates a deposit slip on Excel to assist the teller with the deposit. In AWdb, we record the check#, amount, payor, date, etc. and apply the payment to the clubber's bill. In an effort to not be creating new Excel documents from scratch like we currently do to record a deposit slip of all of the various household's check payments, is there a report we can run that will give us a list of Payor's name, amount paid, payment method (cash, check, etc), check # so that we can use this report to record the detail of the deposit we are making with the bank?
Pat

[Rick Leffler]

Under the Reports tab there is a report named "Receipts Report". This may work, but likely contains more data than your bank teller would want to see.

Probably the best solution would be to use the main Ledger tab and select the Payments > Received tab.  Here you will see a list of all payments. If you just want to see checks, apply a filter to the Type column so the list includes only records with a Payment Type of "Check". You could also hide any columns you didn't need to see (e.g. Payment ID).  You could then click the Preview/Print button to print the grid.  You may even want to customize the Title while you're on the Print Preview screen.

If you need help applying filters, hiding columns, and working with the grids, there is a detailed topic on working with grids in the User Guide and has screen captures and call outs. There is also a video with details, here: https://www.approvedworkman.com/forum/index.php?topic=2217.0.