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
- 17 Oct, 02:30137 lines2 breaks
- 17 Oct, 02:20140 lines1 break
- 17 Oct, 02:10130 lines3 breaks
- 17 Oct, 02:00101 lines1 break
- 17 Oct, 01:5093 lines2 breaks
- 17 Oct, 01:40122 linesclean
- 17 Oct, 01:30131 lines2 breaks
- 17 Oct, 01:20130 lines3 breaks
- 17 Oct, 01:10116 lines4 breaks
- 17 Oct, 01:00130 lines3 breaks
- 17 Oct, 00:50130 lines4 breaks
- 17 Oct, 00:40138 lines4 breaks
- 17 Oct, 00:30131 linesclean
- 17 Oct, 00:20147 lines5 breaks
17 Oct, 01:00
Gross
€3,021.00
PSP fee
€47.73
Net to the bank
€2,973.27
Settlement journal
#42645
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14765-b275-74e9-9ff0-4ae38649a1f3 is already settled by stl_EUR_2986998 line 95
- missing linein the books, not in the filerefund:01a14760-68c4-736f-8336-a4d38a5585ae is in no file
- missing linein the books, not in the filecapture:01a14762-9c55-72a2-8ba7-f41dedbbf4b3 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 96 | capture | 01a14765-b2e3-7e01-8907-0a6558f6e514 | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a1475d-acd9-7c69-ac8c-32e4da8d86a3 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1475f-49a7-749a-9b92-4e0ea6e85402 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1475f-7c82-7f83-86c1-29196a15201d | €24.00 | €0.37 | matched |
| 4 | capture | 01a1475f-9314-7d3d-a243-0e4d8694a22f | €35.00 | €0.50 | matched |
| 5 | capture | 01a1475f-9371-7d05-bb36-d17abeb91928 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1475f-b15d-7a91-b64a-0c32955e3fda | €35.00 | €0.50 | matched |
| 7 | capture | 01a1475f-bce9-79f6-ac39-2af1889a66b1 | €9.00 | €0.19 | matched |
| 8 | capture | 01a14760-0591-7728-875d-10b28839f4cb | €35.00 | €0.50 | matched |
| 9 | capture | 01a14760-06b2-7b9c-a627-4810b64a126e | €49.00 | €0.67 | matched |
| 10 | capture | 01a14760-0a9d-7925-81dd-00ae233c8ef3 | €35.00 | €0.50 | matched |
| 11 | capture | 01a14760-1643-7c35-8856-1ef734f0e023 | €9.00 | €0.19 | matched |
| 12 | capture | 01a14760-1d12-7c55-94f7-5c486b543f93 | €49.00 | €0.67 | matched |
| 13 | capture | 01a14760-2a77-7835-81d9-81db1f69ac64 | €35.00 | €0.50 | matched |
| 14 | capture | 01a14760-3740-7f05-857f-a05d9987c67b | €9.00 | €0.19 | matched |
| 15 | refund | 01a14760-5c51-75e0-8371-77595446bfb2 | -€29.00 | €0.00 | matched |
| 16 | capture | 01a14760-7215-79b4-814f-4c29d170e761 | €49.00 | €0.67 | matched |
| 17 | capture | 01a14760-780c-7e0f-94d2-ec9a49057146 | €49.00 | €0.67 | matched |
| 18 | capture | 01a14760-89db-7149-8cfc-00d21621ceec | €35.00 | €0.50 | matched |
| 19 | capture | 01a14760-9c03-7e42-bf80-6c4da530c146 | €35.00 | €0.50 | matched |
| 20 | capture | 01a14760-a36a-78cd-bc15-cb9073931426 | €35.00 | €0.50 | matched |
| 21 | capture | 01a14760-b43b-714f-afc0-8ac1beae0201 | €49.00 | €0.67 | matched |
| 22 | refund | 01a14760-cd93-7d1d-85f7-effbb30fdfc2 | -€13.00 | €0.00 | matched |
| 23 | capture | 01a14760-e91c-75af-bc58-240672d2d2cd | €49.00 | €0.67 | matched |
| 24 | capture | 01a14761-0776-78a7-8ce0-64212105ad04 | €24.00 | €0.37 | matched |
| 25 | capture | 01a14761-212d-7b8d-9980-1066b8665627 | €9.00 | €0.19 | matched |
| 26 | capture | 01a14761-27bd-7f10-8b0f-1684e963d7e1 | €15.00 | €0.26 | matched |
| 27 | capture | 01a14761-4058-7520-8363-143330610d6d | €35.00 | €0.50 | matched |
| 28 | capture | 01a14761-4e96-7db4-a750-a112281c59cf | €35.00 | €0.50 | matched |
| 29 | capture | 01a14761-5760-739f-a0d9-79bdb4898d65 | €9.00 | €0.19 | matched |
| 30 | capture | 01a14761-58a1-7d7a-9eb7-1532c55d1296 | €49.00 | €0.67 | matched |
| 31 | capture | 01a14761-5e73-7c50-a202-f204de26ad16 | €24.00 | €0.37 | matched |
| 32 | capture | 01a14761-6891-7d21-a750-b68503057199 | €15.00 | €0.26 | matched |
| 33 | capture | 01a14761-785c-7e3c-9a88-0bd0f1e711ab | €24.00 | €0.37 | matched |
| 34 | refund | 01a14761-9711-7a6d-90b0-c9388da4406b | -€11.00 | €0.00 | matched |
| 35 | capture | 01a14761-971d-76a4-b3d9-07ec2e0f9587 | €35.00 | €0.50 | matched |
| 36 | capture | 01a14761-9b72-77f7-a740-fa32c46ec566 | €24.00 | €0.37 | matched |
| 37 | capture | 01a14761-9f92-704b-87ad-4fcc93cc6c52 | €9.00 | €0.19 | matched |
| 38 | capture | 01a14761-a5dc-785f-aad5-9214bd0b05b3 | €35.00 | €0.50 | matched |
| 39 | capture | 01a14761-c1df-777b-b865-c0d7344f6be9 | €49.00 | €0.67 | matched |
| 40 | capture | 01a14762-161f-7430-bd2e-20eea2008a4b | €24.00 | €0.37 | matched |
| 41 | capture | 01a14762-22e9-7ce9-be18-eeabf38fa27b | €35.00 | €0.50 | matched |
| 42 | capture | 01a14762-36ad-7ff5-8fa0-f0c2e95f6ea5 | €9.00 | €0.19 | matched |
| 43 | capture | 01a14762-4ac0-789a-af3e-6c5bf785a588 | €24.00 | €0.37 | matched |
| 44 | capture | 01a14762-5a7a-7459-bcfe-545cf2da3da9 | €15.00 | €0.26 | matched |
| 45 | refund | 01a14762-6017-78a1-9e9c-b15d12268d38 | -€14.00 | €0.00 | matched |
| 46 | capture | 01a14762-8f2a-7955-8f79-1b5dc9c34b27 | €9.00 | €0.19 | matched |
| 47 | refund | 01a14762-9067-71a8-95b6-75e337c027a7 | -€8.00 | €0.00 | matched |
| 48 | capture | 01a14762-9fa1-7d33-b27c-19c9e72b730e | €9.00 | €0.19 | matched |
| 49 | capture | 01a14762-aa01-76f5-93ac-d4973f24f4fe | €9.00 | €0.19 | matched |
| 50 | capture | 01a14762-ca1e-72df-b96c-db4cdd6a3295 | €49.00 | €0.67 | matched |
| 51 | capture | 01a14762-cf70-76d2-b336-f9af210f1d7d | €35.00 | €0.50 | matched |
| 52 | capture | 01a14763-00d0-7eeb-b61a-06644ba6e855 | €15.00 | €0.26 | matched |
| 53 | capture | 01a14763-1903-7b01-a4e9-4c0a06c7572a | €24.00 | €0.37 | matched |
| 54 | capture | 01a14763-1e3a-7923-b68f-3857609db6fd | €49.00 | €0.67 | matched |
| 55 | capture | 01a14763-58bc-7cce-b335-9678e3adb519 | €24.00 | €0.37 | matched |
| 56 | capture | 01a14763-6245-7010-9088-b1197160c94a | €15.00 | €0.26 | matched |
| 57 | capture | 01a14763-7015-768e-aeec-efc3e8f507da | €15.00 | €0.26 | matched |
| 58 | capture | 01a14763-7d6e-7cd4-9b4b-d50ccf742379 | €49.00 | €0.67 | matched |
| 59 | capture | 01a14763-7f89-74ce-8cb7-2fbe4d95be1b | €49.00 | €0.67 | matched |
| 60 | capture | 01a14763-7f1c-7663-a56a-e6e55049d775 | €49.00 | €0.67 | matched |
| 61 | capture | 01a14763-a16f-7680-9866-f61f0540db61 | €35.00 | €0.50 | matched |
| 62 | capture | 01a14763-d89d-7b83-abb5-16580bc062f6 | €9.00 | €0.19 | matched |
| 63 | capture | 01a14763-dd9a-76d5-97b1-5929f3e540c3 | €9.00 | €0.19 | matched |
| 64 | capture | 01a14763-e5af-7f8a-b9a9-b5c5af8061cb | €9.00 | €0.19 | matched |
| 65 | capture | 01a14764-0599-7d80-bab3-74981273c051 | €35.00 | €0.50 | matched |
| 66 | capture | 01a14764-2837-7ec3-8240-e153d3940c01 | €24.00 | €0.37 | matched |
| 67 | capture | 01a14764-3308-7ea1-bd8e-1988db258bf2 | €9.00 | €0.19 | matched |
| 68 | capture | 01a14764-45ea-7cd3-8b44-58bcbcca7593 | €15.00 | €0.26 | matched |
| 69 | capture | 01a14764-5553-720b-8449-0195d80fb29f | €15.00 | €0.26 | matched |
| 70 | capture | 01a14764-7bbd-7062-89ee-363c378a7266 | €15.00 | €0.26 | matched |
| 71 | capture | 01a14764-8fb2-7da3-af76-e24616a048fd | €9.00 | €0.19 | matched |
| 72 | capture | 01a14764-a49e-7e2a-84ab-1d6295f55d05 | €35.00 | €0.50 | matched |
| 73 | capture | 01a14764-c2b6-780b-9332-fe385a532025 | €35.00 | €0.50 | matched |
| 74 | capture | 01a14764-c88b-7bbe-9a9c-9918d1b387f6 | €15.00 | €0.26 | matched |
| 75 | capture | 01a14764-cd00-79a3-957e-a6e5c6affbd8 | €15.00 | €0.26 | matched |
| 76 | capture | 01a14764-cee4-72b6-b4e0-d08bf59cd622 | €9.00 | €0.19 | matched |
| 77 | capture | 01a14764-cf09-71a2-b713-1f16964ad1a3 | €49.00 | €0.67 | matched |
| 78 | capture | 01a14764-d1bb-7073-ab8b-05a6c8d0889c | €9.00 | €0.19 | matched |
| 79 | capture | 01a14764-d092-7964-a93a-8dbf0368e6f5 | €49.00 | €0.67 | matched |
| 80 | capture | 01a14764-dedb-7ae5-bc0f-42f0f08b19d4 | €49.00 | €0.67 | matched |
| 81 | capture | 01a14765-06cf-7653-b3f8-211d7b447282 | €49.00 | €0.67 | matched |
| 82 | capture | 01a14765-0f43-74e0-9835-2a89417a8d44 | €35.00 | €0.50 | matched |
| 83 | capture | 01a14765-1410-7dad-ac1b-bf8b504b113e | €9.00 | €0.19 | matched |
| 84 | capture | 01a14765-260e-7bdc-b0fb-4f031cda7870 | €24.00 | €0.37 | matched |
| 85 | capture | 01a14765-3459-7842-87a0-ae440e7f5e7c | €35.00 | €0.50 | matched |
| 86 | capture | 01a14765-561e-77cc-b614-2c02130c2ccf | €15.00 | €0.26 | matched |
| 87 | capture | 01a14765-588f-7be7-a6fe-dd65471b9af0 | €9.00 | €0.19 | matched |
| 88 | capture | 01a14765-5e52-72c4-87a5-aae2d643ec0e | €49.00 | €0.67 | matched |
| 89 | capture | 01a14765-5f69-7d58-8bd1-40fb0ebf50f1 | €24.00 | €0.37 | matched |
| 90 | capture | 01a14765-8040-7c74-af05-7cfeb4efb8ec | €24.00 | €0.37 | matched |
| 91 | capture | 01a14765-8696-7036-b6b2-96e626234ee7 | €49.00 | €0.67 | matched |
| 92 | capture | 01a14765-8dd9-7409-a0b6-0cd0a317a098 | €15.00 | €0.26 | matched |
| 93 | capture | 01a14765-90d2-7999-9fc5-13147d347436 | €24.00 | €0.37 | matched |
| 94 | capture | 01a14765-99a5-7fc4-b727-834658e902f4 | €35.00 | €0.50 | matched |
| 95 | capture | 01a14765-b2e3-7e01-8907-0a6558f6e514 | €9.00 | €0.19 | matched |
| 97 | capture | 01a14765-b2ed-72f7-b5d6-79ac522224b1 | €24.00 | €0.37 | matched |
| 98 | capture | 01a14765-bd23-7013-b704-d5c3f351d512 | €9.00 | €0.19 | matched |
| 99 | refund | 01a14765-cb0b-7426-9704-217bcdbf08fd | -€9.00 | €0.00 | matched |
| 100 | capture | 01a14765-d62f-755a-a741-662cdfa39cca | €49.00 | €0.67 | matched |
| 101 | capture | 01a14765-eec4-79cf-bfbe-36e95843c4a3 | €24.00 | €0.37 | matched |
| 102 | capture | 01a14765-ff3e-779e-9b6d-13f90988f0de | €15.00 | €0.26 | matched |
| 103 | refund | 01a14766-0397-7f7a-b6b2-82cfb85c69db | -€40.00 | €0.00 | matched |
| 104 | capture | 01a14766-084e-7264-a979-a05526ade6ec | €24.00 | €0.37 | matched |
| 105 | capture | 01a14766-4698-7ea3-95ce-5b2f9f48c7c6 | €35.00 | €0.50 | matched |
| 106 | capture | 01a14766-5a22-7fcc-9211-7d71b47cf927 | €15.00 | €0.26 | matched |
| 107 | capture | 01a14766-7b3d-76e5-9e82-8e0f4e6bcb4c | €35.00 | €0.50 | matched |
| 108 | capture | 01a14766-7d80-72b0-abb5-db174b158447 | €15.00 | €0.26 | matched |
| 109 | capture | 01a14766-82fe-786f-acf6-5f42bd953c9f | €49.00 | €0.67 | matched |
| 110 | capture | 01a14766-9c2b-731f-a97b-0fbc560aa433 | €9.00 | €0.19 | matched |
| 111 | capture | 01a14766-9c67-77d3-99a4-178037668c47 | €49.00 | €0.67 | matched |
| 112 | capture | 01a14766-a8a9-7895-a929-b2960e0f4f93 | €15.00 | €0.26 | matched |
| 113 | capture | 01a14766-b203-760d-8c7f-1393edd85144 | €49.00 | €0.67 | matched |
| 114 | capture | 01a14766-bffb-7e68-852f-84e763be7330 | €15.00 | €0.26 | matched |
| 115 | capture | 01a14766-e6ff-7a95-80ee-018eeecfd032 | €49.00 | €0.67 | matched |
| 116 | capture | 01a14766-fb28-7e97-a2aa-54d66486df7f | €9.00 | €0.19 | matched |
| 117 | capture | 01a14767-20a1-718c-9df0-d5a41e331e46 | €15.00 | €0.26 | matched |
| 118 | capture | 01a14767-2c8f-7146-b8b5-82749155c762 | €15.00 | €0.26 | matched |
| 119 | capture | 01a14767-3b0a-7700-af99-31a71cceefd9 | €35.00 | €0.50 | matched |
| 120 | capture | 01a14767-69be-7c8e-ae0f-22fbbb029727 | €9.00 | €0.19 | matched |
| 121 | refund | 01a14767-7005-7880-946c-8878625a8c25 | -€7.00 | €0.00 | matched |
| 122 | capture | 01a14767-8680-71a1-abce-4669e08019a7 | €24.00 | €0.37 | matched |
| 123 | capture | 01a14767-cc6f-70ce-82c4-06d682f3f0c9 | €9.00 | €0.19 | matched |
| 124 | capture | 01a14767-d28c-7d0d-a5cc-a5917f49f122 | €15.00 | €0.26 | matched |
| 125 | capture | 01a14767-d63c-7cd7-a993-57e18ca2dcb3 | €15.00 | €0.26 | matched |
| 126 | capture | 01a14767-fe52-7f5a-98c9-ac2f53e6e25f | €15.00 | €0.26 | matched |
| 127 | capture | 01a14768-0016-7d13-8d48-b04264090585 | €9.00 | €0.19 | matched |
| 128 | capture | 01a14768-1f0f-7723-8f52-a86e5fb1f962 | €15.00 | €0.26 | matched |
| 129 | capture | 01a14768-3451-7e63-888f-fad74b101f49 | €24.00 | €0.37 | matched |
| 130 | capture | 01a14768-7d3e-75ce-95a2-eeafd252a674 | €9.00 | €0.19 | matched |