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
- 3 Nov, 00:50110 lines4 breaks
- 3 Nov, 00:40145 linesclean
- 3 Nov, 00:30125 lines1 break
- 3 Nov, 00:20128 linesclean
- 3 Nov, 00:10123 lines1 break
- 3 Nov, 00:00141 lines8 breaks
- 2 Nov, 23:50119 lines2 breaks
- 2 Nov, 23:40116 lines3 breaks
- 2 Nov, 23:30108 lines6 breaks
- 2 Nov, 23:20134 lines2 breaks
- 2 Nov, 23:10137 lines3 breaks
- 2 Nov, 23:00118 lines2 breaks
- 2 Nov, 22:50110 lines3 breaks
- 2 Nov, 22:40119 linesclean
3 Nov, 00:00
Gross
€3,433.00
PSP fee
€53.81
Net to the bank
€3,379.19
Settlement journal
#351692
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19eb9-8ed1-7054-bb1c-e36799c2d4f2 is already settled by stl_EUR_2989440 line 59
- duplicate linethe file lists it twicerefund:01a19eba-22ea-7d5a-9a97-f3c2f7f02c9c is already settled by stl_EUR_2989440 line 68
- duplicate linethe file lists it twicecapture:01a19ebc-4814-7801-8fe8-244587073db1 is already settled by stl_EUR_2989440 line 108
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- fee differencethe fee is not the contract feethe fee is 54, the contract says 50
- fee differencethe fee is not the contract feethe fee is 38, the contract says 37
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- missing linein the books, not in the filecapture:01a19ebc-f3a0-7d72-be47-d0b2764ef13c is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 9 | capture | 01a19eb4-fe9b-7052-9e11-ece7130ba16b | €9.00 | €0.23 | fee difference |
| 27 | capture | 01a19eb6-430a-77a7-bd89-a545309e7ee0 | €35.00 | €0.54 | fee difference |
| 60 | capture | 01a19eb9-a42b-7c19-989d-5938e46a3b65 | €49.00 | €0.67 | duplicate line |
| 69 | refund | 01a19eba-22ec-74a7-9abc-b5827648f498 | -€21.00 | €0.00 | duplicate line |
| 109 | capture | 01a19ebc-482b-7aa7-8a81-52d92bf709ba | €35.00 | €0.50 | duplicate line |
| 123 | capture | 01a19ebc-dd11-7971-a26e-83c29375cd07 | €24.00 | €0.38 | fee difference |
| 138 | capture | 01a19ebd-9ca1-79f4-8c5d-a13a6dae2766 | €9.00 | €0.23 | fee difference |
| 1 | capture | 01a19eac-edbd-7225-b040-da7d3e3ebe5a | €35.00 | €0.50 | matched |
| 2 | capture | 01a19eb4-b679-75a2-acb5-254c36ae76db | €49.00 | €0.67 | matched |
| 3 | capture | 01a19eb4-c0be-7063-82ef-693b2ce5d97c | €35.00 | €0.50 | matched |
| 4 | refund | 01a19eb4-ce58-7143-9c21-65779b396770 | -€2.00 | €0.00 | matched |
| 5 | capture | 01a19eb4-d032-7240-a35c-73bc7dfb5ccc | €35.00 | €0.50 | matched |
| 6 | capture | 01a19eb4-df86-7bdc-b5e6-b411d8948264 | €24.00 | €0.37 | matched |
| 7 | capture | 01a19eb4-e4af-78d8-befa-ea1555c7e223 | €9.00 | €0.19 | matched |
| 8 | capture | 01a19eb5-0016-74fb-96d6-d8939bf1355c | €24.00 | €0.37 | matched |
| 10 | refund | 01a19eb5-1f2c-707c-bfc8-251bbaf4ec5a | -€4.00 | €0.00 | matched |
| 11 | capture | 01a19eb5-2dcb-7ca9-bc80-87d354eba6f0 | €49.00 | €0.67 | matched |
| 12 | capture | 01a19eb5-580a-7878-a90d-19230db5d252 | €49.00 | €0.67 | matched |
| 13 | capture | 01a19eb5-8240-7960-b04e-b458c944ba8b | €24.00 | €0.37 | matched |
| 14 | capture | 01a19eb5-98c2-7e7d-b075-bf493510b176 | €49.00 | €0.67 | matched |
| 15 | capture | 01a19eb5-9b02-71ef-b08b-800d19aa34a4 | €35.00 | €0.50 | matched |
| 16 | capture | 01a19eb5-9e09-71cb-912e-5e26bfdaed38 | €35.00 | €0.50 | matched |
| 17 | capture | 01a19eb5-a172-7e19-8119-38ba4aa27694 | €24.00 | €0.37 | matched |
| 18 | capture | 01a19eb5-b6ec-7b4a-8d1d-39943adc83c8 | €35.00 | €0.50 | matched |
| 19 | capture | 01a19eb5-ca70-71e0-80af-dea2969dc331 | €9.00 | €0.19 | matched |
| 20 | capture | 01a19eb5-caa0-7df1-95e2-6f76bd7ef171 | €15.00 | €0.26 | matched |
| 21 | capture | 01a19eb5-cec7-7ece-bb41-d4ed0d32cbcf | €9.00 | €0.19 | matched |
| 22 | capture | 01a19eb5-d7cf-7a04-a5c0-55d129c6ea4e | €15.00 | €0.26 | matched |
| 23 | capture | 01a19eb5-df52-7a83-b5e3-3a570fabfd83 | €24.00 | €0.37 | matched |
| 24 | capture | 01a19eb5-e6eb-7296-ba64-0a26d97cfb11 | €24.00 | €0.37 | matched |
| 25 | capture | 01a19eb5-ef73-7000-ab69-c2c9b400f93d | €35.00 | €0.50 | matched |
| 26 | capture | 01a19eb6-17e2-7d2b-8723-ad635d420f96 | €49.00 | €0.67 | matched |
| 28 | capture | 01a19eb6-8891-7314-933a-688bb15e9db2 | €35.00 | €0.50 | matched |
| 29 | capture | 01a19eb6-aeca-7b89-a652-e7b62b341ca0 | €49.00 | €0.67 | matched |
| 30 | capture | 01a19eb6-e1f6-73a5-bc55-22af4ef46118 | €9.00 | €0.19 | matched |
| 31 | capture | 01a19eb7-289d-7e2e-abe1-fda00d9de729 | €15.00 | €0.26 | matched |
| 32 | capture | 01a19eb7-2b01-726d-bb22-4100d50f83be | €9.00 | €0.19 | matched |
| 33 | capture | 01a19eb7-45b0-75fb-8fd7-ac368230a681 | €49.00 | €0.67 | matched |
| 34 | capture | 01a19eb7-5e32-72e2-8b6a-2a7dfd348e77 | €35.00 | €0.50 | matched |
| 35 | capture | 01a19eb7-6865-76af-a61e-4cf4b655b841 | €49.00 | €0.67 | matched |
| 36 | capture | 01a19eb7-d6ee-7bf2-bf37-31688e1b52d1 | €49.00 | €0.67 | matched |
| 37 | capture | 01a19eb7-f9a0-749d-ac60-5240702831a9 | €35.00 | €0.50 | matched |
| 38 | capture | 01a19eb7-f869-7632-866a-3b95b5c35b08 | €35.00 | €0.50 | matched |
| 39 | capture | 01a19eb8-153d-7faf-a434-fe545aaecb30 | €24.00 | €0.37 | matched |
| 40 | capture | 01a19eb8-1bb2-7ce7-adba-94a0b128dcc2 | €24.00 | €0.37 | matched |
| 41 | capture | 01a19eb8-3c26-70b5-9860-a472c4c7cc01 | €35.00 | €0.50 | matched |
| 42 | capture | 01a19eb8-407f-79f5-934c-904c5fec1564 | €24.00 | €0.37 | matched |
| 43 | capture | 01a19eb8-532d-79ee-b5bf-fe14195e7f04 | €24.00 | €0.37 | matched |
| 44 | capture | 01a19eb8-64c9-7e76-86da-3d8ce20a461f | €9.00 | €0.19 | matched |
| 45 | capture | 01a19eb8-93ff-781a-a308-af6eba18f26d | €35.00 | €0.50 | matched |
| 46 | capture | 01a19eb8-95b3-7fa2-bb73-a6364f21b498 | €24.00 | €0.37 | matched |
| 47 | capture | 01a19eb8-cd86-7687-8b4c-fff521d5d775 | €49.00 | €0.67 | matched |
| 48 | capture | 01a19eb8-d078-72b8-87f9-61333a854e73 | €49.00 | €0.67 | matched |
| 49 | capture | 01a19eb8-e6cd-76dc-bf78-f2f44ce48ee7 | €15.00 | €0.26 | matched |
| 50 | capture | 01a19eb9-01bb-79bc-a16f-f860bece0764 | €15.00 | €0.26 | matched |
| 51 | capture | 01a19eb9-0d52-78c3-8c25-947e5d347a6b | €15.00 | €0.26 | matched |
| 52 | capture | 01a19eb9-19c8-7180-8112-38fce347377d | €24.00 | €0.37 | matched |
| 53 | capture | 01a19eb9-1b3d-7718-85c9-59abfa6895c7 | €49.00 | €0.67 | matched |
| 54 | capture | 01a19eb9-1d55-75ae-b2d3-3de9c60d338c | €49.00 | €0.67 | matched |
| 55 | capture | 01a19eb9-3012-78dc-a4f0-a4e3407bbfa5 | €9.00 | €0.19 | matched |
| 56 | capture | 01a19eb9-71b5-7ff6-aa19-f7b33a9caf1c | €35.00 | €0.50 | matched |
| 57 | capture | 01a19eb9-7628-7a81-9043-6c43646a4375 | €49.00 | €0.67 | matched |
| 58 | capture | 01a19eb9-83a9-7fb8-ae41-7d9d9957cf0e | €15.00 | €0.26 | matched |
| 59 | capture | 01a19eb9-a42b-7c19-989d-5938e46a3b65 | €49.00 | €0.67 | matched |
| 61 | capture | 01a19eb9-aab5-79ce-9001-a3f9c1ca88f7 | €24.00 | €0.37 | matched |
| 62 | capture | 01a19eb9-b741-7d0b-a604-4fb09a12756e | €24.00 | €0.37 | matched |
| 63 | capture | 01a19eb9-d856-7821-bce3-d1921fbeaa32 | €35.00 | €0.50 | matched |
| 64 | capture | 01a19eb9-dcd1-7cba-b716-419f90365027 | €49.00 | €0.67 | matched |
| 65 | capture | 01a19eb9-e4c9-73cb-b67d-537a8837980d | €35.00 | €0.50 | matched |
| 66 | refund | 01a19eb9-eacb-78f2-ae77-c4428adba4ea | -€6.00 | €0.00 | matched |
| 67 | capture | 01a19eb9-fec8-76cf-bbd9-024800eea5c8 | €9.00 | €0.19 | matched |
| 68 | refund | 01a19eba-22ec-74a7-9abc-b5827648f498 | -€21.00 | €0.00 | matched |
| 70 | capture | 01a19eba-2dac-705a-a1a0-95805b471a34 | €35.00 | €0.50 | matched |
| 71 | capture | 01a19eba-2f08-7a90-9eb1-0a5ce93b9f61 | €9.00 | €0.19 | matched |
| 72 | capture | 01a19eba-2f19-7aa5-80aa-be1a688f0dbc | €9.00 | €0.19 | matched |
| 73 | capture | 01a19eba-2f97-7ce1-aad1-d7e0cd59f968 | €15.00 | €0.26 | matched |
| 74 | capture | 01a19eba-3043-798e-88b4-c16d1c7e6bb9 | €35.00 | €0.50 | matched |
| 75 | capture | 01a19eba-4e17-7fe3-ae8d-42881bda1ee5 | €15.00 | €0.26 | matched |
| 76 | capture | 01a19eba-604a-7866-9280-de6e252a8242 | €35.00 | €0.50 | matched |
| 77 | refund | 01a19eba-6249-75a8-a419-6d3171016410 | -€10.00 | €0.00 | matched |
| 78 | capture | 01a19eba-8280-7191-b2d3-ddfec6f0bd1d | €9.00 | €0.19 | matched |
| 79 | capture | 01a19eba-8bbf-7757-b234-1f5ebbd3d9ee | €24.00 | €0.37 | matched |
| 80 | capture | 01a19eba-9519-79fc-8943-1f1d6b316e8e | €15.00 | €0.26 | matched |
| 81 | capture | 01a19eba-9e4e-753e-a02a-fd806b745283 | €49.00 | €0.67 | matched |
| 82 | capture | 01a19eba-9f10-7213-9aa0-546e8d33c17b | €24.00 | €0.37 | matched |
| 83 | capture | 01a19eba-ae92-7689-9baf-73ba3b5c5827 | €9.00 | €0.19 | matched |
| 84 | refund | 01a19eba-b393-7109-b2cb-abc94b6d040b | -€26.00 | €0.00 | matched |
| 85 | capture | 01a19eba-bc54-795a-90cb-90626a16ebf9 | €9.00 | €0.19 | matched |
| 86 | capture | 01a19eba-cdec-729d-8bce-821f7cc8ff4a | €35.00 | €0.50 | matched |
| 87 | capture | 01a19eba-d9d8-76a4-b253-af7844ce15d7 | €24.00 | €0.37 | matched |
| 88 | capture | 01a19eba-dae5-7efa-9690-d382a4d7e07c | €35.00 | €0.50 | matched |
| 89 | capture | 01a19eba-e3fc-78c0-aee2-23b75a1f2827 | €49.00 | €0.67 | matched |
| 90 | capture | 01a19ebb-0085-78f7-b01b-dba09bc94d0c | €49.00 | €0.67 | matched |
| 91 | refund | 01a19ebb-2841-784a-9b05-10db5f4a6115 | -€8.00 | €0.00 | matched |
| 92 | capture | 01a19ebb-29b1-7c71-a247-a727f001aa34 | €15.00 | €0.26 | matched |
| 93 | capture | 01a19ebb-32dc-7927-be2e-06402f304762 | €35.00 | €0.50 | matched |
| 94 | capture | 01a19ebb-4971-7663-99b1-4b0244fb3c8c | €24.00 | €0.37 | matched |
| 95 | capture | 01a19ebb-52bd-76e3-b190-704cc45de32d | €9.00 | €0.19 | matched |
| 96 | capture | 01a19ebb-9ddd-7298-9430-38649fe08b6d | €9.00 | €0.19 | matched |
| 97 | capture | 01a19ebb-bc93-7e14-9d8d-8012feae093d | €9.00 | €0.19 | matched |
| 98 | capture | 01a19ebb-c555-762f-a2d6-1e9ab038f328 | €24.00 | €0.37 | matched |
| 99 | capture | 01a19ebb-ccd0-71e1-a157-591ce1c33605 | €24.00 | €0.37 | matched |
| 100 | capture | 01a19ebb-eaed-7bde-8660-7777c6282c11 | €9.00 | €0.19 | matched |
| 101 | capture | 01a19ebc-0a1d-7cb9-912b-88adc2982869 | €9.00 | €0.19 | matched |
| 102 | capture | 01a19ebc-21d1-76e0-aab5-ba25e26b3496 | €35.00 | €0.50 | matched |
| 103 | capture | 01a19ebc-3921-756f-a36b-127d59f73444 | €49.00 | €0.67 | matched |
| 104 | capture | 01a19ebc-3a59-7d81-b40e-190c6ee7279c | €35.00 | €0.50 | matched |
| 105 | capture | 01a19ebc-3ac5-7938-985b-99b57071f874 | €15.00 | €0.26 | matched |
| 106 | capture | 01a19ebc-3aee-7282-9ca7-1fa7c32237c2 | €24.00 | €0.37 | matched |
| 107 | capture | 01a19ebc-44ce-7bbc-9a19-4aa9ad77b10c | €49.00 | €0.67 | matched |
| 108 | capture | 01a19ebc-482b-7aa7-8a81-52d92bf709ba | €35.00 | €0.50 | matched |
| 110 | capture | 01a19ebc-50ab-7cda-85aa-2e0b88ca6e8a | €15.00 | €0.26 | matched |
| 111 | capture | 01a19ebc-7205-76ae-98fb-ab185d41694c | €24.00 | €0.37 | matched |
| 112 | capture | 01a19ebc-7943-7a6f-b045-0cece2bdb007 | €35.00 | €0.50 | matched |
| 113 | refund | 01a19ebc-7e6c-7bf0-85c0-3438465bf8db | -€23.00 | €0.00 | matched |
| 114 | capture | 01a19ebc-8679-7125-ad3c-7a266abbcd6b | €15.00 | €0.26 | matched |
| 115 | refund | 01a19ebc-8b8b-7c8e-9e61-247188b7dfee | -€13.00 | €0.00 | matched |
| 116 | refund | 01a19ebc-8f82-7307-a81b-1674f9aa4c03 | -€10.00 | €0.00 | matched |
| 117 | capture | 01a19ebc-97f4-7ed7-8f80-9354ee38f717 | €35.00 | €0.50 | matched |
| 118 | capture | 01a19ebc-989d-7a30-b809-32e7e66156e1 | €24.00 | €0.37 | matched |
| 119 | capture | 01a19ebc-b6f4-7c76-886f-4d55793fccc2 | €9.00 | €0.19 | matched |
| 120 | capture | 01a19ebc-ba13-7fe0-907d-39c959fdbf4f | €35.00 | €0.50 | matched |
| 121 | capture | 01a19ebc-c817-76d5-9e3d-a1eae99ecbd9 | €15.00 | €0.26 | matched |
| 122 | capture | 01a19ebc-d559-78bf-aeac-258286599735 | €35.00 | €0.50 | matched |
| 124 | capture | 01a19ebc-e4a6-7e8e-ab50-13264ad213cc | €49.00 | €0.67 | matched |
| 125 | capture | 01a19ebc-e700-7185-9d6d-019cf938998e | €15.00 | €0.26 | matched |
| 126 | capture | 01a19ebc-e85b-710b-8d1d-037fd91049c6 | €35.00 | €0.50 | matched |
| 127 | capture | 01a19ebd-2723-7282-b0a9-0bf6ea7a0868 | €24.00 | €0.37 | matched |
| 128 | refund | 01a19ebd-295f-7086-8971-aee1bbef7260 | -€24.00 | €0.00 | matched |
| 129 | capture | 01a19ebd-3ef8-7f27-bbc9-3a71ee660069 | €35.00 | €0.50 | matched |
| 130 | capture | 01a19ebd-3f8c-79b9-8e0a-b8aae54d9cf1 | €9.00 | €0.19 | matched |
| 131 | capture | 01a19ebd-563c-71f0-a68b-4f9b769f63d9 | €49.00 | €0.67 | matched |
| 132 | capture | 01a19ebd-587e-77a9-a70a-10829ed1acd7 | €15.00 | €0.26 | matched |
| 133 | capture | 01a19ebd-5fc1-78dd-8707-d3f6b55e25be | €35.00 | €0.50 | matched |
| 134 | capture | 01a19ebd-6de4-71ac-afbc-fdbed37443bb | €35.00 | €0.50 | matched |
| 135 | capture | 01a19ebd-73e5-7817-a69e-fdeb775603c0 | €15.00 | €0.26 | matched |
| 136 | capture | 01a19ebd-8665-7868-b29b-aa51a7b87960 | €9.00 | €0.19 | matched |
| 137 | capture | 01a19ebd-8a3b-7457-957f-1c14455729b0 | €15.00 | €0.26 | matched |
| 139 | capture | 01a19ebd-ab56-7b9d-aee8-342198ce3768 | €35.00 | €0.50 | matched |
| 140 | capture | 01a19ebd-be00-78cf-8053-c955cf3f36f8 | €49.00 | €0.67 | matched |
| 141 | capture | 01a19ebd-bf70-7470-840a-d4c129b6a93e | €24.00 | €0.37 | matched |