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:10122 linesclean
- 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, 18:00140 lines3 breaks
14 Oct, 18:20
Gross
€2,658.00
PSP fee
€42.80
Net to the bank
€2,615.20
Settlement journal
#788
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13ba5-c47e-7948-b7ca-4fde3101be25 is already settled by stl_EUR_2986670 line 20
- fee differencethe fee is not the contract feethe fee is 20, the contract says 19
- missing linein the books, not in the filecapture:01a13ba6-312f-78db-bf2f-3ad30b921dc1 is in no file
- missing linein the books, not in the filecapture:01a13baa-61db-7efb-9012-5e1f35ff591b is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 21 | capture | 01a13ba5-c4f3-7072-a6f5-3c0f7753f492 | €9.00 | €0.19 | duplicate line |
| 78 | capture | 01a13ba9-615b-709d-b531-6a71c020468f | €9.00 | €0.20 | fee difference |
| 1 | capture | 01a13ba4-899f-7974-b9c6-d53d5542d8f4 | €35.00 | €0.50 | matched |
| 2 | capture | 01a13ba4-c4db-7406-b2df-47f54b1313ab | €49.00 | €0.67 | matched |
| 3 | capture | 01a13ba4-d24b-7049-a8b9-48efaa1c959c | €9.00 | €0.19 | matched |
| 4 | capture | 01a13ba4-d832-7aec-a0bd-8630c1cf7367 | €35.00 | €0.50 | matched |
| 5 | capture | 01a13ba5-110d-7fb9-a9f4-d9805400bb7d | €49.00 | €0.67 | matched |
| 6 | capture | 01a13ba5-12ca-72d5-8643-4f644c4efd84 | €9.00 | €0.19 | matched |
| 7 | capture | 01a13ba5-40d0-73ec-8ae0-b46a98fe2776 | €35.00 | €0.50 | matched |
| 8 | capture | 01a13ba5-40da-725c-8b6f-8aad2bae9133 | €49.00 | €0.67 | matched |
| 9 | capture | 01a13ba5-426b-74ec-ac40-b912788f44d4 | €15.00 | €0.26 | matched |
| 10 | capture | 01a13ba5-4282-7cba-a962-d3dd2f38929a | €9.00 | €0.19 | matched |
| 11 | capture | 01a13ba5-46c8-7275-94a3-d6a908f2c6e5 | €49.00 | €0.67 | matched |
| 12 | capture | 01a13ba5-508a-7891-8e3f-d38078b05514 | €24.00 | €0.37 | matched |
| 13 | capture | 01a13ba5-5208-7358-bdd3-4b25e8ef643a | €35.00 | €0.50 | matched |
| 14 | capture | 01a13ba5-6bc5-7faf-8501-f9bca76555ca | €15.00 | €0.26 | matched |
| 15 | capture | 01a13ba5-93f1-748b-b273-79a4c4bd967f | €49.00 | €0.67 | matched |
| 16 | capture | 01a13ba5-a83f-7284-8741-fe75bf5b68b7 | €49.00 | €0.67 | matched |
| 17 | capture | 01a13ba5-b2de-7080-9a96-5b39a3b1aa14 | €49.00 | €0.67 | matched |
| 18 | capture | 01a13ba5-b40f-70ab-bc09-3e21de9e201c | €24.00 | €0.37 | matched |
| 19 | capture | 01a13ba5-c22b-70c6-adfe-4e908cf3a1db | €35.00 | €0.50 | matched |
| 20 | capture | 01a13ba5-c4f3-7072-a6f5-3c0f7753f492 | €9.00 | €0.19 | matched |
| 22 | capture | 01a13ba5-d297-73ef-b66b-0e1d5ada58fa | €9.00 | €0.19 | matched |
| 23 | capture | 01a13ba5-f168-7076-a036-32d5dcce643d | €9.00 | €0.19 | matched |
| 24 | capture | 01a13ba5-f3eb-7d29-a500-273df1a8e5fe | €24.00 | €0.37 | matched |
| 25 | capture | 01a13ba5-f6a7-7b16-bfa9-496d43ad6129 | €9.00 | €0.19 | matched |
| 26 | capture | 01a13ba6-085a-7d02-b8e1-4b17e82514b5 | €9.00 | €0.19 | matched |
| 27 | capture | 01a13ba6-0883-79c5-8ff6-ab140dbb1414 | €24.00 | €0.37 | matched |
| 28 | capture | 01a13ba6-0a38-75e3-8c40-44fb7c8ed728 | €9.00 | €0.19 | matched |
| 29 | capture | 01a13ba6-3e2e-7311-9450-367744ed1e4f | €24.00 | €0.37 | matched |
| 30 | capture | 01a13ba6-40d8-7ff2-aeef-a46f89221948 | €35.00 | €0.50 | matched |
| 31 | capture | 01a13ba6-4b05-7b13-92ba-035023de1662 | €35.00 | €0.50 | matched |
| 32 | capture | 01a13ba6-9b2f-785f-ae5f-53e332383de6 | €9.00 | €0.19 | matched |
| 33 | capture | 01a13ba6-a354-7302-bb48-4f0ad9814d2e | €35.00 | €0.50 | matched |
| 34 | capture | 01a13ba6-a63c-74b8-93b3-30cd2887463c | €9.00 | €0.19 | matched |
| 35 | capture | 01a13ba6-ad3c-7d8b-9ec8-c1e4e96c3767 | €15.00 | €0.26 | matched |
| 36 | capture | 01a13ba6-ae92-7b49-8c23-36bda86b20b5 | €9.00 | €0.19 | matched |
| 37 | capture | 01a13ba6-e538-77f5-89da-404db1cc8985 | €9.00 | €0.19 | matched |
| 38 | capture | 01a13ba6-f492-7d39-8646-d23d31d58538 | €15.00 | €0.26 | matched |
| 39 | capture | 01a13ba6-f6f4-7d2a-8fbc-b6752e73be62 | €9.00 | €0.19 | matched |
| 40 | capture | 01a13ba6-f95b-7ea3-8846-b470f839337c | €15.00 | €0.26 | matched |
| 41 | capture | 01a13ba7-026c-7d65-be5a-18e2043a5259 | €15.00 | €0.26 | matched |
| 42 | capture | 01a13ba7-0f18-7e6b-9a80-0b4de6f2e2f7 | €15.00 | €0.26 | matched |
| 43 | refund | 01a13ba7-3ef0-7526-b65c-8444ab45c2cd | -€10.00 | €0.00 | matched |
| 44 | capture | 01a13ba7-41e8-7a9d-9d0b-70c6ede9b321 | €9.00 | €0.19 | matched |
| 45 | capture | 01a13ba7-5013-75a4-bee1-889d301fcf27 | €49.00 | €0.67 | matched |
| 46 | capture | 01a13ba7-51b0-7ec0-b574-390e522eb812 | €35.00 | €0.50 | matched |
| 47 | capture | 01a13ba7-5441-7c0a-a78e-d3770d4f9827 | €49.00 | €0.67 | matched |
| 48 | capture | 01a13ba7-6d0b-7fcd-9314-1da8f2eab6c4 | €35.00 | €0.50 | matched |
| 49 | capture | 01a13ba7-75c0-733a-8dac-705986e45b14 | €49.00 | €0.67 | matched |
| 50 | capture | 01a13ba7-7946-7af1-8f65-1911f7847e11 | €9.00 | €0.19 | matched |
| 51 | capture | 01a13ba7-8178-788b-8fae-04e3c5254ee4 | €9.00 | €0.19 | matched |
| 52 | capture | 01a13ba7-867a-79ab-8138-e8368555d413 | €15.00 | €0.26 | matched |
| 53 | capture | 01a13ba7-8dca-74da-9f98-28b69f1dab2d | €15.00 | €0.26 | matched |
| 54 | capture | 01a13ba7-9393-7ebc-bfcb-74b97ea84d68 | €49.00 | €0.67 | matched |
| 55 | capture | 01a13ba7-98ee-7ef3-8dff-d210768652a0 | €15.00 | €0.26 | matched |
| 56 | refund | 01a13ba7-b350-7444-9718-5ae9b0eb67b2 | -€38.00 | €0.00 | matched |
| 57 | refund | 01a13ba7-bbdb-78f1-a3f8-b2f88593817d | -€14.00 | €0.00 | matched |
| 58 | capture | 01a13ba7-e2cb-7f74-98d8-9b37c3de430d | €24.00 | €0.37 | matched |
| 59 | capture | 01a13ba7-e2d9-756d-881c-40f9e2b4c1aa | €49.00 | €0.67 | matched |
| 60 | capture | 01a13ba7-f0c5-7411-bd8f-ee3b8b904f46 | €15.00 | €0.26 | matched |
| 61 | capture | 01a13ba8-04f7-7427-bcd3-e589d379db70 | €15.00 | €0.26 | matched |
| 62 | capture | 01a13ba8-3458-7703-a113-505e83e66d22 | €15.00 | €0.26 | matched |
| 63 | capture | 01a13ba8-42d4-722f-88a8-e707e10f7ebe | €9.00 | €0.19 | matched |
| 64 | capture | 01a13ba8-4bf9-7df2-8cce-29da9dc2e687 | €35.00 | €0.50 | matched |
| 65 | capture | 01a13ba8-4bf7-7109-b141-74a8723238e7 | €15.00 | €0.26 | matched |
| 66 | capture | 01a13ba8-50f2-7841-bd13-db4597aa2b30 | €49.00 | €0.67 | matched |
| 67 | capture | 01a13ba8-8e5f-7940-9bc3-513447082eb9 | €35.00 | €0.50 | matched |
| 68 | capture | 01a13ba8-9242-7b29-85c1-e286915aaf6d | €24.00 | €0.37 | matched |
| 69 | capture | 01a13ba8-a996-7ce0-842a-9d92fab3687f | €24.00 | €0.37 | matched |
| 70 | capture | 01a13ba8-c700-757c-a470-2deaa1f237a6 | €9.00 | €0.19 | matched |
| 71 | capture | 01a13ba8-cbe5-7eb0-abe5-13e0f5e91838 | €24.00 | €0.37 | matched |
| 72 | capture | 01a13ba8-e067-71a2-80f7-b5c730a5b118 | €35.00 | €0.50 | matched |
| 73 | capture | 01a13ba8-f395-7103-817f-220350023ab7 | €15.00 | €0.26 | matched |
| 74 | refund | 01a13ba9-14db-7062-a0fb-26c3c29c0913 | -€13.00 | €0.00 | matched |
| 75 | capture | 01a13ba9-3619-76ca-94f5-592d968c2ae2 | €24.00 | €0.37 | matched |
| 76 | capture | 01a13ba9-2218-7c76-b35e-9388f3b8d013 | €9.00 | €0.19 | matched |
| 77 | capture | 01a13ba9-4e38-749c-a24b-835c2546f924 | €15.00 | €0.26 | matched |
| 79 | capture | 01a13ba9-7dca-73d0-a2dd-e28a19f44b90 | €35.00 | €0.50 | matched |
| 80 | refund | 01a13ba9-83ce-7da6-accd-d9951094cf3c | -€3.00 | €0.00 | matched |
| 81 | capture | 01a13ba9-907e-7238-aa6e-873ff039ebf5 | €24.00 | €0.37 | matched |
| 82 | capture | 01a13ba9-91c8-7da6-bda3-ac331a205038 | €15.00 | €0.26 | matched |
| 83 | capture | 01a13ba9-a616-7763-8f05-d4d7ee95e699 | €24.00 | €0.37 | matched |
| 84 | capture | 01a13ba9-ab43-7fa9-95e2-d8001cec46d3 | €9.00 | €0.19 | matched |
| 85 | capture | 01a13ba9-ac8b-72a9-ba3d-9a93fff24e1c | €15.00 | €0.26 | matched |
| 86 | capture | 01a13ba9-b69a-7b81-bf53-e27649587378 | €35.00 | €0.50 | matched |
| 87 | refund | 01a13ba9-c9c8-73fe-8611-5472bc92f334 | -€3.00 | €0.00 | matched |
| 88 | capture | 01a13ba9-d7cd-7fa5-89d3-c34cf1a11425 | €9.00 | €0.19 | matched |
| 89 | capture | 01a13baa-15d7-74bf-bc35-89d7eabe0a2b | €49.00 | €0.67 | matched |
| 90 | capture | 01a13baa-3956-7fc6-a30a-6767e74413bd | €35.00 | €0.50 | matched |
| 91 | capture | 01a13baa-4365-78be-8857-3833254192f8 | €35.00 | €0.50 | matched |
| 92 | refund | 01a13baa-68ef-76b5-ab58-7ba313f83902 | -€20.00 | €0.00 | matched |
| 93 | capture | 01a13baa-6d11-7611-a8e1-789509f260f7 | €24.00 | €0.37 | matched |
| 94 | capture | 01a13baa-7a86-7e0e-9250-1c5ed665c211 | €24.00 | €0.37 | matched |
| 95 | capture | 01a13baa-9818-796e-95b9-fbec5d7525c9 | €35.00 | €0.50 | matched |
| 96 | capture | 01a13baa-cfee-7562-9002-c2fb9f265f18 | €15.00 | €0.26 | matched |
| 97 | capture | 01a13baa-fca1-79f7-bea3-18a09fcfbe4d | €24.00 | €0.37 | matched |
| 98 | capture | 01a13bab-2a5e-76ee-95f4-f93177a598ac | €15.00 | €0.26 | matched |
| 99 | capture | 01a13bab-357f-7cbf-9efd-d3e5bd540e3d | €15.00 | €0.26 | matched |
| 100 | capture | 01a13bab-3a0b-7ca1-b60b-7210f49c296d | €49.00 | €0.67 | matched |
| 101 | refund | 01a13bab-716d-789b-b88a-494ec697c014 | -€9.00 | €0.00 | matched |
| 102 | capture | 01a13bab-7e73-7d8f-a9a5-a3680cdf3f25 | €9.00 | €0.19 | matched |
| 103 | capture | 01a13bab-c13f-7e0c-97a3-54274a157de7 | €9.00 | €0.19 | matched |
| 104 | capture | 01a13bab-cb9d-771f-8c12-3d46a0effa30 | €24.00 | €0.37 | matched |
| 105 | capture | 01a13bab-dd9f-7557-bbfe-f626d20a6286 | €49.00 | €0.67 | matched |
| 106 | refund | 01a13bab-eac2-77bc-919e-fb8cd0a9a38f | -€2.00 | €0.00 | matched |
| 107 | capture | 01a13bab-f834-75cd-a8c3-4ba6a8abbd00 | €9.00 | €0.19 | matched |
| 108 | capture | 01a13bab-f372-7277-936d-fd746cf0ba5d | €35.00 | €0.50 | matched |
| 109 | capture | 01a13bab-fdd8-76dd-8c26-4c42b1b0580c | €9.00 | €0.19 | matched |
| 110 | refund | 01a13bac-5988-706e-a93c-cf918de9914f | -€18.00 | €0.00 | matched |
| 111 | capture | 01a13bac-7890-7bdf-9d65-9bec2d9d590a | €35.00 | €0.50 | matched |
| 112 | capture | 01a13bac-7f9f-7e48-80c9-6ae55c69b071 | €9.00 | €0.19 | matched |
| 113 | capture | 01a13bac-85fc-71aa-85b9-4693bbe3b878 | €24.00 | €0.37 | matched |
| 114 | capture | 01a13bac-8c4d-7d7d-a5aa-e26c437acefb | €49.00 | €0.67 | matched |
| 115 | capture | 01a13bac-9ade-7514-8350-dc972f1ff028 | €24.00 | €0.37 | matched |
| 116 | capture | 01a13bac-ac16-7403-bb5c-fc17af3476af | €49.00 | €0.67 | matched |
| 117 | capture | 01a13bac-ae99-7ab9-ba65-4817b95baf0a | €35.00 | €0.50 | matched |
| 118 | capture | 01a13bac-bf43-7498-b740-eb3c6e785fd1 | €15.00 | €0.26 | matched |
| 119 | capture | 01a13bac-d745-7f54-b24b-01a743fe3735 | €15.00 | €0.26 | matched |
| 120 | capture | 01a13bac-ecc0-7cc2-af5f-b45e5ea90569 | €15.00 | €0.26 | matched |
| 121 | capture | 01a13bad-3c52-7f6d-97a8-af41a466fb72 | €35.00 | €0.50 | matched |
| 122 | capture | 01a13bad-4f31-7cb4-8526-3cc2d620e660 | €9.00 | €0.19 | matched |
| 123 | capture | 01a13bad-5f81-79b8-920f-6fb5c343025c | €24.00 | €0.37 | matched |
| 124 | capture | 01a13bad-6cad-7ff0-a21e-c15a1cb048e2 | €35.00 | €0.50 | matched |
| 125 | capture | 01a13bad-979d-7529-8d49-f39eab90b3d3 | €15.00 | €0.26 | matched |