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, 23:10133 lines3 breaks
- 14 Oct, 23:00156 lines2 breaks
- 14 Oct, 22:50126 lines3 breaks
- 14 Oct, 22:40101 lines1 break
- 14 Oct, 22:3091 lines2 breaks
- 14 Oct, 22:20122 lines2 breaks
- 14 Oct, 22:10115 lines2 breaks
- 14 Oct, 22:00138 lines1 break
- 14 Oct, 21:50111 lines3 breaks
- 14 Oct, 21:40113 lines4 breaks
- 14 Oct, 21:30122 lines2 breaks
- 14 Oct, 21:20124 linesclean
- 14 Oct, 21:10137 lines3 breaks
- 14 Oct, 21:00146 lines9 breaks
14 Oct, 21:40
Gross
€2,960.00
PSP fee
€44.99
Net to the bank
€2,915.01
Settlement journal
#3291
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13c5c-9641-7759-8523-7302a7e7d086 is already settled by stl_EUR_2986690 line 10
- duplicate linethe file lists it twicecapture:01a13c5d-0fc9-7c0f-99c4-390370dbb9b4 is already settled by stl_EUR_2986690 line 20
- fee differencethe fee is not the contract feethe fee is 29, the contract says 26
- missing linein the books, not in the filecapture:01a13c62-b027-7133-a0e7-61d16a110036 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 11 | capture | 01a13c5c-96c5-7de8-8633-d727cafc2849 | €49.00 | €0.67 | duplicate line |
| 21 | capture | 01a13c5d-0ff4-786e-8d7c-40b8b68a49b1 | €15.00 | €0.26 | duplicate line |
| 75 | capture | 01a13c61-9f99-74af-bad5-bd57b2eadf07 | €15.00 | €0.29 | fee difference |
| 1 | capture | 01a13c56-1133-725a-a3bc-cab1cac81ba1 | €35.00 | €0.50 | matched |
| 2 | capture | 01a13c5b-ad90-702c-8f97-80fa5913f629 | €49.00 | €0.67 | matched |
| 3 | capture | 01a13c5b-b387-76f2-af51-fe5748f85e1f | €35.00 | €0.50 | matched |
| 4 | capture | 01a13c5b-ee4c-733a-941a-695f81216582 | €35.00 | €0.50 | matched |
| 5 | capture | 01a13c5b-f266-79f0-8102-fa25eb7d3dec | €49.00 | €0.67 | matched |
| 6 | capture | 01a13c5b-fa37-7917-9897-63b717e3321d | €9.00 | €0.19 | matched |
| 7 | capture | 01a13c5c-3a74-7598-9e25-5c0dd6bd32f6 | €49.00 | €0.67 | matched |
| 8 | capture | 01a13c5c-4049-73a1-b76c-bb7be80c52d4 | €9.00 | €0.19 | matched |
| 9 | capture | 01a13c5c-42bf-70b3-8ebd-938b051e375b | €24.00 | €0.37 | matched |
| 10 | capture | 01a13c5c-96c5-7de8-8633-d727cafc2849 | €49.00 | €0.67 | matched |
| 12 | capture | 01a13c5c-a4c9-7fbe-ac0b-9e060bac21df | €35.00 | €0.50 | matched |
| 13 | capture | 01a13c5c-bac1-798b-989e-da61017e4463 | €15.00 | €0.26 | matched |
| 14 | capture | 01a13c5c-cc2c-7a59-9c2a-5815795f5bac | €15.00 | €0.26 | matched |
| 15 | capture | 01a13c5c-cf10-73b6-9999-f53c522d6e85 | €49.00 | €0.67 | matched |
| 16 | capture | 01a13c5c-f2d6-734d-b3b8-209af5fb102f | €15.00 | €0.26 | matched |
| 17 | capture | 01a13c5c-f404-7bd5-8e74-234ccae6908e | €24.00 | €0.37 | matched |
| 18 | capture | 01a13c5c-f9f9-71f6-aa06-1855ac085e01 | €24.00 | €0.37 | matched |
| 19 | capture | 01a13c5d-0348-71c5-8214-995f518fec7e | €15.00 | €0.26 | matched |
| 20 | capture | 01a13c5d-0ff4-786e-8d7c-40b8b68a49b1 | €15.00 | €0.26 | matched |
| 22 | capture | 01a13c5d-1e8c-7117-ab29-9917b31b0f35 | €35.00 | €0.50 | matched |
| 23 | capture | 01a13c5d-27f9-744a-ac0b-4e7e2f916d8e | €35.00 | €0.50 | matched |
| 24 | capture | 01a13c5d-28f2-7920-a3a3-8b17b1480c00 | €15.00 | €0.26 | matched |
| 25 | capture | 01a13c5d-b5dc-7f70-92d0-00704a47412d | €35.00 | €0.50 | matched |
| 26 | capture | 01a13c5d-b6a2-749f-b3b7-0a63707e0e9c | €15.00 | €0.26 | matched |
| 27 | capture | 01a13c5d-c789-7080-8a56-62470dcea6d0 | €15.00 | €0.26 | matched |
| 28 | capture | 01a13c5d-d7c4-70f8-8701-390f466f4e1c | €49.00 | €0.67 | matched |
| 29 | capture | 01a13c5d-df0d-7944-878c-77ef3273d724 | €24.00 | €0.37 | matched |
| 30 | refund | 01a13c5d-e030-75da-ae9c-dff92524095e | -€6.00 | €0.00 | matched |
| 31 | capture | 01a13c5d-eb6f-72de-bbb2-174c9d7050d5 | €49.00 | €0.67 | matched |
| 32 | capture | 01a13c5e-054f-78d9-bd38-ae9529b3617b | €24.00 | €0.37 | matched |
| 33 | capture | 01a13c5e-1db6-78a5-94a8-cadb1afc7e00 | €24.00 | €0.37 | matched |
| 34 | capture | 01a13c5e-2270-78d8-96cc-ee894e827fc0 | €15.00 | €0.26 | matched |
| 35 | capture | 01a13c5e-3ce6-77f7-88c4-59b0c9c3c813 | €49.00 | €0.67 | matched |
| 36 | capture | 01a13c5e-74ae-7721-89ec-1d3144da8c17 | €24.00 | €0.37 | matched |
| 37 | capture | 01a13c5e-9681-70c6-9338-d248c735ef05 | €49.00 | €0.67 | matched |
| 38 | capture | 01a13c5e-99d9-7277-b0eb-1bf9712bfb0e | €15.00 | €0.26 | matched |
| 39 | capture | 01a13c5e-96f0-79de-adc2-4cb4e41ff0b9 | €24.00 | €0.37 | matched |
| 40 | capture | 01a13c5e-db4c-75d1-8ab8-c516f9000ef0 | €24.00 | €0.37 | matched |
| 41 | capture | 01a13c5e-f16d-7726-a678-81b096a73bfb | €24.00 | €0.37 | matched |
| 42 | capture | 01a13c5e-f559-79f2-9711-49e1f10edf7c | €49.00 | €0.67 | matched |
| 43 | capture | 01a13c5e-fa8a-7814-86cc-3051d78e90fe | €9.00 | €0.19 | matched |
| 44 | capture | 01a13c5f-033a-7079-abc6-e0eea9b01ff3 | €9.00 | €0.19 | matched |
| 45 | capture | 01a13c5f-0bf4-7f6d-bc99-48606ee9852f | €9.00 | €0.19 | matched |
| 46 | capture | 01a13c5f-1991-7222-9679-adac88e9a234 | €24.00 | €0.37 | matched |
| 47 | capture | 01a13c5f-27b3-7044-adde-cbe53afaf3ef | €49.00 | €0.67 | matched |
| 48 | capture | 01a13c5f-2b6d-7f58-a233-706f5f2466c4 | €15.00 | €0.26 | matched |
| 49 | capture | 01a13c5f-3da2-7820-89f6-33c60a65c62f | €49.00 | €0.67 | matched |
| 50 | refund | 01a13c5f-60d9-7f85-9311-f60fb2ac58c2 | -€8.00 | €0.00 | matched |
| 51 | capture | 01a13c5f-6f9d-7b28-bd6e-64ffb1278770 | €24.00 | €0.37 | matched |
| 52 | capture | 01a13c5f-961f-73c5-9952-f76ff8037ef8 | €15.00 | €0.26 | matched |
| 53 | capture | 01a13c5f-bbcd-7f3c-b534-2ea4e7d3ceed | €15.00 | €0.26 | matched |
| 54 | capture | 01a13c5f-ce0e-796a-9175-4c58f2abecd1 | €24.00 | €0.37 | matched |
| 55 | capture | 01a13c5f-d874-7e00-abf3-ea143c98fa92 | €49.00 | €0.67 | matched |
| 56 | capture | 01a13c60-3a43-7e79-af82-c3b08aac36c5 | €35.00 | €0.50 | matched |
| 57 | capture | 01a13c60-5ada-7182-a9c9-cb03ba19de3c | €49.00 | €0.67 | matched |
| 58 | capture | 01a13c60-5e19-7413-893c-48a7ace7bd03 | €49.00 | €0.67 | matched |
| 59 | capture | 01a13c60-5e9f-7005-aa4d-eac6584cd4ff | €9.00 | €0.19 | matched |
| 60 | capture | 01a13c60-75e7-7b07-adc6-fc2a6597d874 | €49.00 | €0.67 | matched |
| 61 | capture | 01a13c60-79cc-7f64-8c50-068057e8a54e | €24.00 | €0.37 | matched |
| 62 | capture | 01a13c60-7d0f-7773-882a-76b324cfe12f | €15.00 | €0.26 | matched |
| 63 | capture | 01a13c60-8311-7ad8-bbf5-feeabc03f674 | €9.00 | €0.19 | matched |
| 64 | capture | 01a13c60-c6e8-7b1a-9d11-b0ce59bc6aa3 | €24.00 | €0.37 | matched |
| 65 | capture | 01a13c60-d9ff-7cfc-881a-2aa212285f48 | €24.00 | €0.37 | matched |
| 66 | capture | 01a13c60-eecd-72f4-abc8-273ee7aa2def | €15.00 | €0.26 | matched |
| 67 | capture | 01a13c60-fbfb-7b32-b98f-6b867132dbf2 | €9.00 | €0.19 | matched |
| 68 | capture | 01a13c61-029e-7e85-8c2e-3fed04678797 | €24.00 | €0.37 | matched |
| 69 | capture | 01a13c61-14eb-70ae-9fe5-214fb2478197 | €24.00 | €0.37 | matched |
| 70 | capture | 01a13c61-379e-773a-b8fc-5f91911508e0 | €35.00 | €0.50 | matched |
| 71 | capture | 01a13c61-80c7-7dfd-9000-950bf4238f51 | €49.00 | €0.67 | matched |
| 72 | capture | 01a13c61-8450-7ad6-a2bf-26f0328b2490 | €15.00 | €0.26 | matched |
| 73 | capture | 01a13c61-90f5-799d-91fe-71b509dafd88 | €9.00 | €0.19 | matched |
| 74 | capture | 01a13c61-9a64-7b0f-a214-26c758aaf163 | €9.00 | €0.19 | matched |
| 76 | capture | 01a13c61-de5f-78cd-94fe-73789bc4b2ac | €35.00 | €0.50 | matched |
| 77 | capture | 01a13c62-097e-7af1-bce0-1aaf5027ab3a | €15.00 | €0.26 | matched |
| 78 | capture | 01a13c62-1217-7c85-b0dd-f056e6ba8f81 | €15.00 | €0.26 | matched |
| 79 | capture | 01a13c62-12f3-7b66-9194-7c50d513b23b | €49.00 | €0.67 | matched |
| 80 | capture | 01a13c62-2ce6-7b1f-a915-334d211eecc9 | €9.00 | €0.19 | matched |
| 81 | capture | 01a13c62-631a-71e3-a612-9908f1b1e248 | €24.00 | €0.37 | matched |
| 82 | capture | 01a13c62-66cb-7d92-9c22-65749352cdcd | €9.00 | €0.19 | matched |
| 83 | capture | 01a13c62-7e7b-7419-8542-27ec49298350 | €24.00 | €0.37 | matched |
| 84 | capture | 01a13c62-c1cf-71ad-880d-a9090a01d42c | €15.00 | €0.26 | matched |
| 85 | capture | 01a13c62-d97c-7c45-bfe7-6d578bd0c6af | €24.00 | €0.37 | matched |
| 86 | capture | 01a13c62-dd85-71c2-86b1-72f220281ed7 | €49.00 | €0.67 | matched |
| 87 | capture | 01a13c62-ed21-7160-b064-1a88b0835891 | €15.00 | €0.26 | matched |
| 88 | refund | 01a13c63-0b6e-7200-a3c8-c16675dd82fc | -€33.00 | €0.00 | matched |
| 89 | refund | 01a13c63-2c77-7857-8912-0b29d949211b | -€3.00 | €0.00 | matched |
| 90 | capture | 01a13c63-3266-7d92-a1ed-01dde6d35cd2 | €49.00 | €0.67 | matched |
| 91 | capture | 01a13c63-3df9-7be0-9820-8f3ef423e553 | €35.00 | €0.50 | matched |
| 92 | capture | 01a13c63-4617-7db3-9206-f5cc5f728270 | €49.00 | €0.67 | matched |
| 93 | capture | 01a13c63-53ee-7f20-8188-9729a8043138 | €9.00 | €0.19 | matched |
| 94 | capture | 01a13c63-60d1-7bea-afb8-7fbb8a4951a9 | €15.00 | €0.26 | matched |
| 95 | capture | 01a13c63-65b4-7f2b-aa4d-339bc2417b12 | €49.00 | €0.67 | matched |
| 96 | capture | 01a13c63-9652-71ba-95d5-34d1c4024063 | €35.00 | €0.50 | matched |
| 97 | refund | 01a13c63-9da0-7638-8ac0-1536dc6233fc | -€5.00 | €0.00 | matched |
| 98 | capture | 01a13c63-d6b7-7b7b-8241-1ee3532bc033 | €24.00 | €0.37 | matched |
| 99 | capture | 01a13c63-fc20-7fe7-94cc-73d8d91f84d5 | €49.00 | €0.67 | matched |
| 100 | capture | 01a13c63-fd88-7545-b03d-f8d420c3644c | €49.00 | €0.67 | matched |
| 101 | capture | 01a13c63-fdc0-75e3-8a69-83e6cd134850 | €24.00 | €0.37 | matched |
| 102 | capture | 01a13c64-1398-7912-8960-274ae2ecf7a6 | €24.00 | €0.37 | matched |
| 103 | capture | 01a13c64-292d-7582-ae2b-4bc2511b6558 | €9.00 | €0.19 | matched |
| 104 | capture | 01a13c64-2b85-7ccb-b181-83354236cc3e | €49.00 | €0.67 | matched |
| 105 | capture | 01a13c64-36e4-7682-8ba3-df4fab3ebf2f | €24.00 | €0.37 | matched |
| 106 | capture | 01a13c64-5bbc-7170-b214-d151ad5da2ad | €35.00 | €0.50 | matched |
| 107 | capture | 01a13c64-6b74-7353-b4db-ea2dcc1a5ac5 | €9.00 | €0.19 | matched |
| 108 | capture | 01a13c64-70ae-79b7-a2ee-fa52a5a4a690 | €15.00 | €0.26 | matched |
| 109 | capture | 01a13c64-9cf4-7c37-9d80-34d55ec72d58 | €9.00 | €0.19 | matched |
| 110 | capture | 01a13c64-9d4a-7e95-8fef-70acd766a9c6 | €35.00 | €0.50 | matched |
| 111 | capture | 01a13c64-a19e-71f8-93cc-e874cc3e7205 | €49.00 | €0.67 | matched |
| 112 | capture | 01a13c64-bc20-7129-9f6f-21bfbb236c42 | €49.00 | €0.67 | matched |
| 113 | capture | 01a13c64-c2d0-7d1c-8af1-574584265ea6 | €49.00 | €0.67 | matched |