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
- 30 Oct, 06:20136 lines2 breaks
- 30 Oct, 06:10112 lines3 breaks
- 30 Oct, 06:00151 linesclean
- 30 Oct, 05:50114 lines2 breaks
- 30 Oct, 05:40123 lines1 break
- 30 Oct, 05:30118 lines3 breaks
- 30 Oct, 05:20125 lines3 breaks
- 30 Oct, 05:10111 lines3 breaks
- 30 Oct, 05:00151 lines3 breaks
- 30 Oct, 04:50124 lines1 break
- 30 Oct, 04:40137 lines6 breaks
- 30 Oct, 04:30123 lines3 breaks
- 30 Oct, 04:20121 lines3 breaks
- 30 Oct, 04:10123 lines1 break
30 Oct, 05:00
Gross
€3,482.00
PSP fee
€55.47
Net to the bank
€3,426.53
Settlement journal
#282134
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a18b35-a1e5-733b-ba77-1b57000999c4 is already settled by stl_EUR_2988894 line 131
- fee differencethe fee is not the contract feethe fee is 31, the contract says 26
- missing linein the books, not in the filecapture:01a18b35-c7d5-74f7-9492-a2f2763e73d0 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 58 | capture | 01a18b30-e803-7913-a57d-f5e089bc7ba2 | €15.00 | €0.31 | fee difference |
| 132 | refund | 01a18b35-a1e7-75a9-9db3-28da133386f8 | -€24.00 | €0.00 | duplicate line |
| 1 | capture | 01a18b27-056c-7d5d-8a42-155fcf537656 | €35.00 | €0.50 | matched |
| 2 | capture | 01a18b2a-080f-7d66-8acc-2996856bcd6b | €49.00 | €0.67 | matched |
| 3 | capture | 01a18b2d-505e-7e93-82fd-f9e1b1bd7916 | €9.00 | €0.19 | matched |
| 4 | capture | 01a18b2d-8a2f-774d-9a92-2991ec6bd067 | €35.00 | €0.50 | matched |
| 5 | capture | 01a18b2d-e2bb-710a-baac-1e941109b046 | €24.00 | €0.37 | matched |
| 6 | capture | 01a18b2d-eb11-716e-881c-4a75c89fa91c | €15.00 | €0.26 | matched |
| 7 | capture | 01a18b2e-0173-756b-a3d6-3e106f7adcff | €15.00 | €0.26 | matched |
| 8 | capture | 01a18b2e-19dc-7e0d-abf5-9d03c224c402 | €15.00 | €0.26 | matched |
| 9 | capture | 01a18b2e-1e7b-7222-87e2-00b381618151 | €35.00 | €0.50 | matched |
| 10 | capture | 01a18b2e-3109-770f-a1a0-dcc554a84c28 | €49.00 | €0.67 | matched |
| 11 | capture | 01a18b2e-3171-74f5-8331-275afbdb9851 | €49.00 | €0.67 | matched |
| 12 | capture | 01a18b2e-459a-735a-84fd-4c28a4e3f564 | €9.00 | €0.19 | matched |
| 13 | capture | 01a18b2e-5c0d-71c3-b5fd-4e3df36f705e | €24.00 | €0.37 | matched |
| 14 | capture | 01a18b2e-7d6b-7631-a2e7-6b3209500436 | €24.00 | €0.37 | matched |
| 15 | capture | 01a18b2e-8e3c-7334-a589-82648489ad53 | €49.00 | €0.67 | matched |
| 16 | capture | 01a18b2e-932b-7a91-bc53-b9bd9e70f26b | €9.00 | €0.19 | matched |
| 17 | capture | 01a18b2e-94bd-74a6-a25b-d3f5519fcd3f | €35.00 | €0.50 | matched |
| 18 | capture | 01a18b2e-d97b-7c56-9c59-d422d8e7dcb9 | €35.00 | €0.50 | matched |
| 19 | capture | 01a18b2e-eacb-7f28-8324-fdb094bbda78 | €9.00 | €0.19 | matched |
| 20 | capture | 01a18b2e-ecec-79ba-9057-b8791f70ea70 | €9.00 | €0.19 | matched |
| 21 | capture | 01a18b2e-ff6e-7c95-bc59-098a5f6cd156 | €15.00 | €0.26 | matched |
| 22 | capture | 01a18b2f-0c3a-700c-83be-b9019dbd37f0 | €15.00 | €0.26 | matched |
| 23 | capture | 01a18b2f-0ea8-7b28-8e08-526cc8eda288 | €35.00 | €0.50 | matched |
| 24 | capture | 01a18b2f-1864-7074-b77f-8f55439c1d60 | €9.00 | €0.19 | matched |
| 25 | capture | 01a18b2f-1e2b-76c5-90ee-b69087f33505 | €49.00 | €0.67 | matched |
| 26 | capture | 01a18b2f-233d-7fb6-bb5e-f0ee0a6166aa | €35.00 | €0.50 | matched |
| 27 | capture | 01a18b2f-3627-715d-b165-389d8b9bdd67 | €24.00 | €0.37 | matched |
| 28 | capture | 01a18b2f-5758-729f-a917-077536bd75ad | €35.00 | €0.50 | matched |
| 29 | capture | 01a18b2f-57a8-7e56-a9ba-44e38e1115c5 | €24.00 | €0.37 | matched |
| 30 | capture | 01a18b2f-7d3f-7d44-a969-73b12e2c8dd9 | €15.00 | €0.26 | matched |
| 31 | capture | 01a18b2f-8e85-7969-84ce-20d8854cb88b | €35.00 | €0.50 | matched |
| 32 | capture | 01a18b2f-9130-7a27-abcc-ea750e44ee20 | €15.00 | €0.26 | matched |
| 33 | capture | 01a18b2f-adb5-74e5-bf27-313f2284b1a7 | €15.00 | €0.26 | matched |
| 34 | refund | 01a18b2f-ba54-7d4e-bb7c-0e468aab2ffe | -€14.00 | €0.00 | matched |
| 35 | capture | 01a18b2f-c218-7726-8bf2-4bc26aab9c21 | €49.00 | €0.67 | matched |
| 36 | capture | 01a18b2f-c47e-74c3-bee9-93e6b5d603b6 | €9.00 | €0.19 | matched |
| 37 | capture | 01a18b2f-c6e5-754a-97b7-8c18cda20663 | €24.00 | €0.37 | matched |
| 38 | capture | 01a18b2f-c738-71b6-ae45-c9ca25d1c20e | €24.00 | €0.37 | matched |
| 39 | refund | 01a18b2f-c995-7bf5-9471-32d822e633b2 | -€5.00 | €0.00 | matched |
| 40 | capture | 01a18b2f-d6b4-7196-ba27-cfc7798c884f | €15.00 | €0.26 | matched |
| 41 | capture | 01a18b2f-e8ba-74ba-a7ab-ad85087a5923 | €9.00 | €0.19 | matched |
| 42 | capture | 01a18b2f-f10e-7e36-a5cf-83c06bfe129f | €49.00 | €0.67 | matched |
| 43 | capture | 01a18b30-02d5-7858-817d-16262e8e9ff6 | €9.00 | €0.19 | matched |
| 44 | capture | 01a18b30-2d87-7fe5-abf2-e862193b6562 | €24.00 | €0.37 | matched |
| 45 | capture | 01a18b30-441a-747e-9ba9-176ef63131cb | €9.00 | €0.19 | matched |
| 46 | capture | 01a18b30-609a-715a-bdef-b3d52c3738e5 | €15.00 | €0.26 | matched |
| 47 | capture | 01a18b30-657c-7abc-8abf-df79fc3dca17 | €24.00 | €0.37 | matched |
| 48 | capture | 01a18b30-8097-7b0f-bf23-bfb0839286fd | €49.00 | €0.67 | matched |
| 49 | capture | 01a18b30-87b1-76fb-8e36-b2371eef0aee | €9.00 | €0.19 | matched |
| 50 | refund | 01a18b30-8a9c-7108-8942-51628b69a047 | -€9.00 | €0.00 | matched |
| 51 | capture | 01a18b30-9405-7515-89ee-cea1b6cd9ef3 | €24.00 | €0.37 | matched |
| 52 | capture | 01a18b30-99e1-7b50-8866-186bf6daaac4 | €9.00 | €0.19 | matched |
| 53 | capture | 01a18b30-c8d9-7926-8714-66f7da26c291 | €15.00 | €0.26 | matched |
| 54 | capture | 01a18b30-dceb-76c2-9cf2-a3a71633a563 | €49.00 | €0.67 | matched |
| 55 | capture | 01a18b30-de12-7970-9956-e037c23919e7 | €49.00 | €0.67 | matched |
| 56 | capture | 01a18b30-e17b-7c7a-8688-e8b895c4df8e | €15.00 | €0.26 | matched |
| 57 | capture | 01a18b30-e397-70d9-b090-1d45246c9eb1 | €49.00 | €0.67 | matched |
| 59 | refund | 01a18b30-e9f0-71d6-a20f-0f1b9cb30bce | -€3.00 | €0.00 | matched |
| 60 | capture | 01a18b30-ee81-77f2-9115-3996b917d950 | €24.00 | €0.37 | matched |
| 61 | capture | 01a18b30-f6ff-79fe-b0e3-4868db5dd299 | €49.00 | €0.67 | matched |
| 62 | refund | 01a18b31-2239-7d47-b8a4-50e472c53232 | -€34.00 | €0.00 | matched |
| 63 | capture | 01a18b31-2349-723b-ba3b-050b35ea5f16 | €35.00 | €0.50 | matched |
| 64 | capture | 01a18b31-2815-75a8-9dbc-8a995d0dd7a6 | €49.00 | €0.67 | matched |
| 65 | capture | 01a18b31-2dc1-70d2-8634-6fa67535bcb5 | €24.00 | €0.37 | matched |
| 66 | capture | 01a18b31-361c-70ff-8a17-7dd59be94cdd | €9.00 | €0.19 | matched |
| 67 | capture | 01a18b31-458b-77ca-becd-88c29f9f0fae | €9.00 | €0.19 | matched |
| 68 | capture | 01a18b31-4c8f-7ede-856e-ddfcda955f63 | €49.00 | €0.67 | matched |
| 69 | capture | 01a18b31-6869-7446-b4a3-41ddf20cfede | €24.00 | €0.37 | matched |
| 70 | refund | 01a18b31-8186-70f2-bc63-3f4965d26448 | -€37.00 | €0.00 | matched |
| 71 | refund | 01a18b31-99bb-7d68-a2ea-3088ca61c89d | -€3.00 | €0.00 | matched |
| 72 | capture | 01a18b31-9ed3-7588-8f63-5f6cd9452ecc | €9.00 | €0.19 | matched |
| 73 | capture | 01a18b31-a548-7b9d-975a-5b3851901dc0 | €15.00 | €0.26 | matched |
| 74 | capture | 01a18b31-b149-7f98-9772-3a386d0feae0 | €49.00 | €0.67 | matched |
| 75 | capture | 01a18b31-bd50-76c7-902a-99d0b803ecd1 | €49.00 | €0.67 | matched |
| 76 | capture | 01a18b31-d15e-75e1-84eb-db92b1548080 | €35.00 | €0.50 | matched |
| 77 | capture | 01a18b31-e0bd-7bf3-9bfe-d2801631450c | €35.00 | €0.50 | matched |
| 78 | capture | 01a18b32-040f-7a50-8c59-6a4dc6650eda | €49.00 | €0.67 | matched |
| 79 | capture | 01a18b32-2e57-73b1-a6a6-b18ab2c01906 | €49.00 | €0.67 | matched |
| 80 | capture | 01a18b32-3d38-7e84-8166-97f9fb1aac94 | €15.00 | €0.26 | matched |
| 81 | capture | 01a18b32-5237-78b5-af0b-935fe3222b41 | €24.00 | €0.37 | matched |
| 82 | capture | 01a18b32-64f6-76d5-a1c3-23e84be0617d | €49.00 | €0.67 | matched |
| 83 | capture | 01a18b32-7ede-7681-ba3f-9d599dfd9e33 | €9.00 | €0.19 | matched |
| 84 | capture | 01a18b32-7fad-7bef-9b3b-4be2acca8cfc | €49.00 | €0.67 | matched |
| 85 | capture | 01a18b32-8043-7cd0-b336-a7597dbbfab2 | €35.00 | €0.50 | matched |
| 86 | capture | 01a18b32-98ef-7bc7-bbfa-95bc36ab1d19 | €15.00 | €0.26 | matched |
| 87 | capture | 01a18b32-9989-74d9-83eb-a871c2975081 | €15.00 | €0.26 | matched |
| 88 | capture | 01a18b32-9d65-74c3-9686-ed7418ec7f41 | €35.00 | €0.50 | matched |
| 89 | capture | 01a18b32-ad52-7a50-ac5c-71557ad78a40 | €24.00 | €0.37 | matched |
| 90 | capture | 01a18b32-ae64-78fd-99f9-1a35945d0256 | €24.00 | €0.37 | matched |
| 91 | capture | 01a18b32-b579-70d8-82a5-11c0708e1988 | €24.00 | €0.37 | matched |
| 92 | refund | 01a18b32-b73b-75a1-b653-4b96cbbe8dbe | -€6.00 | €0.00 | matched |
| 93 | capture | 01a18b32-bd11-7875-833a-6b0a3ed4333a | €35.00 | €0.50 | matched |
| 94 | capture | 01a18b32-be11-7e21-99b6-e857c60f1391 | €9.00 | €0.19 | matched |
| 95 | capture | 01a18b32-c437-73d6-adef-9f034993faa8 | €9.00 | €0.19 | matched |
| 96 | capture | 01a18b32-d9fb-7bf3-bdc9-00b17cfd4b78 | €24.00 | €0.37 | matched |
| 97 | capture | 01a18b32-ef1e-7518-b6bb-448b98071b6b | €24.00 | €0.37 | matched |
| 98 | capture | 01a18b32-fed7-7d63-b82d-54466b530278 | €24.00 | €0.37 | matched |
| 99 | capture | 01a18b33-0dc1-7562-8806-1073e234d7d3 | €49.00 | €0.67 | matched |
| 100 | capture | 01a18b33-16b6-7d54-9925-e88e695661f9 | €9.00 | €0.19 | matched |
| 101 | capture | 01a18b33-1a85-74c8-9497-de8163806de0 | €49.00 | €0.67 | matched |
| 102 | capture | 01a18b33-57c7-73d2-bb11-c892df075bc7 | €15.00 | €0.26 | matched |
| 103 | capture | 01a18b33-621f-75d0-8f91-9b698436be7f | €9.00 | €0.19 | matched |
| 104 | capture | 01a18b33-7901-712e-8168-3e46a7a019b2 | €49.00 | €0.67 | matched |
| 105 | capture | 01a18b33-79bd-797f-972f-e8e1fc55b8d1 | €35.00 | €0.50 | matched |
| 106 | capture | 01a18b33-7ef7-7d68-bdcb-42210ac87bfe | €24.00 | €0.37 | matched |
| 107 | capture | 01a18b33-99f4-7013-9abf-18ddab31853d | €15.00 | €0.26 | matched |
| 108 | capture | 01a18b33-c2a3-7b3d-a62c-9abd41032e2d | €24.00 | €0.37 | matched |
| 109 | capture | 01a18b33-cdc9-7aaf-b73c-7dd82cf56139 | €49.00 | €0.67 | matched |
| 110 | capture | 01a18b33-f64d-7948-baaa-57053d911a67 | €9.00 | €0.19 | matched |
| 111 | capture | 01a18b33-f6b4-792a-8fa4-7b583efaacdd | €49.00 | €0.67 | matched |
| 112 | capture | 01a18b34-09f4-79ba-b98e-0ad2dbae20b3 | €49.00 | €0.67 | matched |
| 113 | capture | 01a18b34-1009-7cd0-9bbc-b9a1008a8bb2 | €9.00 | €0.19 | matched |
| 114 | capture | 01a18b34-4e3d-7f9c-a334-2b5b3a35aba9 | €9.00 | €0.19 | matched |
| 115 | capture | 01a18b34-5cfd-76ea-9a34-e7aa8b434cf8 | €24.00 | €0.37 | matched |
| 116 | capture | 01a18b34-9e00-7368-8fcf-ef00e5413423 | €15.00 | €0.26 | matched |
| 117 | capture | 01a18b34-b68d-7746-89e7-b1b242c60a26 | €9.00 | €0.19 | matched |
| 118 | capture | 01a18b34-c178-7f58-a4c8-36122027b097 | €15.00 | €0.26 | matched |
| 119 | capture | 01a18b34-de3a-77bd-8ded-9adcc6db7c72 | €49.00 | €0.67 | matched |
| 120 | refund | 01a18b34-ee71-788c-b66b-74b80456dcb5 | -€5.00 | €0.00 | matched |
| 121 | capture | 01a18b34-ef08-7cce-bbad-7a1a72cb3810 | €15.00 | €0.26 | matched |
| 122 | capture | 01a18b35-0276-7919-a073-c6ab620800e3 | €35.00 | €0.50 | matched |
| 123 | capture | 01a18b35-07a6-7cfd-b01c-d2b09f8fca97 | €9.00 | €0.19 | matched |
| 124 | capture | 01a18b35-30d3-76e2-b3bb-96604b713cc8 | €35.00 | €0.50 | matched |
| 125 | capture | 01a18b35-3cd4-78d9-a98c-077c2fa68164 | €15.00 | €0.26 | matched |
| 126 | capture | 01a18b35-5b3e-7f4a-9f29-ecffa909dc39 | €24.00 | €0.37 | matched |
| 127 | capture | 01a18b35-5b61-7fc5-b053-1ef0ad32b065 | €35.00 | €0.50 | matched |
| 128 | capture | 01a18b35-6df7-742f-902f-b5d5b697104a | €49.00 | €0.67 | matched |
| 129 | capture | 01a18b35-7088-76e9-9543-ced0bac11d11 | €49.00 | €0.67 | matched |
| 130 | capture | 01a18b35-7973-74ce-90a9-21cf568fa47d | €35.00 | €0.50 | matched |
| 131 | refund | 01a18b35-a1e7-75a9-9db3-28da133386f8 | -€24.00 | €0.00 | matched |
| 133 | refund | 01a18b35-ad6f-71eb-8455-f2609d2a2538 | -€11.00 | €0.00 | matched |
| 134 | capture | 01a18b35-bc3d-7216-b036-3ca5167676c1 | €35.00 | €0.50 | matched |
| 135 | capture | 01a18b35-bde5-7172-87f5-c222f6c6ed85 | €35.00 | €0.50 | matched |
| 136 | capture | 01a18b36-07bf-7a29-8624-9fab102b7d0d | €24.00 | €0.37 | matched |
| 137 | capture | 01a18b36-11e3-7a19-80d4-828924ff2602 | €24.00 | €0.37 | matched |
| 138 | capture | 01a18b36-245e-75c7-bc28-57737ce3725c | €15.00 | €0.26 | matched |
| 139 | capture | 01a18b36-27fd-75aa-8799-06f5af997fd1 | €15.00 | €0.26 | matched |
| 140 | capture | 01a18b36-37be-7d1e-ab57-e352893669b3 | €9.00 | €0.19 | matched |
| 141 | capture | 01a18b36-4f00-78e5-8c31-e97ab1eac84e | €9.00 | €0.19 | matched |
| 142 | capture | 01a18b36-9736-7772-a853-63f5732119b6 | €35.00 | €0.50 | matched |
| 143 | capture | 01a18b36-a317-76b9-aa60-ae860d81c302 | €24.00 | €0.37 | matched |
| 144 | capture | 01a18b36-9c2a-7d5d-be5c-11d5a56de72e | €35.00 | €0.50 | matched |
| 145 | capture | 01a18b36-c176-7aa2-a878-8369fa551bc7 | €24.00 | €0.37 | matched |
| 146 | capture | 01a18b36-c24b-70ab-a98f-bc7bc1d0d26b | €24.00 | €0.37 | matched |
| 147 | capture | 01a18b36-c6a3-73cb-825a-5d39139893f2 | €35.00 | €0.50 | matched |
| 148 | capture | 01a18b36-ebd9-708a-81e4-1ff4bbb4f92c | €35.00 | €0.50 | matched |
| 149 | refund | 01a18b36-ef1d-73f4-9e5c-39fbbc449812 | -€27.00 | €0.00 | matched |
| 150 | capture | 01a18b36-ef2a-7d93-b43f-2038aeca5dba | €24.00 | €0.37 | matched |
| 151 | capture | 01a18b36-f400-7fe3-9934-a1570236b5e8 | €15.00 | €0.26 | matched |