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
- 1 Nov, 08:30132 lines3 breaks
- 1 Nov, 08:20131 lines3 breaks
- 1 Nov, 08:10134 lines3 breaks
- 1 Nov, 08:00128 lines2 breaks
- 1 Nov, 07:50104 lines1 break
- 1 Nov, 07:40135 lines2 breaks
- 1 Nov, 07:30122 lines7 breaks
- 1 Nov, 07:20133 linesclean
- 1 Nov, 07:10134 lines4 breaks
- 1 Nov, 07:00108 lines2 breaks
- 1 Nov, 06:50121 lines4 breaks
- 1 Nov, 06:40126 lines4 breaks
- 1 Nov, 06:30120 lines3 breaks
- 1 Nov, 06:20118 lines1 break
1 Nov, 07:10
Gross
€3,095.00
PSP fee
€48.83
Net to the bank
€3,046.17
Settlement journal
#320487
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a195f5-6bd9-77b4-a8bc-92626c7eeccb is already settled by stl_EUR_2989195 line 69
- missing linein the books, not in the filerefund:01a195fa-a366-7d62-a493-6082582d4190 is in no file
- missing linein the books, not in the filerefund:01a195f8-0d6d-7738-bb30-b1c13c2ed04a is in no file
- missing linein the books, not in the filecapture:01a195f8-9a4a-7d6d-a944-8e0869497b6e is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 70 | capture | 01a195f5-7ce0-78f1-82df-c41ff443f173 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a195e8-ac28-7f78-afac-b31ef6955608 | €35.00 | €0.50 | matched |
| 2 | capture | 01a195e9-4288-7ce7-8aff-ca70e76268d1 | €24.00 | €0.37 | matched |
| 3 | capture | 01a195ec-8ec9-7d14-90d6-a688a7df75b4 | €15.00 | €0.26 | matched |
| 4 | capture | 01a195ee-5609-7503-81ba-042d8fe564ad | €49.00 | €0.67 | matched |
| 5 | refund | 01a195f1-952a-7897-a5cb-344f5f06349d | -€7.00 | €0.00 | matched |
| 6 | capture | 01a195f1-b0cf-7673-b494-4c6d36e44cec | €15.00 | €0.26 | matched |
| 7 | capture | 01a195f1-b236-7212-aaa2-f5063bacf23a | €9.00 | €0.19 | matched |
| 8 | capture | 01a195f1-b506-72b5-808d-28c09454459e | €9.00 | €0.19 | matched |
| 9 | capture | 01a195f1-b9e4-7d90-afbd-0a0ecb7973c3 | €15.00 | €0.26 | matched |
| 10 | capture | 01a195f1-c2bd-7942-b95d-c34dc7aa8a1b | €15.00 | €0.26 | matched |
| 11 | capture | 01a195f1-cb50-779f-807b-1bdd625ded19 | €15.00 | €0.26 | matched |
| 12 | capture | 01a195f1-d2a7-7899-87a1-61dbb8070291 | €35.00 | €0.50 | matched |
| 13 | capture | 01a195f1-fb18-7606-9632-e4a1f80247f8 | €9.00 | €0.19 | matched |
| 14 | capture | 01a195f2-358d-7e1a-a8f6-939785b628c0 | €15.00 | €0.26 | matched |
| 15 | capture | 01a195f2-38d4-7d9a-9999-3e289addd661 | €49.00 | €0.67 | matched |
| 16 | capture | 01a195f2-38e7-73ce-80c4-e38703098cbd | €24.00 | €0.37 | matched |
| 17 | capture | 01a195f2-75f4-7378-8399-62b255a9ef0c | €9.00 | €0.19 | matched |
| 18 | capture | 01a195f2-8da6-7728-9f88-4de24e9ddcf2 | €24.00 | €0.37 | matched |
| 19 | capture | 01a195f2-9576-724a-b34a-d0d0d1d54416 | €9.00 | €0.19 | matched |
| 20 | capture | 01a195f2-a618-7646-ba29-2cacd872aeb9 | €49.00 | €0.67 | matched |
| 21 | capture | 01a195f2-b864-7aa0-adcf-5770f2de48de | €49.00 | €0.67 | matched |
| 22 | capture | 01a195f2-be0c-7959-a888-4e42ad3deba7 | €35.00 | €0.50 | matched |
| 23 | capture | 01a195f2-d2de-765a-895e-02e72f4800ac | €15.00 | €0.26 | matched |
| 24 | refund | 01a195f3-06c3-7c03-a6f2-276a36cf8cfc | -€24.00 | €0.00 | matched |
| 25 | capture | 01a195f3-0eb5-7263-9342-e6f97c4461ce | €49.00 | €0.67 | matched |
| 26 | capture | 01a195f3-0df0-7789-9f5c-b279b13281ab | €24.00 | €0.37 | matched |
| 27 | capture | 01a195f3-15cd-7f15-8897-4467dc6db257 | €9.00 | €0.19 | matched |
| 28 | capture | 01a195f3-187b-739e-8dad-352c2911298d | €49.00 | €0.67 | matched |
| 29 | capture | 01a195f3-1abb-748b-b3df-4420af6d0db8 | €9.00 | €0.19 | matched |
| 30 | capture | 01a195f3-40f3-73e8-acd5-c5275d621aa1 | €35.00 | €0.50 | matched |
| 31 | capture | 01a195f3-4cce-7110-b655-fa3a00f0bfb4 | €15.00 | €0.26 | matched |
| 32 | capture | 01a195f3-56bc-7f17-86e5-205df77fd23b | €35.00 | €0.50 | matched |
| 33 | capture | 01a195f3-5a26-7dc5-b85f-c54d5ef949ef | €15.00 | €0.26 | matched |
| 34 | capture | 01a195f3-5c96-7f15-aecd-f9a061b26bcf | €15.00 | €0.26 | matched |
| 35 | capture | 01a195f3-7b40-7f2c-ae92-ae5eb4730df3 | €15.00 | €0.26 | matched |
| 36 | capture | 01a195f3-7bfc-7d9d-883e-5d966c2924ab | €35.00 | €0.50 | matched |
| 37 | capture | 01a195f3-7e28-7d1a-b579-ada1ddf36be1 | €15.00 | €0.26 | matched |
| 38 | capture | 01a195f3-7f84-7b54-9a8b-2d13e04d54f3 | €9.00 | €0.19 | matched |
| 39 | capture | 01a195f3-b9c4-753f-96a9-47c620abcf3d | €15.00 | €0.26 | matched |
| 40 | capture | 01a195f3-b95d-7d9e-8dc2-b4bcbf507c85 | €24.00 | €0.37 | matched |
| 41 | refund | 01a195f3-c4ad-7224-8943-6d172d574afa | -€4.00 | €0.00 | matched |
| 42 | capture | 01a195f3-efdb-7872-8e54-08684e0574c8 | €9.00 | €0.19 | matched |
| 43 | capture | 01a195f3-f8cd-7440-abdd-403e223ef4a2 | €24.00 | €0.37 | matched |
| 44 | capture | 01a195f4-0154-760c-902f-ed8921c94f08 | €15.00 | €0.26 | matched |
| 45 | capture | 01a195f4-0b6a-7a26-902e-366e8116d69e | €15.00 | €0.26 | matched |
| 46 | capture | 01a195f4-0cab-781d-abd3-bd8d22fd5dc5 | €49.00 | €0.67 | matched |
| 47 | capture | 01a195f4-1bb7-7197-807e-78cf869fb766 | €24.00 | €0.37 | matched |
| 48 | capture | 01a195f4-1f90-7642-ad16-4284827d3c0b | €9.00 | €0.19 | matched |
| 49 | capture | 01a195f4-35bb-7b32-bda2-4ddcb47a585c | €49.00 | €0.67 | matched |
| 50 | capture | 01a195f4-3860-7be7-b995-68d731cb3962 | €24.00 | €0.37 | matched |
| 51 | capture | 01a195f4-6d30-7130-b379-c6d83335252e | €9.00 | €0.19 | matched |
| 52 | capture | 01a195f4-6fa1-78f2-8ae5-40ed4ed27c68 | €9.00 | €0.19 | matched |
| 53 | capture | 01a195f4-72fb-7bf8-9ffc-b4929a3036dd | €35.00 | €0.50 | matched |
| 54 | capture | 01a195f4-7391-721e-8325-2e57e229b31c | €24.00 | €0.37 | matched |
| 55 | refund | 01a195f4-8cab-7a2d-b245-eab64d6c32ca | -€21.00 | €0.00 | matched |
| 56 | capture | 01a195f4-8936-7c0f-a030-b69f580a914d | €35.00 | €0.50 | matched |
| 57 | capture | 01a195f4-a37a-73f3-b1be-2c02a8445f2c | €35.00 | €0.50 | matched |
| 58 | capture | 01a195f4-cb4d-7ce3-b723-752c774bf9b6 | €35.00 | €0.50 | matched |
| 59 | capture | 01a195f4-cbbb-72f5-9fff-26cd5f70c002 | €49.00 | €0.67 | matched |
| 60 | capture | 01a195f4-e629-72f8-b001-b53b8a50628e | €49.00 | €0.67 | matched |
| 61 | capture | 01a195f4-ed3a-7597-83b4-199b4b797a4a | €49.00 | €0.67 | matched |
| 62 | capture | 01a195f4-f778-72ea-8075-028d4dfaba0a | €9.00 | €0.19 | matched |
| 63 | capture | 01a195f5-131a-7710-9f5b-b29dc8ccc220 | €9.00 | €0.19 | matched |
| 64 | capture | 01a195f5-4aa2-7f04-9a5e-b203a1632f58 | €49.00 | €0.67 | matched |
| 65 | capture | 01a195f5-59ea-7db3-a257-8ef11c59f74c | €24.00 | €0.37 | matched |
| 66 | capture | 01a195f5-6064-7da4-8fde-8a2db2f13fbc | €9.00 | €0.19 | matched |
| 67 | capture | 01a195f5-6fbe-7170-a8e7-d30aef01eaa4 | €15.00 | €0.26 | matched |
| 68 | refund | 01a195f5-743d-7e28-b7f1-ddc5aa165ee9 | -€5.00 | €0.00 | matched |
| 69 | capture | 01a195f5-7ce0-78f1-82df-c41ff443f173 | €35.00 | €0.50 | matched |
| 71 | capture | 01a195f5-83fc-7660-91e0-e869013c6994 | €24.00 | €0.37 | matched |
| 72 | capture | 01a195f5-b7f1-778c-93a1-7b8861d0d898 | €24.00 | €0.37 | matched |
| 73 | capture | 01a195f6-0c6a-7a64-87fc-d94f27f5ffdb | €15.00 | €0.26 | matched |
| 74 | capture | 01a195f6-20d0-7c45-ad57-689048c3d7ec | €15.00 | €0.26 | matched |
| 75 | capture | 01a195f6-54cc-7fc1-82b9-42886d5f9d12 | €24.00 | €0.37 | matched |
| 76 | capture | 01a195f6-7811-7083-a079-14df22516934 | €49.00 | €0.67 | matched |
| 77 | capture | 01a195f6-7e9a-765e-8c91-894ba8a9aa05 | €9.00 | €0.19 | matched |
| 78 | capture | 01a195f6-944b-7441-8c7d-f51d181880f6 | €9.00 | €0.19 | matched |
| 79 | capture | 01a195f6-a9b6-7ce2-b86f-15d701edb06a | €49.00 | €0.67 | matched |
| 80 | capture | 01a195f6-c271-7e8f-8b78-a8e1ac260026 | €24.00 | €0.37 | matched |
| 81 | capture | 01a195f6-c4a2-71cd-be2a-5cd1c9691002 | €49.00 | €0.67 | matched |
| 82 | capture | 01a195f6-c82c-73d4-84ee-ab7c3b85003e | €24.00 | €0.37 | matched |
| 83 | capture | 01a195f6-deb7-79a4-ac62-bf82c894e1fa | €9.00 | €0.19 | matched |
| 84 | refund | 01a195f6-eacf-725b-ab39-3b6f57423317 | -€15.00 | €0.00 | matched |
| 85 | capture | 01a195f7-2049-7cd3-a0a3-1109e069080a | €24.00 | €0.37 | matched |
| 86 | capture | 01a195f7-2345-7da6-9190-0e530b9f5c89 | €15.00 | €0.26 | matched |
| 87 | capture | 01a195f7-289f-76c3-b717-afcea7e8f907 | €35.00 | €0.50 | matched |
| 88 | capture | 01a195f7-3f25-7e0a-acbe-b4a3ec2938b7 | €24.00 | €0.37 | matched |
| 89 | capture | 01a195f7-6aa0-7049-9ac4-014ee1cfbfae | €24.00 | €0.37 | matched |
| 90 | capture | 01a195f7-7347-77b5-8b93-710014320bd1 | €24.00 | €0.37 | matched |
| 91 | capture | 01a195f7-80ae-771a-b68f-de943bf0821d | €35.00 | €0.50 | matched |
| 92 | capture | 01a195f7-8ee2-7a47-8286-5332b26a82d3 | €35.00 | €0.50 | matched |
| 93 | refund | 01a195f7-954b-7a28-8278-70f6c0017021 | -€19.00 | €0.00 | matched |
| 94 | capture | 01a195f7-d448-7f59-8eea-c798becac393 | €9.00 | €0.19 | matched |
| 95 | capture | 01a195f7-df8e-7017-bbd7-b0decba14b20 | €35.00 | €0.50 | matched |
| 96 | capture | 01a195f8-0220-7812-aedf-735a45b2551f | €9.00 | €0.19 | matched |
| 97 | capture | 01a195f8-17f8-7453-a798-8361c09fcbf6 | €24.00 | €0.37 | matched |
| 98 | capture | 01a195f8-1bf6-7273-b0ef-90c0e4b257e8 | €15.00 | €0.26 | matched |
| 99 | capture | 01a195f8-24ab-74d7-b79d-b7b74e346251 | €15.00 | €0.26 | matched |
| 100 | capture | 01a195f8-3155-7cee-966f-dc0f17738f7d | €35.00 | €0.50 | matched |
| 101 | capture | 01a195f8-315e-72ba-b633-987f2528604a | €49.00 | €0.67 | matched |
| 102 | capture | 01a195f8-4010-7983-a4ff-7d5e676ed5ff | €49.00 | €0.67 | matched |
| 103 | capture | 01a195f8-55d0-7ee1-804b-c0b01627a7c5 | €35.00 | €0.50 | matched |
| 104 | capture | 01a195f8-66a5-788d-bdd2-ea5f31ce5764 | €9.00 | €0.19 | matched |
| 105 | capture | 01a195f8-6a5e-76d0-ae7a-0ee8d0ada40d | €24.00 | €0.37 | matched |
| 106 | refund | 01a195f8-8277-75a4-9b26-5113143deb4b | -€17.00 | €0.00 | matched |
| 107 | capture | 01a195f8-95c7-7731-b2a9-359a2c32c41f | €24.00 | €0.37 | matched |
| 108 | capture | 01a195f8-c9f2-721e-9a1f-ef44c7453c28 | €15.00 | €0.26 | matched |
| 109 | capture | 01a195f8-d281-74c4-b853-8d399a447eb6 | €35.00 | €0.50 | matched |
| 110 | capture | 01a195f8-f318-7f48-bcf6-49bfc148f1ce | €15.00 | €0.26 | matched |
| 111 | capture | 01a195f8-f4c5-7796-8ac1-73057a399c69 | €35.00 | €0.50 | matched |
| 112 | capture | 01a195f8-f6b6-757d-a3f6-25d762e61dc9 | €49.00 | €0.67 | matched |
| 113 | capture | 01a195f9-2b39-754a-8ecc-f2ceba017b6f | €49.00 | €0.67 | matched |
| 114 | capture | 01a195f9-2cdf-71a5-8a5b-8ed04c3bb373 | €35.00 | €0.50 | matched |
| 115 | capture | 01a195f9-3180-7d13-ab57-bc88158283bb | €15.00 | €0.26 | matched |
| 116 | capture | 01a195f9-5f4e-754a-ad26-bb0712fbe194 | €49.00 | €0.67 | matched |
| 117 | refund | 01a195f9-6612-7467-84cf-6cd1022f60d2 | -€7.00 | €0.00 | matched |
| 118 | capture | 01a195f9-6db6-7fbb-9855-90fd2fec6e34 | €24.00 | €0.37 | matched |
| 119 | refund | 01a195f9-8c5a-70cc-b7de-dc9f069df6ef | -€11.00 | €0.00 | matched |
| 120 | capture | 01a195f9-bcd5-7560-a1c4-d2c676dbb419 | €15.00 | €0.26 | matched |
| 121 | capture | 01a195f9-c817-7c55-be0c-4c6e158b75f5 | €24.00 | €0.37 | matched |
| 122 | capture | 01a195f9-e0ce-7095-9095-9e5ff38a4087 | €49.00 | €0.67 | matched |
| 123 | capture | 01a195f9-ebf8-7de3-9b02-9bbdc6bb3e60 | €35.00 | €0.50 | matched |
| 124 | capture | 01a195f9-f400-73c1-a216-059202f138f4 | €24.00 | €0.37 | matched |
| 125 | capture | 01a195fa-0e91-766f-afa9-f4d43c7d505c | €15.00 | €0.26 | matched |
| 126 | capture | 01a195fa-316d-7665-a88e-6d61f3d86a3d | €49.00 | €0.67 | matched |
| 127 | capture | 01a195fa-550a-763d-a01a-51bdcd13d9f3 | €9.00 | €0.19 | matched |
| 128 | capture | 01a195fa-7069-75a1-9015-ba9f3cc5762f | €49.00 | €0.67 | matched |
| 129 | capture | 01a195fa-7d55-7c42-a021-b154d2f712e3 | €24.00 | €0.37 | matched |
| 130 | capture | 01a195fa-952f-7db6-83fa-ef6db8abf068 | €9.00 | €0.19 | matched |
| 131 | capture | 01a195fa-a853-7fd8-97ef-94586b6f3cf0 | €35.00 | €0.50 | matched |
| 132 | capture | 01a195fa-aa26-7711-91a0-b5bd0d4365c4 | €49.00 | €0.67 | matched |
| 133 | capture | 01a195fa-bb4e-7d19-ba8f-41b2d62351a8 | €35.00 | €0.50 | matched |
| 134 | refund | 01a195fa-bbda-7a8c-9b1a-148604c59124 | -€12.00 | €0.00 | matched |