> For the complete documentation index, see [llms.txt](https://docs.milientsoftware.com/help/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.milientsoftware.com/help/moment-by-topic/integrations/file-exports/file-export-accounting-system/xledger/format-gl02b.md).

# Format GL02b

The GL02b is a Xledger file format specifically to be used for accounting data.

This export requires tag groups if the option to set specific account receivable and/or revenue account will be used. Read more about tags [here](/help/setup/tags.md). 

## Configuration

To configure Xledger (GL02b) file export see the common explanation in [here](/help/moment-by-topic/integrations/file-exports/file-export-accounting-system/xledger.md#common). 

The specific fields that are unique to the GL02b format are the fields "Customer ledger account" and "Owner code".<br>

<figure><img src="/files/vwcH70QQhWkS4wSnmNKf" alt=""><figcaption></figcaption></figure>

### Account receivable

Select the tag group containing tags corresponding with financial accounts that can be set as account receivable for customers.\
\
To use this feature it's required to create a tag group that will contain the accounts that can be selected.

Example of tag used for this:

<figure><img src="/files/Lr0XKdLNRFkHUlBDrTe6" alt=""><figcaption></figcaption></figure>

Note! It's the tag code field that is used by the export, this is required for the export.

### Revenue account

Select the tag group containing tags corresponding with financial accounts that can be set as revenue account for customers.

To use this feature it's required to create a tag group that will contain the accounts that can be used.

Example of tag used for this:

<figure><img src="/files/9dY3cWlzfxFOdma8ZFUk" alt=""><figcaption></figcaption></figure>

Note! It's the tag code field that is used by the export, this is required for the export.

### Owner Code

This field is used to identify the your company in Xledger, register your id here. This is a required field.

### Configured

Example of a configured export

* Department from project
* Tag group "Account receivable" used for named purpose
* Tag group "Revenue" used for named purpose
* Owner code registered

<figure><img src="/files/WN0fGVP6DjIZdpMpExq8" alt=""><figcaption></figcaption></figure>

## File

The file is a CSV file where semi-colon (;) is used as the separator.

### Format

* Date format: yyyymmdd
* Decimal separator: . (period)

## Columns

<table><thead><tr><th width="168">Description</th><th width="172.33333333333331">Column # </th><th>Excel Column</th><th>Format</th><th>Max length</th><th>Comment</th><th>Mandatory</th></tr></thead><tbody><tr><td>ImpSystem</td><td>1</td><td>A</td><td></td><td>25</td><td>Always "GL02b"</td><td>No</td></tr><tr><td>ImpSystemRef</td><td>2</td><td>B</td><td></td><td>25</td><td>Always "Moment"</td><td>No</td></tr><tr><td>Entity</td><td>3</td><td>C</td><td></td><td></td><td>Entity code</td><td>Yes</td></tr><tr><td>VoucherType</td><td>4</td><td>D</td><td></td><td>8</td><td>VoucherType in XLEDGER.NET</td><td>Yes</td></tr><tr><td>VoucherNo</td><td>5</td><td>E</td><td>nnnn</td><td>8</td><td>Imported voucher no.</td><td>Yes</td></tr><tr><td>FiscalYear</td><td>6</td><td>F</td><td>yyyy</td><td>4</td><td>Accounting period year from Voucher Date</td><td>No</td></tr><tr><td>PeriodNo</td><td>7</td><td>G</td><td>nn</td><td>2</td><td>Accounting period month from Voucher Date</td><td>No</td></tr><tr><td>VoucherDate</td><td>8</td><td>H</td><td>yyyymmdd</td><td></td><td>Voucher Date</td><td>Yes</td></tr><tr><td>Account</td><td>9</td><td>I</td><td></td><td>25</td><td>Account</td><td>Yes</td></tr><tr><td>AccountLedger</td><td>10</td><td>J</td><td></td><td>25</td><td>Ledger account</td><td>No</td></tr><tr><td>Posting1</td><td>11</td><td>K</td><td></td><td>25</td><td>Cost Center/Department</td><td>No</td></tr><tr><td>Posting2</td><td>12</td><td>L</td><td></td><td>25</td><td>Project</td><td>No</td></tr><tr><td>XGL</td><td>13</td><td>M</td><td></td><td>25</td><td>Object value for XGL</td><td>No</td></tr><tr><td>Our Ref (Imp)</td><td>14</td><td>N</td><td></td><td>25</td><td>Our ref posting value</td><td>No</td></tr><tr><td>Period Start (Imp)</td><td>15</td><td>O</td><td></td><td></td><td>Defines start period</td><td>No</td></tr><tr><td>No of Periods</td><td>16</td><td>P</td><td></td><td></td><td>Used for periodization</td><td>No</td></tr><tr><td>Pay Method (Imp)</td><td>17</td><td>Q</td><td></td><td>255</td><td>Defines payment method</td><td>No</td></tr><tr><td>Pay Code Int</td><td>18</td><td>R</td><td></td><td></td><td></td><td>No</td></tr><tr><td>Pay Doc Code (Imp)</td><td>19</td><td>S</td><td></td><td>25</td><td></td><td>No</td></tr><tr><td>Pay Doc Text</td><td>20</td><td>T</td><td></td><td>50</td><td></td><td>No</td></tr><tr><td>SubledgerNo</td><td>21</td><td>U</td><td></td><td>25</td><td>Customer No or Supplier No</td><td>No</td></tr><tr><td>SubledgerName</td><td>22</td><td>V</td><td></td><td>2555</td><td>Name of customer/supplier</td><td>No</td></tr><tr><td>InvoiceDate</td><td>23</td><td>W</td><td>yyyymmdd</td><td></td><td>Invoice Date</td><td>No</td></tr><tr><td>InvoiceNo</td><td>24</td><td>X</td><td></td><td>50</td><td>Invoice Number</td><td>No</td></tr><tr><td>XIdentifier(KID/OCR)</td><td>25</td><td>Y</td><td></td><td>50</td><td>KID/OCR</td><td>No</td></tr><tr><td>DueDate</td><td>26</td><td>Z</td><td>yyyymmdd</td><td></td><td>Due Date</td><td>No</td></tr><tr><td>SubledgerBankAccount</td><td>27</td><td>AA</td><td></td><td>50</td><td></td><td>No</td></tr><tr><td>PaymentTerms</td><td>28</td><td>AB</td><td></td><td>25</td><td></td><td>No</td></tr><tr><td>Text</td><td>29</td><td>AC</td><td></td><td>255</td><td>Transaction text</td><td>No</td></tr><tr><td>TaxRule</td><td>30</td><td>AD</td><td></td><td>25</td><td>Tax rule</td><td></td></tr><tr><td>Currency</td><td>31</td><td>AE</td><td></td><td>25</td><td>Currency code</td><td></td></tr><tr><td>CurrencyAmount</td><td>32</td><td>AF</td><td>nnnn.nn</td><td></td><td>Amount in selected currency</td><td></td></tr><tr><td>Amount</td><td>33</td><td>AG</td><td>nnnn.nn</td><td></td><td>Amount in company currency</td><td></td></tr><tr><td>Amount 3 (Imp)</td><td>34</td><td>AH</td><td></td><td></td><td></td><td></td></tr><tr><td>Amount 4 (Imp)</td><td>35</td><td>AI</td><td></td><td></td><td></td><td></td></tr><tr><td>Amount 5 (Imp)</td><td>36</td><td>AJ</td><td></td><td></td><td></td><td></td></tr><tr><td>UpdateSubledger</td><td>37</td><td>AK</td><td>n</td><td></td><td>If set to 1, address field will be updated</td><td></td></tr><tr><td>SubledgerGroup</td><td>38</td><td>AL</td><td></td><td>25</td><td>Only used when creating a new subledger</td><td>No</td></tr><tr><td>CompanyNo</td><td>39</td><td>AM</td><td></td><td>25</td><td></td><td></td></tr><tr><td>StreetAddress1</td><td>40</td><td>AN</td><td></td><td>255</td><td></td><td></td></tr><tr><td>StreetAddress2</td><td>41</td><td>AO</td><td></td><td>255</td><td></td><td></td></tr><tr><td>ZipCode</td><td>42</td><td>AP</td><td></td><td>25</td><td></td><td></td></tr><tr><td>Place</td><td>43</td><td>AQ</td><td></td><td>255</td><td></td><td></td></tr><tr><td>State</td><td>44</td><td>AR</td><td></td><td>50</td><td></td><td></td></tr><tr><td>Country</td><td>45</td><td>AS</td><td></td><td>25</td><td></td><td></td></tr><tr><td>BillingStreetAddress</td><td>46</td><td>AT</td><td></td><td>255</td><td></td><td></td></tr><tr><td>BillingStreetAddress2</td><td>47</td><td>AU</td><td></td><td>255</td><td></td><td></td></tr><tr><td>BillingZipCode</td><td>48</td><td>AV</td><td></td><td>25</td><td></td><td></td></tr><tr><td>BillingPlace</td><td>49</td><td>AW</td><td></td><td>255</td><td></td><td></td></tr><tr><td>BillingState</td><td>50</td><td>AX</td><td></td><td>25</td><td></td><td></td></tr><tr><td>BillingCountry</td><td>51</td><td>AY</td><td></td><td>25</td><td></td><td></td></tr><tr><td>Phone</td><td>52</td><td>AZ</td><td></td><td>50</td><td></td><td></td></tr><tr><td>Email</td><td>53</td><td>BA</td><td></td><td>50</td><td></td><td></td></tr><tr><td>YourRef</td><td>54</td><td>BB</td><td></td><td>255</td><td></td><td></td></tr><tr><td>Archive No</td><td>55</td><td>BC</td><td></td><td></td><td>Allows for defining archive number</td><td></td></tr><tr><td>Workflow</td><td>56</td><td>BD</td><td></td><td>1</td><td>0 if voucher will bypass workflow<br>1 if voucher will enter workflow</td><td></td></tr><tr><td>Posting 3</td><td>57</td><td>BE</td><td></td><td>255</td><td></td><td></td></tr><tr><td>Posting 4</td><td>58</td><td>BF</td><td></td><td>255</td><td></td><td></td></tr><tr><td>Posting 5</td><td>59</td><td>BG</td><td></td><td>255</td><td></td><td></td></tr><tr><td>Dummy</td><td>60</td><td>BH</td><td></td><td>255</td><td>not in use</td><td></td></tr><tr><td>EOL</td><td>61</td><td>BI</td><td></td><td>25</td><td>Last column, always "x"</td><td></td></tr></tbody></table>