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
- 25 Oct, 08:40126 lines2 breaks
- 25 Oct, 08:30128 lines3 breaks
- 25 Oct, 08:20133 lines2 breaks
- 25 Oct, 08:10110 lines1 break
- 25 Oct, 08:00153 lines4 breaks
- 25 Oct, 07:50141 lines4 breaks
- 25 Oct, 07:40129 lines3 breaks
- 25 Oct, 07:30115 lines3 breaks
- 25 Oct, 07:20123 lines4 breaks
- 25 Oct, 07:10111 lines5 breaks
- 25 Oct, 07:00135 lines2 breaks
- 25 Oct, 06:50122 lines1 break
- 25 Oct, 06:40137 lines1 break
- 25 Oct, 06:30121 lines6 breaks
25 Oct, 07:20
Gross
€2,692.00
PSP fee
€44.11
Net to the bank
€2,647.89
Settlement journal
#192809
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a171ef-03c8-7469-abf2-a494c3c50b49 is already settled by stl_EUR_2988188 line 15
- fee differencethe fee is not the contract feethe fee is 51, the contract says 50
- missing linein the books, not in the filerefund:01a171ee-a644-700e-8b83-c5a6e6213463 is in no file
- missing linein the books, not in the filecapture:01a171ef-11eb-710e-84a6-3505dc3a746d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 16 | capture | 01a171ef-04b6-7c59-b422-9bc78012e497 | €24.00 | €0.37 | duplicate line |
| 27 | capture | 01a171f0-386f-78c4-8b46-57258c58d26c | €35.00 | €0.51 | fee difference |
| 1 | capture | 01a171e5-20a8-7b9b-b4ea-f9a6c96951fd | €24.00 | €0.37 | matched |
| 2 | refund | 01a171e6-6514-75e2-a816-1a15102a9bd3 | -€30.00 | €0.00 | matched |
| 3 | capture | 01a171e8-5790-714c-818f-e724f804282f | €49.00 | €0.67 | matched |
| 4 | capture | 01a171ee-4255-7c71-b997-ce5c7caf5e14 | €24.00 | €0.37 | matched |
| 5 | capture | 01a171ee-5559-7b95-b073-644d58435c9a | €15.00 | €0.26 | matched |
| 6 | capture | 01a171ee-5d20-707a-9811-6e139ffa2185 | €15.00 | €0.26 | matched |
| 7 | capture | 01a171ee-6b12-70d2-8fd6-aab9be10c4fb | €24.00 | €0.37 | matched |
| 8 | capture | 01a171ee-70d3-759b-9bb2-aee49d3c6d70 | €35.00 | €0.50 | matched |
| 9 | capture | 01a171ee-7f93-7663-bb63-066e7a8f3d5c | €9.00 | €0.19 | matched |
| 10 | refund | 01a171ee-ae44-7ff0-b18e-ab44f5311635 | -€34.00 | €0.00 | matched |
| 11 | capture | 01a171ee-afeb-7c2a-ab74-c5f888b02bb8 | €35.00 | €0.50 | matched |
| 12 | capture | 01a171ee-c489-77a3-a961-2440a992328f | €15.00 | €0.26 | matched |
| 13 | capture | 01a171ee-da6d-7620-b5ce-4a66da1a94d4 | €35.00 | €0.50 | matched |
| 14 | capture | 01a171ef-0df5-7ff8-8c95-6342b1d6c4d1 | €49.00 | €0.67 | matched |
| 15 | capture | 01a171ef-04b6-7c59-b422-9bc78012e497 | €24.00 | €0.37 | matched |
| 17 | capture | 01a171ef-109c-7f68-bad4-f146f3681101 | €49.00 | €0.67 | matched |
| 18 | capture | 01a171ef-1f26-7052-8caf-b93c2e162d4c | €24.00 | €0.37 | matched |
| 19 | capture | 01a171ef-2045-7bb3-b506-69a3a471f0ba | €24.00 | €0.37 | matched |
| 20 | capture | 01a171ef-29c3-7616-95f0-bc79f0b2abc7 | €15.00 | €0.26 | matched |
| 21 | capture | 01a171ef-4483-7e1c-9eab-009a29c54f7f | €35.00 | €0.50 | matched |
| 22 | capture | 01a171ef-64d9-7556-891a-b38c30f78d74 | €9.00 | €0.19 | matched |
| 23 | capture | 01a171ef-b40a-75bf-ac61-e9d6858f4df4 | €24.00 | €0.37 | matched |
| 24 | capture | 01a171ef-b916-73e7-a28f-68fdd8b42f86 | €15.00 | €0.26 | matched |
| 25 | capture | 01a171f0-0f0f-7f7e-af7d-6c20eccebd3a | €49.00 | €0.67 | matched |
| 26 | capture | 01a171f0-29f8-7905-b51a-f6835de3a0c8 | €49.00 | €0.67 | matched |
| 28 | capture | 01a171f0-391b-7626-8193-74caa2427add | €9.00 | €0.19 | matched |
| 29 | capture | 01a171f0-3e98-76d6-b369-cef0add34b28 | €15.00 | €0.26 | matched |
| 30 | capture | 01a171f0-60f4-7f2b-99e0-2ae1fc3579e1 | €15.00 | €0.26 | matched |
| 31 | refund | 01a171f0-61da-78c0-b6c5-f0d2e86ca1e1 | -€13.00 | €0.00 | matched |
| 32 | capture | 01a171f0-68e0-7725-9500-68b313d75916 | €9.00 | €0.19 | matched |
| 33 | capture | 01a171f0-85c9-709a-9387-92a4245d0572 | €9.00 | €0.19 | matched |
| 34 | capture | 01a171f0-863d-7047-9d85-2ad396835885 | €24.00 | €0.37 | matched |
| 35 | capture | 01a171f0-980a-7eaa-b7ef-5326734e72f5 | €24.00 | €0.37 | matched |
| 36 | capture | 01a171f0-a3fd-728a-9059-e67b1da78c9d | €35.00 | €0.50 | matched |
| 37 | capture | 01a171f0-c469-7a41-88d8-5bc71f51b531 | €15.00 | €0.26 | matched |
| 38 | capture | 01a171f0-dcff-7261-a899-12fe3aecfe4c | €15.00 | €0.26 | matched |
| 39 | capture | 01a171f0-e5a8-7342-af5a-fbba01b34fec | €49.00 | €0.67 | matched |
| 40 | capture | 01a171f1-0159-7313-a528-a72ecbe9a1d6 | €49.00 | €0.67 | matched |
| 41 | capture | 01a171f1-0e7f-742e-a2f6-603ad5382a89 | €24.00 | €0.37 | matched |
| 42 | capture | 01a171f1-1079-73b5-8761-f1b9d5ade0f4 | €9.00 | €0.19 | matched |
| 43 | capture | 01a171f1-1e27-74b5-a6c0-06a3bfda61b2 | €49.00 | €0.67 | matched |
| 44 | capture | 01a171f1-3336-7e3e-9dbd-64063ab8cf20 | €9.00 | €0.19 | matched |
| 45 | refund | 01a171f1-4dac-7c14-91c5-bbbf27738bdd | -€30.00 | €0.00 | matched |
| 46 | capture | 01a171f1-6229-7dd9-bc14-abd6c7dfe9f5 | €15.00 | €0.26 | matched |
| 47 | capture | 01a171f1-6d2e-782a-ac28-46a608ea4fd8 | €15.00 | €0.26 | matched |
| 48 | capture | 01a171f1-6e19-7249-b978-9cfef3f08d62 | €24.00 | €0.37 | matched |
| 49 | capture | 01a171f1-7e8b-76b8-b334-b6cf7a1ab9c0 | €35.00 | €0.50 | matched |
| 50 | capture | 01a171f1-aed2-7569-8e55-f9ee6b990bf7 | €9.00 | €0.19 | matched |
| 51 | capture | 01a171f1-cbf5-761f-be53-82ae9327da26 | €15.00 | €0.26 | matched |
| 52 | capture | 01a171f1-d0b3-7762-b0c1-5f3cbba0c91c | €9.00 | €0.19 | matched |
| 53 | capture | 01a171f1-f712-7233-b57e-a154efca0757 | €24.00 | €0.37 | matched |
| 54 | capture | 01a171f1-fd79-72b2-b103-d92463184545 | €49.00 | €0.67 | matched |
| 55 | capture | 01a171f2-1695-719e-8799-7d74f5a30024 | €9.00 | €0.19 | matched |
| 56 | capture | 01a171f2-21fc-784b-a5d3-bf806da42fb7 | €15.00 | €0.26 | matched |
| 57 | capture | 01a171f2-2bee-70d8-983a-d80129cdae3c | €49.00 | €0.67 | matched |
| 58 | capture | 01a171f2-2e43-7e2e-9167-90007ec382ba | €24.00 | €0.37 | matched |
| 59 | capture | 01a171f2-40e8-78ae-92f9-401c40e873b9 | €9.00 | €0.19 | matched |
| 60 | capture | 01a171f2-7543-70a4-8e25-a102255821b1 | €24.00 | €0.37 | matched |
| 61 | capture | 01a171f2-8488-730f-8880-66ad82115b07 | €15.00 | €0.26 | matched |
| 62 | capture | 01a171f2-a313-7261-9c5c-66338151f16b | €35.00 | €0.50 | matched |
| 63 | capture | 01a171f2-a3cc-71a0-8eb7-635990344c0a | €49.00 | €0.67 | matched |
| 64 | capture | 01a171f2-cc67-71a9-b3a8-9954c1c35e12 | €24.00 | €0.37 | matched |
| 65 | capture | 01a171f2-d67a-733f-8a14-0e1dbb1cd56b | €9.00 | €0.19 | matched |
| 66 | capture | 01a171f2-dbf3-7c3c-b744-c7d0140dad5e | €24.00 | €0.37 | matched |
| 67 | capture | 01a171f2-dc5f-7d4c-bcc3-ccde2958aada | €35.00 | €0.50 | matched |
| 68 | capture | 01a171f2-f5db-79aa-b993-e16244a5f255 | €15.00 | €0.26 | matched |
| 69 | refund | 01a171f3-1ae2-71fa-a14f-88d4accf5e6e | -€9.00 | €0.00 | matched |
| 70 | capture | 01a171f3-1fb7-7858-ae55-8b62aeed119d | €35.00 | €0.50 | matched |
| 71 | capture | 01a171f3-26ff-745a-975e-458adbcf9eda | €15.00 | €0.26 | matched |
| 72 | capture | 01a171f3-3082-7ce7-90fe-15160363c5f2 | €35.00 | €0.50 | matched |
| 73 | capture | 01a171f3-3860-7c44-ae2d-516d3709dc7c | €24.00 | €0.37 | matched |
| 74 | capture | 01a171f3-3bcb-7987-b50c-63672f471b84 | €49.00 | €0.67 | matched |
| 75 | capture | 01a171f3-4324-7ecb-9b7d-e0b29d1ace4b | €35.00 | €0.50 | matched |
| 76 | capture | 01a171f3-544d-738a-ad93-9a1fe972f900 | €24.00 | €0.37 | matched |
| 77 | capture | 01a171f3-55b1-7c43-ad31-cd4a1d3bee00 | €15.00 | €0.26 | matched |
| 78 | capture | 01a171f3-5724-7a35-8e82-fa484a3ede5b | €15.00 | €0.26 | matched |
| 79 | capture | 01a171f3-5ea5-76c1-9255-b5521f2adfa5 | €9.00 | €0.19 | matched |
| 80 | capture | 01a171f3-61f9-769c-b397-8b4bdd75482b | €35.00 | €0.50 | matched |
| 81 | refund | 01a171f3-7676-7625-9fc5-2f2d9d76a48c | -€33.00 | €0.00 | matched |
| 82 | capture | 01a171f3-9f80-78c4-be1b-5d6f5af530b6 | €9.00 | €0.19 | matched |
| 83 | capture | 01a171f3-a29b-7bae-bc3f-7aeb57f3d389 | €35.00 | €0.50 | matched |
| 84 | capture | 01a171f3-bdfd-7631-b432-37c55a1310de | €35.00 | €0.50 | matched |
| 85 | capture | 01a171f3-c9e8-7260-87a4-36137bdeb095 | €35.00 | €0.50 | matched |
| 86 | capture | 01a171f3-d315-7e9b-a8e4-2af3469693f7 | €9.00 | €0.19 | matched |
| 87 | capture | 01a171f3-fd5b-7714-9ac1-d17651471f6f | €24.00 | €0.37 | matched |
| 88 | capture | 01a171f3-ff60-7114-a827-58aa8ee340cb | €24.00 | €0.37 | matched |
| 89 | capture | 01a171f4-0ecd-7cd5-a6ed-b4b7132d32c4 | €35.00 | €0.50 | matched |
| 90 | refund | 01a171f4-1493-7d26-9002-dd47b0cb0757 | -€8.00 | €0.00 | matched |
| 91 | refund | 01a171f4-2dec-7d57-8f20-308bdffd5bda | -€23.00 | €0.00 | matched |
| 92 | capture | 01a171f4-a958-76c5-a0f4-7d6c27dd7d88 | €15.00 | €0.26 | matched |
| 93 | capture | 01a171f4-ade0-7c8e-84d6-3fcaa3c08bb0 | €9.00 | €0.19 | matched |
| 94 | capture | 01a171f4-c4e1-7e19-aae3-decea6e84668 | €24.00 | €0.37 | matched |
| 95 | capture | 01a171f4-c679-7da0-9545-508434e3e721 | €49.00 | €0.67 | matched |
| 96 | capture | 01a171f4-c8c2-7e31-a759-95ae800fea15 | €35.00 | €0.50 | matched |
| 97 | refund | 01a171f5-037f-7554-8d87-31e604c61a24 | -€31.00 | €0.00 | matched |
| 98 | capture | 01a171f5-36de-710d-b40c-66b310ff6554 | €9.00 | €0.19 | matched |
| 99 | capture | 01a171f5-3efb-71a5-9a37-b2d46d5dede7 | €9.00 | €0.19 | matched |
| 100 | capture | 01a171f5-5707-77d7-b63c-9fa397dc5f9a | €9.00 | €0.19 | matched |
| 101 | capture | 01a171f5-7934-74a5-91d1-b741202c35a8 | €35.00 | €0.50 | matched |
| 102 | capture | 01a171f5-800f-7517-9566-cdb86babfee1 | €15.00 | €0.26 | matched |
| 103 | capture | 01a171f5-a55e-7024-9a21-1faec086c595 | €35.00 | €0.50 | matched |
| 104 | capture | 01a171f5-b95d-70ee-9d40-1b337971d84b | €35.00 | €0.50 | matched |
| 105 | refund | 01a171f5-c355-71d1-9cb4-2c170c6c73f6 | -€8.00 | €0.00 | matched |
| 106 | capture | 01a171f5-e097-7089-b035-7b887402d1c7 | €24.00 | €0.37 | matched |
| 107 | capture | 01a171f5-ff3c-7d9b-9a78-3ebe071a1203 | €9.00 | €0.19 | matched |
| 108 | capture | 01a171f6-1499-7296-9f50-1f7bf6341050 | €35.00 | €0.50 | matched |
| 109 | capture | 01a171f6-260f-7b5f-9099-00e171a06e9e | €49.00 | €0.67 | matched |
| 110 | capture | 01a171f6-2f49-73f3-a535-825cc6a86df8 | €35.00 | €0.50 | matched |
| 111 | capture | 01a171f6-38e2-7cbf-a82c-f2220ce0c395 | €49.00 | €0.67 | matched |
| 112 | capture | 01a171f6-4813-7307-afcd-63454f052dc6 | €35.00 | €0.50 | matched |
| 113 | capture | 01a171f6-6101-7401-a9fe-72867762c1cd | €35.00 | €0.50 | matched |
| 114 | capture | 01a171f6-73a8-7502-bf47-aa030d7d43b6 | €15.00 | €0.26 | matched |
| 115 | capture | 01a171f6-8634-7651-9b9a-bbb330c2d2a2 | €15.00 | €0.26 | matched |
| 116 | capture | 01a171f6-8474-7432-b21d-540f263e394b | €9.00 | €0.19 | matched |
| 117 | capture | 01a171f6-8dfc-7d0d-84ef-8c44a071394b | €15.00 | €0.26 | matched |
| 118 | capture | 01a171f6-aa51-71d9-a5f2-b8ee3692a850 | €49.00 | €0.67 | matched |
| 119 | capture | 01a171f6-aec0-731d-b5cb-6922d7e85935 | €9.00 | €0.19 | matched |
| 120 | capture | 01a171f6-c775-72df-b3ef-04eb7a0779c1 | €24.00 | €0.37 | matched |
| 121 | capture | 01a171f7-04d5-7ee9-991d-22c1686fab75 | €49.00 | €0.67 | matched |
| 122 | capture | 01a171f7-054b-79c8-a965-e9b17fa4fc13 | €49.00 | €0.67 | matched |
| 123 | capture | 01a171f7-346c-705a-a8dc-816c428c800e | €35.00 | €0.50 | matched |