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
- 28 Oct, 01:50131 lines3 breaks
- 28 Oct, 01:40121 lines6 breaks
- 28 Oct, 01:30116 linesclean
- 28 Oct, 01:20153 lines5 breaks
- 28 Oct, 01:10111 lines2 breaks
- 28 Oct, 01:00107 lines1 break
- 28 Oct, 00:50128 lines1 break
- 28 Oct, 00:40140 lines3 breaks
- 28 Oct, 00:30137 lines4 breaks
- 28 Oct, 00:20127 lines3 breaks
- 28 Oct, 00:10126 linesclean
- 28 Oct, 00:00121 lines2 breaks
- 27 Oct, 23:50101 lines4 breaks
- 27 Oct, 23:40131 lines2 breaks
28 Oct, 00:30
Gross
€3,118.00
PSP fee
€49.50
Net to the bank
€3,068.50
Settlement journal
#242091
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17feb-b407-710a-80e6-3acd36ff8314 is already settled by stl_EUR_2988579 line 27
- 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 28, the contract says 26
- missing linein the books, not in the filecapture:01a17ff0-4481-7dda-ae5c-00a0c137c72d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 27 | capture | 01a17feb-b46a-7935-bdff-60c187e2c6b1 | €35.00 | €0.54 | fee difference |
| 28 | capture | 01a17feb-b46a-7935-bdff-60c187e2c6b1 | €35.00 | €0.54 | duplicate line |
| 69 | capture | 01a17fee-383e-73d7-89cd-c708245d2d11 | €15.00 | €0.28 | fee difference |
| 1 | capture | 01a17fe1-90a5-74b4-976c-7b42d5ab14c7 | €49.00 | €0.67 | matched |
| 2 | capture | 01a17fe6-2234-71e9-a996-96048b7100a3 | €15.00 | €0.26 | matched |
| 3 | capture | 01a17fe6-4df0-7f59-a417-98635940b979 | €24.00 | €0.37 | matched |
| 4 | capture | 01a17fea-02b5-703b-9bee-921f7d921d51 | €9.00 | €0.19 | matched |
| 5 | capture | 01a17fea-17a3-70e9-9242-3edc8e9eee6d | €49.00 | €0.67 | matched |
| 6 | capture | 01a17fea-22d9-7cb8-ac6e-abda8e61831c | €9.00 | €0.19 | matched |
| 7 | capture | 01a17fea-2e8e-7c80-b55d-3d40af55c51a | €49.00 | €0.67 | matched |
| 8 | capture | 01a17fea-31f4-791a-8144-c1066cf4e3fb | €15.00 | €0.26 | matched |
| 9 | capture | 01a17fea-32a8-78b9-9c7a-decee428012e | €24.00 | €0.37 | matched |
| 10 | capture | 01a17fea-606b-7bc8-871d-3acb8d0f60ca | €9.00 | €0.19 | matched |
| 11 | capture | 01a17fea-68fb-72f2-9cc0-b5f81bb7e624 | €49.00 | €0.67 | matched |
| 12 | capture | 01a17fea-81a1-72b1-81af-d429fe1ace35 | €15.00 | €0.26 | matched |
| 13 | capture | 01a17fea-861e-759a-8279-c71ba6b7f6ea | €15.00 | €0.26 | matched |
| 14 | capture | 01a17fea-8a87-72a8-a2fd-5661929a75b7 | €49.00 | €0.67 | matched |
| 15 | capture | 01a17fea-8fa4-7999-a0ee-a37977dfd321 | €15.00 | €0.26 | matched |
| 16 | capture | 01a17fea-be27-71bc-967e-486b9df6df6b | €15.00 | €0.26 | matched |
| 17 | capture | 01a17fea-c0a6-7e1a-9aae-b4a1e5780be8 | €24.00 | €0.37 | matched |
| 18 | capture | 01a17feb-198f-7e44-9376-069e670f5113 | €9.00 | €0.19 | matched |
| 19 | capture | 01a17feb-2808-79eb-b758-b740a867762d | €24.00 | €0.37 | matched |
| 20 | capture | 01a17feb-2a92-7f04-9bce-133c12cc1f10 | €24.00 | €0.37 | matched |
| 21 | capture | 01a17feb-2f72-7037-9fac-9d9a5537167b | €24.00 | €0.37 | matched |
| 22 | capture | 01a17feb-69db-7a30-b1b2-c4dd0f4c8a4a | €49.00 | €0.67 | matched |
| 23 | refund | 01a17feb-6dcb-77d3-88b9-8c2e2378a5ba | -€23.00 | €0.00 | matched |
| 24 | capture | 01a17feb-8248-7642-8722-9bd5a079c988 | €15.00 | €0.26 | matched |
| 25 | capture | 01a17feb-8c8a-7158-8a83-87e6547ceada | €9.00 | €0.19 | matched |
| 26 | capture | 01a17feb-98ca-71e6-9c56-cb1eae8b2928 | €15.00 | €0.26 | matched |
| 29 | capture | 01a17feb-b8e0-7f04-bcbd-3237de0b35ea | €9.00 | €0.19 | matched |
| 30 | capture | 01a17feb-b9b1-796f-a9d3-64be6188e6d9 | €9.00 | €0.19 | matched |
| 31 | capture | 01a17feb-bf7a-7ed6-ac33-8fd47d6e40ce | €24.00 | €0.37 | matched |
| 32 | refund | 01a17feb-df96-705a-bf53-264966ca192a | -€15.00 | €0.00 | matched |
| 33 | refund | 01a17feb-e120-77af-9d91-4436a0b039d1 | -€5.00 | €0.00 | matched |
| 34 | capture | 01a17feb-e6ea-7793-ae76-50a825ece994 | €49.00 | €0.67 | matched |
| 35 | capture | 01a17fec-03da-7bc5-b20d-8100cd80bfc4 | €9.00 | €0.19 | matched |
| 36 | capture | 01a17fec-15c4-74eb-b28a-105da95f5214 | €9.00 | €0.19 | matched |
| 37 | capture | 01a17fec-48e4-75a9-9ee4-12ebfb264434 | €49.00 | €0.67 | matched |
| 38 | capture | 01a17fec-6a14-7d9a-89b3-1e4daeb33758 | €15.00 | €0.26 | matched |
| 39 | capture | 01a17fec-706b-7392-8a7b-b033eaa12662 | €49.00 | €0.67 | matched |
| 40 | capture | 01a17fec-745e-7aaf-a1f0-9338e5afe4e3 | €9.00 | €0.19 | matched |
| 41 | capture | 01a17fec-7dd3-7a8f-bf0a-74e44c5a0bb5 | €9.00 | €0.19 | matched |
| 42 | capture | 01a17fec-96ef-796c-98e8-2055355b9f0f | €35.00 | €0.50 | matched |
| 43 | capture | 01a17fec-b353-7958-ac99-4bec754b4a38 | €49.00 | €0.67 | matched |
| 44 | refund | 01a17fec-bb35-7825-8df3-24eca00f27bb | -€5.00 | €0.00 | matched |
| 45 | capture | 01a17fec-c018-7819-a821-318b6bf4b465 | €24.00 | €0.37 | matched |
| 46 | refund | 01a17fec-c59b-7f3b-b724-18a7d6aba0f4 | -€2.00 | €0.00 | matched |
| 47 | capture | 01a17fec-c5d6-7617-ae4a-912e4697f217 | €24.00 | €0.37 | matched |
| 48 | capture | 01a17fec-d4c1-71c5-b3e7-04819daf3037 | €15.00 | €0.26 | matched |
| 49 | capture | 01a17fec-e469-7661-85e8-3a8ac260ef36 | €15.00 | €0.26 | matched |
| 50 | capture | 01a17fed-1d83-7b58-b79a-6b814d7959c8 | €35.00 | €0.50 | matched |
| 51 | capture | 01a17fed-2893-7476-ab83-fa97d288fdfb | €49.00 | €0.67 | matched |
| 52 | capture | 01a17fed-2a5e-7ef8-93ee-84b033f02c8f | €49.00 | €0.67 | matched |
| 53 | capture | 01a17fed-352c-74e0-84f9-ff8dc3eca0fb | €24.00 | €0.37 | matched |
| 54 | capture | 01a17fed-36e3-77a7-bef9-2c230468a5a4 | €15.00 | €0.26 | matched |
| 55 | capture | 01a17fed-3b45-7f2d-ac36-36079055f9d0 | €15.00 | €0.26 | matched |
| 56 | capture | 01a17fed-4426-7528-b1f1-794247107087 | €24.00 | €0.37 | matched |
| 57 | capture | 01a17fed-5742-75d3-ab10-8022d4b1d363 | €49.00 | €0.67 | matched |
| 58 | refund | 01a17fed-8be2-776d-97d2-47f2fe3e68a1 | -€24.00 | €0.00 | matched |
| 59 | capture | 01a17fed-8e4e-79f6-8016-87dcfe73121e | €9.00 | €0.19 | matched |
| 60 | capture | 01a17fed-aeec-7da1-9523-17ff49b59dcb | €24.00 | €0.37 | matched |
| 61 | capture | 01a17fed-b297-7468-82fe-d79f7773cae5 | €49.00 | €0.67 | matched |
| 62 | capture | 01a17fed-b620-712c-a111-b4159faa0316 | €35.00 | €0.50 | matched |
| 63 | capture | 01a17fed-cfc5-7955-8bd5-b6e3cab27bae | €49.00 | €0.67 | matched |
| 64 | capture | 01a17fed-d221-7539-bfc5-d9821ae7535e | €15.00 | €0.26 | matched |
| 65 | capture | 01a17fed-daac-76b4-b04f-f07f65e73857 | €15.00 | €0.26 | matched |
| 66 | refund | 01a17fee-0243-7e08-9d75-6458c314698c | -€7.00 | €0.00 | matched |
| 67 | capture | 01a17fee-0fcf-7c45-8a21-71e537b1bfea | €9.00 | €0.19 | matched |
| 68 | capture | 01a17fee-2071-7a1a-87b3-7a3dcf42b92d | €35.00 | €0.50 | matched |
| 70 | capture | 01a17fee-3f6b-7748-b866-c9f5ef4b3e2d | €9.00 | €0.19 | matched |
| 71 | capture | 01a17fee-559c-7410-9bb6-3269f6538082 | €35.00 | €0.50 | matched |
| 72 | capture | 01a17fee-6039-75fd-b0c7-dda285d2bbc7 | €24.00 | €0.37 | matched |
| 73 | capture | 01a17fee-751a-7326-8681-dccc46534f7b | €24.00 | €0.37 | matched |
| 74 | refund | 01a17fee-9679-7028-97fb-9609e0683e4a | -€4.00 | €0.00 | matched |
| 75 | capture | 01a17fee-cd82-730b-9204-23c3b7e236b0 | €24.00 | €0.37 | matched |
| 76 | capture | 01a17fef-06f9-794d-aeac-d607ce964124 | €49.00 | €0.67 | matched |
| 77 | capture | 01a17fef-0a47-778c-9ccb-85e86226655d | €9.00 | €0.19 | matched |
| 78 | capture | 01a17fef-2452-7e36-b39b-3e442bc830b3 | €15.00 | €0.26 | matched |
| 79 | capture | 01a17fef-3bc7-7314-bf9e-9b4278dc6dab | €9.00 | €0.19 | matched |
| 80 | capture | 01a17fef-50fa-7f1c-bff2-6864beb68948 | €24.00 | €0.37 | matched |
| 81 | capture | 01a17fef-756a-7374-81fb-8c67f7bf27bb | €24.00 | €0.37 | matched |
| 82 | capture | 01a17fef-8b55-736c-b1cd-275439b42192 | €49.00 | €0.67 | matched |
| 83 | capture | 01a17fef-9792-7e77-ba52-3f9959a8c69b | €49.00 | €0.67 | matched |
| 84 | capture | 01a17fef-a4ae-79a8-8fbe-d5a3edec7ab6 | €9.00 | €0.19 | matched |
| 85 | capture | 01a17fef-c87c-78c2-b68f-f6ed1b3940ca | €35.00 | €0.50 | matched |
| 86 | capture | 01a17fef-e954-725e-b800-60ac760f8769 | €9.00 | €0.19 | matched |
| 87 | capture | 01a17ff0-03a5-78b1-8c5c-b1e5dd765a48 | €15.00 | €0.26 | matched |
| 88 | capture | 01a17ff0-0d11-7150-9b36-ef5e0e942ac0 | €15.00 | €0.26 | matched |
| 89 | capture | 01a17ff0-1b7d-74c1-b300-1db9cba4bc90 | €49.00 | €0.67 | matched |
| 90 | capture | 01a17ff0-2a81-7d29-8f8d-94924c3a40bc | €9.00 | €0.19 | matched |
| 91 | capture | 01a17ff0-35f3-7128-8819-b7462e1318e1 | €24.00 | €0.37 | matched |
| 92 | capture | 01a17ff0-3ee1-74b8-85d7-88fa0701dfbc | €9.00 | €0.19 | matched |
| 93 | capture | 01a17ff0-4be3-775d-9a14-fedd6dcfe44c | €35.00 | €0.50 | matched |
| 94 | capture | 01a17ff0-4c37-7869-b382-c27a1968daf9 | €9.00 | €0.19 | matched |
| 95 | capture | 01a17ff0-5489-7455-9c93-7a444305dc9f | €9.00 | €0.19 | matched |
| 96 | capture | 01a17ff0-6f55-7dca-b921-c92662748d09 | €35.00 | €0.50 | matched |
| 97 | capture | 01a17ff0-74e1-7358-94b2-85d02b746b8a | €35.00 | €0.50 | matched |
| 98 | capture | 01a17ff0-7505-72ba-8d39-932e93b13e95 | €35.00 | €0.50 | matched |
| 99 | capture | 01a17ff0-7d1e-702d-a8bb-7967304a0310 | €35.00 | €0.50 | matched |
| 100 | refund | 01a17ff0-7ee0-71f0-864a-89cd85462296 | -€3.00 | €0.00 | matched |
| 101 | capture | 01a17ff0-7f9c-7e81-9e14-6eba2ed69fc3 | €15.00 | €0.26 | matched |
| 102 | capture | 01a17ff0-8a7a-7ca5-b664-621bcb701e18 | €35.00 | €0.50 | matched |
| 103 | capture | 01a17ff0-93c2-7c26-99bb-be62fc0ba6ca | €15.00 | €0.26 | matched |
| 104 | capture | 01a17ff0-93c3-7c70-a059-def4d5de122b | €15.00 | €0.26 | matched |
| 105 | capture | 01a17ff0-9b07-763b-b24b-86c25d9f2070 | €49.00 | €0.67 | matched |
| 106 | capture | 01a17ff0-beef-7f5c-a0f1-6fb4c6d2da4f | €35.00 | €0.50 | matched |
| 107 | capture | 01a17ff0-dd47-74f9-96ba-5b81f49d0b12 | €24.00 | €0.37 | matched |
| 108 | capture | 01a17ff0-e34c-7d1c-9e2a-bf94c61a2e29 | €49.00 | €0.67 | matched |
| 109 | capture | 01a17ff0-e4be-765f-a421-a2c977f952b9 | €49.00 | €0.67 | matched |
| 110 | capture | 01a17ff0-e80f-759a-bee8-6efeb2c20e3e | €49.00 | €0.67 | matched |
| 111 | capture | 01a17ff0-ee9b-702c-b494-b4ee67f654e4 | €49.00 | €0.67 | matched |
| 112 | capture | 01a17ff1-0585-7456-ad2b-777f466f5d00 | €9.00 | €0.19 | matched |
| 113 | capture | 01a17ff1-05a9-71ba-933a-d7d686dbb5b5 | €35.00 | €0.50 | matched |
| 114 | capture | 01a17ff1-08a6-79ff-849e-a261d8e5bdc0 | €15.00 | €0.26 | matched |
| 115 | capture | 01a17ff1-0e63-7528-afbb-c37f91f7fadf | €24.00 | €0.37 | matched |
| 116 | capture | 01a17ff1-24c0-73c0-b7e9-307a44ab2542 | €35.00 | €0.50 | matched |
| 117 | capture | 01a17ff1-660c-7839-8eaf-0acaf5cd31d3 | €49.00 | €0.67 | matched |
| 118 | refund | 01a17ff1-695c-7cca-b851-3afad4218b0f | -€13.00 | €0.00 | matched |
| 119 | capture | 01a17ff1-7444-7da3-998e-fcc741e53cad | €9.00 | €0.19 | matched |
| 120 | capture | 01a17ff1-7c78-7edc-a5dc-4e190fc67b1f | €49.00 | €0.67 | matched |
| 121 | capture | 01a17ff1-87f1-794f-87f6-0a32645cfa71 | €35.00 | €0.50 | matched |
| 122 | capture | 01a17ff1-a615-7d69-845b-e30965ada302 | €15.00 | €0.26 | matched |
| 123 | capture | 01a17ff2-0ff6-74c3-94ee-deaf2a88ab22 | €35.00 | €0.50 | matched |
| 124 | capture | 01a17ff2-1104-7f12-a05e-8b61341cd651 | €24.00 | €0.37 | matched |
| 125 | capture | 01a17ff2-1c9e-73af-acf4-5084f7272be6 | €24.00 | €0.37 | matched |
| 126 | capture | 01a17ff2-29cd-7170-b37d-7a91542aca69 | €9.00 | €0.19 | matched |
| 127 | capture | 01a17ff2-4aae-7702-b51f-a5c34a3e17df | €24.00 | €0.37 | matched |
| 128 | capture | 01a17ff2-6166-7a0f-b41d-a5c87a0be47e | €24.00 | €0.37 | matched |
| 129 | capture | 01a17ff2-6605-7946-9a8e-a890688f5959 | €24.00 | €0.37 | matched |
| 130 | capture | 01a17ff2-6bda-73ae-95f4-0804a0bad9c8 | €49.00 | €0.67 | matched |
| 131 | capture | 01a17ff2-7ec0-7f35-959a-f6a3fcec8fb5 | €9.00 | €0.19 | matched |
| 132 | capture | 01a17ff2-9f08-7fc8-8ca1-8df7e53113d7 | €15.00 | €0.26 | matched |
| 133 | capture | 01a17ff2-acc6-7912-9340-1209f891bae3 | €49.00 | €0.67 | matched |
| 134 | capture | 01a17ff2-c581-77ae-b3d1-c509d667e8a0 | €15.00 | €0.26 | matched |
| 135 | refund | 01a17ff2-c865-7515-9737-bdad4bcdb6bd | -€11.00 | €0.00 | matched |
| 136 | refund | 01a17ff2-ddff-717c-b7f1-1553060903cc | -€40.00 | €0.00 | matched |
| 137 | capture | 01a17ff3-02a4-729b-894c-b7fbfb072fc8 | €9.00 | €0.19 | matched |