Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time

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






    • Related Articles

    • ARCSHENT Accounts Receivable Cash Receipts Processing

      Cash Receipts Processing Application Overview Cash Receipts Processing is an application that you will use quite often. You will use it whenever you have received payments from any of your customers and want to apply those payments to the customer's ...

    • ARMENU Accounts Receivable Package Overview

      Package Overview How to Use This Manual When most people receive a new product they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a reference ...

    • ARAGEMNU Accounts Receivable Aging Reports

      Reports Aging Reports Application Overview The Aging Reports are reports that can tell you a great deal about the state of a customer's account. It will tell you how much the customer owes you, and how old these owed amounts are. In A/R Setup, you ...

    • ARCSHSCN Accounts Receivable Cash Projection Report

      Cash Projection Report Application Overview The Cash Projection Report graph application facilitates Elliott reporting features by plotting the anticipated future revenue outlook of your organization. It processes information obtained from the A/R ...

    • ARCTLMNT Accounts Receivable A/R Setup

      A/R Setup Application Overview A/R Setup is not an application that you will be running very often. In this application, you will answer some questions that tailor the Accounts Receivable package to the way you do accounting in your company. For ...