Midoco Booking Journal Export Use Cases and Example
Use cases and a worked example of the booking-journal export.
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 Booking Journal Export file.
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:
| Account ID | Account Type | Account Name |
|---|---|---|
| 100002 | account receivable | Fishmonger Inc. (the client of the TMC) |
| 300000 | account receivable | ONYX Commission Chasing Services |
| 590006 | account payable | IATA/BSP |
| 590007 | account payable | Best Western Hotels |
| 580000 | account payable | Accrual Purchases (used for all suppliers) |
| 4000 | revenue | Sales Invoices |
| 4001 | revenue | Agency Fees |
| 4900 | revenue | Supplier Commission |
| 5000 | expense | Cost of Sales |
| 5900 | expense | Cost of Sales Accruals |
| 9600 | allocation account debit | Credit Card Allocation Account |
| 1200 | nominal | Bank Current Account |
This example TMC does not use Summary Accounts/Control Accounts for AP/AR.
Use Cases
| Use Case Description | related journal ID(s) in the Midoco Journal and in the Midoco Standard Accounting Export files | |
|---|---|---|
| 1 | A sales invoice (invoice number 2000902) worth 267.20 GBP to client Fishmonger Inc. is issued for a trip comprised of:
| The sales invoices positions get individual journal ids:
|
| 2 | The sales invoice is charged to the clients Mastercard, the PSP issued a payment reference for this payment: 20250926123 | 46370 |
| 3 | On issuing the sales invoice while there are no purchase invoices, yet, purchase accruals are created automatically:
(no commission accruals set up for this Midoco environment) |
|
| 4 | The BSP settlement (purchase invoice, invoice number BSP0925) for the flight is reconciled and booked. BSP charges 126.20 GBP for the ticket. | 46374 |
| 5 | Automatically, when booking the purchase invoice for the flight, the purchase accrual for the flight is voided: -126.20 GBP | 46373 |
| 6 | The hotel´s purchase invoice (invoice number BWH260925) is reconciled. It contains 20% input tax which is included in the purchase price of 98.00 GBP (81.67 GBP net + 16.33 GBP input tax = 98.00 GBP purchase price total. | 46376 |
| 7 | Automatically, when booking the purchase invoice for the hotel, the net purchase accrual for the hotel is voided: -81.67 GBP | 46375 |
| 8 | The purchase invoice to the hotel is paid by bank transfer. The bank statement with the statement reference 20250926Bank shows the debit transaction of 98.00 GBP allocating the suppliers account payable for the purchase invoice number BWH060525. | 46377 |
| 9 | ONYX sends a commission credit note for the hotel service granting 9.80 GBP incl. output tax (8.17 GBP net + 1.63 GBP tax - commission credit note number ONYX060525 | 46378 |
Related Midoco Journals
| Journal ID | Transaction Date | Transaction Reference | Debit Account | Deb. Name | Credit Account | Crd. Name | Amount | Original Amount | Original Currency | Booking Text/Descr. | VAT Code | VAT Percent | VAT Amount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46371 | 26.09.2025 | 102269 | 5900 | Cost of Sales Accruals | 580000 | ACCRUAL PURCHASE | 126.20 | 0.00 | Purchase Accrual 6313558773682 102269 | 0.00 | 0.00 | ||
| 46372 | 26.09.2025 | 102269 | 5900 | Cost of Sales Accruals | 580000 | ACCRUAL PURCHASE | 81.67 | 0.00 | Purchase Accrual 5741777BW 102269 | 0.00 | 0.00 | ||
| 46373 | 26.09.2025 | 102269 | 5900 | Cost of Sales Accruals | 580000 | ACCRUAL PURCHASE | -126.20 | 0.00 | Cancel Purchase Accrual 6313558773682 102269 | 0.00 | 0.00 | ||
| 46375 | 26.09.2025 | 102269 | 5900 | Cost of Sales Accruals | 580000 | ACCRUAL PURCHASE | -81.67 | 0.00 | Cancel Purchase Accrual 5741777BW 102269 | 0.00 | 0.00 | ||
| 46364 | 26.09.2025 | 2000960 | 100002 | Fishmonger Inc.,Fishtown | 4000 | Sales Revenue | 126.20 | Sales Revenue 6313558773682 | 0.00 | 0.00 | |||
| 46365 | 26.09.2025 | 2000960 | 100002 | Fishmonger Inc.,Fishtown | 4000 | Sales Revenue | 15.00 | Sales Revenue 6313558773682 | 0.00 | 0.00 | |||
| 46366 | 26.09.2025 | 2000960 | 100002 | Fishmonger Inc.,Fishtown | 4001 | Service Fee | 12.00 | FEE Corporate Ticket 6313558773682 | 0.00 | 0.00 | |||
| 46367 | 26.09.2025 | 2000960 | 100002 | Fishmonger Inc.,Fishtown | 4001 | Service Fee | -3.00 | FEE Corporate Ticket Discount 6313558773682 | 0.00 | 0.00 | |||
| 46368 | 26.09.2025 | 2000960 | 100002 | Fishmonger Inc.,Fishtown | 4000 | Sales Revenue | 111.00 | Sales Revenue 5741777BW | full output VAT | 20.00 | 18.50 | ||
| 46369 | 26.09.2025 | 2000960 | 100002 | Fishmonger Inc.,Fishtown | 4001 | Service Fee | 6.00 | Corporate Fee Hotel 5741777BW | 0.00 | 0.00 | |||
| 46370 | 26.09.2025 | 2000960 | 9600 | CC Payment | 100002 | Fishmonger Inc.,Fishtown | 267.20 | MC 20250926123 540000XXXXXX9691 | 0.00 | 0.00 | |||
| 46377 | 26.09.2025 | 20250926Bank | 590007 | Best Western Hotel | 1200 | Bank account | 98.00 | Best Western Purchase Invoice BWH260925 | |||||
| 46374 | 26.09.2025 | BSP0925 | 5000 | Cost of Sales | 590006 | IATA (new) | 126.20 | Purchase Invoice 102269 | 0% input VAT | 0.00 | 0.00 | ||
| 46376 | 26.09.2025 | BWH260925 | 5000 | Cost of Sales | 590007 | Best Western Hotel | 98.00 | Purchase Invoice 102269 | full input VAT | 20.00 | 16.33 | ||
| 46378 | 26.09.2025 | ONYX260925 | 300000 | Onyx Commission Chasing | 4900 | Supplier Commission | 9.80 | 0.00 | Commission 2025-05-07 Best Western 102269 Fishmonger Inc. | full output VAT | 20.00 | 1.63 |