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, 20:40128 lines1 break
- 30 Oct, 20:30135 lines1 break
- 30 Oct, 20:20123 lines3 breaks
- 30 Oct, 20:10138 lines3 breaks
- 30 Oct, 20:00138 lines3 breaks
- 30 Oct, 19:50130 lines7 breaks
- 30 Oct, 19:40105 lines3 breaks
- 30 Oct, 19:30125 lines4 breaks
- 30 Oct, 19:20126 lines4 breaks
- 30 Oct, 19:10118 lines3 breaks
- 30 Oct, 19:00114 lines2 breaks
- 30 Oct, 18:50120 lines2 breaks
- 30 Oct, 18:40126 lines3 breaks
- 30 Oct, 18:30124 lines6 breaks
30 Oct, 19:50
Gross
€3,221.00
PSP fee
€50.68
Net to the bank
€3,170.32
Settlement journal
#293495
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18e5f-8655-78fc-91c2-e610cc24136e is already settled by stl_EUR_2988983 line 35
- fee differencethe fee is not the contract feethe fee is 70, the contract says 67
- 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 24, the contract says 19
- missing linein the books, not in the filecapture:01a18e61-2706-70d5-8c2e-4739e66fc48d is in no file
- missing linein the books, not in the filecapture:01a18e64-1523-7273-bb4c-a47829ee6f20 is in no file
- missing linein the books, not in the filecapture:01a18e64-43ca-7fb2-a795-00cd86cf932e is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 5 | capture | 01a18e5c-ae11-74b4-8b2d-2c3bcdcd9e8b | €49.00 | €0.70 | fee difference |
| 9 | capture | 01a18e5c-f64c-710a-8cba-c3d163bca79c | €9.00 | €0.23 | fee difference |
| 36 | capture | 01a18e5f-868b-7702-a2ee-747f5d22e154 | €15.00 | €0.26 | duplicate line |
| 85 | capture | 01a18e62-8088-7a04-90c4-c87c0b8054c9 | €9.00 | €0.24 | fee difference |
| 1 | capture | 01a18e53-e2af-77c3-805b-e007d6686f8d | €24.00 | €0.37 | matched |
| 2 | capture | 01a18e54-5913-7a1b-a6be-6ffecce31b0d | €35.00 | €0.50 | matched |
| 3 | capture | 01a18e56-886d-701a-8d8c-6edb8a9d86d0 | €24.00 | €0.37 | matched |
| 4 | capture | 01a18e5c-4ac5-7489-abf2-49b26c9aa642 | €49.00 | €0.67 | matched |
| 6 | capture | 01a18e5c-b0d7-7f2a-aac8-593e1e4048bb | €49.00 | €0.67 | matched |
| 7 | capture | 01a18e5c-c9ab-78bc-a71a-74aa9c214315 | €35.00 | €0.50 | matched |
| 8 | capture | 01a18e5c-e0b9-7008-9107-e6fe34dea894 | €49.00 | €0.67 | matched |
| 10 | capture | 01a18e5d-2c3c-719d-ba28-da3b391c0ab6 | €9.00 | €0.19 | matched |
| 11 | capture | 01a18e5d-39a9-7c68-a609-c43657ca74ad | €15.00 | €0.26 | matched |
| 12 | capture | 01a18e5d-401b-7d8c-8031-427ae48f4dce | €49.00 | €0.67 | matched |
| 13 | capture | 01a18e5d-40f5-7758-a243-657258f597e7 | €24.00 | €0.37 | matched |
| 14 | capture | 01a18e5d-70ae-74dd-8b3f-68447842e7ec | €24.00 | €0.37 | matched |
| 15 | capture | 01a18e5d-70b7-71fb-975d-5535eca4d9c6 | €24.00 | €0.37 | matched |
| 16 | capture | 01a18e5d-967c-713f-83b0-ce63f2a4d06a | €15.00 | €0.26 | matched |
| 17 | capture | 01a18e5d-98b8-7ea4-b490-9bba9f8993ef | €24.00 | €0.37 | matched |
| 18 | capture | 01a18e5d-ed1b-7cb7-bb6d-4a658bc7d625 | €49.00 | €0.67 | matched |
| 19 | capture | 01a18e5d-f82d-7a06-8433-c761c482b923 | €9.00 | €0.19 | matched |
| 20 | capture | 01a18e5e-357c-759a-b81e-59a8e6597633 | €24.00 | €0.37 | matched |
| 21 | capture | 01a18e5e-342d-7bde-bf94-43658138064f | €9.00 | €0.19 | matched |
| 22 | capture | 01a18e5e-47f0-71f2-a958-1dd2eccfa923 | €9.00 | €0.19 | matched |
| 23 | capture | 01a18e5e-72a1-76fa-9c79-d7a9f45ab2ec | €35.00 | €0.50 | matched |
| 24 | capture | 01a18e5e-7b95-77cb-b1a6-d57d015d40bf | €15.00 | €0.26 | matched |
| 25 | capture | 01a18e5e-7bff-7207-8dd7-9075ae7d441f | €24.00 | €0.37 | matched |
| 26 | capture | 01a18e5e-98c1-7325-b0f7-8c23317e589a | €15.00 | €0.26 | matched |
| 27 | capture | 01a18e5e-ca57-77c2-a872-f20d7ff8ae21 | €24.00 | €0.37 | matched |
| 28 | capture | 01a18e5e-e352-754e-b5ab-f3bcc923ddcf | €9.00 | €0.19 | matched |
| 29 | capture | 01a18e5f-0f96-73b8-b2a3-61e504c4cdb7 | €49.00 | €0.67 | matched |
| 30 | capture | 01a18e5f-1fa3-7dcf-ac7e-5dc9f3b9feb4 | €49.00 | €0.67 | matched |
| 31 | capture | 01a18e5f-58a8-7911-ab7f-7661ca5dde96 | €9.00 | €0.19 | matched |
| 32 | capture | 01a18e5f-6b46-77c6-9b7c-51d527a6e170 | €24.00 | €0.37 | matched |
| 33 | capture | 01a18e5f-6d0e-7305-aeb1-b2efc36bf008 | €24.00 | €0.37 | matched |
| 34 | capture | 01a18e5f-833e-7533-9e7b-1a27116e883b | €49.00 | €0.67 | matched |
| 35 | capture | 01a18e5f-868b-7702-a2ee-747f5d22e154 | €15.00 | €0.26 | matched |
| 37 | capture | 01a18e5f-8ee0-7caf-b250-3629214c22ef | €35.00 | €0.50 | matched |
| 38 | capture | 01a18e5f-9318-7fe9-a9f3-ce921d02f263 | €24.00 | €0.37 | matched |
| 39 | capture | 01a18e5f-9911-7a6b-9c84-7617a78e9f7d | €49.00 | €0.67 | matched |
| 40 | capture | 01a18e5f-c9ba-7043-a701-06f9f9bcdd50 | €24.00 | €0.37 | matched |
| 41 | refund | 01a18e5f-cead-753b-845d-c0a71bf30031 | -€11.00 | €0.00 | matched |
| 42 | refund | 01a18e5f-eae7-78ec-ab67-cf67762c38b6 | -€38.00 | €0.00 | matched |
| 43 | capture | 01a18e5f-eea9-7e43-aea9-d044233172a4 | €9.00 | €0.19 | matched |
| 44 | capture | 01a18e60-15d8-75e8-a2e8-10e483958570 | €9.00 | €0.19 | matched |
| 45 | capture | 01a18e60-17fa-76ab-80bc-000cc7ea84ac | €49.00 | €0.67 | matched |
| 46 | capture | 01a18e60-4399-7efd-860c-03c404511e3c | €49.00 | €0.67 | matched |
| 47 | refund | 01a18e60-61d6-7859-abc8-e7fcb1cf1b70 | -€4.00 | €0.00 | matched |
| 48 | capture | 01a18e60-7fe7-70e6-b69b-f03edaea5265 | €35.00 | €0.50 | matched |
| 49 | capture | 01a18e60-8f70-72ca-96a3-1336465ab5c2 | €35.00 | €0.50 | matched |
| 50 | refund | 01a18e60-c3b0-7831-8844-f8f78baa8b34 | -€20.00 | €0.00 | matched |
| 51 | capture | 01a18e60-cc59-7d33-9cc2-190efa02cabe | €35.00 | €0.50 | matched |
| 52 | capture | 01a18e60-d457-7573-926c-4ab5ea50ebee | €24.00 | €0.37 | matched |
| 53 | capture | 01a18e60-d4a7-789f-a00a-2a314d1956dd | €15.00 | €0.26 | matched |
| 54 | capture | 01a18e60-da0a-7d1a-a2df-e2d213c722ae | €15.00 | €0.26 | matched |
| 55 | capture | 01a18e60-e2bc-79a9-96c6-5abe69c8e1fb | €9.00 | €0.19 | matched |
| 56 | capture | 01a18e60-ee74-76a7-8dce-5d9faae37537 | €49.00 | €0.67 | matched |
| 57 | capture | 01a18e60-f9d8-7496-86ad-f16601a8e964 | €15.00 | €0.26 | matched |
| 58 | capture | 01a18e60-ff90-74a3-93da-bc05a02be01b | €24.00 | €0.37 | matched |
| 59 | capture | 01a18e61-058b-725d-b525-06278dcd7691 | €15.00 | €0.26 | matched |
| 60 | capture | 01a18e61-4bec-78c1-b3c3-3bed83dc3a1d | €35.00 | €0.50 | matched |
| 61 | refund | 01a18e61-5636-7c7b-bcbf-502e9f444603 | -€27.00 | €0.00 | matched |
| 62 | capture | 01a18e61-86ab-7422-af1f-655cc42a2e99 | €35.00 | €0.50 | matched |
| 63 | capture | 01a18e61-9b1b-7711-8ae6-5bfab3b39c9e | €35.00 | €0.50 | matched |
| 64 | capture | 01a18e61-a8cc-7214-b650-2d4819887acf | €35.00 | €0.50 | matched |
| 65 | capture | 01a18e61-a95e-71d5-9eec-4df2bf50e9a6 | €49.00 | €0.67 | matched |
| 66 | capture | 01a18e61-b1a3-7600-abbc-989b774dc88d | €49.00 | €0.67 | matched |
| 67 | capture | 01a18e61-b5f9-7b83-9f7f-4d76f267e49a | €15.00 | €0.26 | matched |
| 68 | capture | 01a18e61-c2c3-7baf-a24d-e518c48930a0 | €35.00 | €0.50 | matched |
| 69 | capture | 01a18e61-cb71-7401-be50-3a58c2ef99f2 | €24.00 | €0.37 | matched |
| 70 | capture | 01a18e61-d14e-7147-acb3-bf32e0c74a24 | €15.00 | €0.26 | matched |
| 71 | capture | 01a18e61-e025-731d-8dc5-a72fb875f495 | €49.00 | €0.67 | matched |
| 72 | capture | 01a18e61-e568-7410-a599-cc4c0a883245 | €9.00 | €0.19 | matched |
| 73 | capture | 01a18e61-eac0-7323-83d1-6d936a210441 | €35.00 | €0.50 | matched |
| 74 | refund | 01a18e61-ecb1-7f6c-8c7c-5ccad61c13ba | -€7.00 | €0.00 | matched |
| 75 | capture | 01a18e61-efab-7230-8eb1-e4a8cc876b76 | €35.00 | €0.50 | matched |
| 76 | capture | 01a18e61-ffc6-74ce-950d-f980656ea796 | €9.00 | €0.19 | matched |
| 77 | capture | 01a18e62-15b3-7a1b-b049-5779f4810d44 | €49.00 | €0.67 | matched |
| 78 | capture | 01a18e62-3be0-78de-9906-c2928eb5346d | €15.00 | €0.26 | matched |
| 79 | capture | 01a18e62-5990-7c12-9f39-ae7b32742742 | €35.00 | €0.50 | matched |
| 80 | capture | 01a18e62-665b-7670-9cd0-11e00029d271 | €35.00 | €0.50 | matched |
| 81 | capture | 01a18e62-6de3-74d6-b6c6-306a987c3ba5 | €49.00 | €0.67 | matched |
| 82 | refund | 01a18e62-6eaa-76dd-8055-7ea1c5b6f4a7 | -€8.00 | €0.00 | matched |
| 83 | capture | 01a18e62-701a-7b8b-90c4-85143d32b693 | €35.00 | €0.50 | matched |
| 84 | capture | 01a18e62-6ebe-746f-8d21-41c833881954 | €24.00 | €0.37 | matched |
| 86 | capture | 01a18e62-82e1-720b-b872-b787088b42d6 | €9.00 | €0.19 | matched |
| 87 | capture | 01a18e62-9031-74b9-9eba-c9366a8d025a | €24.00 | €0.37 | matched |
| 88 | capture | 01a18e62-a053-71ed-8cec-a8f6011a5d0f | €15.00 | €0.26 | matched |
| 89 | capture | 01a18e62-c38c-726c-96b2-a0bb6a0b485a | €15.00 | €0.26 | matched |
| 90 | capture | 01a18e62-fbda-7565-8a0a-5d3c949a0a24 | €35.00 | €0.50 | matched |
| 91 | capture | 01a18e63-123f-7c19-a7ee-f9da9faa191a | €35.00 | €0.50 | matched |
| 92 | capture | 01a18e63-1304-7d43-803c-342a5d317627 | €35.00 | €0.50 | matched |
| 93 | refund | 01a18e63-63c8-7115-8094-8b0f8b1a7121 | -€31.00 | €0.00 | matched |
| 94 | capture | 01a18e63-6e05-7a86-873b-2fd00ce30aba | €15.00 | €0.26 | matched |
| 95 | capture | 01a18e63-8ba5-7d63-bd10-6243ed3008eb | €35.00 | €0.50 | matched |
| 96 | capture | 01a18e63-92f0-7865-865a-ac254350166b | €49.00 | €0.67 | matched |
| 97 | capture | 01a18e63-ad4b-734b-8375-fac24e4e04db | €9.00 | €0.19 | matched |
| 98 | capture | 01a18e63-c00d-7a3d-84a0-ca456cf68d35 | €35.00 | €0.50 | matched |
| 99 | capture | 01a18e63-ec53-7200-886a-99300138e875 | €24.00 | €0.37 | matched |
| 100 | capture | 01a18e63-f0b6-7e5a-b08e-9541b5860e98 | €9.00 | €0.19 | matched |
| 101 | capture | 01a18e64-131d-7bfd-90ab-8262086ddaf6 | €24.00 | €0.37 | matched |
| 102 | capture | 01a18e64-2c27-7374-a537-3f4ce1ad6590 | €49.00 | €0.67 | matched |
| 103 | capture | 01a18e64-4284-7924-8ded-7da2438152e0 | €35.00 | €0.50 | matched |
| 104 | capture | 01a18e64-529e-7838-9dc2-4cd2316db4a2 | €35.00 | €0.50 | matched |
| 105 | capture | 01a18e64-5bd7-7e8e-ad11-0e004a6c1588 | €49.00 | €0.67 | matched |
| 106 | capture | 01a18e64-5e4a-781f-8619-6f311d99029f | €24.00 | €0.37 | matched |
| 107 | capture | 01a18e64-7dfa-7a99-b020-11dfa43ac28c | €15.00 | €0.26 | matched |
| 108 | capture | 01a18e64-814f-7065-8ad9-4c667f44b6a2 | €35.00 | €0.50 | matched |
| 109 | capture | 01a18e64-88dc-7bc1-a749-dbe2802548fb | €49.00 | €0.67 | matched |
| 110 | capture | 01a18e64-8db8-7c31-8181-93adb86eadb7 | €9.00 | €0.19 | matched |
| 111 | capture | 01a18e64-8de4-71fb-9e0c-888002b4594c | €49.00 | €0.67 | matched |
| 112 | capture | 01a18e64-8fc6-7ed9-8d29-bd91744db0b5 | €49.00 | €0.67 | matched |
| 113 | capture | 01a18e64-92b5-758c-bba7-5dc1953ef816 | €15.00 | €0.26 | matched |
| 114 | capture | 01a18e64-a606-77b0-bf9c-9ea520548eb4 | €35.00 | €0.50 | matched |
| 115 | capture | 01a18e64-b413-73f1-ac5a-0efe914252ed | €49.00 | €0.67 | matched |
| 116 | capture | 01a18e64-d1c4-78df-9ba2-99d5e7149e9b | €49.00 | €0.67 | matched |
| 117 | capture | 01a18e64-ddac-739c-88a3-d8463af16f2e | €24.00 | €0.37 | matched |
| 118 | capture | 01a18e64-ee8f-7a53-9c8e-8d6c1101a18b | €9.00 | €0.19 | matched |
| 119 | refund | 01a18e65-09b7-7188-a2f3-6f2fd8845a0b | -€10.00 | €0.00 | matched |
| 120 | capture | 01a18e65-15f3-79aa-bdda-015434a355e8 | €35.00 | €0.50 | matched |
| 121 | capture | 01a18e65-15f5-7406-8193-c6b48e52bbdf | €15.00 | €0.26 | matched |
| 122 | capture | 01a18e65-17eb-772c-a25f-f88e481cd699 | €24.00 | €0.37 | matched |
| 123 | capture | 01a18e65-4320-7006-89f2-c8a86b01d8b3 | €9.00 | €0.19 | matched |
| 124 | capture | 01a18e65-6060-75b3-bd2a-fb196e954e63 | €35.00 | €0.50 | matched |
| 125 | capture | 01a18e65-67eb-7cbc-b418-9dbfcd4999c9 | €24.00 | €0.37 | matched |
| 126 | capture | 01a18e65-6e17-7231-903c-6b7562fd3136 | €24.00 | €0.37 | matched |
| 127 | capture | 01a18e65-85b7-7fe7-86dd-5257eddd9a7c | €49.00 | €0.67 | matched |
| 128 | refund | 01a18e65-a9a3-7ec7-8921-c2e1a36ca585 | -€3.00 | €0.00 | matched |
| 129 | capture | 01a18e65-a9b1-7ce2-93ed-8dce69c5e0cd | €49.00 | €0.67 | matched |
| 130 | refund | 01a18e65-cd7e-7e1a-b76c-cbb394d5664f | -€28.00 | €0.00 | matched |