Sales Cash Receipts Report window

SalesCS > Sales > Reporting menu > Sales Cash Receipts Report window

The Cash Receipts Report determines the amount of revenue generated in cash for a specified range of invoices, batches, registers, dates, and salespeople. A variety of sort options make this report a useful tool for balancing registers, evaluating salesperson performance, monitoring inventory, and more.

Include

Use these check boxes to specify the type(s) of transactions you want to include in the report.

Orders

These are transactions entered in the Sales Order Entry window.

These are transactions entered in the Sales POS Register window.

Job Cost

This option is available if you select Posted from the Transaction Type drop-down. Select this check box to include transactions entered in the Sales Order Entry window from Job Cost.

Include Layaway Payments

Select this check box to include layaway payments in the report. This option is only available if you have Layaway activated in the Sales module. The default for this check box (if visible) is checked.

Transaction Type

• Posted: include only posted transactions from the sales history file in your report. If you select this option, the Order Batch start and end range will be unavailable.

• Unposted: include only current unposted transactions.

Report Type

• Detailed (default): the Detailed report shows the transaction number, sales department, salesperson, customer number, customer name, invoice number, transaction date, module, cash amount, check amount, net cash/check/credit card amount, charge amount, total payment, and transaction total for each transaction.

• Condensed: the Condensed report shows group totals according to the sort option selected.

• Summary: the Summary report shows only the totals for cash receipts selected.

Invoice / Receipt Type

Specify what type(s) of invoices to include in the report.

• Cash Invoice: this will include invoices that were paid by cash, and will include monies that were received on account.

• Check Invoice: this will include invoices that were paid by check.

• Credit Card: this will include invoices that were charged to a credit card.

• Charge Invoice: this will include invoices that were charged to the customers’ in-house charge account.

• Debit Card: this will include invoices that were paid with a debit card.

• All: this will include all of the above payment types.

Subtotals

This option is only available if you select either Detailed or Condensed in the Report Type drop-down list. If you want the report to be subtotaled, select from the following options: Register / Batch, Salesperson, Sales Department, Customer Number, Invoice Number, and Transaction Number. The default for this option is None, which means there will be no subtotals on the report.

Start and End Ranges: Order Batch, Sales Register, Date, Invoice/Receipt Number, and Salesperson

These boxes allow you to define the range of items to include on the report. You can include a single item by entering the same value in both boxes. These settings will include all items that meet the remaining criteria in the window. The defaults for Order Batch, Sales Register, Invoice/Receipt Number, and Salesperson are Start and End. The default for the Date Start is the first date of your fiscal calendar, and the default for the Date End is the current system date.

If you left the Orders check box unchecked or selected Posted as the Transaction Type, then the Order Batch range will be unavailable.

Date Range

From the drop-down, select a predefined period to run the report for.