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
- 25 Oct, 14:30128 lines2 breaks
- 25 Oct, 14:20106 linesclean
- 25 Oct, 14:10117 lines1 break
- 25 Oct, 14:00113 lines4 breaks
- 25 Oct, 13:50119 lines5 breaks
- 25 Oct, 13:40109 lines1 break
- 25 Oct, 13:30113 lines3 breaks
- 25 Oct, 13:20120 lines4 breaks
- 25 Oct, 13:10106 lines3 breaks
- 25 Oct, 13:00126 lines2 breaks
- 25 Oct, 12:50118 lines5 breaks
- 25 Oct, 12:40121 lines3 breaks
- 25 Oct, 12:30122 lines3 breaks
- 25 Oct, 12:20116 linesclean
25 Oct, 13:30
Gross
€2,739.00
PSP fee
€42.95
Net to the bank
€2,696.05
Settlement journal
#197548
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17347-a37c-7323-bc29-70a8d584b4c6 is already settled by stl_EUR_2988225 line 74
- fee differencethe fee is not the contract feethe fee is 55, the contract says 50
- missing linein the books, not in the filecapture:01a17341-2e52-799f-a1d9-ac4712b00897 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 22 | capture | 01a17342-7ed3-718a-a2f0-2b2794596c00 | €35.00 | €0.55 | fee difference |
| 75 | capture | 01a17347-ac48-771b-bb47-1d53ce20c328 | €35.00 | €0.50 | duplicate line |
| 1 | refund | 01a17338-b856-7999-83a1-ddefd748280c | -€23.00 | €0.00 | matched |
| 2 | capture | 01a1733a-305e-7be9-ab5e-d8d5093fb541 | €24.00 | €0.37 | matched |
| 3 | capture | 01a17341-1652-7181-9e08-b81def7a0a5d | €24.00 | €0.37 | matched |
| 4 | capture | 01a17341-554d-73fa-88a8-131bf08b4c9e | €49.00 | €0.67 | matched |
| 5 | capture | 01a17341-6587-7dea-b75f-31a0795afd54 | €9.00 | €0.19 | matched |
| 6 | capture | 01a17341-65c0-734e-8817-8a0df1090418 | €9.00 | €0.19 | matched |
| 7 | capture | 01a17341-672f-74c7-b71e-fe0d20beb5c7 | €35.00 | €0.50 | matched |
| 8 | capture | 01a17341-6f19-7353-a8ed-7f4b6e27bcd9 | €49.00 | €0.67 | matched |
| 9 | capture | 01a17341-8200-7ece-bcb7-90ac22503089 | €35.00 | €0.50 | matched |
| 10 | capture | 01a17341-86c3-7545-bc83-85bcddd8cd98 | €35.00 | €0.50 | matched |
| 11 | capture | 01a17341-91b6-7cf1-bf5c-b74c6e7db1ff | €9.00 | €0.19 | matched |
| 12 | capture | 01a17341-91cd-7daf-afe2-0915ea874156 | €24.00 | €0.37 | matched |
| 13 | capture | 01a17341-af87-7bea-a98f-13466d3b8d8f | €9.00 | €0.19 | matched |
| 14 | capture | 01a17341-e099-7714-8856-fee763796aed | €49.00 | €0.67 | matched |
| 15 | capture | 01a17341-f44a-7514-9bfb-c02ec3caeb38 | €35.00 | €0.50 | matched |
| 16 | capture | 01a17341-f4e2-7017-9639-db7b1cd343e3 | €15.00 | €0.26 | matched |
| 17 | capture | 01a17341-fc9f-7539-a53c-64b888288c60 | €9.00 | €0.19 | matched |
| 18 | capture | 01a17342-03d4-7a9e-83ba-3c6afb232c51 | €15.00 | €0.26 | matched |
| 19 | capture | 01a17342-39cb-7859-96f3-464c99ae8ee8 | €49.00 | €0.67 | matched |
| 20 | capture | 01a17342-687f-7437-b9e9-cb97a6e49cd4 | €49.00 | €0.67 | matched |
| 21 | capture | 01a17342-73f6-7f6e-9f5f-9f66cd3c6b6b | €24.00 | €0.37 | matched |
| 23 | capture | 01a17342-9312-78fb-a81c-2efb40e718b7 | €24.00 | €0.37 | matched |
| 24 | capture | 01a17342-c67a-7aab-b72d-a331c7b29c9a | €24.00 | €0.37 | matched |
| 25 | capture | 01a17342-d084-7d64-9609-2ac0f242903c | €49.00 | €0.67 | matched |
| 26 | capture | 01a17342-dea7-7dc7-bed0-60cf104edfac | €49.00 | €0.67 | matched |
| 27 | capture | 01a17343-034c-7520-8804-f13b3055e5ff | €49.00 | €0.67 | matched |
| 28 | capture | 01a17343-231f-77a4-bc92-5bfd8280102e | €9.00 | €0.19 | matched |
| 29 | capture | 01a17343-494c-7702-9df8-fcd4d0481261 | €24.00 | €0.37 | matched |
| 30 | capture | 01a17343-52e7-7d2b-85a9-e3daed61fdd1 | €49.00 | €0.67 | matched |
| 31 | capture | 01a17343-5eec-7f29-a704-8133307358a1 | €15.00 | €0.26 | matched |
| 32 | capture | 01a17343-8373-7167-b86e-345558bb4b77 | €15.00 | €0.26 | matched |
| 33 | capture | 01a17343-8761-7979-8932-3dc3ab6e3b4e | €35.00 | €0.50 | matched |
| 34 | capture | 01a17343-8d6d-7614-84ea-8eb12325ae85 | €15.00 | €0.26 | matched |
| 35 | capture | 01a17343-a660-74b3-8dbc-bafd2d145015 | €49.00 | €0.67 | matched |
| 36 | capture | 01a17343-a6f5-70e7-bad3-29ca83524c77 | €24.00 | €0.37 | matched |
| 37 | capture | 01a17343-c2b8-762d-b045-ab671955a2a1 | €35.00 | €0.50 | matched |
| 38 | refund | 01a17343-dab9-7185-8c0c-291978f6ebd5 | -€14.00 | €0.00 | matched |
| 39 | refund | 01a17343-e408-7946-bbba-9a7ac716aa8f | -€6.00 | €0.00 | matched |
| 40 | capture | 01a17344-06a6-78bd-a713-eccba0c4cf6d | €49.00 | €0.67 | matched |
| 41 | capture | 01a17344-2097-7941-8045-17505cb4293f | €9.00 | €0.19 | matched |
| 42 | capture | 01a17344-2353-7d8a-9990-7033392d897b | €9.00 | €0.19 | matched |
| 43 | capture | 01a17344-8ca3-7aae-a337-83ab6a542c39 | €24.00 | €0.37 | matched |
| 44 | capture | 01a17344-e224-7fb3-80d7-33c8ab588ca4 | €49.00 | €0.67 | matched |
| 45 | capture | 01a17344-e921-7926-9532-028daea5dde8 | €35.00 | €0.50 | matched |
| 46 | capture | 01a17345-4765-79d5-ac8a-1e9aec2c1a20 | €15.00 | €0.26 | matched |
| 47 | capture | 01a17345-5edb-721f-a98c-361504c71577 | €15.00 | €0.26 | matched |
| 48 | capture | 01a17345-84da-7892-87c3-c84be70cf771 | €35.00 | €0.50 | matched |
| 49 | capture | 01a17345-a12e-736f-9c7b-6fa1268e6249 | €24.00 | €0.37 | matched |
| 50 | capture | 01a17345-acd7-7852-a433-3aeb9932293c | €24.00 | €0.37 | matched |
| 51 | capture | 01a17345-b082-7f2c-847c-54739e230295 | €15.00 | €0.26 | matched |
| 52 | capture | 01a17345-cccf-7054-8a5c-53d403a24c42 | €15.00 | €0.26 | matched |
| 53 | capture | 01a17345-de93-7f76-b368-90da5b502899 | €35.00 | €0.50 | matched |
| 54 | capture | 01a17345-dd59-7063-916c-c49ef9126cd5 | €49.00 | €0.67 | matched |
| 55 | capture | 01a17345-f1e4-7e21-b003-8675577ee6a4 | €15.00 | €0.26 | matched |
| 56 | capture | 01a17346-173e-786f-ac60-39df41dacb8e | €9.00 | €0.19 | matched |
| 57 | refund | 01a17346-26c9-702a-a860-3d1139afe6b4 | -€11.00 | €0.00 | matched |
| 58 | capture | 01a17346-2a13-7fed-920d-e41d91dff541 | €24.00 | €0.37 | matched |
| 59 | capture | 01a17346-2dc7-7668-aa97-9f28493b112c | €35.00 | €0.50 | matched |
| 60 | capture | 01a17346-550d-7473-97e9-aee7106646c9 | €35.00 | €0.50 | matched |
| 61 | capture | 01a17346-6076-7a9b-a5a0-f4eedcd7f4c1 | €24.00 | €0.37 | matched |
| 62 | capture | 01a17346-83ae-79f7-a229-1e704b68dd7e | €35.00 | €0.50 | matched |
| 63 | capture | 01a17346-bccd-7660-8cf4-b0131d075381 | €9.00 | €0.19 | matched |
| 64 | capture | 01a17346-cb7f-7fef-ad2f-c8d014f223ea | €35.00 | €0.50 | matched |
| 65 | capture | 01a17346-e3ee-719a-bad5-31f2a8984273 | €35.00 | €0.50 | matched |
| 66 | refund | 01a17347-02c0-7bfa-bce3-8bb01617d016 | -€35.00 | €0.00 | matched |
| 67 | capture | 01a17347-10d0-775a-a7df-e3773cb276a5 | €24.00 | €0.37 | matched |
| 68 | capture | 01a17347-506a-711d-ae22-19c66df8b590 | €24.00 | €0.37 | matched |
| 69 | capture | 01a17347-6ee9-716a-898a-c2d71d05bb84 | €9.00 | €0.19 | matched |
| 70 | capture | 01a17347-6df9-7fab-94e0-bc22cad8e169 | €9.00 | €0.19 | matched |
| 71 | capture | 01a17347-6ff3-7600-95ba-f52ccb923e00 | €35.00 | €0.50 | matched |
| 72 | capture | 01a17347-7eb3-7481-b659-fe82ea4c70f7 | €9.00 | €0.19 | matched |
| 73 | capture | 01a17347-8006-7350-8f0c-5b9a9750e78d | €49.00 | €0.67 | matched |
| 74 | capture | 01a17347-ac48-771b-bb47-1d53ce20c328 | €35.00 | €0.50 | matched |
| 76 | capture | 01a17347-da01-7f19-9dd6-9009fd8daca1 | €15.00 | €0.26 | matched |
| 77 | capture | 01a17347-db27-7b79-b67c-6acb7c8169f7 | €35.00 | €0.50 | matched |
| 78 | capture | 01a17347-ecea-76a5-aee2-73f441f83f4a | €49.00 | €0.67 | matched |
| 79 | capture | 01a17348-18b9-7662-b128-da9285ff3f1d | €35.00 | €0.50 | matched |
| 80 | capture | 01a17348-33e4-7774-9d3d-5b8cf820b481 | €9.00 | €0.19 | matched |
| 81 | capture | 01a17348-3518-7ea9-a605-eea42333618d | €49.00 | €0.67 | matched |
| 82 | capture | 01a17348-3964-76c1-9b3d-8d1b1e64d89e | €15.00 | €0.26 | matched |
| 83 | capture | 01a17348-40be-78ea-8325-048a50aeefb0 | €24.00 | €0.37 | matched |
| 84 | capture | 01a17348-47b9-79b5-b3a4-9d0df32b4068 | €9.00 | €0.19 | matched |
| 85 | capture | 01a17348-5170-7068-abb9-e5083d227cbb | €35.00 | €0.50 | matched |
| 86 | capture | 01a17348-6239-7d14-b9c6-aa1354c3d105 | €35.00 | €0.50 | matched |
| 87 | capture | 01a17348-711e-776c-ba6b-27b779b969c5 | €9.00 | €0.19 | matched |
| 88 | capture | 01a17348-7c66-75c2-8f34-ae4d0bdbaff6 | €24.00 | €0.37 | matched |
| 89 | capture | 01a17348-83c0-7836-b033-0adcfa19fdca | €24.00 | €0.37 | matched |
| 90 | capture | 01a17348-8b69-764f-97d5-cef5f4b45cf9 | €15.00 | €0.26 | matched |
| 91 | capture | 01a17348-8d71-780c-898a-16cdc26abd32 | €49.00 | €0.67 | matched |
| 92 | capture | 01a17348-9fbf-7071-a167-2bcab61c6be0 | €9.00 | €0.19 | matched |
| 93 | capture | 01a17348-a474-7705-a507-1e80e45916d9 | €24.00 | €0.37 | matched |
| 94 | capture | 01a17348-a56d-7d98-b946-ba17d04e45af | €24.00 | €0.37 | matched |
| 95 | refund | 01a17348-ceaf-750c-a9d5-915c0ac185b2 | -€9.00 | €0.00 | matched |
| 96 | refund | 01a17348-fabe-7496-9429-6cde82693b07 | -€19.00 | €0.00 | matched |
| 97 | capture | 01a17348-ffc5-734d-99e6-2fba752fd364 | €15.00 | €0.26 | matched |
| 98 | capture | 01a17349-2ad9-7c7f-9e6d-e2ef38991069 | €24.00 | €0.37 | matched |
| 99 | capture | 01a17349-402a-7edc-9308-236818e578f2 | €24.00 | €0.37 | matched |
| 100 | capture | 01a17349-8081-7f1e-8817-0e75e06f5848 | €35.00 | €0.50 | matched |
| 101 | capture | 01a17349-81d5-7873-ad25-028f5a9ba0b2 | €49.00 | €0.67 | matched |
| 102 | capture | 01a17349-8cd2-7da8-8cd3-aaf4ec9d2c70 | €9.00 | €0.19 | matched |
| 103 | capture | 01a17349-91cb-7b6b-ae7a-3f25055a6435 | €24.00 | €0.37 | matched |
| 104 | capture | 01a17349-931a-7eea-b906-696cb2cb14d2 | €49.00 | €0.67 | matched |
| 105 | capture | 01a17349-a83b-70fb-bfe1-77f52cc148cd | €9.00 | €0.19 | matched |
| 106 | capture | 01a17349-b2e8-7d67-9071-d1f856cca052 | €35.00 | €0.50 | matched |
| 107 | refund | 01a17349-d7a0-74c8-9699-d2778c36beea | -€8.00 | €0.00 | matched |
| 108 | capture | 01a17349-db0e-784a-9145-3ba91599b100 | €49.00 | €0.67 | matched |
| 109 | capture | 01a17349-ea08-79db-a660-0eabe73f4134 | €9.00 | €0.19 | matched |
| 110 | capture | 01a17349-eb71-7cd8-939c-fd9cb535f9fd | €49.00 | €0.67 | matched |
| 111 | capture | 01a17349-ef7c-7aaa-a1e2-078d0a3551b3 | €9.00 | €0.19 | matched |
| 112 | capture | 01a1734a-05e4-7236-a02a-abe4fc1235fc | €35.00 | €0.50 | matched |
| 113 | capture | 01a1734a-05ef-7fb2-9358-dd516132ba06 | €9.00 | €0.19 | matched |