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
- 27 Oct, 13:40127 lines6 breaks
- 27 Oct, 13:30120 lines5 breaks
- 27 Oct, 13:20120 lines2 breaks
- 27 Oct, 13:10127 lines6 breaks
- 27 Oct, 13:00134 lines3 breaks
- 27 Oct, 12:50128 lines1 break
- 27 Oct, 12:40123 lines4 breaks
- 27 Oct, 12:30152 lines1 break
- 27 Oct, 12:20122 lines1 break
- 27 Oct, 12:10140 lines1 break
- 27 Oct, 12:00122 lines1 break
- 27 Oct, 11:50114 lines2 breaks
- 27 Oct, 11:40124 lines1 break
- 27 Oct, 11:30131 linesclean
27 Oct, 12:40
Gross
€2,714.00
PSP fee
€44.39
Net to the bank
€2,669.61
Settlement journal
#233154
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17d68-60a3-768d-ab0d-d2b7c94eb2f6 is already settled by stl_EUR_2988508 line 119
- fee differencethe fee is not the contract feethe fee is 70, the contract says 67
- missing linein the books, not in the filecapture:01a17d62-5030-7469-b689-998f33c37d18 is in no file
- missing linein the books, not in the filecapture:01a17d65-b48d-7356-9ade-83df2a86ff9a is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 74 | capture | 01a17d64-bf97-751b-8717-0aaafa596906 | €49.00 | €0.70 | fee difference |
| 120 | capture | 01a17d68-61f2-7a7f-8d47-0e44b3e345ad | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a17d58-af3b-7a06-8770-0907637da133 | €49.00 | €0.67 | matched |
| 2 | capture | 01a17d59-0ea8-73ae-9a7c-59bbe93b9540 | €9.00 | €0.19 | matched |
| 3 | capture | 01a17d5a-bc02-7211-8336-4b7e66de7ebf | €24.00 | €0.37 | matched |
| 4 | capture | 01a17d5d-1f88-779b-abb9-fadc6502727d | €24.00 | €0.37 | matched |
| 5 | refund | 01a17d5d-84d0-741e-b51f-126a4201a57e | -€30.00 | €0.00 | matched |
| 6 | capture | 01a17d5e-4e1a-7038-9721-a89112eb4091 | €9.00 | €0.19 | matched |
| 7 | capture | 01a17d5f-f3b3-7176-969c-0f03e2431be9 | €35.00 | €0.50 | matched |
| 8 | capture | 01a17d60-51ed-7819-9532-c7a80c4817bf | €35.00 | €0.50 | matched |
| 9 | capture | 01a17d60-5a35-781a-8084-e71d836d5fb1 | €35.00 | €0.50 | matched |
| 10 | capture | 01a17d60-8da2-7943-a734-b4adce6b9a32 | €24.00 | €0.37 | matched |
| 11 | capture | 01a17d60-af84-7d0b-8568-66bc7f9bcd59 | €15.00 | €0.26 | matched |
| 12 | capture | 01a17d60-b4c9-739b-b91a-9126605b0052 | €9.00 | €0.19 | matched |
| 13 | capture | 01a17d60-bae1-7492-9c8d-1a63e6391830 | €24.00 | €0.37 | matched |
| 14 | capture | 01a17d60-c08e-77cc-9af6-9328e2635f05 | €15.00 | €0.26 | matched |
| 15 | capture | 01a17d60-c8a9-74fb-8714-18a873f0e9cc | €49.00 | €0.67 | matched |
| 16 | capture | 01a17d60-dcd6-7473-942c-a8954382b1fb | €15.00 | €0.26 | matched |
| 17 | capture | 01a17d60-f672-7d92-b8e6-a7d7ed86b420 | €24.00 | €0.37 | matched |
| 18 | refund | 01a17d60-f570-7e1b-b7aa-ab4460dfe753 | -€10.00 | €0.00 | matched |
| 19 | capture | 01a17d61-02de-7ef9-9ff6-d308dccc151e | €49.00 | €0.67 | matched |
| 20 | capture | 01a17d61-086b-7399-bcd9-2212fd16f62e | €15.00 | €0.26 | matched |
| 21 | capture | 01a17d61-1e4b-75cd-8d5f-0487ccde8fd2 | €24.00 | €0.37 | matched |
| 22 | capture | 01a17d61-28fc-7326-8a49-62492bf2a922 | €49.00 | €0.67 | matched |
| 23 | refund | 01a17d61-339a-7c98-957a-60908d41641d | -€17.00 | €0.00 | matched |
| 24 | refund | 01a17d61-5b8a-7a2a-804b-3a3871c27736 | -€40.00 | €0.00 | matched |
| 25 | refund | 01a17d61-7b9b-750f-afe5-28cbaae7e265 | -€11.00 | €0.00 | matched |
| 26 | capture | 01a17d61-bc4c-7151-8418-0d79131c0765 | €35.00 | €0.50 | matched |
| 27 | capture | 01a17d61-bf42-7998-a1ca-78db6bca227d | €49.00 | €0.67 | matched |
| 28 | capture | 01a17d61-d931-7f00-bad3-f522837a5bb5 | €9.00 | €0.19 | matched |
| 29 | capture | 01a17d61-f4a5-756e-80d4-74d0a0371a5e | €9.00 | €0.19 | matched |
| 30 | capture | 01a17d62-09a7-74e6-8ce0-beef01f93614 | €9.00 | €0.19 | matched |
| 31 | capture | 01a17d62-1323-7de3-a7bf-ea0559f30c10 | €49.00 | €0.67 | matched |
| 32 | capture | 01a17d62-221b-727d-8b35-03fca2ee39db | €24.00 | €0.37 | matched |
| 33 | capture | 01a17d62-40e6-70d4-8627-46d4914e61cb | €35.00 | €0.50 | matched |
| 34 | capture | 01a17d62-4365-71ad-b450-19786cc22f17 | €49.00 | €0.67 | matched |
| 35 | capture | 01a17d62-4940-714b-b9ae-0d1685696491 | €15.00 | €0.26 | matched |
| 36 | capture | 01a17d62-520f-7904-b4bc-3b93f7f49111 | €49.00 | €0.67 | matched |
| 37 | capture | 01a17d62-6c51-743b-8617-c6d1569f4016 | €9.00 | €0.19 | matched |
| 38 | capture | 01a17d62-6d9a-7fe5-862b-8623783d070f | €15.00 | €0.26 | matched |
| 39 | capture | 01a17d62-7200-7389-b293-12dc68608283 | €35.00 | €0.50 | matched |
| 40 | capture | 01a17d62-73f6-7b20-9e3f-e2f083a45532 | €35.00 | €0.50 | matched |
| 41 | capture | 01a17d62-8593-7882-b68b-366a41118532 | €24.00 | €0.37 | matched |
| 42 | refund | 01a17d62-8aeb-72dd-85fe-8a906819f394 | -€22.00 | €0.00 | matched |
| 43 | capture | 01a17d62-8cae-7686-9404-4cb506cbcd46 | €9.00 | €0.19 | matched |
| 44 | capture | 01a17d62-92d3-7135-b461-8d5d459f3243 | €15.00 | €0.26 | matched |
| 45 | capture | 01a17d62-9879-7228-a00a-b9b041562642 | €15.00 | €0.26 | matched |
| 46 | capture | 01a17d62-b0ae-7cda-b938-a805b58f70de | €15.00 | €0.26 | matched |
| 47 | capture | 01a17d62-cb58-7d23-b885-abd09bf40cb1 | €24.00 | €0.37 | matched |
| 48 | capture | 01a17d62-d7d8-75ce-8388-fe063c78827c | €15.00 | €0.26 | matched |
| 49 | capture | 01a17d62-d98e-7944-bcba-de51481dfece | €49.00 | €0.67 | matched |
| 50 | capture | 01a17d62-e538-75d6-a3e2-1966053218ff | €15.00 | €0.26 | matched |
| 51 | capture | 01a17d62-ff78-7a9d-839e-6410b3e6bde3 | €49.00 | €0.67 | matched |
| 52 | capture | 01a17d63-05f1-7560-8ee8-f119c75f7aa8 | €9.00 | €0.19 | matched |
| 53 | capture | 01a17d63-1548-7684-87f4-52709355f012 | €49.00 | €0.67 | matched |
| 54 | capture | 01a17d63-1c92-734e-a144-6410ac6995d7 | €15.00 | €0.26 | matched |
| 55 | capture | 01a17d63-2378-7775-af8b-fbdde0beac0a | €35.00 | €0.50 | matched |
| 56 | refund | 01a17d63-37b6-7293-9849-a93da1777529 | -€41.00 | €0.00 | matched |
| 57 | capture | 01a17d63-3d52-7572-a737-ae11f44ad936 | €35.00 | €0.50 | matched |
| 58 | capture | 01a17d63-67a1-78b3-b4d7-f22cb73eeace | €49.00 | €0.67 | matched |
| 59 | refund | 01a17d63-7cbf-7131-847b-fff41c545a5d | -€32.00 | €0.00 | matched |
| 60 | capture | 01a17d63-94b4-744a-b470-2948a6dd87c5 | €9.00 | €0.19 | matched |
| 61 | capture | 01a17d63-a06e-778d-976b-4795b9a608cf | €15.00 | €0.26 | matched |
| 62 | capture | 01a17d63-b028-7eb9-8945-bd5d0f65d647 | €49.00 | €0.67 | matched |
| 63 | capture | 01a17d63-b9b5-75e7-93c2-c2ca1c391720 | €9.00 | €0.19 | matched |
| 64 | capture | 01a17d63-df90-7609-802b-3dcad196e165 | €24.00 | €0.37 | matched |
| 65 | capture | 01a17d63-f221-7cc4-a714-1b9f7fc6382f | €9.00 | €0.19 | matched |
| 66 | capture | 01a17d64-17ca-7d9e-83e6-febe0923092a | €24.00 | €0.37 | matched |
| 67 | capture | 01a17d64-2bfd-7921-881d-cbb79d1e4f90 | €24.00 | €0.37 | matched |
| 68 | capture | 01a17d64-4e8f-7f26-9305-eef2e4f07d43 | €9.00 | €0.19 | matched |
| 69 | capture | 01a17d64-5a06-76e5-840a-18fe55b1ec5c | €24.00 | €0.37 | matched |
| 70 | capture | 01a17d64-6130-7b2b-be0c-1671b24f35cf | €49.00 | €0.67 | matched |
| 71 | capture | 01a17d64-612c-75f4-9eb5-2b581d55f997 | €15.00 | €0.26 | matched |
| 72 | capture | 01a17d64-9279-70b5-9099-ea091b527d49 | €15.00 | €0.26 | matched |
| 73 | capture | 01a17d64-b594-716e-b54e-09749f6fda66 | €15.00 | €0.26 | matched |
| 75 | capture | 01a17d64-c44e-782a-9d9d-e4305d8687cc | €15.00 | €0.26 | matched |
| 76 | capture | 01a17d64-c647-7eef-9bea-7c375780ede0 | €24.00 | €0.37 | matched |
| 77 | capture | 01a17d64-c899-79dc-a788-88a63514a4f0 | €24.00 | €0.37 | matched |
| 78 | capture | 01a17d64-d6f8-79d1-9167-bf97ba46576e | €24.00 | €0.37 | matched |
| 79 | capture | 01a17d64-e5dd-7855-b317-c724e52e1417 | €24.00 | €0.37 | matched |
| 80 | capture | 01a17d64-fc52-7653-bb94-29eb1496a26c | €9.00 | €0.19 | matched |
| 81 | capture | 01a17d65-23c3-75a3-aa3c-04af0248d019 | €49.00 | €0.67 | matched |
| 82 | capture | 01a17d65-5bd3-79bd-b789-641e2948f05d | €24.00 | €0.37 | matched |
| 83 | capture | 01a17d65-5ee4-7a9d-9900-c6ce03422444 | €35.00 | €0.50 | matched |
| 84 | capture | 01a17d65-6178-747d-a851-6d79e07e56dd | €24.00 | €0.37 | matched |
| 85 | capture | 01a17d65-72ea-7535-9af1-88080527b7b8 | €9.00 | €0.19 | matched |
| 86 | capture | 01a17d65-727a-74e2-9c0a-bd14fca61c5a | €35.00 | €0.50 | matched |
| 87 | capture | 01a17d65-7b61-74c6-8f5e-37555e06d78d | €49.00 | €0.67 | matched |
| 88 | capture | 01a17d65-93da-733d-a1a3-b8bb1b268126 | €15.00 | €0.26 | matched |
| 89 | capture | 01a17d65-a730-710f-aab9-50c786c936e6 | €35.00 | €0.50 | matched |
| 90 | capture | 01a17d65-ba71-786a-9099-5250414cd364 | €49.00 | €0.67 | matched |
| 91 | capture | 01a17d65-d91e-74a7-9f75-0d3ce378644f | €24.00 | €0.37 | matched |
| 92 | capture | 01a17d65-f03d-76d2-9f96-777f65ea0c8f | €15.00 | €0.26 | matched |
| 93 | capture | 01a17d66-1f44-759a-9961-f7f414b34a00 | €15.00 | €0.26 | matched |
| 94 | capture | 01a17d66-2021-7d91-b6b3-01171949cd90 | €24.00 | €0.37 | matched |
| 95 | capture | 01a17d66-51c2-72dd-82a1-4479dc0d4d14 | €49.00 | €0.67 | matched |
| 96 | capture | 01a17d66-8f14-7b98-80f9-b54bdfe1f455 | €9.00 | €0.19 | matched |
| 97 | capture | 01a17d66-9994-7e5c-8fd2-9dd5f9ec50ed | €9.00 | €0.19 | matched |
| 98 | capture | 01a17d66-aa32-71c6-9fd9-32538559d4eb | €9.00 | €0.19 | matched |
| 99 | capture | 01a17d66-af24-7786-9924-f955e4a41822 | €15.00 | €0.26 | matched |
| 100 | capture | 01a17d66-c089-7265-b637-6181076bc2c0 | €49.00 | €0.67 | matched |
| 101 | capture | 01a17d66-d593-7719-a3a1-e9fe9ddf9837 | €24.00 | €0.37 | matched |
| 102 | capture | 01a17d66-de60-7ea0-93e0-2a3e1a071c2d | €15.00 | €0.26 | matched |
| 103 | capture | 01a17d67-2bc9-7b29-89b7-20769db59ca4 | €24.00 | €0.37 | matched |
| 104 | capture | 01a17d67-53aa-735a-8d75-2b8832879db7 | €24.00 | €0.37 | matched |
| 105 | capture | 01a17d67-6114-7cf0-ba5a-cf3ea92a148b | €24.00 | €0.37 | matched |
| 106 | capture | 01a17d67-92a4-7fd9-ad3b-c7c56ad834b8 | €9.00 | €0.19 | matched |
| 107 | capture | 01a17d67-a655-7443-8f00-95fd9a6df8cc | €49.00 | €0.67 | matched |
| 108 | capture | 01a17d67-b4f6-778a-973a-3fc05a30232b | €9.00 | €0.19 | matched |
| 109 | capture | 01a17d67-baa4-7625-8607-184a423a1117 | €49.00 | €0.67 | matched |
| 110 | capture | 01a17d67-bf92-73e7-9927-2f6635b52bbc | €24.00 | €0.37 | matched |
| 111 | capture | 01a17d67-cc0d-7c8e-944e-bd0cbbe25f90 | €15.00 | €0.26 | matched |
| 112 | capture | 01a17d67-cee5-75dd-a77b-399dfeee0b34 | €15.00 | €0.26 | matched |
| 113 | capture | 01a17d67-ead9-76e6-9fec-98301d3adbec | €9.00 | €0.19 | matched |
| 114 | capture | 01a17d68-3afb-7607-8574-501ca7ba1392 | €49.00 | €0.67 | matched |
| 115 | capture | 01a17d68-4b29-7e77-897c-04bab7058822 | €24.00 | €0.37 | matched |
| 116 | capture | 01a17d68-4c2d-7e4f-8711-ddb03a7dbd13 | €35.00 | €0.50 | matched |
| 117 | capture | 01a17d68-5dab-7084-bd24-a4e7b1897292 | €49.00 | €0.67 | matched |
| 118 | capture | 01a17d68-61f0-704b-b194-5e5162187ba8 | €15.00 | €0.26 | matched |
| 119 | capture | 01a17d68-61f2-7a7f-8d47-0e44b3e345ad | €24.00 | €0.37 | matched |
| 121 | capture | 01a17d68-be20-776c-8c77-c5b431e2aad2 | €24.00 | €0.37 | matched |
| 122 | capture | 01a17d68-d028-70af-b7d6-5ab37247eef8 | €9.00 | €0.19 | matched |
| 123 | refund | 01a17d69-0849-7761-8bf0-f239a2f74c61 | -€7.00 | €0.00 | matched |