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
- 28 Oct, 23:40143 lines2 breaks
- 28 Oct, 23:30141 lines1 break
- 28 Oct, 23:20130 lines1 break
- 28 Oct, 23:10137 linesclean
- 28 Oct, 23:00120 lines3 breaks
- 28 Oct, 22:50117 lines1 break
- 28 Oct, 22:40126 lines1 break
- 28 Oct, 22:30114 lines3 breaks
- 28 Oct, 22:20127 lines4 breaks
- 28 Oct, 22:10100 lines2 breaks
- 28 Oct, 22:00148 lines2 breaks
- 28 Oct, 21:50121 lines1 break
- 28 Oct, 21:40134 linesclean
- 28 Oct, 21:30114 lines2 breaks
28 Oct, 22:00
Gross
€3,457.00
PSP fee
€54.40
Net to the bank
€3,402.60
Settlement journal
#258633
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18487-537c-74c5-94b3-315f3e173340 is already settled by stl_EUR_2988708 line 7
- missing linein the books, not in the filecapture:01a1848d-11c0-7270-89a6-8ce14476c02a is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 8 | capture | 01a18487-5772-7575-9b85-c6d5b93db00c | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a18482-8f5c-72cb-a607-086b0a128e98 | €9.00 | €0.19 | matched |
| 2 | capture | 01a18483-da0b-7d0c-8e1c-4b162c152468 | €9.00 | €0.19 | matched |
| 3 | capture | 01a18487-2752-7937-afe7-c14989a30eba | €15.00 | €0.26 | matched |
| 4 | capture | 01a18487-29f7-714e-97b7-bc34367c9c02 | €49.00 | €0.67 | matched |
| 5 | capture | 01a18487-4692-7f58-96bf-0e5382cb0f2e | €24.00 | €0.37 | matched |
| 6 | capture | 01a18487-50a0-70df-b36a-6d67fd611d46 | €24.00 | €0.37 | matched |
| 7 | capture | 01a18487-5772-7575-9b85-c6d5b93db00c | €24.00 | €0.37 | matched |
| 9 | capture | 01a18487-6022-79e6-943b-a9c2bae70cf5 | €9.00 | €0.19 | matched |
| 10 | capture | 01a18487-6a88-70c4-ae25-a7a83d290463 | €15.00 | €0.26 | matched |
| 11 | capture | 01a18487-736f-767a-b834-3ea418270c2f | €24.00 | €0.37 | matched |
| 12 | capture | 01a18487-82f2-75f1-9777-74df68a2a194 | €15.00 | €0.26 | matched |
| 13 | capture | 01a18487-8702-75d4-8cfe-008e39e5a39e | €9.00 | €0.19 | matched |
| 14 | capture | 01a18487-c1f2-784e-b08a-829fcd7bfd12 | €35.00 | €0.50 | matched |
| 15 | capture | 01a18487-cc3c-7265-a625-24ad1c3567df | €15.00 | €0.26 | matched |
| 16 | refund | 01a18487-c7f2-787d-be8d-bb7ac81e0392 | -€4.00 | €0.00 | matched |
| 17 | capture | 01a18487-d6eb-7320-a619-7dbb7b0cbda1 | €35.00 | €0.50 | matched |
| 18 | capture | 01a18487-e4d8-7d7e-88b6-b405236f53ec | €49.00 | €0.67 | matched |
| 19 | refund | 01a18487-f030-7582-979f-4b3333fff747 | -€12.00 | €0.00 | matched |
| 20 | capture | 01a18488-17c5-7a8a-acbe-dccf98b153f1 | €35.00 | €0.50 | matched |
| 21 | capture | 01a18488-20a7-78f7-a58c-607b7d8fc716 | €9.00 | €0.19 | matched |
| 22 | capture | 01a18488-33f4-749e-94f1-b677290d0d3a | €49.00 | €0.67 | matched |
| 23 | capture | 01a18488-33f2-7d15-a04f-e84677523980 | €15.00 | €0.26 | matched |
| 24 | capture | 01a18488-39e8-789d-84b5-471efc0e3ad8 | €9.00 | €0.19 | matched |
| 25 | capture | 01a18488-3f87-7cb3-a8ef-0fe50260ac31 | €35.00 | €0.50 | matched |
| 26 | capture | 01a18488-470b-7cf1-b38a-31bc7577a170 | €24.00 | €0.37 | matched |
| 27 | capture | 01a18488-51a4-74be-b618-ebea0a59a032 | €35.00 | €0.50 | matched |
| 28 | refund | 01a18488-710f-74c8-927e-f0f15498c57d | -€7.00 | €0.00 | matched |
| 29 | capture | 01a18488-746c-71ae-aea1-3984f942033d | €35.00 | €0.50 | matched |
| 30 | capture | 01a18488-773a-7c6a-9c2c-04c389b2e1bb | €35.00 | €0.50 | matched |
| 31 | capture | 01a18488-8088-7c35-abe1-c5e70021c66c | €9.00 | €0.19 | matched |
| 32 | capture | 01a18488-87f4-737f-89b8-94d7fa3ef692 | €49.00 | €0.67 | matched |
| 33 | capture | 01a18488-91bb-72fe-a699-7ef52b3e3022 | €15.00 | €0.26 | matched |
| 34 | capture | 01a18488-a5f5-7e18-a932-20f5867f32e9 | €24.00 | €0.37 | matched |
| 35 | capture | 01a18488-b338-73de-821f-92a7315ffce9 | €49.00 | €0.67 | matched |
| 36 | capture | 01a18488-c1e3-76af-b38b-c9cb697ef69f | €24.00 | €0.37 | matched |
| 37 | capture | 01a18488-c301-7d1e-8a59-f23af334d1c2 | €15.00 | €0.26 | matched |
| 38 | refund | 01a18488-c81f-7a52-be48-179ff9111d8c | -€23.00 | €0.00 | matched |
| 39 | capture | 01a18488-d396-7a50-8119-625033128ffe | €24.00 | €0.37 | matched |
| 40 | capture | 01a18488-d781-788e-a0a4-257e1430faf6 | €9.00 | €0.19 | matched |
| 41 | capture | 01a18488-f4c1-78c3-8f00-563b007bbd30 | €35.00 | €0.50 | matched |
| 42 | capture | 01a18489-17e6-7f76-bad6-bd8414f0f34b | €49.00 | €0.67 | matched |
| 43 | capture | 01a18489-182b-7e70-85c1-0619e18b2450 | €35.00 | €0.50 | matched |
| 44 | capture | 01a18489-240a-7470-8faa-05901f2dba09 | €9.00 | €0.19 | matched |
| 45 | capture | 01a18489-399f-718e-8dd8-57f10a19bc6b | €35.00 | €0.50 | matched |
| 46 | capture | 01a18489-3a05-7b38-8eac-02662edf72e1 | €49.00 | €0.67 | matched |
| 47 | capture | 01a18489-3d86-71f6-af79-faa890808c1b | €49.00 | €0.67 | matched |
| 48 | capture | 01a18489-4dff-7f2d-8db4-ff9ccdce2644 | €35.00 | €0.50 | matched |
| 49 | capture | 01a18489-5912-7db8-822d-6e68468fd0f4 | €35.00 | €0.50 | matched |
| 50 | capture | 01a18489-5e7f-7883-9e3b-c7c7967e2cf2 | €49.00 | €0.67 | matched |
| 51 | capture | 01a18489-6b7a-7109-aa39-5db1cf0a7223 | €49.00 | €0.67 | matched |
| 52 | capture | 01a18489-7bb4-7e64-b463-c80d929ea8df | €15.00 | €0.26 | matched |
| 53 | capture | 01a18489-8282-7c7b-869f-293d2f5a9fbe | €35.00 | €0.50 | matched |
| 54 | capture | 01a18489-8527-759a-8989-318a4e265766 | €24.00 | €0.37 | matched |
| 55 | capture | 01a18489-9e23-754e-a4e1-d4025f564a7b | €35.00 | €0.50 | matched |
| 56 | capture | 01a18489-a712-7d54-a7fb-ef4f3eaf0813 | €9.00 | €0.19 | matched |
| 57 | capture | 01a18489-b18c-7c4b-8502-90c5ef04ccb3 | €24.00 | €0.37 | matched |
| 58 | capture | 01a18489-b298-7606-8211-fca7415175e4 | €35.00 | €0.50 | matched |
| 59 | refund | 01a18489-b714-7386-a795-ed884afd559c | -€20.00 | €0.00 | matched |
| 60 | capture | 01a18489-bc80-7042-9951-f8b24ebd940c | €15.00 | €0.26 | matched |
| 61 | capture | 01a18489-d81d-7f5f-a07d-068ad68f79d5 | €24.00 | €0.37 | matched |
| 62 | capture | 01a18489-dcd0-7973-ae08-cf8da60a4655 | €15.00 | €0.26 | matched |
| 63 | capture | 01a18489-ebec-77c8-834e-f973a3572221 | €24.00 | €0.37 | matched |
| 64 | capture | 01a18489-eea4-7ceb-a040-745d1536e4dc | €9.00 | €0.19 | matched |
| 65 | capture | 01a18489-efc2-764b-a56b-903ca75abee4 | €24.00 | €0.37 | matched |
| 66 | capture | 01a18489-f958-7ab7-90e6-ab77cea46328 | €35.00 | €0.50 | matched |
| 67 | capture | 01a1848a-1ae7-7c9b-b3ce-243be0f3ae29 | €24.00 | €0.37 | matched |
| 68 | capture | 01a1848a-1b78-748c-b3b3-e082096e225c | €49.00 | €0.67 | matched |
| 69 | capture | 01a1848a-20a0-73e8-b946-a4886826c1b9 | €49.00 | €0.67 | matched |
| 70 | capture | 01a1848a-258e-718b-a6ad-611e2bc857de | €15.00 | €0.26 | matched |
| 71 | capture | 01a1848a-2ab1-7157-b8f9-1130ec80b668 | €24.00 | €0.37 | matched |
| 72 | refund | 01a1848a-29f8-7de5-9268-6b3d5c100b1b | -€30.00 | €0.00 | matched |
| 73 | capture | 01a1848a-2b27-7f9f-ae04-711ab26c3cea | €49.00 | €0.67 | matched |
| 74 | capture | 01a1848a-4333-72b9-a422-29309b101539 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1848a-4e58-7014-bc1a-94fa1ac5b751 | €15.00 | €0.26 | matched |
| 76 | capture | 01a1848a-8fc1-7eb7-8755-3ff799581d72 | €35.00 | €0.50 | matched |
| 77 | capture | 01a1848a-9ef1-76ec-a820-9bc1482c9b88 | €9.00 | €0.19 | matched |
| 78 | capture | 01a1848a-c2c3-7dc0-8cad-4d2e04c40e62 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1848a-c94b-7ff5-b099-b1920c361a90 | €49.00 | €0.67 | matched |
| 80 | capture | 01a1848a-d446-7e2b-99ef-74aeb2864e77 | €35.00 | €0.50 | matched |
| 81 | capture | 01a1848a-e618-7f32-a08c-21c288cb4a11 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1848a-ef74-7d68-a040-cb756753db35 | €15.00 | €0.26 | matched |
| 83 | capture | 01a1848a-f4e2-7727-9223-2fd6c92f7188 | €15.00 | €0.26 | matched |
| 84 | capture | 01a1848a-f803-7541-879d-64411ff5e5c1 | €15.00 | €0.26 | matched |
| 85 | refund | 01a1848a-f94a-7a99-8a10-868672d3c6a7 | -€5.00 | €0.00 | matched |
| 86 | capture | 01a1848b-0a3f-75c4-b67b-1d0a54cce911 | €24.00 | €0.37 | matched |
| 87 | capture | 01a1848b-0e04-7590-a39d-ef6d0ebff3d0 | €15.00 | €0.26 | matched |
| 88 | capture | 01a1848b-15c1-71d4-a3a9-13cb8d2ec614 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1848b-17ef-7256-a4ea-f8bbe893eaf4 | €35.00 | €0.50 | matched |
| 90 | capture | 01a1848b-1db1-7862-987b-2de7b663c27e | €24.00 | €0.37 | matched |
| 91 | refund | 01a1848b-3fd8-71c0-92f4-09f56a158a41 | -€22.00 | €0.00 | matched |
| 92 | capture | 01a1848b-5181-70cd-aa1c-7c78e858ce97 | €35.00 | €0.50 | matched |
| 93 | capture | 01a1848b-7779-7e21-8b48-34d530117c24 | €35.00 | €0.50 | matched |
| 94 | capture | 01a1848b-97f4-7505-b39a-091011b987bc | €24.00 | €0.37 | matched |
| 95 | capture | 01a1848b-ae86-7e09-9386-8c8729fa16de | €35.00 | €0.50 | matched |
| 96 | capture | 01a1848b-b50e-7d5f-85fd-880e5985c8db | €35.00 | €0.50 | matched |
| 97 | capture | 01a1848b-eafe-7208-8d59-897afbe817ff | €35.00 | €0.50 | matched |
| 98 | capture | 01a1848c-1118-7a03-87b0-351854571325 | €24.00 | €0.37 | matched |
| 99 | capture | 01a1848c-1873-7fe0-9632-24b49d13c508 | €49.00 | €0.67 | matched |
| 100 | capture | 01a1848c-230d-7608-a294-f9692db4ff57 | €15.00 | €0.26 | matched |
| 101 | capture | 01a1848c-2562-7a5c-8b31-ec6e17a75f21 | €24.00 | €0.37 | matched |
| 102 | capture | 01a1848c-2e6b-732b-a80c-3f1fa7add78d | €49.00 | €0.67 | matched |
| 103 | capture | 01a1848c-3b7e-7489-a11f-646f4fbbc445 | €9.00 | €0.19 | matched |
| 104 | capture | 01a1848c-5bc5-7d7e-833b-da3718fb6e65 | €9.00 | €0.19 | matched |
| 105 | capture | 01a1848c-7fec-7204-9251-1a4044135f19 | €35.00 | €0.50 | matched |
| 106 | capture | 01a1848c-8fd1-788d-bf48-89badaa649c7 | €49.00 | €0.67 | matched |
| 107 | capture | 01a1848c-bdb6-7c3b-863e-51c0c8536d73 | €24.00 | €0.37 | matched |
| 108 | capture | 01a1848c-c1ab-76e1-aff6-fa9e922be22b | €24.00 | €0.37 | matched |
| 109 | capture | 01a1848c-ca4d-71c4-9481-d2352911c741 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1848d-179d-7e50-9aa4-fec884bec909 | €24.00 | €0.37 | matched |
| 111 | capture | 01a1848d-4bad-7c66-a3b5-39690f08d13b | €24.00 | €0.37 | matched |
| 112 | capture | 01a1848d-6828-7209-a6a5-6dd3af951e62 | €24.00 | €0.37 | matched |
| 113 | refund | 01a1848d-8050-7243-a9c3-50af23d00e13 | -€8.00 | €0.00 | matched |
| 114 | capture | 01a1848d-9087-705a-8776-2a6843b052fb | €24.00 | €0.37 | matched |
| 115 | capture | 01a1848d-e71a-7b3a-b485-dab594ebaf16 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1848e-0d7d-75cf-96eb-22b3c19faed5 | €15.00 | €0.26 | matched |
| 117 | capture | 01a1848e-1ac9-7d1d-9a56-3a92cfb2262d | €49.00 | €0.67 | matched |
| 118 | capture | 01a1848e-59f7-7eb9-bbbb-3b98c2134263 | €49.00 | €0.67 | matched |
| 119 | capture | 01a1848e-6ad7-7bdf-9e2c-dfd14f952f90 | €9.00 | €0.19 | matched |
| 120 | capture | 01a1848e-786c-7e4e-9075-191c60c4e3b4 | €24.00 | €0.37 | matched |
| 121 | capture | 01a1848e-98e7-7612-b5b4-46bc24565234 | €24.00 | €0.37 | matched |
| 122 | capture | 01a1848e-9ed1-74c0-b453-ae428f1aa2b3 | €49.00 | €0.67 | matched |
| 123 | capture | 01a1848e-a6f1-780e-9fe2-e5d11dd98a7e | €15.00 | €0.26 | matched |
| 124 | capture | 01a1848e-a8c9-7946-b872-59f3dc35bb81 | €9.00 | €0.19 | matched |
| 125 | capture | 01a1848e-b15a-7f34-aad4-3a54d0064a8e | €49.00 | €0.67 | matched |
| 126 | capture | 01a1848e-d1e9-7f03-bdcb-52db926fd019 | €24.00 | €0.37 | matched |
| 127 | refund | 01a1848e-dd63-7dae-a60a-6ba7b9cae0d5 | -€14.00 | €0.00 | matched |
| 128 | capture | 01a1848f-0312-7572-b02f-d079545c556c | €24.00 | €0.37 | matched |
| 129 | capture | 01a1848f-1b26-73c6-95c6-7209ae8ee70b | €15.00 | €0.26 | matched |
| 130 | capture | 01a1848f-1fa3-7e20-8969-4da610adfb7c | €49.00 | €0.67 | matched |
| 131 | capture | 01a1848f-2f8d-7a9f-b004-83cd983b9e31 | €35.00 | €0.50 | matched |
| 132 | capture | 01a1848f-4055-7143-b8a2-c3792e0a0377 | €15.00 | €0.26 | matched |
| 133 | capture | 01a1848f-5592-7f4b-b757-6b15797c5336 | €9.00 | €0.19 | matched |
| 134 | capture | 01a1848f-7ff6-7f5e-b0ee-e09478502d76 | €15.00 | €0.26 | matched |
| 135 | capture | 01a1848f-8e63-7212-9e65-64b87c14e2b7 | €9.00 | €0.19 | matched |
| 136 | capture | 01a1848f-b2b4-770a-8a3d-e6c008cae84b | €35.00 | €0.50 | matched |
| 137 | capture | 01a1848f-b23e-7dbf-8681-a62c5072cb75 | €9.00 | €0.19 | matched |
| 138 | capture | 01a1848f-baf6-78e0-9b54-6fb957c2e357 | €9.00 | €0.19 | matched |
| 139 | capture | 01a1848f-b3b5-777a-af3e-ea3ffb8e2561 | €35.00 | €0.50 | matched |
| 140 | capture | 01a1848f-d16f-7126-907b-912078e6b797 | €49.00 | €0.67 | matched |
| 141 | capture | 01a1848f-d3b5-7fae-afe1-839ae170ac98 | €15.00 | €0.26 | matched |
| 142 | capture | 01a1848f-dcd2-76cd-9abc-23307df1eee1 | €9.00 | €0.19 | matched |
| 143 | capture | 01a1848f-e397-7663-be05-cc6a1b5ff1e8 | €24.00 | €0.37 | matched |
| 144 | refund | 01a1848f-f179-7279-890e-2d41f6b316df | -€3.00 | €0.00 | matched |
| 145 | refund | 01a1848f-f22d-7651-8cba-47b0c7497a05 | -€8.00 | €0.00 | matched |
| 146 | capture | 01a1848f-fbc2-78f4-93cf-6c1342ad5d8a | €35.00 | €0.50 | matched |
| 147 | capture | 01a18490-13ca-7970-abb2-03481b626f97 | €9.00 | €0.19 | matched |
| 148 | capture | 01a18490-1668-7de7-859e-17ac8326a89a | €35.00 | €0.50 | matched |