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
- 14 Oct, 20:10122 linesclean
- 14 Oct, 20:00119 lines1 break
- 14 Oct, 19:50128 lines2 breaks
- 14 Oct, 19:40134 linesclean
- 14 Oct, 19:30133 lines1 break
- 14 Oct, 19:20107 lines1 break
- 14 Oct, 19:10124 lines6 breaks
- 14 Oct, 19:00124 lines3 breaks
- 14 Oct, 18:50115 lines1 break
- 14 Oct, 18:40117 lines5 breaks
- 14 Oct, 18:30125 lines3 breaks
- 14 Oct, 18:20125 lines4 breaks
- 14 Oct, 18:10124 lines2 breaks
- 14 Oct, 18:00140 lines3 breaks
14 Oct, 17:40
Gross
€2,788.00
PSP fee
€44.23
Net to the bank
€2,743.77
Settlement journal
#270
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13b81-7a34-76f3-ab4e-5c65922b0d60 is already settled by stl_EUR_2986666 line 21
- duplicate linethe file lists it twicecapture:01a13b84-cdb0-71de-9eb4-0c115eef2c5c is already settled by stl_EUR_2986666 line 73
- missing linein the books, not in the filecapture:01a13b80-184b-7f47-b0f7-3c4245cd6911 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 22 | capture | 01a13b81-935f-76d2-a926-31eab80758c4 | €49.00 | €0.67 | duplicate line |
| 74 | capture | 01a13b84-ce01-703a-b50b-f8401c98f71d | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a13b7a-4e73-76bb-adf9-aee8da35d7be | €9.00 | €0.19 | matched |
| 2 | capture | 01a13b7f-250f-7742-84cd-e88780d2f690 | €35.00 | €0.50 | matched |
| 3 | capture | 01a13b7f-ee9b-72a6-bfe5-036ddea984f4 | €15.00 | €0.26 | matched |
| 4 | capture | 01a13b7f-fa96-7f2c-902b-821e7695e5d1 | €15.00 | €0.26 | matched |
| 5 | capture | 01a13b80-0df7-7fbf-816f-a21d3b68138d | €35.00 | €0.50 | matched |
| 6 | capture | 01a13b80-1457-738c-b144-74ca866380df | €15.00 | €0.26 | matched |
| 7 | capture | 01a13b80-2425-7ece-96ee-e22e0f6e3d48 | €9.00 | €0.19 | matched |
| 8 | capture | 01a13b80-706f-75b1-820c-4e51c4f09187 | €15.00 | €0.26 | matched |
| 9 | capture | 01a13b80-730a-762b-892a-e6a7ff2dff3f | €24.00 | €0.37 | matched |
| 10 | capture | 01a13b80-9d26-7331-8d8a-57257d27b0a3 | €24.00 | €0.37 | matched |
| 11 | capture | 01a13b80-9fe7-7b8c-ac7c-a91f10b1bcdc | €49.00 | €0.67 | matched |
| 12 | capture | 01a13b80-b875-7abb-93e9-c300e58c8061 | €24.00 | €0.37 | matched |
| 13 | refund | 01a13b80-d3f8-7959-b93e-e7bddf1ea792 | -€12.00 | €0.00 | matched |
| 14 | capture | 01a13b80-e341-75b4-9144-d42adbdbe710 | €15.00 | €0.26 | matched |
| 15 | capture | 01a13b81-1e64-77e1-bc01-553b83ad4a81 | €49.00 | €0.67 | matched |
| 16 | capture | 01a13b81-5995-71ad-99e3-f87dd1597a8b | €9.00 | €0.19 | matched |
| 17 | capture | 01a13b81-5aa8-7ef4-b5b4-79b2c7635325 | €15.00 | €0.26 | matched |
| 18 | capture | 01a13b81-5e47-7557-b527-024050fa82b7 | €9.00 | €0.19 | matched |
| 19 | capture | 01a13b81-6b4f-7765-8590-4fc3c7c64058 | €9.00 | €0.19 | matched |
| 20 | capture | 01a13b81-8591-74a9-a410-aca1ac1286ac | €24.00 | €0.37 | matched |
| 21 | capture | 01a13b81-935f-76d2-a926-31eab80758c4 | €49.00 | €0.67 | matched |
| 23 | capture | 01a13b81-9735-7b9b-8864-5ecb738854cd | €9.00 | €0.19 | matched |
| 24 | capture | 01a13b81-a7ac-76a7-a8b1-c014d82459cf | €49.00 | €0.67 | matched |
| 25 | refund | 01a13b81-b7f5-7319-89a0-eab18109777b | -€4.00 | €0.00 | matched |
| 26 | refund | 01a13b81-c9d4-7a44-9abe-07c8b7d46615 | -€3.00 | €0.00 | matched |
| 27 | capture | 01a13b81-f58d-7489-91d2-682cc9caa05b | €35.00 | €0.50 | matched |
| 28 | capture | 01a13b82-1d61-7460-a04d-5b2b0c220fe4 | €49.00 | €0.67 | matched |
| 29 | capture | 01a13b82-1d20-71de-bb74-b13284b3a2ab | €35.00 | €0.50 | matched |
| 30 | capture | 01a13b82-2cca-78c0-9cb8-efbbfd67596a | €49.00 | €0.67 | matched |
| 31 | capture | 01a13b82-3dec-71c1-b870-2515cdb5707a | €24.00 | €0.37 | matched |
| 32 | capture | 01a13b82-3efa-7b1e-a352-f427d3cf74e4 | €9.00 | €0.19 | matched |
| 33 | capture | 01a13b82-3fe4-7db1-a05c-b3cc06bd2759 | €24.00 | €0.37 | matched |
| 34 | capture | 01a13b82-5087-7fe2-90eb-9d2f3a83bb40 | €49.00 | €0.67 | matched |
| 35 | capture | 01a13b82-5386-7ebb-8b2a-bec1083749fa | €9.00 | €0.19 | matched |
| 36 | capture | 01a13b82-6464-744a-b1ab-b06d58eacf61 | €35.00 | €0.50 | matched |
| 37 | capture | 01a13b82-6658-7ecd-b1f2-063c8dafe47b | €15.00 | €0.26 | matched |
| 38 | capture | 01a13b82-71df-7403-95ab-971e90f83f6d | €35.00 | €0.50 | matched |
| 39 | refund | 01a13b82-b2bc-70ca-8c65-a6e870be98c4 | -€9.00 | €0.00 | matched |
| 40 | capture | 01a13b82-bcec-7470-b360-76c5f20c0d31 | €9.00 | €0.19 | matched |
| 41 | capture | 01a13b82-bed9-787e-9c11-dd57d5528462 | €24.00 | €0.37 | matched |
| 42 | capture | 01a13b82-beba-7715-94c7-bed81edead1c | €9.00 | €0.19 | matched |
| 43 | capture | 01a13b82-bc1d-75fa-9e9e-df4e6c589b4d | €24.00 | €0.37 | matched |
| 44 | capture | 01a13b82-ebee-756d-b641-79ca2f896cb0 | €15.00 | €0.26 | matched |
| 45 | capture | 01a13b82-ebf5-7682-ba67-6a936e50ceae | €35.00 | €0.50 | matched |
| 46 | capture | 01a13b83-4f07-712b-9d78-b18205db717b | €35.00 | €0.50 | matched |
| 47 | capture | 01a13b83-879b-7349-bf4e-6303df217c60 | €35.00 | €0.50 | matched |
| 48 | capture | 01a13b83-9259-7407-8491-b72be0bfff63 | €49.00 | €0.67 | matched |
| 49 | capture | 01a13b83-9ebd-70f7-9c90-d8a4478e03ab | €9.00 | €0.19 | matched |
| 50 | capture | 01a13b83-b377-758e-9dda-c64ed6efc31b | €15.00 | €0.26 | matched |
| 51 | capture | 01a13b83-bcc8-7860-b2e3-d411ca31cf41 | €35.00 | €0.50 | matched |
| 52 | capture | 01a13b83-bd17-7e60-bbb4-ca0caac58a8e | €15.00 | €0.26 | matched |
| 53 | capture | 01a13b83-bff8-713c-ac6f-3058f96fc512 | €24.00 | €0.37 | matched |
| 54 | capture | 01a13b83-c284-7f92-952e-b73dd42c9887 | €9.00 | €0.19 | matched |
| 55 | capture | 01a13b83-d981-7b4d-b23b-23047a8ef359 | €24.00 | €0.37 | matched |
| 56 | capture | 01a13b83-d9ee-7fc6-9fa5-67e414a84c31 | €24.00 | €0.37 | matched |
| 57 | capture | 01a13b83-c98c-7c1a-9654-6b7d451435e3 | €9.00 | €0.19 | matched |
| 58 | capture | 01a13b83-ee00-7eb9-92c2-4f6e3dc12bc5 | €9.00 | €0.19 | matched |
| 59 | capture | 01a13b83-f4b6-7040-b8d0-b1d0a057df4a | €9.00 | €0.19 | matched |
| 60 | capture | 01a13b84-32a8-7017-b32e-6c7f3c579456 | €49.00 | €0.67 | matched |
| 61 | capture | 01a13b84-37b5-73d2-aaa4-3a84d960e90b | €49.00 | €0.67 | matched |
| 62 | capture | 01a13b84-54aa-7ac3-a019-47a65bbeef91 | €35.00 | €0.50 | matched |
| 63 | capture | 01a13b84-5858-790e-bc84-b5b6d8b9a306 | €35.00 | €0.50 | matched |
| 64 | capture | 01a13b84-5e8e-75cf-ad1d-d085e0f8899b | €24.00 | €0.37 | matched |
| 65 | capture | 01a13b84-682e-7c4d-9c88-b2b80e799a08 | €24.00 | €0.37 | matched |
| 66 | capture | 01a13b84-68eb-71ec-959b-b3fdaa951c44 | €24.00 | €0.37 | matched |
| 67 | capture | 01a13b84-6d56-7713-9cc7-537577d5089a | €9.00 | €0.19 | matched |
| 68 | capture | 01a13b84-6e46-7078-9221-4e829d762a95 | €9.00 | €0.19 | matched |
| 69 | capture | 01a13b84-84f4-7872-a981-32815ad70638 | €35.00 | €0.50 | matched |
| 70 | capture | 01a13b84-9863-7875-9282-5ffaad43315b | €35.00 | €0.50 | matched |
| 71 | capture | 01a13b84-bcbe-7742-88a3-6a956f27aa87 | €15.00 | €0.26 | matched |
| 72 | capture | 01a13b84-ca58-755d-8ea1-b345247ceffb | €9.00 | €0.19 | matched |
| 73 | capture | 01a13b84-ce01-703a-b50b-f8401c98f71d | €9.00 | €0.19 | matched |
| 75 | capture | 01a13b84-e8d4-7d70-af82-d649dba74f86 | €9.00 | €0.19 | matched |
| 76 | capture | 01a13b85-0e3f-7e06-8cd6-0ac9fd82797c | €49.00 | €0.67 | matched |
| 77 | capture | 01a13b85-38a6-76d4-8dcf-3be6dc4a0a39 | €15.00 | €0.26 | matched |
| 78 | capture | 01a13b85-48f6-7eec-bd48-110c9b70f5fb | €9.00 | €0.19 | matched |
| 79 | capture | 01a13b85-4c88-7a60-9008-6fe367a9d12e | €9.00 | €0.19 | matched |
| 80 | capture | 01a13b85-62fa-77c8-912e-544008a7e27f | €35.00 | €0.50 | matched |
| 81 | capture | 01a13b85-8066-79f2-9521-b75ff6758e1f | €15.00 | €0.26 | matched |
| 82 | capture | 01a13b85-b2b9-7ff2-9dec-f02ed4ed2004 | €15.00 | €0.26 | matched |
| 83 | capture | 01a13b85-d0b3-776e-9f85-124e29ed932e | €24.00 | €0.37 | matched |
| 84 | capture | 01a13b85-fb97-7bae-95ff-1c220ec91688 | €15.00 | €0.26 | matched |
| 85 | capture | 01a13b86-2c94-70b3-95b9-445b05e83027 | €35.00 | €0.50 | matched |
| 86 | capture | 01a13b86-2f4e-75df-a14d-62a595499a2f | €9.00 | €0.19 | matched |
| 87 | capture | 01a13b86-39bb-7006-8a39-7dff2fd9f961 | €35.00 | €0.50 | matched |
| 88 | capture | 01a13b86-4767-74cd-a2fa-08178f186e5a | €49.00 | €0.67 | matched |
| 89 | capture | 01a13b86-5dd0-7eb9-9220-dfea962b7b3a | €24.00 | €0.37 | matched |
| 90 | capture | 01a13b86-6062-756e-bf6b-b1eed74aae9f | €35.00 | €0.50 | matched |
| 91 | capture | 01a13b86-78b6-7cfd-9ad9-41c448dfa762 | €24.00 | €0.37 | matched |
| 92 | capture | 01a13b86-7d8e-70c5-9bc3-773d76b52b13 | €15.00 | €0.26 | matched |
| 93 | capture | 01a13b86-abbb-774a-9ff0-eeadcfdc62bc | €15.00 | €0.26 | matched |
| 94 | capture | 01a13b86-ac4a-7379-839e-5963f50d5097 | €15.00 | €0.26 | matched |
| 95 | capture | 01a13b86-c6cf-7fe8-b5e5-3d49d06c6a91 | €9.00 | €0.19 | matched |
| 96 | capture | 01a13b86-f591-7895-aeb1-767c226fbd16 | €9.00 | €0.19 | matched |
| 97 | capture | 01a13b86-f7c9-7050-93ed-9b3f4a6d83b2 | €15.00 | €0.26 | matched |
| 98 | capture | 01a13b86-ff83-7f24-be67-9971012ad013 | €35.00 | €0.50 | matched |
| 99 | capture | 01a13b87-023f-7bb8-b33d-84031fbc2f89 | €15.00 | €0.26 | matched |
| 100 | capture | 01a13b87-1bf4-77f2-9b7d-12a850479a2b | €24.00 | €0.37 | matched |
| 101 | refund | 01a13b87-36ef-71e6-80f6-f0b9111dc78a | -€10.00 | €0.00 | matched |
| 102 | refund | 01a13b87-3b7e-7931-9e84-645af5c96f84 | -€8.00 | €0.00 | matched |
| 103 | capture | 01a13b87-6de5-73b7-9d9c-3eb9c7410bac | €35.00 | €0.50 | matched |
| 104 | capture | 01a13b87-70b2-79b1-bf42-a82cab886b61 | €9.00 | €0.19 | matched |
| 105 | capture | 01a13b87-7781-7d23-b17b-22a16344ec4d | €35.00 | €0.50 | matched |
| 106 | capture | 01a13b87-a040-7fd6-bcda-67df3b6faae1 | €24.00 | €0.37 | matched |
| 107 | capture | 01a13b87-e31f-7048-bd11-9424edc6d154 | €24.00 | €0.37 | matched |
| 108 | capture | 01a13b87-f4d4-732e-a249-49ca64dca723 | €15.00 | €0.26 | matched |
| 109 | refund | 01a13b87-f5fe-7f1d-a1ed-32c5f1a96fa8 | -€17.00 | €0.00 | matched |
| 110 | capture | 01a13b87-fb85-7d22-b619-dcc814f58260 | €24.00 | €0.37 | matched |
| 111 | capture | 01a13b88-0e52-7b71-a684-ace9ef72986d | €49.00 | €0.67 | matched |
| 112 | capture | 01a13b88-0f06-770a-ae08-67ab014df704 | €49.00 | €0.67 | matched |
| 113 | capture | 01a13b88-2437-7270-b093-7a04443530fd | €24.00 | €0.37 | matched |
| 114 | capture | 01a13b88-29ea-7e18-b907-e562c7fa00ab | €24.00 | €0.37 | matched |
| 115 | refund | 01a13b88-50ed-75df-98d6-9d127699ad3f | -€15.00 | €0.00 | matched |
| 116 | capture | 01a13b88-62e3-777e-9b9b-8b0cded59f71 | €35.00 | €0.50 | matched |
| 117 | capture | 01a13b88-6690-78a2-9d1d-c75ee9a2d8f2 | €9.00 | €0.19 | matched |
| 118 | capture | 01a13b88-6a81-7632-b57f-76455542281c | €15.00 | €0.26 | matched |
| 119 | capture | 01a13b88-7365-7af5-8401-0666900e5d7d | €49.00 | €0.67 | matched |
| 120 | capture | 01a13b88-7aa8-7880-9b93-57406e9170ba | €9.00 | €0.19 | matched |
| 121 | capture | 01a13b88-7c4f-7804-a981-43617a36e9e3 | €24.00 | €0.37 | matched |
| 122 | capture | 01a13b88-9e2e-7cb6-b2f0-950235e26a36 | €24.00 | €0.37 | matched |
| 123 | capture | 01a13b88-a022-7004-9a33-7e292e191c5f | €49.00 | €0.67 | matched |
| 124 | capture | 01a13b88-a8b0-7007-939d-267282383d72 | €35.00 | €0.50 | matched |
| 125 | capture | 01a13b88-bc05-7d8e-bd69-1dffba835d5d | €49.00 | €0.67 | matched |
| 126 | capture | 01a13b88-cb14-71c0-a95f-51557894be0e | €9.00 | €0.19 | matched |
| 127 | refund | 01a13b88-e5de-75c6-9515-76552700873f | -€21.00 | €0.00 | matched |