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
- 30 Oct, 23:30123 lines2 breaks
- 30 Oct, 23:20146 lines5 breaks
- 30 Oct, 23:10149 lines3 breaks
- 30 Oct, 23:00113 lines3 breaks
- 30 Oct, 22:50124 lines3 breaks
- 30 Oct, 22:40108 lines1 break
- 30 Oct, 22:30143 lines4 breaks
- 30 Oct, 22:20131 lines1 break
- 30 Oct, 22:10125 lines1 break
- 30 Oct, 22:00142 lines4 breaks
- 30 Oct, 21:50127 lines2 breaks
- 30 Oct, 21:40116 lines1 break
- 30 Oct, 21:30124 lines1 break
- 30 Oct, 21:20123 lines3 breaks
30 Oct, 22:50
Gross
€2,861.00
PSP fee
€44.83
Net to the bank
€2,816.17
Settlement journal
#295856
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18f06-470e-7ef7-91ab-6f986137e89c is already settled by stl_EUR_2989001 line 69
- duplicate linethe file lists it twicecapture:01a18f08-e1f0-7e53-9863-9d74fe3d37ed is already settled by stl_EUR_2989001 line 108
- missing linein the books, not in the filecapture:01a18f07-f1cb-7450-b7f0-ba13cc59d260 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 70 | capture | 01a18f06-4750-7e55-a636-010031490473 | €35.00 | €0.50 | duplicate line |
| 109 | capture | 01a18f08-e23b-7c09-b86f-365ae54326b6 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a18efb-c87d-7216-af8b-71f437140f67 | €49.00 | €0.67 | matched |
| 2 | capture | 01a18efc-57d8-7330-847c-7dea67fc5f12 | €24.00 | €0.37 | matched |
| 3 | capture | 01a18f01-8b0b-7684-8bbb-41b1374ebce5 | €9.00 | €0.19 | matched |
| 4 | capture | 01a18f01-b080-755f-9690-c7c7469c0fd1 | €49.00 | €0.67 | matched |
| 5 | capture | 01a18f01-db3a-7e6c-b2ec-8ae8c844d391 | €15.00 | €0.26 | matched |
| 6 | capture | 01a18f01-dbc2-7dc1-9440-d73f13b577c9 | €24.00 | €0.37 | matched |
| 7 | capture | 01a18f01-ddb0-7656-b3bb-a4c86cb7a129 | €15.00 | €0.26 | matched |
| 8 | capture | 01a18f01-e20e-7d7e-8e24-fc9adcbf8f9d | €24.00 | €0.37 | matched |
| 9 | capture | 01a18f01-e6c0-791c-8dfa-86f929d9be76 | €35.00 | €0.50 | matched |
| 10 | capture | 01a18f01-ef7e-7203-a574-a1aaae6e6c33 | €9.00 | €0.19 | matched |
| 11 | capture | 01a18f02-015b-7f35-94f3-408e24fb6ecb | €35.00 | €0.50 | matched |
| 12 | refund | 01a18f02-0952-7e04-b083-b73c633ede06 | -€19.00 | €0.00 | matched |
| 13 | capture | 01a18f02-3bcb-7eeb-94bd-53eb6e07a08c | €9.00 | €0.19 | matched |
| 14 | capture | 01a18f02-6b30-7250-afd8-8dfaa2a971a8 | €9.00 | €0.19 | matched |
| 15 | capture | 01a18f02-743a-7bec-af4f-d9a4d0a68497 | €9.00 | €0.19 | matched |
| 16 | capture | 01a18f02-74f3-76a1-9378-f0b526a059d7 | €24.00 | €0.37 | matched |
| 17 | capture | 01a18f02-84a6-70c6-a7f4-ffda20ef96f9 | €15.00 | €0.26 | matched |
| 18 | refund | 01a18f02-b0b7-7fda-8e9f-14086edfd052 | -€6.00 | €0.00 | matched |
| 19 | capture | 01a18f02-ca7c-754c-b6ea-334a87e03b7f | €24.00 | €0.37 | matched |
| 20 | capture | 01a18f02-f0b9-70ee-b951-a34c8e3cca93 | €9.00 | €0.19 | matched |
| 21 | capture | 01a18f03-025f-73ef-9eab-b8535f871a6e | €49.00 | €0.67 | matched |
| 22 | capture | 01a18f03-1920-7592-b8dd-efda220f79d0 | €35.00 | €0.50 | matched |
| 23 | capture | 01a18f03-1a8f-7f94-8a45-ca3996a45076 | €49.00 | €0.67 | matched |
| 24 | capture | 01a18f03-1aa1-736b-8628-0a003b053ab8 | €49.00 | €0.67 | matched |
| 25 | capture | 01a18f03-342e-7484-923c-f63975a81e09 | €49.00 | €0.67 | matched |
| 26 | capture | 01a18f03-52ee-7ec8-af49-882f3d18fe50 | €9.00 | €0.19 | matched |
| 27 | capture | 01a18f03-778c-7f87-9847-da9c5b515820 | €35.00 | €0.50 | matched |
| 28 | capture | 01a18f03-8a11-7016-9b1b-6517d6b39a3b | €24.00 | €0.37 | matched |
| 29 | capture | 01a18f03-8dbf-712b-bacd-315daa1b1ec3 | €15.00 | €0.26 | matched |
| 30 | capture | 01a18f03-91df-799d-921d-b3d4c2969f02 | €24.00 | €0.37 | matched |
| 31 | capture | 01a18f03-b900-7431-be8c-89b8a2a9057e | €9.00 | €0.19 | matched |
| 32 | capture | 01a18f04-029f-7250-9354-a676fe1af7a2 | €35.00 | €0.50 | matched |
| 33 | capture | 01a18f04-0672-7046-9344-1ac03c0d42f7 | €9.00 | €0.19 | matched |
| 34 | capture | 01a18f04-0a34-724d-bea4-158b239f6d2e | €24.00 | €0.37 | matched |
| 35 | capture | 01a18f04-0c2b-7c65-a986-d38eb0ed2d48 | €24.00 | €0.37 | matched |
| 36 | capture | 01a18f04-1a16-7632-8192-68cfc359f6ff | €49.00 | €0.67 | matched |
| 37 | capture | 01a18f04-2449-7187-983c-04bdd8a2b631 | €49.00 | €0.67 | matched |
| 38 | capture | 01a18f04-2dba-7fb3-aeb0-ea5b8f8e1eee | €24.00 | €0.37 | matched |
| 39 | capture | 01a18f04-51ce-784d-a2e5-3bff297ee4a9 | €35.00 | €0.50 | matched |
| 40 | capture | 01a18f04-729a-705f-9124-52de4b06b5d0 | €24.00 | €0.37 | matched |
| 41 | capture | 01a18f04-759e-7c88-8e7d-05901fec1992 | €15.00 | €0.26 | matched |
| 42 | capture | 01a18f04-81ba-7ee5-b1d5-7457ec8e1e0e | €9.00 | €0.19 | matched |
| 43 | capture | 01a18f04-82f1-7e4b-9b1a-33fe0cfe606e | €49.00 | €0.67 | matched |
| 44 | refund | 01a18f04-903f-735f-b0f2-9cc0a9c5db23 | -€12.00 | €0.00 | matched |
| 45 | capture | 01a18f04-9245-7548-bce7-4006a3cedf1e | €24.00 | €0.37 | matched |
| 46 | capture | 01a18f04-a6bb-7587-9033-69bc35cc3b26 | €15.00 | €0.26 | matched |
| 47 | capture | 01a18f04-b16c-72e6-8bdc-69617b173eea | €9.00 | €0.19 | matched |
| 48 | refund | 01a18f04-c19b-7f87-81bb-ded40865b4d6 | -€13.00 | €0.00 | matched |
| 49 | capture | 01a18f04-ce16-72a1-a417-08d8e78c5a68 | €15.00 | €0.26 | matched |
| 50 | capture | 01a18f04-d36d-727b-9543-48e6c18f57bb | €15.00 | €0.26 | matched |
| 51 | refund | 01a18f05-0b19-76b9-ad77-71d8fb076b84 | -€10.00 | €0.00 | matched |
| 52 | capture | 01a18f05-1509-7941-a5a1-40c99ea7b665 | €24.00 | €0.37 | matched |
| 53 | refund | 01a18f05-231d-7353-b973-99e829034eff | -€13.00 | €0.00 | matched |
| 54 | capture | 01a18f05-408f-7a1c-9aa6-efab1d5ab43b | €24.00 | €0.37 | matched |
| 55 | capture | 01a18f05-75bb-70db-ae6e-1a82b5a3b53f | €24.00 | €0.37 | matched |
| 56 | capture | 01a18f05-7623-7d77-b3d0-4c27e18f1681 | €9.00 | €0.19 | matched |
| 57 | capture | 01a18f05-77e9-7e84-883f-73e1191fc5d7 | €15.00 | €0.26 | matched |
| 58 | capture | 01a18f05-8505-7256-a34e-5638e8e81430 | €24.00 | €0.37 | matched |
| 59 | capture | 01a18f05-a688-74c2-a3b3-05490662e0f5 | €35.00 | €0.50 | matched |
| 60 | capture | 01a18f05-ad5f-7fcc-b928-cf4d7b938992 | €24.00 | €0.37 | matched |
| 61 | capture | 01a18f05-cf83-78ad-aba2-90da71dc33cb | €35.00 | €0.50 | matched |
| 62 | refund | 01a18f05-d61d-7a17-844e-6319d97a0a5a | -€2.00 | €0.00 | matched |
| 63 | capture | 01a18f05-ec56-7648-943a-33c3e46a30a8 | €49.00 | €0.67 | matched |
| 64 | capture | 01a18f06-0cf9-76c4-8f9a-4f4ae88bf3c0 | €24.00 | €0.37 | matched |
| 65 | capture | 01a18f06-1870-7d6f-9537-a762a06dc0d1 | €9.00 | €0.19 | matched |
| 66 | capture | 01a18f06-288a-7c07-819d-699e585980d2 | €9.00 | €0.19 | matched |
| 67 | capture | 01a18f06-2c41-7cfc-a88c-3709126f3845 | €24.00 | €0.37 | matched |
| 68 | capture | 01a18f06-3a77-7198-a25f-d1916f241c54 | €49.00 | €0.67 | matched |
| 69 | capture | 01a18f06-4750-7e55-a636-010031490473 | €35.00 | €0.50 | matched |
| 71 | capture | 01a18f06-6456-7d95-abd1-e870268ae42f | €9.00 | €0.19 | matched |
| 72 | capture | 01a18f06-961b-7059-bf96-913f80dbbf8a | €24.00 | €0.37 | matched |
| 73 | capture | 01a18f06-9b77-7f3c-b40d-52ee7117dca5 | €15.00 | €0.26 | matched |
| 74 | capture | 01a18f06-bf30-7e00-8715-cb04a7fdec85 | €35.00 | €0.50 | matched |
| 75 | capture | 01a18f06-d4ef-7994-9c9c-85410732d2e1 | €35.00 | €0.50 | matched |
| 76 | capture | 01a18f06-dab1-7f8e-a1bc-911f1c9331e1 | €35.00 | €0.50 | matched |
| 77 | capture | 01a18f06-e766-7f36-99a8-ba2ad0136d00 | €35.00 | €0.50 | matched |
| 78 | capture | 01a18f06-f1cd-7706-8195-13bc5100cea1 | €24.00 | €0.37 | matched |
| 79 | capture | 01a18f07-096e-7418-87cd-5711ba3e025f | €35.00 | €0.50 | matched |
| 80 | capture | 01a18f07-0b85-726d-8079-5c9b8931498c | €9.00 | €0.19 | matched |
| 81 | capture | 01a18f07-2747-79b0-90bf-647ea98ead40 | €9.00 | €0.19 | matched |
| 82 | capture | 01a18f07-4b1b-7e21-a2b2-b2aef9779f21 | €35.00 | €0.50 | matched |
| 83 | capture | 01a18f07-4eb3-7141-848d-2cea6f5efa33 | €9.00 | €0.19 | matched |
| 84 | capture | 01a18f07-6cbc-7026-8cb2-844acd98ed03 | €15.00 | €0.26 | matched |
| 85 | capture | 01a18f07-6ff8-74c4-8b0b-110dd6045c39 | €24.00 | €0.37 | matched |
| 86 | capture | 01a18f07-a3ac-760b-b11e-ab8c9db7f971 | €24.00 | €0.37 | matched |
| 87 | capture | 01a18f07-b3ae-7821-9781-406bfd65669a | €9.00 | €0.19 | matched |
| 88 | capture | 01a18f07-b689-707d-9d2b-fae58f6b1ec8 | €24.00 | €0.37 | matched |
| 89 | capture | 01a18f07-b259-700a-b1b9-bfb6637c3354 | €24.00 | €0.37 | matched |
| 90 | capture | 01a18f07-c423-7f13-bc23-fa534f0dc845 | €9.00 | €0.19 | matched |
| 91 | capture | 01a18f07-d571-7994-abc8-1cba48f03fcc | €9.00 | €0.19 | matched |
| 92 | capture | 01a18f07-d8ef-7302-a72e-6ddcbb92958f | €15.00 | €0.26 | matched |
| 93 | capture | 01a18f07-dd6a-7ea2-bed3-82325038cb07 | €35.00 | €0.50 | matched |
| 94 | capture | 01a18f07-f61c-7cf8-9d2e-9124f5160914 | €49.00 | €0.67 | matched |
| 95 | capture | 01a18f07-fd08-74ef-b953-8108980a933d | €15.00 | €0.26 | matched |
| 96 | capture | 01a18f08-18cf-7d6d-ad46-de373f86639f | €49.00 | €0.67 | matched |
| 97 | capture | 01a18f08-2269-7e1d-8272-d69cb84a7c7b | €15.00 | €0.26 | matched |
| 98 | capture | 01a18f08-28f4-7e91-ae9f-e9cfceec40a5 | €35.00 | €0.50 | matched |
| 99 | capture | 01a18f08-3be5-7789-b99a-6cb39ab60773 | €49.00 | €0.67 | matched |
| 100 | capture | 01a18f08-5f17-7347-b306-d4882b03f457 | €24.00 | €0.37 | matched |
| 101 | capture | 01a18f08-6c71-79f1-8ad6-4cbb899dd441 | €24.00 | €0.37 | matched |
| 102 | capture | 01a18f08-728f-7f34-826e-d7fb2324cede | €35.00 | €0.50 | matched |
| 103 | capture | 01a18f08-7522-7f88-b9ec-ac1ed556f924 | €35.00 | €0.50 | matched |
| 104 | capture | 01a18f08-8072-7f09-b494-de5b05378caa | €15.00 | €0.26 | matched |
| 105 | capture | 01a18f08-8463-760c-9103-72a2b2a5b281 | €49.00 | €0.67 | matched |
| 106 | refund | 01a18f08-b4ce-7670-bf4d-ee4a42515f56 | -€15.00 | €0.00 | matched |
| 107 | capture | 01a18f08-bb07-7e65-9725-edd9b7e1a2da | €35.00 | €0.50 | matched |
| 108 | capture | 01a18f08-e23b-7c09-b86f-365ae54326b6 | €49.00 | €0.67 | matched |
| 110 | capture | 01a18f08-f7cf-7561-a706-86915e737da3 | €15.00 | €0.26 | matched |
| 111 | capture | 01a18f08-fd6e-70a0-b852-d630b9d99d87 | €35.00 | €0.50 | matched |
| 112 | capture | 01a18f09-2bd5-7f41-8001-30ebc291768e | €35.00 | €0.50 | matched |
| 113 | capture | 01a18f09-6caa-7148-9e0a-25612cac63ea | €35.00 | €0.50 | matched |
| 114 | capture | 01a18f09-75d7-7348-b2e5-387d60313a16 | €15.00 | €0.26 | matched |
| 115 | capture | 01a18f09-7603-77d3-a59b-675aca056ca5 | €49.00 | €0.67 | matched |
| 116 | capture | 01a18f09-7a3f-7397-ac91-1672bf8a1c84 | €15.00 | €0.26 | matched |
| 117 | capture | 01a18f09-8f72-7a4f-ae97-28946277e29c | €9.00 | €0.19 | matched |
| 118 | capture | 01a18f09-9fe3-79d8-8e72-9fe9542154ca | €15.00 | €0.26 | matched |
| 119 | capture | 01a18f09-c7e8-7107-b7d0-27981419c260 | €15.00 | €0.26 | matched |
| 120 | capture | 01a18f09-c9b0-7d0d-8d93-449b60d2fca9 | €9.00 | €0.19 | matched |
| 121 | capture | 01a18f09-dc70-718c-861f-5e3b1391d3c8 | €15.00 | €0.26 | matched |
| 122 | capture | 01a18f0a-095c-7b8c-8469-782e59c87a1e | €35.00 | €0.50 | matched |
| 123 | capture | 01a18f0a-10cc-7968-9267-5c422ae6d970 | €9.00 | €0.19 | matched |
| 124 | capture | 01a18f0a-6eae-7786-a8bd-1a06eba9bbd0 | €15.00 | €0.26 | matched |