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, 06:20116 lines2 breaks
- 5 Nov, 06:10133 lines4 breaks
- 5 Nov, 06:00125 lines2 breaks
- 5 Nov, 05:50121 lines3 breaks
- 5 Nov, 05:40113 lines3 breaks
- 5 Nov, 05:30114 linesclean
- 5 Nov, 05:20102 lines1 break
- 5 Nov, 05:10124 lines5 breaks
- 5 Nov, 05:00119 lines1 break
- 5 Nov, 04:50134 lines1 break
- 5 Nov, 04:40120 lines3 breaks
- 5 Nov, 04:30142 lines3 breaks
- 5 Nov, 04:20130 lines2 breaks
- 5 Nov, 04:10117 lines1 break
5 Nov, 05:10
Gross
€3,080.00
PSP fee
€47.75
Net to the bank
€3,032.25
Settlement journal
#392112
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1aa25-b1b2-76f3-9649-fc6fbe5bcede is already settled by stl_EUR_2989759 line 114
- fee differencethe fee is not the contract feethe fee is 30, the contract says 26
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- missing linein the books, not in the filecapture:01a1aa1d-5fcd-7ea4-a8e5-2b90ee8382db is in no file
- missing linein the books, not in the filecapture:01a1aa25-40b3-7834-a088-273b143317fd is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 87 | capture | 01a1aa23-0af7-7730-aeda-0d0773d12949 | €15.00 | €0.30 | fee difference |
| 89 | capture | 01a1aa23-2cc4-77b9-9225-93e0488b57c7 | €24.00 | €0.40 | fee difference |
| 115 | capture | 01a1aa25-b1e0-7ab6-837d-c9e5aa9acb82 | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a1aa1d-2b2f-74f3-b574-c799fd5177e9 | €49.00 | €0.67 | matched |
| 2 | capture | 01a1aa1d-36d1-7a3f-9977-0795d777fe16 | €49.00 | €0.67 | matched |
| 3 | refund | 01a1aa1d-4183-710b-a7bf-6f4ef5a90c60 | -€9.00 | €0.00 | matched |
| 4 | capture | 01a1aa1d-6076-726d-b6af-9c3ccc8cbff1 | €9.00 | €0.19 | matched |
| 5 | capture | 01a1aa1d-7538-7532-ab2a-8ffc213da1a0 | €35.00 | €0.50 | matched |
| 6 | capture | 01a1aa1d-7a58-7e0c-b28a-1738563103f7 | €15.00 | €0.26 | matched |
| 7 | capture | 01a1aa1d-b8a5-74c3-a313-a5a2338aa05d | €49.00 | €0.67 | matched |
| 8 | capture | 01a1aa1d-bf4d-7bb3-83f7-1758666f4a25 | €49.00 | €0.67 | matched |
| 9 | capture | 01a1aa1d-d9c2-7d1f-bcbd-7efc7d5fba4b | €35.00 | €0.50 | matched |
| 10 | capture | 01a1aa1d-e0ff-76dd-b101-944c58c048af | €49.00 | €0.67 | matched |
| 11 | capture | 01a1aa1d-e3f5-7a2c-954f-3cc65e00e3d4 | €9.00 | €0.19 | matched |
| 12 | capture | 01a1aa1e-0431-7bed-9672-7fafe2290649 | €35.00 | €0.50 | matched |
| 13 | capture | 01a1aa1e-2129-7a6e-ac7f-5b72f97df23a | €35.00 | €0.50 | matched |
| 14 | capture | 01a1aa1e-2693-75ed-b646-22605323e1f3 | €35.00 | €0.50 | matched |
| 15 | capture | 01a1aa1e-3343-7d3f-9af3-5beb0ef632ae | €35.00 | €0.50 | matched |
| 16 | capture | 01a1aa1e-334f-75c6-b631-68ccdf4e04fe | €24.00 | €0.37 | matched |
| 17 | capture | 01a1aa1e-3a28-716b-a775-a7b9fc11cf48 | €35.00 | €0.50 | matched |
| 18 | capture | 01a1aa1e-3cd4-7670-bd7a-f9660afb73c1 | €15.00 | €0.26 | matched |
| 19 | capture | 01a1aa1e-408d-76ef-ac93-be756c59b7c7 | €9.00 | €0.19 | matched |
| 20 | capture | 01a1aa1e-472c-7241-81c4-970b3ef6bed0 | €49.00 | €0.67 | matched |
| 21 | capture | 01a1aa1e-4b36-75fd-af5d-7807e6521a6d | €49.00 | €0.67 | matched |
| 22 | capture | 01a1aa1e-659e-7e37-862f-aabb9748f60d | €9.00 | €0.19 | matched |
| 23 | capture | 01a1aa1e-a217-7214-ac52-ef67c36a54ad | €15.00 | €0.26 | matched |
| 24 | capture | 01a1aa1e-a3ff-7ca8-b146-c17d81619064 | €24.00 | €0.37 | matched |
| 25 | capture | 01a1aa1e-b799-7ee4-a906-0b396892b462 | €15.00 | €0.26 | matched |
| 26 | capture | 01a1aa1e-c910-7444-a0ec-00104eff0bd2 | €9.00 | €0.19 | matched |
| 27 | capture | 01a1aa1e-e887-7906-98b8-75860ee2d31e | €9.00 | €0.19 | matched |
| 28 | capture | 01a1aa1e-fb6d-79b3-af72-cffe7022a14d | €15.00 | €0.26 | matched |
| 29 | capture | 01a1aa1e-ff10-738d-a163-d5c1d8a86cc8 | €15.00 | €0.26 | matched |
| 30 | capture | 01a1aa1f-0239-79cc-9241-7bba15508800 | €24.00 | €0.37 | matched |
| 31 | capture | 01a1aa1f-15d1-77d6-af84-fa78d2dc3f30 | €15.00 | €0.26 | matched |
| 32 | capture | 01a1aa1f-2195-7e1d-bccc-ed2b4ea035ec | €35.00 | €0.50 | matched |
| 33 | capture | 01a1aa1f-23eb-7559-8bf1-2f95c5446e93 | €35.00 | €0.50 | matched |
| 34 | capture | 01a1aa1f-1adc-7022-8a1e-2cf5d1e6e750 | €24.00 | €0.37 | matched |
| 35 | capture | 01a1aa1f-2d3f-738f-8f95-c592b6b84c4f | €49.00 | €0.67 | matched |
| 36 | refund | 01a1aa1f-3890-7f65-b335-645e3bb8b33c | -€8.00 | €0.00 | matched |
| 37 | capture | 01a1aa1f-3c53-7534-8f7e-07b17d5bb782 | €49.00 | €0.67 | matched |
| 38 | refund | 01a1aa1f-4006-7e8e-bc78-2dd4a829b275 | -€15.00 | €0.00 | matched |
| 39 | capture | 01a1aa1f-4499-76bd-aced-cbc9628cb841 | €9.00 | €0.19 | matched |
| 40 | capture | 01a1aa1f-4e0e-781d-8f72-605703760b09 | €15.00 | €0.26 | matched |
| 41 | capture | 01a1aa1f-515d-7c77-8951-dd224b7cb68a | €9.00 | €0.19 | matched |
| 42 | capture | 01a1aa1f-550c-7997-ab2e-75ba7c1ce867 | €15.00 | €0.26 | matched |
| 43 | capture | 01a1aa1f-59cb-78b0-ad04-a402e9558525 | €9.00 | €0.19 | matched |
| 44 | capture | 01a1aa1f-7b8d-7786-83a2-fbc1925c6210 | €9.00 | €0.19 | matched |
| 45 | capture | 01a1aa1f-aceb-778e-b61f-e4f2b4ce2973 | €15.00 | €0.26 | matched |
| 46 | capture | 01a1aa1f-ae3c-79e6-9d0f-c9f7431b9c67 | €9.00 | €0.19 | matched |
| 47 | capture | 01a1aa1f-cfc4-7ccb-a0ab-244836b141ac | €35.00 | €0.50 | matched |
| 48 | capture | 01a1aa1f-e0ee-7386-a645-6539cd986dd8 | €9.00 | €0.19 | matched |
| 49 | capture | 01a1aa1f-e356-703c-b1ff-27c6a7ec1032 | €15.00 | €0.26 | matched |
| 50 | capture | 01a1aa1f-f26e-7ba3-b8b8-5d946216f76d | €49.00 | €0.67 | matched |
| 51 | capture | 01a1aa20-1a40-7386-a48e-bdb5e1096045 | €24.00 | €0.37 | matched |
| 52 | capture | 01a1aa20-3dd1-7117-9ca8-399e73fd791d | €9.00 | €0.19 | matched |
| 53 | capture | 01a1aa20-3e5f-76a6-b02d-a3be6b8e8969 | €35.00 | €0.50 | matched |
| 54 | capture | 01a1aa20-79c6-7cc9-bf69-707ac4425eb2 | €49.00 | €0.67 | matched |
| 55 | capture | 01a1aa20-7abe-743c-aed1-1a7f8420a82b | €49.00 | €0.67 | matched |
| 56 | capture | 01a1aa20-7fd5-71a2-9edf-7eb007e52a3e | €9.00 | €0.19 | matched |
| 57 | capture | 01a1aa20-8101-713a-9a3c-a20cf4e30b63 | €24.00 | €0.37 | matched |
| 58 | capture | 01a1aa20-8a49-7975-95ac-70ef47ff2667 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1aa20-9578-7547-bbf4-74fbb137dd32 | €9.00 | €0.19 | matched |
| 60 | capture | 01a1aa20-9e39-7b5d-8578-09977e4bc480 | €9.00 | €0.19 | matched |
| 61 | capture | 01a1aa20-b4f7-770f-add5-69e2f3658716 | €15.00 | €0.26 | matched |
| 62 | capture | 01a1aa20-d829-7d6c-bc99-8147b0a78d1e | €15.00 | €0.26 | matched |
| 63 | capture | 01a1aa20-ee2a-7853-868b-f7f3328dca9d | €49.00 | €0.67 | matched |
| 64 | capture | 01a1aa21-12a6-7cf3-8b83-15048ca946bc | €35.00 | €0.50 | matched |
| 65 | capture | 01a1aa21-150f-7233-8e72-c59625d7a081 | €15.00 | €0.26 | matched |
| 66 | capture | 01a1aa21-17df-7227-b598-adab90e9b02c | €49.00 | €0.67 | matched |
| 67 | capture | 01a1aa21-25e0-7775-a33b-9e5e22628c6b | €24.00 | €0.37 | matched |
| 68 | capture | 01a1aa21-34dc-739e-a6e0-9de236eaf9b5 | €15.00 | €0.26 | matched |
| 69 | capture | 01a1aa21-426a-72c3-8ce2-d8a0adae2b5b | €24.00 | €0.37 | matched |
| 70 | capture | 01a1aa21-493b-7991-aa1a-d85918417ebe | €49.00 | €0.67 | matched |
| 71 | capture | 01a1aa21-68b6-71e3-afce-fd856a4379e1 | €35.00 | €0.50 | matched |
| 72 | refund | 01a1aa21-9bc7-7056-b4e4-5cc102051fbb | -€15.00 | €0.00 | matched |
| 73 | capture | 01a1aa21-9d2f-7cc6-8493-dc6b9c7c1278 | €24.00 | €0.37 | matched |
| 74 | capture | 01a1aa21-c405-7456-b3a3-260ef560dcc8 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1aa21-d5b7-7209-b2d5-2d5796915e83 | €15.00 | €0.26 | matched |
| 76 | capture | 01a1aa22-211c-7e76-ac3f-28f64c90b998 | €24.00 | €0.37 | matched |
| 77 | capture | 01a1aa22-5d68-7ff1-a372-9b86e0a9a497 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1aa22-6b70-7523-9098-d83ce237a523 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1aa22-8c6a-7235-8972-076819a3318c | €49.00 | €0.67 | matched |
| 80 | capture | 01a1aa22-96cd-72bf-a2a9-c5231485ddab | €24.00 | €0.37 | matched |
| 81 | capture | 01a1aa22-98a5-714c-873c-a3cb405c12b8 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1aa22-af43-72e3-8f34-4777099a7eb8 | €49.00 | €0.67 | matched |
| 83 | capture | 01a1aa22-b0e4-7910-aa5c-b510d37143c1 | €24.00 | €0.37 | matched |
| 84 | capture | 01a1aa22-bd0f-7fcc-9993-9b6b7e0071d8 | €49.00 | €0.67 | matched |
| 85 | capture | 01a1aa22-f9db-7564-9188-03a32f3da483 | €35.00 | €0.50 | matched |
| 86 | capture | 01a1aa23-091a-7cb5-9f72-3a3d45eee823 | €24.00 | €0.37 | matched |
| 88 | capture | 01a1aa23-16e0-7d14-aff9-275f25ae5376 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1aa23-3983-796c-83be-ba3cefa385b0 | €49.00 | €0.67 | matched |
| 91 | refund | 01a1aa23-49e2-7e1a-adb0-b63941a5609d | -€27.00 | €0.00 | matched |
| 92 | capture | 01a1aa23-d78c-76d6-9818-1446fd0e17f4 | €24.00 | €0.37 | matched |
| 93 | capture | 01a1aa24-1294-71e9-9ba4-f2f7fcacd027 | €35.00 | €0.50 | matched |
| 94 | capture | 01a1aa24-2632-7708-8472-41939e588077 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1aa24-3b8c-7863-b896-ec21bea7a353 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1aa24-44ac-7a3b-acbf-0a4486f3c376 | €24.00 | €0.37 | matched |
| 97 | capture | 01a1aa24-5226-7c76-b853-2d52c83d9f52 | €9.00 | €0.19 | matched |
| 98 | capture | 01a1aa24-60ae-7d2c-af0a-ac12bf2d0e4c | €35.00 | €0.50 | matched |
| 99 | capture | 01a1aa24-72a0-7a78-bc3d-204d501c3faa | €49.00 | €0.67 | matched |
| 100 | capture | 01a1aa24-7606-7902-b30a-7d17baae7de4 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1aa24-f6b8-7728-965c-fa795cb3c726 | €49.00 | €0.67 | matched |
| 102 | capture | 01a1aa25-02b0-7da5-aac7-90e078c5e544 | €15.00 | €0.26 | matched |
| 103 | capture | 01a1aa25-0402-7c8e-9f45-9040003b3dc1 | €35.00 | €0.50 | matched |
| 104 | refund | 01a1aa25-30af-7ab0-a380-5f2b246ee829 | -€14.00 | €0.00 | matched |
| 105 | capture | 01a1aa25-337d-712a-9dc9-b5e72711c6b5 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1aa25-58d6-72e4-9046-ad5c5362b7bf | €9.00 | €0.19 | matched |
| 107 | capture | 01a1aa25-5ac8-779e-ad7d-c8a1669ef8ab | €35.00 | €0.50 | matched |
| 108 | capture | 01a1aa25-8893-76e2-b020-5c83873f1aaa | €9.00 | €0.19 | matched |
| 109 | capture | 01a1aa25-8d2a-72c1-9729-0fdb0fdb6c71 | €49.00 | €0.67 | matched |
| 110 | refund | 01a1aa25-8f5c-767d-b7c1-38bf8ac125b3 | -€13.00 | €0.00 | matched |
| 111 | capture | 01a1aa25-a346-7fd7-a37a-2f30573d2fdc | €24.00 | €0.37 | matched |
| 112 | capture | 01a1aa25-a936-71e4-8d21-08883f9d35ec | €49.00 | €0.67 | matched |
| 113 | capture | 01a1aa25-af3d-73f5-9914-562fa697fc1c | €24.00 | €0.37 | matched |
| 114 | capture | 01a1aa25-b1e0-7ab6-837d-c9e5aa9acb82 | €15.00 | €0.26 | matched |
| 116 | capture | 01a1aa25-c0cd-77b4-a065-c8c36339023c | €9.00 | €0.19 | matched |
| 117 | capture | 01a1aa25-cba1-7ccf-ba1b-65ccffd58c2f | €9.00 | €0.19 | matched |
| 118 | capture | 01a1aa25-d1f1-7839-916b-c44d55515d7d | €49.00 | €0.67 | matched |
| 119 | capture | 01a1aa25-dd93-74cb-939f-2522f1fc8822 | €35.00 | €0.50 | matched |
| 120 | capture | 01a1aa25-ea6c-76d5-bb8f-23d758f9b253 | €35.00 | €0.50 | matched |
| 121 | capture | 01a1aa26-1852-7ede-b2aa-608a1c89285a | €35.00 | €0.50 | matched |
| 122 | capture | 01a1aa26-36c4-7884-b00b-08aad741f5b9 | €15.00 | €0.26 | matched |
| 123 | capture | 01a1aa26-3fc9-73bc-811c-188c2ed83bb0 | €49.00 | €0.67 | matched |
| 124 | capture | 01a1aa26-420b-7590-ba65-b8d134110a75 | €24.00 | €0.37 | matched |