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, 15:30126 linesclean
- 30 Oct, 15:20140 lines6 breaks
- 30 Oct, 15:10127 lines4 breaks
- 30 Oct, 15:00123 lines4 breaks
- 30 Oct, 14:50119 lines1 break
- 30 Oct, 14:40135 lines1 break
- 30 Oct, 14:30112 lines2 breaks
- 30 Oct, 14:20131 lines2 breaks
- 30 Oct, 14:10117 lines5 breaks
- 30 Oct, 14:00108 lines2 breaks
- 30 Oct, 13:50127 lines3 breaks
- 30 Oct, 13:40125 lines2 breaks
- 30 Oct, 13:30122 lines3 breaks
- 30 Oct, 13:20116 lines1 break
30 Oct, 14:10
Gross
€2,719.00
PSP fee
€43.70
Net to the bank
€2,675.30
Settlement journal
#289174
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18d27-f240-781f-87b1-a9567a7cfb85 is already settled by stl_EUR_2988949 line 25
- duplicate linethe file lists it twicecapture:01a18d2c-beed-7281-a7e2-ce85dcaccafd is already settled by stl_EUR_2988949 line 92
- fee differencethe fee is not the contract feethe fee is 42, the contract says 37
- fee differencethe fee is not the contract feethe fee is 30, the contract says 26
- missing linein the books, not in the filecapture:01a18d2c-7421-77ba-baa6-ba647344f7f3 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 11 | capture | 01a18d26-de17-7953-96fb-4c9d9474f156 | €24.00 | €0.42 | fee difference |
| 26 | capture | 01a18d28-0c5a-7beb-8c4e-eb11a1ee0665 | €35.00 | €0.50 | duplicate line |
| 64 | capture | 01a18d2a-8c5a-74c0-a133-e59b9f0eae1c | €15.00 | €0.30 | fee difference |
| 93 | capture | 01a18d2c-c022-756d-9617-05904f2d4f80 | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a18d21-8dd6-7f6b-9a23-335a135ef390 | €24.00 | €0.37 | matched |
| 2 | capture | 01a18d25-842a-7d3c-8eab-e1a24908d06b | €49.00 | €0.67 | matched |
| 3 | capture | 01a18d25-fbee-7211-bc51-f52e66b4f45a | €24.00 | €0.37 | matched |
| 4 | capture | 01a18d26-18de-7270-914a-84678a895f4c | €24.00 | €0.37 | matched |
| 5 | capture | 01a18d26-3ca5-797a-a075-e0b60fcddfcd | €49.00 | €0.67 | matched |
| 6 | capture | 01a18d26-6f65-75f1-8fa4-694daea58e06 | €35.00 | €0.50 | matched |
| 7 | capture | 01a18d26-8117-7bb7-90b6-638c232d07b1 | €15.00 | €0.26 | matched |
| 8 | capture | 01a18d26-bf87-77a7-9dd1-a38f7f15cff5 | €24.00 | €0.37 | matched |
| 9 | capture | 01a18d26-c769-7c64-aa7a-05c77b5c8fe4 | €24.00 | €0.37 | matched |
| 10 | capture | 01a18d26-db8a-7b14-8a56-83348df622ca | €24.00 | €0.37 | matched |
| 12 | capture | 01a18d26-f2c2-73cd-a990-9974c5c62b48 | €15.00 | €0.26 | matched |
| 13 | capture | 01a18d27-04c6-7bd8-b55b-bc1ada033f12 | €24.00 | €0.37 | matched |
| 14 | refund | 01a18d27-05b1-7e3d-8ceb-0d3485c007e9 | -€20.00 | €0.00 | matched |
| 15 | capture | 01a18d27-0e94-7ca6-a8d7-f5180eb85b85 | €49.00 | €0.67 | matched |
| 16 | capture | 01a18d27-13d7-7727-8fef-ba89e612984c | €49.00 | €0.67 | matched |
| 17 | capture | 01a18d27-1db4-7695-b509-ac329ad28af3 | €35.00 | €0.50 | matched |
| 18 | capture | 01a18d27-23a8-76ab-9fc0-96950ad116ab | €15.00 | €0.26 | matched |
| 19 | capture | 01a18d27-503c-7095-950c-dbcbaedd290e | €49.00 | €0.67 | matched |
| 20 | capture | 01a18d27-6ab2-7277-be14-eecde7004bf0 | €24.00 | €0.37 | matched |
| 21 | capture | 01a18d27-7b17-798f-97b6-5da2b8fd38e3 | €15.00 | €0.26 | matched |
| 22 | capture | 01a18d27-906e-765f-aea1-e18942006791 | €35.00 | €0.50 | matched |
| 23 | capture | 01a18d27-cc95-7ed7-b09a-bf6c56a676d7 | €35.00 | €0.50 | matched |
| 24 | capture | 01a18d27-f10b-732b-a1bb-468283628232 | €9.00 | €0.19 | matched |
| 25 | capture | 01a18d28-0c5a-7beb-8c4e-eb11a1ee0665 | €35.00 | €0.50 | matched |
| 27 | capture | 01a18d28-117b-7029-8d5d-9103ecafcd52 | €15.00 | €0.26 | matched |
| 28 | capture | 01a18d28-1f95-7861-b663-eb66b435d8e1 | €49.00 | €0.67 | matched |
| 29 | capture | 01a18d28-3711-7e59-9c32-ec302b79ba04 | €35.00 | €0.50 | matched |
| 30 | capture | 01a18d28-426f-7bf3-8fd9-6a4be76b1e6d | €24.00 | €0.37 | matched |
| 31 | capture | 01a18d28-4587-7235-b0ad-cd6545594c7e | €9.00 | €0.19 | matched |
| 32 | capture | 01a18d28-4d08-7d85-9aad-7faa95c76a83 | €24.00 | €0.37 | matched |
| 33 | refund | 01a18d28-4db4-7405-b9c7-d86c5a0f16ab | -€32.00 | €0.00 | matched |
| 34 | capture | 01a18d28-4fd0-7c50-9615-24eee0f49d99 | €49.00 | €0.67 | matched |
| 35 | refund | 01a18d28-86fe-7e51-9e44-6ff986b8e638 | -€49.00 | €0.00 | matched |
| 36 | capture | 01a18d28-891a-7871-a8b3-5a3eaab6f706 | €24.00 | €0.37 | matched |
| 37 | capture | 01a18d28-9fb9-7932-a410-7587633cdcd7 | €15.00 | €0.26 | matched |
| 38 | capture | 01a18d28-b50a-7bfe-a03d-a9325dfa2381 | €24.00 | €0.37 | matched |
| 39 | capture | 01a18d28-bafe-7ab8-b13c-7c1ede61a7e9 | €49.00 | €0.67 | matched |
| 40 | capture | 01a18d28-c7f0-7de1-bdaf-d0eaee8b433e | €15.00 | €0.26 | matched |
| 41 | capture | 01a18d28-e52a-7dbb-afd1-04e7458261bd | €24.00 | €0.37 | matched |
| 42 | capture | 01a18d28-f7ae-7f88-877d-4107b35e4a6f | €15.00 | €0.26 | matched |
| 43 | capture | 01a18d29-169a-7a11-9c2e-9dc499dc64d4 | €35.00 | €0.50 | matched |
| 44 | capture | 01a18d29-322d-7954-a531-6abde24c5ad0 | €49.00 | €0.67 | matched |
| 45 | capture | 01a18d29-6c54-7729-9572-fcd8057679bc | €24.00 | €0.37 | matched |
| 46 | capture | 01a18d29-6eac-7676-a944-9198297f7c0a | €35.00 | €0.50 | matched |
| 47 | capture | 01a18d29-8e06-70b1-9b7e-56a3c63619ed | €49.00 | €0.67 | matched |
| 48 | capture | 01a18d29-9823-7f55-8f51-cd2ec1983830 | €24.00 | €0.37 | matched |
| 49 | capture | 01a18d29-a1ea-720a-ac7f-e1a0457b5701 | €15.00 | €0.26 | matched |
| 50 | capture | 01a18d29-a648-7816-a241-749810246907 | €24.00 | €0.37 | matched |
| 51 | capture | 01a18d29-a850-7466-902f-ac25f207ecfc | €35.00 | €0.50 | matched |
| 52 | capture | 01a18d29-c198-7821-b634-1447ae1e5607 | €15.00 | €0.26 | matched |
| 53 | capture | 01a18d29-cd59-726b-9b80-0199eb4d4518 | €24.00 | €0.37 | matched |
| 54 | capture | 01a18d29-de2e-797c-9d7c-099608ddd94e | €9.00 | €0.19 | matched |
| 55 | capture | 01a18d29-fe7f-71f8-baaa-4b8ddf12d6c8 | €35.00 | €0.50 | matched |
| 56 | capture | 01a18d2a-1a1c-7b92-8ddb-5b777e82757c | €9.00 | €0.19 | matched |
| 57 | refund | 01a18d2a-21c2-76f5-a4b3-e9de93600abf | -€8.00 | €0.00 | matched |
| 58 | capture | 01a18d2a-48b6-74a2-aa93-4827d6f2ff74 | €15.00 | €0.26 | matched |
| 59 | capture | 01a18d2a-51ca-7e3b-b980-6290a125fe6a | €9.00 | €0.19 | matched |
| 60 | capture | 01a18d2a-6511-7888-9c6e-e41796fffcaf | €24.00 | €0.37 | matched |
| 61 | capture | 01a18d2a-7939-71fb-907d-7745e7898262 | €24.00 | €0.37 | matched |
| 62 | capture | 01a18d2a-79cd-7949-90c5-3ca00251b0f7 | €49.00 | €0.67 | matched |
| 63 | capture | 01a18d2a-7d00-7133-a398-a8ea0e0e5d5f | €9.00 | €0.19 | matched |
| 65 | capture | 01a18d2a-923d-75ab-980c-c9c03e562e3e | €9.00 | €0.19 | matched |
| 66 | capture | 01a18d2a-9317-7cb7-a03b-fe4c3a309d5c | €35.00 | €0.50 | matched |
| 67 | capture | 01a18d2a-aac6-72ef-a76b-680bf578918f | €24.00 | €0.37 | matched |
| 68 | capture | 01a18d2a-bb0a-779e-a961-67a96839b461 | €49.00 | €0.67 | matched |
| 69 | refund | 01a18d2a-cdc9-78a7-9189-8a2b74c0e6c7 | -€8.00 | €0.00 | matched |
| 70 | capture | 01a18d2a-e49f-759c-8ddb-4d3ea7a83487 | €15.00 | €0.26 | matched |
| 71 | capture | 01a18d2a-f515-7d0b-a6db-06f727e0fa50 | €24.00 | €0.37 | matched |
| 72 | refund | 01a18d2b-0dae-7574-a1c7-919d65997814 | -€14.00 | €0.00 | matched |
| 73 | capture | 01a18d2b-10c1-7886-b936-effafbd07a3b | €15.00 | €0.26 | matched |
| 74 | capture | 01a18d2b-16d3-7c0c-b33e-db138843dae5 | €35.00 | €0.50 | matched |
| 75 | capture | 01a18d2b-44e4-7ecb-8c8d-f26586073ce1 | €49.00 | €0.67 | matched |
| 76 | capture | 01a18d2b-4beb-7cfa-81eb-23f8d752bedc | €35.00 | €0.50 | matched |
| 77 | capture | 01a18d2b-64df-774d-bd1f-17c4cd407714 | €49.00 | €0.67 | matched |
| 78 | capture | 01a18d2b-7cc8-7c28-a3b3-ba1f2376407d | €49.00 | €0.67 | matched |
| 79 | capture | 01a18d2b-8601-7870-aebf-ea23647509c8 | €49.00 | €0.67 | matched |
| 80 | capture | 01a18d2b-8935-73dd-8005-db5ceb8ec882 | €15.00 | €0.26 | matched |
| 81 | capture | 01a18d2b-8c9d-7fd0-a22b-923abc22f952 | €49.00 | €0.67 | matched |
| 82 | capture | 01a18d2b-c92e-7d2a-913e-3bd33ed3b00c | €35.00 | €0.50 | matched |
| 83 | capture | 01a18d2b-e480-7a09-ae5b-84f39b67d9e7 | €35.00 | €0.50 | matched |
| 84 | capture | 01a18d2b-e43d-7cc2-8e7f-331bfa6a99a7 | €24.00 | €0.37 | matched |
| 85 | capture | 01a18d2b-ffc2-7613-bad8-119555257803 | €15.00 | €0.26 | matched |
| 86 | capture | 01a18d2c-0c8b-769e-a331-d8ac91ed6a89 | €24.00 | €0.37 | matched |
| 87 | capture | 01a18d2c-3bfd-792e-91c6-d17bc37978dc | €35.00 | €0.50 | matched |
| 88 | capture | 01a18d2c-5896-741e-a55d-fa4f00eb4cc3 | €35.00 | €0.50 | matched |
| 89 | capture | 01a18d2c-8da5-7934-8094-ae4443f3205e | €15.00 | €0.26 | matched |
| 90 | capture | 01a18d2c-9ef4-7dad-abe6-f9539ae5dae8 | €9.00 | €0.19 | matched |
| 91 | capture | 01a18d2c-aa3d-7ffc-ade2-3ddcba180b59 | €49.00 | €0.67 | matched |
| 92 | capture | 01a18d2c-c022-756d-9617-05904f2d4f80 | €9.00 | €0.19 | matched |
| 94 | capture | 01a18d2c-c0eb-738e-a4b5-63f77c9019ef | €15.00 | €0.26 | matched |
| 95 | refund | 01a18d2c-ef8b-742b-b210-a1d6a7a673ee | -€32.00 | €0.00 | matched |
| 96 | capture | 01a18d2c-f066-76b0-860f-5b904fbb4be1 | €9.00 | €0.19 | matched |
| 97 | capture | 01a18d2c-fcbf-788e-814f-9735d058a93f | €15.00 | €0.26 | matched |
| 98 | capture | 01a18d2d-0a2e-7342-9d5e-af246482ccb1 | €15.00 | €0.26 | matched |
| 99 | capture | 01a18d2d-104e-7067-93e2-8966e029aaeb | €9.00 | €0.19 | matched |
| 100 | refund | 01a18d2d-1b74-784a-828c-9fe53d1d5be1 | -€15.00 | €0.00 | matched |
| 101 | capture | 01a18d2d-3a06-7f44-8797-aa1ee67064aa | €49.00 | €0.67 | matched |
| 102 | capture | 01a18d2d-3d10-78aa-89ab-d0854b2887d5 | €49.00 | €0.67 | matched |
| 103 | capture | 01a18d2d-41f0-773f-81d5-3eead7634572 | €24.00 | €0.37 | matched |
| 104 | capture | 01a18d2d-496d-7fe5-8d91-f902e4526066 | €35.00 | €0.50 | matched |
| 105 | capture | 01a18d2d-4afb-7f07-94c9-2040217dc688 | €35.00 | €0.50 | matched |
| 106 | capture | 01a18d2d-5fcc-7f71-8830-10ff1e088203 | €24.00 | €0.37 | matched |
| 107 | capture | 01a18d2d-6e8e-7f19-90fc-d58720b7da98 | €9.00 | €0.19 | matched |
| 108 | capture | 01a18d2d-b132-7ea1-8260-57e46dac241b | €15.00 | €0.26 | matched |
| 109 | capture | 01a18d2d-c213-734b-a33b-034cb1e7131e | €15.00 | €0.26 | matched |
| 110 | capture | 01a18d2d-c883-7c43-96f4-01333aa5cb34 | €15.00 | €0.26 | matched |
| 111 | capture | 01a18d2d-cdaa-74ab-8e49-8463100486d5 | €15.00 | €0.26 | matched |
| 112 | capture | 01a18d2e-1be0-72ea-ae3d-9a6ba2fb7237 | €9.00 | €0.19 | matched |
| 113 | capture | 01a18d2e-2c54-775b-be98-16307e58ffed | €15.00 | €0.26 | matched |
| 114 | capture | 01a18d2e-48fb-76c5-bff5-1dacca8a7ffd | €24.00 | €0.37 | matched |
| 115 | capture | 01a18d2e-4deb-76f3-841a-cd52da2d667d | €35.00 | €0.50 | matched |
| 116 | capture | 01a18d2e-6009-7ea0-95d9-a7fd1aa997be | €9.00 | €0.19 | matched |
| 117 | capture | 01a18d2e-7962-74c8-9420-57bfc73fc645 | €24.00 | €0.37 | matched |