Sales Payment Spreadsheet Explanation of Summary

Go Back to List of FAQs  Previous  Next

Explanation of the Summary Area of the Sales Payment Spreadsheet

 

clip0200

 

At the bottom of the Sales Payment Spreadsheet Report there are various numbers. They can't be added up to get the total as they may have overlap. This report is not to be used for accounting, but for a review of the day's activity.

 

The totals which *can* be summed up from the lines above are in the totals line - such as Cash, Subtotal, etc.

 

*) Special orders        = Value of sales flagged special orders

 

*) Memo        = Value of ITEMS flagged as memo

      (there might be an overlap if you have a memo item on

      special order sale however, that would be balanced by

       a reduction in Other Sales)

 

*) Other Sales  = Whatever portion is NOT any of charge, special, memo, layaway, out of state,  resale, repairs, labor.

 It's a forced balance account and could be negative in cases where there is overlap in

 some of the other sales subtotals.

 

*) Resale        = Sales to customers marked with either a Wholesale level,

             Tax Exempt or a Resale Number  [and if the sale had no tax]

 

*) Labor        = Value of ITEMS from major class codes of type 1 or 2

             (repair or custom work) for non-taxable items if

              the state has a sales tax usually for merchandise

              There could be an overlap with repairs

 

*) Repair        = Value of ITEMS from major class codes of type 1 or 2

             (repair or custom work) for non-taxable items if

              the state has a sales tax usually for merchandise

 

*) Layaway        = Finalized layaway / repair sales

             There could be an overlap with repairs/labor

---

The repair box is added to for items where the Repair category (on the

major  code screen ) is set to 1 (std repairs) or 2  (extended repairs)

The labor box is added to for items where there is NO tax and where

the Repair category (on the major code screen ) is set to 1 (std repairs)

or  2 (extended repairs)

i.e. it appears there's an overlap and the labor box value is included

in the repair box value - but it's only the non-taxable portion.