Net Sales Report vs. Cash Flow Report

Net Sales Report vs. Cash Flow Report

Two reports in OrderLogix that are commonly compared are the Net Sales Report and the Cash Flow Report. This article will outline how you will want to run these two reports so that the data is comparable as well as limitations that may prevent you from having matching totals between the two reports.

 

Between the two reports, the $ Net Total Revenue in the Net Sales Report and the Total Amount in the Cash Flow Report should be equal if you have considered all the points below.

 

Dates – The date range in the Cash Flow Report is the date range of the successful payment transaction. To ensure that you are comparing the same data between the two reports you will want to ensure that you select “Payment Date” from the Date Type filter in the Net Sales Report.

Refunds – The Cash Flow Report displays debit and credit payment transactions by default, while the Net Sales Report only includes debits. Be sure to filter the Cash Flow report by Transaction Type of “Debit Only”

Order Type – The Cash Flow Report will show transactions for all Order Types by default, whereas the Net Sales report will only show types of “Regular” and “Enrollment” unless you select “All” from the Order Type drop down.

 

A major difference between the Net Sales Report and the Cash Flow Report that you will want to keep in mind when comparing totals between these two reports is that the Cash Flow Report will include tax while the Net Sales report will not. If you do charge tax for orders included in these reports, then your totals between the two reports will not match.

 

If you have any questions regarding these reports, please refer to the Report Definitions for both of these reports Net Sales: http://support.orderlogix.com/index.php?/Knowledgebase/Article/View/288/71/net-sales-report-definitions Cash Flow: http://support.orderlogix.com/index.php?/Knowledgebase/Article/View/269/70/cash-flow-report-definitions

Any further questions can be directed to OrderLogix Customer Care by submitting a support request.

    • Related Articles

    • Sales By Origin Report includes Continuity Orders

      The Sales By Origin Report, located under Reports -> Sales Reports, includes Continuity Orders in its totals. Currently the only way to filter out continuity shipments from the Sales by Origin Report is if the subsequent product offers are setup with ...

    • Using Coupon Codes on Imports vs Manually Entered Orders

      Module: Advertising Path: Company Data -> Advertising -> Coupon Codes Topic: Import vs Manual Orders and Coupon Codes Version(s):   Editions:  Coupon codes on imported orders differ from coupon codes on manually entered orders in that they are ...

    • Promo Codes VS Coupon Codes

      Promo Codes Promo Codes do not apply any discounts. They are tied to Sources and DNISes in the system and provide an additional way of tracking your advertising. Promo codes populate the KEY_CODE field of our standard imports. Promo codes can also be ...

    • Report to Display ReShips

      If you are looking for a report that will provide a list of orders for which a reship has been issued, the "Customer Service Activity" report can provide this information. The report can be filtered to show orders with items that have been ...

    • Commission Report Definitions

      This report is a look at what would be processed for commissions if they were run at that moment. Commission Report Column Definitions Employee # Employee number Employee Name Employee name # Items The number of items on orders placed in the date ...