﻿<?xml version="1.0" encoding="utf-8"?>
<CrossTab xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" AppVersion="3.2.5.36101" xmlns="http://www.ajbsystems.net">
  <UserIDLastEdited>AJBSystems</UserIDLastEdited>Requires one sales file and corresponding Cost of Sales file. 
Shows monthly and annual Gross Margin %.

For further details and sample output, search the IFP Help Centre for 'Cost of Sales Analysis'.<ClassificationVariables /><Columns><CrossTabColumn><OutputColIndex>1</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>010101</ColumnCode><ColumnHeaders>Jan|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>2</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>010102</ColumnCode><ColumnHeaders>Jan|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>3</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0102</ColumnCode><ColumnHeaders>Jan|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>4</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>0301#0.0</ColumnCode><ColumnHeaders>Jan|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>5</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>020201</ColumnCode><ColumnHeaders>Feb|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>6</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>020202</ColumnCode><ColumnHeaders>Feb|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>7</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0506</ColumnCode><ColumnHeaders>Feb|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>8</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>0705#0.0</ColumnCode><ColumnHeaders>Feb|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>9</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>030301</ColumnCode><ColumnHeaders>Mar|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>10</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>030302</ColumnCode><ColumnHeaders>Mar|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>11</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0910</ColumnCode><ColumnHeaders>Mar|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>12</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>1109#0.0</ColumnCode><ColumnHeaders>Mar|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>13</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>040401</ColumnCode><ColumnHeaders>Apr|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>14</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>040402</ColumnCode><ColumnHeaders>Apr|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>15</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1314</ColumnCode><ColumnHeaders>Apr|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>16</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>1513#0.0</ColumnCode><ColumnHeaders>Apr|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>17</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>050501</ColumnCode><ColumnHeaders>May|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>18</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>050502</ColumnCode><ColumnHeaders>May|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>19</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1718</ColumnCode><ColumnHeaders>May|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>20</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>1917#0.0</ColumnCode><ColumnHeaders>May|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>21</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>060601</ColumnCode><ColumnHeaders>Jun|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>22</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>060602</ColumnCode><ColumnHeaders>Jun|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>23</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2122</ColumnCode><ColumnHeaders>Jun|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>24</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>2321#0.0</ColumnCode><ColumnHeaders>Jun |% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>25</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>070701</ColumnCode><ColumnHeaders>Jul|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>26</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>070702</ColumnCode><ColumnHeaders>Jul|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>27</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2526</ColumnCode><ColumnHeaders>Jul|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>28</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>2725#0.0</ColumnCode><ColumnHeaders>Jul|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>29</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>080801</ColumnCode><ColumnHeaders>Aug|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>30</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>080802</ColumnCode><ColumnHeaders>Aug|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>31</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2930</ColumnCode><ColumnHeaders>Aug|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>32</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>3129#0.0</ColumnCode><ColumnHeaders>Aug|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>33</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>090901</ColumnCode><ColumnHeaders>Sep|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>34</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>090902</ColumnCode><ColumnHeaders>Sep|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>35</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>3334</ColumnCode><ColumnHeaders>Sep|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>36</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>3533#0.0</ColumnCode><ColumnHeaders>Sep|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>37</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>101001</ColumnCode><ColumnHeaders>Oct|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>38</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>101002</ColumnCode><ColumnHeaders>Oct|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>39</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>3738</ColumnCode><ColumnHeaders>Oct|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>40</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>3937#0.0</ColumnCode><ColumnHeaders>Oct|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>41</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>111101</ColumnCode><ColumnHeaders>Nov|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>42</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>111102</ColumnCode><ColumnHeaders>Nov|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>43</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>4142</ColumnCode><ColumnHeaders>Nov|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>44</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>4341#0.0</ColumnCode><ColumnHeaders>Nov|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>45</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>121201</ColumnCode><ColumnHeaders>Dec|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>46</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>121202</ColumnCode><ColumnHeaders>Dec|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>47</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>4546</ColumnCode><ColumnHeaders>Dec|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>48</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>4745#0.0</ColumnCode><ColumnHeaders>Dec|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>49</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011201</ColumnCode><ColumnHeaders>Annual|Sales</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>50</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>011202</ColumnCode><ColumnHeaders>Annual|COGS</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>51</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>4950</ColumnCode><ColumnHeaders>Annual|GM</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>52</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>ColumnXasPercentageOfColumnY</ColumnType><ColumnCode>5149#0.0</ColumnCode><ColumnHeaders>Annual|% GM</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn></Columns><OutputPercentTotalColumns>false</OutputPercentTotalColumns><OutputTotalsColumns>false</OutputTotalsColumns></CrossTab>