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
- 19 Oct, 18:50117 lines1 break
- 19 Oct, 18:40121 lines1 break
- 19 Oct, 18:3097 lines2 breaks
- 19 Oct, 18:20110 lines1 break
- 19 Oct, 18:10120 linesclean
- 19 Oct, 18:00128 lines2 breaks
- 19 Oct, 17:50122 lines2 breaks
- 19 Oct, 17:40145 lines6 breaks
- 19 Oct, 17:30114 lines4 breaks
- 19 Oct, 17:20126 lines2 breaks
- 19 Oct, 17:10117 lines2 breaks
- 19 Oct, 17:00132 linesclean
- 19 Oct, 16:50111 lines3 breaks
- 19 Oct, 16:40117 lines1 break
19 Oct, 17:40
Gross
€3,058.00
PSP fee
€49.79
Net to the bank
€3,008.21
Settlement journal
#91059
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a15541-12ba-7648-ab1a-10297c4416c5 is already settled by stl_EUR_2987386 line 26
- duplicate linethe file lists it twicecapture:01a15546-017a-71fb-8495-9a2fc039c9c0 is already settled by stl_EUR_2987386 line 107
- fee differencethe fee is not the contract feethe fee is 41, the contract says 37
- fee differencethe fee is not the contract feethe fee is 5, the contract says 0
- missing linein the books, not in the filecapture:01a15548-7c0e-7f69-bc9d-39961904d43a is in no file
- missing linein the books, not in the filerefund:01a15548-7da5-7d65-a048-f2e39bb5a0f4 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 27 | capture | 01a15541-134d-736a-a2b2-2f3dac615faf | €15.00 | €0.26 | duplicate line |
| 55 | capture | 01a15543-2fee-778b-b19c-f1e2567675ae | €24.00 | €0.41 | fee difference |
| 78 | refund | 01a15544-40d4-7177-b1c9-4c2d10ae6bc3 | -€4.00 | €0.05 | fee difference |
| 108 | capture | 01a15546-0286-773c-8521-1376844bb0bb | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a1553a-9622-734d-8b42-1cf43b23896b | €15.00 | €0.26 | matched |
| 2 | capture | 01a1553c-52aa-7cfb-88dd-8107df2d9a3e | €9.00 | €0.19 | matched |
| 3 | capture | 01a1553d-b9a3-7fa9-8a87-0f393a033d3b | €9.00 | €0.19 | matched |
| 4 | refund | 01a1553f-643a-75c8-aedf-403839f9129a | -€5.00 | €0.00 | matched |
| 5 | capture | 01a1553f-adf1-74fb-83bb-4da2990e8a4d | €9.00 | €0.19 | matched |
| 6 | capture | 01a1553f-efc0-7b34-a0b3-ede1ec09d8c9 | €49.00 | €0.67 | matched |
| 7 | capture | 01a1553f-ee77-7f0a-acc8-ee962c3d462e | €49.00 | €0.67 | matched |
| 8 | capture | 01a1553f-fece-7861-a9e8-9832d3ba47b0 | €15.00 | €0.26 | matched |
| 9 | capture | 01a15540-081b-756a-8fb3-a9ad2a1798d3 | €9.00 | €0.19 | matched |
| 10 | capture | 01a15540-082b-7d19-a469-9640a925dc05 | €35.00 | €0.50 | matched |
| 11 | capture | 01a15540-1421-7468-ba12-5a3373237d40 | €15.00 | €0.26 | matched |
| 12 | capture | 01a15540-428b-7f65-b384-6f4cc0cc5e01 | €9.00 | €0.19 | matched |
| 13 | capture | 01a15540-6323-7c18-9bdd-1c2fea1227f9 | €9.00 | €0.19 | matched |
| 14 | capture | 01a15540-7abf-73bf-97d0-2b7ec4fe1723 | €9.00 | €0.19 | matched |
| 15 | capture | 01a15540-84f3-7966-b26e-4f3da1a80a2f | €15.00 | €0.26 | matched |
| 16 | capture | 01a15540-c5ae-7bc0-bfd5-741ac1319baf | €15.00 | €0.26 | matched |
| 17 | capture | 01a15540-c9e8-7013-8090-87adb5a858e0 | €15.00 | €0.26 | matched |
| 18 | capture | 01a15540-cc9e-71f3-a581-9309bd72383c | €24.00 | €0.37 | matched |
| 19 | capture | 01a15540-cf5e-7f1f-945a-a223507f9113 | €24.00 | €0.37 | matched |
| 20 | capture | 01a15540-d5b7-7a39-8744-fe7d102a78bd | €24.00 | €0.37 | matched |
| 21 | capture | 01a15540-e191-7110-a57b-536d442fb688 | €35.00 | €0.50 | matched |
| 22 | capture | 01a15540-e860-7133-b6fc-3a69dfd470d1 | €24.00 | €0.37 | matched |
| 23 | capture | 01a15540-f55a-7721-89b0-2606bf0686fb | €15.00 | €0.26 | matched |
| 24 | refund | 01a15540-fff9-7d46-ade6-f10f2fe8ae61 | -€15.00 | €0.00 | matched |
| 25 | capture | 01a15541-00c3-7796-9834-2d4a70c8091c | €24.00 | €0.37 | matched |
| 26 | capture | 01a15541-134d-736a-a2b2-2f3dac615faf | €15.00 | €0.26 | matched |
| 28 | capture | 01a15541-1a8b-7f70-ad66-1b92173e8e75 | €35.00 | €0.50 | matched |
| 29 | capture | 01a15541-3119-770c-a43b-72a46d400931 | €49.00 | €0.67 | matched |
| 30 | capture | 01a15541-4c56-72cc-8494-fe8ca1ad2f4f | €24.00 | €0.37 | matched |
| 31 | capture | 01a15541-56e6-7657-8877-fd35192b2d95 | €24.00 | €0.37 | matched |
| 32 | refund | 01a15541-5910-748d-a172-b11ec5f2a771 | -€11.00 | €0.00 | matched |
| 33 | capture | 01a15541-5b0d-78a0-b7a0-56fb92d44161 | €35.00 | €0.50 | matched |
| 34 | capture | 01a15541-7b70-78cf-82f0-0b255d4dcc26 | €49.00 | €0.67 | matched |
| 35 | capture | 01a15541-aabd-7866-a0fe-301c6dc0b510 | €24.00 | €0.37 | matched |
| 36 | capture | 01a15541-b62e-7f80-afc9-1805cef3fcc8 | €15.00 | €0.26 | matched |
| 37 | capture | 01a15541-c3f2-7037-8188-9600164a86fa | €35.00 | €0.50 | matched |
| 38 | capture | 01a15541-fb9b-7a57-86ab-bd888ce9bf93 | €35.00 | €0.50 | matched |
| 39 | capture | 01a15542-02dc-7fe1-8436-7bb3f85aa9e5 | €15.00 | €0.26 | matched |
| 40 | capture | 01a15542-217b-7e2e-96c4-9f7b2ce74c34 | €24.00 | €0.37 | matched |
| 41 | capture | 01a15542-2c11-703b-b2de-70101cb6d5ad | €24.00 | €0.37 | matched |
| 42 | capture | 01a15542-42f4-7205-9bb0-3d6936d47c7f | €49.00 | €0.67 | matched |
| 43 | refund | 01a15542-5815-776d-be5c-f54a5e6d7635 | -€11.00 | €0.00 | matched |
| 44 | capture | 01a15542-65d6-719c-a915-6e420a7501ee | €24.00 | €0.37 | matched |
| 45 | capture | 01a15542-7478-779b-b3f5-a168174fea7d | €15.00 | €0.26 | matched |
| 46 | capture | 01a15542-7fc6-74bb-ada5-926751bc88bd | €15.00 | €0.26 | matched |
| 47 | capture | 01a15542-8c21-75ab-864e-cd6cdf2e91ea | €9.00 | €0.19 | matched |
| 48 | capture | 01a15542-a936-7ea4-a076-7d7ced120381 | €15.00 | €0.26 | matched |
| 49 | capture | 01a15542-d487-75bc-b1fb-50ecc05c4dd2 | €49.00 | €0.67 | matched |
| 50 | capture | 01a15542-ef9b-737b-8bbd-b3c92d8b05a3 | €24.00 | €0.37 | matched |
| 51 | capture | 01a15542-f2cc-73c6-b8c0-c9e84643a90f | €35.00 | €0.50 | matched |
| 52 | capture | 01a15542-f864-7ed6-867f-0dc8ef2d79d2 | €9.00 | €0.19 | matched |
| 53 | capture | 01a15543-0c44-7366-832f-2e61eea96640 | €15.00 | €0.26 | matched |
| 54 | capture | 01a15543-14bf-7fd3-a68e-476bcb07469f | €15.00 | €0.26 | matched |
| 56 | capture | 01a15543-30b1-7ec0-987f-437213885218 | €24.00 | €0.37 | matched |
| 57 | refund | 01a15543-39fb-74cd-8955-6973ef6d894d | -€8.00 | €0.00 | matched |
| 58 | refund | 01a15543-4562-7343-9240-5183c5df0af9 | -€44.00 | €0.00 | matched |
| 59 | capture | 01a15543-485a-79a1-8219-ec9ab2677ae2 | €24.00 | €0.37 | matched |
| 60 | capture | 01a15543-4c87-782e-9fab-2cf666cf1caf | €35.00 | €0.50 | matched |
| 61 | refund | 01a15543-59ff-7564-a5ce-e77ab06e53cf | -€12.00 | €0.00 | matched |
| 62 | capture | 01a15543-659c-7bab-b2ae-a5eb7fa5715e | €35.00 | €0.50 | matched |
| 63 | capture | 01a15543-8853-7027-9e2f-df03f0e74d38 | €15.00 | €0.26 | matched |
| 64 | capture | 01a15543-95d4-7804-9288-621e617c52b1 | €15.00 | €0.26 | matched |
| 65 | capture | 01a15543-9897-7edd-892a-906625132607 | €15.00 | €0.26 | matched |
| 66 | capture | 01a15543-ac07-7180-8e78-f3370e7c3d5c | €24.00 | €0.37 | matched |
| 67 | capture | 01a15543-b7cf-7d06-97b7-8e2c2547da69 | €9.00 | €0.19 | matched |
| 68 | capture | 01a15543-c8b3-73ff-8703-59dfbc9d5d84 | €9.00 | €0.19 | matched |
| 69 | capture | 01a15543-cfec-7c6e-a128-dea4b822cb02 | €35.00 | €0.50 | matched |
| 70 | capture | 01a15543-d7c2-7c85-a062-9212b8be87ff | €9.00 | €0.19 | matched |
| 71 | capture | 01a15543-e0ea-7cac-8ffc-041bc103250d | €9.00 | €0.19 | matched |
| 72 | capture | 01a15543-ee27-72d4-b2ef-6d7191dffba9 | €49.00 | €0.67 | matched |
| 73 | capture | 01a15544-0878-7608-83a1-2338b020c2e8 | €24.00 | €0.37 | matched |
| 74 | capture | 01a15544-2a8c-7b8a-ad78-dfc42b3eef7a | €15.00 | €0.26 | matched |
| 75 | capture | 01a15544-2b1c-7ede-9724-9ed109c6639b | €9.00 | €0.19 | matched |
| 76 | capture | 01a15544-2e77-7284-b251-90f5b9b7f8d7 | €35.00 | €0.50 | matched |
| 77 | capture | 01a15544-3350-7223-98dd-fd2b827e6fac | €9.00 | €0.19 | matched |
| 79 | capture | 01a15544-4ac8-7df7-9e07-9163293071fe | €35.00 | €0.50 | matched |
| 80 | refund | 01a15544-5ccb-70fc-9ec3-5518c1d2eed0 | -€29.00 | €0.00 | matched |
| 81 | capture | 01a15544-6ebd-73fa-a78f-4000dfc34a65 | €24.00 | €0.37 | matched |
| 82 | capture | 01a15544-a8f4-7390-aa20-f0578bac6594 | €24.00 | €0.37 | matched |
| 83 | capture | 01a15544-bed2-7566-8807-ade8e6323f39 | €24.00 | €0.37 | matched |
| 84 | capture | 01a15544-ceba-7be5-84a4-99db1b1ff05f | €49.00 | €0.67 | matched |
| 85 | capture | 01a15544-e72d-747e-9ede-b55d0a403043 | €9.00 | €0.19 | matched |
| 86 | capture | 01a15544-f26d-7dfe-843f-0fc0103abcab | €24.00 | €0.37 | matched |
| 87 | capture | 01a15544-f469-7948-8f6b-d682c1702ac4 | €15.00 | €0.26 | matched |
| 88 | capture | 01a15544-f923-78ab-bf0e-b5512076d087 | €24.00 | €0.37 | matched |
| 89 | capture | 01a15545-20dc-7de3-b131-77151810dc8c | €15.00 | €0.26 | matched |
| 90 | capture | 01a15545-2da9-712d-9a23-679562e654cf | €49.00 | €0.67 | matched |
| 91 | capture | 01a15545-342c-70bd-a1f9-4f1770b67b8a | €15.00 | €0.26 | matched |
| 92 | capture | 01a15545-415f-7831-99ef-87d05a1c1dca | €9.00 | €0.19 | matched |
| 93 | capture | 01a15545-513a-78b3-b9d3-7551e23fe77c | €49.00 | €0.67 | matched |
| 94 | capture | 01a15545-53bc-77e0-b929-e1fa4c93a979 | €35.00 | €0.50 | matched |
| 95 | capture | 01a15545-602e-70cf-951d-30a0d1d91a5a | €35.00 | €0.50 | matched |
| 96 | capture | 01a15545-7354-730d-bf15-1ce03d3a5246 | €9.00 | €0.19 | matched |
| 97 | capture | 01a15545-7611-7697-9a16-37a5c3ba3cc4 | €35.00 | €0.50 | matched |
| 98 | capture | 01a15545-79a1-7271-8a2f-db112f940064 | €24.00 | €0.37 | matched |
| 99 | capture | 01a15545-99aa-7f95-a33e-fb0807c490bb | €24.00 | €0.37 | matched |
| 100 | capture | 01a15545-a512-74c8-a754-1f800bea087b | €35.00 | €0.50 | matched |
| 101 | capture | 01a15545-b211-728b-8996-628bf76ef6b0 | €35.00 | €0.50 | matched |
| 102 | capture | 01a15545-b213-7570-a1a4-cf2c40930592 | €15.00 | €0.26 | matched |
| 103 | capture | 01a15545-b6b0-7a1a-8e09-525686b032fa | €35.00 | €0.50 | matched |
| 104 | capture | 01a15545-b91d-7d9b-ab40-ec2f6fc10cb8 | €15.00 | €0.26 | matched |
| 105 | capture | 01a15545-d539-79e5-95c9-4f2f7e4d3e26 | €15.00 | €0.26 | matched |
| 106 | capture | 01a15545-dec6-7cbe-b9b2-c92c0653db31 | €49.00 | €0.67 | matched |
| 107 | capture | 01a15546-0286-773c-8521-1376844bb0bb | €35.00 | €0.50 | matched |
| 109 | capture | 01a15546-0593-772a-aa4b-63674bce2771 | €49.00 | €0.67 | matched |
| 110 | capture | 01a15546-1c71-77c5-b2e1-6ab04b0956ac | €9.00 | €0.19 | matched |
| 111 | capture | 01a15546-1b31-7393-b09a-465be2187f89 | €15.00 | €0.26 | matched |
| 112 | capture | 01a15546-5d3c-75a8-8f08-41fcc64f3ecf | €15.00 | €0.26 | matched |
| 113 | capture | 01a15546-6961-7dd1-833e-9be4538f13ce | €24.00 | €0.37 | matched |
| 114 | capture | 01a15546-6e74-7b32-9c5c-6de3f3dfd539 | €49.00 | €0.67 | matched |
| 115 | capture | 01a15546-a8f0-7128-b43d-0ed265cf0c8a | €15.00 | €0.26 | matched |
| 116 | capture | 01a15546-ddac-7821-a597-75d7c93f596a | €24.00 | €0.37 | matched |
| 117 | capture | 01a15546-f1d4-74f8-b875-f221d01d9f36 | €49.00 | €0.67 | matched |
| 118 | refund | 01a15547-00c6-77b3-b967-fcbe4d5289ee | -€10.00 | €0.00 | matched |
| 119 | capture | 01a15547-175a-7c5d-8952-dc7ed2df9f59 | €15.00 | €0.26 | matched |
| 120 | capture | 01a15547-12e2-74c7-8f6d-ef921d4e7b0a | €24.00 | €0.37 | matched |
| 121 | capture | 01a15547-1d7a-7178-a162-2fb8802dd212 | €15.00 | €0.26 | matched |
| 122 | capture | 01a15547-4cb7-7a41-bb0d-13481d85e411 | €15.00 | €0.26 | matched |
| 123 | capture | 01a15547-5d1d-7eca-910f-65743eb37821 | €35.00 | €0.50 | matched |
| 124 | capture | 01a15547-6192-728a-aef1-5f04d74d0ca8 | €9.00 | €0.19 | matched |
| 125 | capture | 01a15547-900b-700d-962a-4e8d73a0e035 | €49.00 | €0.67 | matched |
| 126 | capture | 01a15547-98cb-7ff4-b48b-d2e3120dffc4 | €9.00 | €0.19 | matched |
| 127 | capture | 01a15547-a4f2-76d1-a778-f441a9d223f6 | €24.00 | €0.37 | matched |
| 128 | capture | 01a15547-ae9c-7311-b195-7a51ea9c1f0a | €9.00 | €0.19 | matched |
| 129 | capture | 01a15547-b34b-7b6a-b7b0-7ac561404f7c | €24.00 | €0.37 | matched |
| 130 | capture | 01a15547-bb24-75c4-aefe-ba2dcb23b06e | €35.00 | €0.50 | matched |
| 131 | capture | 01a15547-db88-7a56-a25a-406fd2762006 | €49.00 | €0.67 | matched |
| 132 | capture | 01a15547-de11-728d-949a-ef077fb7b3b7 | €35.00 | €0.50 | matched |
| 133 | capture | 01a15547-f1fa-7181-87e1-75089545931b | €35.00 | €0.50 | matched |
| 134 | capture | 01a15548-09d3-741b-93ee-9bfaa3faa9b8 | €9.00 | €0.19 | matched |
| 135 | capture | 01a15548-09c5-7e81-b1dc-20238df9c05d | €15.00 | €0.26 | matched |
| 136 | refund | 01a15548-1355-7d4a-ad2a-7947d1e8d586 | -€10.00 | €0.00 | matched |
| 137 | capture | 01a15548-111d-7cb2-8353-1b0f07e3f040 | €35.00 | €0.50 | matched |
| 138 | capture | 01a15548-4662-77d0-94e5-53c35b60b50b | €24.00 | €0.37 | matched |
| 139 | capture | 01a15548-60fa-7ddc-b7e8-001a1ead5dc7 | €15.00 | €0.26 | matched |
| 140 | capture | 01a15548-8a00-7243-b368-eb2c6e80c2c4 | €15.00 | €0.26 | matched |
| 141 | capture | 01a15548-9130-7165-8b93-77a33222966a | €24.00 | €0.37 | matched |
| 142 | capture | 01a15548-b7b6-7647-bd1c-fbf758bb496d | €35.00 | €0.50 | matched |
| 143 | refund | 01a15548-b99a-7290-949d-2f8b87ab8453 | -€26.00 | €0.00 | matched |
| 144 | capture | 01a15548-c234-786d-8e5b-92770bb7694b | €24.00 | €0.37 | matched |
| 145 | capture | 01a15548-cd75-71d3-9e52-2b94efba464f | €49.00 | €0.67 | matched |