<?xml version="1.0" encoding="utf-8"?>
<FormatImport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <oKind>TransactionCurrent</oKind>
  <stName>Format qif Quicken</stName>
  <stExtension>qif</stExtension>
  <oDateOrder>MDY</oDateOrder>
  <stDateDelimiter>/</stDateDelimiter>
  <bYear4Digits>false</bYear4Digits>
  <oFormatMonth>Numerical</oFormatMonth>
  <oFieldSeparator>PointVirgule</oFieldSeparator>
  <stDecimalSeparator>.</stDecimalSeparator>
  <stTimeSeparator>:</stTimeSeparator>
  <stTextSeparator>"</stTextSeparator>
  <bStartRow>false</bStartRow>
  <strListOfRules>
    <FormatRule>
      <stDescription>Type Carte</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCheque</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^Carte.*</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Carte Bancaire</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>"CB à renommer"</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type DAB</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCheque</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^DAB.*</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Retrait Espèce par carte</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>"CB à renommer"</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type Prélvmt</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCheque</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^Prélvmt.*</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VMTREC</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCheque</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VMTREC.*</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VIRMT</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCheque</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIRMT.*</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Virement Intercomptes</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type DEP</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCheque</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^DEP.*</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Espèce reçue</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Suppression de la nature REVENUS des catégories</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCategory</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>REVENUS</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>REVENUS~</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Suppression de la nature DEPENSES des catégories</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCategory</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>DEPENSES</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>DEPENSES~</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Mise au format du tiers, de la catégorie et sous catégorie</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>\s+~ </stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>Trim</oAction>
          <oResultColumn />
          <stResultText> </stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>\s+~ </stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>Trim</oAction>
          <oResultColumn />
          <stResultText> </stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>\s+~ </stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>Trim</oAction>
          <oResultColumn />
          <stResultText> </stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
  </strListOfRules>
</FormatImport>