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
- 5 Nov, 23:10122 lines2 breaks
- 5 Nov, 23:00100 lines2 breaks
- 5 Nov, 22:50122 lines6 breaks
- 5 Nov, 22:40121 lines5 breaks
- 5 Nov, 22:30130 lines3 breaks
- 5 Nov, 22:20120 lines2 breaks
- 5 Nov, 22:10134 lines3 breaks
- 5 Nov, 22:00120 lines3 breaks
- 5 Nov, 21:50126 lines1 break
- 5 Nov, 21:40116 lines1 break
- 5 Nov, 21:30104 lines1 break
- 5 Nov, 21:20110 lines1 break
- 5 Nov, 21:10127 lines4 breaks
- 5 Nov, 21:00112 lines3 breaks
5 Nov, 19:30
Gross
€2,731.00
PSP fee
€46.07
Net to the bank
€2,684.93
Settlement journal
#403023
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1ad32-4c38-7ffc-8a65-adf4a880d2b4 is already settled by stl_EUR_2989845 line 32
- fee differencethe fee is not the contract feethe fee is 72, the contract says 67
- missing linein the books, not in the filecapture:01a1ad36-2953-7437-9040-0a90f8e9b929 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 33 | capture | 01a1ad32-6221-70c8-91b0-e32b94cb21b6 | €15.00 | €0.26 | duplicate line |
| 42 | capture | 01a1ad33-0329-79d9-814d-bdb027b7b7e7 | €49.00 | €0.72 | fee difference |
| 1 | capture | 01a1ad2c-b52d-7049-bab9-67a3a50dc3c2 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1ad30-8337-748e-885b-0424ad71715c | €49.00 | €0.67 | matched |
| 3 | capture | 01a1ad30-9db6-7a7a-9b04-ee545eba5351 | €35.00 | €0.50 | matched |
| 4 | refund | 01a1ad30-a33c-7d5f-9ff5-6ea9ade7e1cf | -€41.00 | €0.00 | matched |
| 5 | capture | 01a1ad30-a4f0-789c-bad2-585a0fcb68fe | €35.00 | €0.50 | matched |
| 6 | capture | 01a1ad30-ab3f-7ec4-9f8d-fc20269b3839 | €24.00 | €0.37 | matched |
| 7 | capture | 01a1ad30-b76b-7dc5-9f18-c4ab88dac6a6 | €9.00 | €0.19 | matched |
| 8 | capture | 01a1ad30-c67e-7e4d-b1ab-d7663df1340b | €9.00 | €0.19 | matched |
| 9 | capture | 01a1ad30-d11d-7c1d-b2bc-67a3a316e21e | €15.00 | €0.26 | matched |
| 10 | capture | 01a1ad30-ed40-71de-8ed1-640603613bd3 | €24.00 | €0.37 | matched |
| 11 | capture | 01a1ad30-f286-7a7e-97d9-7beee79db722 | €15.00 | €0.26 | matched |
| 12 | capture | 01a1ad30-fc0d-7c20-859f-0989bdf6296e | €24.00 | €0.37 | matched |
| 13 | capture | 01a1ad31-0aa5-70e1-8923-c47fe2729e62 | €9.00 | €0.19 | matched |
| 14 | capture | 01a1ad31-1ebe-7ffa-8117-bf1f89a7a3b1 | €9.00 | €0.19 | matched |
| 15 | capture | 01a1ad31-344f-7db5-b9e5-727d440ed6a6 | €24.00 | €0.37 | matched |
| 16 | capture | 01a1ad31-38dc-7c37-bccd-ddb2be27f606 | €9.00 | €0.19 | matched |
| 17 | capture | 01a1ad31-8289-7cde-a665-da29138e3a80 | €15.00 | €0.26 | matched |
| 18 | capture | 01a1ad31-82ea-7a4a-862a-edd433a452ce | €24.00 | €0.37 | matched |
| 19 | capture | 01a1ad31-a360-74af-922c-26c538025639 | €35.00 | €0.50 | matched |
| 20 | capture | 01a1ad31-a6c5-7a29-a536-5ec5f841abf7 | €9.00 | €0.19 | matched |
| 21 | capture | 01a1ad31-b2df-7d12-a0d3-b2f50df97576 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1ad31-b6bc-746f-a421-728dd46e3999 | €49.00 | €0.67 | matched |
| 23 | capture | 01a1ad31-c131-7d16-a647-7cd922214f15 | €24.00 | €0.37 | matched |
| 24 | capture | 01a1ad31-e7f2-7c94-8fb1-791e00f605fb | €15.00 | €0.26 | matched |
| 25 | capture | 01a1ad31-fa22-71ac-bf28-75bd7d4e7c00 | €15.00 | €0.26 | matched |
| 26 | capture | 01a1ad32-09f0-7594-928f-5a9049f448f7 | €49.00 | €0.67 | matched |
| 27 | capture | 01a1ad32-22d6-74c1-92e5-84801a913a6f | €15.00 | €0.26 | matched |
| 28 | capture | 01a1ad32-2b75-73e1-b110-e59df9540c9d | €24.00 | €0.37 | matched |
| 29 | capture | 01a1ad32-34ce-714c-9e31-67cdba35968a | €9.00 | €0.19 | matched |
| 30 | capture | 01a1ad32-442d-7e77-8f6e-c1d46e28cf95 | €15.00 | €0.26 | matched |
| 31 | capture | 01a1ad32-499d-79a2-aa0b-18fa284c94a5 | €24.00 | €0.37 | matched |
| 32 | capture | 01a1ad32-6221-70c8-91b0-e32b94cb21b6 | €15.00 | €0.26 | matched |
| 34 | refund | 01a1ad32-6358-74a6-8f5c-8dd73b928e17 | -€10.00 | €0.00 | matched |
| 35 | refund | 01a1ad32-6e93-7d9a-a206-c1273b7f11b3 | -€41.00 | €0.00 | matched |
| 36 | capture | 01a1ad32-8fa5-7738-8e32-8405f7abe6ac | €15.00 | €0.26 | matched |
| 37 | capture | 01a1ad32-927d-7064-8dc9-813c955cc12d | €15.00 | €0.26 | matched |
| 38 | capture | 01a1ad32-9478-7a77-b635-5d7a65d4ebc6 | €35.00 | €0.50 | matched |
| 39 | capture | 01a1ad32-c690-70a4-a430-a411a11d13f1 | €49.00 | €0.67 | matched |
| 40 | capture | 01a1ad32-ce01-7d2d-9963-6351a93aaba7 | €24.00 | €0.37 | matched |
| 41 | capture | 01a1ad32-e7d2-7fea-a59d-c555bb056e51 | €9.00 | €0.19 | matched |
| 43 | capture | 01a1ad33-1458-788e-9f07-715cd10105d1 | €9.00 | €0.19 | matched |
| 44 | capture | 01a1ad33-1a17-70a2-8744-043bad42edaa | €49.00 | €0.67 | matched |
| 45 | capture | 01a1ad33-1c72-74a4-8db6-d2afb45587e2 | €24.00 | €0.37 | matched |
| 46 | capture | 01a1ad33-1f4a-7f28-9802-15eb15e234b2 | €24.00 | €0.37 | matched |
| 47 | capture | 01a1ad33-29b4-7f42-9b72-619c77aac42a | €24.00 | €0.37 | matched |
| 48 | capture | 01a1ad33-31f4-7f80-b3aa-739f02ee64e7 | €49.00 | €0.67 | matched |
| 49 | capture | 01a1ad33-33d0-75d0-ab48-09896fbe06ba | €15.00 | €0.26 | matched |
| 50 | capture | 01a1ad33-3fbf-728c-99eb-fc62da32343c | €9.00 | €0.19 | matched |
| 51 | capture | 01a1ad33-47eb-7040-b394-3231b951ff56 | €24.00 | €0.37 | matched |
| 52 | refund | 01a1ad33-4944-779e-8d8a-7124dda4168e | -€39.00 | €0.00 | matched |
| 53 | capture | 01a1ad33-7207-7861-96af-9f1e4211a4b5 | €35.00 | €0.50 | matched |
| 54 | capture | 01a1ad33-8c42-7800-a3d1-97578f153337 | €9.00 | €0.19 | matched |
| 55 | capture | 01a1ad33-79bb-7fa1-a6be-311ec8e450a9 | €24.00 | €0.37 | matched |
| 56 | capture | 01a1ad33-a5d1-792d-b86d-320634a80035 | €9.00 | €0.19 | matched |
| 57 | capture | 01a1ad33-af88-74fe-861b-7a3810ef69f4 | €24.00 | €0.37 | matched |
| 58 | capture | 01a1ad33-d090-7ee8-8e79-d93436c853dd | €15.00 | €0.26 | matched |
| 59 | capture | 01a1ad33-e22b-74ef-8365-9cccd7f83bfe | €15.00 | €0.26 | matched |
| 60 | capture | 01a1ad33-f92f-7fa1-9432-25571e1d0912 | €9.00 | €0.19 | matched |
| 61 | capture | 01a1ad34-1799-742c-898e-34f1ad6eb8df | €49.00 | €0.67 | matched |
| 62 | capture | 01a1ad34-3320-79d2-94ba-e3fae2b8357f | €9.00 | €0.19 | matched |
| 63 | capture | 01a1ad34-4397-767a-a6ec-a775c652a419 | €35.00 | €0.50 | matched |
| 64 | refund | 01a1ad34-b033-7d03-9380-fc2e1a37dcfd | -€19.00 | €0.00 | matched |
| 65 | capture | 01a1ad34-b54d-7c43-a91a-16909eeceec7 | €9.00 | €0.19 | matched |
| 66 | capture | 01a1ad34-caa9-7799-a37d-8956cc31d1f8 | €9.00 | €0.19 | matched |
| 67 | capture | 01a1ad34-d9bc-7eb1-9543-a1784d7b81a0 | €9.00 | €0.19 | matched |
| 68 | capture | 01a1ad34-e0bc-7a43-9370-466b3af17e44 | €24.00 | €0.37 | matched |
| 69 | capture | 01a1ad34-e762-788a-aecd-94c08bbfdb1c | €24.00 | €0.37 | matched |
| 70 | capture | 01a1ad35-0c86-7945-8b82-44d3de0b3e9c | €15.00 | €0.26 | matched |
| 71 | capture | 01a1ad35-1570-78dc-8825-153429e3cee1 | €9.00 | €0.19 | matched |
| 72 | capture | 01a1ad35-1f27-7e82-8f37-b913345b4950 | €15.00 | €0.26 | matched |
| 73 | capture | 01a1ad35-5723-779a-894d-02244a4f2170 | €35.00 | €0.50 | matched |
| 74 | capture | 01a1ad35-57e0-7777-a370-8946b89305a4 | €15.00 | €0.26 | matched |
| 75 | capture | 01a1ad35-673c-7b58-9e12-c98578b292e2 | €15.00 | €0.26 | matched |
| 76 | capture | 01a1ad35-8125-776e-9f5d-c39c04ba82e5 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1ad35-837f-7557-a3f8-2811eb710a1e | €35.00 | €0.50 | matched |
| 78 | capture | 01a1ad35-8cca-7da5-ac58-f7ab8ee498bf | €24.00 | €0.37 | matched |
| 79 | capture | 01a1ad35-e3c7-764e-9c24-0cce54fdd49e | €49.00 | €0.67 | matched |
| 80 | capture | 01a1ad36-1617-77bc-aa51-0b4a6a6196c0 | €35.00 | €0.50 | matched |
| 81 | capture | 01a1ad36-1e41-779d-ad97-229fb425ae82 | €49.00 | €0.67 | matched |
| 82 | capture | 01a1ad36-276b-7897-989c-f35eda6f2ef3 | €49.00 | €0.67 | matched |
| 83 | capture | 01a1ad36-6534-7bd7-899d-a07fa0639e6e | €49.00 | €0.67 | matched |
| 84 | capture | 01a1ad36-6596-7123-82ab-dab4473d302c | €49.00 | €0.67 | matched |
| 85 | capture | 01a1ad36-8911-7bdf-be53-90aa7d273d4c | €49.00 | €0.67 | matched |
| 86 | capture | 01a1ad36-ada8-7d1d-b510-5bbf2be1b9cb | €35.00 | €0.50 | matched |
| 87 | capture | 01a1ad36-b6c1-7cd4-bb1a-2a692ea29f6f | €15.00 | €0.26 | matched |
| 88 | capture | 01a1ad36-e5e2-7337-b22e-e18f370577dc | €9.00 | €0.19 | matched |
| 89 | capture | 01a1ad36-e7c1-73c5-8e68-965d51bbdc76 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1ad36-f825-7e5b-bb61-8c0a653cda7a | €15.00 | €0.26 | matched |
| 91 | refund | 01a1ad37-0402-7252-8467-a4b07f567a50 | -€10.00 | €0.00 | matched |
| 92 | capture | 01a1ad37-0c72-7ee7-ba62-fcbb5fea0703 | €24.00 | €0.37 | matched |
| 93 | capture | 01a1ad37-0ff6-71cd-90af-d3b463cefd2b | €24.00 | €0.37 | matched |
| 94 | capture | 01a1ad37-2194-7b6c-9b23-ba8d33cbc30d | €49.00 | €0.67 | matched |
| 95 | capture | 01a1ad37-27a4-7694-8f78-adb36add00ae | €24.00 | €0.37 | matched |
| 96 | capture | 01a1ad37-435f-724f-af37-8cb1b3f14477 | €24.00 | €0.37 | matched |
| 97 | capture | 01a1ad37-45af-7eb4-97a5-9ca92ffcf8df | €24.00 | €0.37 | matched |
| 98 | capture | 01a1ad37-467a-7172-b530-2c45407b2e07 | €9.00 | €0.19 | matched |
| 99 | capture | 01a1ad37-4a48-7108-a178-7cf6c07e95c8 | €15.00 | €0.26 | matched |
| 100 | refund | 01a1ad37-50ba-7230-a529-5f4037606a3e | -€27.00 | €0.00 | matched |
| 101 | capture | 01a1ad37-57bb-714b-85aa-59623224f2a9 | €24.00 | €0.37 | matched |
| 102 | refund | 01a1ad37-6424-7c88-b966-a0ef734bd84c | -€15.00 | €0.00 | matched |
| 103 | refund | 01a1ad37-64d7-735f-847b-8388cce5cdae | -€9.00 | €0.00 | matched |
| 104 | capture | 01a1ad37-70a0-7bc5-89e6-1ada9f13ee77 | €15.00 | €0.26 | matched |
| 105 | capture | 01a1ad37-829f-7df1-8acf-5b87205a4ee5 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1ad37-8e9e-70de-ba75-467427bc667f | €49.00 | €0.67 | matched |
| 107 | capture | 01a1ad37-9ad9-73e0-bc76-e457b5d603c8 | €24.00 | €0.37 | matched |
| 108 | refund | 01a1ad37-af82-7847-9095-707938e789f6 | -€8.00 | €0.00 | matched |
| 109 | refund | 01a1ad37-e30a-7f29-a749-34cf001f9658 | -€8.00 | €0.00 | matched |
| 110 | capture | 01a1ad37-f428-7b8e-9e8a-4a597bea77fa | €35.00 | €0.50 | matched |
| 111 | capture | 01a1ad37-fdc0-7a62-a065-2e966f33526c | €24.00 | €0.37 | matched |
| 112 | capture | 01a1ad38-00a2-7df4-8edb-857165c87216 | €24.00 | €0.37 | matched |
| 113 | capture | 01a1ad38-014d-7758-a003-0b20e1e51d0a | €15.00 | €0.26 | matched |
| 114 | capture | 01a1ad38-0b19-7fb5-ad53-2d4b9a0ca2cd | €24.00 | €0.37 | matched |
| 115 | capture | 01a1ad38-1905-7268-86b8-77d1153a1787 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1ad38-196e-7646-acca-44e922a597c8 | €9.00 | €0.19 | matched |
| 117 | refund | 01a1ad38-3487-799a-affb-432bdb864ae3 | -€3.00 | €0.00 | matched |
| 118 | capture | 01a1ad38-4352-74bf-9f3d-ef98924213f0 | €49.00 | €0.67 | matched |
| 119 | capture | 01a1ad38-53b9-76d9-b06d-baf351a3bbc3 | €24.00 | €0.37 | matched |
| 120 | capture | 01a1ad38-59db-7317-bd2f-cd719da133c6 | €9.00 | €0.19 | matched |
| 121 | capture | 01a1ad38-5c44-7ed8-b76a-37182cf56eeb | €35.00 | €0.50 | matched |
| 122 | capture | 01a1ad38-7a4b-7a6c-bee2-281b03b75de1 | €9.00 | €0.19 | matched |
| 123 | capture | 01a1ad38-7b11-7196-ae44-2c70b2acd02b | €15.00 | €0.26 | matched |
| 124 | capture | 01a1ad38-a509-7e8b-88b6-49b42a205807 | €24.00 | €0.37 | matched |
| 125 | capture | 01a1ad38-b310-732e-bbf3-29766a373b49 | €15.00 | €0.26 | matched |
| 126 | capture | 01a1ad38-beae-7cee-9593-23b8dd2929bb | €49.00 | €0.67 | matched |
| 127 | refund | 01a1ad38-c213-74ec-bcba-d35c8b6b57e2 | -€34.00 | €0.00 | matched |
| 128 | capture | 01a1ad38-c5e1-7171-807d-699dd04fbcd3 | €9.00 | €0.19 | matched |
| 129 | capture | 01a1ad38-c687-7c56-b70a-a9e925849a38 | €49.00 | €0.67 | matched |
| 130 | capture | 01a1ad38-c9e9-7c59-b5fc-9b25944eece1 | €15.00 | €0.26 | matched |
| 131 | capture | 01a1ad39-0ce4-72c3-a90f-6fee57ed48cb | €49.00 | €0.67 | matched |
| 132 | capture | 01a1ad39-1f2c-796b-a16f-47c58eaa9348 | €24.00 | €0.37 | matched |
| 133 | capture | 01a1ad39-494a-75b7-a6d1-92a2a468149d | €24.00 | €0.37 | matched |
| 134 | capture | 01a1ad39-51a8-7103-b6de-f45fe7e6ff46 | €24.00 | €0.37 | matched |
| 135 | capture | 01a1ad39-6f06-7d54-90b5-e2ea57bf23a3 | €9.00 | €0.19 | matched |
| 136 | capture | 01a1ad39-8204-7757-a67b-3a96627c3c47 | €35.00 | €0.50 | matched |
| 137 | capture | 01a1ad39-8392-7f9c-b6a2-47ad38e5160f | €35.00 | €0.50 | matched |