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
- 25 Oct, 10:20124 lines5 breaks
- 25 Oct, 10:10127 lines3 breaks
- 25 Oct, 10:00125 lines2 breaks
- 25 Oct, 09:50125 lines4 breaks
- 25 Oct, 09:40119 lines1 break
- 25 Oct, 09:30137 lines5 breaks
- 25 Oct, 09:20124 lines5 breaks
- 25 Oct, 09:10128 lines3 breaks
- 25 Oct, 09:00135 lines5 breaks
- 25 Oct, 08:50135 lines6 breaks
- 25 Oct, 08:40126 lines3 breaks
- 25 Oct, 08:30128 lines3 breaks
- 25 Oct, 08:20133 lines2 breaks
- 25 Oct, 08:10110 lines1 break
25 Oct, 08:50
Gross
€2,819.00
PSP fee
€46.39
Net to the bank
€2,772.61
Settlement journal
#194001
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17240-b18b-739c-a772-f2f16d054e10 is already settled by stl_EUR_2988197 line 5
- duplicate linethe file lists it twicerefund:01a17242-3898-7612-b72f-ca81a487905b is already settled by stl_EUR_2988197 line 30
- duplicate linethe file lists it twicecapture:01a17246-343c-7a97-8d9c-d5d4af7bdb93 is already settled by stl_EUR_2988197 line 77
- duplicate linethe file lists it twicecapture:01a17246-5c97-7536-b07f-91e8d2ff2962 is already settled by stl_EUR_2988197 line 79
- missing linein the books, not in the filecapture:01a17241-834f-70c9-8756-5d165e46aa9d is in no file
- missing linein the books, not in the filecapture:01a17245-5584-79b2-a5c9-b7994311d0d6 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 6 | capture | 01a17240-b541-702e-92e9-88d3ac602e8f | €49.00 | €0.67 | duplicate line |
| 31 | refund | 01a17242-389b-7c8e-85fc-0f0236b46958 | -€19.00 | €0.00 | duplicate line |
| 78 | capture | 01a17246-34ac-7738-ab6c-b37f75a1df6f | €35.00 | €0.50 | duplicate line |
| 80 | capture | 01a17246-5cbf-78fe-b8b7-cf0be0d2ef00 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1723a-13e8-720d-bc6c-51b1f6b23889 | €24.00 | €0.37 | matched |
| 2 | capture | 01a1723f-6ea3-7586-91a9-a54d208b8cc8 | €9.00 | €0.19 | matched |
| 3 | capture | 01a17240-b0b4-7231-af5c-62cd1a878f88 | €9.00 | €0.19 | matched |
| 4 | capture | 01a17240-b295-7ec3-804e-3aa222d2fb83 | €24.00 | €0.37 | matched |
| 5 | capture | 01a17240-b541-702e-92e9-88d3ac602e8f | €49.00 | €0.67 | matched |
| 7 | capture | 01a17240-e60b-73d4-bc8f-0350d2ede632 | €49.00 | €0.67 | matched |
| 8 | capture | 01a17240-fa15-746f-b6e9-21c9d9894397 | €24.00 | €0.37 | matched |
| 9 | capture | 01a17241-1513-7515-91c8-820dc141e707 | €24.00 | €0.37 | matched |
| 10 | capture | 01a17241-3611-7623-bea8-4dd45559e73a | €24.00 | €0.37 | matched |
| 11 | refund | 01a17241-3673-7a10-bedc-67be7c272179 | -€36.00 | €0.00 | matched |
| 12 | capture | 01a17241-4d2d-7c2a-9403-fcb129ffb643 | €9.00 | €0.19 | matched |
| 13 | capture | 01a17241-5eaa-7d63-88bc-9545fb5130c5 | €9.00 | €0.19 | matched |
| 14 | capture | 01a17241-61f7-75e3-989e-4a5c683b2f60 | €35.00 | €0.50 | matched |
| 15 | capture | 01a17241-7e56-7abe-ab54-5b0667210507 | €15.00 | €0.26 | matched |
| 16 | capture | 01a17241-8141-7027-a0eb-0ed814687a10 | €24.00 | €0.37 | matched |
| 17 | capture | 01a17241-83ac-708f-a5e7-819f3abedcf5 | €24.00 | €0.37 | matched |
| 18 | capture | 01a17241-990c-7abf-9758-0e8b17db7740 | €35.00 | €0.50 | matched |
| 19 | capture | 01a17241-9a61-76ed-8dba-b590970cbb4e | €24.00 | €0.37 | matched |
| 20 | capture | 01a17241-b8e9-7391-91ad-f3538886ebde | €35.00 | €0.50 | matched |
| 21 | refund | 01a17241-dfef-7dd7-87e8-ab97aac33c72 | -€9.00 | €0.00 | matched |
| 22 | capture | 01a17241-e826-7c71-8d70-de4fc06e3679 | €9.00 | €0.19 | matched |
| 23 | capture | 01a17242-025c-71d1-a71d-60f355b09b40 | €35.00 | €0.50 | matched |
| 24 | capture | 01a17242-02d7-7531-b2c2-bd3846d22876 | €35.00 | €0.50 | matched |
| 25 | capture | 01a17242-05ba-7a3e-a066-33a7e90c8b99 | €49.00 | €0.67 | matched |
| 26 | capture | 01a17242-0de6-7f8b-8ec9-8bbe8ccf2e73 | €49.00 | €0.67 | matched |
| 27 | capture | 01a17242-1210-73d4-8b60-a1dae318cfdb | €49.00 | €0.67 | matched |
| 28 | capture | 01a17242-28a6-7f25-b69c-a9cb8fb4acbf | €9.00 | €0.19 | matched |
| 29 | capture | 01a17242-2dd7-7ab6-95bb-3bb047106ae3 | €49.00 | €0.67 | matched |
| 30 | refund | 01a17242-389b-7c8e-85fc-0f0236b46958 | -€19.00 | €0.00 | matched |
| 32 | capture | 01a17242-5443-7443-86ac-d4ad7a1353fc | €15.00 | €0.26 | matched |
| 33 | capture | 01a17242-6831-76be-8179-806622e44c0d | €15.00 | €0.26 | matched |
| 34 | refund | 01a17242-77a5-7264-97e3-0fceaa15626b | -€4.00 | €0.00 | matched |
| 35 | capture | 01a17242-83a7-78cd-94c6-3cc69822e555 | €24.00 | €0.37 | matched |
| 36 | capture | 01a17242-8841-7f2a-8e90-f9922c9cd23f | €15.00 | €0.26 | matched |
| 37 | capture | 01a17242-8b4d-7201-90f4-f34ff2a7e59f | €49.00 | €0.67 | matched |
| 38 | capture | 01a17242-968f-7903-a58a-2ac729e07eda | €9.00 | €0.19 | matched |
| 39 | capture | 01a17242-9beb-76c0-beaa-5f27deb76c84 | €9.00 | €0.19 | matched |
| 40 | capture | 01a17242-de25-7858-b432-a9707232be90 | €9.00 | €0.19 | matched |
| 41 | capture | 01a17242-e047-790c-a187-27241054b51e | €35.00 | €0.50 | matched |
| 42 | capture | 01a17243-140f-7056-93fb-7bd8bdd3056e | €15.00 | €0.26 | matched |
| 43 | capture | 01a17243-25d9-7248-862b-6de0cffa90af | €35.00 | €0.50 | matched |
| 44 | capture | 01a17243-3248-7fd9-ac69-31a0e30082aa | €15.00 | €0.26 | matched |
| 45 | capture | 01a17243-33f2-7d0a-90d5-d29071636d84 | €35.00 | €0.50 | matched |
| 46 | capture | 01a17243-3eda-7c98-a4e4-dab32fabba23 | €24.00 | €0.37 | matched |
| 47 | capture | 01a17243-6149-73a8-ae06-fd4289d5a832 | €9.00 | €0.19 | matched |
| 48 | capture | 01a17243-7a3b-7668-88cc-948f1286d568 | €35.00 | €0.50 | matched |
| 49 | capture | 01a17243-7b96-73dd-9465-bcccd0e81e99 | €15.00 | €0.26 | matched |
| 50 | capture | 01a17243-ad52-7065-bfc1-afbee1bb9cbd | €35.00 | €0.50 | matched |
| 51 | capture | 01a17243-d266-709f-9ce5-0630463c3c87 | €49.00 | €0.67 | matched |
| 52 | capture | 01a17244-1624-7193-969c-a78e3b3ac082 | €24.00 | €0.37 | matched |
| 53 | capture | 01a17244-2340-7416-a683-272fc4b6e141 | €15.00 | €0.26 | matched |
| 54 | capture | 01a17244-5b0d-7733-a7e8-6742fd3e5f94 | €24.00 | €0.37 | matched |
| 55 | capture | 01a17244-71bd-77d4-a773-26688bccc037 | €15.00 | €0.26 | matched |
| 56 | capture | 01a17244-903d-7173-b528-c927845ab4bf | €9.00 | €0.19 | matched |
| 57 | capture | 01a17244-a7c9-763b-ab40-4957d4cb81e9 | €24.00 | €0.37 | matched |
| 58 | capture | 01a17244-af88-75d5-b9bf-d02f8a798706 | €9.00 | €0.19 | matched |
| 59 | capture | 01a17244-d84d-7c11-8381-53eb982025bc | €35.00 | €0.50 | matched |
| 60 | refund | 01a17244-e68a-7156-b03a-bc5f1a41acc5 | -€11.00 | €0.00 | matched |
| 61 | capture | 01a17244-ec6c-71c3-b903-c3a47397c5dd | €9.00 | €0.19 | matched |
| 62 | capture | 01a17244-f67c-7342-b2e2-da0c610c938c | €9.00 | €0.19 | matched |
| 63 | capture | 01a17244-f982-7461-9628-3a18eb276d22 | €35.00 | €0.50 | matched |
| 64 | refund | 01a17245-1091-7c59-a500-8ce70d34c412 | -€14.00 | €0.00 | matched |
| 65 | capture | 01a17245-14c7-779b-b0c9-0b20cafd8a4d | €24.00 | €0.37 | matched |
| 66 | capture | 01a17245-33ec-741d-bc0c-62b65d3632f2 | €9.00 | €0.19 | matched |
| 67 | capture | 01a17245-4376-7dca-88d8-b7347e451fca | €15.00 | €0.26 | matched |
| 68 | capture | 01a17245-4893-70a6-902e-b87636ba7734 | €24.00 | €0.37 | matched |
| 69 | capture | 01a17245-4e1c-73bd-a6a5-8fd99b24fd2a | €49.00 | €0.67 | matched |
| 70 | capture | 01a17245-5548-7792-b2d9-7d952231a0cd | €15.00 | €0.26 | matched |
| 71 | refund | 01a17245-852e-77ff-bd9e-e0381b928dae | -€24.00 | €0.00 | matched |
| 72 | capture | 01a17245-aff5-7f4c-b80b-e4fee80b3e99 | €35.00 | €0.50 | matched |
| 73 | capture | 01a17245-b18c-7dc2-a2db-fe69f54f7f10 | €24.00 | €0.37 | matched |
| 74 | capture | 01a17246-0721-7ba9-9ca6-e13cb557c5c4 | €9.00 | €0.19 | matched |
| 75 | capture | 01a17246-1263-7b95-95ae-ec1b3b5dc92d | €49.00 | €0.67 | matched |
| 76 | capture | 01a17246-19ad-7be1-ac30-0f5ec498db8c | €9.00 | €0.19 | matched |
| 77 | capture | 01a17246-34ac-7738-ab6c-b37f75a1df6f | €35.00 | €0.50 | matched |
| 79 | capture | 01a17246-5cbf-78fe-b8b7-cf0be0d2ef00 | €49.00 | €0.67 | matched |
| 81 | capture | 01a17246-6481-7b55-80d0-55596933f4be | €15.00 | €0.26 | matched |
| 82 | capture | 01a17246-87bc-7f5d-9867-f39e93d4bd0c | €24.00 | €0.37 | matched |
| 83 | capture | 01a17246-891f-79e6-a8a4-d9f310049ecf | €15.00 | €0.26 | matched |
| 84 | capture | 01a17246-a318-7e8e-be4b-a588323ff73d | €49.00 | €0.67 | matched |
| 85 | capture | 01a17246-a5ee-7d9b-ade9-6d0bbecc441a | €9.00 | €0.19 | matched |
| 86 | capture | 01a17246-a823-77ce-9dbc-0997bb9e12a3 | €35.00 | €0.50 | matched |
| 87 | capture | 01a17246-c89c-765a-b2ee-6b48fd6e09fd | €24.00 | €0.37 | matched |
| 88 | refund | 01a17246-d730-7748-8563-82975611494f | -€4.00 | €0.00 | matched |
| 89 | capture | 01a17246-de31-7ca2-b4d0-590ceb8c4468 | €24.00 | €0.37 | matched |
| 90 | capture | 01a17246-ead3-7823-8b82-cec2dcd5a755 | €15.00 | €0.26 | matched |
| 91 | capture | 01a17246-ec6b-784a-ba4d-406dd833f292 | €24.00 | €0.37 | matched |
| 92 | capture | 01a17246-efe9-7fa5-815e-ceda9e89c3a0 | €49.00 | €0.67 | matched |
| 93 | capture | 01a17246-f676-799c-894e-c08e81d826f1 | €49.00 | €0.67 | matched |
| 94 | capture | 01a17246-fb3c-75df-bea0-875a591aede2 | €9.00 | €0.19 | matched |
| 95 | capture | 01a17247-010e-7bd8-8109-71fbc48ee605 | €35.00 | €0.50 | matched |
| 96 | capture | 01a17247-06b8-734e-9b5e-24e063ee44c6 | €15.00 | €0.26 | matched |
| 97 | capture | 01a17247-08dc-7d47-b88f-5d93f8b5305d | €24.00 | €0.37 | matched |
| 98 | capture | 01a17247-0e3c-7273-b6b0-a83c60d0ce30 | €9.00 | €0.19 | matched |
| 99 | capture | 01a17247-2d6c-78b5-a7bd-a3f5c9256cc3 | €49.00 | €0.67 | matched |
| 100 | capture | 01a17247-2f06-7382-98f1-eadef2e2be7b | €9.00 | €0.19 | matched |
| 101 | capture | 01a17247-3b40-77bb-9a7b-b1bc7af4dda6 | €24.00 | €0.37 | matched |
| 102 | capture | 01a17247-6a03-74f7-8831-bd5419c80aad | €9.00 | €0.19 | matched |
| 103 | refund | 01a17247-68ef-782e-9a13-d66e7c79d3fe | -€38.00 | €0.00 | matched |
| 104 | capture | 01a17247-9775-74d7-92df-70bc504a0d80 | €35.00 | €0.50 | matched |
| 105 | capture | 01a17247-9b40-7c98-b3df-b643516cdfc8 | €35.00 | €0.50 | matched |
| 106 | capture | 01a17247-a8d5-7184-89e0-d194dfaf0e97 | €9.00 | €0.19 | matched |
| 107 | capture | 01a17247-b452-7087-be1a-81f3010c05ed | €9.00 | €0.19 | matched |
| 108 | capture | 01a17247-ba17-719c-8630-44e4ecb98e93 | €9.00 | €0.19 | matched |
| 109 | refund | 01a17247-c38e-7aa7-8fe4-dc9f8fe42a75 | -€5.00 | €0.00 | matched |
| 110 | capture | 01a17247-d3c3-7e5a-8624-025b4ee0c98d | €15.00 | €0.26 | matched |
| 111 | capture | 01a17247-de0a-7c26-aa58-2366fe30cb0b | €15.00 | €0.26 | matched |
| 112 | capture | 01a17247-e5ef-710e-9242-aeaf2a20f1b9 | €9.00 | €0.19 | matched |
| 113 | capture | 01a17247-e629-78e4-aad2-78dc720d96eb | €24.00 | €0.37 | matched |
| 114 | capture | 01a17247-d038-7bbd-9e56-11048705937e | €9.00 | €0.19 | matched |
| 115 | capture | 01a17247-ec8a-7798-bba9-f4285e01be4c | €9.00 | €0.19 | matched |
| 116 | capture | 01a17248-18e6-7cda-80d5-e4156591e217 | €49.00 | €0.67 | matched |
| 117 | capture | 01a17248-58fb-7cec-8e5b-23bb63296159 | €15.00 | €0.26 | matched |
| 118 | capture | 01a17248-6b1e-7cdb-9fba-5f1224c6daef | €9.00 | €0.19 | matched |
| 119 | capture | 01a17248-6c78-77a4-b064-a00a13d696f3 | €15.00 | €0.26 | matched |
| 120 | capture | 01a17248-8fce-7bb5-99a4-f66693e72dad | €49.00 | €0.67 | matched |
| 121 | capture | 01a17248-da3d-7e2f-acec-d510036b56a8 | €9.00 | €0.19 | matched |
| 122 | capture | 01a17248-fc42-7bdc-b879-70cac62b68ca | €15.00 | €0.26 | matched |
| 123 | capture | 01a17249-0666-7310-bc03-40051f0a448a | €15.00 | €0.26 | matched |
| 124 | capture | 01a17249-07f7-7960-9850-8fa3b5c4cf82 | €15.00 | €0.26 | matched |
| 125 | capture | 01a17249-1a6c-78c8-a03f-fd904375ca82 | €35.00 | €0.50 | matched |
| 126 | capture | 01a17249-232b-72f2-a43c-a4374d8d4a14 | €15.00 | €0.26 | matched |
| 127 | capture | 01a17249-2ed4-731b-8f7c-5873bc1c79ed | €49.00 | €0.67 | matched |
| 128 | capture | 01a17249-5643-7020-8673-ac113da4d6fb | €24.00 | €0.37 | matched |
| 129 | capture | 01a17249-68ae-714e-9a75-17798ca196f1 | €35.00 | €0.50 | matched |
| 130 | capture | 01a17249-6abf-7155-b6b2-caa4ce39b4b3 | €9.00 | €0.19 | matched |
| 131 | capture | 01a17249-6e3b-737f-a817-e3b418368d55 | €35.00 | €0.50 | matched |
| 132 | refund | 01a17249-87cd-7fe8-b882-86a58619afa0 | -€31.00 | €0.00 | matched |
| 133 | capture | 01a17249-996d-7944-8f24-a3818d9b4c85 | €24.00 | €0.37 | matched |
| 134 | capture | 01a17249-9d69-79ab-9fed-de80ebdbc619 | €35.00 | €0.50 | matched |
| 135 | capture | 01a17249-a0e0-7eaf-901d-9f7740ff4790 | €24.00 | €0.37 | matched |