Customer Deposit Report

This Help File Page was last Modified on 09/17/2018

<< Click to Display Table of Contents >>

Navigation:  Accounts Receivable System - The Receivables Module > Receivable Reports - An Overview >

Customer Deposit Report

This Help File Page was last Modified on 09/17/2018

The Customer Deposit Report displays a Grid with all of the designated Receipts listed (based on the Option selected) which may be Printed and/or Exported, as needed.

There are two ways to access the Customer Deposit Report dialog:

a)From the Backstage Menu System Select Reports and Choose Receivable Reports, or

b)From the Quick Access Menu, Select Reports and Choose Receivable Reports.

Then, Select the Customer Deposit Report option.

 

HelpFilesCustomerDepositReport

Customer Deposit Report - Options & Grid view

 

Setting Up the Customer Deposit Report dialog's data grid Options:

 

HelpFilesCustomerDepositReport-Options

Customer Deposit Report - Options & Icons:  Date Range, Retrieve Data, Print, Export, Email, Go To Subscriber

 

Reporting Options:

All Customer Deposits - All Receipts that were ever identified as a Customer Deposit (that field had been Checked) will be included in this Customer Deposit Report dialog.

Deposited and Not Converted - Receipts that are still identified as a Customer Deposit and have been Deposited in the Bank will be included in this Customer Deposit Report dialog.

Deposited and Converted - Receipts that were initially identified as a Customer Deposit and have been Deposited in the Bank and before of after being Deposited were converted to a (standard) Receipt and will be included in this Customer Deposit Report dialog.

Not Deposited - Receipts that are still identified as a Customer Deposit and have not been Deposited in the Bank

Current Customer Deposits Liability - This shows Receipts marked as a Customer Deposit, subtracts any Amount that was Refunded from those Receipts and displays it as the Amount paid;  and also subtracts any Receipt that was Allocated ((thereby "paying off some portion of an Invoice, causing a reduction in your Company's Accounts Receivable balance) within the designated Date Range (see "Reporting Date Range" immediately below).  

Note The Amount from Current Customer Deposits Liability should match the Customer Deposit Liability Mandatory General Ledger Account listed in the Balance Sheet report if the Start Date is 01/01/1985 and the End Date is the same as the As Of Date entered for the Balance Sheet.

Converted Customer Deposits - These are Receipts originally marked as a Customer Deposit which have subsequently been Allocated (thereby "paying off some portion of an Invoice, causing a reduction in your Company's Accounts Receivable balance).

 

Reporting Date Range:

Start - By default, the Starting Date will be the first Day of the current Month.

oUse the Drop-Down Date/Calendar box to Choose another Starting Date.

End - By default, the Ending Date will be the current Day of the current Month.

oUse the Drop-Down Date/Calendar box to Choose another Ending Date.

 

Retrieve Data - Click this Icon to populate the grid based on the selected Reporting Option and Date Range entered.

 

Go To Options - Right-Click on any line item within the Grid to open the Radial Right-Click Menu to access the Go To Subscriber (which will open the associated Subscriber Form), or Open Receipt option (which will open the associated Receipt Form).

 

HelpFilesCustomerDepositReport-RadialMenu

Customer Deposit Report - data-grid - Radial Right-Click menu

 

Print - Once the data has been formatted, filtered, sorted and configured as needed, Click the Print Icon to see the Print Preview of the selected data.

See the "Printing the Customer Deposit Report dialog's data grid" discussion below for more information

 

Export - Once the data has been formatted, filtered, sorted and configured as needed, Click the Export Icon to display the standard Windows® Save As dialog.

See the data grid chapter for more information.

 

EMail - Once the data has been formatted, filtered, sorted and configured as needed, Click the EMail Icon to send this data as a PDF attachment to an Email address of your choosing.

 

Go To Subscriber - Select a specific Customer Deposit record and Click this Icon to open that Subscriber Form.

 

Columns - Select which columns of data are to be displayed in the Customer Deposit Report:

 

HelpFilesCustomerDepositReport-ColumnHeaderOptions

Customer Deposit Report - Column Header Name options

 

Click the asterisk (¬) at the left of the data grid's Header row (see the mouse pointer in the illustration above) to display a list of all of the column names - and associated data - which may be displayed.

By default, all Column Names will be Checked.

Remove the Check mark (Click on the Check to remove it) to hide that column of data from the data grid.

 

Setting the Order in which the data in the grid is Listed within the Customer Deposit Report:

The default sorted order of the Customer Deposit Report List is based on the Subscriber's Name - which is ordered from lowest to highest (1 - 9, a-z, then A - Z).

Thereafter, the column that determines the sorted order of the List may be easily changed, whenever needed.

 

HelpFilesCustomerDepositReport-ColumnSortingOption

Customer Deposit Report - Data Grid sorted by Date Paid - oldest to newest

To do so:

Click another column's Header Name (the mouse points to the sorting arrow within the Date Paid Header Name in the illustration above) to change the sorted order to by on that column of data, with the sorted order automatically set from lowest to highest (a-z or 1 - 9).  

To change this newly selected column's sorted order from highest to lowest, Click that column's Header Name again.

An Arrow next to the Header Name indicates the column that is determining the sorted order of the Grid Data.

o~ indicates lowest to highest (a-z or 1 - 9)

o indicates highest to lowest (z-a or 9-1).

 

See the Accounts Receivable As Of chapter for information about sorting, filtering and rearranging the columns and data within the Grid.

 

Printing the Customer Deposit Report dialog's data grid:

Print - Once you have:

a)Chosen which columns of data are to be included,

b)Set the order in which they are to be listed, related any columns (if appropriate),

c)Adjusted any column's width,

d)Then, you are ready to Print the resulting Customer Deposit Report.

 

Click the Print Icon at the top of the Form to display the Print Preview dialog.

 

HelpFilesCustomerDepositReport-PrintPreview

 

The Print Preview dialog will be displayed exactly as the data grid was formatted.

It is easy to Close the Print Preview, make formatting adjustments (if needed), then Click the Print Icon again until you have the Customer Deposit Report displayed in the Print Preview dialog exactly as needed.

The example above illustrates how a Customer Deposit Report may ultimately be customized, formatted and printed (or exported as a PDF file).

 

See the Grids & Lists - Print Preview - Exporting Data chapter for much more information about formatting and printing (and exporting) the Accounts Receivable As Of Form's data grid