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
- 15 Oct, 18:10146 lines2 breaks
- 15 Oct, 18:00131 lines3 breaks
- 15 Oct, 17:50126 lines4 breaks
- 15 Oct, 17:40115 lines6 breaks
- 15 Oct, 17:30104 linesclean
- 15 Oct, 17:20139 lines5 breaks
- 15 Oct, 17:10107 linesclean
- 15 Oct, 17:00109 lines1 break
- 15 Oct, 16:50152 lines1 break
- 15 Oct, 16:40126 lines3 breaks
- 15 Oct, 16:30106 linesclean
- 15 Oct, 16:20130 lines3 breaks
- 15 Oct, 16:10132 lines3 breaks
- 15 Oct, 16:00114 lines2 breaks
15 Oct, 16:40
Gross
€2,875.00
PSP fee
€45.34
Net to the bank
€2,829.66
Settlement journal
#17888
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14070-ea0e-7e1f-b1d6-30e2428f9e8e is already settled by stl_EUR_2986804 line 31
- fee differencethe fee is not the contract feethe fee is 24, the contract says 19
- missing linein the books, not in the filecapture:01a14070-391b-71a5-8073-1474fc20b4fb is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 29 | capture | 01a14070-b919-707d-858c-dd5fd6bcae8b | €9.00 | €0.24 | fee difference |
| 32 | capture | 01a14070-ea5e-7625-ba16-4ab4aa34f579 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a14066-4b41-7fdd-988d-36222801acb4 | €9.00 | €0.19 | matched |
| 2 | capture | 01a14066-a898-7bb2-8751-2146a3b50144 | €24.00 | €0.37 | matched |
| 3 | capture | 01a14068-a1b2-79b5-aead-cd337b26dc60 | €9.00 | €0.19 | matched |
| 4 | refund | 01a1406f-61da-7bb9-9c63-b5daee74de34 | -€5.00 | €0.00 | matched |
| 5 | capture | 01a1406f-6ca4-7cac-836d-5b2bf1494b91 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1406f-9890-7780-b282-b6e245da3538 | €24.00 | €0.37 | matched |
| 7 | refund | 01a1406f-91b0-7d3b-8a32-9b02b124d821 | -€27.00 | €0.00 | matched |
| 8 | capture | 01a1406f-9b18-7901-8091-48dce7e90f25 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1406f-a046-73a8-aa8e-878d1457a13e | €15.00 | €0.26 | matched |
| 10 | capture | 01a1406f-a5a4-7170-bccf-145a0bf94f89 | €9.00 | €0.19 | matched |
| 11 | capture | 01a1406f-b3a8-709b-94ed-2fd2239bb81b | €15.00 | €0.26 | matched |
| 12 | capture | 01a1406f-c2e5-704c-bd4f-e0921848ff01 | €9.00 | €0.19 | matched |
| 13 | capture | 01a1406f-c991-7bd1-8006-3f0502c1a5c2 | €24.00 | €0.37 | matched |
| 14 | capture | 01a1406f-d967-72b7-9e1c-d6c10aab66e2 | €9.00 | €0.19 | matched |
| 15 | capture | 01a1406f-da3e-7bc5-b7bb-2e03fbfbae4d | €49.00 | €0.67 | matched |
| 16 | capture | 01a1406f-e2d1-771f-ae59-86633f310cef | €24.00 | €0.37 | matched |
| 17 | capture | 01a1406f-e49c-7aab-bf85-fd46f6fcac50 | €9.00 | €0.19 | matched |
| 18 | capture | 01a1406f-e66a-768d-8eae-faba071d5da8 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1406f-e834-7437-85de-ab3db1fc88c4 | €9.00 | €0.19 | matched |
| 20 | capture | 01a1406f-fd17-71bf-a484-9505e6378f56 | €9.00 | €0.19 | matched |
| 21 | refund | 01a14070-05de-7176-93f5-7c492113d015 | -€6.00 | €0.00 | matched |
| 22 | capture | 01a14070-45c6-7782-a107-f098309c6ffd | €35.00 | €0.50 | matched |
| 23 | capture | 01a14070-5b87-7f5d-add7-bc09c08cfdbd | €24.00 | €0.37 | matched |
| 24 | capture | 01a14070-6d6c-7abe-a8f7-736b5c07cea1 | €9.00 | €0.19 | matched |
| 25 | capture | 01a14070-9d71-7866-9c06-58bcfb997477 | €49.00 | €0.67 | matched |
| 26 | capture | 01a14070-a230-7d08-bc55-912f9171e4c8 | €24.00 | €0.37 | matched |
| 27 | capture | 01a14070-a417-780a-a0b0-11d5e1016685 | €35.00 | €0.50 | matched |
| 28 | capture | 01a14070-b60e-7b91-846e-5093f0657b37 | €49.00 | €0.67 | matched |
| 30 | capture | 01a14070-de3c-7248-b8be-f514c8d59b47 | €24.00 | €0.37 | matched |
| 31 | capture | 01a14070-ea5e-7625-ba16-4ab4aa34f579 | €49.00 | €0.67 | matched |
| 33 | refund | 01a14071-34c8-741d-acb8-3dfe32377074 | -€17.00 | €0.00 | matched |
| 34 | capture | 01a14071-80c5-7d48-a997-8057cbda9dad | €35.00 | €0.50 | matched |
| 35 | capture | 01a14071-8756-7037-8462-7772719c76a2 | €49.00 | €0.67 | matched |
| 36 | capture | 01a14071-9d3e-7b77-bf0b-f589ebef6015 | €49.00 | €0.67 | matched |
| 37 | capture | 01a14071-afbe-77cc-b42e-dd3cc294c5f6 | €35.00 | €0.50 | matched |
| 38 | capture | 01a14071-c02c-76ba-b644-c5376da13929 | €35.00 | €0.50 | matched |
| 39 | capture | 01a14071-f739-7aa4-a235-c4bb9d9a496c | €24.00 | €0.37 | matched |
| 40 | capture | 01a14072-0204-731d-9a89-034fa5d2db83 | €24.00 | €0.37 | matched |
| 41 | capture | 01a14072-348e-74cf-8a37-eb0f53c62aea | €35.00 | €0.50 | matched |
| 42 | capture | 01a14072-38df-7768-b3e4-c9abc0e0227d | €24.00 | €0.37 | matched |
| 43 | capture | 01a14072-470e-7d90-b2d7-9ca2f929f8b7 | €35.00 | €0.50 | matched |
| 44 | capture | 01a14072-4e66-72e6-a86e-30344a6082eb | €15.00 | €0.26 | matched |
| 45 | capture | 01a14072-541b-7308-abcd-9d5a69670c26 | €24.00 | €0.37 | matched |
| 46 | capture | 01a14072-626d-779b-b54c-5a8790ea23e9 | €9.00 | €0.19 | matched |
| 47 | capture | 01a14072-828b-75fb-92bd-6385a3bc0569 | €9.00 | €0.19 | matched |
| 48 | capture | 01a14072-8427-7072-8da4-327573c6e5df | €35.00 | €0.50 | matched |
| 49 | refund | 01a14072-8d91-792c-a9bf-d49630b8bb4d | -€23.00 | €0.00 | matched |
| 50 | capture | 01a14072-a402-733c-ba2e-099a7e578e13 | €35.00 | €0.50 | matched |
| 51 | capture | 01a14072-c54d-7605-8b02-552c30c282f2 | €15.00 | €0.26 | matched |
| 52 | capture | 01a14072-ef8f-7bc0-972a-dd7af25a8a2f | €15.00 | €0.26 | matched |
| 53 | capture | 01a14073-0882-72ec-97c1-38f56c9f30e2 | €35.00 | €0.50 | matched |
| 54 | capture | 01a14073-15db-7937-a457-d2eae7f8a35f | €49.00 | €0.67 | matched |
| 55 | capture | 01a14073-1837-77e7-8479-7ffc5a3db4bc | €35.00 | €0.50 | matched |
| 56 | capture | 01a14073-3e80-7364-9987-bcc68ef7d6fe | €35.00 | €0.50 | matched |
| 57 | capture | 01a14073-52bf-7e63-a0f9-172621b0805f | €15.00 | €0.26 | matched |
| 58 | capture | 01a14073-5e27-795b-b119-49644dd2e6df | €24.00 | €0.37 | matched |
| 59 | capture | 01a14073-75cd-7860-bae5-c92d70767d4b | €9.00 | €0.19 | matched |
| 60 | capture | 01a14073-9056-709b-8dd8-47915473262e | €15.00 | €0.26 | matched |
| 61 | capture | 01a14073-9c42-7447-af7a-f73f7c92bfd7 | €15.00 | €0.26 | matched |
| 62 | capture | 01a14073-b61e-7ebb-9a00-3a9148148296 | €35.00 | €0.50 | matched |
| 63 | capture | 01a14073-c16d-7168-b199-5d7306f51e64 | €35.00 | €0.50 | matched |
| 64 | capture | 01a14073-e659-7eb4-a4d9-c6436762bb57 | €49.00 | €0.67 | matched |
| 65 | capture | 01a14073-f898-713a-96f4-4de091d329e5 | €9.00 | €0.19 | matched |
| 66 | capture | 01a14073-f9ed-7beb-b24b-501801b5b0be | €9.00 | €0.19 | matched |
| 67 | capture | 01a14074-1515-7272-9c95-604315db3ad1 | €49.00 | €0.67 | matched |
| 68 | capture | 01a14074-1a38-7dbe-8ef0-6d134b4331e5 | €35.00 | €0.50 | matched |
| 69 | capture | 01a14074-2f73-74bd-b802-3dbaed2fb06d | €35.00 | €0.50 | matched |
| 70 | capture | 01a14074-5c06-7ac2-85c5-dc22eff97d32 | €15.00 | €0.26 | matched |
| 71 | capture | 01a14074-65d7-7db4-828a-c367bae222cc | €24.00 | €0.37 | matched |
| 72 | capture | 01a14074-79b8-7861-b6d6-f9f19f9df026 | €9.00 | €0.19 | matched |
| 73 | capture | 01a14074-7b0d-7418-9678-875395374426 | €49.00 | €0.67 | matched |
| 74 | capture | 01a14074-9a49-7c04-b173-417934d90567 | €15.00 | €0.26 | matched |
| 75 | capture | 01a14074-9fbb-7c5a-8aa3-15acfd3c4475 | €24.00 | €0.37 | matched |
| 76 | capture | 01a14074-ec59-7777-81f5-57cbcf2f067f | €49.00 | €0.67 | matched |
| 77 | capture | 01a14075-072a-7289-9416-7435a2c58e4e | €49.00 | €0.67 | matched |
| 78 | capture | 01a14075-2288-7e13-a825-78f4dedb12f1 | €49.00 | €0.67 | matched |
| 79 | capture | 01a14075-425b-71f1-b9e7-53a2f8b89b21 | €15.00 | €0.26 | matched |
| 80 | capture | 01a14075-472b-78b2-ae5a-81560a7f2a2c | €9.00 | €0.19 | matched |
| 81 | capture | 01a14075-4de6-7f00-b9ad-d723785834e0 | €49.00 | €0.67 | matched |
| 82 | capture | 01a14075-5a4a-7dec-896e-5dca4ded0c60 | €35.00 | €0.50 | matched |
| 83 | capture | 01a14075-6b3a-77e8-8f4a-a824f6b829d0 | €15.00 | €0.26 | matched |
| 84 | capture | 01a14075-6bfa-7654-bde0-5027b95e4422 | €35.00 | €0.50 | matched |
| 85 | capture | 01a14075-733b-7ce5-9d74-9ef665474a78 | €24.00 | €0.37 | matched |
| 86 | refund | 01a14075-877a-7536-9f5b-3723a4515633 | -€3.00 | €0.00 | matched |
| 87 | capture | 01a14075-a3a2-7135-a6b8-52d6cd40cd59 | €9.00 | €0.19 | matched |
| 88 | capture | 01a14075-b32f-7e66-89f2-69da04849538 | €35.00 | €0.50 | matched |
| 89 | capture | 01a14075-b7d4-7707-ad2c-007330509d81 | €15.00 | €0.26 | matched |
| 90 | capture | 01a14075-bb70-7454-8425-6b8308f3866f | €9.00 | €0.19 | matched |
| 91 | capture | 01a14075-d932-71a6-a6b5-5ddb7fc5d0b3 | €15.00 | €0.26 | matched |
| 92 | capture | 01a14075-dcc1-76b1-a686-6217b593d247 | €35.00 | €0.50 | matched |
| 93 | capture | 01a14075-efc9-73f7-9550-8fe90f32757e | €24.00 | €0.37 | matched |
| 94 | capture | 01a14075-f4eb-7f34-b18a-90a48fe141fb | €24.00 | €0.37 | matched |
| 95 | capture | 01a14075-ffca-7aa7-a106-b594eea01aba | €49.00 | €0.67 | matched |
| 96 | capture | 01a14076-03e1-7283-a077-33a634c3dbdb | €9.00 | €0.19 | matched |
| 97 | capture | 01a14076-162d-7516-b8b0-da03c56d275a | €9.00 | €0.19 | matched |
| 98 | capture | 01a14076-23d4-7798-ba71-4bbce79ffee6 | €9.00 | €0.19 | matched |
| 99 | capture | 01a14076-2eb0-7e24-bc52-d556f7e6b0da | €15.00 | €0.26 | matched |
| 100 | capture | 01a14076-396e-7ed5-a855-a11664d3f1c4 | €35.00 | €0.50 | matched |
| 101 | capture | 01a14076-3d97-72c8-8654-aafe376539f2 | €35.00 | €0.50 | matched |
| 102 | capture | 01a14076-5815-7182-bda5-0020369b1bb1 | €49.00 | €0.67 | matched |
| 103 | capture | 01a14076-64e7-7989-9ea8-f200733175bd | €35.00 | €0.50 | matched |
| 104 | refund | 01a14076-7350-7c2d-9da6-73abdc876747 | -€5.00 | €0.00 | matched |
| 105 | capture | 01a14076-7664-7e60-9eb8-e5676f993ee5 | €9.00 | €0.19 | matched |
| 106 | capture | 01a14076-8233-71c2-a9a9-3600256e4b3b | €24.00 | €0.37 | matched |
| 107 | capture | 01a14076-9677-7c28-8d65-1a2863a4dfe1 | €49.00 | €0.67 | matched |
| 108 | capture | 01a14076-a836-7949-9a24-ab2cb745ebb0 | €9.00 | €0.19 | matched |
| 109 | capture | 01a14076-bd5c-72a4-8b75-f6482c7237c1 | €35.00 | €0.50 | matched |
| 110 | capture | 01a14076-d3c5-7ae2-99bf-5926e9bcff38 | €9.00 | €0.19 | matched |
| 111 | capture | 01a14076-dea5-767d-846b-fbbddddb68cc | €15.00 | €0.26 | matched |
| 112 | capture | 01a14076-e0ab-7ce8-bfd9-6b0b033aa8d6 | €35.00 | €0.50 | matched |
| 113 | capture | 01a14076-e241-7219-8677-3eee1ad7999e | €24.00 | €0.37 | matched |
| 114 | refund | 01a14077-26ab-7dd0-86b5-d1509aa9ae6b | -€7.00 | €0.00 | matched |
| 115 | capture | 01a14077-2a12-7e66-9584-ea35df289587 | €49.00 | €0.67 | matched |
| 116 | refund | 01a14077-564f-7790-89c9-d281de3f3da3 | -€14.00 | €0.00 | matched |
| 117 | capture | 01a14077-6c49-7c74-8158-3324d0d8f6e3 | €15.00 | €0.26 | matched |
| 118 | capture | 01a14077-947e-7e5f-b181-a8b097c97f47 | €24.00 | €0.37 | matched |
| 119 | capture | 01a14077-a9b8-7813-a948-06f433959aee | €9.00 | €0.19 | matched |
| 120 | capture | 01a14077-c8aa-7273-baac-a1b9f3bef0dd | €24.00 | €0.37 | matched |
| 121 | capture | 01a14077-f011-7f6a-8b90-c5efe9f22a5d | €9.00 | €0.19 | matched |
| 122 | capture | 01a14078-089f-74b6-b93f-f8366af4a9b2 | €24.00 | €0.37 | matched |
| 123 | capture | 01a14078-20e6-782c-b1f9-6228b197a12e | €9.00 | €0.19 | matched |
| 124 | capture | 01a14078-27c6-7b4d-9cde-773c42607d50 | €35.00 | €0.50 | matched |
| 125 | capture | 01a14078-6659-7be0-94a4-1f22c8625628 | €49.00 | €0.67 | matched |
| 126 | capture | 01a14078-7382-75df-87ee-15c3c37a0b20 | €9.00 | €0.19 | matched |