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
- 1 Nov, 09:20133 lines5 breaks
- 1 Nov, 09:10118 lines6 breaks
- 1 Nov, 09:00110 lines2 breaks
- 1 Nov, 08:50122 lines2 breaks
- 1 Nov, 08:40115 lines2 breaks
- 1 Nov, 08:30132 lines3 breaks
- 1 Nov, 08:20131 lines3 breaks
- 1 Nov, 08:10134 lines3 breaks
- 1 Nov, 08:00128 lines2 breaks
- 1 Nov, 07:50104 lines1 break
- 1 Nov, 07:40135 lines2 breaks
- 1 Nov, 07:30122 lines7 breaks
- 1 Nov, 07:20133 linesclean
- 1 Nov, 07:10134 lines4 breaks
1 Nov, 08:00
Gross
€3,001.00
PSP fee
€47.54
Net to the bank
€2,953.46
Settlement journal
#321119
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19628-6365-7aa4-ba95-c33a0206f063 is already settled by stl_EUR_2989200 line 125
- missing linein the books, not in the filecapture:01a19622-73a0-7411-8681-b6a5531bef83 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 126 | capture | 01a19628-63a8-7485-aac1-7a0a93b5ff7e | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a1961a-f279-79ea-b3ed-6e52bd6b7216 | €49.00 | €0.67 | matched |
| 2 | capture | 01a1961b-552d-725b-b2f5-d126e599340d | €35.00 | €0.50 | matched |
| 3 | capture | 01a1961f-6098-7c9a-818f-011cf6781d72 | €24.00 | €0.37 | matched |
| 4 | capture | 01a1961f-6e48-78bf-a734-5b2d1bf041a8 | €15.00 | €0.26 | matched |
| 5 | capture | 01a1961f-98fb-7917-a044-f8c0a3b3c7be | €35.00 | €0.50 | matched |
| 6 | refund | 01a1961f-ad85-7d3d-899f-f5c0460f65f4 | -€7.00 | €0.00 | matched |
| 7 | capture | 01a1961f-af4c-745c-accf-af91097c08ce | €35.00 | €0.50 | matched |
| 8 | capture | 01a1961f-cd58-77ae-b8b6-7057d6f997c9 | €9.00 | €0.19 | matched |
| 9 | capture | 01a1961f-ded3-7f0c-bba4-178ddcf2a29a | €15.00 | €0.26 | matched |
| 10 | capture | 01a1961f-edc3-71bd-b05b-950854aa5fe3 | €9.00 | €0.19 | matched |
| 11 | capture | 01a1961f-f864-7abb-9c78-7f9d3b4b42f1 | €24.00 | €0.37 | matched |
| 12 | capture | 01a19620-3738-7339-b758-33230ddda2a6 | €9.00 | €0.19 | matched |
| 13 | capture | 01a19620-3995-789c-b2d5-e2546ce2f840 | €15.00 | €0.26 | matched |
| 14 | capture | 01a19620-706f-701d-9d25-3dd6061860f2 | €35.00 | €0.50 | matched |
| 15 | capture | 01a19620-a69d-721b-8da2-ecd7e8a0b4a1 | €9.00 | €0.19 | matched |
| 16 | capture | 01a19620-aa01-7c4d-a845-65496a1d09c6 | €24.00 | €0.37 | matched |
| 17 | capture | 01a19620-b3cd-7aa9-b657-626138160ee3 | €49.00 | €0.67 | matched |
| 18 | capture | 01a19620-d320-715e-a5a8-37ec89308cbc | €49.00 | €0.67 | matched |
| 19 | capture | 01a19620-e0a4-745b-9983-1cf477bcdbdb | €9.00 | €0.19 | matched |
| 20 | capture | 01a19620-e5d6-750a-8e16-b552cc6b6d03 | €49.00 | €0.67 | matched |
| 21 | capture | 01a19620-fc93-7970-a4fc-992d0eb7c2c7 | €35.00 | €0.50 | matched |
| 22 | capture | 01a19621-0394-77be-9b24-7cfa5a9326e3 | €15.00 | €0.26 | matched |
| 23 | capture | 01a19621-0b19-7c23-b122-763f4fc82e42 | €49.00 | €0.67 | matched |
| 24 | capture | 01a19621-0c22-7b1d-b14a-364395940b25 | €15.00 | €0.26 | matched |
| 25 | capture | 01a19621-1e4b-7790-80f0-1a1e4e065214 | €35.00 | €0.50 | matched |
| 26 | capture | 01a19621-39b6-7e08-896c-2a49c9169677 | €24.00 | €0.37 | matched |
| 27 | capture | 01a19621-3a89-7170-8c16-a5aa2c7fcb7c | €24.00 | €0.37 | matched |
| 28 | capture | 01a19621-4a3f-7068-b8a0-d7e707a07f97 | €49.00 | €0.67 | matched |
| 29 | capture | 01a19621-613f-7127-9ee2-85c9410250b8 | €35.00 | €0.50 | matched |
| 30 | refund | 01a19621-7494-759f-a5a9-58fe53a5c360 | -€21.00 | €0.00 | matched |
| 31 | capture | 01a19621-7dfb-71a6-b99c-4fbbd4989136 | €35.00 | €0.50 | matched |
| 32 | capture | 01a19621-8c96-7b52-88d9-08919e3de95b | €49.00 | €0.67 | matched |
| 33 | capture | 01a19621-9fb5-7a12-a01c-dd631f65b903 | €24.00 | €0.37 | matched |
| 34 | capture | 01a19621-a1c9-75e0-9c3c-ed815fa20971 | €9.00 | €0.19 | matched |
| 35 | capture | 01a19621-acbb-7137-8be2-d5e2587a4cc1 | €9.00 | €0.19 | matched |
| 36 | capture | 01a19621-b3cf-7687-9ccb-1af131a8e2c3 | €24.00 | €0.37 | matched |
| 37 | capture | 01a19621-baf9-75bf-8219-81ee9c7172f3 | €9.00 | €0.19 | matched |
| 38 | capture | 01a19621-d2dc-7441-9a5a-903b67466ef0 | €49.00 | €0.67 | matched |
| 39 | capture | 01a19622-0d43-7430-a9d4-fa6103314da4 | €35.00 | €0.50 | matched |
| 40 | capture | 01a19622-1c43-773a-8e8e-b549c0330099 | €49.00 | €0.67 | matched |
| 41 | capture | 01a19622-1df2-7eb4-b78a-e5a05f021690 | €9.00 | €0.19 | matched |
| 42 | capture | 01a19622-23cc-7f14-8062-077b2469c514 | €9.00 | €0.19 | matched |
| 43 | capture | 01a19622-26ff-77f5-8c5e-867ef23d76f5 | €9.00 | €0.19 | matched |
| 44 | capture | 01a19622-2d37-7d53-9f13-5f39ae993386 | €35.00 | €0.50 | matched |
| 45 | capture | 01a19622-3340-78e0-9f31-4f3e4e9afd39 | €35.00 | €0.50 | matched |
| 46 | capture | 01a19622-40ec-7cce-af88-4ba7debe0758 | €35.00 | €0.50 | matched |
| 47 | capture | 01a19622-47f7-7494-a0a0-cc703ad8dd67 | €35.00 | €0.50 | matched |
| 48 | capture | 01a19622-4c80-787a-ab16-25f134a583fa | €9.00 | €0.19 | matched |
| 49 | capture | 01a19622-6e07-729c-af9b-43c582e3241e | €24.00 | €0.37 | matched |
| 50 | capture | 01a19622-820d-76c5-a265-02e6e241fecf | €15.00 | €0.26 | matched |
| 51 | capture | 01a19622-a3c9-7668-b8c1-ab66524b0b64 | €24.00 | €0.37 | matched |
| 52 | capture | 01a19622-a3e9-76c3-9505-46d1d25d480b | €35.00 | €0.50 | matched |
| 53 | capture | 01a19622-cece-7ea5-801f-c5c1afb0f8fe | €9.00 | €0.19 | matched |
| 54 | refund | 01a19622-d5cb-7a72-9c05-3ebc937262ae | -€32.00 | €0.00 | matched |
| 55 | capture | 01a19622-f86b-7768-bb40-5822daac5593 | €35.00 | €0.50 | matched |
| 56 | capture | 01a19622-fa57-7140-a305-de9b8c68ccef | €35.00 | €0.50 | matched |
| 57 | capture | 01a19623-05ac-7229-b842-15f5c426b447 | €24.00 | €0.37 | matched |
| 58 | capture | 01a19623-1838-7e2e-8e27-f18599e186e3 | €9.00 | €0.19 | matched |
| 59 | capture | 01a19623-1b90-718d-9a10-d3b7e7e8d3f0 | €9.00 | €0.19 | matched |
| 60 | capture | 01a19623-2bd2-7315-bd0e-1e83dede8546 | €9.00 | €0.19 | matched |
| 61 | capture | 01a19623-5640-7252-bc93-edda0461a915 | €15.00 | €0.26 | matched |
| 62 | capture | 01a19623-6dd4-7673-b9d8-c12a57021266 | €15.00 | €0.26 | matched |
| 63 | capture | 01a19623-89cf-72df-b6d7-112cd82dd0e4 | €49.00 | €0.67 | matched |
| 64 | capture | 01a19623-9df9-79b9-a81a-313ce5f606ab | €35.00 | €0.50 | matched |
| 65 | capture | 01a19623-c46b-7309-b9ae-9f1af7006ed9 | €9.00 | €0.19 | matched |
| 66 | capture | 01a19623-dd8a-78e8-9693-eda6898079cd | €49.00 | €0.67 | matched |
| 67 | capture | 01a19624-1017-77fc-a00d-29a11dc1f7a9 | €24.00 | €0.37 | matched |
| 68 | capture | 01a19624-2227-752d-83c6-f5499026a5d2 | €35.00 | €0.50 | matched |
| 69 | capture | 01a19624-332d-70fd-889f-c0000891f217 | €49.00 | €0.67 | matched |
| 70 | capture | 01a19624-3446-764d-8e87-89f5aa9182a9 | €49.00 | €0.67 | matched |
| 71 | capture | 01a19624-4929-733d-83db-fca71e8b06a6 | €24.00 | €0.37 | matched |
| 72 | capture | 01a19624-493c-73d0-9caa-c94430ac71fa | €9.00 | €0.19 | matched |
| 73 | capture | 01a19624-5ffd-76df-95bf-40594efa041d | €49.00 | €0.67 | matched |
| 74 | capture | 01a19624-74a1-7680-9518-793b29e8d7d1 | €35.00 | €0.50 | matched |
| 75 | capture | 01a19624-955b-768d-ae09-c5d9bd69e804 | €24.00 | €0.37 | matched |
| 76 | refund | 01a19624-9ffa-7e5d-8d9b-9b5b05ab1cff | -€3.00 | €0.00 | matched |
| 77 | capture | 01a19624-a4b3-742d-906b-73b1e4e07c7b | €24.00 | €0.37 | matched |
| 78 | refund | 01a19624-ca37-7e54-bc45-b72bf2d315e3 | -€20.00 | €0.00 | matched |
| 79 | capture | 01a19624-f7d0-776c-a317-c7ecb42da8a6 | €35.00 | €0.50 | matched |
| 80 | capture | 01a19625-0a83-7e27-a7ca-0ef75bcbffb2 | €9.00 | €0.19 | matched |
| 81 | capture | 01a19625-2af6-7723-8607-7b4e077fbeb2 | €24.00 | €0.37 | matched |
| 82 | capture | 01a19625-4c43-7fe1-8eb5-b206c9b55a17 | €15.00 | €0.26 | matched |
| 83 | capture | 01a19625-6b47-7eab-97cf-db4fb9aea890 | €9.00 | €0.19 | matched |
| 84 | capture | 01a19625-87f3-73a7-8534-d4ab9f1ac8ab | €15.00 | €0.26 | matched |
| 85 | capture | 01a19625-a926-7cd8-9d42-b37e7d4e4181 | €35.00 | €0.50 | matched |
| 86 | capture | 01a19625-b029-7238-b60c-61e2fba585b9 | €49.00 | €0.67 | matched |
| 87 | capture | 01a19625-b683-7367-83a0-0816206577d8 | €35.00 | €0.50 | matched |
| 88 | capture | 01a19625-db94-7dd2-9fe3-1e1dfdc22774 | €15.00 | €0.26 | matched |
| 89 | capture | 01a19625-e002-7de8-a48d-f31704d1c945 | €49.00 | €0.67 | matched |
| 90 | refund | 01a19626-0456-76c7-a699-7d34756f02d3 | -€13.00 | €0.00 | matched |
| 91 | capture | 01a19626-088b-73db-9315-b4c0a59eeed2 | €49.00 | €0.67 | matched |
| 92 | refund | 01a19626-0f0a-762b-a23d-460d592adee6 | -€46.00 | €0.00 | matched |
| 93 | capture | 01a19626-13fd-73c5-b860-7704ecf00cb8 | €35.00 | €0.50 | matched |
| 94 | capture | 01a19626-2598-7093-a3bd-c21394bcaf7f | €9.00 | €0.19 | matched |
| 95 | capture | 01a19626-2802-798a-b9f2-7668bc1c827b | €15.00 | €0.26 | matched |
| 96 | capture | 01a19626-2872-7371-832b-c0075c62b311 | €9.00 | €0.19 | matched |
| 97 | capture | 01a19626-3b27-71d5-9420-63e8be721342 | €24.00 | €0.37 | matched |
| 98 | capture | 01a19626-5794-715c-847c-0333ceee173d | €35.00 | €0.50 | matched |
| 99 | capture | 01a19626-5a16-7a18-9bca-02e4564766ef | €35.00 | €0.50 | matched |
| 100 | capture | 01a19626-986e-795f-b450-6127e6f06bf2 | €24.00 | €0.37 | matched |
| 101 | capture | 01a19626-bfe6-78a1-ade3-44da05cc46cb | €35.00 | €0.50 | matched |
| 102 | capture | 01a19626-c04a-7a9f-a1db-78490f89b45d | €9.00 | €0.19 | matched |
| 103 | capture | 01a19626-e9fc-727c-a90a-2e2fa634c412 | €9.00 | €0.19 | matched |
| 104 | capture | 01a19627-0104-7d46-8274-b2d97247247c | €15.00 | €0.26 | matched |
| 105 | capture | 01a19627-0af4-70e1-ad70-2cdf29ab49f2 | €24.00 | €0.37 | matched |
| 106 | capture | 01a19627-0ef3-7401-a04b-4d587226f849 | €15.00 | €0.26 | matched |
| 107 | capture | 01a19627-1766-7c3f-b631-00c731b4cb65 | €15.00 | €0.26 | matched |
| 108 | capture | 01a19627-19c1-75f4-9a6b-e49c2e28dbda | €9.00 | €0.19 | matched |
| 109 | capture | 01a19627-1f4f-7979-bf94-78c0fb0c0c1a | €24.00 | €0.37 | matched |
| 110 | capture | 01a19627-2177-70ea-bd9c-0c769912eacc | €35.00 | €0.50 | matched |
| 111 | capture | 01a19627-2ed4-7e4f-b702-b30b4a6011a0 | €49.00 | €0.67 | matched |
| 112 | capture | 01a19627-3a0b-7ef2-acc2-5ad2498b6904 | €35.00 | €0.50 | matched |
| 113 | capture | 01a19627-54ec-7a11-96f4-8673448ebcaa | €15.00 | €0.26 | matched |
| 114 | capture | 01a19627-803f-7c8d-bea9-43941157932f | €24.00 | €0.37 | matched |
| 115 | capture | 01a19627-8053-7961-a6d2-0be6f69eac10 | €24.00 | €0.37 | matched |
| 116 | capture | 01a19627-8c3c-7452-ba63-bfb87537c985 | €15.00 | €0.26 | matched |
| 117 | capture | 01a19627-be9c-73a6-9168-2a61f8e87741 | €15.00 | €0.26 | matched |
| 118 | capture | 01a19627-c193-75ef-acbf-32fdad61a76e | €24.00 | €0.37 | matched |
| 119 | capture | 01a19627-ec50-7224-8429-5e6357b4ff0a | €9.00 | €0.19 | matched |
| 120 | capture | 01a19627-f6f6-79da-abaf-669f680ecce8 | €35.00 | €0.50 | matched |
| 121 | capture | 01a19627-faa6-78e5-9d71-22de8a02700c | €49.00 | €0.67 | matched |
| 122 | capture | 01a19627-fde8-7888-a9eb-d8ba28a5baf4 | €9.00 | €0.19 | matched |
| 123 | capture | 01a19628-1b17-7680-8629-6c90fbdbc253 | €49.00 | €0.67 | matched |
| 124 | capture | 01a19628-5c15-7a77-b77f-a72e15fb83ed | €35.00 | €0.50 | matched |
| 125 | capture | 01a19628-63a8-7485-aac1-7a0a93b5ff7e | €24.00 | €0.37 | matched |
| 127 | capture | 01a19628-6902-7984-a321-b8fad214a903 | €9.00 | €0.19 | matched |
| 128 | capture | 01a19628-826c-7e93-9b31-ac8e0d2a62ca | €15.00 | €0.26 | matched |