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
- 15 Oct, 12:20123 lines1 break
- 15 Oct, 12:10126 lines3 breaks
- 15 Oct, 12:00143 lines3 breaks
- 15 Oct, 11:50137 lines3 breaks
- 15 Oct, 11:40129 linesclean
- 15 Oct, 11:30132 lines4 breaks
- 15 Oct, 11:20136 lines4 breaks
- 15 Oct, 11:10150 lines4 breaks
- 15 Oct, 11:00116 lines2 breaks
- 15 Oct, 10:50128 lines2 breaks
- 15 Oct, 10:40141 lines1 break
- 15 Oct, 10:30154 lines3 breaks
- 15 Oct, 10:20126 lines4 breaks
- 15 Oct, 10:10136 lines2 breaks
15 Oct, 11:10
Gross
€3,203.00
PSP fee
€53.10
Net to the bank
€3,149.90
Settlement journal
#13644
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13f41-3ef5-76c0-afc2-011dbbd42b17 is already settled by stl_EUR_2986771 line 3
- duplicate linethe file lists it twicecapture:01a13f44-dc84-7886-bd7a-7407ddad7614 is already settled by stl_EUR_2986772 line 1
- fee differencethe fee is not the contract feethe fee is 39, the contract says 37
- missing linein the books, not in the filecapture:01a13f47-ce8a-7f6a-9383-61d2a61f5d4b is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 4 | capture | 01a13f41-3f4e-74d5-891e-77d6b47569a9 | €9.00 | €0.19 | duplicate line |
| 103 | capture | 01a13f47-9b02-73a2-9811-1665ec5c6f24 | €24.00 | €0.39 | fee difference |
| 1 | capture | 01a13f3c-c246-710e-8c52-7b74df0e4c3b | €9.00 | €0.19 | matched |
| 2 | capture | 01a13f41-3646-73f9-910d-80d4ab8d3997 | €49.00 | €0.67 | matched |
| 3 | capture | 01a13f41-3f4e-74d5-891e-77d6b47569a9 | €9.00 | €0.19 | matched |
| 5 | capture | 01a13f41-4b22-7104-88fd-4c04c699ede7 | €9.00 | €0.19 | matched |
| 6 | capture | 01a13f41-591e-704a-9cc6-15fb394147dc | €49.00 | €0.67 | matched |
| 7 | capture | 01a13f41-81cf-7e9c-9af1-5167bd6b91a4 | €35.00 | €0.50 | matched |
| 8 | capture | 01a13f41-8a2a-7244-8a90-20abc2ce53e4 | €15.00 | €0.26 | matched |
| 9 | capture | 01a13f41-c897-7ec1-92ac-f67c42106957 | €24.00 | €0.37 | matched |
| 10 | capture | 01a13f41-cd86-76b2-b95e-a7a0d9c0853f | €15.00 | €0.26 | matched |
| 11 | capture | 01a13f41-d6b1-7182-b524-002b6b901dd7 | €49.00 | €0.67 | matched |
| 12 | capture | 01a13f41-f4b3-7368-adee-197786df017a | €35.00 | €0.50 | matched |
| 13 | capture | 01a13f42-04be-7f71-9e5a-c6d91358a767 | €35.00 | €0.50 | matched |
| 14 | capture | 01a13f42-08c8-7834-a409-612e0678ade6 | €35.00 | €0.50 | matched |
| 15 | capture | 01a13f42-3508-7c54-bab9-e610a8056e64 | €9.00 | €0.19 | matched |
| 16 | capture | 01a13f42-5dd9-7d5b-80f2-d0753caae7da | €24.00 | €0.37 | matched |
| 17 | capture | 01a13f42-5e87-7b7a-a5c2-a841770cee8b | €24.00 | €0.37 | matched |
| 18 | refund | 01a13f42-5afa-7dab-abc1-7080874fbc58 | -€12.00 | €0.00 | matched |
| 19 | capture | 01a13f42-72de-7134-9c20-6ef217d41c4c | €35.00 | €0.50 | matched |
| 20 | capture | 01a13f42-7506-7f2d-b77a-4b20ff4e7750 | €35.00 | €0.50 | matched |
| 21 | capture | 01a13f42-7988-7e35-9016-73b3c265233e | €9.00 | €0.19 | matched |
| 22 | capture | 01a13f42-7c4d-7267-b60b-3a11c294a094 | €24.00 | €0.37 | matched |
| 23 | capture | 01a13f42-c0a8-70e6-8cb6-3a4ccc645d35 | €24.00 | €0.37 | matched |
| 24 | capture | 01a13f42-f4d8-75e5-a49e-a1eecbc5f07a | €35.00 | €0.50 | matched |
| 25 | capture | 01a13f43-0527-77b4-8b82-cdae931fcf79 | €9.00 | €0.19 | matched |
| 26 | capture | 01a13f43-098a-7004-8632-dab344adab26 | €15.00 | €0.26 | matched |
| 27 | capture | 01a13f43-0fa4-7b1c-bb6d-8a774fe296be | €49.00 | €0.67 | matched |
| 28 | capture | 01a13f43-1e67-7ce2-bdc5-5c90ab2b83b8 | €49.00 | €0.67 | matched |
| 29 | capture | 01a13f43-518d-7987-9ab8-07d5b0eb249e | €35.00 | €0.50 | matched |
| 30 | capture | 01a13f43-57cd-7207-84fd-fda8d3f704c8 | €49.00 | €0.67 | matched |
| 31 | refund | 01a13f43-5bbb-7647-8d74-d7470a1d1de5 | -€16.00 | €0.00 | matched |
| 32 | refund | 01a13f43-6720-751e-a25f-2571d4406219 | -€42.00 | €0.00 | matched |
| 33 | capture | 01a13f43-701c-71a4-b673-c6a60b66e36a | €15.00 | €0.26 | matched |
| 34 | capture | 01a13f43-78f6-70cd-9249-4dfde7543721 | €49.00 | €0.67 | matched |
| 35 | capture | 01a13f43-77ec-7ef0-859b-c7e9a1db24b6 | €24.00 | €0.37 | matched |
| 36 | capture | 01a13f43-7c6d-7ff6-9a2b-0db7698790e9 | €24.00 | €0.37 | matched |
| 37 | capture | 01a13f43-89e4-736e-b9d5-b19beb4cdfaa | €49.00 | €0.67 | matched |
| 38 | capture | 01a13f43-b59e-7f30-9f23-14b0820b6494 | €24.00 | €0.37 | matched |
| 39 | capture | 01a13f43-b73b-7b25-99d5-31fddd23bbff | €49.00 | €0.67 | matched |
| 40 | capture | 01a13f43-bd70-7e69-af6c-dd381976226f | €15.00 | €0.26 | matched |
| 41 | capture | 01a13f43-d7f5-76a5-a0de-bdf09b6da394 | €15.00 | €0.26 | matched |
| 42 | capture | 01a13f43-f971-7b53-b4f8-de9845325370 | €24.00 | €0.37 | matched |
| 43 | capture | 01a13f44-2a88-7bcd-85f9-c8581a30316b | €24.00 | €0.37 | matched |
| 44 | capture | 01a13f44-2ac3-7ccb-838e-8a2344b65ae2 | €35.00 | €0.50 | matched |
| 45 | capture | 01a13f44-3094-7790-9041-5f4997af8d12 | €24.00 | €0.37 | matched |
| 46 | capture | 01a13f44-3e01-7ddb-9ca5-9f0120606d42 | €9.00 | €0.19 | matched |
| 47 | capture | 01a13f44-4203-75dd-9792-cab066f6b8ea | €9.00 | €0.19 | matched |
| 48 | capture | 01a13f44-5443-796e-9d05-c4b6614ba58c | €15.00 | €0.26 | matched |
| 49 | capture | 01a13f44-5ca8-7ee3-a29c-e4cebc1b51e0 | €24.00 | €0.37 | matched |
| 50 | capture | 01a13f44-5f76-746f-b21e-7a0815c05983 | €9.00 | €0.19 | matched |
| 51 | refund | 01a13f44-634d-785a-8102-eef5216527a8 | -€13.00 | €0.00 | matched |
| 52 | capture | 01a13f44-811a-7cbe-a9e7-d39aade6452d | €24.00 | €0.37 | matched |
| 53 | capture | 01a13f44-8b55-797e-ad26-de80518a94aa | €49.00 | €0.67 | matched |
| 54 | capture | 01a13f44-b6a8-7164-8936-0d516f2e3f4a | €35.00 | €0.50 | matched |
| 55 | capture | 01a13f44-dd1a-7298-ac10-2004ea668091 | €24.00 | €0.37 | matched |
| 56 | capture | 01a13f44-de9a-7959-962e-a228719ad55f | €35.00 | €0.50 | matched |
| 57 | capture | 01a13f44-dfb5-79b7-9617-0b4797b9ef08 | €15.00 | €0.26 | matched |
| 58 | capture | 01a13f44-f062-7677-af7e-cbf3fa87fc47 | €49.00 | €0.67 | matched |
| 59 | capture | 01a13f44-ff03-7313-a2d7-57c9d996d66e | €15.00 | €0.26 | matched |
| 60 | capture | 01a13f44-f191-76f3-abe0-e1305155ea14 | €35.00 | €0.50 | matched |
| 61 | capture | 01a13f45-37e4-7891-a90f-7145f5ef3580 | €49.00 | €0.67 | matched |
| 62 | capture | 01a13f45-56f1-7731-bc63-7a3777818e7a | €15.00 | €0.26 | matched |
| 63 | capture | 01a13f45-5ecd-7047-9f25-698b2ceae1b7 | €24.00 | €0.37 | matched |
| 64 | capture | 01a13f45-64d6-7753-b22f-7cd840dc65fe | €9.00 | €0.19 | matched |
| 65 | refund | 01a13f45-69ff-7afe-93b1-8304d3fa2a01 | -€8.00 | €0.00 | matched |
| 66 | capture | 01a13f45-71f5-70b0-9f09-ac735089fc49 | €49.00 | €0.67 | matched |
| 67 | capture | 01a13f45-9ef8-77e1-a8d2-40c0aae9bf38 | €15.00 | €0.26 | matched |
| 68 | refund | 01a13f45-b22d-7462-893f-fd662248cdf6 | -€31.00 | €0.00 | matched |
| 69 | capture | 01a13f45-c492-7c8a-8c96-dd3376866e06 | €24.00 | €0.37 | matched |
| 70 | capture | 01a13f45-c897-70fa-b243-bab41b418150 | €15.00 | €0.26 | matched |
| 71 | capture | 01a13f45-d1b7-76a7-a60c-d9dc2a944804 | €15.00 | €0.26 | matched |
| 72 | capture | 01a13f45-d62d-7e39-8066-70f4c419aaf6 | €9.00 | €0.19 | matched |
| 73 | capture | 01a13f45-f5d5-7b1a-a639-8cb5de2ada9e | €15.00 | €0.26 | matched |
| 74 | capture | 01a13f46-07da-7749-97e4-c1cc12aca625 | €24.00 | €0.37 | matched |
| 75 | capture | 01a13f46-1b4d-7834-aa8c-82de4fbb4b47 | €24.00 | €0.37 | matched |
| 76 | capture | 01a13f46-39a0-7c98-89fa-d9f63e3b5e39 | €49.00 | €0.67 | matched |
| 77 | capture | 01a13f46-3bd2-774d-af99-d5939e61d54a | €49.00 | €0.67 | matched |
| 78 | capture | 01a13f46-473e-7382-adbe-e43fa2340b2c | €24.00 | €0.37 | matched |
| 79 | capture | 01a13f46-505a-7176-9e77-0e9a57ea34a1 | €9.00 | €0.19 | matched |
| 80 | capture | 01a13f46-6162-7f0e-8060-1a5584b1e6f1 | €35.00 | €0.50 | matched |
| 81 | capture | 01a13f46-6a10-7f69-ab7e-5b5044d3b9e0 | €15.00 | €0.26 | matched |
| 82 | capture | 01a13f46-8171-769e-807d-75535ab2bf1d | €15.00 | €0.26 | matched |
| 83 | capture | 01a13f46-83cb-7c4b-96cc-d309c22fe57c | €35.00 | €0.50 | matched |
| 84 | capture | 01a13f46-95c7-7f98-8feb-c5127b1d21b0 | €9.00 | €0.19 | matched |
| 85 | refund | 01a13f46-9b93-7e23-9f4d-0ad70a92758c | -€17.00 | €0.00 | matched |
| 86 | capture | 01a13f46-9b97-7730-9933-745c7621185d | €35.00 | €0.50 | matched |
| 87 | capture | 01a13f46-9dba-7529-af93-84893cff75cd | €35.00 | €0.50 | matched |
| 88 | capture | 01a13f46-ae25-7c15-96be-7e21263069b8 | €35.00 | €0.50 | matched |
| 89 | refund | 01a13f46-b2e3-7558-854b-28846dbf3cb0 | -€12.00 | €0.00 | matched |
| 90 | capture | 01a13f46-c251-7a65-a71c-b6a0c5493a7d | €49.00 | €0.67 | matched |
| 91 | capture | 01a13f46-c54d-7ee7-9afb-1dff7a176c59 | €49.00 | €0.67 | matched |
| 92 | capture | 01a13f46-de7f-724c-a9ed-3565cb613976 | €9.00 | €0.19 | matched |
| 93 | capture | 01a13f46-e2db-79b4-b2bc-8d5ae81ff434 | €15.00 | €0.26 | matched |
| 94 | capture | 01a13f46-ed4a-72cd-8dc6-9ce224745b1c | €49.00 | €0.67 | matched |
| 95 | refund | 01a13f46-f7e3-72cf-95b4-c4b147b3c745 | -€49.00 | €0.00 | matched |
| 96 | refund | 01a13f47-3f6d-776f-9412-7b12c7b3ce24 | -€6.00 | €0.00 | matched |
| 97 | refund | 01a13f47-4417-7520-8237-c09a426109be | -€8.00 | €0.00 | matched |
| 98 | capture | 01a13f47-48d4-772f-9182-45bb656070de | €24.00 | €0.37 | matched |
| 99 | capture | 01a13f47-5346-722d-9db7-20c875c66fdc | €9.00 | €0.19 | matched |
| 100 | capture | 01a13f47-655e-7d29-b0d3-7d81cd4738c1 | €35.00 | €0.50 | matched |
| 101 | capture | 01a13f47-8073-7949-9d8d-1ab575d1dd47 | €9.00 | €0.19 | matched |
| 102 | capture | 01a13f47-8b16-742e-9066-21003af77e05 | €35.00 | €0.50 | matched |
| 104 | capture | 01a13f47-aeff-7703-869b-68623a8eb5db | €49.00 | €0.67 | matched |
| 105 | capture | 01a13f47-b379-73c7-a694-db745ef21699 | €9.00 | €0.19 | matched |
| 106 | refund | 01a13f47-b73c-7d3e-a3d5-a17c5ffb4341 | -€6.00 | €0.00 | matched |
| 107 | capture | 01a13f47-d744-78da-8cb0-45b4c05f6de4 | €49.00 | €0.67 | matched |
| 108 | capture | 01a13f47-df8c-7a70-8c11-017047d2bb40 | €15.00 | €0.26 | matched |
| 109 | refund | 01a13f47-f29e-774e-840a-33ea0015170e | -€6.00 | €0.00 | matched |
| 110 | capture | 01a13f47-fbcc-7312-b489-d2fa04de20a1 | €9.00 | €0.19 | matched |
| 111 | refund | 01a13f47-ff84-7923-9dec-ac3bab9ba0d7 | -€33.00 | €0.00 | matched |
| 112 | capture | 01a13f48-0164-739b-8dff-2ca3c5cbfc50 | €9.00 | €0.19 | matched |
| 113 | refund | 01a13f48-0ea9-78c6-8a4c-54c2b1fbbc8f | -€32.00 | €0.00 | matched |
| 114 | capture | 01a13f48-32de-73ee-b494-929b795558ab | €9.00 | €0.19 | matched |
| 115 | capture | 01a13f48-3fb0-77b1-b1b0-8d92c9446ff3 | €49.00 | €0.67 | matched |
| 116 | capture | 01a13f48-500b-7e36-b728-8d22123f0313 | €24.00 | €0.37 | matched |
| 117 | capture | 01a13f48-6bee-7c1b-a267-47ed102e4fe1 | €9.00 | €0.19 | matched |
| 118 | capture | 01a13f48-5cae-7ccb-8610-34b93c8c7ad5 | €49.00 | €0.67 | matched |
| 119 | capture | 01a13f48-836c-7daa-b2ab-42dd2f5fa827 | €9.00 | €0.19 | matched |
| 120 | capture | 01a13f48-98f9-7dc2-81f4-724f1e548c8a | €35.00 | €0.50 | matched |
| 121 | capture | 01a13f48-99c2-7c38-9c4c-5f0ac9fdebff | €49.00 | €0.67 | matched |
| 122 | capture | 01a13f48-b14a-7654-a291-8635b0711cc2 | €24.00 | €0.37 | matched |
| 123 | capture | 01a13f48-b488-77a8-8306-e9ef985c9cbd | €35.00 | €0.50 | matched |
| 124 | refund | 01a13f48-be8c-71ab-af41-8aeb36295283 | -€14.00 | €0.00 | matched |
| 125 | capture | 01a13f48-d796-7888-8ee5-6abb2f2e8d98 | €9.00 | €0.19 | matched |
| 126 | capture | 01a13f48-f334-74e6-91cf-525310307b2e | €35.00 | €0.50 | matched |
| 127 | capture | 01a13f49-0293-71da-b4a2-8e6950adf690 | €9.00 | €0.19 | matched |
| 128 | capture | 01a13f49-1b0c-7cc5-b73d-ceeb0d0d3b3c | €15.00 | €0.26 | matched |
| 129 | capture | 01a13f49-20c2-71d8-8292-eadff3d3bbea | €49.00 | €0.67 | matched |
| 130 | refund | 01a13f49-2300-7fc2-9945-4138fa1614b4 | -€6.00 | €0.00 | matched |
| 131 | capture | 01a13f49-2cba-7e2b-b175-642d00383581 | €35.00 | €0.50 | matched |
| 132 | capture | 01a13f49-2dc3-77e4-a81b-8bb22a031052 | €49.00 | €0.67 | matched |
| 133 | capture | 01a13f49-416b-7d88-9cbf-1cfa0580be4d | €35.00 | €0.50 | matched |
| 134 | capture | 01a13f49-44d6-7f7a-8124-4625fe3920c6 | €9.00 | €0.19 | matched |
| 135 | capture | 01a13f49-681b-7100-8d75-1d26e0f541e6 | €49.00 | €0.67 | matched |
| 136 | capture | 01a13f49-73a5-72a2-a84e-36fd1b82cabc | €9.00 | €0.19 | matched |
| 137 | refund | 01a13f49-9ce1-788c-b977-1ee16ad2acec | -€15.00 | €0.00 | matched |
| 138 | capture | 01a13f49-9f55-707e-9144-ee098e7ca61c | €24.00 | €0.37 | matched |
| 139 | capture | 01a13f49-b97a-7253-9560-8b460b7d234f | €24.00 | €0.37 | matched |
| 140 | capture | 01a13f49-dfd4-7c7d-a3b4-30ff7ceb80fa | €49.00 | €0.67 | matched |
| 141 | capture | 01a13f49-e538-759f-8cbd-375626c43e7e | €15.00 | €0.26 | matched |
| 142 | capture | 01a13f49-e5ab-7aa0-87a0-21b8d76ea352 | €24.00 | €0.37 | matched |
| 143 | capture | 01a13f49-ed3a-7e44-a4e3-968e6e7fce08 | €24.00 | €0.37 | matched |
| 144 | capture | 01a13f49-f081-7db4-a56e-c286b96429c1 | €15.00 | €0.26 | matched |
| 145 | capture | 01a13f49-f42d-7f3f-a460-b4bce3e4cea3 | €15.00 | €0.26 | matched |
| 146 | capture | 01a13f4a-0d3f-7631-891c-37f479c94951 | €49.00 | €0.67 | matched |
| 147 | capture | 01a13f4a-0d49-7582-9fd3-56f3894fb7f2 | €24.00 | €0.37 | matched |
| 148 | capture | 01a13f4a-0fc0-7499-8e53-ec4886adf766 | €24.00 | €0.37 | matched |
| 149 | capture | 01a13f4a-2803-7df3-af11-e8eee93df035 | €24.00 | €0.37 | matched |
| 150 | capture | 01a13f4a-32d6-79f6-9922-561d212037dd | €24.00 | €0.37 | matched |