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
- 16 Oct, 01:40114 lines1 break
- 16 Oct, 01:30128 lines3 breaks
- 16 Oct, 01:20132 lines2 breaks
- 16 Oct, 01:10114 lines2 breaks
- 16 Oct, 01:00146 lines6 breaks
- 16 Oct, 00:50129 lines3 breaks
- 16 Oct, 00:40141 lines4 breaks
- 16 Oct, 00:30133 lines3 breaks
- 16 Oct, 00:20123 lines5 breaks
- 16 Oct, 00:10120 lines3 breaks
- 16 Oct, 00:00134 lines1 break
- 15 Oct, 23:50138 linesclean
- 15 Oct, 23:40123 lines2 breaks
- 15 Oct, 23:30133 lines5 breaks
16 Oct, 00:10
Gross
€3,058.00
PSP fee
€47.22
Net to the bank
€3,010.78
Settlement journal
#23719
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14212-78bc-74fe-b7ae-8346d89a2af0 is already settled by stl_EUR_2986849 line 93
- fee differencethe fee is not the contract feethe fee is 27, the contract says 26
- missing linein the books, not in the filecapture:01a1420d-a438-792c-a308-49462052b716 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 68 | capture | 01a14210-f988-7fd8-9076-4e82bf856ab4 | €15.00 | €0.27 | fee difference |
| 94 | capture | 01a14212-78d6-7602-b3fa-a34cbba6c171 | €15.00 | €0.26 | duplicate line |
| 1 | refund | 01a14202-4c0b-711c-a94e-7a848ca87680 | -€15.00 | €0.00 | matched |
| 2 | capture | 01a14204-e9ec-7352-b7ce-77414c5d6bc5 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1420a-3b46-7f65-ab1e-f2690c5ab0d9 | €9.00 | €0.19 | matched |
| 4 | capture | 01a1420a-c8db-7d65-9836-23de89b7164b | €49.00 | €0.67 | matched |
| 5 | capture | 01a1420b-528e-7589-b537-db2f3b758d7f | €35.00 | €0.50 | matched |
| 6 | capture | 01a1420b-5bbd-7d9e-820c-21d521b12370 | €9.00 | €0.19 | matched |
| 7 | capture | 01a1420b-6cf7-70b1-b802-339aca1aae37 | €49.00 | €0.67 | matched |
| 8 | capture | 01a1420b-861b-7f27-af3f-1353fdb98b45 | €49.00 | €0.67 | matched |
| 9 | capture | 01a1420b-9fe8-7bd5-9b49-c4673a2ec788 | €9.00 | €0.19 | matched |
| 10 | capture | 01a1420b-a444-7709-a0fe-365256d55ee2 | €9.00 | €0.19 | matched |
| 11 | capture | 01a1420b-a74f-767e-aee3-0f367dc2f5ff | €15.00 | €0.26 | matched |
| 12 | capture | 01a1420b-cbf8-7386-85bf-3cc82e5c081e | €9.00 | €0.19 | matched |
| 13 | capture | 01a1420b-df2f-7ea0-b66d-17e873cb0716 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1420b-e1b7-77e2-a27f-2b5f4ff2f2da | €24.00 | €0.37 | matched |
| 15 | capture | 01a1420b-f543-7fc5-a3ea-2cb334956c93 | €49.00 | €0.67 | matched |
| 16 | refund | 01a1420c-0805-7925-abb9-81cb6331e835 | -€7.00 | €0.00 | matched |
| 17 | capture | 01a1420c-1b1d-7466-b4fe-853efef86240 | €9.00 | €0.19 | matched |
| 18 | capture | 01a1420c-463b-7da4-b028-a09a911de685 | €49.00 | €0.67 | matched |
| 19 | capture | 01a1420c-4c69-7b46-ba7a-f9ddc06fece4 | €35.00 | €0.50 | matched |
| 20 | capture | 01a1420c-7cbe-7264-9a35-5f5408cba7f9 | €35.00 | €0.50 | matched |
| 21 | capture | 01a1420c-9aea-7834-8661-302824f5a226 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1420c-ae00-706f-bcaf-a4b22c4ac05e | €15.00 | €0.26 | matched |
| 23 | capture | 01a1420c-d193-779a-a440-f7aa14b76487 | €9.00 | €0.19 | matched |
| 24 | capture | 01a1420c-d628-7964-bbf2-c99b93592140 | €9.00 | €0.19 | matched |
| 25 | capture | 01a1420d-1507-702e-8225-fe158cd62eae | €15.00 | €0.26 | matched |
| 26 | capture | 01a1420d-58d2-7f15-a454-2fe91ad27ba7 | €35.00 | €0.50 | matched |
| 27 | capture | 01a1420d-5bcd-72cf-95e7-c611950efcb3 | €49.00 | €0.67 | matched |
| 28 | capture | 01a1420d-abae-7610-89c5-fd95151c99f1 | €49.00 | €0.67 | matched |
| 29 | capture | 01a1420d-c928-7571-9753-6ed8086027fb | €15.00 | €0.26 | matched |
| 30 | capture | 01a1420d-d02f-7627-968a-41b0893cc8aa | €49.00 | €0.67 | matched |
| 31 | capture | 01a1420d-da8b-7187-bc4a-8fe968ab867a | €49.00 | €0.67 | matched |
| 32 | capture | 01a1420d-de31-764d-b1cd-59076a3c9ea1 | €24.00 | €0.37 | matched |
| 33 | capture | 01a1420d-edcd-732a-aa79-f24ad4062feb | €15.00 | €0.26 | matched |
| 34 | capture | 01a1420d-f48d-7326-b4e6-239b775c3249 | €24.00 | €0.37 | matched |
| 35 | refund | 01a1420e-0cf2-7957-9e7d-cf8385762727 | -€16.00 | €0.00 | matched |
| 36 | capture | 01a1420e-2e1a-72f3-b253-fabfd28c5c08 | €24.00 | €0.37 | matched |
| 37 | capture | 01a1420e-2f10-7ee5-b4bf-bc2dc1973919 | €15.00 | €0.26 | matched |
| 38 | capture | 01a1420e-312f-7cf1-be1c-ff9513c2ed0e | €15.00 | €0.26 | matched |
| 39 | capture | 01a1420e-423d-777f-ad05-4e581be8dc26 | €49.00 | €0.67 | matched |
| 40 | capture | 01a1420e-98c4-78c7-b0b0-af3396ef0365 | €15.00 | €0.26 | matched |
| 41 | capture | 01a1420e-b1e8-780b-af2a-3a24b430d838 | €49.00 | €0.67 | matched |
| 42 | capture | 01a1420e-bb03-7b48-aa5d-07f218403f5c | €15.00 | €0.26 | matched |
| 43 | capture | 01a1420e-cbfd-7b9e-87a2-56c421fcacd7 | €35.00 | €0.50 | matched |
| 44 | capture | 01a1420e-e2d2-7ec6-9215-4b4a8e7484a9 | €9.00 | €0.19 | matched |
| 45 | capture | 01a1420e-e3e8-7cb8-b4bb-1c028e5b01bb | €49.00 | €0.67 | matched |
| 46 | capture | 01a1420f-024a-753a-b7af-9b90f60b5240 | €49.00 | €0.67 | matched |
| 47 | capture | 01a1420f-0c94-7f86-8590-e1a2bac2f74d | €24.00 | €0.37 | matched |
| 48 | capture | 01a1420f-0e91-79ad-a00b-bea129b65893 | €49.00 | €0.67 | matched |
| 49 | capture | 01a1420f-1055-7614-af65-d30ea107653d | €35.00 | €0.50 | matched |
| 50 | capture | 01a1420f-2348-756f-8c50-4c05083e54cb | €49.00 | €0.67 | matched |
| 51 | capture | 01a1420f-3346-746f-9058-7e22dedf5563 | €24.00 | €0.37 | matched |
| 52 | capture | 01a1420f-6e53-77c2-81c0-9375e457f012 | €9.00 | €0.19 | matched |
| 53 | capture | 01a1420f-72d5-71d1-930d-d77ee878897a | €35.00 | €0.50 | matched |
| 54 | refund | 01a1420f-7c86-72ce-bb8e-c912a26b0a91 | -€20.00 | €0.00 | matched |
| 55 | capture | 01a1420f-9219-7433-821e-01b3899ec440 | €15.00 | €0.26 | matched |
| 56 | capture | 01a1420f-ae77-7f5a-b7ba-0b3b525f5498 | €35.00 | €0.50 | matched |
| 57 | capture | 01a1420f-c71f-70e8-9ac5-0c4507ceb68b | €9.00 | €0.19 | matched |
| 58 | capture | 01a1420f-e61a-7c6a-b0f8-b011bb9949b3 | €35.00 | €0.50 | matched |
| 59 | capture | 01a1420f-ed21-7db2-8d0a-cd6211f02d35 | €9.00 | €0.19 | matched |
| 60 | capture | 01a14210-14ef-7367-8fb5-f06bb9cf41a6 | €24.00 | €0.37 | matched |
| 61 | capture | 01a14210-3635-799b-9c75-cc51cac7338f | €49.00 | €0.67 | matched |
| 62 | capture | 01a14210-4792-7aa4-a0c9-14e97f6b2336 | €9.00 | €0.19 | matched |
| 63 | capture | 01a14210-69f3-745a-9641-1e11efe7e4fe | €35.00 | €0.50 | matched |
| 64 | capture | 01a14210-7879-7c26-bb64-d7825840ee60 | €49.00 | €0.67 | matched |
| 65 | capture | 01a14210-e014-73be-954c-7bf856f559af | €35.00 | €0.50 | matched |
| 66 | capture | 01a14210-ee60-71e0-8a2e-e5cc24c2915c | €35.00 | €0.50 | matched |
| 67 | capture | 01a14210-f39f-786b-8169-f07d6d6bfe7c | €24.00 | €0.37 | matched |
| 69 | capture | 01a14211-05d1-7be4-91fe-dfffcad5828b | €15.00 | €0.26 | matched |
| 70 | capture | 01a14211-0b84-745c-90bd-8f78c913d192 | €49.00 | €0.67 | matched |
| 71 | capture | 01a14211-1085-7b2e-a792-63e438ed7488 | €49.00 | €0.67 | matched |
| 72 | capture | 01a14211-3728-75a5-9861-5457078bc17a | €15.00 | €0.26 | matched |
| 73 | capture | 01a14211-419f-7ef3-ad6f-a9acff140e30 | €15.00 | €0.26 | matched |
| 74 | refund | 01a14211-45f5-7c13-ac8b-7ca90409f055 | -€8.00 | €0.00 | matched |
| 75 | capture | 01a14211-47e0-73cf-b989-7ad626a0f678 | €49.00 | €0.67 | matched |
| 76 | capture | 01a14211-4824-74e3-b0bf-8559c09244dc | €15.00 | €0.26 | matched |
| 77 | capture | 01a14211-9fb0-75e3-a337-53d70473485b | €49.00 | €0.67 | matched |
| 78 | capture | 01a14211-a040-70db-b729-f10fc00b97a9 | €24.00 | €0.37 | matched |
| 79 | capture | 01a14211-a817-70ef-937f-d7780ea506a2 | €35.00 | €0.50 | matched |
| 80 | capture | 01a14211-b3a8-73e4-8df5-f1f57474159d | €49.00 | €0.67 | matched |
| 81 | capture | 01a14211-b486-7f6a-b0be-f997e521bd7c | €24.00 | €0.37 | matched |
| 82 | capture | 01a14211-be0e-74a4-b820-36e9e4969587 | €24.00 | €0.37 | matched |
| 83 | capture | 01a14211-ce74-76b4-afc4-1e7c8817d414 | €24.00 | €0.37 | matched |
| 84 | capture | 01a14211-d26b-77c9-93f2-2e0d523f2848 | €35.00 | €0.50 | matched |
| 85 | capture | 01a14211-d4bc-7816-b4fe-1b0adbd3c9ae | €49.00 | €0.67 | matched |
| 86 | capture | 01a14211-d9f5-7558-9f15-7e867dfbc7e2 | €24.00 | €0.37 | matched |
| 87 | capture | 01a14211-e2da-72a9-8509-7f318e71db79 | €9.00 | €0.19 | matched |
| 88 | capture | 01a14211-f249-7731-91bf-6783e882527c | €24.00 | €0.37 | matched |
| 89 | capture | 01a14211-ffb5-7d6e-928d-43fced521274 | €9.00 | €0.19 | matched |
| 90 | capture | 01a14212-2472-7824-b919-3700c5aa88da | €35.00 | €0.50 | matched |
| 91 | capture | 01a14212-2a93-7ab7-bdcd-a9d6d39c3244 | €15.00 | €0.26 | matched |
| 92 | capture | 01a14212-4891-7229-be44-e1e491b4a371 | €35.00 | €0.50 | matched |
| 93 | capture | 01a14212-78d6-7602-b3fa-a34cbba6c171 | €15.00 | €0.26 | matched |
| 95 | capture | 01a14212-990f-77ff-b8fa-49e66555234a | €24.00 | €0.37 | matched |
| 96 | capture | 01a14212-c514-708f-8492-4342d3cf7589 | €9.00 | €0.19 | matched |
| 97 | capture | 01a14212-f86c-767b-a681-66fbbc33f445 | €35.00 | €0.50 | matched |
| 98 | capture | 01a14213-0fc9-73c4-b4ef-e6817d0b280e | €24.00 | €0.37 | matched |
| 99 | capture | 01a14213-12a3-7ad1-b7a9-5f5fe8302531 | €15.00 | €0.26 | matched |
| 100 | capture | 01a14213-1df1-76fb-b406-431aa66efdeb | €49.00 | €0.67 | matched |
| 101 | capture | 01a14213-2025-7884-8060-ba1fd573c9cc | €24.00 | €0.37 | matched |
| 102 | capture | 01a14213-2ebf-7558-bc5a-21b4ea9064b5 | €9.00 | €0.19 | matched |
| 103 | capture | 01a14213-32a7-746f-ac27-4dae02db56b4 | €49.00 | €0.67 | matched |
| 104 | capture | 01a14213-3584-7062-a9e0-a69af4f5c2ba | €9.00 | €0.19 | matched |
| 105 | capture | 01a14213-3cb3-7fdc-8878-0b7ed329f906 | €15.00 | €0.26 | matched |
| 106 | capture | 01a14213-56b7-72f5-a5bd-895127fc60a5 | €24.00 | €0.37 | matched |
| 107 | capture | 01a14213-56e4-7afb-a2c0-dc559ba1b747 | €24.00 | €0.37 | matched |
| 108 | capture | 01a14213-6973-7425-8273-bfddf0155c1b | €24.00 | €0.37 | matched |
| 109 | capture | 01a14213-7619-7f92-8c3c-300076f2c30b | €49.00 | €0.67 | matched |
| 110 | capture | 01a14213-766d-714b-b8c0-175359a225f7 | €49.00 | €0.67 | matched |
| 111 | capture | 01a14213-8759-7ec9-825c-cd81f4c68b33 | €15.00 | €0.26 | matched |
| 112 | refund | 01a14213-8796-784e-8a73-c3305546b344 | -€3.00 | €0.00 | matched |
| 113 | refund | 01a14213-a4e9-7a64-b367-7badcb68a5d0 | -€39.00 | €0.00 | matched |
| 114 | capture | 01a14213-a87f-7d1e-876e-9abdf8d06998 | €35.00 | €0.50 | matched |
| 115 | capture | 01a14213-cd5b-7fb2-af9e-cbc2cd55e3ce | €49.00 | €0.67 | matched |
| 116 | refund | 01a14213-d07a-731e-b3b5-37e186656c9d | -€10.00 | €0.00 | matched |
| 117 | capture | 01a14213-e15d-77d2-b890-cc5978d21b01 | €35.00 | €0.50 | matched |
| 118 | capture | 01a14214-0b32-7e0c-abe1-41e22e555fe4 | €24.00 | €0.37 | matched |
| 119 | capture | 01a14214-4842-787a-80af-906ede9b2438 | €49.00 | €0.67 | matched |
| 120 | capture | 01a14214-5125-768b-a278-6553a201bdd8 | €24.00 | €0.37 | matched |