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
- 6 Nov, 00:30112 lines2 breaks
- 6 Nov, 00:20147 lines3 breaks
- 6 Nov, 00:10118 lines4 breaks
- 6 Nov, 00:00158 lines3 breaks
- 5 Nov, 23:50126 lines4 breaks
- 5 Nov, 23:4097 lines3 breaks
- 5 Nov, 23:30109 lines3 breaks
- 5 Nov, 23:20106 lines3 breaks
- 5 Nov, 23:10122 lines4 breaks
- 5 Nov, 23:00100 lines2 breaks
- 5 Nov, 22:50122 lines6 breaks
- 5 Nov, 22:40121 lines5 breaks
- 5 Nov, 22:30130 lines3 breaks
- 5 Nov, 22:20120 lines2 breaks
5 Nov, 22:50
Gross
€2,863.00
PSP fee
€44.84
Net to the bank
€2,818.16
Settlement journal
#405512
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1ade9-b3b5-7280-843e-cef932f4e612 is already settled by stl_EUR_2989865 line 30
- duplicate linethe file lists it twicerefund:01a1adee-1148-70f8-ab08-3c5bb548eecb is already settled by stl_EUR_2989865 line 82
- duplicate linethe file lists it twicecapture:01a1adef-0d24-7042-b62b-737c6a57846b is already settled by stl_EUR_2989865 line 98
- fee differencethe fee is not the contract feethe fee is 55, the contract says 50
- missing linein the books, not in the filecapture:01a1adea-1393-7ee0-bdb3-60fe951f6f0c is in no file
- missing linein the books, not in the filerefund:01a1adee-03ed-7fd2-8544-4dde5bdad4a8 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 2 | capture | 01a1ade1-57a6-7189-8c1b-f32e77bcf708 | €24.00 | €0.37 | duplicate line |
| 6 | capture | 01a1ade7-03a0-7262-b724-74da14e26a4d | €24.00 | €0.37 | duplicate line |
| 23 | capture | 01a1ade8-92f6-760f-a0cd-d4f5c2cea54e | €35.00 | €0.55 | fee difference |
| 31 | capture | 01a1ade9-b3d9-749a-abbc-f071447e0386 | €24.00 | €0.37 | duplicate line |
| 83 | refund | 01a1adee-1152-784e-a64b-1bdc7fc06cb3 | -€13.00 | €0.00 | duplicate line |
| 99 | capture | 01a1adef-0d37-78bf-b011-b7f3c35d894b | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1ade1-57a6-7189-8c1b-f32e77bcf708 | €24.00 | €0.37 | matched |
| 3 | capture | 01a1ade4-bcbe-749a-bd29-737f11d18367 | €9.00 | €0.19 | matched |
| 4 | capture | 01a1ade5-7b23-7f54-bb80-dcf3f6edd94d | €35.00 | €0.50 | matched |
| 5 | capture | 01a1ade7-03a0-7262-b724-74da14e26a4d | €24.00 | €0.37 | matched |
| 7 | capture | 01a1ade7-bf37-7f63-b39c-bf0de90c0fe3 | €15.00 | €0.26 | matched |
| 8 | capture | 01a1ade7-cb68-7024-a2fc-f7b12462c331 | €24.00 | €0.37 | matched |
| 9 | capture | 01a1ade7-cf39-73a5-bfaa-c12a5e0194af | €35.00 | €0.50 | matched |
| 10 | capture | 01a1ade7-dbb6-7be7-a7b1-7884dc9735b8 | €9.00 | €0.19 | matched |
| 11 | capture | 01a1ade7-e8d5-73ff-bf78-a20b4d28a1c0 | €15.00 | €0.26 | matched |
| 12 | capture | 01a1ade7-ea01-79d7-b348-6688ecf152f6 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1ade8-075b-75c8-88dc-f39492fdcab2 | €49.00 | €0.67 | matched |
| 14 | capture | 01a1ade8-08db-75ac-8951-93060ca9020c | €9.00 | €0.19 | matched |
| 15 | capture | 01a1ade8-1e08-7b7e-968d-e4b418c412f2 | €24.00 | €0.37 | matched |
| 16 | capture | 01a1ade8-21ec-72cf-a084-6bd36c180e93 | €9.00 | €0.19 | matched |
| 17 | capture | 01a1ade8-2475-7cab-8ee5-d351559f60e5 | €15.00 | €0.26 | matched |
| 18 | capture | 01a1ade8-2f86-785b-bf00-82249ffbfa1a | €24.00 | €0.37 | matched |
| 19 | capture | 01a1ade8-3939-734d-9f3d-4c90ce7d1124 | €35.00 | €0.50 | matched |
| 20 | refund | 01a1ade8-6788-7c91-ba8c-15dc8008f8a7 | -€9.00 | €0.00 | matched |
| 21 | capture | 01a1ade8-7392-7f15-8e45-49fbe32c6e29 | €24.00 | €0.37 | matched |
| 22 | capture | 01a1ade8-797b-730c-ae9d-cf67c7fc820b | €24.00 | €0.37 | matched |
| 24 | capture | 01a1ade8-9394-7850-a34a-e4fc6cd4767a | €9.00 | €0.19 | matched |
| 25 | capture | 01a1ade9-0b0e-7564-b619-47c5dc0e359e | €49.00 | €0.67 | matched |
| 26 | capture | 01a1ade9-2a05-7d1a-8aa1-81c2a27b880e | €35.00 | €0.50 | matched |
| 27 | capture | 01a1ade9-393a-7fc6-a82e-ca644bb77439 | €9.00 | €0.19 | matched |
| 28 | capture | 01a1ade9-5c72-70a2-9aaf-a962bcfd91db | €15.00 | €0.26 | matched |
| 29 | capture | 01a1ade9-a106-70e2-b9ee-c3a859f49d8f | €9.00 | €0.19 | matched |
| 30 | capture | 01a1ade9-b3d9-749a-abbc-f071447e0386 | €24.00 | €0.37 | matched |
| 32 | capture | 01a1ade9-c183-7063-8a65-bc534c3e2291 | €35.00 | €0.50 | matched |
| 33 | capture | 01a1ade9-cc3d-7254-a70c-44088eec19a6 | €24.00 | €0.37 | matched |
| 34 | capture | 01a1ade9-d958-76b6-8e27-c2d3e0465210 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1ade9-e9e2-7792-8a93-b7f5e72da0f9 | €15.00 | €0.26 | matched |
| 36 | capture | 01a1ade9-ea0f-7da2-a27f-472e707eb47a | €49.00 | €0.67 | matched |
| 37 | capture | 01a1adea-0d65-7705-9d4c-ebdda455391b | €9.00 | €0.19 | matched |
| 38 | capture | 01a1adea-5475-7cdc-9594-19c393be8355 | €49.00 | €0.67 | matched |
| 39 | capture | 01a1adea-7328-7c91-a880-2ff55705b857 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1adea-a1cb-750e-9c16-2edddd821aea | €24.00 | €0.37 | matched |
| 41 | capture | 01a1adea-b17d-725a-811b-31b640b3ddc1 | €35.00 | €0.50 | matched |
| 42 | capture | 01a1adea-c489-79eb-84b5-cb95299c336f | €49.00 | €0.67 | matched |
| 43 | capture | 01a1adea-c9d1-7794-a6ad-5a226eb96eb7 | €15.00 | €0.26 | matched |
| 44 | capture | 01a1adea-d1c3-7f7a-8d35-7e006974b8b5 | €35.00 | €0.50 | matched |
| 45 | capture | 01a1adea-ea23-79d8-b81e-ec2ab5520669 | €9.00 | €0.19 | matched |
| 46 | capture | 01a1adeb-0171-7e10-8e3a-d22b3471a2bb | €15.00 | €0.26 | matched |
| 47 | capture | 01a1adeb-01fe-70aa-95ee-057fd0dc1bea | €35.00 | €0.50 | matched |
| 48 | refund | 01a1adeb-10a5-77ee-bdd7-44815a490cff | -€7.00 | €0.00 | matched |
| 49 | capture | 01a1adeb-695a-7c85-8977-64c44cd9e2ef | €49.00 | €0.67 | matched |
| 50 | capture | 01a1adeb-78c0-7f3e-b6a3-e4391a7d283d | €9.00 | €0.19 | matched |
| 51 | capture | 01a1adeb-7e43-7ab2-a34f-4b504ef82d49 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1adeb-8932-70df-bcb4-a4c2da30ea83 | €9.00 | €0.19 | matched |
| 53 | capture | 01a1adeb-95ca-7547-abb6-c75622a735aa | €35.00 | €0.50 | matched |
| 54 | capture | 01a1adeb-e298-7fa2-927c-4771f64264d8 | €15.00 | €0.26 | matched |
| 55 | capture | 01a1adeb-f41a-7ddb-80ee-33b88961f9c6 | €49.00 | €0.67 | matched |
| 56 | capture | 01a1adeb-fa6f-7c0b-826f-1488f0d19055 | €24.00 | €0.37 | matched |
| 57 | capture | 01a1adec-0c55-7d0b-bcff-0d3ab4203a09 | €15.00 | €0.26 | matched |
| 58 | refund | 01a1adec-3c8e-7e46-9faf-28e3ff4a8a94 | -€27.00 | €0.00 | matched |
| 59 | capture | 01a1adec-4d1b-7c86-8fdf-593f84050dcf | €9.00 | €0.19 | matched |
| 60 | capture | 01a1adec-7c19-7a70-b84d-d90a0b8fcaf9 | €9.00 | €0.19 | matched |
| 61 | capture | 01a1adec-7f6e-795e-87c6-8b302696b400 | €24.00 | €0.37 | matched |
| 62 | capture | 01a1adec-885b-75aa-a23b-719c74b9191c | €24.00 | €0.37 | matched |
| 63 | capture | 01a1adec-94d2-7508-acd1-25972e394c3a | €35.00 | €0.50 | matched |
| 64 | capture | 01a1adec-a498-70f9-abde-63c49fdb3ae9 | €9.00 | €0.19 | matched |
| 65 | capture | 01a1adec-c634-7b96-bfbe-11fe6bb9ea65 | €49.00 | €0.67 | matched |
| 66 | capture | 01a1adec-c6c4-71e7-afad-5738ed1769a4 | €35.00 | €0.50 | matched |
| 67 | capture | 01a1adec-d0d8-73cf-9cd6-1cfa1a8621e4 | €24.00 | €0.37 | matched |
| 68 | refund | 01a1adec-da06-7e5b-a0e6-cd91c97b0b23 | -€7.00 | €0.00 | matched |
| 69 | capture | 01a1adec-d83f-7917-9bd2-1d10e18e7db3 | €24.00 | €0.37 | matched |
| 70 | capture | 01a1adec-f15f-7153-a2d4-6de537c00f1b | €9.00 | €0.19 | matched |
| 71 | refund | 01a1adec-f3f0-7043-a2b6-b41877bf5042 | -€14.00 | €0.00 | matched |
| 72 | capture | 01a1aded-3d37-7584-94bb-b72ecf26926d | €24.00 | €0.37 | matched |
| 73 | capture | 01a1aded-4539-7208-8068-5843147cd6f6 | €35.00 | €0.50 | matched |
| 74 | capture | 01a1aded-5851-74a8-adcd-12376ef1feeb | €9.00 | €0.19 | matched |
| 75 | capture | 01a1aded-7870-7ff1-87d2-1c5b034ff95b | €35.00 | €0.50 | matched |
| 76 | capture | 01a1aded-9a21-74c3-9352-2f36268c936c | €15.00 | €0.26 | matched |
| 77 | refund | 01a1aded-a5bd-7fc2-ba9d-10d44cf994bd | -€8.00 | €0.00 | matched |
| 78 | capture | 01a1aded-c9b1-7f4b-aabc-574ac672e315 | €24.00 | €0.37 | matched |
| 79 | capture | 01a1aded-d9ee-794e-b6a1-8d3bd0a52979 | €9.00 | €0.19 | matched |
| 80 | refund | 01a1aded-de3d-7a24-be67-9c6ebe03839e | -€10.00 | €0.00 | matched |
| 81 | capture | 01a1aded-f180-7141-b6b1-223edbe8708b | €15.00 | €0.26 | matched |
| 82 | refund | 01a1adee-1152-784e-a64b-1bdc7fc06cb3 | -€13.00 | €0.00 | matched |
| 84 | capture | 01a1adee-5833-7203-8b95-b2d8692b3563 | €35.00 | €0.50 | matched |
| 85 | capture | 01a1adee-5eed-7c62-a54f-828603f5585a | €9.00 | €0.19 | matched |
| 86 | capture | 01a1adee-6a7c-792c-b562-29ba4a49a658 | €49.00 | €0.67 | matched |
| 87 | capture | 01a1adee-722e-7808-981c-472bd6be0dfa | €15.00 | €0.26 | matched |
| 88 | capture | 01a1adee-837f-77df-80b7-07f4cc6674d7 | €49.00 | €0.67 | matched |
| 89 | capture | 01a1adee-906d-7921-8f5d-ffdb6e3e124d | €24.00 | €0.37 | matched |
| 90 | capture | 01a1adee-919c-7443-a02d-6070239f5006 | €49.00 | €0.67 | matched |
| 91 | capture | 01a1adee-a2c6-7819-9a3f-2f8a3d108b8e | €9.00 | €0.19 | matched |
| 92 | capture | 01a1adee-bd83-7a20-8f20-fb4b046fabf8 | €35.00 | €0.50 | matched |
| 93 | capture | 01a1adee-cc97-7ec6-bed7-d9c88b24f005 | €24.00 | €0.37 | matched |
| 94 | capture | 01a1adee-f942-7d56-9469-0e9b2b964899 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1adee-ff41-7c58-95ef-5c31ec6945f9 | €49.00 | €0.67 | matched |
| 96 | capture | 01a1adef-0042-7741-9cf0-a15b932b8ac2 | €9.00 | €0.19 | matched |
| 97 | capture | 01a1adef-026a-761e-bff3-79b1a573e6d5 | €24.00 | €0.37 | matched |
| 98 | capture | 01a1adef-0d37-78bf-b011-b7f3c35d894b | €49.00 | €0.67 | matched |
| 100 | capture | 01a1adef-0f64-78e8-a425-552ccb80b7e8 | €9.00 | €0.19 | matched |
| 101 | capture | 01a1adef-1633-790f-b23f-73c121a9a62e | €49.00 | €0.67 | matched |
| 102 | refund | 01a1adef-56fe-78f0-86de-fabbaeebd778 | -€3.00 | €0.00 | matched |
| 103 | capture | 01a1adef-9173-71e5-8fc6-360b708452a0 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1adef-929a-70b8-87ee-c186d3743d3b | €15.00 | €0.26 | matched |
| 105 | capture | 01a1adef-a92d-7469-b01c-74531acedd80 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1adef-b1fd-7ff8-9ea7-690e304fd2ad | €35.00 | €0.50 | matched |
| 107 | capture | 01a1adef-b2db-7558-bd82-222d1157e0d9 | €35.00 | €0.50 | matched |
| 108 | capture | 01a1adef-b43c-7eba-9bb1-8bd037a7c1e9 | €35.00 | €0.50 | matched |
| 109 | capture | 01a1adef-b97b-7f13-85c2-ba8f32e0e0a3 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1adef-d212-78af-a5d1-f916be7aae17 | €49.00 | €0.67 | matched |
| 111 | capture | 01a1adf0-2f65-70b8-af80-687d3c61c1f7 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1adf0-44a2-7ee2-9b8d-c27dc7fe8330 | €15.00 | €0.26 | matched |
| 113 | capture | 01a1adf0-524b-7b18-8a74-724b000d998a | €35.00 | €0.50 | matched |
| 114 | capture | 01a1adf0-5979-76b3-aee0-3155ed7b7351 | €49.00 | €0.67 | matched |
| 115 | capture | 01a1adf0-5f77-7c45-854f-5c69f6989c44 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1adf0-7a89-74ee-bfd4-43ee95d0c531 | €24.00 | €0.37 | matched |
| 117 | capture | 01a1adf0-910d-7296-95e0-e675bec92cd2 | €9.00 | €0.19 | matched |
| 118 | capture | 01a1adf0-99f6-7466-9522-0f8ab4964ec0 | €24.00 | €0.37 | matched |
| 119 | capture | 01a1adf0-a995-7da3-bd66-75a7f6341516 | €49.00 | €0.67 | matched |
| 120 | capture | 01a1adf0-acec-7511-9138-38cf390afdfe | €49.00 | €0.67 | matched |
| 121 | capture | 01a1adf0-b0eb-7114-b383-481b98801335 | €49.00 | €0.67 | matched |
| 122 | capture | 01a1adf0-b433-7932-9410-7750a273d3f5 | €15.00 | €0.26 | matched |