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
- 28 Oct, 03:20114 lines1 break
- 28 Oct, 03:10141 linesclean
- 28 Oct, 03:00132 lines1 break
- 28 Oct, 02:50142 lines2 breaks
- 28 Oct, 02:40106 linesclean
- 28 Oct, 02:30122 lines1 break
- 28 Oct, 02:20133 lines2 breaks
- 28 Oct, 02:10119 lines4 breaks
- 28 Oct, 02:00101 lines1 break
- 28 Oct, 01:50131 lines4 breaks
- 28 Oct, 01:40121 lines6 breaks
- 28 Oct, 01:30116 linesclean
- 28 Oct, 01:20153 lines5 breaks
- 28 Oct, 01:10111 lines2 breaks
28 Oct, 02:20
Gross
€3,468.00
PSP fee
€53.06
Net to the bank
€3,414.94
Settlement journal
#243476
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18051-4d0c-772f-baba-5e2cbe470736 is already settled by stl_EUR_2988590 line 34
- missing linein the books, not in the filecapture:01a18056-b4c2-7648-9bd7-0bd883ce1409 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 35 | capture | 01a18051-58f9-727c-9b9c-0f1adbd16e63 | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a18048-6028-7ba3-9628-52fb896307b1 | €9.00 | €0.19 | matched |
| 2 | capture | 01a18048-6484-74aa-8a28-f7cde5bcd561 | €49.00 | €0.67 | matched |
| 3 | refund | 01a1804b-b971-7be6-9011-bf8e6ebed598 | -€11.00 | €0.00 | matched |
| 4 | capture | 01a1804e-a88f-75c7-96d0-1dbb68d96346 | €49.00 | €0.67 | matched |
| 5 | capture | 01a1804e-f11d-7a5e-a44a-9521afc64fcb | €15.00 | €0.26 | matched |
| 6 | capture | 01a1804f-013f-7fdb-9a96-56829f300970 | €49.00 | €0.67 | matched |
| 7 | capture | 01a1804f-25c5-7833-92db-e11e0d6ba67d | €35.00 | €0.50 | matched |
| 8 | capture | 01a1804f-5fcc-7db0-b721-82bc484f45fe | €15.00 | €0.26 | matched |
| 9 | capture | 01a1804f-765a-70af-b567-5f03771991df | €15.00 | €0.26 | matched |
| 10 | capture | 01a1804f-7c88-772f-a5b4-4671cbf1d542 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1804f-7c79-799a-988d-ff988c49b889 | €24.00 | €0.37 | matched |
| 12 | capture | 01a1804f-985f-7edd-954a-a5494e49c442 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1804f-b504-7649-a751-62389aa88459 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1804f-cd32-7e84-93ec-71f879d65eee | €15.00 | €0.26 | matched |
| 15 | capture | 01a1804f-dc9a-77af-958e-cd6cec29b90f | €15.00 | €0.26 | matched |
| 16 | capture | 01a1804f-e89f-7d5c-a8b8-b2fcc4cd1658 | €15.00 | €0.26 | matched |
| 17 | capture | 01a1804f-f274-7555-b62b-68e4069ef390 | €15.00 | €0.26 | matched |
| 18 | capture | 01a18050-361f-78c7-a422-2e557c2766b6 | €49.00 | €0.67 | matched |
| 19 | capture | 01a18050-3a0d-7f93-8e8f-6d95829fc084 | €24.00 | €0.37 | matched |
| 20 | capture | 01a18050-4b25-7c2d-87e8-9936e85d4b21 | €9.00 | €0.19 | matched |
| 21 | capture | 01a18050-5e81-7403-9aff-97424a379864 | €49.00 | €0.67 | matched |
| 22 | capture | 01a18050-631a-7222-abbf-8fcd91c2e4b7 | €24.00 | €0.37 | matched |
| 23 | capture | 01a18050-9d41-7dc7-8aee-3560f6784a9c | €15.00 | €0.26 | matched |
| 24 | capture | 01a18050-cbb8-7278-b671-95ea733ad096 | €49.00 | €0.67 | matched |
| 25 | capture | 01a18050-d5eb-7773-b602-07e3b91a3dcf | €49.00 | €0.67 | matched |
| 26 | capture | 01a18050-f02c-7981-b0e9-7d5145ed3df6 | €9.00 | €0.19 | matched |
| 27 | capture | 01a18051-014d-778d-b30c-482a47545a78 | €24.00 | €0.37 | matched |
| 28 | capture | 01a18051-1f48-7a94-8efd-24c2bd354733 | €49.00 | €0.67 | matched |
| 29 | capture | 01a18051-2067-798c-8f60-3ebe4873654d | €35.00 | €0.50 | matched |
| 30 | capture | 01a18051-2b4b-7abe-b065-cadbaa9d360f | €9.00 | €0.19 | matched |
| 31 | capture | 01a18051-3358-758b-9629-f4004bdc56c5 | €15.00 | €0.26 | matched |
| 32 | capture | 01a18051-3590-7733-a4ff-e914bf27e936 | €24.00 | €0.37 | matched |
| 33 | capture | 01a18051-3ca0-7757-9fff-5de3b6ea40ac | €49.00 | €0.67 | matched |
| 34 | capture | 01a18051-58f9-727c-9b9c-0f1adbd16e63 | €9.00 | €0.19 | matched |
| 36 | capture | 01a18051-6da1-74eb-bd64-9fbf78843605 | €15.00 | €0.26 | matched |
| 37 | capture | 01a18051-7a30-7d9a-a978-37a2d3971650 | €35.00 | €0.50 | matched |
| 38 | capture | 01a18051-7a73-7125-b9ab-6f3ee9fb248e | €9.00 | €0.19 | matched |
| 39 | capture | 01a18051-9534-7b77-acca-38e538bd61ba | €35.00 | €0.50 | matched |
| 40 | capture | 01a18051-9937-7a52-8218-4f3d6b5f3b11 | €15.00 | €0.26 | matched |
| 41 | capture | 01a18051-a009-71ad-92c0-6cc33cba3766 | €15.00 | €0.26 | matched |
| 42 | capture | 01a18051-a7da-7422-a014-7b3a2851fe14 | €49.00 | €0.67 | matched |
| 43 | capture | 01a18051-b3ea-7866-ac0b-7c64d616d300 | €15.00 | €0.26 | matched |
| 44 | capture | 01a18051-bade-7219-a5c7-886b12b7d6c7 | €49.00 | €0.67 | matched |
| 45 | capture | 01a18051-c0bd-767f-ac91-f1be9a3d9f06 | €15.00 | €0.26 | matched |
| 46 | capture | 01a18051-c6ed-7571-ab8f-788c73fb7c8e | €24.00 | €0.37 | matched |
| 47 | capture | 01a18051-cc55-75ec-ab7c-af591ab700cd | €15.00 | €0.26 | matched |
| 48 | capture | 01a18051-cfa4-7259-b223-890e699f06ca | €9.00 | €0.19 | matched |
| 49 | capture | 01a18051-edfb-7ce2-95a8-1d801d70685f | €9.00 | €0.19 | matched |
| 50 | capture | 01a18051-ef48-7b7e-bb38-900584037e32 | €24.00 | €0.37 | matched |
| 51 | capture | 01a18052-4270-7849-93c4-186658baad4b | €35.00 | €0.50 | matched |
| 52 | refund | 01a18052-4c94-72e7-9c4b-fde6c953300d | -€18.00 | €0.00 | matched |
| 53 | refund | 01a18052-5ebb-73b4-bf59-65b4e2d089c7 | -€5.00 | €0.00 | matched |
| 54 | capture | 01a18052-66c7-7cd7-977e-f4727b83afd1 | €9.00 | €0.19 | matched |
| 55 | capture | 01a18052-6bc7-725f-8a4e-4b5da3a1eeb7 | €35.00 | €0.50 | matched |
| 56 | capture | 01a18052-6d61-7c76-95f6-01179312f8b3 | €15.00 | €0.26 | matched |
| 57 | capture | 01a18052-87f5-79aa-9ee5-22e7a9054830 | €24.00 | €0.37 | matched |
| 58 | capture | 01a18052-9cb2-79da-9db7-d2ea8ca827d2 | €9.00 | €0.19 | matched |
| 59 | capture | 01a18052-a023-783e-b7c0-fa1e66dc5661 | €35.00 | €0.50 | matched |
| 60 | capture | 01a18052-a18e-7ce6-960d-c9f7fa17d9ef | €15.00 | €0.26 | matched |
| 61 | capture | 01a18052-c2d6-751e-9003-a11e8aec8138 | €9.00 | €0.19 | matched |
| 62 | capture | 01a18052-ecfa-76c1-af5d-e00073299095 | €15.00 | €0.26 | matched |
| 63 | capture | 01a18053-0795-7c35-8a3f-75ce48fb4d71 | €15.00 | €0.26 | matched |
| 64 | capture | 01a18053-08d1-7d47-9cc9-b1e6c1c6ee17 | €49.00 | €0.67 | matched |
| 65 | capture | 01a18053-10fb-78d3-b0c2-38240cc0c4e1 | €49.00 | €0.67 | matched |
| 66 | capture | 01a18053-1497-78f2-9c4b-c76d3916dc4c | €15.00 | €0.26 | matched |
| 67 | capture | 01a18053-3602-74f8-a1e9-5e47b5f15387 | €49.00 | €0.67 | matched |
| 68 | capture | 01a18053-39b5-7bb1-8ac2-f51244e8d789 | €35.00 | €0.50 | matched |
| 69 | capture | 01a18053-52c1-7f8e-9c73-1d43684d7181 | €15.00 | €0.26 | matched |
| 70 | capture | 01a18053-568a-7e5b-b135-91bc1eb48221 | €49.00 | €0.67 | matched |
| 71 | capture | 01a18053-5cc5-7b9c-ac54-4a50bc28fec4 | €9.00 | €0.19 | matched |
| 72 | capture | 01a18053-6536-79a2-a5f3-bbd52bb4cd5b | €24.00 | €0.37 | matched |
| 73 | refund | 01a18053-83dd-7f6d-8025-66d1cf5d54fd | -€27.00 | €0.00 | matched |
| 74 | capture | 01a18053-980d-767a-b2ee-2464eb0bb9ea | €24.00 | €0.37 | matched |
| 75 | capture | 01a18053-9c09-712a-9e84-535a739de609 | €49.00 | €0.67 | matched |
| 76 | capture | 01a18053-a522-7519-b6dd-0db9cbd8d64c | €15.00 | €0.26 | matched |
| 77 | capture | 01a18053-c06d-7636-9662-994b6bbedb7e | €15.00 | €0.26 | matched |
| 78 | capture | 01a18053-e26f-71fe-a24a-435f3a6edce7 | €35.00 | €0.50 | matched |
| 79 | capture | 01a18053-f1ef-7207-8cee-25bf75cd380b | €35.00 | €0.50 | matched |
| 80 | capture | 01a18054-0240-711b-a7b2-7d3c412e8102 | €15.00 | €0.26 | matched |
| 81 | capture | 01a18054-0dfc-7156-a1dd-5dd7ddc34f75 | €49.00 | €0.67 | matched |
| 82 | capture | 01a18054-170b-7219-bc45-b7dbd52362ba | €35.00 | €0.50 | matched |
| 83 | capture | 01a18054-1d99-7bb2-a5d6-1fb1424dbfbb | €24.00 | €0.37 | matched |
| 84 | capture | 01a18054-3864-772c-8b96-d167605a3417 | €15.00 | €0.26 | matched |
| 85 | capture | 01a18054-5bd3-764d-88a8-097de72754f8 | €49.00 | €0.67 | matched |
| 86 | capture | 01a18054-69ea-70fa-94bb-2d93ae6ac1ff | €24.00 | €0.37 | matched |
| 87 | capture | 01a18054-69ee-77f6-b861-954b1cd65576 | €35.00 | €0.50 | matched |
| 88 | capture | 01a18054-7f6c-7250-8803-08e4e03afc2c | €49.00 | €0.67 | matched |
| 89 | capture | 01a18054-8613-742f-a155-56610c22f178 | €35.00 | €0.50 | matched |
| 90 | capture | 01a18054-9564-75e3-b586-122cf21b0bdc | €24.00 | €0.37 | matched |
| 91 | capture | 01a18054-9ce4-7f7a-9724-b7380f92d998 | €49.00 | €0.67 | matched |
| 92 | capture | 01a18054-b113-7063-a2a5-c3449c164250 | €35.00 | €0.50 | matched |
| 93 | capture | 01a18054-cb1f-7efb-bc42-7fbc36df82e4 | €35.00 | €0.50 | matched |
| 94 | capture | 01a18054-dae7-7cdc-b2bf-e6fefbe7799d | €49.00 | €0.67 | matched |
| 95 | capture | 01a18054-ec26-7216-b193-2f2ea865bbf4 | €35.00 | €0.50 | matched |
| 96 | capture | 01a18055-0f0e-7a1d-a0fe-02818a30d701 | €15.00 | €0.26 | matched |
| 97 | capture | 01a18055-1b86-7c04-a846-0c80eda366e7 | €49.00 | €0.67 | matched |
| 98 | capture | 01a18055-2d09-7748-977b-4b88ac62cd77 | €9.00 | €0.19 | matched |
| 99 | capture | 01a18055-2eb9-7405-8644-69a68020a6d0 | €24.00 | €0.37 | matched |
| 100 | capture | 01a18055-3a04-746b-849b-32d990c9f1d3 | €35.00 | €0.50 | matched |
| 101 | capture | 01a18055-6c63-76aa-97b7-eb65dc5c55fc | €24.00 | €0.37 | matched |
| 102 | capture | 01a18055-a54f-781e-9052-34a4b0a5ab2e | €9.00 | €0.19 | matched |
| 103 | capture | 01a18055-c6b7-771e-8c53-d5b09575f3b8 | €15.00 | €0.26 | matched |
| 104 | capture | 01a18055-d317-778d-8eb0-5811cf90ae22 | €15.00 | €0.26 | matched |
| 105 | capture | 01a18055-ef66-7913-ab17-7977e42bed81 | €49.00 | €0.67 | matched |
| 106 | capture | 01a18056-0091-7df3-92b5-b0306f9cbb82 | €35.00 | €0.50 | matched |
| 107 | capture | 01a18056-250c-7bb5-91d6-c570cce21f01 | €9.00 | €0.19 | matched |
| 108 | capture | 01a18056-4f7e-7193-99d5-f3ccea89db2c | €24.00 | €0.37 | matched |
| 109 | capture | 01a18056-5503-74ef-af6f-e3e880ba241d | €49.00 | €0.67 | matched |
| 110 | capture | 01a18056-77d9-7b42-8ad6-12ef05993ed3 | €15.00 | €0.26 | matched |
| 111 | capture | 01a18056-7ab4-7b83-bcee-2a04ead1e963 | €49.00 | €0.67 | matched |
| 112 | capture | 01a18056-8a19-78e1-838f-1e4a5b950e93 | €35.00 | €0.50 | matched |
| 113 | capture | 01a18056-8bb3-7015-911e-7ca43b42bf60 | €24.00 | €0.37 | matched |
| 114 | capture | 01a18056-b586-7eec-87ff-8a9f5969d34a | €24.00 | €0.37 | matched |
| 115 | capture | 01a18056-c09e-7e82-9df7-1e8cd496f7aa | €24.00 | €0.37 | matched |
| 116 | capture | 01a18056-c49d-7d50-9f51-ffb3dbd093ef | €49.00 | €0.67 | matched |
| 117 | capture | 01a18056-c4fb-7a8e-8657-12e7e936de39 | €24.00 | €0.37 | matched |
| 118 | capture | 01a18056-e90b-7ed3-807b-359e1a421c1b | €24.00 | €0.37 | matched |
| 119 | capture | 01a18056-eca3-705e-a3d8-f1f8846fb023 | €24.00 | €0.37 | matched |
| 120 | capture | 01a18057-18b9-7ddc-91f5-025b8374734f | €35.00 | €0.50 | matched |
| 121 | capture | 01a18057-2021-78d7-bdcb-0349370e6948 | €24.00 | €0.37 | matched |
| 122 | capture | 01a18057-38c4-730f-ad43-6de5d7e28ca4 | €49.00 | €0.67 | matched |
| 123 | capture | 01a18057-41b7-7494-bb9a-26b30a3472fc | €49.00 | €0.67 | matched |
| 124 | capture | 01a18057-4acf-7b74-bcd3-04f9644072c5 | €9.00 | €0.19 | matched |
| 125 | capture | 01a18057-4eea-793f-8541-2d77f6a349e5 | €35.00 | €0.50 | matched |
| 126 | capture | 01a18057-86e5-732e-8339-7f6965287fb1 | €49.00 | €0.67 | matched |
| 127 | capture | 01a18057-880b-7dcf-a319-78340436ac10 | €49.00 | €0.67 | matched |
| 128 | capture | 01a18057-92ee-73cc-84c9-ee9866ec9600 | €35.00 | €0.50 | matched |
| 129 | capture | 01a18057-9438-7d57-8c59-1df4a9705d04 | €35.00 | €0.50 | matched |
| 130 | refund | 01a18057-9915-7a12-b4d4-95cb56fb5551 | -€27.00 | €0.00 | matched |
| 131 | capture | 01a18057-99d9-73b8-a992-8751f9c4cc31 | €9.00 | €0.19 | matched |
| 132 | capture | 01a18057-bb21-7965-a5bc-cd453cecf11b | €35.00 | €0.50 | matched |
| 133 | capture | 01a18057-c6ac-7dd8-89be-df8522b76b35 | €9.00 | €0.19 | matched |