Order tracking for accounting.

in Xcart, export - 

     Orders (without images) in one file {orders}

     Order items (without images) in one file {orderlineitems}

     Coupons & products in one file

     Combine orders in single worksheet with column A being store tag (SUN, ESS, etc.), column B being month, C being day, D being year

     This formula will generate the truncated date (calc in separate sheet, copy and paste over original) for original date in column B with target location being column C: 

                     {Column C} =MID(LEFT(B2,(LEN(B2)-12)),(FIND("y ",LEFT(B2,(LEN(B2)-12)))+2),20)

     Pull month, day, and year with these formulas for truncated date generated in column C: 

                     {Column F} =MID(C2,4,LEN(C2)-8)

                     {Column G} =LEFT(C2,2)

                     {Column H} =RIGHT(C2,4)

     Create a pivot table for: (tbd)

income by month

product sales

coupon usage

(sending this spreadsheet home separately)

in Paypal, export reciepts.

     tag purchases by hand (commercial or personal use items)

     commercial use is deductible.