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
- 2 Nov, 13:20124 lines2 breaks
- 2 Nov, 13:10126 lines1 break
- 2 Nov, 13:00146 lines1 break
- 2 Nov, 12:50118 linesclean
- 2 Nov, 12:40112 lines3 breaks
- 2 Nov, 12:30127 lines4 breaks
- 2 Nov, 12:20137 lines6 breaks
- 2 Nov, 12:10114 lines3 breaks
- 2 Nov, 12:00128 lines3 breaks
- 2 Nov, 11:50125 linesclean
- 2 Nov, 11:40105 lines5 breaks
- 2 Nov, 11:30136 lines2 breaks
- 2 Nov, 11:20137 lines1 break
- 2 Nov, 11:10127 lines1 break
2 Nov, 12:20
Gross
€3,239.00
PSP fee
€51.48
Net to the bank
€3,187.52
Settlement journal
#342730
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19c3c-3be8-7d4e-8c3f-0349ac7eb31c is already settled by stl_EUR_2989371 line 4
- fee differencethe fee is not the contract feethe fee is 29, the contract says 26
- fee differencethe fee is not the contract feethe fee is 68, the contract says 67
- 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 21, the contract says 19
- missing linein the books, not in the filecapture:01a19c3b-e4cb-7678-99dd-e1f9c9747464 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 14 | capture | 01a19c34-f4ce-781e-a18c-30a1f03cb061 | €15.00 | €0.29 | fee difference |
| 31 | capture | 01a19c35-cdec-71c0-adeb-86ff2896d8cd | €49.00 | €0.68 | fee difference |
| 79 | capture | 01a19c39-2c8b-7612-803f-b55598266074 | €24.00 | €0.38 | fee difference |
| 1 | capture | 01a19c2d-d4c4-7330-b566-be5168e385cf | €15.00 | €0.26 | matched |
| 2 | capture | 01a19c2e-a966-71f9-962b-23e22ed42009 | €35.00 | €0.50 | matched |
| 3 | capture | 01a19c33-cecf-78b0-87bd-d1864dab0191 | €24.00 | €0.37 | matched |
| 4 | capture | 01a19c33-d77f-7aa3-a63c-2fd5226659ba | €49.00 | €0.67 | matched |
| 5 | capture | 01a19c33-ff1a-7d1c-94aa-05a7a1bd72f9 | €49.00 | €0.67 | matched |
| 6 | capture | 01a19c34-0c6e-7135-85ad-8d512cb57737 | €15.00 | €0.26 | matched |
| 7 | capture | 01a19c34-5ed8-7592-8ace-ba56f13a9ccb | €49.00 | €0.67 | matched |
| 8 | capture | 01a19c34-63c3-7b2c-9082-0e1a303ba556 | €9.00 | €0.19 | matched |
| 9 | capture | 01a19c34-77da-7f7d-a64d-293be392199d | €35.00 | €0.50 | matched |
| 10 | capture | 01a19c34-ae2c-73ca-a06e-1a5b5312dc0b | €24.00 | €0.37 | matched |
| 11 | capture | 01a19c34-b8ef-759d-b1ab-b81fdb0c0c47 | €49.00 | €0.67 | matched |
| 12 | capture | 01a19c34-c045-7d4c-bc5f-7b05e3a8c232 | €15.00 | €0.26 | matched |
| 13 | capture | 01a19c34-d349-747d-aa67-26b4f86790fc | €49.00 | €0.67 | matched |
| 15 | capture | 01a19c34-fd2b-7151-aaef-fa96288fd4f2 | €15.00 | €0.26 | matched |
| 16 | capture | 01a19c35-022c-7453-97e5-f1679b53f9d6 | €9.00 | €0.19 | matched |
| 17 | capture | 01a19c35-182f-776d-97f3-7a6db0e79d5c | €9.00 | €0.19 | matched |
| 18 | capture | 01a19c35-38ea-7611-832d-5fd0e968e9b8 | €35.00 | €0.50 | matched |
| 19 | capture | 01a19c35-4b24-7a36-8a9a-050c58b87ee7 | €15.00 | €0.26 | matched |
| 20 | capture | 01a19c35-604a-7703-a01f-052352d1e06a | €9.00 | €0.19 | matched |
| 21 | capture | 01a19c35-5f04-74fa-9a38-0009382e7f10 | €9.00 | €0.19 | matched |
| 22 | capture | 01a19c35-7303-7eeb-ba8a-393168c919c1 | €15.00 | €0.26 | matched |
| 23 | refund | 01a19c35-73be-7d23-8677-cf68645bdf06 | -€27.00 | €0.00 | matched |
| 24 | capture | 01a19c35-7713-7e2e-8ebe-9339f9e700e4 | €9.00 | €0.19 | matched |
| 25 | capture | 01a19c35-8796-7879-8c78-1f7b843d19cd | €15.00 | €0.26 | matched |
| 26 | capture | 01a19c35-8c4c-73ee-b258-433a422a19bb | €35.00 | €0.50 | matched |
| 27 | capture | 01a19c35-b7ed-7f00-9aaf-17b4adf349d0 | €49.00 | €0.67 | matched |
| 28 | refund | 01a19c35-c110-7eeb-92d8-32e1ca1af58d | -€23.00 | €0.00 | matched |
| 29 | capture | 01a19c35-c409-73f3-86a1-a2f08380e1ed | €49.00 | €0.67 | matched |
| 30 | capture | 01a19c35-c6ea-77f0-8de3-239c9f20ae6d | €49.00 | €0.67 | matched |
| 32 | refund | 01a19c35-fecb-7865-abdd-db4fc32ea08e | -€40.00 | €0.00 | matched |
| 33 | capture | 01a19c36-01c1-74dc-ba3e-e0d1421fe376 | €24.00 | €0.37 | matched |
| 34 | capture | 01a19c36-0f44-7238-8524-3e164333a2df | €49.00 | €0.67 | matched |
| 35 | capture | 01a19c36-23d3-7cff-b983-cfef420b1f4c | €35.00 | €0.50 | matched |
| 36 | capture | 01a19c36-2936-7a4f-aec8-6ed19e245987 | €49.00 | €0.67 | matched |
| 37 | capture | 01a19c36-2c26-7857-86d5-5f314a258bbf | €35.00 | €0.50 | matched |
| 38 | capture | 01a19c36-55e3-71f4-8d00-5586e1cb09da | €9.00 | €0.19 | matched |
| 39 | capture | 01a19c36-6809-7f05-af2c-714e87442f46 | €35.00 | €0.50 | matched |
| 40 | capture | 01a19c36-7e29-7fab-9f24-e5be6645eedb | €35.00 | €0.50 | matched |
| 41 | capture | 01a19c36-7ee8-7526-a808-883fed5f962e | €24.00 | €0.37 | matched |
| 42 | capture | 01a19c36-a9c9-747d-a7da-49c93acb2e80 | €35.00 | €0.50 | matched |
| 43 | capture | 01a19c36-9e65-7758-a069-2cafc7814872 | €24.00 | €0.37 | matched |
| 44 | refund | 01a19c36-c62b-7980-aa2c-c9df5f8ef86a | -€13.00 | €0.00 | matched |
| 45 | capture | 01a19c36-cdd1-7a73-8b8f-4dbf0586a392 | €9.00 | €0.19 | matched |
| 46 | capture | 01a19c36-d5cf-7155-9d4a-df0f70703817 | €35.00 | €0.50 | matched |
| 47 | capture | 01a19c36-e465-7616-b9d4-835bd9b08a7a | €9.00 | €0.19 | matched |
| 48 | capture | 01a19c36-f4d6-7f7a-bfe6-f9ee3b210b1f | €24.00 | €0.37 | matched |
| 49 | capture | 01a19c37-2803-7523-8edf-f628657cf8f8 | €15.00 | €0.26 | matched |
| 50 | capture | 01a19c37-43b2-7eed-a0fe-532d9af0d0e1 | €9.00 | €0.19 | matched |
| 51 | capture | 01a19c37-51ab-73e8-85c9-6eade0facfc0 | €24.00 | €0.37 | matched |
| 52 | capture | 01a19c37-52e9-7602-8b17-247c0e860e13 | €49.00 | €0.67 | matched |
| 53 | capture | 01a19c37-5e6b-79b1-b87d-dd2fef47c605 | €24.00 | €0.37 | matched |
| 54 | capture | 01a19c37-77d1-7bb8-b063-1dbf34a179c6 | €24.00 | €0.37 | matched |
| 55 | capture | 01a19c37-85a4-7dae-b200-426a34525b0e | €49.00 | €0.67 | matched |
| 56 | refund | 01a19c37-901d-7d35-9f9d-54e24fa7e360 | -€16.00 | €0.00 | matched |
| 57 | capture | 01a19c37-905d-7d02-8830-62caa67072dd | €9.00 | €0.19 | matched |
| 58 | capture | 01a19c37-a9a4-7347-8220-844e423a1496 | €35.00 | €0.50 | matched |
| 59 | capture | 01a19c37-b5d3-78aa-8d28-e664ac6df30b | €15.00 | €0.26 | matched |
| 60 | capture | 01a19c37-df47-73c5-a706-19d1e2278be5 | €49.00 | €0.67 | matched |
| 61 | capture | 01a19c37-e990-78e6-a01d-7491fbdbdbf0 | €9.00 | €0.19 | matched |
| 62 | capture | 01a19c37-ee7f-744c-9253-471806808869 | €15.00 | €0.26 | matched |
| 63 | capture | 01a19c37-f3ff-7ea5-9889-1dcb32b22b5c | €15.00 | €0.26 | matched |
| 64 | capture | 01a19c37-f5cb-707b-b6d6-7b408cb1cb7f | €35.00 | €0.50 | matched |
| 65 | refund | 01a19c38-12ad-701a-bf3a-d5bac647e000 | -€8.00 | €0.00 | matched |
| 66 | capture | 01a19c38-21e4-72ba-ba53-96ec670b24af | €24.00 | €0.37 | matched |
| 67 | capture | 01a19c38-3d1d-7f29-b1eb-f29c7d917cc9 | €49.00 | €0.67 | matched |
| 68 | capture | 01a19c38-73b3-7810-ba0c-50835ac1f9df | €15.00 | €0.26 | matched |
| 69 | capture | 01a19c38-7b11-71fc-94f1-42ef08d3666a | €35.00 | €0.50 | matched |
| 70 | capture | 01a19c38-aa51-793e-98ad-7e278f7fa0f1 | €35.00 | €0.50 | matched |
| 71 | capture | 01a19c38-b2ba-7061-878a-9f767b89987f | €35.00 | €0.50 | matched |
| 72 | capture | 01a19c38-ba44-757b-bcac-b44fb5c0533c | €9.00 | €0.19 | matched |
| 73 | capture | 01a19c38-eb76-739c-ba0b-5faf67d2dede | €24.00 | €0.37 | matched |
| 74 | capture | 01a19c38-edc7-7bfa-9773-30c881d97842 | €9.00 | €0.19 | matched |
| 75 | capture | 01a19c39-1c22-707b-be03-27d1aa39fbd0 | €49.00 | €0.67 | matched |
| 76 | capture | 01a19c39-1c53-7d42-81ac-26a0ae003068 | €49.00 | €0.67 | matched |
| 77 | capture | 01a19c39-2587-763d-bf17-debe70d1b357 | €9.00 | €0.19 | matched |
| 78 | capture | 01a19c39-259d-7381-987a-bb5689043a61 | €49.00 | €0.67 | matched |
| 80 | capture | 01a19c39-3730-7abd-afe4-c40a24ad9881 | €49.00 | €0.67 | matched |
| 81 | capture | 01a19c39-3d69-7903-b86b-19a4981bb67d | €35.00 | €0.50 | matched |
| 82 | capture | 01a19c39-562c-7890-908c-e4727a068e0b | €49.00 | €0.67 | matched |
| 83 | capture | 01a19c39-5873-77d4-9967-62229c8e619f | €49.00 | €0.67 | matched |
| 84 | capture | 01a19c39-5e07-741a-84ea-f575c27632bc | €24.00 | €0.37 | matched |
| 85 | capture | 01a19c39-67a4-7ee9-b564-e68a30a6b148 | €35.00 | €0.50 | matched |
| 86 | capture | 01a19c39-9ff0-7a3c-8e81-66c56c8be62e | €15.00 | €0.26 | matched |
| 87 | capture | 01a19c39-adce-7bec-868a-d53f29404923 | €49.00 | €0.67 | matched |
| 88 | capture | 01a19c39-ce77-7358-94bb-7227e1bfe86b | €24.00 | €0.37 | matched |
| 89 | capture | 01a19c39-e1c7-71a3-9f48-7c888ec15606 | €35.00 | €0.50 | matched |
| 90 | capture | 01a19c39-e3e4-7476-a729-7b148a70ee20 | €15.00 | €0.26 | matched |
| 91 | capture | 01a19c39-e3e3-70ed-b545-5540e7ae10e6 | €49.00 | €0.67 | matched |
| 92 | capture | 01a19c39-e47e-778e-b190-c79ad1b8bfdc | €15.00 | €0.26 | matched |
| 93 | capture | 01a19c39-e749-726b-ac50-1f24c10d3269 | €9.00 | €0.19 | matched |
| 94 | capture | 01a19c3a-0a21-7a75-83c8-cbeea68bd992 | €9.00 | €0.19 | matched |
| 95 | capture | 01a19c3a-0a69-736c-a788-87223fed8c7f | €35.00 | €0.50 | matched |
| 96 | capture | 01a19c3a-1151-7890-9140-18f24dcd91b4 | €9.00 | €0.19 | matched |
| 97 | capture | 01a19c3a-117e-73db-8845-ef7157fc8482 | €24.00 | €0.37 | matched |
| 98 | capture | 01a19c3a-130c-7791-885b-98936a64f0e5 | €49.00 | €0.67 | matched |
| 99 | capture | 01a19c3a-17ef-7839-9787-75077457f3c7 | €9.00 | €0.19 | matched |
| 100 | refund | 01a19c3a-1b6d-7259-a960-17530c9dd2c4 | -€11.00 | €0.00 | matched |
| 101 | capture | 01a19c3a-66e2-72ba-b96c-a1b3ce08dfb2 | €9.00 | €0.19 | matched |
| 102 | capture | 01a19c3a-9b72-79b9-a175-1c6ddca37053 | €35.00 | €0.50 | matched |
| 103 | capture | 01a19c3a-c655-7151-a394-3e092569161f | €9.00 | €0.19 | matched |
| 104 | capture | 01a19c3a-d711-709b-a341-b1607eda2fcd | €24.00 | €0.37 | matched |
| 105 | refund | 01a19c3a-e129-7b70-a149-d48e6e9b244e | -€8.00 | €0.00 | matched |
| 106 | capture | 01a19c3a-e5fb-7a75-a4ef-8bcb70e5afea | €35.00 | €0.50 | matched |
| 107 | capture | 01a19c3a-e9f1-7c9b-9b72-09bb4f1e94a1 | €49.00 | €0.67 | matched |
| 108 | capture | 01a19c3a-ef41-7a50-8a28-b349d008af4b | €15.00 | €0.26 | matched |
| 109 | capture | 01a19c3b-0401-71e2-9ae2-d7199e7281bd | €24.00 | €0.37 | matched |
| 110 | capture | 01a19c3b-05e8-7953-8032-5c84561b6bed | €15.00 | €0.26 | matched |
| 111 | capture | 01a19c3b-306b-798a-8b7b-f461a96869db | €15.00 | €0.26 | matched |
| 112 | capture | 01a19c3b-341c-709b-a888-d3192f33a023 | €15.00 | €0.26 | matched |
| 113 | capture | 01a19c3b-4310-7a30-870a-0d5253983e81 | €9.00 | €0.19 | matched |
| 114 | capture | 01a19c3b-53b3-7998-b429-bc509c28aa59 | €49.00 | €0.67 | matched |
| 115 | capture | 01a19c3b-6599-7691-bfca-f4c20374fefb | €49.00 | €0.67 | matched |
| 116 | capture | 01a19c3b-6f48-7c5d-9e4c-f1fe4bdd4159 | €24.00 | €0.37 | matched |
| 117 | capture | 01a19c3b-77c4-7d89-9701-5dc814c65cb0 | €35.00 | €0.50 | matched |
| 118 | capture | 01a19c3b-9ab9-78a8-b054-7222e61bcf67 | €24.00 | €0.37 | matched |
| 119 | capture | 01a19c3b-a5c0-763c-99df-b37b53bf43e0 | €24.00 | €0.37 | matched |
| 120 | capture | 01a19c3b-b0a8-7501-9ef6-2b01b7d654e8 | €15.00 | €0.26 | matched |
| 121 | capture | 01a19c3b-b3a0-779d-9044-6e134832d4cc | €9.00 | €0.19 | matched |
| 122 | capture | 01a19c3b-ed37-738c-b386-c4dc7b5c4b0a | €35.00 | €0.50 | matched |
| 123 | capture | 01a19c3b-f37a-7f0c-953e-9ca7691a2066 | €9.00 | €0.19 | matched |
| 124 | capture | 01a19c3c-0d78-7a7e-836e-8b56ee478da4 | €24.00 | €0.37 | matched |
| 125 | capture | 01a19c3c-4283-7179-b344-f4b83256f921 | €49.00 | €0.67 | matched |
| 126 | capture | 01a19c3c-447c-7260-a894-d427222e2f66 | €15.00 | €0.26 | matched |
| 127 | refund | 01a19c3c-46d1-7ff4-928d-df4d81cc1c47 | -€3.00 | €0.00 | matched |
| 128 | refund | 01a19c3c-53e7-7e5d-a8ec-e2a87a59e08d | -€9.00 | €0.00 | matched |
| 129 | capture | 01a19c3c-59a1-745c-a257-649625257007 | €15.00 | €0.26 | matched |
| 130 | capture | 01a19c3c-5f23-7fe9-840a-b29561901237 | €35.00 | €0.50 | matched |
| 131 | capture | 01a19c3c-6e19-7137-b8ba-1d137217162e | €35.00 | €0.50 | matched |
| 132 | capture | 01a19c3c-8baa-711e-8074-06fd704e61dc | €49.00 | €0.67 | matched |
| 133 | capture | 01a19c3c-8c2e-7783-b674-56fcec2adbd2 | €24.00 | €0.37 | matched |
| 134 | capture | 01a19c3c-aa78-7872-b3e0-b53353e38703 | €24.00 | €0.37 | matched |
| 135 | refund | 01a19c3c-c5d9-714a-abb2-c27f02b1215c | -€36.00 | €0.00 | matched |
| 136 | capture | 01a19c3c-c6d0-75f7-af3f-d61dc0e599ae | €9.00 | €0.19 | matched |
| 137 | capture | 01a19c3c-d6e4-7c04-9e91-24b9ce640551 | €15.00 | €0.26 | matched |