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
- 14 Oct, 20:20105 lines1 break
- 14 Oct, 20:10122 lines1 break
- 14 Oct, 20:00119 lines1 break
- 14 Oct, 19:50128 lines2 breaks
- 14 Oct, 19:40134 linesclean
- 14 Oct, 19:30133 lines1 break
- 14 Oct, 19:20107 lines1 break
- 14 Oct, 19:10124 lines6 breaks
- 14 Oct, 19:00124 lines3 breaks
- 14 Oct, 18:50115 lines1 break
- 14 Oct, 18:40117 lines5 breaks
- 14 Oct, 18:30125 lines3 breaks
- 14 Oct, 18:20125 lines4 breaks
- 14 Oct, 18:10124 lines2 breaks
14 Oct, 19:00
Gross
€2,869.00
PSP fee
€45.05
Net to the bank
€2,823.95
Settlement journal
#1277
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13bcd-4ce9-73d2-b861-5232166ae84f is already settled by stl_EUR_2986674 line 54
- duplicate linethe file lists it twicecapture:01a13bcd-d070-72a0-9b56-2a98bfa93fca is already settled by stl_EUR_2986674 line 60
- fee differencethe fee is not the contract feethe fee is 52, the contract says 50
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 55 | capture | 01a13bcd-4d55-71ca-90b7-f8becf6842b2 | €24.00 | €0.37 | duplicate line |
| 61 | capture | 01a13bcd-d2f1-7fa3-8571-87661a037ef3 | €15.00 | €0.26 | duplicate line |
| 90 | capture | 01a13bcf-e38f-7715-97ee-9a1be362f385 | €35.00 | €0.52 | fee difference |
| 1 | capture | 01a13bc8-a496-76eb-b4a0-f352a217ac78 | €24.00 | €0.37 | matched |
| 2 | refund | 01a13bc9-4d5f-7450-a92f-92f75ddb6ad0 | -€26.00 | €0.00 | matched |
| 3 | capture | 01a13bc9-4dfd-754c-b61c-9aa45fd844dd | €9.00 | €0.19 | matched |
| 4 | capture | 01a13bc9-62a0-7115-9a24-0506440efb78 | €35.00 | €0.50 | matched |
| 5 | capture | 01a13bc9-9541-7035-b4bc-aefd6a80a095 | €24.00 | €0.37 | matched |
| 6 | capture | 01a13bc9-9d3e-7ae9-9b0f-c1b5a647d874 | €15.00 | €0.26 | matched |
| 7 | capture | 01a13bc9-a7c5-72d8-9642-7a0c6b55e7a2 | €49.00 | €0.67 | matched |
| 8 | capture | 01a13bc9-b975-7dc2-b59c-f527406de9cc | €15.00 | €0.26 | matched |
| 9 | capture | 01a13bc9-d18c-76ad-81e4-2c0eebc97c68 | €24.00 | €0.37 | matched |
| 10 | capture | 01a13bc9-d1cd-714c-bf13-d9ef17286d6f | €49.00 | €0.67 | matched |
| 11 | capture | 01a13bc9-d227-7bc0-ad5e-e387611a0b5d | €49.00 | €0.67 | matched |
| 12 | capture | 01a13bc9-dcf8-762e-842c-bc01d161209a | €24.00 | €0.37 | matched |
| 13 | capture | 01a13bc9-e48a-7c08-827e-f01550575293 | €35.00 | €0.50 | matched |
| 14 | capture | 01a13bc9-de2e-7b83-9270-9b9d460132b9 | €9.00 | €0.19 | matched |
| 15 | capture | 01a13bc9-f07c-7b9c-8350-34110070795a | €24.00 | €0.37 | matched |
| 16 | capture | 01a13bca-091a-7b89-a5b6-f46645748b42 | €35.00 | €0.50 | matched |
| 17 | refund | 01a13bca-1fd8-7098-bda9-f5a7a55c3b95 | -€9.00 | €0.00 | matched |
| 18 | capture | 01a13bca-5d98-774a-86e6-de19b076e672 | €9.00 | €0.19 | matched |
| 19 | capture | 01a13bca-629d-7c9e-8dbd-bffc9f1a85f2 | €9.00 | €0.19 | matched |
| 20 | capture | 01a13bca-6329-7b34-81a4-d79c09e3a10a | €24.00 | €0.37 | matched |
| 21 | capture | 01a13bca-7112-7e32-9063-66b964010e7a | €9.00 | €0.19 | matched |
| 22 | capture | 01a13bca-91a6-7951-994f-d5dcd46026d2 | €15.00 | €0.26 | matched |
| 23 | capture | 01a13bca-95a3-79d2-9be2-3f43858f64a7 | €49.00 | €0.67 | matched |
| 24 | capture | 01a13bca-c102-703b-a5ad-7446a125caf9 | €24.00 | €0.37 | matched |
| 25 | capture | 01a13bca-e6cb-7bdd-82f9-8bef8967273a | €9.00 | €0.19 | matched |
| 26 | capture | 01a13bca-ebcd-7fd8-a273-74d6e6139d56 | €49.00 | €0.67 | matched |
| 27 | capture | 01a13bcb-0d57-740d-be11-60b440dc8eff | €49.00 | €0.67 | matched |
| 28 | refund | 01a13bcb-152f-724e-9239-5d4d2aecbcf1 | -€7.00 | €0.00 | matched |
| 29 | capture | 01a13bcb-157c-7202-887c-a06a8ef6a440 | €35.00 | €0.50 | matched |
| 30 | capture | 01a13bcb-1c85-7d38-8d6c-c65627dc5c8b | €9.00 | €0.19 | matched |
| 31 | capture | 01a13bcb-1e25-7db1-9045-17af577debc7 | €24.00 | €0.37 | matched |
| 32 | capture | 01a13bcb-1efd-7cf2-88e6-8972f79a6a65 | €9.00 | €0.19 | matched |
| 33 | capture | 01a13bcb-2460-7790-b86a-74ebbbd333c4 | €35.00 | €0.50 | matched |
| 34 | capture | 01a13bcb-2b7d-773f-8eb7-fd46d72ff0f0 | €49.00 | €0.67 | matched |
| 35 | capture | 01a13bcb-3099-73c9-8375-73bf51c01ace | €35.00 | €0.50 | matched |
| 36 | capture | 01a13bcb-5ee2-7fec-b7a0-a26672720fac | €9.00 | €0.19 | matched |
| 37 | capture | 01a13bcb-8f08-7444-87d8-7816dda7d725 | €9.00 | €0.19 | matched |
| 38 | capture | 01a13bcb-b21a-78c7-a58f-380c8616057d | €35.00 | €0.50 | matched |
| 39 | capture | 01a13bcb-d060-7fa0-904b-d827b716ed34 | €49.00 | €0.67 | matched |
| 40 | capture | 01a13bcb-d864-7675-a664-3ed2f13eb037 | €35.00 | €0.50 | matched |
| 41 | capture | 01a13bcb-dfd4-7cc5-a9ed-fb99491c694e | €9.00 | €0.19 | matched |
| 42 | capture | 01a13bcb-e384-78a9-821d-dce5c5f73e1e | €24.00 | €0.37 | matched |
| 43 | capture | 01a13bcb-fddb-7cd1-b82f-e2589d753e8a | €9.00 | €0.19 | matched |
| 44 | capture | 01a13bcc-3555-785b-b178-8f524a97c170 | €35.00 | €0.50 | matched |
| 45 | capture | 01a13bcc-38f5-757c-afb9-5095a2a969a7 | €24.00 | €0.37 | matched |
| 46 | capture | 01a13bcc-40e4-7cd9-88ab-c8275749045f | €15.00 | €0.26 | matched |
| 47 | capture | 01a13bcc-434f-778f-8060-009e6f8c5644 | €9.00 | €0.19 | matched |
| 48 | capture | 01a13bcc-8496-7aef-82a1-95544e660ca1 | €35.00 | €0.50 | matched |
| 49 | capture | 01a13bcc-a051-7414-bb4f-cf0d50d2fbda | €15.00 | €0.26 | matched |
| 50 | capture | 01a13bcc-b167-7d32-9f4f-7a8f5e489bfa | €35.00 | €0.50 | matched |
| 51 | capture | 01a13bcc-ece3-734a-b857-0153de14b422 | €24.00 | €0.37 | matched |
| 52 | capture | 01a13bcd-115c-785a-8e2c-af28ec90796a | €24.00 | €0.37 | matched |
| 53 | capture | 01a13bcd-17b4-74c6-88b2-008cddda703e | €49.00 | €0.67 | matched |
| 54 | capture | 01a13bcd-4d55-71ca-90b7-f8becf6842b2 | €24.00 | €0.37 | matched |
| 56 | capture | 01a13bcd-56c0-755f-96cd-15b949e87a42 | €15.00 | €0.26 | matched |
| 57 | capture | 01a13bcd-5c95-7c84-85e1-2fb7d2c5ea46 | €49.00 | €0.67 | matched |
| 58 | capture | 01a13bcd-7841-752b-a702-dbf503d8a5b0 | €15.00 | €0.26 | matched |
| 59 | capture | 01a13bcd-b4ce-7b70-979f-e5358d3b2edb | €9.00 | €0.19 | matched |
| 60 | capture | 01a13bcd-d2f1-7fa3-8571-87661a037ef3 | €15.00 | €0.26 | matched |
| 62 | capture | 01a13bcd-dada-7561-9a87-e6a828b6da43 | €35.00 | €0.50 | matched |
| 63 | capture | 01a13bcd-ebec-72e7-830e-41f530c5d470 | €9.00 | €0.19 | matched |
| 64 | capture | 01a13bce-168c-711e-b416-63b37041f43a | €49.00 | €0.67 | matched |
| 65 | capture | 01a13bce-3a37-7515-8082-d67f1cbbda55 | €9.00 | €0.19 | matched |
| 66 | capture | 01a13bce-421c-7692-aa41-4b397499d39e | €24.00 | €0.37 | matched |
| 67 | capture | 01a13bce-43f2-7e97-a62a-da21fe48f0d1 | €35.00 | €0.50 | matched |
| 68 | capture | 01a13bce-59c6-71e6-9c75-2ccbe1b9bb45 | €35.00 | €0.50 | matched |
| 69 | capture | 01a13bce-5ed2-7ede-8f4c-e7d504bcfdf7 | €35.00 | €0.50 | matched |
| 70 | capture | 01a13bce-61f0-7f63-be0f-c8a4e07b4427 | €24.00 | €0.37 | matched |
| 71 | capture | 01a13bce-6447-7738-92d9-a8a3560ec017 | €9.00 | €0.19 | matched |
| 72 | capture | 01a13bce-859a-744c-b1e3-6d7cba6c730a | €35.00 | €0.50 | matched |
| 73 | capture | 01a13bce-9c25-7d97-bb33-68a0aef0a7d6 | €49.00 | €0.67 | matched |
| 74 | capture | 01a13bce-a04f-799e-8788-55230af29d73 | €9.00 | €0.19 | matched |
| 75 | capture | 01a13bce-c2bf-7d14-a6a0-b807e103732b | €35.00 | €0.50 | matched |
| 76 | capture | 01a13bcf-0a32-720f-a3f6-97bf724d8f8c | €35.00 | €0.50 | matched |
| 77 | capture | 01a13bcf-0eb0-7651-8d81-88b3d6148e26 | €24.00 | €0.37 | matched |
| 78 | capture | 01a13bcf-1a11-72aa-b149-a522cbed955c | €24.00 | €0.37 | matched |
| 79 | capture | 01a13bcf-27d0-7bbb-8aa9-ab4de8f42ba0 | €35.00 | €0.50 | matched |
| 80 | capture | 01a13bcf-3b7a-7cdb-ac56-a722c538e62b | €49.00 | €0.67 | matched |
| 81 | capture | 01a13bcf-3d13-7cd3-8806-e0350a872520 | €49.00 | €0.67 | matched |
| 82 | capture | 01a13bcf-3c81-7cd0-9d14-8cfbc919886c | €9.00 | €0.19 | matched |
| 83 | capture | 01a13bcf-42dc-7028-98a0-3fd244c85ab2 | €9.00 | €0.19 | matched |
| 84 | capture | 01a13bcf-7ebd-703b-8e16-f39960760155 | €35.00 | €0.50 | matched |
| 85 | refund | 01a13bcf-87c9-71e1-b7f1-a82a041ccc08 | -€12.00 | €0.00 | matched |
| 86 | capture | 01a13bcf-a9ed-7dd9-9884-ef9cd9a83d11 | €24.00 | €0.37 | matched |
| 87 | capture | 01a13bcf-b081-776f-8581-5c34ca19817b | €15.00 | €0.26 | matched |
| 88 | capture | 01a13bcf-b9b9-7d2c-9a65-316fb9616908 | €49.00 | €0.67 | matched |
| 89 | capture | 01a13bcf-d46c-7e37-932d-d345b78fb9dc | €15.00 | €0.26 | matched |
| 91 | capture | 01a13bcf-fe63-7c36-b79b-8534b3f0a0f3 | €24.00 | €0.37 | matched |
| 92 | capture | 01a13bd0-1747-79b8-9ddb-62c883af378d | €24.00 | €0.37 | matched |
| 93 | capture | 01a13bd0-18df-72c2-b1be-094697267d96 | €35.00 | €0.50 | matched |
| 94 | capture | 01a13bd0-209e-7908-9ca2-6dc4660a95e2 | €15.00 | €0.26 | matched |
| 95 | capture | 01a13bd0-23a6-7fbd-a80b-9c28523b6133 | €35.00 | €0.50 | matched |
| 96 | capture | 01a13bd0-482a-7ea7-8d87-c119eceef123 | €49.00 | €0.67 | matched |
| 97 | capture | 01a13bd0-4ae6-7c14-bd22-3c641902c4e1 | €49.00 | €0.67 | matched |
| 98 | capture | 01a13bd0-4fe2-7495-a14e-243a67cb238a | €9.00 | €0.19 | matched |
| 99 | refund | 01a13bd0-56de-712a-b6c9-0e20ee68eea4 | -€6.00 | €0.00 | matched |
| 100 | refund | 01a13bd0-5b8d-77a0-9364-19a76f4b90a4 | -€25.00 | €0.00 | matched |
| 101 | capture | 01a13bd0-87ec-73dc-b88e-3417f494afbb | €9.00 | €0.19 | matched |
| 102 | capture | 01a13bd0-a250-7789-a807-5efaa465224d | €35.00 | €0.50 | matched |
| 103 | capture | 01a13bd0-a947-75b5-a5a3-725a2d244bdd | €15.00 | €0.26 | matched |
| 104 | capture | 01a13bd0-b6eb-7d9b-82fd-68298bd88694 | €15.00 | €0.26 | matched |
| 105 | capture | 01a13bd0-bef4-7b19-b1a4-c028dc09a89c | €15.00 | €0.26 | matched |
| 106 | capture | 01a13bd0-d99b-7167-93e5-19356ed10ee5 | €15.00 | €0.26 | matched |
| 107 | capture | 01a13bd0-d99e-7e6a-beda-737cc30e193d | €35.00 | €0.50 | matched |
| 108 | capture | 01a13bd0-dec4-7c58-b41f-908c17687599 | €15.00 | €0.26 | matched |
| 109 | refund | 01a13bd1-1769-71f4-bdf4-e887f617fa6a | -€11.00 | €0.00 | matched |
| 110 | capture | 01a13bd1-5d2a-7041-834d-ddd34bcada97 | €35.00 | €0.50 | matched |
| 111 | capture | 01a13bd1-7792-7b2b-8d95-e346176e7421 | €9.00 | €0.19 | matched |
| 112 | capture | 01a13bd1-779f-7324-be73-3eb82122ce25 | €9.00 | €0.19 | matched |
| 113 | capture | 01a13bd1-8185-7473-9803-378ba3d73e9b | €49.00 | €0.67 | matched |
| 114 | capture | 01a13bd1-818b-7696-8006-cf94e81b758b | €9.00 | €0.19 | matched |
| 115 | capture | 01a13bd1-8e22-7da6-bfd0-16fb000b9f4f | €35.00 | €0.50 | matched |
| 116 | capture | 01a13bd1-a820-797a-82f8-d20eafa370ae | €15.00 | €0.26 | matched |
| 117 | capture | 01a13bd1-d31b-7d74-9e3d-0f142a9ba414 | €35.00 | €0.50 | matched |
| 118 | capture | 01a13bd1-e229-7462-b807-cf706e304145 | €15.00 | €0.26 | matched |
| 119 | refund | 01a13bd1-e12d-71d5-a34e-2e38235d49fd | -€3.00 | €0.00 | matched |
| 120 | capture | 01a13bd1-e712-7229-b0a2-395a8951d624 | €35.00 | €0.50 | matched |
| 121 | capture | 01a13bd2-08e1-723e-92c5-7ca90158707b | €24.00 | €0.37 | matched |
| 122 | capture | 01a13bd2-1bf0-7949-8544-00d1e239a333 | €9.00 | €0.19 | matched |
| 123 | capture | 01a13bd2-2cfd-7b47-add4-634fc6b5839b | €9.00 | €0.19 | matched |
| 124 | capture | 01a13bd2-3938-78a4-a264-2c1defecb4c9 | €15.00 | €0.26 | matched |