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, 05:20149 lines3 breaks
- 17 Oct, 05:10128 lines6 breaks
- 17 Oct, 05:00116 lines4 breaks
- 17 Oct, 04:50117 linesclean
- 17 Oct, 04:40114 lines2 breaks
- 17 Oct, 04:30123 lines1 break
- 17 Oct, 04:20135 lines2 breaks
- 17 Oct, 04:10110 lines4 breaks
- 17 Oct, 04:00115 lines1 break
- 17 Oct, 03:50123 lines1 break
- 17 Oct, 03:40134 linesclean
- 17 Oct, 03:30110 lines1 break
- 17 Oct, 03:20128 lines3 breaks
- 17 Oct, 03:10136 lines3 breaks
17 Oct, 04:20
Gross
€2,685.00
PSP fee
€43.42
Net to the bank
€2,641.58
Settlement journal
#45174
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1481a-a181-77ef-8968-bb42a60662d1 is already settled by stl_EUR_2987018 line 70
- missing linein the books, not in the filecapture:01a14819-dfd3-7865-a2e2-4c8b8d14e13a is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 71 | capture | 01a1481a-a224-7773-8fc4-091a26546b0a | €35.00 | €0.50 | duplicate line |
| 1 | refund | 01a1480d-e90c-7c6d-9d0b-67d73963c9e2 | -€8.00 | €0.00 | matched |
| 2 | capture | 01a14816-8f1f-7429-9add-b6047efa7b5b | €35.00 | €0.50 | matched |
| 3 | capture | 01a14816-9719-73d8-9001-789629d49c4b | €9.00 | €0.19 | matched |
| 4 | capture | 01a14816-af91-7ec6-a21a-a4aa009f92e0 | €24.00 | €0.37 | matched |
| 5 | capture | 01a14816-b78a-70be-8b8c-6cdbf44cef55 | €24.00 | €0.37 | matched |
| 6 | capture | 01a14816-b9bb-7cb7-ade9-89e0bfa6f01d | €24.00 | €0.37 | matched |
| 7 | capture | 01a14816-c30d-73e3-9a78-2dfd4b714392 | €15.00 | €0.26 | matched |
| 8 | capture | 01a14816-c4f1-7637-a334-0ee73ef4536c | €24.00 | €0.37 | matched |
| 9 | capture | 01a14816-c4db-7e82-8407-c4d44ebe0455 | €15.00 | €0.26 | matched |
| 10 | refund | 01a14816-cf46-75a8-9029-e4ea9594d79b | -€3.00 | €0.00 | matched |
| 11 | capture | 01a14816-d5ed-7bd6-8b71-780a173f3a5b | €15.00 | €0.26 | matched |
| 12 | capture | 01a14816-d8f2-7d99-b869-39400c7f5d91 | €49.00 | €0.67 | matched |
| 13 | capture | 01a14816-f34e-737f-84ac-7730a77550a6 | €15.00 | €0.26 | matched |
| 14 | refund | 01a14817-07d3-7fa4-a557-1566d2ab667d | -€9.00 | €0.00 | matched |
| 15 | capture | 01a14817-0f10-770b-bdb7-0f24fb1d06f2 | €15.00 | €0.26 | matched |
| 16 | refund | 01a14817-177c-7ef4-8d75-e95aa640065e | -€12.00 | €0.00 | matched |
| 17 | capture | 01a14817-2b74-72ca-9652-159ce9bb36bc | €15.00 | €0.26 | matched |
| 18 | refund | 01a14817-3164-72f5-8c53-c75a5d64fb55 | -€7.00 | €0.00 | matched |
| 19 | capture | 01a14817-4fc5-71bb-92f8-e4a0e768d59d | €9.00 | €0.19 | matched |
| 20 | capture | 01a14817-53d6-7ff0-817c-d2253af80e1a | €9.00 | €0.19 | matched |
| 21 | capture | 01a14817-70b8-7f04-b0d8-89b7672f4546 | €35.00 | €0.50 | matched |
| 22 | capture | 01a14817-7105-73be-a87c-195203b18f6f | €9.00 | €0.19 | matched |
| 23 | capture | 01a14817-849f-7be3-9136-0e2400fcdcbb | €35.00 | €0.50 | matched |
| 24 | capture | 01a14817-8d10-704b-904c-76cdbbc67a5d | €15.00 | €0.26 | matched |
| 25 | capture | 01a14817-a053-77ef-962a-be96aaf7330e | €9.00 | €0.19 | matched |
| 26 | capture | 01a14817-a19a-7530-8074-f662228b4030 | €9.00 | €0.19 | matched |
| 27 | capture | 01a14817-af11-70d3-870a-cb0f8e3c048f | €15.00 | €0.26 | matched |
| 28 | capture | 01a14817-c10d-79b8-b20b-17aadc9975e7 | €15.00 | €0.26 | matched |
| 29 | capture | 01a14817-c334-71fc-bdf9-7fa1b05323ea | €15.00 | €0.26 | matched |
| 30 | capture | 01a14817-c9da-709c-8c77-c19c699d6eb4 | €15.00 | €0.26 | matched |
| 31 | capture | 01a14817-d8da-7df0-ab85-b147b264415c | €9.00 | €0.19 | matched |
| 32 | capture | 01a14818-0905-7086-b4cf-9b7eed67c1be | €49.00 | €0.67 | matched |
| 33 | refund | 01a14818-0ec7-71f0-b21e-ff0efa2ca16e | -€7.00 | €0.00 | matched |
| 34 | capture | 01a14818-16c8-75ac-be37-b039fee070d6 | €15.00 | €0.26 | matched |
| 35 | capture | 01a14818-3608-7ccf-a2d8-97981fb26409 | €49.00 | €0.67 | matched |
| 36 | capture | 01a14818-52a9-7a79-a080-4e8f864dd374 | €9.00 | €0.19 | matched |
| 37 | capture | 01a14818-57bb-7561-81fd-de2b61a221a1 | €49.00 | €0.67 | matched |
| 38 | capture | 01a14818-6b2c-747f-9290-068ceafccd3e | €49.00 | €0.67 | matched |
| 39 | capture | 01a14818-c17e-7dc3-b88c-43725237abda | €9.00 | €0.19 | matched |
| 40 | capture | 01a14818-d0b4-7e9e-86a7-d215ef54173c | €24.00 | €0.37 | matched |
| 41 | capture | 01a14818-dead-735c-b6eb-048128cd29dd | €49.00 | €0.67 | matched |
| 42 | capture | 01a14819-0440-7abf-9007-35ee89f78e32 | €9.00 | €0.19 | matched |
| 43 | capture | 01a14819-0616-7feb-967b-c51d965e1ce7 | €35.00 | €0.50 | matched |
| 44 | capture | 01a14819-1069-786d-a0e3-8d7aa9dc3130 | €9.00 | €0.19 | matched |
| 45 | capture | 01a14819-18ea-709c-8423-7b7a481b81cd | €35.00 | €0.50 | matched |
| 46 | capture | 01a14819-2299-73b4-81b2-3c59d54e4236 | €9.00 | €0.19 | matched |
| 47 | capture | 01a14819-2764-72cf-8130-231ccd44dd44 | €49.00 | €0.67 | matched |
| 48 | capture | 01a14819-27a1-7c30-b033-ddf1fd256537 | €24.00 | €0.37 | matched |
| 49 | capture | 01a14819-3a52-71b3-ab0d-41474231c506 | €24.00 | €0.37 | matched |
| 50 | capture | 01a14819-3cc6-72c0-bbc8-87b1a569a66b | €9.00 | €0.19 | matched |
| 51 | capture | 01a14819-3f6e-73e5-bd45-f7b4bcc3b9bb | €15.00 | €0.26 | matched |
| 52 | refund | 01a14819-61f2-7277-913d-b048141eadda | -€5.00 | €0.00 | matched |
| 53 | capture | 01a14819-7212-75fc-982e-66fe5951ee27 | €9.00 | €0.19 | matched |
| 54 | capture | 01a14819-741a-7e66-aa00-7893ec213168 | €9.00 | €0.19 | matched |
| 55 | capture | 01a14819-9a3d-7ff2-b938-0e9c44a51ae5 | €9.00 | €0.19 | matched |
| 56 | capture | 01a14819-aaac-7090-b6a7-13c14a01794d | €9.00 | €0.19 | matched |
| 57 | capture | 01a14819-af1c-7294-819e-3cf08373c789 | €15.00 | €0.26 | matched |
| 58 | capture | 01a14819-c4fc-7c9e-a9a4-a5c9273d5057 | €9.00 | €0.19 | matched |
| 59 | capture | 01a14819-dc76-7e32-8317-5569e3014168 | €49.00 | €0.67 | matched |
| 60 | refund | 01a14819-e46e-7e37-a004-df5090eb80fb | -€2.00 | €0.00 | matched |
| 61 | refund | 01a14819-e640-763b-8089-4677f7b5c7a9 | -€5.00 | €0.00 | matched |
| 62 | capture | 01a14819-f2af-7146-a680-2ca278e58377 | €24.00 | €0.37 | matched |
| 63 | capture | 01a14819-feb2-715e-8818-501872300122 | €49.00 | €0.67 | matched |
| 64 | capture | 01a1481a-08b8-7e53-832b-7c57e9336b3e | €15.00 | €0.26 | matched |
| 65 | capture | 01a1481a-2216-731b-9af0-12d548739751 | €49.00 | €0.67 | matched |
| 66 | capture | 01a1481a-4dfb-7574-9c25-ac1d1df3d934 | €9.00 | €0.19 | matched |
| 67 | capture | 01a1481a-8123-721a-b0af-4d500ad1d25d | €15.00 | €0.26 | matched |
| 68 | capture | 01a1481a-8f4b-7b3e-ac6d-5faa0074f4ee | €35.00 | €0.50 | matched |
| 69 | capture | 01a1481a-9fde-70bc-ab44-a9203e3444db | €9.00 | €0.19 | matched |
| 70 | capture | 01a1481a-a224-7773-8fc4-091a26546b0a | €35.00 | €0.50 | matched |
| 72 | capture | 01a1481a-b653-7dc2-a3ce-e60e4ef1ad71 | €9.00 | €0.19 | matched |
| 73 | capture | 01a1481a-d4cc-771f-84e4-68c6758634a8 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1481a-e401-7613-8c6d-23bb198578dc | €9.00 | €0.19 | matched |
| 75 | capture | 01a1481a-f17a-7804-9741-62b41370c43b | €24.00 | €0.37 | matched |
| 76 | capture | 01a1481b-2a5d-7656-a7fd-218462bee190 | €24.00 | €0.37 | matched |
| 77 | capture | 01a1481b-3044-76f4-8fdd-323dfcd927aa | €9.00 | €0.19 | matched |
| 78 | capture | 01a1481b-3d8d-77c0-a54c-ddffb5259b1c | €35.00 | €0.50 | matched |
| 79 | capture | 01a1481b-53bd-7d1c-bd38-be66f7816509 | €24.00 | €0.37 | matched |
| 80 | capture | 01a1481b-844d-72af-8a00-0cc7f715a9d5 | €24.00 | €0.37 | matched |
| 81 | capture | 01a1481b-916e-7fd1-92ef-1692c23e52cc | €49.00 | €0.67 | matched |
| 82 | capture | 01a1481b-9c74-7d3d-826c-09eeae11bb54 | €35.00 | €0.50 | matched |
| 83 | capture | 01a1481b-bd31-78b5-bd0b-2a42cf50293d | €9.00 | €0.19 | matched |
| 84 | capture | 01a1481b-ce56-7892-8da2-61d5933b459b | €24.00 | €0.37 | matched |
| 85 | capture | 01a1481b-d808-79d6-ab7a-5990c028096b | €15.00 | €0.26 | matched |
| 86 | capture | 01a1481b-df5c-79ef-85a3-53f600582224 | €9.00 | €0.19 | matched |
| 87 | capture | 01a1481b-eda3-7e63-9dba-1cfda945f050 | €9.00 | €0.19 | matched |
| 88 | capture | 01a1481b-fc1b-73ac-8f0a-44193db357c0 | €49.00 | €0.67 | matched |
| 89 | capture | 01a1481c-380d-7457-8fd6-5ce180acf2e0 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1481c-8672-78e0-893f-09287598ef7f | €35.00 | €0.50 | matched |
| 91 | capture | 01a1481c-9c47-76ce-a895-b29d582c5fe1 | €15.00 | €0.26 | matched |
| 92 | capture | 01a1481c-bd74-76e7-a54b-23436bfe3297 | €35.00 | €0.50 | matched |
| 93 | capture | 01a1481c-c134-7f84-a62a-cb1adda9e1a5 | €9.00 | €0.19 | matched |
| 94 | capture | 01a1481c-e3db-707f-95f2-f49acea3f52e | €15.00 | €0.26 | matched |
| 95 | capture | 01a1481d-15e4-70c3-8b7a-13cbf13acfb9 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1481d-2071-7ed2-ba31-7432d5a1a673 | €9.00 | €0.19 | matched |
| 97 | capture | 01a1481d-3db7-779f-9990-e14750aaceba | €24.00 | €0.37 | matched |
| 98 | capture | 01a1481d-5ae7-7ed3-bf96-d7abae693a68 | €24.00 | €0.37 | matched |
| 99 | refund | 01a1481d-6b5b-7f0e-b8a3-1921e1a51dc5 | -€22.00 | €0.00 | matched |
| 100 | capture | 01a1481d-742e-7e3f-9c9c-31567f6207f6 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1481d-7591-7bd2-99aa-ac871b779b45 | €35.00 | €0.50 | matched |
| 102 | capture | 01a1481d-7750-7e6d-8821-214b93aaa852 | €35.00 | €0.50 | matched |
| 103 | capture | 01a1481d-9fbd-7964-aa7c-8b8a3df6966f | €24.00 | €0.37 | matched |
| 104 | capture | 01a1481d-af4f-7fb4-901e-2b4109277c81 | €24.00 | €0.37 | matched |
| 105 | capture | 01a1481d-b71d-745a-b3be-290cb267ad9f | €9.00 | €0.19 | matched |
| 106 | capture | 01a1481d-b962-71d3-a8b2-fe243c0d2f3f | €24.00 | €0.37 | matched |
| 107 | capture | 01a1481d-d664-7199-a4c5-cc3508bd2b78 | €9.00 | €0.19 | matched |
| 108 | capture | 01a1481d-e446-742a-9a41-b733fdfdebeb | €24.00 | €0.37 | matched |
| 109 | capture | 01a1481d-ee62-7172-a7dd-c16d32cf4e25 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1481d-ef4c-72f8-90e1-a08c754526d1 | €15.00 | €0.26 | matched |
| 111 | capture | 01a1481d-f5f3-7df6-baa4-a845facc101e | €24.00 | €0.37 | matched |
| 112 | capture | 01a1481e-2c44-78c1-a38f-73eae2c4ffe9 | €49.00 | €0.67 | matched |
| 113 | capture | 01a1481e-3560-7b3c-8e04-6355a51e958c | €24.00 | €0.37 | matched |
| 114 | capture | 01a1481e-47d1-763c-9858-8628a02d14f7 | €35.00 | €0.50 | matched |
| 115 | capture | 01a1481e-5ae4-7f50-85f6-46365df82869 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1481e-6e5a-7461-9827-5ed526a72cf2 | €49.00 | €0.67 | matched |
| 117 | capture | 01a1481e-7042-7576-a049-3170249077d8 | €49.00 | €0.67 | matched |
| 118 | capture | 01a1481e-8459-798e-9fee-3856e5d4aca7 | €9.00 | €0.19 | matched |
| 119 | capture | 01a1481e-9033-7117-b8cb-127e473f0ad5 | €9.00 | €0.19 | matched |
| 120 | capture | 01a1481e-aa79-77e2-b3fb-f645380a9790 | €35.00 | €0.50 | matched |
| 121 | refund | 01a1481e-b29c-73e9-a2f3-aadc190473fa | -€13.00 | €0.00 | matched |
| 122 | capture | 01a1481e-d5d4-70d1-afee-b3ba51c62960 | €24.00 | €0.37 | matched |
| 123 | capture | 01a1481e-e5e3-7f8b-adcd-d7c56ee022b7 | €9.00 | €0.19 | matched |
| 124 | capture | 01a1481f-07fa-7f86-b100-d612636dd59d | €35.00 | €0.50 | matched |
| 125 | capture | 01a1481f-0d05-7438-8661-bce1567df434 | €9.00 | €0.19 | matched |
| 126 | capture | 01a1481f-1244-78f2-b5ab-11693f3c8e64 | €35.00 | €0.50 | matched |
| 127 | capture | 01a1481f-17ac-7f26-ab26-edac0579f895 | €9.00 | €0.19 | matched |
| 128 | capture | 01a1481f-3bd2-7233-b25c-15fd2eb230bf | €15.00 | €0.26 | matched |
| 129 | capture | 01a1481f-56b4-7ed9-a841-ec91fdd6b0ae | €24.00 | €0.37 | matched |
| 130 | capture | 01a1481f-6ca0-731c-bea4-b236e00c3e04 | €9.00 | €0.19 | matched |
| 131 | capture | 01a1481f-75f1-71b4-b161-5b9b153b120c | €15.00 | €0.26 | matched |
| 132 | capture | 01a1481f-7a69-7b72-ab27-8b95e97f99f9 | €9.00 | €0.19 | matched |
| 133 | capture | 01a1481f-9852-7502-957e-83df2053ef47 | €9.00 | €0.19 | matched |
| 134 | capture | 01a1481f-9c13-76b9-aebf-ec0d2463e8fc | €9.00 | €0.19 | matched |
| 135 | capture | 01a1481f-b189-7349-8dbd-85580650bb39 | €24.00 | €0.37 | matched |