This page intends to illustrate the export files content for common use cases.

It compares the Midoco Journals provided in Midoco Midoffice and the respective Midoco Standard Accounting Export files.

Note: The examples were compiled in a UK based test environment in Midoco.

The Tax Codes set up for this test environment are (may well be completely different for your country and for your use cases):

Example Tax Codes

• Standard Tax Rate (20%) = T20
• Reduced Tax Rate (5%) = T5
• Zero Rated (0%) = T0
• Tax Exempt = TExempt

Account IDs

The accounts used in this Use Case example are:

Use Cases

Related Midoco Journals

Related Midoco Standard Accounting Export Files

The export is a zip-archive comprised of multiple XML files: Midoco06.05.25.zip

For the use cases above the files are:

MIDCONTACTS

Contains all the contact information related to clients and suppliers found in this export file.

<?xml version="1.0" encoding="UTF-8"?><BusinessContacts>
   <BusinessContact accountCode="100002" accountType="AR" currency="GBP" midocoCustomerId="80375">
      <CompanyName1>Fishmonger Inc.</CompanyName1>
      <CompanyName2>
      </CompanyName2>
      <Adresses>
         <Address isDefault="true" midocoAddressId="66979">
            <AddressLine1>3 North Square</AddressLine1>
            <City>Aberdeen</City>
            <ZipCode>AB11 5DX</ZipCode>
            <State>
            </State>
            <CountryId>GB</CountryId>
         </Address>
      </Adresses>
      <PaymentTypes/>
   </BusinessContact>
   <BusinessContact accountCode="300000" accountType="AR" currency="GBP" midocoCustomerId="81199">
      <CompanyName1>Onyx CenterSource</CompanyName1>
      <CompanyName2>
      </CompanyName2>
      <Adresses>
         <Address isDefault="true" midocoAddressId="67820">
            <AddressLine1>5420 LBJ Freeway, Suite 900</AddressLine1>
            <AddressLine2>Two Lincoln Centre</AddressLine2>
            <City>Dallas</City>
            <ZipCode>75240</ZipCode>
            <State>TX</State>
            <CountryId>US</CountryId>
         </Address>
      </Adresses>
      <PaymentTypes/>
   </BusinessContact>
   <BusinessContact accountCode="590006" accountType="AP" currency="GBP" midocoCustomerId="81197">
      <CompanyName1>International Air Transport Association</CompanyName1>
      <CompanyName2>
      </CompanyName2>
      <Adresses>
         <Address isDefault="true" midocoAddressId="67818">
            <AddressLine1>800 Rue du Square-Victoria</AddressLine1>
            <City>Montreal</City>
            <ZipCode>QC H4Z 1M</ZipCode>
            <State>QC</State>
            <CountryId>CA</CountryId>
         </Address>
      </Adresses>
   </BusinessContact>
   <BusinessContact accountCode="590007" accountType="AP" currency="GBP" midocoCustomerId="81198">
      <CompanyName1>Best Western International, Inc.</CompanyName1>
      <CompanyName2>
      </CompanyName2>
      <Adresses>
         <Address isDefault="true" midocoAddressId="67819">
            <AddressLine1>Old Nass Road</AddressLine1>
            <AddressLine2>Unit 7 Citylink Business Park</AddressLine2>
            <City>Dublin</City>
            <ZipCode>12</ZipCode>
            <State>
            </State>
            <CountryId>IE</CountryId>
         </Address>
      </Adresses>
   </BusinessContact>
</BusinessContacts>

MIDCINVOICES

Contains the sales invoice, the sales invoice´s credit card payment and the commission invoice values.

<?xml version="1.0" encoding="UTF-8"?><Invoices>
   <Invoice accountType="AR" exportId="849" receiverId="4711" senderId="MIDOCO">
      <Header accountCode="100002">
         <TransactionReference>2000902</TransactionReference>
         <TransactionDate>20250506</TransactionDate>
         <BookingDate>20250506</BookingDate>
         <DueDate>20250506</DueDate>
         <Currency>GBP</Currency>
         <CurrencyRate>1.0</CurrencyRate>
         <TotalAmount>267.20</TotalAmount>
         <TotalBaseAmount>267.20</TotalBaseAmount>
      </Header>
      <DetailLine midocoJournalId="46118">
         <LineDescription>Sales Revenue 6313558773682</LineDescription>
         <LineAccountCode>4000</LineAccountCode>
         <LineDCIndicator>C</LineDCIndicator>
         <LineTotalAmount>126.20</LineTotalAmount>
         <LineTotalBaseAmount>126.20</LineTotalBaseAmount>
         <LineReference>6313558773682</LineReference>
         <Taxes>
            <TaxElement taxCode="T0">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
      <DetailLine midocoJournalId="46119">
         <LineDescription>Sales Revenue 6313558773682</LineDescription>
         <LineAccountCode>4000</LineAccountCode>
         <LineDCIndicator>C</LineDCIndicator>
         <LineTotalAmount>15.00</LineTotalAmount>
         <LineTotalBaseAmount>15.00</LineTotalBaseAmount>
         <LineReference>6313558773682</LineReference>
         <Taxes>
            <TaxElement taxCode="T0">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
      <DetailLine midocoJournalId="46120">
         <LineDescription>FEE Corporate Ticket 6313558773682</LineDescription>
         <LineAccountCode>4001</LineAccountCode>
         <LineDCIndicator>C</LineDCIndicator>
         <LineTotalAmount>12.00</LineTotalAmount>
         <LineTotalBaseAmount>12.00</LineTotalBaseAmount>
         <LineReference>6313558773682</LineReference>
         <Taxes>
            <TaxElement taxCode="T0">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
      <DetailLine midocoJournalId="46121">
         <LineDescription>FEE Corporate Ticket Discount 6313558773682</LineDescription>
         <LineAccountCode>4001</LineAccountCode>
         <LineDCIndicator>D</LineDCIndicator>
         <LineTotalAmount>3.00</LineTotalAmount>
         <LineTotalBaseAmount>3.00</LineTotalBaseAmount>
         <LineReference>6313558773682</LineReference>
         <Taxes>
            <TaxElement taxCode="T0">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
      <DetailLine midocoJournalId="46122">
         <LineDescription>Sales Revenue 5741777BW</LineDescription>
         <LineAccountCode>4000</LineAccountCode>
         <LineDCIndicator>C</LineDCIndicator>
         <LineTotalAmount>111.00</LineTotalAmount>
         <LineTotalBaseAmount>111.00</LineTotalBaseAmount>
         <LineReference>5741777BW</LineReference>
         <Taxes>
            <TaxElement taxCode="T20">
               <Amount>18.50</Amount>
               <RelatedNetAmount>18.50</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
      <DetailLine midocoJournalId="46123">
         <LineDescription>Corporate Fee Hotel 5741777BW</LineDescription>
         <LineAccountCode>4001</LineAccountCode>
         <LineDCIndicator>C</LineDCIndicator>
         <LineTotalAmount>6.00</LineTotalAmount>
         <LineTotalBaseAmount>6.00</LineTotalBaseAmount>
         <LineReference>5741777BW</LineReference>
         <Taxes>
            <TaxElement taxCode="T0">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
      <Payment paymentAccountCode="9600">
         <TransactionDate>20250506</TransactionDate>
         <TransactionReference>20250506123</TransactionReference>
         <PaymentAmount>267.20</PaymentAmount>
         <PaymentBaseAmount>267.20</PaymentBaseAmount>
         <Currency>GBP</Currency>
         <CurrencyRate>1.0</CurrencyRate>
      </Payment>
      <Documents>
         <Document filename="Invoice_2000902.pdf">
            <Link url="https://midoffice.midoco.net/ws/ExportDocument?orgunit=Travel+Management+Partner&repositoryId=76770561&checksum=1988"/>
         </Document>
      </Documents>
   </Invoice>
   <Invoice accountType="AR" exportId="849" receiverId="4711" senderId="MIDOCO">
      <Header accountCode="300000">
         <TransactionReference>ONYX060525-46138</TransactionReference>
         <TransactionDate>20250506</TransactionDate>
         <BookingDate>20250506</BookingDate>
         <DueDate>20250506</DueDate>
         <Currency>GBP</Currency>
         <CurrencyRate>1.0</CurrencyRate>
         <TotalAmount>9.80</TotalAmount>
         <TotalBaseAmount>9.80</TotalBaseAmount>
         <ClearingReference>ONYX060525</ClearingReference>
      </Header>
      <DetailLine midocoJournalId="46138">
         <LineDescription>Commission 2025-05-07 Best Western 102197 Fishmonger Inc.</LineDescription>
         <LineAccountCode>4900</LineAccountCode>
         <LineDCIndicator>C</LineDCIndicator>
         <LineTotalAmount>9.80</LineTotalAmount>
         <LineTotalBaseAmount>9.80</LineTotalBaseAmount>
         <LineReference>102197</LineReference>
         <Taxes>
            <TaxElement taxCode="T20">
               <Amount>1.63</Amount>
               <RelatedNetAmount>1.63</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
   </Invoice>
</Invoices>

MIDSINVOICES

Is comprised of the purchase accruals and the purchase invoices.

<?xml version="1.0" encoding="UTF-8"?><Invoices>
   <Invoice accountType="AP" exportId="849" receiverId="4711" senderId="MIDOCO">
      <Header accountCode="580000">
         <TransactionReference>102197-46125-46125</TransactionReference>
         <TransactionDate>20250506</TransactionDate>
         <BookingDate>20250506</BookingDate>
         <DueDate>20250506</DueDate>
         <Currency>GBP</Currency>
         <CurrencyRate>1.0</CurrencyRate>
         <TotalAmount>207.87</TotalAmount>
         <TotalBaseAmount>207.87</TotalBaseAmount>
         <ClearingReference>102197</ClearingReference>
      </Header>
      <DetailLine midocoJournalId="46125">
         <LineDescription>Purchase Accrual 6313558773682 102197</LineDescription>
         <LineAccountCode>5900</LineAccountCode>
         <LineDCIndicator>D</LineDCIndicator>
         <LineTotalAmount>126.20</LineTotalAmount>
         <LineTotalBaseAmount>126.20</LineTotalBaseAmount>
         <LineReference>102197</LineReference>
         <Taxes>
            <TaxElement taxCode="TExempt">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
      <DetailLine midocoJournalId="46126">
         <LineDescription>Purchase Accrual 5741777BW 102197</LineDescription>
         <LineAccountCode>5900</LineAccountCode>
         <LineDCIndicator>D</LineDCIndicator>
         <LineTotalAmount>81.67</LineTotalAmount>
         <LineTotalBaseAmount>81.67</LineTotalBaseAmount>
         <LineReference>102197</LineReference>
         <Taxes>
            <TaxElement taxCode="TExempt">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
   </Invoice>
   <Invoice accountType="AP" exportId="849" receiverId="4711" senderId="MIDOCO">
      <Header accountCode="590006">
         <TransactionReference>BSP0525-46128</TransactionReference>
         <TransactionDate>20250506</TransactionDate>
         <BookingDate>20250506</BookingDate>
         <DueDate>20250506</DueDate>
         <Currency>GBP</Currency>
         <CurrencyRate>1.0</CurrencyRate>
         <TotalAmount>126.20</TotalAmount>
         <TotalBaseAmount>126.20</TotalBaseAmount>
         <ClearingReference>BSP0525</ClearingReference>
      </Header>
      <DetailLine midocoJournalId="46128">
         <LineDescription>Purchase Invoice  102197</LineDescription>
         <LineAccountCode>5000</LineAccountCode>
         <LineDCIndicator>D</LineDCIndicator>
         <LineTotalAmount>126.20</LineTotalAmount>
         <LineTotalBaseAmount>126.20</LineTotalBaseAmount>
         <LineReference>102197</LineReference>
         <Taxes>
            <TaxElement taxCode="T0">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
   </Invoice>
   <Invoice accountType="AP" exportId="849" receiverId="4711" senderId="MIDOCO">
      <Header accountCode="590007">
         <TransactionReference>BWH060525-46130</TransactionReference>
         <TransactionDate>20250506</TransactionDate>
         <BookingDate>20250506</BookingDate>
         <DueDate>20250506</DueDate>
         <Currency>GBP</Currency>
         <CurrencyRate>1.0</CurrencyRate>
         <TotalAmount>98.00</TotalAmount>
         <TotalBaseAmount>98.00</TotalBaseAmount>
         <ClearingReference>BWH060525</ClearingReference>
      </Header>
      <DetailLine midocoJournalId="46130">
         <LineDescription>Purchase Invoice  102197</LineDescription>
         <LineAccountCode>5000</LineAccountCode>
         <LineDCIndicator>D</LineDCIndicator>
         <LineTotalAmount>98.00</LineTotalAmount>
         <LineTotalBaseAmount>98.00</LineTotalBaseAmount>
         <LineReference>102197</LineReference>
         <Taxes>
            <TaxElement taxCode="T20">
               <Amount>16.33</Amount>
               <RelatedNetAmount>16.33</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
   </Invoice>
</Invoices>

MIDSCREDITNOTES

Contains the purchase accrual voids which were created when the suppliers purchase invoice was booked.

<?xml version="1.0" encoding="UTF-8"?><CreditNotes>
   <CreditNote exportId="849" receiverId="4711" senderId="MIDOCO">
      <Header accountCode="580000">
         <TransactionReference>102197-46127-46127</TransactionReference>
         <TransactionDate>20250506</TransactionDate>
         <BookingDate>20250506</BookingDate>
         <DueDate>20250506</DueDate>
         <Currency>GBP</Currency>
         <CurrencyRate>1.0</CurrencyRate>
         <TotalAmount>207.87</TotalAmount>
         <TotalBaseAmount>207.87</TotalBaseAmount>
         <ClearingReference>102197</ClearingReference>
         <CreditReference>102197</CreditReference>
      </Header>
      <DetailLine midocoJournalId="46127">
         <LineDescription>Cancel Purchase Accrual 6313558773682 102197</LineDescription>
         <LineAccountCode>5900</LineAccountCode>
         <LineDCIndicator>C</LineDCIndicator>
         <LineTotalAmount>-126.20</LineTotalAmount>
         <LineTotalBaseAmount>-126.20</LineTotalBaseAmount>
         <LineReference>102197</LineReference>
         <Taxes>
            <TaxElement taxCode="TExempt">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
      <DetailLine midocoJournalId="46129">
         <LineDescription>Cancel Purchase Accrual 5741777BW 102197</LineDescription>
         <LineAccountCode>5900</LineAccountCode>
         <LineDCIndicator>C</LineDCIndicator>
         <LineTotalAmount>-81.67</LineTotalAmount>
         <LineTotalBaseAmount>-81.67</LineTotalBaseAmount>
         <LineReference>102197</LineReference>
         <Taxes>
            <TaxElement taxCode="TExempt">
               <Amount>0.00</Amount>
               <RelatedNetAmount>0.00</RelatedNetAmount>
            </TaxElement>
         </Taxes>
      </DetailLine>
   </CreditNote>
</CreditNotes>

MIDSOUTPAYMENTS

Contains the payment of the supplier invoice (Best Western).

<?xml version="1.0" encoding="UTF-8"?><APPayments>
   <PaymentTransaction midocoJournalId="46131">
      <TransactionDate>20250506</TransactionDate>
      <TransactionReference>20250506Bank</TransactionReference>
      <PaymentAccountCode>1200</PaymentAccountCode>
      <PaymentCode>
      </PaymentCode>
      <Currency>GBP</Currency>
      <CurrencyRate>1.0</CurrencyRate>
      <Amount>98.00</Amount>
      <BaseAmount>98.00</BaseAmount>
      <PaymentReference>BWH060525</PaymentReference>
   </PaymentTransaction>
</APPayments>