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
- 26 Oct, 08:40133 lines2 breaks
- 26 Oct, 08:30127 lines5 breaks
- 26 Oct, 08:20132 lines2 breaks
- 26 Oct, 08:10113 lines4 breaks
- 26 Oct, 08:00136 lines3 breaks
- 26 Oct, 07:50145 lines4 breaks
- 26 Oct, 07:40114 lines2 breaks
- 26 Oct, 07:30131 lines2 breaks
- 26 Oct, 07:20105 lines3 breaks
- 26 Oct, 07:10134 lines4 breaks
- 26 Oct, 07:00116 lines2 breaks
- 26 Oct, 06:50114 lines2 breaks
- 26 Oct, 06:40150 lines3 breaks
- 26 Oct, 06:30111 lines3 breaks
26 Oct, 08:00
Gross
€3,023.00
PSP fee
€47.90
Net to the bank
€2,975.10
Settlement journal
#211516
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1773a-7b8f-71c0-9757-e3bf7728aab4 is already settled by stl_EUR_2988336 line 17
- duplicate linethe file lists it twicecapture:01a1773e-c538-701c-82d8-8220d59b330c is already settled by stl_EUR_2988336 line 91
- missing linein the books, not in the filecapture:01a1773a-1ba6-71fa-8e5a-4757e9619367 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 18 | capture | 01a1773a-7d45-7d01-a8fe-4efeb8caf508 | €9.00 | €0.19 | duplicate line |
| 92 | capture | 01a1773e-dc2e-75e7-b70f-26d94e37eb16 | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a17730-c4ec-76d3-8f8b-bd8aa225e9a3 | €15.00 | €0.26 | matched |
| 2 | capture | 01a17733-46b7-7f26-b13d-3ef8af2fddce | €24.00 | €0.37 | matched |
| 3 | capture | 01a17739-5440-70e0-8e32-de35ce0ec104 | €35.00 | €0.50 | matched |
| 4 | capture | 01a17739-662d-7008-ab56-8bb8448bc17e | €9.00 | €0.19 | matched |
| 5 | capture | 01a17739-6818-7e41-8d64-1f92e4c456fd | €15.00 | €0.26 | matched |
| 6 | capture | 01a17739-73f7-7611-acd6-7ac7bb6f3a7a | €9.00 | €0.19 | matched |
| 7 | capture | 01a17739-8b01-716e-b236-b104114565a3 | €9.00 | €0.19 | matched |
| 8 | refund | 01a17739-9081-73de-b1c3-7df2152e3d1d | -€10.00 | €0.00 | matched |
| 9 | refund | 01a17739-93d5-76d1-a88a-d94283f3e347 | -€3.00 | €0.00 | matched |
| 10 | capture | 01a17739-c125-71dc-8806-cefc3f7d3603 | €15.00 | €0.26 | matched |
| 11 | capture | 01a17739-e284-73b2-bd00-055166ea14cf | €49.00 | €0.67 | matched |
| 12 | capture | 01a17739-fa96-7254-8545-7133bb9ab891 | €9.00 | €0.19 | matched |
| 13 | capture | 01a1773a-32c7-7f72-9667-2a34383e5d98 | €9.00 | €0.19 | matched |
| 14 | capture | 01a1773a-38ff-78dc-a843-241ace059e7a | €24.00 | €0.37 | matched |
| 15 | capture | 01a1773a-3f07-7a26-82a9-98eec28f8e66 | €35.00 | €0.50 | matched |
| 16 | capture | 01a1773a-5e21-75b4-8838-2f7eb725494e | €35.00 | €0.50 | matched |
| 17 | capture | 01a1773a-7d45-7d01-a8fe-4efeb8caf508 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1773a-90aa-7cfa-afc6-0632d1f27238 | €35.00 | €0.50 | matched |
| 20 | capture | 01a1773a-915f-7300-879e-4564cd552ad3 | €35.00 | €0.50 | matched |
| 21 | capture | 01a1773a-91da-74ed-adf0-d2cc0ccb04ae | €9.00 | €0.19 | matched |
| 22 | capture | 01a1773a-93dd-7a49-a5c3-68ce718d20fb | €35.00 | €0.50 | matched |
| 23 | capture | 01a1773a-96cd-7fb5-9676-382170521b32 | €49.00 | €0.67 | matched |
| 24 | capture | 01a1773a-be2e-72c1-89a8-de5ef8ac6c9a | €35.00 | €0.50 | matched |
| 25 | capture | 01a1773a-c624-799a-a686-9a53fe51f767 | €49.00 | €0.67 | matched |
| 26 | capture | 01a1773a-ce06-71cb-b283-a5481be1238f | €49.00 | €0.67 | matched |
| 27 | capture | 01a1773a-d839-77cc-90b4-0f8e2ade5c0e | €49.00 | €0.67 | matched |
| 28 | capture | 01a1773a-e18e-7897-82f1-420efd8a62a3 | €35.00 | €0.50 | matched |
| 29 | capture | 01a1773a-fcad-7cab-8ed9-c17a570de96f | €24.00 | €0.37 | matched |
| 30 | capture | 01a1773a-fd60-7d91-89b6-25bebe7ee71e | €35.00 | €0.50 | matched |
| 31 | capture | 01a1773b-1319-7b6f-86a0-6a833dd5b0bd | €15.00 | €0.26 | matched |
| 32 | capture | 01a1773b-2a6d-7def-88a2-3dfc8a735c41 | €15.00 | €0.26 | matched |
| 33 | capture | 01a1773b-2c16-7140-bdc8-65426f56a781 | €35.00 | €0.50 | matched |
| 34 | capture | 01a1773b-3f75-71ca-a050-ee419575b5de | €15.00 | €0.26 | matched |
| 35 | capture | 01a1773b-6242-7142-90a5-aff79b81a976 | €49.00 | €0.67 | matched |
| 36 | refund | 01a1773b-6c35-7850-a80a-363fa723ef9b | -€12.00 | €0.00 | matched |
| 37 | capture | 01a1773b-79b3-7a8a-b5c8-9a6c7bd073a1 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1773b-8679-70a9-b128-cd201bae2976 | €15.00 | €0.26 | matched |
| 39 | capture | 01a1773b-9482-7274-b189-a93b65257f76 | €9.00 | €0.19 | matched |
| 40 | capture | 01a1773b-aa3b-754f-bc09-17770c5d7bd4 | €35.00 | €0.50 | matched |
| 41 | capture | 01a1773b-ad0c-792c-b5d1-1d0e4adf8137 | €15.00 | €0.26 | matched |
| 42 | capture | 01a1773b-b3b2-7fb0-b178-29922c38b128 | €35.00 | €0.50 | matched |
| 43 | capture | 01a1773b-d2c9-7856-aa7a-3a29f4875748 | €24.00 | €0.37 | matched |
| 44 | capture | 01a1773b-db9f-7a42-b028-5a8fb41bcce4 | €9.00 | €0.19 | matched |
| 45 | capture | 01a1773b-de81-74b9-9a0c-c79aa0360d1c | €24.00 | €0.37 | matched |
| 46 | capture | 01a1773b-df17-7228-bf0b-671ca56a4343 | €35.00 | €0.50 | matched |
| 47 | capture | 01a1773b-e924-7f4d-ab0b-ba16645b567b | €9.00 | €0.19 | matched |
| 48 | capture | 01a1773b-f8cc-791e-9ff9-49523b2a8acb | €35.00 | €0.50 | matched |
| 49 | capture | 01a1773c-08f1-7a2b-b986-efa49dd79f45 | €24.00 | €0.37 | matched |
| 50 | capture | 01a1773c-0f69-7488-9e9e-03bedaafedfe | €15.00 | €0.26 | matched |
| 51 | capture | 01a1773c-16c5-731a-a370-f92bf9a0bd4c | €24.00 | €0.37 | matched |
| 52 | refund | 01a1773c-35be-7a28-b5ec-e731fc9cd851 | -€9.00 | €0.00 | matched |
| 53 | capture | 01a1773c-4927-75d2-8c13-55b762cbada1 | €49.00 | €0.67 | matched |
| 54 | capture | 01a1773c-7e26-7c43-be64-56fbfbf3e563 | €49.00 | €0.67 | matched |
| 55 | capture | 01a1773c-7f8f-73a0-9e8b-3b9d57d893cc | €49.00 | €0.67 | matched |
| 56 | capture | 01a1773c-8222-7297-907e-fa026cbc3c70 | €9.00 | €0.19 | matched |
| 57 | capture | 01a1773c-8d2f-7fd2-9c34-997744c20e6b | €9.00 | €0.19 | matched |
| 58 | capture | 01a1773c-8f04-7588-a755-984d1f568c16 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1773c-9c34-7531-8f1c-c43816647150 | €15.00 | €0.26 | matched |
| 60 | capture | 01a1773c-cd4e-795f-946e-1965ef8712d5 | €24.00 | €0.37 | matched |
| 61 | capture | 01a1773c-c9b0-7027-9012-15f17897633d | €15.00 | €0.26 | matched |
| 62 | capture | 01a1773c-d2ea-7fb9-97b0-bbe9d062d945 | €35.00 | €0.50 | matched |
| 63 | capture | 01a1773c-d4c7-7623-9dfb-62d3966a548c | €35.00 | €0.50 | matched |
| 64 | refund | 01a1773c-e544-74ed-96b3-71fe552637d0 | -€7.00 | €0.00 | matched |
| 65 | capture | 01a1773d-047f-75d2-8e34-25086f51d35e | €35.00 | €0.50 | matched |
| 66 | capture | 01a1773d-0d0b-7742-ba05-342d985b0fa3 | €24.00 | €0.37 | matched |
| 67 | refund | 01a1773d-3668-73a0-8aa8-7e2b0db25638 | -€17.00 | €0.00 | matched |
| 68 | capture | 01a1773d-4856-74a0-bccb-c4b355f78ad7 | €24.00 | €0.37 | matched |
| 69 | capture | 01a1773d-49a5-75a0-aec2-d1869f6dfaf1 | €15.00 | €0.26 | matched |
| 70 | capture | 01a1773d-6c71-7a7b-beee-f0935038f28c | €49.00 | €0.67 | matched |
| 71 | capture | 01a1773d-b0ab-735d-be3b-b2d27186e41f | €35.00 | €0.50 | matched |
| 72 | capture | 01a1773d-b40f-7db2-9e03-6a8628c0f330 | €35.00 | €0.50 | matched |
| 73 | capture | 01a1773d-b74e-74ac-a620-936a7c5e85e6 | €49.00 | €0.67 | matched |
| 74 | capture | 01a1773d-c9fa-712c-bfbc-2e27aa70a948 | €15.00 | €0.26 | matched |
| 75 | capture | 01a1773d-d9b5-703a-b9a3-1654c09dae00 | €9.00 | €0.19 | matched |
| 76 | capture | 01a1773d-d9e4-7fc8-8f94-c22671d8d1ae | €9.00 | €0.19 | matched |
| 77 | refund | 01a1773d-f836-7665-b2c1-a7ec7e39a34a | -€19.00 | €0.00 | matched |
| 78 | capture | 01a1773e-198f-7603-b67e-be6a4f1fd990 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1773e-2cbf-7350-be10-92aedbf31486 | €15.00 | €0.26 | matched |
| 80 | capture | 01a1773e-3fab-7fef-9f3c-f3959616177e | €35.00 | €0.50 | matched |
| 81 | capture | 01a1773e-4427-7ec9-8f01-8b4f7faa86a7 | €15.00 | €0.26 | matched |
| 82 | capture | 01a1773e-4881-7ab8-a645-899870dec746 | €24.00 | €0.37 | matched |
| 83 | capture | 01a1773e-582f-73e7-972f-4934a5426a14 | €49.00 | €0.67 | matched |
| 84 | capture | 01a1773e-5a32-7f4f-ba03-a6a4503c2853 | €35.00 | €0.50 | matched |
| 85 | capture | 01a1773e-64c0-7521-9622-ca4033933a72 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1773e-725a-7341-86c9-feea86363172 | €24.00 | €0.37 | matched |
| 87 | capture | 01a1773e-8a8e-7070-8c13-cec7a39e233b | €9.00 | €0.19 | matched |
| 88 | refund | 01a1773e-b7ee-7507-bd60-6b14c037ed75 | -€16.00 | €0.00 | matched |
| 89 | capture | 01a1773e-baea-7bed-907f-eb2808dfc4e0 | €35.00 | €0.50 | matched |
| 90 | refund | 01a1773e-d864-7ceb-a2df-756cb99596c7 | -€3.00 | €0.00 | matched |
| 91 | capture | 01a1773e-dc2e-75e7-b70f-26d94e37eb16 | €15.00 | €0.26 | matched |
| 93 | capture | 01a1773e-dc5f-738c-ae86-930178f959ed | €9.00 | €0.19 | matched |
| 94 | capture | 01a1773e-ec1b-79ff-8a08-69d3601f8022 | €9.00 | €0.19 | matched |
| 95 | capture | 01a1773e-f920-7a5e-95b6-774d7639387b | €24.00 | €0.37 | matched |
| 96 | capture | 01a1773f-0a36-7152-ad48-40158a0ec13b | €9.00 | €0.19 | matched |
| 97 | capture | 01a1773f-0c9b-7f15-b5ce-295d9acf3a6b | €9.00 | €0.19 | matched |
| 98 | capture | 01a1773f-2348-7f2b-9371-bd8616625a15 | €9.00 | €0.19 | matched |
| 99 | capture | 01a1773f-307e-77bb-8bbd-d3528e099620 | €49.00 | €0.67 | matched |
| 100 | capture | 01a1773f-3851-7262-836d-f7b70df11fae | €15.00 | €0.26 | matched |
| 101 | capture | 01a1773f-4082-72a9-b312-47f9df242124 | €15.00 | €0.26 | matched |
| 102 | capture | 01a1773f-4373-72e3-a4de-2255d71f65c7 | €24.00 | €0.37 | matched |
| 103 | capture | 01a1773f-8032-70bf-8525-ebf7e57b9068 | €24.00 | €0.37 | matched |
| 104 | capture | 01a1773f-83f8-7512-8522-3470f63c4f2b | €35.00 | €0.50 | matched |
| 105 | capture | 01a1773f-a288-778f-aa7a-0feb14266690 | €9.00 | €0.19 | matched |
| 106 | capture | 01a1773f-c854-7fa4-88bc-d8ced6a34aac | €24.00 | €0.37 | matched |
| 107 | capture | 01a1773f-dfe0-7f86-bd6f-4d0fe887f78d | €15.00 | €0.26 | matched |
| 108 | capture | 01a1773f-e0af-7532-8615-a198eb969009 | €35.00 | €0.50 | matched |
| 109 | capture | 01a17740-0dfc-7d1a-b058-9bf00c27c5fc | €24.00 | €0.37 | matched |
| 110 | capture | 01a17740-11ef-7524-8a40-6a76ca2a27fd | €15.00 | €0.26 | matched |
| 111 | capture | 01a17740-1f11-7920-99c2-94633cc81bf9 | €15.00 | €0.26 | matched |
| 112 | capture | 01a17740-3899-737d-8b37-5ee634128a48 | €49.00 | €0.67 | matched |
| 113 | capture | 01a17740-4723-7efd-a415-4005b4e947b5 | €35.00 | €0.50 | matched |
| 114 | capture | 01a17740-5d32-7283-8cf7-3a4e61cd9fc8 | €49.00 | €0.67 | matched |
| 115 | capture | 01a17740-5f3e-7604-84fe-789f709e8014 | €35.00 | €0.50 | matched |
| 116 | capture | 01a17740-6750-7cb7-95e1-a7572d443214 | €15.00 | €0.26 | matched |
| 117 | capture | 01a17740-6fc1-7398-a23c-f3bdcde62d5e | €15.00 | €0.26 | matched |
| 118 | capture | 01a17740-acf9-76f7-ad36-b03d8663e678 | €15.00 | €0.26 | matched |
| 119 | capture | 01a17740-aebd-73b5-949c-e8a42f65c5d7 | €24.00 | €0.37 | matched |
| 120 | capture | 01a17740-cf74-7e7e-a91b-59666c14d43a | €35.00 | €0.50 | matched |
| 121 | capture | 01a17741-21b1-76cd-889d-705222628314 | €15.00 | €0.26 | matched |
| 122 | capture | 01a17741-4c61-76bf-a8e7-ac035ab35677 | €24.00 | €0.37 | matched |
| 123 | capture | 01a17741-59e9-7b92-96da-5bda22903b26 | €24.00 | €0.37 | matched |
| 124 | capture | 01a17741-7f15-71ad-8548-b01b224790ea | €9.00 | €0.19 | matched |
| 125 | capture | 01a17741-90d9-7042-94b1-c5ed3706216b | €24.00 | €0.37 | matched |
| 126 | capture | 01a17741-9c77-7064-964e-9b7dd825d7d4 | €35.00 | €0.50 | matched |
| 127 | capture | 01a17741-c02c-7caa-834d-f731ad63f8b3 | €15.00 | €0.26 | matched |
| 128 | capture | 01a17741-dbfc-771a-af6b-4ee813f862fb | €9.00 | €0.19 | matched |
| 129 | refund | 01a17741-e760-7c81-b03e-46ef465559a1 | -€7.00 | €0.00 | matched |
| 130 | capture | 01a17741-f0c1-7ca2-94e7-39c20f9961ab | €49.00 | €0.67 | matched |
| 131 | capture | 01a17742-0398-7776-a1d4-5b81b2fc414b | €24.00 | €0.37 | matched |
| 132 | capture | 01a17742-13fc-70d9-9878-59f4f83663d3 | €35.00 | €0.50 | matched |
| 133 | capture | 01a17742-2834-7984-b1a3-a4d2ece7f430 | €24.00 | €0.37 | matched |
| 134 | capture | 01a17742-52f2-7f5d-8989-322a2c5e7d35 | €24.00 | €0.37 | matched |
| 135 | refund | 01a17742-54e3-7aa3-a014-cfc9c05520bd | -€21.00 | €0.00 | matched |
| 136 | capture | 01a17742-5a2f-7348-8cf4-af2fec16620d | €35.00 | €0.50 | matched |