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, 02:30137 lines2 breaks
- 17 Oct, 02:20140 lines1 break
- 17 Oct, 02:10130 lines3 breaks
- 17 Oct, 02:00101 lines1 break
- 17 Oct, 01:5093 lines2 breaks
- 17 Oct, 01:40122 linesclean
- 17 Oct, 01:30131 lines2 breaks
- 17 Oct, 01:20130 lines3 breaks
- 17 Oct, 01:10116 lines4 breaks
- 17 Oct, 01:00130 lines3 breaks
- 17 Oct, 00:50130 lines4 breaks
- 17 Oct, 00:40138 lines4 breaks
- 17 Oct, 00:30131 linesclean
- 17 Oct, 00:20147 lines5 breaks
17 Oct, 00:50
Gross
€3,144.00
PSP fee
€50.57
Net to the bank
€3,093.43
Settlement journal
#42516
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14759-ced6-770f-b7cf-7a5e68340c9f is already settled by stl_EUR_2986997 line 54
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- missing linein the books, not in the filecapture:01a1475a-4652-7c82-9ec0-daa56207c92d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 3 | capture | 01a14755-2958-7f18-a2b3-4fed19d0adcf | €9.00 | €0.24 | fee difference |
| 17 | capture | 01a14757-1d07-7053-9d84-e23b97ca3126 | €24.00 | €0.40 | fee difference |
| 54 | capture | 01a14759-ddf5-7aa2-902d-ef02ae5c046c | €24.00 | €0.40 | fee difference |
| 55 | capture | 01a14759-ddf5-7aa2-902d-ef02ae5c046c | €24.00 | €0.40 | duplicate line |
| 1 | refund | 01a1474d-97bf-7590-a283-0f1aa2fbf9bb | -€27.00 | €0.00 | matched |
| 2 | capture | 01a14752-e2a9-793d-b604-1b8f388f9bf0 | €35.00 | €0.50 | matched |
| 4 | capture | 01a14756-713f-7ab5-8192-7648a5272778 | €35.00 | €0.50 | matched |
| 5 | refund | 01a14756-71d9-717e-91f8-71240cc5e5f2 | -€28.00 | €0.00 | matched |
| 6 | capture | 01a14756-87aa-77db-9128-b3f0af8d9cd6 | €49.00 | €0.67 | matched |
| 7 | capture | 01a14756-8945-7fe3-8bc9-d73bde7fe1ab | €49.00 | €0.67 | matched |
| 8 | capture | 01a14756-90e8-796a-a6a3-f59de88830e9 | €15.00 | €0.26 | matched |
| 9 | capture | 01a14756-9a54-76cf-b024-983ce7def012 | €35.00 | €0.50 | matched |
| 10 | capture | 01a14756-a566-7de3-9ed8-f5ccc4ef51f1 | €35.00 | €0.50 | matched |
| 11 | capture | 01a14756-c528-78ab-abc1-64fdc0c443c5 | €9.00 | €0.19 | matched |
| 12 | capture | 01a14756-c947-704c-ba52-61de7f5e4149 | €15.00 | €0.26 | matched |
| 13 | refund | 01a14756-cf40-7198-ab88-17493da24d55 | -€31.00 | €0.00 | matched |
| 14 | capture | 01a14756-d5a3-7fad-bd71-6ed0c08a2173 | €9.00 | €0.19 | matched |
| 15 | capture | 01a14757-0e82-7695-b315-bfb982758ce0 | €24.00 | €0.37 | matched |
| 16 | capture | 01a14757-1437-7822-8ee8-fe936bebc4ee | €9.00 | €0.19 | matched |
| 18 | capture | 01a14757-2793-7e45-adef-46dc8e122c34 | €15.00 | €0.26 | matched |
| 19 | capture | 01a14757-4628-7fa3-a55b-56b9c30968bd | €35.00 | €0.50 | matched |
| 20 | capture | 01a14757-7e53-7316-a4e6-267c8007fc99 | €15.00 | €0.26 | matched |
| 21 | capture | 01a14757-83c5-7845-8545-322c9d970b4e | €15.00 | €0.26 | matched |
| 22 | capture | 01a14757-71a7-7e9f-af49-7eb724170d4f | €49.00 | €0.67 | matched |
| 23 | capture | 01a14757-96ef-7c56-99ca-57b222ef13e7 | €49.00 | €0.67 | matched |
| 24 | capture | 01a14757-a271-732f-b7e4-c0be9abfb5d1 | €35.00 | €0.50 | matched |
| 25 | capture | 01a14757-ca2b-710f-a573-d19017361811 | €35.00 | €0.50 | matched |
| 26 | capture | 01a14757-e81b-7d5b-8313-826f4a5e37cb | €35.00 | €0.50 | matched |
| 27 | capture | 01a14757-f4f1-750b-a71f-b75857fb3059 | €9.00 | €0.19 | matched |
| 28 | capture | 01a14758-0166-7628-8c95-44b90f6baa7e | €9.00 | €0.19 | matched |
| 29 | capture | 01a14758-0958-7eb4-9244-085cd5b5f732 | €49.00 | €0.67 | matched |
| 30 | capture | 01a14758-2352-7467-b655-09fd1ccb747e | €35.00 | €0.50 | matched |
| 31 | capture | 01a14758-248d-7b1f-b8b5-05f121ba8a8f | €35.00 | €0.50 | matched |
| 32 | capture | 01a14758-349a-74b4-87ec-ff7bb090410c | €9.00 | €0.19 | matched |
| 33 | capture | 01a14758-4c3d-732b-94ab-2e25b455c688 | €49.00 | €0.67 | matched |
| 34 | capture | 01a14758-60f7-77c9-92a8-38e62d5f06ef | €24.00 | €0.37 | matched |
| 35 | capture | 01a14758-6960-75e5-87a9-ad53874654d8 | €15.00 | €0.26 | matched |
| 36 | capture | 01a14758-9738-704c-8e79-6c150d0c09ad | €49.00 | €0.67 | matched |
| 37 | capture | 01a14758-a343-7c7b-8ca5-ff5bedf50fe7 | €35.00 | €0.50 | matched |
| 38 | capture | 01a14758-eb37-7695-8b82-28b8c6811db4 | €15.00 | €0.26 | matched |
| 39 | capture | 01a14758-eca5-7d7f-b0a6-1c8bde3e7bd4 | €49.00 | €0.67 | matched |
| 40 | capture | 01a14758-f989-79a0-bc50-8806a87d7295 | €9.00 | €0.19 | matched |
| 41 | capture | 01a14759-1553-7702-ab65-450e35cf7901 | €49.00 | €0.67 | matched |
| 42 | capture | 01a14759-334e-7e90-b688-d7755f555688 | €24.00 | €0.37 | matched |
| 43 | capture | 01a14759-5023-7e53-ac01-1a6dea1c6823 | €35.00 | €0.50 | matched |
| 44 | capture | 01a14759-51d5-7c1a-98db-baf772c74a51 | €49.00 | €0.67 | matched |
| 45 | capture | 01a14759-5fff-7516-a916-032db6542429 | €15.00 | €0.26 | matched |
| 46 | refund | 01a14759-79b0-7b82-8b5f-2b2907917f4f | -€49.00 | €0.00 | matched |
| 47 | capture | 01a14759-81ae-7bf8-9555-ec3b07f7bec4 | €15.00 | €0.26 | matched |
| 48 | capture | 01a14759-841c-7309-acb8-1062f813d288 | €24.00 | €0.37 | matched |
| 49 | capture | 01a14759-903e-70e5-949a-0494ede2ed1d | €9.00 | €0.19 | matched |
| 50 | capture | 01a14759-9d40-762f-a04f-946336c87f0f | €35.00 | €0.50 | matched |
| 51 | refund | 01a14759-a218-7432-aea1-03e1a0890165 | -€30.00 | €0.00 | matched |
| 52 | capture | 01a14759-a06f-7809-9441-6c69b48ae736 | €24.00 | €0.37 | matched |
| 53 | capture | 01a14759-dc3d-71d1-8e09-9fb1948a5288 | €24.00 | €0.37 | matched |
| 56 | capture | 01a14759-eedc-781e-8cdd-6d47fdb9d0f2 | €35.00 | €0.50 | matched |
| 57 | capture | 01a14759-fe1d-76c6-a43a-a9622e1cd96c | €35.00 | €0.50 | matched |
| 58 | capture | 01a1475a-0025-71c1-9d6c-57e8d5ca8e52 | €24.00 | €0.37 | matched |
| 59 | capture | 01a1475a-0e05-7e82-9752-ee0d5265e76a | €35.00 | €0.50 | matched |
| 60 | capture | 01a1475a-1325-7567-8ca4-bd99cb0cc1fe | €35.00 | €0.50 | matched |
| 61 | capture | 01a1475a-1fb9-7485-ace7-e65d181c3b0a | €35.00 | €0.50 | matched |
| 62 | capture | 01a1475a-251d-7080-bbca-a8b37c3cd7ad | €49.00 | €0.67 | matched |
| 63 | capture | 01a1475a-305b-77f4-b912-1c9446e95824 | €49.00 | €0.67 | matched |
| 64 | capture | 01a1475a-3d25-725d-8bbe-cab553e5f5c0 | €9.00 | €0.19 | matched |
| 65 | refund | 01a1475a-3fad-7338-abbb-6886ae812e11 | -€27.00 | €0.00 | matched |
| 66 | capture | 01a1475a-5bd1-7763-bf6d-f7a9ddaa57f9 | €35.00 | €0.50 | matched |
| 67 | capture | 01a1475a-6945-7d77-bdec-f840e18b6bc3 | €15.00 | €0.26 | matched |
| 68 | capture | 01a1475a-7ae4-7afd-b0a9-a298aa31dcfa | €35.00 | €0.50 | matched |
| 69 | capture | 01a1475a-a746-7179-8bf5-3bc405a913f2 | €9.00 | €0.19 | matched |
| 70 | refund | 01a1475a-bd06-7df5-b9e8-549cd2f7aae1 | -€17.00 | €0.00 | matched |
| 71 | capture | 01a1475a-e76e-7cb6-96f5-aedaf8a415d7 | €15.00 | €0.26 | matched |
| 72 | capture | 01a1475b-1767-7c6e-9366-c01340b7da7b | €9.00 | €0.19 | matched |
| 73 | capture | 01a1475b-1e41-78a3-aff2-e9af4aa93b25 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1475b-2e3c-778c-aa2e-94dd231859b4 | €49.00 | €0.67 | matched |
| 75 | capture | 01a1475b-3d91-7b11-85d5-5920197abf3e | €35.00 | €0.50 | matched |
| 76 | capture | 01a1475b-430b-72e5-97da-6b43fd461a48 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1475b-7f9c-7c6d-925e-cd50508faa71 | €15.00 | €0.26 | matched |
| 78 | capture | 01a1475b-8906-73e0-bd4a-45b8cfadd46e | €15.00 | €0.26 | matched |
| 79 | capture | 01a1475b-ae75-7cf4-a40f-c8d5a23b9f91 | €24.00 | €0.37 | matched |
| 80 | capture | 01a1475b-af21-7bfb-9cfb-8a7272f4bb46 | €35.00 | €0.50 | matched |
| 81 | capture | 01a1475b-c329-7bdd-a593-af78c5037187 | €49.00 | €0.67 | matched |
| 82 | capture | 01a1475b-d05c-71e3-ad5e-30abe942e1f2 | €15.00 | €0.26 | matched |
| 83 | capture | 01a1475b-d09b-7d15-9e03-05d264353588 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1475b-f80a-7153-afe0-c415e1d519ba | €49.00 | €0.67 | matched |
| 85 | capture | 01a1475c-1873-7ea6-a577-6929cde82005 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1475c-2242-7aaa-a5c0-a05500374389 | €24.00 | €0.37 | matched |
| 87 | capture | 01a1475c-443e-731c-b6a4-793d09364183 | €9.00 | €0.19 | matched |
| 88 | capture | 01a1475c-4836-75b7-adbe-a3262e9736c1 | €9.00 | €0.19 | matched |
| 89 | capture | 01a1475c-5505-730d-a2e7-82ef211f2ac4 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1475c-70ba-7d92-90b1-3eef58644cfc | €15.00 | €0.26 | matched |
| 91 | capture | 01a1475c-82aa-755f-ba96-e552c91afece | €35.00 | €0.50 | matched |
| 92 | capture | 01a1475c-9a24-7789-a9f8-bcbc0103dde1 | €35.00 | €0.50 | matched |
| 93 | capture | 01a1475c-af59-7cd6-8562-e4c380a61ccc | €24.00 | €0.37 | matched |
| 94 | capture | 01a1475c-cfeb-761b-b4ee-352fbd616fcd | €49.00 | €0.67 | matched |
| 95 | capture | 01a1475c-d85b-7b6b-92a7-07da645ff958 | €49.00 | €0.67 | matched |
| 96 | capture | 01a1475c-e74e-7818-8660-3e1b8bfe2b4b | €35.00 | €0.50 | matched |
| 97 | refund | 01a1475c-f74b-734a-9c2e-37f022f0d805 | -€10.00 | €0.00 | matched |
| 98 | capture | 01a1475c-fff1-7e71-a135-8455a7ba7d1f | €35.00 | €0.50 | matched |
| 99 | refund | 01a1475d-0b1c-7b81-b9b0-b0540b204c3f | -€14.00 | €0.00 | matched |
| 100 | capture | 01a1475d-0b4d-7627-8f0f-08e3885d3ab8 | €24.00 | €0.37 | matched |
| 101 | capture | 01a1475d-2119-723a-8881-a8cc519d7d29 | €24.00 | €0.37 | matched |
| 102 | capture | 01a1475d-2f27-7c92-972b-a4c7fac0cb9b | €35.00 | €0.50 | matched |
| 103 | capture | 01a1475d-3892-7e13-bcfa-ec8a01667397 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1475d-6cb3-7685-8e01-9f862466aa46 | €15.00 | €0.26 | matched |
| 105 | capture | 01a1475d-7b7e-771f-a1c2-7f6ad440eb1c | €9.00 | €0.19 | matched |
| 106 | capture | 01a1475d-883a-7256-8158-00b43eb25ad1 | €35.00 | €0.50 | matched |
| 107 | capture | 01a1475d-98f9-7bed-81a3-d3f51782adf7 | €15.00 | €0.26 | matched |
| 108 | capture | 01a1475d-a150-7f3d-be15-48706616d848 | €9.00 | €0.19 | matched |
| 109 | capture | 01a1475d-c16d-7411-963c-ec55bba4d2a5 | €9.00 | €0.19 | matched |
| 110 | capture | 01a1475d-c1c4-72a4-897e-558ab04e07b4 | €49.00 | €0.67 | matched |
| 111 | capture | 01a1475d-f1c0-70c5-babf-87310329d463 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1475e-08d6-706f-936f-956eabfb09c8 | €35.00 | €0.50 | matched |
| 113 | capture | 01a1475e-092a-7fde-9234-e0e5f8dc7876 | €9.00 | €0.19 | matched |
| 114 | capture | 01a1475e-14c6-7880-bcdb-4d0b5d1e4a3e | €24.00 | €0.37 | matched |
| 115 | capture | 01a1475e-159e-7d3b-ba89-f0ca77773999 | €24.00 | €0.37 | matched |
| 116 | capture | 01a1475e-2d36-72fc-871d-8e398ea6b4cb | €15.00 | €0.26 | matched |
| 117 | capture | 01a1475e-6f83-743b-8803-ff2627b0241a | €15.00 | €0.26 | matched |
| 118 | capture | 01a1475e-808b-7d78-a743-ccda87fb2b82 | €49.00 | €0.67 | matched |
| 119 | capture | 01a1475e-8bdf-748d-95bc-af35e61e2b17 | €35.00 | €0.50 | matched |
| 120 | capture | 01a1475e-97f9-7730-8a1f-31d1a938fead | €35.00 | €0.50 | matched |
| 121 | capture | 01a1475e-9af3-7d05-b903-6e37faa620f4 | €35.00 | €0.50 | matched |
| 122 | capture | 01a1475e-ad60-7dec-940b-941c812c27cf | €15.00 | €0.26 | matched |
| 123 | capture | 01a1475e-d740-741f-ad24-73667a3fc9c6 | €49.00 | €0.67 | matched |
| 124 | capture | 01a1475e-e8d8-7e00-8eba-64656ddbb4ea | €49.00 | €0.67 | matched |
| 125 | capture | 01a1475e-f78c-7fba-8345-2dc582289ab3 | €15.00 | €0.26 | matched |
| 126 | capture | 01a1475e-f890-760f-ab02-30f49331afa3 | €49.00 | €0.67 | matched |
| 127 | capture | 01a1475e-fe0a-76f2-b294-962eec884ff7 | €24.00 | €0.37 | matched |
| 128 | capture | 01a1475f-1897-73f9-9c1e-f0af37e1d007 | €49.00 | €0.67 | matched |
| 129 | capture | 01a1475f-39ba-77d5-85c6-2775b6214e81 | €35.00 | €0.50 | matched |
| 130 | refund | 01a1475f-599f-7b8c-b206-c8aecbd89630 | -€15.00 | €0.00 | matched |