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, 18:30121 lines3 breaks
- 3 Nov, 18:20131 lines2 breaks
- 3 Nov, 18:10122 lines2 breaks
- 3 Nov, 18:00124 lines1 break
- 3 Nov, 17:50126 lines5 breaks
- 3 Nov, 17:40142 lines4 breaks
- 3 Nov, 17:3095 lines1 break
- 3 Nov, 17:20131 lines2 breaks
- 3 Nov, 17:10119 lines6 breaks
- 3 Nov, 17:00144 lines2 breaks
- 3 Nov, 16:50115 lines2 breaks
- 3 Nov, 16:40140 lines2 breaks
- 3 Nov, 16:30108 lines2 breaks
- 3 Nov, 16:20117 lines3 breaks
3 Nov, 17:10
Gross
€2,879.00
PSP fee
€45.04
Net to the bank
€2,833.96
Settlement journal
#364687
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a269-3e2b-77c2-b682-1e935be36717 is already settled by stl_EUR_2989543 line 73
- duplicate linethe file lists it twicecapture:01a1a269-79ff-709e-840e-c5a98d9cb475 is already settled by stl_EUR_2989543 line 79
- fee differencethe fee is not the contract feethe fee is 52, the contract says 50
- missing linein the books, not in the filecapture:01a1a265-8d8f-7805-9502-d9f1413c64ba is in no file
- missing linein the books, not in the filecapture:01a1a266-7009-7648-bb54-3845e710befc is in no file
- missing linein the books, not in the filecapture:01a1a267-9bff-7cba-b376-55db7b3347e9 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 48 | capture | 01a1a266-cc4f-75a8-8a3c-c060a324e05a | €35.00 | €0.52 | fee difference |
| 74 | capture | 01a1a269-3e5b-7e4f-92fe-c73914c8dc5c | €35.00 | €0.50 | duplicate line |
| 80 | capture | 01a1a269-7a38-710c-8e92-6723f0e73331 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a1a25d-2f21-7312-af79-5ed562d8bed6 | €24.00 | €0.37 | matched |
| 2 | capture | 01a1a263-7b70-703a-b0c6-a1a2466253bd | €15.00 | €0.26 | matched |
| 3 | capture | 01a1a263-a331-7242-8367-ba0d239d8923 | €35.00 | €0.50 | matched |
| 4 | capture | 01a1a263-b894-7538-bd25-b51d3e9786fe | €9.00 | €0.19 | matched |
| 5 | capture | 01a1a263-cfc1-73f3-9ee7-0d1c26da27b1 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1a264-0fcb-7862-be30-166363d48bb5 | €35.00 | €0.50 | matched |
| 7 | capture | 01a1a264-3697-7502-8bd4-e4e5f00427b2 | €15.00 | €0.26 | matched |
| 8 | capture | 01a1a264-3ce9-70f6-9038-2c91135bb8a6 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1a264-53ed-7a10-9aad-a69798320138 | €35.00 | €0.50 | matched |
| 10 | capture | 01a1a264-559e-7db2-bbc7-9f588ec1c5e9 | €24.00 | €0.37 | matched |
| 11 | capture | 01a1a264-622e-709f-a1de-3966998dc645 | €49.00 | €0.67 | matched |
| 12 | capture | 01a1a264-6c46-7ecd-9781-cb00f13d0895 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1a264-90ab-7285-a6fa-c7032d574072 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1a264-9d49-7681-8a6d-a266926f8c79 | €24.00 | €0.37 | matched |
| 15 | capture | 01a1a264-ad85-7d3f-bfe0-7eb4212a244f | €35.00 | €0.50 | matched |
| 16 | capture | 01a1a264-d62a-7a8c-8de1-88b36e82d2f9 | €24.00 | €0.37 | matched |
| 17 | capture | 01a1a264-db1e-7d0a-acd7-0d13dd1a8344 | €24.00 | €0.37 | matched |
| 18 | capture | 01a1a265-0b6a-7359-8fb1-e840ec18b20d | €49.00 | €0.67 | matched |
| 19 | capture | 01a1a265-0c5b-70e5-9569-644b63c4aa53 | €24.00 | €0.37 | matched |
| 20 | capture | 01a1a265-0cf3-71e2-bda6-673dfb39d555 | €15.00 | €0.26 | matched |
| 21 | capture | 01a1a265-122b-707b-9a43-bc8248baa870 | €15.00 | €0.26 | matched |
| 22 | capture | 01a1a265-5d05-756e-a316-7b48cee72c66 | €24.00 | €0.37 | matched |
| 23 | capture | 01a1a265-712a-733a-9e39-938f8b1ed1fd | €35.00 | €0.50 | matched |
| 24 | capture | 01a1a265-77a3-7d48-9506-8c7fe62acb11 | €35.00 | €0.50 | matched |
| 25 | capture | 01a1a265-80ab-71c5-b57d-2c246e9cdd94 | €9.00 | €0.19 | matched |
| 26 | capture | 01a1a265-876e-7d7b-bf00-4a4b980c7499 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1a265-c545-794e-8861-dc9995c603a3 | €15.00 | €0.26 | matched |
| 28 | capture | 01a1a265-ca31-7e1d-9820-e55b765c2e20 | €15.00 | €0.26 | matched |
| 29 | capture | 01a1a265-d089-777f-8b02-a9a34c1ab857 | €35.00 | €0.50 | matched |
| 30 | refund | 01a1a265-d8bf-776e-a50d-54a6dc017bf8 | -€27.00 | €0.00 | matched |
| 31 | capture | 01a1a265-f562-7ec0-8541-12ce95b34d09 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1a266-0f9b-7865-9dd6-0dd38c1fa7f5 | €24.00 | €0.37 | matched |
| 33 | refund | 01a1a266-3687-7143-bda6-a105d063132f | -€12.00 | €0.00 | matched |
| 34 | capture | 01a1a266-484b-71a4-a938-8f02e28a90db | €35.00 | €0.50 | matched |
| 35 | capture | 01a1a266-56ba-731a-bd4d-6924a39cd826 | €49.00 | €0.67 | matched |
| 36 | capture | 01a1a266-6705-7487-a8c7-5d99b98444d8 | €49.00 | €0.67 | matched |
| 37 | capture | 01a1a266-6c82-7cb9-ae54-953d61fb317e | €9.00 | €0.19 | matched |
| 38 | capture | 01a1a266-8946-70b4-95c1-00b7c9c95126 | €9.00 | €0.19 | matched |
| 39 | capture | 01a1a266-8b34-7258-a2cf-9cb1f9352436 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1a266-9559-7f61-be22-5e0f379e05b0 | €15.00 | €0.26 | matched |
| 41 | capture | 01a1a266-9ca7-70d4-bf59-2ccb4bb3e0e3 | €15.00 | €0.26 | matched |
| 42 | capture | 01a1a266-9d38-7734-bfca-141e9aa01890 | €24.00 | €0.37 | matched |
| 43 | capture | 01a1a266-9e8f-7016-9940-fca158742a78 | €49.00 | €0.67 | matched |
| 44 | capture | 01a1a266-a1f5-7537-9c27-66e1cf314ecc | €24.00 | €0.37 | matched |
| 45 | capture | 01a1a266-a6cd-712e-a23f-f28073c48db1 | €24.00 | €0.37 | matched |
| 46 | capture | 01a1a266-b594-7313-be49-a5bdb902ed0f | €24.00 | €0.37 | matched |
| 47 | refund | 01a1a266-bd0b-7e52-a5d3-e02577aa6206 | -€31.00 | €0.00 | matched |
| 49 | capture | 01a1a267-033b-7f26-9052-b50a406944c1 | €15.00 | €0.26 | matched |
| 50 | capture | 01a1a267-05dc-7abb-9586-883337bf7874 | €24.00 | €0.37 | matched |
| 51 | capture | 01a1a267-0c03-7568-a908-5df1b648d1f1 | €24.00 | €0.37 | matched |
| 52 | refund | 01a1a267-4041-7d1d-b571-d144ef4c54eb | -€26.00 | €0.00 | matched |
| 53 | capture | 01a1a267-61c7-767f-a2c9-4877e6ee37c9 | €49.00 | €0.67 | matched |
| 54 | capture | 01a1a267-9961-7259-952f-87c402b66f5a | €49.00 | €0.67 | matched |
| 55 | capture | 01a1a267-9d39-7c8b-9ea1-dc244aae34b7 | €49.00 | €0.67 | matched |
| 56 | capture | 01a1a267-ae31-7150-9539-d5a404def04a | €9.00 | €0.19 | matched |
| 57 | capture | 01a1a267-c4d8-7970-af44-8fd7bfd42717 | €35.00 | €0.50 | matched |
| 58 | capture | 01a1a267-c936-722f-bac7-4a4f93c8a490 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1a267-d45e-777e-984d-49b2dde52502 | €49.00 | €0.67 | matched |
| 60 | capture | 01a1a267-db3a-7bbe-99d8-6e3e99a112b4 | €15.00 | €0.26 | matched |
| 61 | capture | 01a1a267-e12c-75c3-ac84-279dbc657cdd | €35.00 | €0.50 | matched |
| 62 | capture | 01a1a268-036a-7a9a-a591-c596b2990ff2 | €9.00 | €0.19 | matched |
| 63 | capture | 01a1a268-22b5-731f-86f6-32ade7eba3e4 | €24.00 | €0.37 | matched |
| 64 | capture | 01a1a268-2585-78af-a3e0-759fd9ff5da2 | €24.00 | €0.37 | matched |
| 65 | capture | 01a1a268-30d4-74d8-af57-c9301e6f100f | €24.00 | €0.37 | matched |
| 66 | capture | 01a1a268-71fc-7218-98f3-0457bcea59ed | €9.00 | €0.19 | matched |
| 67 | capture | 01a1a268-9253-79df-b935-4753fab60a3e | €24.00 | €0.37 | matched |
| 68 | capture | 01a1a268-bdae-7c71-a8a6-d25219562e90 | €35.00 | €0.50 | matched |
| 69 | capture | 01a1a268-e13e-754d-b404-1a3cd8943474 | €24.00 | €0.37 | matched |
| 70 | capture | 01a1a269-14b5-7995-927d-5c3f0946fc96 | €9.00 | €0.19 | matched |
| 71 | capture | 01a1a269-1c9f-778f-b19d-a0d88d5346dd | €15.00 | €0.26 | matched |
| 72 | capture | 01a1a269-34dd-7446-bb17-8933f4ec2140 | €24.00 | €0.37 | matched |
| 73 | capture | 01a1a269-3e5b-7e4f-92fe-c73914c8dc5c | €35.00 | €0.50 | matched |
| 75 | capture | 01a1a269-5ef6-7409-86b5-7c1d36f170d1 | €49.00 | €0.67 | matched |
| 76 | capture | 01a1a269-631c-7e60-b801-3d31315c595e | €49.00 | €0.67 | matched |
| 77 | capture | 01a1a269-74f2-7392-ae7b-f9e14a8db9c4 | €24.00 | €0.37 | matched |
| 78 | capture | 01a1a269-75b3-78bd-8485-a995b365a013 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1a269-7a38-710c-8e92-6723f0e73331 | €24.00 | €0.37 | matched |
| 81 | capture | 01a1a269-b70e-73fa-a258-223204ef0abd | €35.00 | €0.50 | matched |
| 82 | capture | 01a1a269-bd5f-7912-88d0-0cd8fe58ecfa | €15.00 | €0.26 | matched |
| 83 | capture | 01a1a269-c64e-743c-90c4-1c594f4f2315 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1a269-cc1e-70f5-9f9c-d09040b47e2d | €9.00 | €0.19 | matched |
| 85 | capture | 01a1a269-e751-724a-9bd1-4fa3b17620ba | €9.00 | €0.19 | matched |
| 86 | capture | 01a1a269-ef76-7e6d-9acb-5a2b235c76e2 | €49.00 | €0.67 | matched |
| 87 | refund | 01a1a269-f7ec-7c68-a320-2ea0b90a29c5 | -€2.00 | €0.00 | matched |
| 88 | capture | 01a1a26a-00c1-75c2-ae59-f6293238ac3c | €24.00 | €0.37 | matched |
| 89 | capture | 01a1a26a-092a-70ff-ae06-857c7e1e15be | €35.00 | €0.50 | matched |
| 90 | capture | 01a1a26a-0c74-755f-ab02-011ce00aab79 | €15.00 | €0.26 | matched |
| 91 | capture | 01a1a26a-1229-75a7-969e-6e34166f00d1 | €9.00 | €0.19 | matched |
| 92 | capture | 01a1a26a-3ce1-71d6-bfd3-2a2446c6c848 | €35.00 | €0.50 | matched |
| 93 | capture | 01a1a26a-5303-7fab-9a59-a0940ac45824 | €35.00 | €0.50 | matched |
| 94 | refund | 01a1a26a-70a2-7fc2-b360-8e6797f0af01 | -€8.00 | €0.00 | matched |
| 95 | capture | 01a1a26a-7ddd-755e-abfe-64ecdb17a1ed | €15.00 | €0.26 | matched |
| 96 | capture | 01a1a26a-8b4b-7b3a-ab40-fbb7edff0fc4 | €9.00 | €0.19 | matched |
| 97 | capture | 01a1a26a-b361-72f9-97e6-4af12a66c5cd | €35.00 | €0.50 | matched |
| 98 | capture | 01a1a26a-bb08-7e62-86e9-2c6083b4337c | €49.00 | €0.67 | matched |
| 99 | capture | 01a1a26a-f3d8-7e42-9ac4-1d23c5c8ddc7 | €49.00 | €0.67 | matched |
| 100 | capture | 01a1a26a-ff5e-7dea-a0c1-932b93454c3e | €15.00 | €0.26 | matched |
| 101 | capture | 01a1a26b-3d0f-7c96-a97b-236bb872fea5 | €15.00 | €0.26 | matched |
| 102 | capture | 01a1a26b-4a89-7319-b76a-08a341b104e3 | €15.00 | €0.26 | matched |
| 103 | capture | 01a1a26b-7932-7670-9d9a-1def82c4c978 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1a26b-a32d-7644-b701-9d01813045a0 | €35.00 | €0.50 | matched |
| 105 | capture | 01a1a26b-a646-74a3-939f-a564bb6ad626 | €49.00 | €0.67 | matched |
| 106 | capture | 01a1a26b-bd33-7d0b-8780-49a9bf1d84d8 | €49.00 | €0.67 | matched |
| 107 | capture | 01a1a26b-e858-7c2b-9ba5-55fdd0cd5f40 | €15.00 | €0.26 | matched |
| 108 | capture | 01a1a26c-1e99-7ec3-ae07-18c54ca2ffab | €24.00 | €0.37 | matched |
| 109 | capture | 01a1a26c-22aa-79da-b2bf-3330c999c583 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1a26c-2365-7265-a5c1-be2d70a9ef9f | €35.00 | €0.50 | matched |
| 111 | capture | 01a1a26c-2667-7502-9e27-4d08c5c752fe | €15.00 | €0.26 | matched |
| 112 | capture | 01a1a26c-3dbe-7de7-bd3d-244e89bf57c4 | €35.00 | €0.50 | matched |
| 113 | capture | 01a1a26c-54e6-7bc5-9a91-0786f3ce3600 | €9.00 | €0.19 | matched |
| 114 | capture | 01a1a26c-58ad-71d5-bfa0-18b142460975 | €24.00 | €0.37 | matched |
| 115 | refund | 01a1a26c-651d-7084-b025-d3cf5051fd04 | -€9.00 | €0.00 | matched |
| 116 | capture | 01a1a26c-6da2-7a3d-b8b2-0eae532ae425 | €49.00 | €0.67 | matched |
| 117 | capture | 01a1a26c-7d74-795e-8e1b-0c8fc607974d | €15.00 | €0.26 | matched |
| 118 | capture | 01a1a26c-7f83-78d3-8efb-de5dfe9687a9 | €49.00 | €0.67 | matched |
| 119 | capture | 01a1a26c-8d4b-72de-9ab8-3520f0a61093 | €15.00 | €0.26 | matched |