Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time
Release Date: 07/17/17
Q - I cannot find a way to get a report from AR showing all the check deposits for a certain period of time and the same information by customer. It drives me crazy. Can you help me?
A - You can go to A/R -> Reports -> A/R Distribution To G/L Report. Choose the date range you want, and choose detail type. Then choose to export to CSV file. Once the CSV file is created, bring it up in Excel. Keep only the Journal Source = “CR????” (CR = Cash Receipt), and get rid of all other records. See sample screen below:
EMK