Version 7.5
Version 7.5
Contents of this Topic: Show
If a user runs different reports for a given time period and the results do not match, it is most likely because different reports use different dates. For example, the "Sales Tax" report uses the Order Date but the "Sales Tax from History" report uses the History date. Each report is designed to present information in different ways.
To determine which report template is used by the program when a report title is selected at the Print Reports screen, go to the Main Menu > Settings > System Functions > System Parameters and check the settings of the parameter related to a specific report type. Refer to the Report System Parameter Group topic for details about parameters that affect reports.
As far as sales reports are concerned, since most merchants do not agree on which date constitutes an actual sale, we offer a number of different sales reports that use different dates. For example, one merchant may consider the date they got paid to be the actual sale date while another merchant may consider the date the order was placed to be the actual sale date. We suggest that the merchant and their accountant decide which date constitutes an actual sale and then use only those reports which use that date.
Provides an order level detail of Gross Sales, Taxes, Shipping, Surcharges, Discounts, Returns, Net Sales (gross-returns) and Cost of Goods.
Can provide a summary breakdown for approved orders, pending orders and for the full report.
The report can be run as a "summary only", eliminating the order level detail.
Gross sales data is reported based on the "quantity shipped" rather than the "quantity ordered".
Can be based on three different dates which produces different values for SOME numbers
Order date
Detail date
Actual Shipped date
User defined date range
Based on the actual order data
Changes based on order revisions
Designed to give a state level breakdown of taxes collected
Depending on format can also provide taxable sales data
Based on Order Date
Report assumes all line items are taxable
Assumes the Bill To state for tax reporting – based on sale not destination
Gives the user an item level breakdown by order of SKU, name, product category, net items sold (shipped minus returns), price, cost, margins, date entered and date shipped
Can be based on Order Date or Actual Date Shipped
Can be limited to certain products or inventory category
Pulls information directly from the Order data so information can change within a given period
Informational report not designed for accounting purposes
Based on Transaction date
One or more transactions dates per order
Pulls from transactions table
Limited to the four primary card types
Best used to verify charges against gateway
Will seldom balance against sales for the same period
Provides a product level breakdown of MTD/YTD comparison to LMTD/LYTD sales based upon criteria specified by user
Report is run against Order Details and will change over time
Uses Actual Ship Date and will not be accurate if actual ship date not set
SKUs no longer listed in the Inventory table will not be included in the report results regardless of date shipped
Provides gross sales (based on quantity shipped) and gross costs, Return sales and costs, net sales and costs
Determines margin based on net sales - net cost
Report can be based on Transaction Date or Actual Date Shipped
Can repeat sales data in multiple periods if based on transaction date
Summary report based on transaction audit system
Auditing system based on Transaction Date
Auditing system only audits standard payment methods
Best used for verification of charges against gateway
Returns same type of data provided by Accounting Summary Report
Based on Order "History" thus single Date used
Only reports on approved orders
Initial History generated at time order is approved
Additional history written as changes are made
History information dated at time change is made
Report results DO NOT change over time
More accurate accounting results
Pulls data from "History"
Based on a single date
Data does not change over time
Calculates Taxable sales values correctly
Correct state identified
Accurate for accounting purposes
Created:
Revised: 9/5/13
Published: 04/14/16