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
- 31 Oct, 07:50112 lines3 breaks
- 31 Oct, 07:4099 lines1 break
- 31 Oct, 07:30122 lines2 breaks
- 31 Oct, 07:20112 lines4 breaks
- 31 Oct, 07:10125 lines6 breaks
- 31 Oct, 07:00130 lines5 breaks
- 31 Oct, 06:50133 lines2 breaks
- 31 Oct, 06:40132 lines1 break
- 31 Oct, 06:30138 linesclean
- 31 Oct, 06:20119 lines1 break
- 31 Oct, 06:10117 lines4 breaks
- 31 Oct, 06:00144 lines4 breaks
- 31 Oct, 05:50117 lines2 breaks
- 31 Oct, 05:40134 lines4 breaks
31 Oct, 06:00
Gross
€2,913.00
PSP fee
€48.00
Net to the bank
€2,865.00
Settlement journal
#301451
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1908d-e436-7f93-bd00-53eeda87b3ea is already settled by stl_EUR_2989044 line 38
- fee differencethe fee is not the contract feethe fee is 28, the contract says 26
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- missing linein the books, not in the filecapture:01a1908c-a961-74e2-a9ed-e250a4b73c1e is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 39 | capture | 01a1908d-e488-7835-a799-a64cb98327b2 | €9.00 | €0.19 | duplicate line |
| 99 | capture | 01a19092-0a28-72dd-88cb-6c2731c8e4dd | €15.00 | €0.28 | fee difference |
| 113 | capture | 01a19092-bab7-72bb-bb13-d2acf44b89d1 | €35.00 | €0.53 | fee difference |
| 1 | capture | 01a19083-1610-71cf-90a3-2fbc0912acd9 | €9.00 | €0.19 | matched |
| 2 | capture | 01a19083-f1d3-7091-8e57-30e59d412984 | €9.00 | €0.19 | matched |
| 3 | capture | 01a1908b-474b-730b-a0e5-fbcee8791bab | €24.00 | €0.37 | matched |
| 4 | capture | 01a1908b-4a50-7876-8b52-87e6391b34da | €15.00 | €0.26 | matched |
| 5 | capture | 01a1908b-50b7-7e76-bff5-252d62391fea | €49.00 | €0.67 | matched |
| 6 | capture | 01a1908b-5b38-70a5-bf2d-365db9f937c5 | €35.00 | €0.50 | matched |
| 7 | capture | 01a1908b-6984-7b6f-86d5-e2831da60b99 | €24.00 | €0.37 | matched |
| 8 | capture | 01a1908b-7cd1-74c7-8924-c7efc2c1956c | €24.00 | €0.37 | matched |
| 9 | refund | 01a1908b-82ae-7c0d-b393-65c5427ab9b9 | -€14.00 | €0.00 | matched |
| 10 | capture | 01a1908b-91e9-725e-91d7-cfe1768c487a | €15.00 | €0.26 | matched |
| 11 | capture | 01a1908b-967a-7cce-bc21-079555f290be | €15.00 | €0.26 | matched |
| 12 | capture | 01a1908b-97ea-7158-8f3a-667811d65fe6 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1908b-9bf7-70fc-adf6-6c24db0e8676 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1908b-9cd3-72ac-a1f6-39820e8e938a | €35.00 | €0.50 | matched |
| 15 | capture | 01a1908b-9f07-7637-8f58-f6e77575b207 | €9.00 | €0.19 | matched |
| 16 | refund | 01a1908b-b4af-7466-ac35-ed233b2fa371 | -€15.00 | €0.00 | matched |
| 17 | capture | 01a1908b-c155-7330-bb72-4dd7371bbc38 | €24.00 | €0.37 | matched |
| 18 | capture | 01a1908c-0e72-7607-8a2a-4dcb6879757a | €9.00 | €0.19 | matched |
| 19 | capture | 01a1908c-1a7a-768b-9a92-9d503dcd82e5 | €24.00 | €0.37 | matched |
| 20 | capture | 01a1908c-2e85-789f-b761-1fa4cf78a961 | €35.00 | €0.50 | matched |
| 21 | capture | 01a1908c-46b7-7434-a09c-705a46a496b5 | €15.00 | €0.26 | matched |
| 22 | capture | 01a1908c-4af1-7624-a36b-044fe829349e | €15.00 | €0.26 | matched |
| 23 | capture | 01a1908c-8eca-757e-8452-51299d4d10e5 | €9.00 | €0.19 | matched |
| 24 | capture | 01a1908c-9cae-77ca-8d2b-3ee41c360293 | €24.00 | €0.37 | matched |
| 25 | capture | 01a1908c-bb8f-7bed-9c4a-8f4f17458400 | €15.00 | €0.26 | matched |
| 26 | capture | 01a1908c-e2e8-7eeb-879d-c45774803501 | €49.00 | €0.67 | matched |
| 27 | capture | 01a1908c-e8bd-7f49-af9d-b313186e0d29 | €9.00 | €0.19 | matched |
| 28 | capture | 01a1908d-08c2-70aa-bade-6e169d79980a | €15.00 | €0.26 | matched |
| 29 | capture | 01a1908d-0cd2-7eef-98b5-31aee38cdcd4 | €24.00 | €0.37 | matched |
| 30 | capture | 01a1908d-0ff4-74e2-b03d-804f620f37b0 | €24.00 | €0.37 | matched |
| 31 | capture | 01a1908d-1b56-7170-a20f-bc010a933ec5 | €35.00 | €0.50 | matched |
| 32 | capture | 01a1908d-372c-7296-8bd6-a0cfa2a2a4a1 | €15.00 | €0.26 | matched |
| 33 | capture | 01a1908d-71e7-7501-8667-102484d7d546 | €49.00 | €0.67 | matched |
| 34 | capture | 01a1908d-7464-7bc3-b830-9b04df5c7410 | €49.00 | €0.67 | matched |
| 35 | capture | 01a1908d-862e-70c5-ab92-3962c9af90a9 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1908d-aead-737a-9c07-e56187cb641f | €24.00 | €0.37 | matched |
| 37 | capture | 01a1908d-dfe9-76b2-9c00-5b06b2846940 | €15.00 | €0.26 | matched |
| 38 | capture | 01a1908d-e488-7835-a799-a64cb98327b2 | €9.00 | €0.19 | matched |
| 40 | capture | 01a1908d-ec9d-710e-b138-a3ee687f7b25 | €49.00 | €0.67 | matched |
| 41 | capture | 01a1908e-0616-70dd-bf0b-842fd41b5eb9 | €35.00 | €0.50 | matched |
| 42 | capture | 01a1908e-0766-7ed5-9fd3-16105d847c51 | €15.00 | €0.26 | matched |
| 43 | capture | 01a1908e-2318-746f-ab7d-d045a6d4b7a2 | €35.00 | €0.50 | matched |
| 44 | capture | 01a1908e-373d-708a-8c70-bec9016b1b1f | €9.00 | €0.19 | matched |
| 45 | capture | 01a1908e-5225-77b3-a709-08f53d175427 | €24.00 | €0.37 | matched |
| 46 | refund | 01a1908e-6aba-7f93-b10a-d173afbebea9 | -€2.00 | €0.00 | matched |
| 47 | capture | 01a1908e-6acc-7da6-8c81-594d22dfb260 | €9.00 | €0.19 | matched |
| 48 | capture | 01a1908e-7531-7fa4-b933-8d1f5cc5abd6 | €35.00 | €0.50 | matched |
| 49 | capture | 01a1908e-7b1d-726c-b2f6-efb7421dc266 | €9.00 | €0.19 | matched |
| 50 | capture | 01a1908e-8a85-79c0-8ea9-7741d7d8faee | €35.00 | €0.50 | matched |
| 51 | capture | 01a1908e-a95b-78cd-bcc0-8f61ac7d89e2 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1908e-b2d9-7bd2-ad0f-8d7b532f2465 | €35.00 | €0.50 | matched |
| 53 | refund | 01a1908e-bcab-751a-80f9-2899d40b6053 | -€20.00 | €0.00 | matched |
| 54 | capture | 01a1908e-c3f5-7dff-95c4-49992fdaf2f0 | €35.00 | €0.50 | matched |
| 55 | capture | 01a1908e-cb66-7fdd-aef3-e1d66374424d | €49.00 | €0.67 | matched |
| 56 | capture | 01a1908e-df7f-77be-b7a8-36faaec5ef98 | €24.00 | €0.37 | matched |
| 57 | refund | 01a1908e-f844-724f-adc5-109e1cae9ce0 | -€46.00 | €0.00 | matched |
| 58 | capture | 01a1908f-1b1a-7237-86b3-eb090a7abf9d | €24.00 | €0.37 | matched |
| 59 | capture | 01a1908f-23ae-7e3f-bb48-dfab83164b05 | €35.00 | €0.50 | matched |
| 60 | capture | 01a1908f-2dcb-73ed-8d70-3896dd7fa03d | €24.00 | €0.37 | matched |
| 61 | capture | 01a1908f-4a77-7214-ac92-21f1692c0e7a | €9.00 | €0.19 | matched |
| 62 | capture | 01a1908f-7ed9-7b8b-9fac-c36ce4cee4f9 | €9.00 | €0.19 | matched |
| 63 | capture | 01a1908f-81f8-739a-b38e-88b20eef026d | €35.00 | €0.50 | matched |
| 64 | capture | 01a1908f-92db-7bfe-98b9-2be6d09d3a96 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1908f-9b82-73ec-b032-59e805abdd0d | €35.00 | €0.50 | matched |
| 66 | capture | 01a1908f-9d2f-71a0-9f18-feee6d19f516 | €15.00 | €0.26 | matched |
| 67 | capture | 01a1908f-a2ca-713e-9ed6-4431042695ed | €9.00 | €0.19 | matched |
| 68 | capture | 01a1908f-d152-7aad-bd0d-fa216c41e5d5 | €15.00 | €0.26 | matched |
| 69 | capture | 01a1908f-d724-79e0-9597-931d70c31869 | €15.00 | €0.26 | matched |
| 70 | capture | 01a19090-03b6-7689-9c62-fcb2f1d57f65 | €15.00 | €0.26 | matched |
| 71 | capture | 01a19090-1851-7831-91fc-126a53dad116 | €49.00 | €0.67 | matched |
| 72 | capture | 01a19090-3537-7c09-b259-4bfbf6e722d7 | €49.00 | €0.67 | matched |
| 73 | capture | 01a19090-45c1-71e4-ac5c-9ac28ce674d1 | €35.00 | €0.50 | matched |
| 74 | capture | 01a19090-58d2-767f-9325-2a23788893f5 | €24.00 | €0.37 | matched |
| 75 | capture | 01a19090-5e24-797a-ac8a-b5055b137047 | €24.00 | €0.37 | matched |
| 76 | capture | 01a19090-6728-7244-a140-d33a072695bf | €9.00 | €0.19 | matched |
| 77 | capture | 01a19090-82d3-7379-8e3a-d7c34a722d99 | €49.00 | €0.67 | matched |
| 78 | capture | 01a19090-88c4-7cc4-872b-5f505a559161 | €15.00 | €0.26 | matched |
| 79 | capture | 01a19090-b613-7ba2-9f5f-3bca28df2b72 | €35.00 | €0.50 | matched |
| 80 | capture | 01a19090-cc88-7b28-8327-da014765474b | €9.00 | €0.19 | matched |
| 81 | capture | 01a19090-cffb-7ca7-b893-865c537d24be | €35.00 | €0.50 | matched |
| 82 | capture | 01a19090-d44a-7330-931d-d14dde7b2fe9 | €9.00 | €0.19 | matched |
| 83 | capture | 01a19090-ed9a-7f99-aa21-5d9f9222cba3 | €24.00 | €0.37 | matched |
| 84 | capture | 01a19091-0395-70ec-b110-2583312495e8 | €24.00 | €0.37 | matched |
| 85 | refund | 01a19091-196f-7cd8-9fc7-bbb240644a1a | -€6.00 | €0.00 | matched |
| 86 | capture | 01a19091-237b-7fc7-98c0-e868bd6bca29 | €15.00 | €0.26 | matched |
| 87 | capture | 01a19091-556e-7452-8bef-7100cc4e1517 | €9.00 | €0.19 | matched |
| 88 | capture | 01a19091-84b6-720b-b00e-011f38e16d37 | €15.00 | €0.26 | matched |
| 89 | capture | 01a19091-865e-7b5e-9575-53f49e2297b8 | €15.00 | €0.26 | matched |
| 90 | capture | 01a19091-8a06-7f36-831c-d1c02fe14865 | €15.00 | €0.26 | matched |
| 91 | capture | 01a19091-8f44-70ee-8104-357c580b4276 | €35.00 | €0.50 | matched |
| 92 | capture | 01a19091-997b-7d17-8e8d-e9e56afeecaa | €24.00 | €0.37 | matched |
| 93 | capture | 01a19091-a0f7-7025-9de2-e5b424d90695 | €24.00 | €0.37 | matched |
| 94 | capture | 01a19091-c0ac-75ac-9641-f0d40df672a8 | €35.00 | €0.50 | matched |
| 95 | capture | 01a19091-df4d-7856-9028-3a7e23a5e341 | €35.00 | €0.50 | matched |
| 96 | capture | 01a19091-f818-7edd-8692-c792a3bfcf6b | €35.00 | €0.50 | matched |
| 97 | capture | 01a19092-02d0-7d75-ab2b-7a6d9d9b5999 | €35.00 | €0.50 | matched |
| 98 | capture | 01a19092-0975-7089-90ba-a7b738ed9a13 | €24.00 | €0.37 | matched |
| 100 | capture | 01a19092-1862-7da3-8393-8c0657bba86d | €24.00 | €0.37 | matched |
| 101 | capture | 01a19092-27bb-781d-afb2-c0062f75473f | €9.00 | €0.19 | matched |
| 102 | capture | 01a19092-3887-7845-a8a9-bffa6287b9d4 | €49.00 | €0.67 | matched |
| 103 | capture | 01a19092-38c0-774c-bac3-10cd09924ecd | €24.00 | €0.37 | matched |
| 104 | capture | 01a19092-39e7-735a-adb0-0f67628d0d5c | €15.00 | €0.26 | matched |
| 105 | capture | 01a19092-580f-7f7f-84cb-b726f130c3c6 | €9.00 | €0.19 | matched |
| 106 | capture | 01a19092-621f-7fc0-8b60-1a7d85bb49f6 | €35.00 | €0.50 | matched |
| 107 | refund | 01a19092-715e-78cd-8021-50c2575e6025 | -€9.00 | €0.00 | matched |
| 108 | capture | 01a19092-7a83-7cea-803b-22e8940fd5cb | €9.00 | €0.19 | matched |
| 109 | capture | 01a19092-81af-7000-86b1-c0a3a5484b24 | €49.00 | €0.67 | matched |
| 110 | capture | 01a19092-84f6-7a04-b0ef-81d1d130095e | €15.00 | €0.26 | matched |
| 111 | capture | 01a19092-87ad-7372-8b4b-50d69915b01d | €9.00 | €0.19 | matched |
| 112 | capture | 01a19092-9c64-7235-8e00-1c240ac0ed8a | €15.00 | €0.26 | matched |
| 114 | refund | 01a19092-be4d-7902-ac8e-7e31460b25ce | -€17.00 | €0.00 | matched |
| 115 | capture | 01a19092-c986-7f0a-a0d1-70198d036c7e | €15.00 | €0.26 | matched |
| 116 | capture | 01a19092-f004-76dc-a653-f6b3c7275df6 | €24.00 | €0.37 | matched |
| 117 | capture | 01a19092-f1f1-7aaa-8eac-7ca445bba0a1 | €9.00 | €0.19 | matched |
| 118 | capture | 01a19093-0b25-771b-b8ca-103a957304d0 | €9.00 | €0.19 | matched |
| 119 | capture | 01a19093-1016-7833-b610-5bb45ba2b63a | €24.00 | €0.37 | matched |
| 120 | capture | 01a19093-11a4-71c1-aac2-dab3d2066af4 | €15.00 | €0.26 | matched |
| 121 | capture | 01a19093-1594-790c-a0fe-a91edc085dd8 | €15.00 | €0.26 | matched |
| 122 | capture | 01a19093-2435-700b-8685-742ac7c513b9 | €24.00 | €0.37 | matched |
| 123 | capture | 01a19093-2dae-7104-b180-d67cb50bb5fa | €49.00 | €0.67 | matched |
| 124 | capture | 01a19093-37d6-7fcc-a4c5-fe647f4acab5 | €9.00 | €0.19 | matched |
| 125 | capture | 01a19093-526c-751f-9646-922a39f53340 | €35.00 | €0.50 | matched |
| 126 | capture | 01a19093-5411-7dd7-bb69-740e88c28257 | €24.00 | €0.37 | matched |
| 127 | capture | 01a19093-55b3-7e67-8891-a708d88b48f4 | €15.00 | €0.26 | matched |
| 128 | capture | 01a19093-589e-7049-a775-efd235237338 | €9.00 | €0.19 | matched |
| 129 | refund | 01a19093-5f87-7127-a00e-f389a8767fa0 | -€23.00 | €0.00 | matched |
| 130 | capture | 01a19093-62f2-7c61-99eb-dc58f8775225 | €24.00 | €0.37 | matched |
| 131 | capture | 01a19093-883d-760b-880b-3f42e412c7ce | €9.00 | €0.19 | matched |
| 132 | capture | 01a19093-8a95-7262-8b5c-f4c77c3ec024 | €49.00 | €0.67 | matched |
| 133 | capture | 01a19093-8ad5-71a7-9dfb-f76af91bc1e0 | €9.00 | €0.19 | matched |
| 134 | refund | 01a19093-af0b-7f2b-999a-1a55f0e1de37 | -€9.00 | €0.00 | matched |
| 135 | capture | 01a19093-b2e1-77b0-9144-ca1c5a69dd83 | €35.00 | €0.50 | matched |
| 136 | refund | 01a19093-ba78-7629-bbf0-a70daf27ca8f | -€11.00 | €0.00 | matched |
| 137 | capture | 01a19093-bcdb-7399-a8a6-af93aebc16be | €35.00 | €0.50 | matched |
| 138 | refund | 01a19093-bd69-7a45-b3ff-cb2837728eae | -€13.00 | €0.00 | matched |
| 139 | capture | 01a19093-d8bd-7be4-a2f6-d069fd0f9c93 | €9.00 | €0.19 | matched |
| 140 | capture | 01a19093-da4c-79b0-90c1-0fafd31a773c | €15.00 | €0.26 | matched |
| 141 | capture | 01a19093-f8ea-7398-95b1-60ccc35878ed | €24.00 | €0.37 | matched |
| 142 | capture | 01a19093-ff8f-7496-98cc-d65260c7001d | €9.00 | €0.19 | matched |
| 143 | refund | 01a19094-05a2-7f08-9e8e-44c6c4cdec36 | -€12.00 | €0.00 | matched |
| 144 | capture | 01a19094-2c08-7832-ae4e-5607f8e809a7 | €35.00 | €0.50 | matched |