The bank's file against the books.
At the end of each day the payment provider sends a settlement file: every capture and refund it settled, with its fee. The matcher pairs each line with the ledger by reference. Whatever doesn't pair is a break, and a person looks at it. In the demo a day is compressed to a few minutes.
Settled days
- 3 Nov, 17:20131 lines2 breaks
- 3 Nov, 17:10119 lines6 breaks
- 3 Nov, 17:00144 lines2 breaks
- 3 Nov, 16:50115 lines2 breaks
- 3 Nov, 16:40140 lines2 breaks
- 3 Nov, 16:30108 lines2 breaks
- 3 Nov, 16:20117 lines3 breaks
- 3 Nov, 16:10138 lines2 breaks
- 3 Nov, 16:00109 lines1 break
- 3 Nov, 15:50147 lines5 breaks
- 3 Nov, 15:40140 lines2 breaks
- 3 Nov, 15:30144 lines6 breaks
- 3 Nov, 15:20114 linesclean
- 3 Nov, 15:10130 lines6 breaks
3 Nov, 15:50
Gross
€3,400.00
PSP fee
€54.79
Net to the bank
€3,345.21
Settlement journal
#363668
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1a222-2a52-7a12-a428-1421e4677530 is already settled by stl_EUR_2989535 line 125
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- fee differencethe fee is not the contract feethe fee is 38, the contract says 37
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- missing linein the books, not in the filecapture:01a1a21c-fbac-7637-931d-d364fb9bf1a3 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 69 | capture | 01a1a21e-65cc-7cee-9dee-dcd17b6ec805 | €9.00 | €0.23 | fee difference |
| 122 | capture | 01a1a221-fe3d-714f-bdd5-0a4a738c71e1 | €24.00 | €0.38 | fee difference |
| 126 | refund | 01a1a222-2a54-76e6-a1f3-7c7289ddbed9 | -€12.00 | €0.00 | duplicate line |
| 129 | capture | 01a1a222-5d1c-7341-ac9b-0da9a4f44308 | €35.00 | €0.53 | fee difference |
| 1 | capture | 01a1a211-71c8-7b14-a0ec-45065825db00 | €15.00 | €0.26 | matched |
| 2 | capture | 01a1a212-dd88-75c7-b64f-5ce79eb6c2d3 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1a216-872a-7f72-aa96-8fca43fb3146 | €9.00 | €0.19 | matched |
| 4 | capture | 01a1a21a-70f6-7cde-a430-79ce8dde70a9 | €9.00 | €0.19 | matched |
| 5 | capture | 01a1a21a-85a7-77dd-915c-e92c00146330 | €35.00 | €0.50 | matched |
| 6 | refund | 01a1a21a-8d4d-7e84-af28-8b84401b098c | -€19.00 | €0.00 | matched |
| 7 | capture | 01a1a21a-98a0-7a7d-b8ec-388c87ab084e | €49.00 | €0.67 | matched |
| 8 | capture | 01a1a21a-a081-77d1-bab6-70fe8225c481 | €35.00 | €0.50 | matched |
| 9 | capture | 01a1a21a-a096-7bc7-8547-509e934d2827 | €35.00 | €0.50 | matched |
| 10 | capture | 01a1a21a-a974-7bc6-b559-4c8a16571c26 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1a21a-bb75-7899-8d5d-65f1555524a2 | €24.00 | €0.37 | matched |
| 12 | capture | 01a1a21a-bda1-71f3-85df-e451ad4fd975 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1a21a-cc0f-7168-89d4-d0fa449899f7 | €49.00 | €0.67 | matched |
| 14 | capture | 01a1a21a-f957-7652-897b-6810e240b917 | €15.00 | €0.26 | matched |
| 15 | capture | 01a1a21b-05d8-7ff6-8a0d-4a939bb1f719 | €15.00 | €0.26 | matched |
| 16 | capture | 01a1a21b-2692-7145-a176-4202f1812b4e | €24.00 | €0.37 | matched |
| 17 | capture | 01a1a21b-26f5-73c4-8376-641f716ab317 | €15.00 | €0.26 | matched |
| 18 | refund | 01a1a21b-2ab2-7fd9-8574-95a1b02646c2 | -€28.00 | €0.00 | matched |
| 19 | capture | 01a1a21b-2c5b-7e18-ad5f-42a78bde9ec8 | €9.00 | €0.19 | matched |
| 20 | capture | 01a1a21b-5862-7494-b559-b91ab53b1528 | €9.00 | €0.19 | matched |
| 21 | capture | 01a1a21b-69f4-720a-bc6d-84a03b52bf70 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1a21b-8579-7510-b41d-3f89a08fb0c2 | €9.00 | €0.19 | matched |
| 23 | capture | 01a1a21b-8b10-7679-a9d0-a36a1322639c | €35.00 | €0.50 | matched |
| 24 | capture | 01a1a21b-8cab-7128-a18d-4c474f38e577 | €49.00 | €0.67 | matched |
| 25 | capture | 01a1a21b-9895-78df-bbff-70e23bc57fac | €49.00 | €0.67 | matched |
| 26 | capture | 01a1a21b-994f-745b-b066-205caf5b714e | €24.00 | €0.37 | matched |
| 27 | capture | 01a1a21b-c003-7e91-884a-e81f3f3e4336 | €49.00 | €0.67 | matched |
| 28 | capture | 01a1a21b-c9a7-7f45-bfc6-23710bb25dde | €24.00 | €0.37 | matched |
| 29 | capture | 01a1a21b-cbe0-7e94-8d63-68569cebb028 | €15.00 | €0.26 | matched |
| 30 | capture | 01a1a21b-da69-7404-bfc7-04a320778069 | €49.00 | €0.67 | matched |
| 31 | capture | 01a1a21b-fecb-7741-89b2-d91f566dab9c | €15.00 | €0.26 | matched |
| 32 | capture | 01a1a21c-00f3-7e2c-b65d-5214194c727f | €15.00 | €0.26 | matched |
| 33 | capture | 01a1a21c-02ae-746e-9ae0-68884b2e01b7 | €49.00 | €0.67 | matched |
| 34 | capture | 01a1a21c-05ea-7910-b01a-9945191c0c71 | €49.00 | €0.67 | matched |
| 35 | capture | 01a1a21c-11d7-7ba8-82db-d61cb1e6b8af | €15.00 | €0.26 | matched |
| 36 | capture | 01a1a21c-16a3-7802-950f-6dfb7c2b565d | €15.00 | €0.26 | matched |
| 37 | capture | 01a1a21c-559b-7477-bee9-8fe1eeb397fd | €35.00 | €0.50 | matched |
| 38 | capture | 01a1a21c-6426-757c-aba3-9c5540e37472 | €49.00 | €0.67 | matched |
| 39 | capture | 01a1a21c-7d4f-7f11-9c14-b9f11b5690fd | €49.00 | €0.67 | matched |
| 40 | capture | 01a1a21c-9f85-72f3-b350-5269e668ad00 | €15.00 | €0.26 | matched |
| 41 | capture | 01a1a21c-b976-7a8e-b187-c0052f0c2027 | €49.00 | €0.67 | matched |
| 42 | refund | 01a1a21c-be78-7f5b-9f0b-3717f6d6f9f7 | -€15.00 | €0.00 | matched |
| 43 | capture | 01a1a21c-be8a-75d2-a730-57c5167fd354 | €15.00 | €0.26 | matched |
| 44 | capture | 01a1a21c-e536-731f-a549-01731f61e0cc | €49.00 | €0.67 | matched |
| 45 | capture | 01a1a21c-ee8a-7260-ba48-d5b6cae9acf9 | €9.00 | €0.19 | matched |
| 46 | capture | 01a1a21d-1fe5-7654-a1d7-807d0b255950 | €24.00 | €0.37 | matched |
| 47 | capture | 01a1a21d-309b-742f-9493-405fafa833a4 | €9.00 | €0.19 | matched |
| 48 | capture | 01a1a21d-36ed-73de-860c-83ff7de96951 | €24.00 | €0.37 | matched |
| 49 | capture | 01a1a21d-4756-7013-9be3-613bc26e855e | €15.00 | €0.26 | matched |
| 50 | capture | 01a1a21d-47b0-75cd-821c-84df22cc1af3 | €35.00 | €0.50 | matched |
| 51 | capture | 01a1a21d-5b48-7e8d-a2d0-7b8529413660 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1a21d-6f93-7c03-ad6f-abcdf6ce8f2d | €49.00 | €0.67 | matched |
| 53 | capture | 01a1a21d-7cc2-7027-875b-06b417019700 | €24.00 | €0.37 | matched |
| 54 | capture | 01a1a21d-abe6-7371-b581-b34b2d4d733f | €15.00 | €0.26 | matched |
| 55 | refund | 01a1a21d-b652-7c2a-9661-b2313f65afd1 | -€12.00 | €0.00 | matched |
| 56 | capture | 01a1a21d-b8e2-73d1-972f-2736031b6486 | €24.00 | €0.37 | matched |
| 57 | capture | 01a1a21d-c35e-7914-85ea-a6723a58bd31 | €35.00 | €0.50 | matched |
| 58 | capture | 01a1a21d-dfb7-7499-9360-d242dea27107 | €35.00 | €0.50 | matched |
| 59 | capture | 01a1a21d-e593-764e-8ef6-975353372631 | €35.00 | €0.50 | matched |
| 60 | capture | 01a1a21d-e821-7163-83a6-ba2525ede202 | €35.00 | €0.50 | matched |
| 61 | capture | 01a1a21d-e94c-7c46-a803-48a99203d99e | €24.00 | €0.37 | matched |
| 62 | capture | 01a1a21d-f361-7bf0-8543-e84395e892b7 | €24.00 | €0.37 | matched |
| 63 | capture | 01a1a21e-0238-7229-b9d8-8c2c4e9a2c11 | €24.00 | €0.37 | matched |
| 64 | refund | 01a1a21e-229a-7313-8230-173b3c5acef4 | -€32.00 | €0.00 | matched |
| 65 | capture | 01a1a21e-2a1d-72e4-abd8-429d341b30bc | €49.00 | €0.67 | matched |
| 66 | capture | 01a1a21e-2ca3-7d9e-9d08-500b68dd6838 | €15.00 | €0.26 | matched |
| 67 | capture | 01a1a21e-3031-798f-85b8-02e1d3c61f8a | €35.00 | €0.50 | matched |
| 68 | capture | 01a1a21e-36a5-7f28-b5d7-c64ed115be20 | €49.00 | €0.67 | matched |
| 70 | capture | 01a1a21e-8860-713b-9316-fb37fbc854c9 | €49.00 | €0.67 | matched |
| 71 | capture | 01a1a21e-9a6d-75a9-9499-d25c3cb3c960 | €49.00 | €0.67 | matched |
| 72 | refund | 01a1a21e-9a84-7aa2-92f6-5816d0c45ca0 | -€33.00 | €0.00 | matched |
| 73 | capture | 01a1a21e-a0a1-7248-8427-b36087c1ce3e | €49.00 | €0.67 | matched |
| 74 | capture | 01a1a21e-9d95-7fae-86f7-4f4fbe812fc0 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1a21e-c55b-7286-9633-294d4e8f6127 | €35.00 | €0.50 | matched |
| 76 | refund | 01a1a21e-c722-7c63-a5d2-a3dcc8576b75 | -€6.00 | €0.00 | matched |
| 77 | capture | 01a1a21e-dec8-717a-be67-c76a26dba5e1 | €24.00 | €0.37 | matched |
| 78 | capture | 01a1a21f-0c02-7ea6-9cfd-0adc744dbe84 | €49.00 | €0.67 | matched |
| 79 | capture | 01a1a21f-180e-72a6-9699-83ca5ddf5337 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1a21f-282f-7feb-9b5f-9b57f04ef0f4 | €9.00 | €0.19 | matched |
| 81 | capture | 01a1a21f-458b-7b3d-9bfd-13f00c9d3dfe | €15.00 | €0.26 | matched |
| 82 | capture | 01a1a21f-55b6-770b-8730-652af8abd926 | €49.00 | €0.67 | matched |
| 83 | capture | 01a1a21f-5e30-75fc-92f2-b51a86dae949 | €49.00 | €0.67 | matched |
| 84 | capture | 01a1a21f-6648-7e85-bcc7-a46e3c5e88b6 | €9.00 | €0.19 | matched |
| 85 | capture | 01a1a21f-6792-7951-9bb4-18a939bf6ff0 | €9.00 | €0.19 | matched |
| 86 | capture | 01a1a21f-78da-78a5-a573-9f8839601097 | €24.00 | €0.37 | matched |
| 87 | refund | 01a1a21f-7fea-7a91-853c-cbb11a91aeca | -€29.00 | €0.00 | matched |
| 88 | capture | 01a1a21f-81ae-7cd6-85fc-01d538f79d25 | €9.00 | €0.19 | matched |
| 89 | capture | 01a1a21f-c270-74cc-bbaa-493803a7fa21 | €24.00 | €0.37 | matched |
| 90 | capture | 01a1a21f-cb3f-7116-931a-74bbb0596c60 | €49.00 | €0.67 | matched |
| 91 | capture | 01a1a21f-e7d1-77b7-83ac-77e5cbc8583a | €35.00 | €0.50 | matched |
| 92 | capture | 01a1a220-0613-728f-89c7-6151488af3dc | €15.00 | €0.26 | matched |
| 93 | capture | 01a1a220-141c-7a22-a75c-52426f1132dd | €9.00 | €0.19 | matched |
| 94 | capture | 01a1a220-2719-7414-ad51-01a499b73a94 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1a220-53e6-7c64-a51d-058a507f5068 | €49.00 | €0.67 | matched |
| 96 | capture | 01a1a220-3f04-73a1-a3e0-0d717f30f4d4 | €49.00 | €0.67 | matched |
| 97 | capture | 01a1a220-715b-7d6e-aad5-1fe3c2789471 | €15.00 | €0.26 | matched |
| 98 | refund | 01a1a220-93ed-7fd9-9ea8-e773d4fbb5be | -€20.00 | €0.00 | matched |
| 99 | capture | 01a1a220-9630-75c3-847c-f9e540976c6f | €35.00 | €0.50 | matched |
| 100 | capture | 01a1a220-a005-78c2-b84e-43ed718fa184 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1a220-a51f-70c6-8789-1b81f1ed5495 | €24.00 | €0.37 | matched |
| 102 | capture | 01a1a220-b28b-7416-8f98-025a0c13c701 | €24.00 | €0.37 | matched |
| 103 | capture | 01a1a220-b4e4-78b2-9ac7-814f0645a424 | €35.00 | €0.50 | matched |
| 104 | capture | 01a1a220-b57b-70fe-9033-dd6c0dcc222b | €15.00 | €0.26 | matched |
| 105 | capture | 01a1a220-f215-7b8d-ab98-fa15f046895e | €15.00 | €0.26 | matched |
| 106 | refund | 01a1a220-f97b-72b1-88aa-ca397d931e53 | -€27.00 | €0.00 | matched |
| 107 | capture | 01a1a221-0809-738a-9e40-7e4fb6cd53c4 | €15.00 | €0.26 | matched |
| 108 | capture | 01a1a221-0a7d-7339-97da-5b72e2751430 | €15.00 | €0.26 | matched |
| 109 | capture | 01a1a221-0aa9-7543-b389-8805e42c78ee | €24.00 | €0.37 | matched |
| 110 | capture | 01a1a221-15ab-71e5-985b-198ea6eb36d4 | €9.00 | €0.19 | matched |
| 111 | capture | 01a1a221-2dc2-73fb-9541-2e59a39a60e9 | €9.00 | €0.19 | matched |
| 112 | capture | 01a1a221-47e5-797a-8fce-613af319a10d | €24.00 | €0.37 | matched |
| 113 | capture | 01a1a221-56c1-7d36-a277-4eeb0145e857 | €9.00 | €0.19 | matched |
| 114 | capture | 01a1a221-6b81-7497-977a-f4f7a6f0cf6c | €9.00 | €0.19 | matched |
| 115 | capture | 01a1a221-6eb2-7133-a631-9edfcc08e165 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1a221-9c5d-75ea-b760-18bb3fd93e73 | €15.00 | €0.26 | matched |
| 117 | capture | 01a1a221-a28e-7e2d-8129-a9038d48e1d8 | €15.00 | €0.26 | matched |
| 118 | capture | 01a1a221-cca9-7369-8408-253d28553433 | €15.00 | €0.26 | matched |
| 119 | capture | 01a1a221-dabf-78e4-a63e-bcb6e133f474 | €9.00 | €0.19 | matched |
| 120 | capture | 01a1a221-efd7-7e5c-8c42-af153d196c65 | €49.00 | €0.67 | matched |
| 121 | capture | 01a1a221-f713-738f-a064-8a022549b616 | €24.00 | €0.37 | matched |
| 123 | capture | 01a1a222-000b-721c-87e7-ed47c22884b2 | €24.00 | €0.37 | matched |
| 124 | capture | 01a1a222-29d2-7562-888c-fc2b0277a1a0 | €49.00 | €0.67 | matched |
| 125 | refund | 01a1a222-2a54-76e6-a1f3-7c7289ddbed9 | -€12.00 | €0.00 | matched |
| 127 | capture | 01a1a222-2aac-7c73-8310-cbd80704c5aa | €9.00 | €0.19 | matched |
| 128 | capture | 01a1a222-3e35-77a4-b7b8-9c3c3aea4614 | €35.00 | €0.50 | matched |
| 130 | capture | 01a1a222-6897-7dab-9c53-3f9298c6c062 | €49.00 | €0.67 | matched |
| 131 | capture | 01a1a222-691e-7404-ba01-2d434515852d | €35.00 | €0.50 | matched |
| 132 | capture | 01a1a222-7af4-7320-b2e3-82c506f56d67 | €15.00 | €0.26 | matched |
| 133 | capture | 01a1a222-86c3-70ec-827b-efbb17d86dd0 | €49.00 | €0.67 | matched |
| 134 | capture | 01a1a222-885c-7616-a549-bc3d92d151f6 | €9.00 | €0.19 | matched |
| 135 | capture | 01a1a222-8f22-7a7e-bf5f-2b1849bc85d4 | €24.00 | €0.37 | matched |
| 136 | capture | 01a1a222-9632-7fa2-8b89-e9d80ae8b0d1 | €9.00 | €0.19 | matched |
| 137 | capture | 01a1a222-b7fa-7145-ab49-1a1eda1e0650 | €15.00 | €0.26 | matched |
| 138 | capture | 01a1a222-c7f7-7809-a9d0-c6ac402c2214 | €15.00 | €0.26 | matched |
| 139 | refund | 01a1a222-caf9-7506-9b0a-3d60bf5ff641 | -€7.00 | €0.00 | matched |
| 140 | capture | 01a1a222-d205-7c6d-ad1c-d43dbcc6a1ae | €9.00 | €0.19 | matched |
| 141 | capture | 01a1a222-d22d-782d-a9e2-a1255cbeb5cc | €9.00 | €0.19 | matched |
| 142 | capture | 01a1a222-ebe5-73ad-89c3-ecc3a566019e | €15.00 | €0.26 | matched |
| 143 | capture | 01a1a222-ed5b-747d-abc0-4b3002ce4fc5 | €35.00 | €0.50 | matched |
| 144 | capture | 01a1a222-ff6f-756f-85e1-a0bd67da085b | €24.00 | €0.37 | matched |
| 145 | capture | 01a1a223-24d8-701e-bd7e-d96f8374bc02 | €49.00 | €0.67 | matched |
| 146 | capture | 01a1a223-35a7-7364-999e-a65f4fd6e64b | €49.00 | €0.67 | matched |
| 147 | capture | 01a1a223-4a8b-74e0-9768-3ee1cdab64f7 | €9.00 | €0.19 | matched |