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
- 3 Nov, 21:30132 lines3 breaks
- 3 Nov, 21:2097 lines1 break
- 3 Nov, 21:10119 lines1 break
- 3 Nov, 21:00117 lines1 break
- 3 Nov, 20:50128 lines4 breaks
- 3 Nov, 20:40104 lines2 breaks
- 3 Nov, 20:30146 lines4 breaks
- 3 Nov, 20:20143 lines4 breaks
- 3 Nov, 20:10123 lines1 break
- 3 Nov, 20:00129 lines7 breaks
- 3 Nov, 19:50125 lines4 breaks
- 3 Nov, 19:40121 lines4 breaks
- 3 Nov, 19:30117 linesclean
- 3 Nov, 19:20121 lines5 breaks
3 Nov, 20:40
Gross
€2,824.00
PSP fee
€42.65
Net to the bank
€2,781.35
Settlement journal
#367342
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a327-f8a7-706c-826a-d66d4dffa15e is already settled by stl_EUR_2989564 line 51
- missing linein the books, not in the filecapture:01a1a328-ab3e-7b39-9e15-25e17b20920e is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 52 | capture | 01a1a327-f8ce-79c1-b166-e9ffecda6380 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1a31c-64bd-7d7d-b62d-63a6f6a64f62 | €35.00 | €0.50 | matched |
| 2 | capture | 01a1a31e-c344-72cd-bca4-72e141fa51fc | €49.00 | €0.67 | matched |
| 3 | refund | 01a1a321-8672-7c15-8b1a-338b608af519 | -€9.00 | €0.00 | matched |
| 4 | capture | 01a1a323-1992-7425-b0e1-4a46075db057 | €15.00 | €0.26 | matched |
| 5 | capture | 01a1a323-f8b1-7745-ba66-af3d40cb4b10 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1a324-0765-760c-86cd-a94d18526993 | €9.00 | €0.19 | matched |
| 7 | capture | 01a1a324-272c-783a-b324-6f7221abe160 | €49.00 | €0.67 | matched |
| 8 | refund | 01a1a324-3ba1-7883-8cb1-bf315eb7448c | -€4.00 | €0.00 | matched |
| 9 | capture | 01a1a324-41c3-749b-9add-eaca738917aa | €9.00 | €0.19 | matched |
| 10 | capture | 01a1a324-7cc5-73e4-8c52-3b0cb3359899 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1a324-8b83-70ac-b6fc-fe68d1e3b3e6 | €35.00 | €0.50 | matched |
| 12 | capture | 01a1a324-adfc-7fd0-bb00-b772a83743f9 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1a324-e46c-7636-b43b-dce0924ef536 | €24.00 | €0.37 | matched |
| 14 | capture | 01a1a324-ea9e-7481-aca3-80d64496d48e | €35.00 | €0.50 | matched |
| 15 | capture | 01a1a325-047b-7f2d-9b08-419f3160f070 | €15.00 | €0.26 | matched |
| 16 | capture | 01a1a325-3903-712e-a171-389137aee2d3 | €9.00 | €0.19 | matched |
| 17 | capture | 01a1a325-4526-70f0-88e6-a040ce6d1841 | €15.00 | €0.26 | matched |
| 18 | capture | 01a1a325-65d3-73f5-8543-f65397db7a2e | €9.00 | €0.19 | matched |
| 19 | capture | 01a1a325-8146-734f-89cc-571720ee44de | €49.00 | €0.67 | matched |
| 20 | capture | 01a1a325-8cfa-70e1-9277-91d68869a207 | €49.00 | €0.67 | matched |
| 21 | capture | 01a1a325-9031-7f03-b29f-3d52694326f4 | €24.00 | €0.37 | matched |
| 22 | capture | 01a1a325-a497-724d-8bb6-f94c403fbad4 | €35.00 | €0.50 | matched |
| 23 | capture | 01a1a325-b394-787b-a48e-94c2e464429e | €9.00 | €0.19 | matched |
| 24 | capture | 01a1a325-b439-7e03-ae47-3ffd4b9bce42 | €49.00 | €0.67 | matched |
| 25 | capture | 01a1a325-c72d-7c18-b031-fde02a19a071 | €35.00 | €0.50 | matched |
| 26 | capture | 01a1a325-d240-7f45-9cf5-ad19b8b221bd | €49.00 | €0.67 | matched |
| 27 | capture | 01a1a326-1b89-7d54-98d7-83742edfa4b1 | €9.00 | €0.19 | matched |
| 28 | capture | 01a1a326-2ead-74b6-8e95-5a06c2f73e79 | €15.00 | €0.26 | matched |
| 29 | capture | 01a1a326-3bf8-73ea-ae46-29477526b2fc | €9.00 | €0.19 | matched |
| 30 | capture | 01a1a326-4089-7bb2-9877-7ccfcce67029 | €24.00 | €0.37 | matched |
| 31 | capture | 01a1a326-4993-7923-9966-59f1d31db275 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1a326-5d7f-7e16-9a8e-c7f4bec52eb6 | €15.00 | €0.26 | matched |
| 33 | capture | 01a1a326-81ef-79a2-ba84-83d40bc68993 | €15.00 | €0.26 | matched |
| 34 | capture | 01a1a326-a90c-78ec-9fb0-b5d1f45b2de3 | €35.00 | €0.50 | matched |
| 35 | capture | 01a1a326-c88a-7a29-9e53-d9bdb3481800 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1a326-dd39-7ea9-b568-d0e87f3e130e | €15.00 | €0.26 | matched |
| 37 | capture | 01a1a326-de8c-72e0-bbb2-5579379a9ba7 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1a326-e1ec-75ee-90b9-e2c294d80af9 | €9.00 | €0.19 | matched |
| 39 | capture | 01a1a327-0420-7383-ab4f-e78b80af9823 | €49.00 | €0.67 | matched |
| 40 | capture | 01a1a327-1c63-7a18-8986-380b6744062e | €35.00 | €0.50 | matched |
| 41 | capture | 01a1a327-3ab6-75f6-95b2-1512c0782726 | €35.00 | €0.50 | matched |
| 42 | capture | 01a1a327-4477-7eb5-82b1-c9e2c56b8e2d | €9.00 | €0.19 | matched |
| 43 | capture | 01a1a327-5e5a-7458-a7ee-ccd19cd132a9 | €35.00 | €0.50 | matched |
| 44 | capture | 01a1a327-6a4e-76e4-afd9-34a5baaa9f1a | €35.00 | €0.50 | matched |
| 45 | capture | 01a1a327-7631-7a8e-ae16-c9776b986e46 | €24.00 | €0.37 | matched |
| 46 | capture | 01a1a327-7747-78ef-94dd-db94e9ca560a | €35.00 | €0.50 | matched |
| 47 | capture | 01a1a327-868a-7f54-9f4e-a6e2a9def235 | €35.00 | €0.50 | matched |
| 48 | capture | 01a1a327-9cec-794b-b653-fddad1e9d62b | €24.00 | €0.37 | matched |
| 49 | capture | 01a1a327-aeae-7c1e-92ec-5a18a158a656 | €24.00 | €0.37 | matched |
| 50 | capture | 01a1a327-b064-7cfd-8e43-70ade0f3e99c | €49.00 | €0.67 | matched |
| 51 | capture | 01a1a327-f8ce-79c1-b166-e9ffecda6380 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1a328-0f9e-7ce5-b0a9-e989e1c0f871 | €9.00 | €0.19 | matched |
| 54 | capture | 01a1a328-314c-71c0-b29a-365115bd2353 | €49.00 | €0.67 | matched |
| 55 | capture | 01a1a328-5fde-730f-8d05-20f8e4447b98 | €9.00 | €0.19 | matched |
| 56 | capture | 01a1a328-841f-7a7d-8587-c26798981f71 | €15.00 | €0.26 | matched |
| 57 | capture | 01a1a328-8a79-7739-93f1-646743deb280 | €49.00 | €0.67 | matched |
| 58 | capture | 01a1a328-8c6b-707c-a018-a462d1177d9a | €9.00 | €0.19 | matched |
| 59 | capture | 01a1a328-93e8-72a0-b711-f4cbba3769d1 | €15.00 | €0.26 | matched |
| 60 | capture | 01a1a328-ea79-7512-87b3-eeb2e5036fc9 | €35.00 | €0.50 | matched |
| 61 | capture | 01a1a329-04d0-75e4-96c9-78a3bb88aed4 | €24.00 | €0.37 | matched |
| 62 | capture | 01a1a329-0975-7e3c-a823-e4a562b10f4e | €24.00 | €0.37 | matched |
| 63 | capture | 01a1a329-0f53-7e17-bc93-3a622d101d0f | €15.00 | €0.26 | matched |
| 64 | capture | 01a1a329-138e-7a7c-9210-5d697180234d | €15.00 | €0.26 | matched |
| 65 | capture | 01a1a329-5dfe-75be-afd5-b1e430fe9a44 | €15.00 | €0.26 | matched |
| 66 | capture | 01a1a329-629a-76a7-9438-2678526fd7a9 | €9.00 | €0.19 | matched |
| 67 | capture | 01a1a329-827b-77e1-aa36-14c7f3940b45 | €35.00 | €0.50 | matched |
| 68 | capture | 01a1a329-9800-78a9-a2cb-5a88ca6ee34b | €49.00 | €0.67 | matched |
| 69 | capture | 01a1a329-b0de-7ed4-a902-8b9b97c732b0 | €15.00 | €0.26 | matched |
| 70 | capture | 01a1a329-b22d-7f7b-b202-bdcf89fc47c4 | €49.00 | €0.67 | matched |
| 71 | capture | 01a1a329-b96f-7759-8482-58145a9b8cb2 | €35.00 | €0.50 | matched |
| 72 | capture | 01a1a329-e96d-78bd-8513-343fcad51106 | €49.00 | €0.67 | matched |
| 73 | capture | 01a1a329-f7ef-7428-bfd9-5085160204aa | €9.00 | €0.19 | matched |
| 74 | capture | 01a1a32a-0da6-7794-90c9-eacba8baf989 | €35.00 | €0.50 | matched |
| 75 | capture | 01a1a32a-2304-7c8b-a35b-33266604a277 | €35.00 | €0.50 | matched |
| 76 | capture | 01a1a32a-2b48-7d0d-959d-5bf62e3bb70e | €35.00 | €0.50 | matched |
| 77 | capture | 01a1a32a-40b7-7fff-b08f-93c4a8c7a5fd | €15.00 | €0.26 | matched |
| 78 | capture | 01a1a32a-40c4-7164-aca3-455e46e2e6a2 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1a32a-7488-7c6a-84a7-0886987221a8 | €49.00 | €0.67 | matched |
| 80 | capture | 01a1a32a-90a9-74e7-94f2-840bd67afa95 | €49.00 | €0.67 | matched |
| 81 | capture | 01a1a32a-9115-7bd0-a4a7-04a37cd42ff9 | €49.00 | €0.67 | matched |
| 82 | capture | 01a1a32a-9f3c-7abb-989a-0a2ee475ed03 | €35.00 | €0.50 | matched |
| 83 | capture | 01a1a32a-a24b-77d1-8067-cab35266b9c1 | €15.00 | €0.26 | matched |
| 84 | refund | 01a1a32a-a59c-7f46-aecb-e87413e7bc91 | -€6.00 | €0.00 | matched |
| 85 | capture | 01a1a32a-cd8b-78bf-997a-35b2465b157b | €15.00 | €0.26 | matched |
| 86 | refund | 01a1a32a-dee5-7ffd-8b82-1e89e7f63ee0 | -€35.00 | €0.00 | matched |
| 87 | capture | 01a1a32a-fde2-7f7c-9f49-968879b8932d | €49.00 | €0.67 | matched |
| 88 | capture | 01a1a32b-095e-7ee1-81de-834a4b572048 | €9.00 | €0.19 | matched |
| 89 | capture | 01a1a32b-496e-71ab-8324-e43de102f294 | €35.00 | €0.50 | matched |
| 90 | capture | 01a1a32b-6570-751e-b7b0-cfc0cd3800eb | €49.00 | €0.67 | matched |
| 91 | capture | 01a1a32b-82d1-7293-b71d-69f58cb17e88 | €35.00 | €0.50 | matched |
| 92 | capture | 01a1a32b-a1e2-7a4f-aa09-4e47cab97c4a | €49.00 | €0.67 | matched |
| 93 | capture | 01a1a32b-ab12-7d1b-a063-d9edb11f5c64 | €24.00 | €0.37 | matched |
| 94 | capture | 01a1a32b-acbd-702f-9d4f-6f08e3176a4a | €49.00 | €0.67 | matched |
| 95 | capture | 01a1a32b-bd13-7f8c-98be-0ccb2d71d087 | €15.00 | €0.26 | matched |
| 96 | capture | 01a1a32c-292c-7de0-9aa3-4d20f95d81ed | €24.00 | €0.37 | matched |
| 97 | capture | 01a1a32c-3668-7c5c-b91d-a7819a0b31f1 | €15.00 | €0.26 | matched |
| 98 | capture | 01a1a32c-4a1f-7a51-95b4-c891b647dd20 | €49.00 | €0.67 | matched |
| 99 | capture | 01a1a32c-6150-7ab5-b840-2fe3b2b7a43c | €35.00 | €0.50 | matched |
| 100 | capture | 01a1a32c-7011-7bda-8fdf-56bff79fc95a | €9.00 | €0.19 | matched |
| 101 | capture | 01a1a32c-b00a-77ec-9bd3-13451cc0f7af | €9.00 | €0.19 | matched |
| 102 | capture | 01a1a32c-ba04-788f-a309-47d5be0c6bb6 | €15.00 | €0.26 | matched |
| 103 | capture | 01a1a32c-f33a-7567-af9b-ac5a014e9cfa | €35.00 | €0.50 | matched |
| 104 | capture | 01a1a32c-f661-761f-bb30-68dc9006e1a5 | €15.00 | €0.26 | matched |