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
- 15 Oct, 13:30132 lines2 breaks
- 15 Oct, 13:20133 lines4 breaks
- 15 Oct, 13:10130 lines5 breaks
- 15 Oct, 13:00141 lines2 breaks
- 15 Oct, 12:50108 lines1 break
- 15 Oct, 12:40116 lines2 breaks
- 15 Oct, 12:30121 lines3 breaks
- 15 Oct, 12:20123 lines2 breaks
- 15 Oct, 12:10126 lines3 breaks
- 15 Oct, 12:00143 lines3 breaks
- 15 Oct, 11:50137 lines3 breaks
- 15 Oct, 11:40129 linesclean
- 15 Oct, 11:30132 lines4 breaks
- 15 Oct, 11:20136 lines4 breaks
15 Oct, 11:50
Gross
€3,055.00
PSP fee
€49.22
Net to the bank
€3,005.78
Settlement journal
#14193
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13f6d-da0e-7f49-b7a3-6553a379b334 is already settled by stl_EUR_2986775 line 121
- fee differencethe fee is not the contract feethe fee is 39, the contract says 37
- missing linein the books, not in the filecapture:01a13f6b-b706-713b-90dc-a8eefcf2df1a is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 41 | capture | 01a13f68-5882-7e81-b0cc-4626fa14c3f8 | €24.00 | €0.39 | fee difference |
| 122 | capture | 01a13f6d-eca1-78be-bcfd-0701f266ebc8 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a13f5d-32ab-7b20-ba84-60b0ff2f75c0 | €24.00 | €0.37 | matched |
| 2 | capture | 01a13f60-e9de-731c-818e-34f5959d1dec | €35.00 | €0.50 | matched |
| 3 | capture | 01a13f65-bb3e-7ccf-9ad5-1b43e9e99ba3 | €15.00 | €0.26 | matched |
| 4 | capture | 01a13f65-db5a-73d6-8c2f-cc6136f18c92 | €24.00 | €0.37 | matched |
| 5 | capture | 01a13f66-1cc6-7d11-88c4-4abea7651046 | €35.00 | €0.50 | matched |
| 6 | capture | 01a13f66-1e81-7cd8-b6fa-0d11cfdb73c5 | €9.00 | €0.19 | matched |
| 7 | capture | 01a13f66-27e8-7cf5-b688-89a2acf614f6 | €9.00 | €0.19 | matched |
| 8 | capture | 01a13f66-291c-7727-969a-9a71779194e6 | €15.00 | €0.26 | matched |
| 9 | capture | 01a13f66-4755-74ee-9521-03816e83a611 | €49.00 | €0.67 | matched |
| 10 | capture | 01a13f66-8213-7e01-933b-1b46b0cbc325 | €35.00 | €0.50 | matched |
| 11 | capture | 01a13f66-9b21-7f8a-b1e0-e6328acd4c40 | €15.00 | €0.26 | matched |
| 12 | capture | 01a13f66-b231-7826-bc39-586727ab6071 | €9.00 | €0.19 | matched |
| 13 | capture | 01a13f66-c12b-7f23-86d8-dc68779df090 | €35.00 | €0.50 | matched |
| 14 | capture | 01a13f66-d9b2-7c33-841d-22c08f0e475a | €35.00 | €0.50 | matched |
| 15 | capture | 01a13f66-dab0-7f8b-ade1-c01013855529 | €35.00 | €0.50 | matched |
| 16 | capture | 01a13f66-e02f-7154-9590-f147fed22071 | €49.00 | €0.67 | matched |
| 17 | capture | 01a13f66-dcb9-7865-9b93-fa65b5819599 | €15.00 | €0.26 | matched |
| 18 | capture | 01a13f67-00fe-723e-80de-c4dfcddcf935 | €24.00 | €0.37 | matched |
| 19 | refund | 01a13f67-0847-74c5-b3e0-cb300718b280 | -€27.00 | €0.00 | matched |
| 20 | capture | 01a13f67-0c68-721e-8935-bac7fc672e43 | €24.00 | €0.37 | matched |
| 21 | capture | 01a13f67-35e7-7e46-8060-c2f6be516461 | €15.00 | €0.26 | matched |
| 22 | capture | 01a13f67-3ce6-7c8f-b804-728479eb7ef9 | €9.00 | €0.19 | matched |
| 23 | capture | 01a13f67-49af-7532-ac1d-2c3e73c7700c | €15.00 | €0.26 | matched |
| 24 | capture | 01a13f67-59cb-7fd8-adb7-499a49e55f2e | €49.00 | €0.67 | matched |
| 25 | capture | 01a13f67-6fb8-70a8-88ef-0382afeb3ada | €49.00 | €0.67 | matched |
| 26 | capture | 01a13f67-767b-7814-ac69-a89b0bb0fb75 | €15.00 | €0.26 | matched |
| 27 | capture | 01a13f67-8070-7eb9-a0af-3c2ac4699ed8 | €49.00 | €0.67 | matched |
| 28 | capture | 01a13f67-95d4-77fb-b37c-8179c8a987aa | €49.00 | €0.67 | matched |
| 29 | refund | 01a13f67-ac49-7466-8c7f-ce4fc74cc5cf | -€14.00 | €0.00 | matched |
| 30 | capture | 01a13f67-ade2-7870-8182-c4cfec989384 | €49.00 | €0.67 | matched |
| 31 | capture | 01a13f67-c666-76c4-bb32-66f3ce8a9f98 | €15.00 | €0.26 | matched |
| 32 | capture | 01a13f67-c6c3-70f7-bd0a-dcd79b665532 | €49.00 | €0.67 | matched |
| 33 | capture | 01a13f67-cd34-7a5c-939f-1dddeae08170 | €35.00 | €0.50 | matched |
| 34 | capture | 01a13f67-e0b9-721a-9459-4f89b69ee593 | €15.00 | €0.26 | matched |
| 35 | capture | 01a13f67-e340-7eda-8c7b-2f4a9987da1a | €9.00 | €0.19 | matched |
| 36 | refund | 01a13f68-00f9-70aa-af74-4688d4fabf27 | -€27.00 | €0.00 | matched |
| 37 | capture | 01a13f68-0680-740e-a354-a420b6bb636d | €15.00 | €0.26 | matched |
| 38 | capture | 01a13f68-0e12-77df-861d-cfe1e00643c5 | €15.00 | €0.26 | matched |
| 39 | capture | 01a13f68-2ed8-7b4d-9d90-1c3e27a80be8 | €15.00 | €0.26 | matched |
| 40 | capture | 01a13f68-4772-7577-b2fc-cece90eb743f | €15.00 | €0.26 | matched |
| 42 | capture | 01a13f68-620b-744e-bb2a-c749e7982e84 | €15.00 | €0.26 | matched |
| 43 | capture | 01a13f68-7159-76aa-95d1-b4412e6ffe6b | €9.00 | €0.19 | matched |
| 44 | capture | 01a13f68-72a2-791d-be00-0b9213408cb7 | €24.00 | €0.37 | matched |
| 45 | capture | 01a13f68-7344-7218-a346-2605246282c9 | €35.00 | €0.50 | matched |
| 46 | capture | 01a13f68-87c1-7e52-84ad-066b5ceff208 | €35.00 | €0.50 | matched |
| 47 | capture | 01a13f68-8829-770f-97a5-52bd810badfc | €9.00 | €0.19 | matched |
| 48 | capture | 01a13f68-a0b9-7ba5-98fe-15a9acd4f7fa | €24.00 | €0.37 | matched |
| 49 | capture | 01a13f68-a1c0-7994-aab3-0e3366b4d6d0 | €9.00 | €0.19 | matched |
| 50 | capture | 01a13f68-af19-7003-95d1-8b81221c0cca | €9.00 | €0.19 | matched |
| 51 | capture | 01a13f68-b54c-78eb-9bf9-cd731f13dc01 | €49.00 | €0.67 | matched |
| 52 | capture | 01a13f68-d883-7198-913c-58c228d8d7f7 | €49.00 | €0.67 | matched |
| 53 | capture | 01a13f68-db5b-7657-914d-3b052e1a9531 | €15.00 | €0.26 | matched |
| 54 | capture | 01a13f68-d215-75a0-a221-a7c4f67cf00d | €24.00 | €0.37 | matched |
| 55 | capture | 01a13f68-f2ab-7ef5-9e88-76914814024f | €35.00 | €0.50 | matched |
| 56 | capture | 01a13f69-26d8-7c05-9f31-f083021c4ab4 | €9.00 | €0.19 | matched |
| 57 | capture | 01a13f69-2723-7f8b-ae77-6edb066346f3 | €24.00 | €0.37 | matched |
| 58 | capture | 01a13f69-5691-7e43-8c61-1ea389decd05 | €49.00 | €0.67 | matched |
| 59 | capture | 01a13f69-5c80-738c-981e-ef9176e92b07 | €49.00 | €0.67 | matched |
| 60 | capture | 01a13f69-750f-7143-a655-8a68416d159b | €9.00 | €0.19 | matched |
| 61 | capture | 01a13f69-8841-716f-8f39-51e6accfdb91 | €9.00 | €0.19 | matched |
| 62 | capture | 01a13f69-aa31-7d27-bde4-c44a40a724e7 | €49.00 | €0.67 | matched |
| 63 | refund | 01a13f69-b3c9-7434-8bff-a7cbe0616a6c | -€20.00 | €0.00 | matched |
| 64 | capture | 01a13f69-d226-75c5-8472-ff583e2c6a3b | €9.00 | €0.19 | matched |
| 65 | capture | 01a13f69-e97c-78d4-bc60-92b4fc49593e | €35.00 | €0.50 | matched |
| 66 | capture | 01a13f69-f311-738e-823f-fd582073b999 | €15.00 | €0.26 | matched |
| 67 | capture | 01a13f6a-1db1-7882-97e5-266eb71621c2 | €24.00 | €0.37 | matched |
| 68 | capture | 01a13f6a-3a2b-7931-b6b3-4e8d4c6a5cc7 | €35.00 | €0.50 | matched |
| 69 | capture | 01a13f6a-7ed1-7e77-a03d-e6df14b5d9a1 | €49.00 | €0.67 | matched |
| 70 | capture | 01a13f6a-9cfe-7bcb-8088-e77e4aa91529 | €15.00 | €0.26 | matched |
| 71 | capture | 01a13f6a-cbc2-76c8-ad04-ff7b46a81843 | €49.00 | €0.67 | matched |
| 72 | capture | 01a13f6a-e5f1-7b6d-aa1d-c7c69c01c868 | €15.00 | €0.26 | matched |
| 73 | capture | 01a13f6a-eca0-717e-a766-01b4187b22ac | €9.00 | €0.19 | matched |
| 74 | capture | 01a13f6a-f01e-7f7f-8172-884bde2931ce | €49.00 | €0.67 | matched |
| 75 | capture | 01a13f6a-f163-7345-9ef6-afa2be63894c | €9.00 | €0.19 | matched |
| 76 | capture | 01a13f6b-04f0-71e1-886e-3feffdb0de1c | €9.00 | €0.19 | matched |
| 77 | capture | 01a13f6b-0dd5-77a9-86cc-c850f8fdab4c | €24.00 | €0.37 | matched |
| 78 | capture | 01a13f6b-1885-75fb-93e2-0d9003f71704 | €35.00 | €0.50 | matched |
| 79 | capture | 01a13f6b-1c7f-7b97-9867-a364dd37044e | €9.00 | €0.19 | matched |
| 80 | capture | 01a13f6b-2252-7b29-b3e6-b4c277f96f4b | €24.00 | €0.37 | matched |
| 81 | capture | 01a13f6b-27a7-7626-be20-671f87f6e3c4 | €35.00 | €0.50 | matched |
| 82 | capture | 01a13f6b-2dfc-78a8-b027-fdfc97ca7fb4 | €15.00 | €0.26 | matched |
| 83 | capture | 01a13f6b-2feb-73c6-b101-89c4a64a69fb | €24.00 | €0.37 | matched |
| 84 | refund | 01a13f6b-4778-7460-96e2-856b9f90d684 | -€19.00 | €0.00 | matched |
| 85 | capture | 01a13f6b-4d55-7045-ae49-70a2679b054d | €9.00 | €0.19 | matched |
| 86 | capture | 01a13f6b-4e2c-7281-a497-124d39a68459 | €49.00 | €0.67 | matched |
| 87 | capture | 01a13f6b-550b-76fa-8ce0-c9b45803287c | €49.00 | €0.67 | matched |
| 88 | refund | 01a13f6b-5719-74b9-bdb9-6fa7f1ce8f77 | -€11.00 | €0.00 | matched |
| 89 | capture | 01a13f6b-5b9f-7525-832b-1bb3930ef0f7 | €9.00 | €0.19 | matched |
| 90 | capture | 01a13f6b-9b3a-742a-9ca1-c9938ff7291f | €35.00 | €0.50 | matched |
| 91 | capture | 01a13f6b-b9a9-7130-98c3-65e91da4a66b | €24.00 | €0.37 | matched |
| 92 | capture | 01a13f6b-db1f-7e87-93c2-2ebffe70b66f | €24.00 | €0.37 | matched |
| 93 | capture | 01a13f6b-e90b-7117-9014-b58684981240 | €9.00 | €0.19 | matched |
| 94 | capture | 01a13f6c-31e5-7891-8431-3c49ff28fc72 | €9.00 | €0.19 | matched |
| 95 | capture | 01a13f6c-3237-7da0-8296-7fe9701fe5ef | €9.00 | €0.19 | matched |
| 96 | capture | 01a13f6c-7284-7cba-bda3-1ed954e01a6f | €35.00 | €0.50 | matched |
| 97 | capture | 01a13f6c-87f7-746f-9848-c4b0765de732 | €24.00 | €0.37 | matched |
| 98 | capture | 01a13f6c-9b2e-7481-85c4-307a852993f4 | €35.00 | €0.50 | matched |
| 99 | capture | 01a13f6c-9b8e-7012-a73a-36916ae5602d | €24.00 | €0.37 | matched |
| 100 | capture | 01a13f6c-c4db-7fec-893f-437c813aaa58 | €24.00 | €0.37 | matched |
| 101 | capture | 01a13f6c-e6c4-76b7-877c-6c0d2f01bc39 | €49.00 | €0.67 | matched |
| 102 | capture | 01a13f6c-f234-7dbe-ad23-96820125b8de | €24.00 | €0.37 | matched |
| 103 | capture | 01a13f6d-0570-7df9-9195-53621382dd14 | €15.00 | €0.26 | matched |
| 104 | refund | 01a13f6d-11b8-71ee-b970-0716d6e9d255 | -€37.00 | €0.00 | matched |
| 105 | capture | 01a13f6d-2caf-79be-a36b-ed190ff6c547 | €9.00 | €0.19 | matched |
| 106 | capture | 01a13f6d-3d51-7906-a7d0-adc2543a74be | €24.00 | €0.37 | matched |
| 107 | capture | 01a13f6d-4272-780e-8970-63be277971fd | €15.00 | €0.26 | matched |
| 108 | capture | 01a13f6d-4c79-7f55-b59a-99de573b7acf | €49.00 | €0.67 | matched |
| 109 | capture | 01a13f6d-5cb0-7bb9-b352-8f490abe7ff7 | €15.00 | €0.26 | matched |
| 110 | capture | 01a13f6d-64e3-7dae-810f-9b2ff1470893 | €49.00 | €0.67 | matched |
| 111 | refund | 01a13f6d-6d33-705d-8a5c-0dd12224a658 | -€8.00 | €0.00 | matched |
| 112 | capture | 01a13f6d-56f6-7d64-baa3-a84f2a29baea | €9.00 | €0.19 | matched |
| 113 | refund | 01a13f6d-871c-75ed-9a1b-1f6d25027ec1 | -€6.00 | €0.00 | matched |
| 114 | refund | 01a13f6d-8e46-7c10-86ac-0d007cefb2c2 | -€15.00 | €0.00 | matched |
| 115 | capture | 01a13f6d-9e04-788b-9dd3-34c0b4ef65cc | €35.00 | €0.50 | matched |
| 116 | capture | 01a13f6d-b76e-7deb-ab61-7c7adffd50e2 | €24.00 | €0.37 | matched |
| 117 | capture | 01a13f6d-b8ff-7016-be29-6febedb8b1b5 | €9.00 | €0.19 | matched |
| 118 | capture | 01a13f6d-cd92-71a5-841a-b5e5c1421e95 | €9.00 | €0.19 | matched |
| 119 | capture | 01a13f6d-db12-7410-b74c-040fbca38be0 | €35.00 | €0.50 | matched |
| 120 | capture | 01a13f6d-f168-7141-87f6-39b536da863d | €15.00 | €0.26 | matched |
| 121 | capture | 01a13f6d-eca1-78be-bcfd-0701f266ebc8 | €49.00 | €0.67 | matched |
| 123 | capture | 01a13f6d-f480-75ef-92fe-0ff4cac874b4 | €35.00 | €0.50 | matched |
| 124 | capture | 01a13f6e-014b-7c08-bf16-efd0ef3d8448 | €35.00 | €0.50 | matched |
| 125 | capture | 01a13f6e-01c2-7319-b007-b98c1a9efcfa | €9.00 | €0.19 | matched |
| 126 | capture | 01a13f6e-144f-79b0-9cbc-680f9402269e | €49.00 | €0.67 | matched |
| 127 | refund | 01a13f6e-1d26-7557-95bc-fbef40a94841 | -€8.00 | €0.00 | matched |
| 128 | capture | 01a13f6e-533f-74b4-bb9e-a485a4eee8a6 | €35.00 | €0.50 | matched |
| 129 | capture | 01a13f6e-67fd-76de-b3a6-24b67daf1ac0 | €49.00 | €0.67 | matched |
| 130 | capture | 01a13f6e-6704-7646-9820-755cdf56b685 | €9.00 | €0.19 | matched |
| 131 | capture | 01a13f6e-745b-7347-a31a-66e9ba59ba26 | €9.00 | €0.19 | matched |
| 132 | capture | 01a13f6e-77c6-76e3-a550-a5b4fb91cf15 | €24.00 | €0.37 | matched |
| 133 | capture | 01a13f6e-8bc1-76be-afc5-3e7192b76a2b | €35.00 | €0.50 | matched |
| 134 | capture | 01a13f6e-d7a6-7c3a-82d8-6495cef8fad1 | €15.00 | €0.26 | matched |
| 135 | capture | 01a13f6e-db50-77fa-a57b-8b03b24d78b5 | €24.00 | €0.37 | matched |
| 136 | capture | 01a13f6e-e68c-7624-97a6-0ca8d3bb48ed | €35.00 | €0.50 | matched |
| 137 | capture | 01a13f6e-f1cd-72dc-bd8f-1b9846f99e63 | €9.00 | €0.19 | matched |