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
- 3 Nov, 21:30132 lines3 breaks
- 3 Nov, 21:2097 lines1 break
- 3 Nov, 21:10119 lines1 break
- 3 Nov, 21:00117 lines1 break
- 3 Nov, 20:50128 lines4 breaks
- 3 Nov, 20:40104 lines2 breaks
- 3 Nov, 20:30146 lines4 breaks
- 3 Nov, 20:20143 lines4 breaks
- 3 Nov, 20:10123 lines1 break
- 3 Nov, 20:00129 lines7 breaks
- 3 Nov, 19:50125 lines4 breaks
- 3 Nov, 19:40121 lines4 breaks
- 3 Nov, 19:30117 linesclean
- 3 Nov, 19:20121 lines5 breaks
3 Nov, 20:20
Gross
€3,235.00
PSP fee
€52.20
Net to the bank
€3,182.80
Settlement journal
#367095
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a311-b591-7008-a33d-3c59ed1592b8 is already settled by stl_EUR_2989562 line 7
- fee differencethe fee is not the contract feethe fee is 68, the contract says 67
- missing linein the books, not in the filecapture:01a1a311-9955-721f-82a9-22060437cd11 is in no file
- missing linein the books, not in the filerefund:01a1a31a-9725-7687-bc06-9d6e56047e79 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 6 | capture | 01a1a311-c7eb-719c-9452-98f0fe0fda87 | €49.00 | €0.68 | fee difference |
| 8 | capture | 01a1a311-c939-704f-a488-9e9225e54b1d | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1a30b-7dbd-7654-b68d-759e25ce5cf1 | €15.00 | €0.26 | matched |
| 2 | capture | 01a1a30e-6d42-7aaa-a4de-3b03887ded45 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1a311-94b6-7f1d-b198-4417ace31ac9 | €24.00 | €0.37 | matched |
| 4 | capture | 01a1a311-ba41-7253-9a63-aee83004b6ee | €49.00 | €0.67 | matched |
| 5 | capture | 01a1a311-bd3d-7c5f-8968-fd7ab2e21d31 | €35.00 | €0.50 | matched |
| 7 | capture | 01a1a311-c939-704f-a488-9e9225e54b1d | €49.00 | €0.67 | matched |
| 9 | capture | 01a1a311-cf0c-7650-a533-0afc63dde36f | €15.00 | €0.26 | matched |
| 10 | capture | 01a1a311-dae7-7066-a728-b9b9c5839310 | €9.00 | €0.19 | matched |
| 11 | capture | 01a1a311-e9aa-7e64-b20c-78bcfdb70714 | €49.00 | €0.67 | matched |
| 12 | capture | 01a1a311-ff12-7a1b-9483-eb7cfaa3dae9 | €9.00 | €0.19 | matched |
| 13 | capture | 01a1a312-035b-7a94-b864-47c0ab9fc1d4 | €24.00 | €0.37 | matched |
| 14 | capture | 01a1a312-0fb3-704f-bd40-10805169c497 | €9.00 | €0.19 | matched |
| 15 | capture | 01a1a312-1c73-777a-9ee3-d664bc89aa3d | €49.00 | €0.67 | matched |
| 16 | capture | 01a1a312-1eb3-770c-97e2-b2547d83da48 | €9.00 | €0.19 | matched |
| 17 | refund | 01a1a312-2b70-7324-9f6a-c35ab451f16b | -€15.00 | €0.00 | matched |
| 18 | capture | 01a1a312-3c65-79b9-a3c7-1f0fc447b725 | €49.00 | €0.67 | matched |
| 19 | refund | 01a1a312-580b-7b87-aa1e-f2c8e2f5d22a | -€36.00 | €0.00 | matched |
| 20 | capture | 01a1a312-607f-786c-aeef-62ba743223f0 | €49.00 | €0.67 | matched |
| 21 | capture | 01a1a312-6504-77dd-8db9-35f9dec497b3 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1a312-7670-77c0-8e6f-65a5917e795d | €49.00 | €0.67 | matched |
| 23 | capture | 01a1a312-7fa9-7f23-8d56-00df8f05909c | €49.00 | €0.67 | matched |
| 24 | refund | 01a1a312-8b45-78e8-98fb-cf2c05c68842 | -€3.00 | €0.00 | matched |
| 25 | capture | 01a1a312-9e01-7a02-af08-f2a527c09f77 | €24.00 | €0.37 | matched |
| 26 | capture | 01a1a312-a1f9-7464-9d2a-d60f91b31c56 | €15.00 | €0.26 | matched |
| 27 | capture | 01a1a312-c9e4-7a9d-a8a9-2b3c3cf240d4 | €49.00 | €0.67 | matched |
| 28 | refund | 01a1a312-ccc5-779c-b488-057830c73b1e | -€19.00 | €0.00 | matched |
| 29 | capture | 01a1a312-e065-746b-baac-11ba9d511681 | €49.00 | €0.67 | matched |
| 30 | capture | 01a1a312-ef56-773a-ac2a-1bd64385005c | €15.00 | €0.26 | matched |
| 31 | capture | 01a1a313-0027-7f8a-8890-69983274272e | €24.00 | €0.37 | matched |
| 32 | capture | 01a1a313-0111-7d98-b1e7-96778bd6e1cc | €49.00 | €0.67 | matched |
| 33 | capture | 01a1a313-154c-7128-afb7-6ccebd515bd2 | €9.00 | €0.19 | matched |
| 34 | capture | 01a1a313-351d-7ed6-bae5-9b71adc2f7d1 | €24.00 | €0.37 | matched |
| 35 | refund | 01a1a313-39ca-7640-99ae-666ed43133d3 | -€45.00 | €0.00 | matched |
| 36 | capture | 01a1a313-3e09-7374-81c9-925011066c0d | €9.00 | €0.19 | matched |
| 37 | capture | 01a1a313-413c-7520-ae18-e8b314ca9174 | €35.00 | €0.50 | matched |
| 38 | capture | 01a1a313-4e85-75c5-afde-8b0a70d63b83 | €49.00 | €0.67 | matched |
| 39 | capture | 01a1a313-55f7-7ed0-aff4-88752409eaaf | €9.00 | €0.19 | matched |
| 40 | capture | 01a1a313-5b99-77cb-bc75-f0668228052f | €24.00 | €0.37 | matched |
| 41 | capture | 01a1a313-73a4-7a6b-8705-5956bd524d69 | €15.00 | €0.26 | matched |
| 42 | capture | 01a1a313-abdd-7a13-b013-f75a6121f473 | €35.00 | €0.50 | matched |
| 43 | capture | 01a1a313-bccf-7699-bd9b-1c08cd02658c | €24.00 | €0.37 | matched |
| 44 | capture | 01a1a313-bdab-782b-aa58-968c3af6342e | €15.00 | €0.26 | matched |
| 45 | capture | 01a1a313-dd36-7864-9a6f-bb57dc27848d | €35.00 | €0.50 | matched |
| 46 | capture | 01a1a313-e1ae-7ee1-aa84-335a579f636d | €24.00 | €0.37 | matched |
| 47 | refund | 01a1a313-eb23-7065-9468-29b94572cacf | -€10.00 | €0.00 | matched |
| 48 | capture | 01a1a314-161e-781f-b915-93010bd181f6 | €35.00 | €0.50 | matched |
| 49 | refund | 01a1a314-262a-7c51-af00-d779e13ba690 | -€11.00 | €0.00 | matched |
| 50 | capture | 01a1a314-2b05-7007-83ff-87b3a143d87a | €9.00 | €0.19 | matched |
| 51 | capture | 01a1a314-323e-7058-a5a3-7dc60e83e79d | €15.00 | €0.26 | matched |
| 52 | capture | 01a1a314-439a-718b-9cff-be5b233e8133 | €9.00 | €0.19 | matched |
| 53 | capture | 01a1a314-4c9c-7383-9ace-ca0e2a60e338 | €49.00 | €0.67 | matched |
| 54 | capture | 01a1a314-68b6-7cd9-9227-6b22a2366c4c | €9.00 | €0.19 | matched |
| 55 | capture | 01a1a314-6c89-78e5-8326-611eb7beb9e2 | €15.00 | €0.26 | matched |
| 56 | capture | 01a1a314-838a-7d7c-8abd-b510e35bce4f | €35.00 | €0.50 | matched |
| 57 | capture | 01a1a314-db70-7d55-b9a2-07e22aad4ab1 | €15.00 | €0.26 | matched |
| 58 | capture | 01a1a314-e699-705c-9e3e-0bddd39f1448 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1a314-f4ad-7d0c-be03-51ed94b7c099 | €9.00 | €0.19 | matched |
| 60 | capture | 01a1a315-03a3-7861-9166-755eebebc7c0 | €24.00 | €0.37 | matched |
| 61 | capture | 01a1a315-0b13-7961-8ea6-e0090c81c21d | €35.00 | €0.50 | matched |
| 62 | capture | 01a1a315-1fb3-7943-8c08-ad6185f7e1a1 | €35.00 | €0.50 | matched |
| 63 | capture | 01a1a315-225b-7bce-bf63-36b21b18cc27 | €35.00 | €0.50 | matched |
| 64 | capture | 01a1a315-2ecc-718f-9690-a9606b9bb92e | €15.00 | €0.26 | matched |
| 65 | capture | 01a1a315-54a4-77dd-a41d-4dbfb6611470 | €35.00 | €0.50 | matched |
| 66 | capture | 01a1a315-5bf1-7483-8937-1314187cf0d1 | €15.00 | €0.26 | matched |
| 67 | capture | 01a1a315-69ce-729e-bd5a-c3cb0e2ade60 | €15.00 | €0.26 | matched |
| 68 | capture | 01a1a315-7392-74f2-93e1-7b6ee3475689 | €9.00 | €0.19 | matched |
| 69 | refund | 01a1a315-c9f2-7e1d-b59e-766c274dd69e | -€8.00 | €0.00 | matched |
| 70 | capture | 01a1a315-cba9-7f79-a7ec-9f1ddaf1ff73 | €9.00 | €0.19 | matched |
| 71 | capture | 01a1a315-cc7f-71a2-a402-9d567fe9395b | €24.00 | €0.37 | matched |
| 72 | capture | 01a1a315-d99d-7179-8514-d4ace1ec79c3 | €9.00 | €0.19 | matched |
| 73 | capture | 01a1a315-e071-76a6-9806-6d03a8ffdfbe | €15.00 | €0.26 | matched |
| 74 | capture | 01a1a315-ec27-79ca-86c8-a6c547a90d33 | €35.00 | €0.50 | matched |
| 75 | capture | 01a1a315-f251-7530-94de-c182738abc25 | €15.00 | €0.26 | matched |
| 76 | capture | 01a1a316-10f7-784d-bfcc-c16ade70440c | €9.00 | €0.19 | matched |
| 77 | capture | 01a1a316-4f87-7669-9c55-e4b8e550a4ef | €49.00 | €0.67 | matched |
| 78 | capture | 01a1a316-55fb-7143-84ef-601e0cff9dd3 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1a316-6f26-7506-8c40-dc5dde7e1b2e | €15.00 | €0.26 | matched |
| 80 | capture | 01a1a316-7b67-7631-b412-5caa5ee701d5 | €35.00 | €0.50 | matched |
| 81 | capture | 01a1a316-7d95-7302-9cb4-2b7a15518f50 | €9.00 | €0.19 | matched |
| 82 | capture | 01a1a316-c32e-7c47-bad9-a6d72fe28050 | €15.00 | €0.26 | matched |
| 83 | capture | 01a1a316-d13d-7dab-9935-37c55fcc70c0 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1a316-fbca-732f-a5a1-d1a22fb46a31 | €24.00 | €0.37 | matched |
| 85 | capture | 01a1a317-09d1-7a7c-8791-656423235f41 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1a317-0ade-7f6e-b32e-26e7268f5238 | €24.00 | €0.37 | matched |
| 87 | capture | 01a1a317-0c65-78d0-b86b-5851688e7c9b | €15.00 | €0.26 | matched |
| 88 | capture | 01a1a317-1d87-7a40-86f3-4937a93a132d | €35.00 | €0.50 | matched |
| 89 | capture | 01a1a317-1f0a-768b-bdd8-246abc1799d8 | €15.00 | €0.26 | matched |
| 90 | capture | 01a1a317-3110-782f-8552-bff9f221151b | €35.00 | €0.50 | matched |
| 91 | capture | 01a1a317-3628-7ccb-9138-6869b8e1474d | €24.00 | €0.37 | matched |
| 92 | capture | 01a1a317-3837-7084-b7d4-3739a5c7d7ae | €35.00 | €0.50 | matched |
| 93 | refund | 01a1a317-46ac-79c1-8256-50a2b2a5e239 | -€6.00 | €0.00 | matched |
| 94 | capture | 01a1a317-540a-7676-9297-faf9160deac5 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1a317-5450-7387-bed6-4bc4f0657c25 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1a317-5e80-71aa-b7d8-299dd805a891 | €35.00 | €0.50 | matched |
| 97 | capture | 01a1a317-6873-7850-bd22-3d98239ef42b | €15.00 | €0.26 | matched |
| 98 | capture | 01a1a317-787a-7c3b-8b08-8046ea1889c0 | €49.00 | €0.67 | matched |
| 99 | capture | 01a1a317-8b41-78e0-b6fe-df362cd51f0f | €49.00 | €0.67 | matched |
| 100 | capture | 01a1a317-8f64-76fb-93e3-109eb332ab57 | €15.00 | €0.26 | matched |
| 101 | refund | 01a1a317-a918-7a18-a145-d4c024366496 | -€12.00 | €0.00 | matched |
| 102 | capture | 01a1a317-c6d8-735b-be23-7c36cc8b02bf | €49.00 | €0.67 | matched |
| 103 | capture | 01a1a317-d4c9-716b-a351-18d88845046a | €49.00 | €0.67 | matched |
| 104 | capture | 01a1a317-de66-78b2-b38a-b8c49c374a96 | €15.00 | €0.26 | matched |
| 105 | capture | 01a1a318-0366-7763-a3e1-02bbfbd61586 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1a318-0a10-7460-b150-eb2835d5a924 | €9.00 | €0.19 | matched |
| 107 | capture | 01a1a318-0aea-7631-9dbf-4c3296acf33c | €24.00 | €0.37 | matched |
| 108 | capture | 01a1a318-193c-7de7-b3e4-f4bd331d87e5 | €24.00 | €0.37 | matched |
| 109 | capture | 01a1a318-2bb3-78af-9c38-fc540e3e4a69 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1a318-2e2d-7150-a187-225b4fd848e5 | €35.00 | €0.50 | matched |
| 111 | capture | 01a1a318-328f-726b-a7a7-e2948e9c389b | €24.00 | €0.37 | matched |
| 112 | capture | 01a1a318-525e-7254-8d52-8e674c6f19e7 | €9.00 | €0.19 | matched |
| 113 | capture | 01a1a318-5791-74b0-a7bc-43aa6d86222a | €24.00 | €0.37 | matched |
| 114 | capture | 01a1a318-8e31-7b76-ab89-170107f45bdb | €9.00 | €0.19 | matched |
| 115 | capture | 01a1a318-9b87-76a9-be2b-f3254f90019a | €15.00 | €0.26 | matched |
| 116 | capture | 01a1a318-9dd4-7513-8b41-790e5a587f15 | €15.00 | €0.26 | matched |
| 117 | capture | 01a1a318-c244-7de3-872e-d2042a4c1554 | €49.00 | €0.67 | matched |
| 118 | capture | 01a1a318-efbb-7e97-a4b3-039cc32aa68a | €15.00 | €0.26 | matched |
| 119 | capture | 01a1a318-f65b-714d-94bc-eec7889bfe20 | €49.00 | €0.67 | matched |
| 120 | capture | 01a1a319-10a8-7ca4-9864-fcf6b2853034 | €49.00 | €0.67 | matched |
| 121 | capture | 01a1a319-1938-7207-b4cf-e76afd13650a | €9.00 | €0.19 | matched |
| 122 | capture | 01a1a319-25ea-7c16-a12a-14b7e2b7c7d4 | €9.00 | €0.19 | matched |
| 123 | capture | 01a1a319-5ae3-7117-b71b-57e7351a3fd5 | €9.00 | €0.19 | matched |
| 124 | capture | 01a1a319-6468-7ea4-ba68-92dbc5e59a4b | €24.00 | €0.37 | matched |
| 125 | capture | 01a1a319-783b-7c64-b191-d6e497ed4b3e | €49.00 | €0.67 | matched |
| 126 | capture | 01a1a319-7df3-7aa9-995a-814e7b205f5b | €15.00 | €0.26 | matched |
| 127 | capture | 01a1a319-a1fb-74d1-a6f4-b540a3fec007 | €49.00 | €0.67 | matched |
| 128 | capture | 01a1a319-d830-7107-aa79-fcede6f35c2d | €9.00 | €0.19 | matched |
| 129 | capture | 01a1a319-e96d-70a4-ae64-1c373ca528ef | €15.00 | €0.26 | matched |
| 130 | capture | 01a1a31a-02e2-791c-b26e-40e198045b13 | €24.00 | €0.37 | matched |
| 131 | capture | 01a1a31a-14f5-767a-80a3-4bccf2a106d7 | €24.00 | €0.37 | matched |
| 132 | capture | 01a1a31a-1c13-7502-a2c1-7d2bd77e6e10 | €24.00 | €0.37 | matched |
| 133 | capture | 01a1a31a-2169-73e4-bb30-e78f1f9caf3f | €35.00 | €0.50 | matched |
| 134 | capture | 01a1a31a-2695-7945-b1df-e67202ccb9d0 | €49.00 | €0.67 | matched |
| 135 | capture | 01a1a31a-4230-7a16-a0a4-3f85577529e8 | €49.00 | €0.67 | matched |
| 136 | capture | 01a1a31a-46cd-73d6-b95a-1c3a3aebfb27 | €24.00 | €0.37 | matched |
| 137 | capture | 01a1a31a-4e7e-7b24-b0db-b06268642b85 | €35.00 | €0.50 | matched |
| 138 | capture | 01a1a31a-5a22-7c89-b331-a38c0ccca384 | €49.00 | €0.67 | matched |
| 139 | capture | 01a1a31a-89c1-7ee1-adc3-917f8126cb10 | €24.00 | €0.37 | matched |
| 140 | capture | 01a1a31a-9664-7134-b23c-1ea408b8996b | €24.00 | €0.37 | matched |
| 141 | refund | 01a1a31a-a16e-7557-bb43-d1ff62f3fbd2 | -€45.00 | €0.00 | matched |
| 142 | refund | 01a1a31a-b019-7860-b1d5-43dd30e3405a | -€15.00 | €0.00 | matched |
| 143 | refund | 01a1a31a-b816-749e-b508-48892e7386f6 | -€9.00 | €0.00 | matched |