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
- 20 Oct, 02:50130 linesclean
- 20 Oct, 02:40120 lines3 breaks
- 20 Oct, 02:30105 lines3 breaks
- 20 Oct, 02:20114 lines1 break
- 20 Oct, 02:10141 lines2 breaks
- 20 Oct, 02:00111 linesclean
- 20 Oct, 01:50142 linesclean
- 20 Oct, 01:40115 lines1 break
- 20 Oct, 01:30125 lines1 break
- 20 Oct, 01:20101 lines3 breaks
- 20 Oct, 01:10113 lines3 breaks
- 20 Oct, 01:00133 lines7 breaks
- 20 Oct, 00:50125 lines2 breaks
- 20 Oct, 00:40137 lines4 breaks
20 Oct, 01:00
Gross
€2,873.00
PSP fee
€46.11
Net to the bank
€2,826.89
Settlement journal
#96634
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a156d5-2c76-79c5-910f-43ccaa1a10bb is already settled by stl_EUR_2987430 line 42
- duplicate linethe file lists it twicerefund:01a156d7-b640-7495-8567-982fe79b68c6 is already settled by stl_EUR_2987430 line 75
- fee differencethe fee is not the contract feethe fee is 38, the contract says 37
- fee differencethe fee is not the contract feethe fee is 30, the contract says 26
- fee differencethe fee is not the contract feethe fee is 51, the contract says 50
- fee differencethe fee is not the contract feethe fee is 27, the contract says 26
- missing linein the books, not in the filecapture:01a156da-8845-7543-a504-abec44975e99 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 23 | capture | 01a156d3-daa2-7a88-b729-0074cafa9fe8 | €24.00 | €0.38 | fee difference |
| 43 | capture | 01a156d5-2ca1-77c9-bd97-61c2f9e74cfc | €24.00 | €0.37 | duplicate line |
| 63 | capture | 01a156d6-7fb8-754c-bc5f-42e085e51aa5 | €15.00 | €0.30 | fee difference |
| 72 | capture | 01a156d7-7f86-7cbf-b3c8-13e7d53e3538 | €35.00 | €0.51 | fee difference |
| 76 | refund | 01a156d7-b641-7f26-a0b7-8992055f261f | -€3.00 | €0.00 | duplicate line |
| 130 | capture | 01a156db-8801-7e53-a9bd-8ce0b9e55bf8 | €15.00 | €0.27 | fee difference |
| 1 | capture | 01a156ca-4f99-7042-8c10-9b48393cbce0 | €15.00 | €0.26 | matched |
| 2 | capture | 01a156cd-c9cd-7e23-a6b0-357cc013155c | €9.00 | €0.19 | matched |
| 3 | refund | 01a156cd-d2b7-7969-8f65-d9baabcadb50 | -€15.00 | €0.00 | matched |
| 4 | capture | 01a156cf-a2db-7daa-bc39-f044c430a7ab | €24.00 | €0.37 | matched |
| 5 | capture | 01a156d2-886a-7e50-9e86-e01f363ffcf6 | €49.00 | €0.67 | matched |
| 6 | refund | 01a156d2-8e5e-7e11-9d4f-a3daaacd7e34 | -€7.00 | €0.00 | matched |
| 7 | capture | 01a156d2-9dbb-7a71-846f-139e0d74cd9a | €24.00 | €0.37 | matched |
| 8 | capture | 01a156d2-b377-7caa-b0e6-cedf2622f265 | €35.00 | €0.50 | matched |
| 9 | capture | 01a156d2-b835-74df-8829-ec5210434ae0 | €15.00 | €0.26 | matched |
| 10 | refund | 01a156d2-c6e7-7f99-950f-c4e682826bdb | -€2.00 | €0.00 | matched |
| 11 | capture | 01a156d2-dcfd-72c7-9000-9b4a0477eb6f | €15.00 | €0.26 | matched |
| 12 | capture | 01a156d3-265b-7bd6-8b54-531ba3ff0980 | €35.00 | €0.50 | matched |
| 13 | refund | 01a156d3-2875-7b2f-bfe7-8e8545b43b4a | -€9.00 | €0.00 | matched |
| 14 | capture | 01a156d3-2f84-70fb-878d-1eb125937178 | €9.00 | €0.19 | matched |
| 15 | capture | 01a156d3-4ba5-7a16-b08d-ae186bc272c9 | €35.00 | €0.50 | matched |
| 16 | capture | 01a156d3-8e36-7dac-9812-261ee388e8e3 | €9.00 | €0.19 | matched |
| 17 | capture | 01a156d3-914b-796c-be1d-e5c676ff49d6 | €49.00 | €0.67 | matched |
| 18 | capture | 01a156d3-a887-7103-8609-0b0758aff0c5 | €15.00 | €0.26 | matched |
| 19 | capture | 01a156d3-b42b-7c33-a3cc-f20190073f32 | €15.00 | €0.26 | matched |
| 20 | capture | 01a156d3-b6fb-7973-a4ff-27c3ce180d18 | €49.00 | €0.67 | matched |
| 21 | capture | 01a156d3-b986-79d9-85ea-9ec87ba2f315 | €24.00 | €0.37 | matched |
| 22 | capture | 01a156d3-d8ae-71ee-9ec1-7c036750aa04 | €9.00 | €0.19 | matched |
| 24 | refund | 01a156d3-e9a1-79d3-bc3b-74afabbc7082 | -€27.00 | €0.00 | matched |
| 25 | capture | 01a156d3-ef2a-7e39-84c7-4c97aa4562a5 | €49.00 | €0.67 | matched |
| 26 | capture | 01a156d4-0725-7084-b8d3-defc56683eee | €24.00 | €0.37 | matched |
| 27 | refund | 01a156d4-16de-71a7-9b24-c99d117ea87d | -€12.00 | €0.00 | matched |
| 28 | capture | 01a156d4-1d19-7a80-b41c-39f283ed2340 | €49.00 | €0.67 | matched |
| 29 | capture | 01a156d4-2a06-728d-9ed9-42f75c143067 | €24.00 | €0.37 | matched |
| 30 | capture | 01a156d4-4e32-7508-92ea-8992efb1b80d | €15.00 | €0.26 | matched |
| 31 | capture | 01a156d4-8216-7e66-b66b-a6948bbaed2b | €24.00 | €0.37 | matched |
| 32 | capture | 01a156d4-8314-7a0f-a7cc-0327f1866306 | €35.00 | €0.50 | matched |
| 33 | capture | 01a156d4-9437-78b0-a64a-3c1bc8aeccf2 | €35.00 | €0.50 | matched |
| 34 | capture | 01a156d4-a22c-7daa-a24b-dd903121b68c | €9.00 | €0.19 | matched |
| 35 | capture | 01a156d4-ad66-7080-990f-efe50e935be6 | €49.00 | €0.67 | matched |
| 36 | capture | 01a156d4-cece-7184-abbf-741cfd477631 | €35.00 | €0.50 | matched |
| 37 | capture | 01a156d4-defa-762f-be77-0af8a5b4c711 | €9.00 | €0.19 | matched |
| 38 | capture | 01a156d4-ecd6-74da-b1df-b301a3b11ed4 | €49.00 | €0.67 | matched |
| 39 | capture | 01a156d5-17d6-7b87-a3ee-13e8dabb7bc3 | €15.00 | €0.26 | matched |
| 40 | capture | 01a156d5-1990-7853-81b4-33758c9d5ca7 | €9.00 | €0.19 | matched |
| 41 | capture | 01a156d5-204d-7cda-86a1-31e22fc8f9fd | €24.00 | €0.37 | matched |
| 42 | capture | 01a156d5-2ca1-77c9-bd97-61c2f9e74cfc | €24.00 | €0.37 | matched |
| 44 | refund | 01a156d5-3188-7ebd-9d25-7e2ce248340c | -€10.00 | €0.00 | matched |
| 45 | capture | 01a156d5-62bf-7d03-8759-d1e4a76946dc | €15.00 | €0.26 | matched |
| 46 | capture | 01a156d5-637c-7841-81e1-46bd5514b29e | €24.00 | €0.37 | matched |
| 47 | capture | 01a156d5-6663-7123-a3a0-4be61f0d95ef | €35.00 | €0.50 | matched |
| 48 | capture | 01a156d5-6cd4-7e1c-beaa-7c98c1d6c18b | €35.00 | €0.50 | matched |
| 49 | refund | 01a156d5-7f1a-7f71-bada-ddc5e61670cc | -€4.00 | €0.00 | matched |
| 50 | capture | 01a156d5-8e7a-7a96-b6b6-741cd8f00bf6 | €24.00 | €0.37 | matched |
| 51 | capture | 01a156d5-ae6f-735c-93cb-0e9636e01968 | €24.00 | €0.37 | matched |
| 52 | capture | 01a156d5-bafc-7027-8641-984fc67a74a6 | €35.00 | €0.50 | matched |
| 53 | capture | 01a156d5-cead-70a3-aced-7e1a33dfb51e | €24.00 | €0.37 | matched |
| 54 | capture | 01a156d6-014b-77f9-92ec-d0bcdcf5ad81 | €9.00 | €0.19 | matched |
| 55 | capture | 01a156d6-074c-736c-86d1-bf46fbcd6607 | €24.00 | €0.37 | matched |
| 56 | capture | 01a156d6-0c93-7ba6-8211-294575707b7d | €9.00 | €0.19 | matched |
| 57 | capture | 01a156d6-10d9-7393-9368-7fd4847f8ba1 | €9.00 | €0.19 | matched |
| 58 | capture | 01a156d6-34cb-77ee-94fd-5ed07b70866d | €49.00 | €0.67 | matched |
| 59 | capture | 01a156d6-4622-768b-9ee0-74fe1c1b324e | €9.00 | €0.19 | matched |
| 60 | capture | 01a156d6-4874-77dc-bf88-ac3053e057a9 | €15.00 | €0.26 | matched |
| 61 | capture | 01a156d6-4e86-7dcb-9435-07b0722225e5 | €15.00 | €0.26 | matched |
| 62 | capture | 01a156d6-6377-7da1-8767-a0bc0e132e9d | €24.00 | €0.37 | matched |
| 64 | capture | 01a156d6-b659-7264-806e-fa644d419b5a | €24.00 | €0.37 | matched |
| 65 | capture | 01a156d6-f6cf-7959-86cc-f1bfa9b515a2 | €15.00 | €0.26 | matched |
| 66 | capture | 01a156d7-026d-7e25-b772-090625fa2415 | €49.00 | €0.67 | matched |
| 67 | capture | 01a156d7-0a22-7f8e-b5b0-2b017a3175a7 | €9.00 | €0.19 | matched |
| 68 | capture | 01a156d7-29ca-7ee3-a40e-15dad47f7384 | €24.00 | €0.37 | matched |
| 69 | capture | 01a156d7-2fb9-7759-855b-2ea6d39f2873 | €24.00 | €0.37 | matched |
| 70 | capture | 01a156d7-438a-7327-b1e1-a1ac0e5c7933 | €49.00 | €0.67 | matched |
| 71 | capture | 01a156d7-6023-7337-911d-bc4c48c1f819 | €9.00 | €0.19 | matched |
| 73 | capture | 01a156d7-88cd-7575-9327-3b573060ef85 | €24.00 | €0.37 | matched |
| 74 | capture | 01a156d7-afe8-71b9-8efb-91dfc39655ba | €24.00 | €0.37 | matched |
| 75 | refund | 01a156d7-b641-7f26-a0b7-8992055f261f | -€3.00 | €0.00 | matched |
| 77 | capture | 01a156d7-cd93-7df1-b0d1-0ce8b70c78aa | €9.00 | €0.19 | matched |
| 78 | capture | 01a156d7-e9e8-7581-ae24-8e55539b1038 | €49.00 | €0.67 | matched |
| 79 | capture | 01a156d7-f21c-771d-a7aa-1a8ef45bde07 | €49.00 | €0.67 | matched |
| 80 | capture | 01a156d7-f22d-7676-b55a-b45f00dc30ef | €15.00 | €0.26 | matched |
| 81 | capture | 01a156d8-0dc8-7de5-a879-885d83fabdeb | €49.00 | €0.67 | matched |
| 82 | capture | 01a156d8-1f5a-7874-b664-ad3e8805fbdd | €49.00 | €0.67 | matched |
| 83 | capture | 01a156d8-3442-7d3c-9162-efadad245d5d | €24.00 | €0.37 | matched |
| 84 | capture | 01a156d8-6830-792d-b911-6d05bb06ac68 | €9.00 | €0.19 | matched |
| 85 | capture | 01a156d8-6ffd-7979-9c21-bb3637f03e39 | €35.00 | €0.50 | matched |
| 86 | capture | 01a156d8-781e-7b89-8937-6cd2f9f95e3b | €15.00 | €0.26 | matched |
| 87 | capture | 01a156d8-b782-7966-957f-b6f28df08368 | €15.00 | €0.26 | matched |
| 88 | capture | 01a156d8-c4a9-7935-b20f-a44d8bcf3117 | €49.00 | €0.67 | matched |
| 89 | capture | 01a156d8-c6ee-7d35-88c8-ce6e4c143be3 | €15.00 | €0.26 | matched |
| 90 | refund | 01a156d8-e0fb-74e3-8548-8efd26a8eae6 | -€15.00 | €0.00 | matched |
| 91 | capture | 01a156d8-f28d-7a79-96da-3a63767fd79f | €35.00 | €0.50 | matched |
| 92 | capture | 01a156d8-fbdc-79d9-ab58-db3d6d80578a | €9.00 | €0.19 | matched |
| 93 | capture | 01a156d9-30b2-75ae-8726-18e3dca21857 | €35.00 | €0.50 | matched |
| 94 | capture | 01a156d9-393a-7ff8-b0ef-af7535326b1a | €35.00 | €0.50 | matched |
| 95 | capture | 01a156d9-4f49-7fe7-a60a-d967d6d3870b | €9.00 | €0.19 | matched |
| 96 | capture | 01a156d9-56f6-7d0f-ac74-3cd9edd5173a | €35.00 | €0.50 | matched |
| 97 | capture | 01a156d9-762f-73a2-9f72-0dc39b3144c6 | €9.00 | €0.19 | matched |
| 98 | refund | 01a156d9-7993-7483-8c97-8fad625abf14 | -€23.00 | €0.00 | matched |
| 99 | capture | 01a156d9-7e79-79e4-89fa-197a46e89cc4 | €9.00 | €0.19 | matched |
| 100 | capture | 01a156d9-7fa5-7a8a-a196-4ad51fc060d8 | €9.00 | €0.19 | matched |
| 101 | capture | 01a156d9-a412-703b-b08c-fa1aaad74e56 | €15.00 | €0.26 | matched |
| 102 | capture | 01a156d9-a9c9-7746-8fc9-c75ce70db1a7 | €35.00 | €0.50 | matched |
| 103 | capture | 01a156d9-add1-78ce-80cd-219cdbfe1e51 | €35.00 | €0.50 | matched |
| 104 | capture | 01a156d9-d8bd-70d2-8075-c9298497ac21 | €35.00 | €0.50 | matched |
| 105 | capture | 01a156d9-e195-7415-8db4-233f56095db6 | €35.00 | €0.50 | matched |
| 106 | refund | 01a156da-0e55-7dc3-a284-ab31a58bd7db | -€22.00 | €0.00 | matched |
| 107 | capture | 01a156da-16c6-75e9-94f3-374718481a5c | €24.00 | €0.37 | matched |
| 108 | capture | 01a156da-2d4a-7f23-a84a-4dc315291828 | €24.00 | €0.37 | matched |
| 109 | capture | 01a156da-32dd-7082-9b87-ad62a459768f | €9.00 | €0.19 | matched |
| 110 | capture | 01a156da-55bf-7025-bc07-582280149a54 | €35.00 | €0.50 | matched |
| 111 | capture | 01a156da-572a-738d-8bca-e1b1a0727daa | €49.00 | €0.67 | matched |
| 112 | capture | 01a156da-5aff-7d57-98b6-2e32a6fbe3c6 | €15.00 | €0.26 | matched |
| 113 | capture | 01a156da-4c55-7763-9427-bba9d3430051 | €35.00 | €0.50 | matched |
| 114 | capture | 01a156da-860a-7613-921a-5f3619c7926a | €9.00 | €0.19 | matched |
| 115 | capture | 01a156da-9a4b-7e31-8541-e72349fa7d3c | €35.00 | €0.50 | matched |
| 116 | capture | 01a156da-9d76-7dd4-8b61-6695265d05cb | €35.00 | €0.50 | matched |
| 117 | refund | 01a156da-a05a-7391-af70-d8862d7549c4 | -€4.00 | €0.00 | matched |
| 118 | capture | 01a156da-cc91-73f5-968b-3ae05d476bdf | €35.00 | €0.50 | matched |
| 119 | capture | 01a156da-d808-7810-aca8-b337ff244e17 | €49.00 | €0.67 | matched |
| 120 | capture | 01a156da-db36-74d9-9597-48546d81a5ec | €9.00 | €0.19 | matched |
| 121 | capture | 01a156da-e4d2-7dfb-b15e-6e826e09b774 | €49.00 | €0.67 | matched |
| 122 | capture | 01a156da-f16f-7c93-9bfa-be3ef1943311 | €35.00 | €0.50 | matched |
| 123 | capture | 01a156db-0388-7733-a405-88e2164a908e | €49.00 | €0.67 | matched |
| 124 | capture | 01a156db-0d9c-7d0e-a905-94e1ed538ed4 | €9.00 | €0.19 | matched |
| 125 | capture | 01a156db-0dd1-7393-bd4d-2ca9a1238192 | €49.00 | €0.67 | matched |
| 126 | capture | 01a156db-2e9f-78a0-bbc0-92bbe889cec8 | €9.00 | €0.19 | matched |
| 127 | capture | 01a156db-48d8-78bb-9ce3-642d597c795c | €9.00 | €0.19 | matched |
| 128 | capture | 01a156db-68ba-7736-a543-87765d996d8c | €9.00 | €0.19 | matched |
| 129 | refund | 01a156db-8757-7fc5-ae8a-ae32e9f710aa | -€9.00 | €0.00 | matched |
| 131 | capture | 01a156db-952f-7c33-9fc4-3ffe36bd0644 | €49.00 | €0.67 | matched |
| 132 | capture | 01a156db-a031-7aa0-bdb7-0e064c1b2a94 | €15.00 | €0.26 | matched |
| 133 | capture | 01a156db-abe0-7e85-b16b-da8c69ad97fc | €15.00 | €0.26 | matched |