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
- 30 Oct, 17:20158 lines3 breaks
- 30 Oct, 17:10112 lines3 breaks
- 30 Oct, 17:00142 linesclean
- 30 Oct, 16:50109 lines6 breaks
- 30 Oct, 16:40116 lines3 breaks
- 30 Oct, 16:30118 lines5 breaks
- 30 Oct, 16:20133 lines1 break
- 30 Oct, 16:10127 lines1 break
- 30 Oct, 16:00124 lines2 breaks
- 30 Oct, 15:50124 lines3 breaks
- 30 Oct, 15:40111 lines1 break
- 30 Oct, 15:30126 linesclean
- 30 Oct, 15:20140 lines6 breaks
- 30 Oct, 15:10127 lines4 breaks
30 Oct, 16:30
Gross
€2,267.00
PSP fee
€37.76
Net to the bank
€2,229.24
Settlement journal
#290966
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a18da7-9b12-79d9-8b66-e612839aa124 is already settled by stl_EUR_2988963 line 24
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- missing linein the books, not in the filecapture:01a18dab-a7b1-783c-835b-b14b3ece363a is in no file
- missing linein the books, not in the filecapture:01a18da6-3358-7b9b-90c0-e4fd15b39f0a is in no file
- missing linein the books, not in the filecapture:01a18da7-4767-7451-8c95-20ddd30e16b6 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 25 | refund | 01a18da7-9b13-7f08-9035-a5f6e26ea6ee | -€7.00 | €0.00 | duplicate line |
| 65 | capture | 01a18daa-0b9b-7df4-9401-680d81322a0d | €9.00 | €0.23 | fee difference |
| 1 | capture | 01a18d9d-659b-711d-99f8-2e94efb3c921 | €15.00 | €0.26 | matched |
| 2 | capture | 01a18da1-256e-70e5-aad7-1216fd36e8d6 | €49.00 | €0.67 | matched |
| 3 | capture | 01a18da3-2e8f-7993-83fb-afae2f7fd048 | €24.00 | €0.37 | matched |
| 4 | capture | 01a18da5-a5fd-73f6-8071-d7d9118aaf0e | €15.00 | €0.26 | matched |
| 5 | refund | 01a18da5-b4f7-7df8-89d1-1f762a25ce82 | -€9.00 | €0.00 | matched |
| 6 | capture | 01a18da5-c716-718f-8b1b-6920e581b91d | €15.00 | €0.26 | matched |
| 7 | capture | 01a18da6-0fae-79f7-b920-d3a881d7e17b | €49.00 | €0.67 | matched |
| 8 | capture | 01a18da6-1b7b-73aa-8fcc-5676b6f9b3f0 | €24.00 | €0.37 | matched |
| 9 | capture | 01a18da6-3a1b-745f-bd0d-801021afef67 | €24.00 | €0.37 | matched |
| 10 | capture | 01a18da6-69cd-7530-911b-a8fde4cad563 | €49.00 | €0.67 | matched |
| 11 | capture | 01a18da6-6a38-7f5e-b0ba-2394fe9c414e | €49.00 | €0.67 | matched |
| 12 | capture | 01a18da6-c3d7-7453-8406-24cb7062fca5 | €15.00 | €0.26 | matched |
| 13 | capture | 01a18da6-cb34-7799-b86a-08402d6bceaa | €15.00 | €0.26 | matched |
| 14 | capture | 01a18da6-efe6-7633-afb4-34fe4fe5a9b6 | €49.00 | €0.67 | matched |
| 15 | capture | 01a18da7-1a6f-7015-b8d5-b66e5ef53655 | €9.00 | €0.19 | matched |
| 16 | capture | 01a18da7-3355-7551-826a-901dfde789db | €35.00 | €0.50 | matched |
| 17 | capture | 01a18da7-484a-7cd7-b2d4-fe586cdaf190 | €9.00 | €0.19 | matched |
| 18 | capture | 01a18da7-4def-7d51-9e09-ca952a01fa7c | €15.00 | €0.26 | matched |
| 19 | capture | 01a18da7-4f12-723c-8dd1-fe7c673e9af2 | €24.00 | €0.37 | matched |
| 20 | capture | 01a18da7-711c-71e4-a1c1-a65655fb2504 | €35.00 | €0.50 | matched |
| 21 | capture | 01a18da7-72d3-78f6-bd07-f8779d6a192f | €24.00 | €0.37 | matched |
| 22 | capture | 01a18da7-88c0-7f2f-9e57-9917230338d9 | €15.00 | €0.26 | matched |
| 23 | capture | 01a18da7-9153-7fd2-9b66-bbdffbde9a28 | €15.00 | €0.26 | matched |
| 24 | refund | 01a18da7-9b13-7f08-9035-a5f6e26ea6ee | -€7.00 | €0.00 | matched |
| 26 | refund | 01a18da7-a85a-7263-b444-e3f5d25a71e8 | -€25.00 | €0.00 | matched |
| 27 | capture | 01a18da7-ab79-7577-8540-71061b640fce | €9.00 | €0.19 | matched |
| 28 | capture | 01a18da7-b2ff-758e-8f40-1c8f914e6313 | €15.00 | €0.26 | matched |
| 29 | refund | 01a18da7-c1e8-7c53-8dbe-df1b76c69da4 | -€10.00 | €0.00 | matched |
| 30 | capture | 01a18da7-c205-7360-8e8c-97f54080f25d | €24.00 | €0.37 | matched |
| 31 | capture | 01a18da7-e201-7337-901f-f731212908c2 | €35.00 | €0.50 | matched |
| 32 | refund | 01a18da8-02bb-70cc-93e8-0ca7e94753b7 | -€24.00 | €0.00 | matched |
| 33 | capture | 01a18da8-0589-765c-81c5-3ff388ccc6f0 | €9.00 | €0.19 | matched |
| 34 | capture | 01a18da8-0c0c-7635-92f6-461cedc3fc11 | €15.00 | €0.26 | matched |
| 35 | capture | 01a18da8-1f4a-7855-813b-9b1321d2b113 | €35.00 | €0.50 | matched |
| 36 | capture | 01a18da8-416c-7eaf-ba37-010ed22d566a | €24.00 | €0.37 | matched |
| 37 | capture | 01a18da8-4c93-7e6e-a151-03e47bcef45d | €49.00 | €0.67 | matched |
| 38 | capture | 01a18da8-4f14-76e2-a4c8-18a6112c7001 | €24.00 | €0.37 | matched |
| 39 | capture | 01a18da8-5d5f-79e2-a1b6-57ed8551c71f | €24.00 | €0.37 | matched |
| 40 | capture | 01a18da8-5db1-7959-968a-cdc0f5146b8f | €9.00 | €0.19 | matched |
| 41 | capture | 01a18da8-7473-74e4-b83f-fb4763de1a0f | €24.00 | €0.37 | matched |
| 42 | capture | 01a18da8-831e-78b9-bef9-f9624a265417 | €15.00 | €0.26 | matched |
| 43 | refund | 01a18da8-87f8-7300-895b-3df413450863 | -€23.00 | €0.00 | matched |
| 44 | capture | 01a18da8-a52a-7966-9d22-38850f1dd796 | €15.00 | €0.26 | matched |
| 45 | refund | 01a18da8-b61c-7712-85b5-f18be6507bc3 | -€20.00 | €0.00 | matched |
| 46 | capture | 01a18da8-eeb5-7709-adbe-946bffc80e25 | €15.00 | €0.26 | matched |
| 47 | capture | 01a18da8-f09e-7930-9a3c-6b6e6e2fe939 | €24.00 | €0.37 | matched |
| 48 | capture | 01a18da9-0038-7068-9919-299465597817 | €49.00 | €0.67 | matched |
| 49 | capture | 01a18da9-08a1-7b23-a811-0571df7b3a0d | €35.00 | €0.50 | matched |
| 50 | capture | 01a18da9-20de-79c0-baea-e08cc02de1c8 | €15.00 | €0.26 | matched |
| 51 | capture | 01a18da9-3160-7130-9ef0-d8c7a60088fb | €49.00 | €0.67 | matched |
| 52 | capture | 01a18da9-33b1-7431-a1d1-8dacd2b5a3e3 | €9.00 | €0.19 | matched |
| 53 | capture | 01a18da9-3f39-7d52-b119-56ff088ddd72 | €49.00 | €0.67 | matched |
| 54 | refund | 01a18da9-4b47-7cd5-a09a-81879a5f842f | -€4.00 | €0.00 | matched |
| 55 | capture | 01a18da9-6ae8-76ed-8779-b6753f3a82a6 | €24.00 | €0.37 | matched |
| 56 | capture | 01a18da9-6e7c-7320-8fcc-1c3ba06740e4 | €9.00 | €0.19 | matched |
| 57 | capture | 01a18da9-7066-76b3-a377-7f041b772510 | €49.00 | €0.67 | matched |
| 58 | capture | 01a18da9-7e19-7d47-b2ce-edde2b05d314 | €9.00 | €0.19 | matched |
| 59 | capture | 01a18da9-ad09-7569-9157-2bba99af899c | €35.00 | €0.50 | matched |
| 60 | capture | 01a18da9-c7f5-7774-a8d1-fb34dbee3b1e | €9.00 | €0.19 | matched |
| 61 | capture | 01a18da9-e415-782f-a58a-892e29d65aa0 | €15.00 | €0.26 | matched |
| 62 | capture | 01a18da9-e430-73d5-a721-450698133fa9 | €35.00 | €0.50 | matched |
| 63 | capture | 01a18da9-edf2-7f86-8a50-82143b2b6afa | €15.00 | €0.26 | matched |
| 64 | capture | 01a18da9-fb19-7a7d-9a4e-7dd494c38b32 | €9.00 | €0.19 | matched |
| 66 | capture | 01a18daa-166b-7377-a0b7-a7573415a78b | €15.00 | €0.26 | matched |
| 67 | capture | 01a18daa-6733-720f-8549-fdc32289b472 | €9.00 | €0.19 | matched |
| 68 | capture | 01a18daa-8069-7568-af5e-acb93132f5a3 | €9.00 | €0.19 | matched |
| 69 | capture | 01a18daa-9c97-7f87-9eed-c2a9c7c8e418 | €35.00 | €0.50 | matched |
| 70 | capture | 01a18daa-a094-73f4-8e1f-a24fb18e449a | €15.00 | €0.26 | matched |
| 71 | capture | 01a18daa-ac03-7896-afe1-b870cd9b3620 | €24.00 | €0.37 | matched |
| 72 | capture | 01a18daa-aec9-7698-b65a-304dbbc8eaf7 | €15.00 | €0.26 | matched |
| 73 | capture | 01a18daa-bb93-7dca-8761-4cb37f074530 | €49.00 | €0.67 | matched |
| 74 | capture | 01a18daa-c3da-7105-b927-52a2e4c6b8b8 | €9.00 | €0.19 | matched |
| 75 | capture | 01a18daa-e9d8-753f-9cc7-10f1e1a7860d | €9.00 | €0.19 | matched |
| 76 | capture | 01a18daa-f7fb-79a7-a1a2-d1d88d5ee2f7 | €9.00 | €0.19 | matched |
| 77 | refund | 01a18dab-1fbf-737f-8625-f103db365039 | -€9.00 | €0.00 | matched |
| 78 | capture | 01a18dab-22e5-794d-a521-c774a4eefdf7 | €35.00 | €0.50 | matched |
| 79 | capture | 01a18dab-235e-7cbd-8a51-b3c35d3d9d65 | €15.00 | €0.26 | matched |
| 80 | capture | 01a18dab-24d1-79d1-82b9-98e65a915692 | €49.00 | €0.67 | matched |
| 81 | capture | 01a18dab-49d9-75f2-8c73-36120c98d1d3 | €9.00 | €0.19 | matched |
| 82 | capture | 01a18dab-9e38-7e0a-ba86-bbd53bdcebb5 | €24.00 | €0.37 | matched |
| 83 | capture | 01a18dab-aa49-75dd-980f-9bb1e0907ca6 | €9.00 | €0.19 | matched |
| 84 | capture | 01a18dab-acd3-7120-89d0-a1e286982f94 | €15.00 | €0.26 | matched |
| 85 | refund | 01a18dab-b0b4-70ee-b518-dfc43e3c316b | -€9.00 | €0.00 | matched |
| 86 | capture | 01a18dab-d6b4-7e85-95c7-f95f100b8fa3 | €35.00 | €0.50 | matched |
| 87 | capture | 01a18dab-d816-71b8-bb7b-e45917fe0ede | €35.00 | €0.50 | matched |
| 88 | capture | 01a18dab-de6c-718a-8aea-4b2010bdf808 | €35.00 | €0.50 | matched |
| 89 | capture | 01a18dab-e022-7e7b-af36-0607dad77189 | €24.00 | €0.37 | matched |
| 90 | refund | 01a18dac-05e2-70b0-8c9d-2f043e2bba57 | -€14.00 | €0.00 | matched |
| 91 | capture | 01a18dac-2b54-7df5-9c55-e4019e213d0b | €49.00 | €0.67 | matched |
| 92 | refund | 01a18dac-4083-7594-9c4d-bd1319514b69 | -€9.00 | €0.00 | matched |
| 93 | capture | 01a18dac-5021-7361-94c8-5dd7891030ab | €9.00 | €0.19 | matched |
| 94 | capture | 01a18dac-5aee-7bf5-8c9e-b90e41847676 | €9.00 | €0.19 | matched |
| 95 | capture | 01a18dac-72ce-71f9-b39b-7de85cd94a01 | €35.00 | €0.50 | matched |
| 96 | capture | 01a18dac-9900-781f-b1be-6f120eca7d01 | €15.00 | €0.26 | matched |
| 97 | capture | 01a18dac-b1e1-7361-a767-4e292780e31a | €35.00 | €0.50 | matched |
| 98 | capture | 01a18dac-b4d5-71cf-95c6-7fac66496ae0 | €35.00 | €0.50 | matched |
| 99 | capture | 01a18dac-c726-72df-8b22-92ae58611229 | €9.00 | €0.19 | matched |
| 100 | capture | 01a18dac-e430-7301-b432-9b311d2a3e87 | €24.00 | €0.37 | matched |
| 101 | capture | 01a18dac-ee84-7011-800d-bf41e11f4886 | €15.00 | €0.26 | matched |
| 102 | capture | 01a18dad-3187-7a3f-9697-9e5783e8cb67 | €49.00 | €0.67 | matched |
| 103 | capture | 01a18dad-4b05-7cde-8758-dde70889a20d | €24.00 | €0.37 | matched |
| 104 | capture | 01a18dad-5f7f-78ae-b9be-087c393a416d | €24.00 | €0.37 | matched |
| 105 | capture | 01a18dad-6c01-7166-9119-69a664a1b621 | €15.00 | €0.26 | matched |
| 106 | capture | 01a18dad-85c6-7475-aaa4-e1d197916ee3 | €9.00 | €0.19 | matched |
| 107 | capture | 01a18dad-9e4d-7563-81ce-2660cb1dddcc | €9.00 | €0.19 | matched |
| 108 | capture | 01a18dad-b3b9-7276-b98e-95312670cd1e | €15.00 | €0.26 | matched |
| 109 | capture | 01a18dad-bcd3-73e1-81f4-b2d9456bc175 | €49.00 | €0.67 | matched |
| 110 | capture | 01a18dad-c922-7f3e-87db-91fb164ffdb9 | €24.00 | €0.37 | matched |
| 111 | refund | 01a18dad-eb63-77a3-97d3-83e1b517f0f0 | -€3.00 | €0.00 | matched |
| 112 | capture | 01a18dad-f106-7293-b71d-762f743c7df5 | €9.00 | €0.19 | matched |
| 113 | capture | 01a18dae-0615-785f-9553-52b256ec8a68 | €35.00 | €0.50 | matched |
| 114 | capture | 01a18dae-3f1b-7714-9ba8-b7df7129f125 | €35.00 | €0.50 | matched |
| 115 | capture | 01a18dae-8f3c-7c11-a816-821fd23b7691 | €9.00 | €0.19 | matched |
| 116 | capture | 01a18dae-a12c-7f5e-9630-cce1258e2da7 | €24.00 | €0.37 | matched |
| 117 | capture | 01a18dae-b1b1-7e54-bd7e-394700f11cbd | €15.00 | €0.26 | matched |
| 118 | capture | 01a18dae-b441-7730-bb31-b36783d1628c | €15.00 | €0.26 | matched |