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
- 28 Oct, 17:50121 lines1 break
- 28 Oct, 17:40135 lines2 breaks
- 28 Oct, 17:30112 lines2 breaks
- 28 Oct, 17:20135 lines2 breaks
- 28 Oct, 17:10149 lines4 breaks
- 28 Oct, 17:00149 lines2 breaks
- 28 Oct, 16:50135 lines3 breaks
- 28 Oct, 16:40111 lines3 breaks
- 28 Oct, 16:30148 lines1 break
- 28 Oct, 16:20114 lines2 breaks
- 28 Oct, 16:10106 lines3 breaks
- 28 Oct, 16:00130 lines3 breaks
- 28 Oct, 15:50136 lines4 breaks
- 28 Oct, 15:40134 lines2 breaks
28 Oct, 17:00
Gross
€3,522.00
PSP fee
€55.72
Net to the bank
€3,466.28
Settlement journal
#254628
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18378-046a-7f4c-a7ea-7914778d3039 is already settled by stl_EUR_2988678 line 52
- missing linein the books, not in the filecapture:01a18378-c4ab-7171-82cd-e189f8fd1dc9 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 53 | capture | 01a18378-04cf-747b-883e-19d81c02f94f | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1836b-8844-7eb7-9790-297085c67b4a | €35.00 | €0.50 | matched |
| 2 | capture | 01a1836e-fe1a-74ec-9c89-c12f6f2ff6e2 | €49.00 | €0.67 | matched |
| 3 | capture | 01a18374-52b8-73eb-8f2f-6bda106e89d8 | €24.00 | €0.37 | matched |
| 4 | capture | 01a18374-686e-715b-b90c-76a8e2de7d63 | €24.00 | €0.37 | matched |
| 5 | capture | 01a18374-9d37-75be-ac69-1c6d26b0bc88 | €9.00 | €0.19 | matched |
| 6 | capture | 01a18374-9fb7-7aa3-b32b-b04c15acd6f7 | €15.00 | €0.26 | matched |
| 7 | capture | 01a18374-b879-7cf8-8b26-b933cc0e010f | €49.00 | €0.67 | matched |
| 8 | capture | 01a18374-b978-7b9c-8afd-38a85ca4deaa | €9.00 | €0.19 | matched |
| 9 | capture | 01a18374-c89f-774b-a8ba-fe1c386e72cb | €9.00 | €0.19 | matched |
| 10 | capture | 01a18374-d420-78d1-bc31-c3cef2431801 | €35.00 | €0.50 | matched |
| 11 | capture | 01a18374-d662-713c-99f7-6641f4f5bc9a | €24.00 | €0.37 | matched |
| 12 | capture | 01a18374-e708-7c40-b54f-981c9952edf1 | €24.00 | €0.37 | matched |
| 13 | capture | 01a18374-f2fb-7e40-b6b6-e1d2f2418ba6 | €24.00 | €0.37 | matched |
| 14 | capture | 01a18374-f57d-7d97-8e6f-00cce5a1d36d | €24.00 | €0.37 | matched |
| 15 | capture | 01a18375-07a6-7c53-a9ce-39b982157551 | €35.00 | €0.50 | matched |
| 16 | capture | 01a18375-4376-7793-b586-e9210a946fb9 | €35.00 | €0.50 | matched |
| 17 | capture | 01a18375-4ecf-755f-b6af-323b1f137be5 | €49.00 | €0.67 | matched |
| 18 | capture | 01a18375-5ab5-79ed-a6a9-077d0b2e28b6 | €9.00 | €0.19 | matched |
| 19 | capture | 01a18375-6353-7646-8297-702d4df48ca7 | €35.00 | €0.50 | matched |
| 20 | capture | 01a18375-6f6a-7a15-b239-b55c249288b0 | €15.00 | €0.26 | matched |
| 21 | capture | 01a18375-7253-7d5f-b91f-6907a514113a | €9.00 | €0.19 | matched |
| 22 | capture | 01a18375-7978-714d-affb-80be87353223 | €15.00 | €0.26 | matched |
| 23 | capture | 01a18375-89e6-7922-b31f-9f0de5a2b0d7 | €15.00 | €0.26 | matched |
| 24 | refund | 01a18375-94da-73ad-85a0-ea5d8ba42df3 | -€3.00 | €0.00 | matched |
| 25 | capture | 01a18375-9922-7585-9444-48978f5d2a9a | €24.00 | €0.37 | matched |
| 26 | refund | 01a18375-d744-78d3-8bcc-bdce2f1c2cd0 | -€8.00 | €0.00 | matched |
| 27 | capture | 01a18375-f6ad-7643-a4ec-9ea4116b2d78 | €9.00 | €0.19 | matched |
| 28 | capture | 01a18375-fecf-7feb-bc0c-9c3749402759 | €9.00 | €0.19 | matched |
| 29 | capture | 01a18376-0b3a-73c9-bab4-39df3890eb51 | €24.00 | €0.37 | matched |
| 30 | capture | 01a18376-1571-7036-998b-e8731c685ed8 | €49.00 | €0.67 | matched |
| 31 | capture | 01a18376-1fbc-7ddb-ad8a-95f2c738e798 | €15.00 | €0.26 | matched |
| 32 | capture | 01a18376-2c0d-7978-8e24-2cfa3e78f487 | €35.00 | €0.50 | matched |
| 33 | capture | 01a18376-3523-721b-b81f-7704fe7b1857 | €15.00 | €0.26 | matched |
| 34 | capture | 01a18376-4e36-7bbe-b659-c336a67e15ee | €9.00 | €0.19 | matched |
| 35 | refund | 01a18376-7e6b-7693-93f1-6545ea4a963c | -€11.00 | €0.00 | matched |
| 36 | capture | 01a18376-d55e-77e4-a15a-59d6fe1e0262 | €24.00 | €0.37 | matched |
| 37 | capture | 01a18376-de95-7997-86e1-8246717145ca | €24.00 | €0.37 | matched |
| 38 | capture | 01a18376-f527-72b9-a1e3-e0ca527d7f63 | €49.00 | €0.67 | matched |
| 39 | capture | 01a18377-333e-7624-bdda-0ac09bfa126c | €15.00 | €0.26 | matched |
| 40 | capture | 01a18377-39a0-7d6a-9917-40b6ee0c25d2 | €15.00 | €0.26 | matched |
| 41 | capture | 01a18377-446a-7338-a9a7-613a619e7cff | €35.00 | €0.50 | matched |
| 42 | capture | 01a18377-5043-7c2a-b0e9-123f317c3910 | €35.00 | €0.50 | matched |
| 43 | capture | 01a18377-77b9-72da-8b67-c32acf720a2b | €49.00 | €0.67 | matched |
| 44 | capture | 01a18377-7d15-7445-a40f-bd7478118572 | €15.00 | €0.26 | matched |
| 45 | capture | 01a18377-8bd7-7160-9ee9-208eac5c1e29 | €49.00 | €0.67 | matched |
| 46 | capture | 01a18377-b3d3-7894-ab23-09b329702fc1 | €35.00 | €0.50 | matched |
| 47 | capture | 01a18377-d25a-7834-a0df-323a7f005178 | €15.00 | €0.26 | matched |
| 48 | capture | 01a18377-ddee-7ed1-bcff-e77ce63f056d | €24.00 | €0.37 | matched |
| 49 | capture | 01a18377-e0b5-7182-9324-5ed57e38dd26 | €35.00 | €0.50 | matched |
| 50 | refund | 01a18377-eeac-7eb2-b142-f4e30d635041 | -€14.00 | €0.00 | matched |
| 51 | capture | 01a18377-f361-769d-b6ac-f56ab2a46ec8 | €9.00 | €0.19 | matched |
| 52 | capture | 01a18378-04cf-747b-883e-19d81c02f94f | €49.00 | €0.67 | matched |
| 54 | capture | 01a18378-262a-71bf-8cac-f6521e2c5797 | €35.00 | €0.50 | matched |
| 55 | capture | 01a18378-3e31-722a-918c-a5953e19552d | €35.00 | €0.50 | matched |
| 56 | capture | 01a18378-3e2c-7dbf-9d09-847a64b23e66 | €9.00 | €0.19 | matched |
| 57 | capture | 01a18378-4487-787f-80be-fe38f245f348 | €49.00 | €0.67 | matched |
| 58 | capture | 01a18378-5435-769f-aa09-8b5653816adc | €35.00 | €0.50 | matched |
| 59 | capture | 01a18378-585c-77a6-a93f-6d6f4519d69c | €49.00 | €0.67 | matched |
| 60 | capture | 01a18378-6dcc-758c-b9b5-ec9100b3843c | €49.00 | €0.67 | matched |
| 61 | capture | 01a18378-7a82-7d58-bd30-906c2e7fb0bc | €24.00 | €0.37 | matched |
| 62 | capture | 01a18378-8a3d-7e90-9b9a-925421221eb3 | €35.00 | €0.50 | matched |
| 63 | capture | 01a18378-9d04-7814-887b-46b8662b4973 | €24.00 | €0.37 | matched |
| 64 | capture | 01a18378-ab73-7059-bb4f-3590281d573f | €24.00 | €0.37 | matched |
| 65 | refund | 01a18378-bbe4-73e4-bb13-e3ce07f41310 | -€30.00 | €0.00 | matched |
| 66 | capture | 01a18378-b90f-7d58-a49d-617fedacbc8a | €24.00 | €0.37 | matched |
| 67 | capture | 01a18378-c065-7224-94fb-d909f56f11d8 | €35.00 | €0.50 | matched |
| 68 | capture | 01a18378-d89b-7254-b4c4-e1dac95a71d5 | €24.00 | €0.37 | matched |
| 69 | capture | 01a18378-d93e-79e3-bcf8-2a1de031a99c | €35.00 | €0.50 | matched |
| 70 | capture | 01a18378-e01e-7813-a9ab-5b6dff1b7bd2 | €35.00 | €0.50 | matched |
| 71 | refund | 01a18378-f758-7318-83d8-2a41e147775d | -€19.00 | €0.00 | matched |
| 72 | capture | 01a18378-f8db-7220-9eac-14effbab6d2e | €15.00 | €0.26 | matched |
| 73 | capture | 01a18379-06a1-73fd-abca-3d977201c9d9 | €35.00 | €0.50 | matched |
| 74 | capture | 01a18379-1aac-7bef-90ed-e2bc62fe1a20 | €49.00 | €0.67 | matched |
| 75 | capture | 01a18379-1b00-7d88-9e6b-e21ddb4b85ef | €35.00 | €0.50 | matched |
| 76 | capture | 01a18379-1f9b-7f54-b47e-39c42a59c3b9 | €9.00 | €0.19 | matched |
| 77 | capture | 01a18379-2b84-7238-bcfb-fbeec1fe38f9 | €15.00 | €0.26 | matched |
| 78 | capture | 01a18379-2dd6-708c-9e1f-6c113ac80319 | €24.00 | €0.37 | matched |
| 79 | capture | 01a18379-3d00-7598-8b08-1388b2848c6d | €49.00 | €0.67 | matched |
| 80 | capture | 01a18379-4a45-71fc-987d-86126ffaf6a6 | €9.00 | €0.19 | matched |
| 81 | capture | 01a18379-7f51-7103-ae79-07226dcadac6 | €35.00 | €0.50 | matched |
| 82 | capture | 01a18379-8331-7d24-92aa-fd29e96f4a2d | €49.00 | €0.67 | matched |
| 83 | capture | 01a18379-8645-7204-91de-e3800d8ed266 | €24.00 | €0.37 | matched |
| 84 | capture | 01a18379-8c46-7f28-a4c0-f8b0e4e4c2db | €15.00 | €0.26 | matched |
| 85 | capture | 01a18379-9417-7558-b578-1f0bb7a19f6e | €35.00 | €0.50 | matched |
| 86 | capture | 01a18379-9916-7f04-a2e5-d8364515aa7d | €9.00 | €0.19 | matched |
| 87 | capture | 01a18379-cfd0-785a-a7a4-c4b26b86dfbf | €35.00 | €0.50 | matched |
| 88 | capture | 01a18379-d1eb-71ab-9e4a-cb3ae2137c65 | €24.00 | €0.37 | matched |
| 89 | capture | 01a18379-e798-76a8-8582-182e269b37d9 | €35.00 | €0.50 | matched |
| 90 | capture | 01a18379-e7f0-7636-b262-86fe22d6a61a | €24.00 | €0.37 | matched |
| 91 | capture | 01a18379-e80c-7ea5-bd8b-3b2f05c0ea6c | €9.00 | €0.19 | matched |
| 92 | capture | 01a18379-f566-73e8-aced-6213bd842db5 | €35.00 | €0.50 | matched |
| 93 | capture | 01a18379-f913-7d93-b753-5c6012779dec | €35.00 | €0.50 | matched |
| 94 | capture | 01a1837a-07fb-7f65-9155-e47a0eafc11c | €49.00 | €0.67 | matched |
| 95 | capture | 01a1837a-0d55-7885-873d-b445fccf3d3b | €9.00 | €0.19 | matched |
| 96 | capture | 01a1837a-0f50-74ff-ad08-416e9994318d | €15.00 | €0.26 | matched |
| 97 | capture | 01a1837a-123c-76ed-b3d9-94fc32b383c6 | €49.00 | €0.67 | matched |
| 98 | capture | 01a1837a-2eca-70ad-9bf8-bcfb3a30996b | €15.00 | €0.26 | matched |
| 99 | capture | 01a1837a-31dd-796a-8d3b-69376bf4aa28 | €9.00 | €0.19 | matched |
| 100 | capture | 01a1837a-3d1c-7050-8b2a-ea041c7231c0 | €9.00 | €0.19 | matched |
| 101 | capture | 01a1837a-3f69-70e0-ab02-ecbd044e83f3 | €35.00 | €0.50 | matched |
| 102 | refund | 01a1837a-41a3-7335-ab30-e3e9987be8d4 | -€5.00 | €0.00 | matched |
| 103 | capture | 01a1837a-4eff-7d35-b6a2-53128283deea | €15.00 | €0.26 | matched |
| 104 | refund | 01a1837a-729c-78b0-b30f-8d13407061e3 | -€20.00 | €0.00 | matched |
| 105 | capture | 01a1837a-8684-7613-894c-179b442e70c0 | €49.00 | €0.67 | matched |
| 106 | capture | 01a1837a-8d92-78eb-b53b-6d07b959dcd9 | €24.00 | €0.37 | matched |
| 107 | capture | 01a1837a-9251-76c6-ae46-bf974131e9f8 | €49.00 | €0.67 | matched |
| 108 | capture | 01a1837a-9fdc-73e0-ab8b-a24e5e73c648 | €9.00 | €0.19 | matched |
| 109 | capture | 01a1837a-a2cc-7a25-80d7-7c1a02e4935d | €15.00 | €0.26 | matched |
| 110 | capture | 01a1837a-b1e4-73e3-93c3-2167aa67eb43 | €35.00 | €0.50 | matched |
| 111 | refund | 01a1837a-eb67-766a-919e-27e3a0036088 | -€36.00 | €0.00 | matched |
| 112 | capture | 01a1837a-ee94-7e9e-88db-19cb346b591c | €9.00 | €0.19 | matched |
| 113 | capture | 01a1837a-f5d5-7155-a903-338c1e292f09 | €49.00 | €0.67 | matched |
| 114 | capture | 01a1837a-f60a-7a56-983f-7dcd32dcbb00 | €15.00 | €0.26 | matched |
| 115 | capture | 01a1837b-1efa-771d-a946-e2c5e7e4e02e | €35.00 | €0.50 | matched |
| 116 | capture | 01a1837b-3116-7abf-8bab-0f63a63c4591 | €35.00 | €0.50 | matched |
| 117 | capture | 01a1837b-3ad9-78ca-bc23-46b0d4bb1040 | €9.00 | €0.19 | matched |
| 118 | capture | 01a1837b-73d6-76a5-82b2-7bd4f665af14 | €49.00 | €0.67 | matched |
| 119 | capture | 01a1837b-7780-728d-836f-e9ec6f46351b | €35.00 | €0.50 | matched |
| 120 | capture | 01a1837b-86dc-7646-b5ec-b1a2eb8bebd4 | €24.00 | €0.37 | matched |
| 121 | capture | 01a1837b-86b2-7110-adaa-f33b2451eaf9 | €24.00 | €0.37 | matched |
| 122 | capture | 01a1837b-8e22-756a-8a34-abaa5811a766 | €49.00 | €0.67 | matched |
| 123 | capture | 01a1837b-954c-7ab9-acdb-c30f934ba96a | €24.00 | €0.37 | matched |
| 124 | capture | 01a1837b-95e4-7ea2-9441-92e6df4c9e36 | €24.00 | €0.37 | matched |
| 125 | capture | 01a1837b-a576-7b72-9992-e9184cda3b41 | €9.00 | €0.19 | matched |
| 126 | capture | 01a1837b-ada0-7ef6-ac0b-37e12ceb44f5 | €24.00 | €0.37 | matched |
| 127 | capture | 01a1837b-ba7e-7134-921f-517eae42ab74 | €9.00 | €0.19 | matched |
| 128 | capture | 01a1837b-c2da-7d81-8962-efae3da149a5 | €49.00 | €0.67 | matched |
| 129 | refund | 01a1837b-c887-704c-bf74-c257b7b3d21a | -€22.00 | €0.00 | matched |
| 130 | capture | 01a1837b-dde4-7305-b2fe-01317be32909 | €24.00 | €0.37 | matched |
| 131 | capture | 01a1837b-f0a9-7e92-b400-a63ee4a07b1a | €35.00 | €0.50 | matched |
| 132 | capture | 01a1837b-f3a8-75b5-a630-c66d3951a894 | €49.00 | €0.67 | matched |
| 133 | capture | 01a1837b-f65d-77bf-acd1-f059b0ef3c09 | €49.00 | €0.67 | matched |
| 134 | capture | 01a1837b-fdb3-74b5-b37d-49fbd92b0abc | €9.00 | €0.19 | matched |
| 135 | capture | 01a1837c-311c-7817-b5f5-89f0283a94ef | €24.00 | €0.37 | matched |
| 136 | capture | 01a1837c-3c62-7ec8-8676-ee3df2797ac1 | €24.00 | €0.37 | matched |
| 137 | capture | 01a1837c-5fec-7994-a753-9ac4d7d2cad1 | €49.00 | €0.67 | matched |
| 138 | capture | 01a1837c-6a62-71aa-90b2-554e1aee8186 | €9.00 | €0.19 | matched |
| 139 | capture | 01a1837c-957d-7be7-b410-2d17ea6f5817 | €24.00 | €0.37 | matched |
| 140 | capture | 01a1837c-a239-7fc4-88d6-79f36b841657 | €24.00 | €0.37 | matched |
| 141 | capture | 01a1837c-b89a-7fd9-8027-cf752cdc5931 | €9.00 | €0.19 | matched |
| 142 | capture | 01a1837c-cb51-7430-a969-568ca12788c5 | €9.00 | €0.19 | matched |
| 143 | capture | 01a1837c-cdf1-789b-addf-267fed45c2ea | €15.00 | €0.26 | matched |
| 144 | capture | 01a1837c-e128-706f-9f57-ce5dce47eb2d | €15.00 | €0.26 | matched |
| 145 | capture | 01a1837c-e5a6-783a-8ded-0d6771d29feb | €15.00 | €0.26 | matched |
| 146 | capture | 01a1837c-f8a0-77a1-9b79-cbe24bcf5cf1 | €24.00 | €0.37 | matched |
| 147 | capture | 01a1837d-3653-738a-8214-4eff4218628f | €9.00 | €0.19 | matched |
| 148 | refund | 01a1837d-4b43-77b4-8f51-b33f003d819b | -€19.00 | €0.00 | matched |
| 149 | capture | 01a1837d-5895-77b2-b62c-1cf7d761993b | €24.00 | €0.37 | matched |