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
- 22 Oct, 08:50143 lines3 breaks
- 22 Oct, 08:40137 lines3 breaks
- 22 Oct, 08:30142 lines1 break
- 22 Oct, 08:20126 lines4 breaks
- 22 Oct, 08:10117 lines3 breaks
- 22 Oct, 08:00124 lines2 breaks
- 22 Oct, 07:50119 lines2 breaks
- 22 Oct, 07:40122 lines2 breaks
- 22 Oct, 07:30134 linesclean
- 22 Oct, 07:20111 lines1 break
- 22 Oct, 07:10129 lines3 breaks
- 22 Oct, 07:00122 linesclean
- 22 Oct, 06:50139 lines1 break
- 22 Oct, 06:40127 lines3 breaks
22 Oct, 07:50
Gross
€2,833.00
PSP fee
€45.20
Net to the bank
€2,787.80
Settlement journal
#138185
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1629f-293a-7bf4-b358-e178f20ac389 is already settled by stl_EUR_2987759 line 109
- missing linein the books, not in the filecapture:01a16297-187a-7273-abdc-4db622cab555 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 110 | capture | 01a1629f-29af-7df1-b360-e5a2ccd42dd0 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a16293-a9b6-7239-9c3b-92e737074f41 | €9.00 | €0.19 | matched |
| 2 | capture | 01a16296-aa8f-7b4d-a4e8-b7f30be935a8 | €49.00 | €0.67 | matched |
| 3 | capture | 01a16296-c644-7777-b391-a89c23cfa070 | €49.00 | €0.67 | matched |
| 4 | capture | 01a16296-d045-75bd-a0fc-e8b1c04a9e84 | €49.00 | €0.67 | matched |
| 5 | capture | 01a16296-dd4e-7619-836e-4a9db4bc5168 | €9.00 | €0.19 | matched |
| 6 | capture | 01a16296-f3fb-7367-aa90-9045fbbd6334 | €24.00 | €0.37 | matched |
| 7 | capture | 01a16296-fe3b-719f-b1e0-a3423ec0a828 | €24.00 | €0.37 | matched |
| 8 | capture | 01a16297-0107-7e6c-be61-802caa190579 | €35.00 | €0.50 | matched |
| 9 | capture | 01a16297-0c4f-7768-8730-02fc94041d7c | €49.00 | €0.67 | matched |
| 10 | capture | 01a16297-112a-7092-9d27-718d8363e903 | €35.00 | €0.50 | matched |
| 11 | capture | 01a16297-2be5-7aa6-aafc-2f86affd0a47 | €24.00 | €0.37 | matched |
| 12 | capture | 01a16297-48bc-773b-a58d-932d26d9f50c | €9.00 | €0.19 | matched |
| 13 | capture | 01a16297-5e06-789c-8334-dd6eaf099973 | €9.00 | €0.19 | matched |
| 14 | refund | 01a16297-701b-723d-9ef4-c3c07b71ef2f | -€32.00 | €0.00 | matched |
| 15 | capture | 01a16297-8ae4-7a5c-a208-06459d6b66a9 | €24.00 | €0.37 | matched |
| 16 | capture | 01a16297-93e3-72c4-8f23-fcf2407ad21d | €24.00 | €0.37 | matched |
| 17 | refund | 01a16297-a523-7d7d-b474-e519d8f859dd | -€8.00 | €0.00 | matched |
| 18 | refund | 01a16297-b7b1-7050-bba7-5f1bb685c6ad | -€3.00 | €0.00 | matched |
| 19 | capture | 01a16297-cf98-7f68-a0f5-6d6bc14915a6 | €15.00 | €0.26 | matched |
| 20 | capture | 01a16297-f1ff-79b0-9644-c6cc31768b5b | €35.00 | €0.50 | matched |
| 21 | capture | 01a16297-ff93-7c54-9608-18e5db70ae5a | €49.00 | €0.67 | matched |
| 22 | capture | 01a16298-01ad-71a0-a2fb-6abf91ac2ba5 | €15.00 | €0.26 | matched |
| 23 | capture | 01a16298-076f-750c-bb26-05af4b9ecac0 | €49.00 | €0.67 | matched |
| 24 | capture | 01a16298-0d8f-7bb5-8108-cffd36076402 | €24.00 | €0.37 | matched |
| 25 | capture | 01a16298-11ca-739a-9498-16f9637cabe0 | €49.00 | €0.67 | matched |
| 26 | capture | 01a16298-1414-74b7-a589-6ac9dcebf383 | €24.00 | €0.37 | matched |
| 27 | refund | 01a16298-43cd-7d4a-9cf4-d09351c09ac5 | -€22.00 | €0.00 | matched |
| 28 | capture | 01a16298-506e-733d-bc26-6f35d972dbba | €9.00 | €0.19 | matched |
| 29 | capture | 01a16298-6af0-74ce-a575-e98b28038830 | €49.00 | €0.67 | matched |
| 30 | capture | 01a16298-9cfc-710e-a86b-087037e6d9b9 | €15.00 | €0.26 | matched |
| 31 | capture | 01a16299-0f8a-7771-8a5b-133eb35d1c8d | €49.00 | €0.67 | matched |
| 32 | capture | 01a16299-2640-7a52-861f-d3f21c0f88d1 | €24.00 | €0.37 | matched |
| 33 | capture | 01a16299-44df-759d-8f5a-cd3e3b884e8a | €24.00 | €0.37 | matched |
| 34 | capture | 01a16299-51dc-7256-8c2d-89c126bb8e63 | €24.00 | €0.37 | matched |
| 35 | capture | 01a16299-7e76-77dd-925d-29ad2120eb5e | €9.00 | €0.19 | matched |
| 36 | capture | 01a16299-7ee2-7c80-8e79-213c1415eb2b | €35.00 | €0.50 | matched |
| 37 | capture | 01a16299-8179-7472-88fb-231ba4d3207d | €49.00 | €0.67 | matched |
| 38 | capture | 01a16299-8e86-7166-850c-654d30ac9f11 | €24.00 | €0.37 | matched |
| 39 | capture | 01a16299-9982-7dbe-805f-ed45af09af8b | €35.00 | €0.50 | matched |
| 40 | capture | 01a16299-b27d-79ba-bb47-df8e9879a92f | €35.00 | €0.50 | matched |
| 41 | capture | 01a16299-c15b-7c7d-a051-a029d47b600b | €9.00 | €0.19 | matched |
| 42 | capture | 01a16299-c3aa-7e18-901e-c2e0bf3e2dd9 | €9.00 | €0.19 | matched |
| 43 | capture | 01a16299-ca60-7017-a45a-fa40351c44b7 | €24.00 | €0.37 | matched |
| 44 | capture | 01a16299-d477-748a-965c-6977f6df1dbe | €9.00 | €0.19 | matched |
| 45 | capture | 01a16299-e913-7885-a6c5-7b57ddd7d1d5 | €35.00 | €0.50 | matched |
| 46 | capture | 01a16299-ea6c-74dc-8595-6094dcec78f9 | €24.00 | €0.37 | matched |
| 47 | refund | 01a1629a-0a3c-723e-b2ca-256b176e3aa7 | -€16.00 | €0.00 | matched |
| 48 | capture | 01a1629a-3c12-7d9e-b492-3d9d18b5b2e4 | €35.00 | €0.50 | matched |
| 49 | capture | 01a1629a-7ddb-7110-ae21-094818579b0c | €49.00 | €0.67 | matched |
| 50 | capture | 01a1629a-8188-7df0-9ac8-ac3257883a22 | €15.00 | €0.26 | matched |
| 51 | capture | 01a1629a-8468-7e72-a70d-fb4675dbca08 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1629a-8aa1-7d1b-b46c-c918ec08ae40 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1629a-cff7-73dc-b226-93c7158af5f0 | €24.00 | €0.37 | matched |
| 54 | capture | 01a1629b-0136-7fb4-be85-74516855d75e | €35.00 | €0.50 | matched |
| 55 | capture | 01a1629b-0198-71ca-92ea-cb937ae35207 | €35.00 | €0.50 | matched |
| 56 | capture | 01a1629b-3686-7993-9d01-fbb0454322d8 | €49.00 | €0.67 | matched |
| 57 | capture | 01a1629b-44d2-7642-9109-912f68d8bb67 | €9.00 | €0.19 | matched |
| 58 | capture | 01a1629b-5918-74b4-b6da-ddd7968e390a | €24.00 | €0.37 | matched |
| 59 | capture | 01a1629b-68bd-7c9b-b272-b5d895b496ed | €9.00 | €0.19 | matched |
| 60 | capture | 01a1629b-604b-7894-8531-3ef6f4b32cc4 | €9.00 | €0.19 | matched |
| 61 | capture | 01a1629b-7a2b-7a9f-9768-ba2611252b1c | €49.00 | €0.67 | matched |
| 62 | capture | 01a1629b-845d-736d-8174-44ad64fa550e | €49.00 | €0.67 | matched |
| 63 | capture | 01a1629b-89c6-7dc8-b027-5eb19146626c | €49.00 | €0.67 | matched |
| 64 | capture | 01a1629b-988f-7ea9-b365-b17708d3dba4 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1629b-c579-78ca-93b1-bba186609b5f | €49.00 | €0.67 | matched |
| 66 | capture | 01a1629b-c776-7e36-882a-890ddcb3b3f1 | €15.00 | €0.26 | matched |
| 67 | capture | 01a1629b-ec5f-746f-9c72-322ce23bfb58 | €35.00 | €0.50 | matched |
| 68 | refund | 01a1629b-ee6c-7896-86f5-6dfe66321825 | -€7.00 | €0.00 | matched |
| 69 | capture | 01a1629b-f01c-7e07-8aa2-f344370edead | €15.00 | €0.26 | matched |
| 70 | capture | 01a1629b-f1e8-7e40-bd13-3664cbe6b9ad | €49.00 | €0.67 | matched |
| 71 | capture | 01a1629c-41e6-7965-bec1-81d84b13a63a | €24.00 | €0.37 | matched |
| 72 | capture | 01a1629c-4968-7c05-9b37-1aa65b442e0d | €9.00 | €0.19 | matched |
| 73 | refund | 01a1629c-502a-77b8-8c0d-f3ffa4e33950 | -€27.00 | €0.00 | matched |
| 74 | refund | 01a1629c-5d0c-76de-8ee7-cd018a2a261a | -€16.00 | €0.00 | matched |
| 75 | capture | 01a1629c-67d5-76db-8d2f-ef2e3c31f00b | €9.00 | €0.19 | matched |
| 76 | capture | 01a1629c-a752-7844-9dbf-8c92497e19a8 | €9.00 | €0.19 | matched |
| 77 | capture | 01a1629c-ab56-79a2-b961-c878fae58df3 | €35.00 | €0.50 | matched |
| 78 | capture | 01a1629c-cc2b-73c7-a2f4-e1a8c8dd9c69 | €15.00 | €0.26 | matched |
| 79 | capture | 01a1629c-dbd8-740f-bad0-180495736fa5 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1629c-f759-7e39-a19a-802762266957 | €35.00 | €0.50 | matched |
| 81 | capture | 01a1629c-fb11-7d68-a204-6a6b90dcc5b0 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1629d-1a6c-70c3-9f00-98c0ca117281 | €49.00 | €0.67 | matched |
| 83 | refund | 01a1629d-2527-7047-91dc-4748074338e5 | -€13.00 | €0.00 | matched |
| 84 | capture | 01a1629d-47f5-743e-be90-29755ae7e629 | €9.00 | €0.19 | matched |
| 85 | capture | 01a1629d-3fb9-70ac-9897-50d09b4d4d64 | €24.00 | €0.37 | matched |
| 86 | capture | 01a1629d-5f61-7217-81a5-90a44ddf3582 | €9.00 | €0.19 | matched |
| 87 | capture | 01a1629d-6601-7aa6-a9e9-64ab471c7403 | €24.00 | €0.37 | matched |
| 88 | capture | 01a1629d-6be3-78b1-b2d0-6a56095ab5b6 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1629d-7bb3-7506-a322-8e6ceebc423d | €9.00 | €0.19 | matched |
| 90 | capture | 01a1629d-7dbc-7061-9b4f-a38a1dd938e8 | €49.00 | €0.67 | matched |
| 91 | capture | 01a1629d-86cd-7483-9e52-73b37e7815e4 | €49.00 | €0.67 | matched |
| 92 | capture | 01a1629d-8f46-790e-abbc-a062adbaee50 | €24.00 | €0.37 | matched |
| 93 | capture | 01a1629d-b896-7c73-9f90-103b46aa32a7 | €9.00 | €0.19 | matched |
| 94 | refund | 01a1629d-be14-71e5-acce-b8e9d1fb2efa | -€11.00 | €0.00 | matched |
| 95 | capture | 01a1629e-38fb-7233-b718-19fb0bdfc53b | €35.00 | €0.50 | matched |
| 96 | capture | 01a1629e-4d8a-7f1f-84b5-a403de1cf2eb | €49.00 | €0.67 | matched |
| 97 | capture | 01a1629e-5219-7c81-81ed-8da367f8e91c | €24.00 | €0.37 | matched |
| 98 | capture | 01a1629e-5a55-7c98-ba3a-453a6f095e96 | €49.00 | €0.67 | matched |
| 99 | capture | 01a1629e-65d2-730c-9076-3ddb8fe29a2e | €15.00 | €0.26 | matched |
| 100 | capture | 01a1629e-7c1a-76e5-b9b8-806ae98c720a | €9.00 | €0.19 | matched |
| 101 | capture | 01a1629e-7ebf-7dab-a118-57fcb7772c9f | €49.00 | €0.67 | matched |
| 102 | capture | 01a1629e-9292-7ded-b838-49621e97b552 | €35.00 | €0.50 | matched |
| 103 | capture | 01a1629e-7e42-7ab6-9a78-dcf67de0afb3 | €24.00 | €0.37 | matched |
| 104 | refund | 01a1629e-ce21-728e-a0e2-f1de7cdde8c1 | -€29.00 | €0.00 | matched |
| 105 | capture | 01a1629e-d444-74bc-8eff-c79c61dea86d | €49.00 | €0.67 | matched |
| 106 | capture | 01a1629f-08ec-7f3f-9c44-d6ab37d55591 | €49.00 | €0.67 | matched |
| 107 | capture | 01a1629f-10e9-7631-91ca-0171024ce6e7 | €35.00 | €0.50 | matched |
| 108 | capture | 01a1629f-1654-7875-939f-e3d180ce4cae | €15.00 | €0.26 | matched |
| 109 | capture | 01a1629f-29af-7df1-b360-e5a2ccd42dd0 | €35.00 | €0.50 | matched |
| 111 | capture | 01a1629f-2b7c-7636-a399-f0a202c35f2e | €35.00 | €0.50 | matched |
| 112 | capture | 01a1629f-50af-7414-b785-28bda8d7694a | €15.00 | €0.26 | matched |
| 113 | capture | 01a1629f-5685-7545-9658-c624e122d54d | €24.00 | €0.37 | matched |
| 114 | refund | 01a1629f-65cc-7bc0-80d5-c1deb889f54b | -€24.00 | €0.00 | matched |
| 115 | capture | 01a1629f-6d89-7c95-b932-475576e07904 | €15.00 | €0.26 | matched |
| 116 | capture | 01a1629f-7dc0-764e-8531-fb6aeec88eee | €15.00 | €0.26 | matched |
| 117 | capture | 01a1629f-8229-7c60-8154-96ed04c1877b | €35.00 | €0.50 | matched |
| 118 | capture | 01a1629f-89b9-7487-b130-a4c6c56742da | €15.00 | €0.26 | matched |
| 119 | capture | 01a1629f-a9a6-7527-a8ad-0766ca8e79e4 | €49.00 | €0.67 | matched |