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
- 21 Oct, 10:00145 lines4 breaks
- 21 Oct, 09:50104 lines3 breaks
- 21 Oct, 09:40107 lines1 break
- 21 Oct, 09:30107 lines1 break
- 21 Oct, 09:20123 lines2 breaks
- 21 Oct, 09:10113 lines5 breaks
- 21 Oct, 09:00113 lines2 breaks
- 21 Oct, 08:50139 lines3 breaks
- 21 Oct, 08:40116 lines2 breaks
- 21 Oct, 08:30106 lines2 breaks
- 21 Oct, 08:20136 lines2 breaks
- 21 Oct, 08:10146 lines4 breaks
- 21 Oct, 08:00147 lines3 breaks
- 21 Oct, 07:50145 lines1 break
21 Oct, 08:40
Gross
€2,367.00
PSP fee
€39.00
Net to the bank
€2,328.00
Settlement journal
#120703
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a15da0-a6d3-7e35-a8b7-f9c709516a40 is already settled by stl_EUR_2987620 line 30
- missing linein the books, not in the filecapture:01a15da4-88a3-7efe-b223-571cd275258e is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 31 | capture | 01a15da0-a742-70fd-ac54-7241251e682e | €15.00 | €0.26 | duplicate line |
| 1 | refund | 01a15d9e-0f6d-710d-b69e-f5a9e6946f32 | -€19.00 | €0.00 | matched |
| 2 | capture | 01a15d9e-1f0a-7d25-9792-db2179029bd3 | €24.00 | €0.37 | matched |
| 3 | refund | 01a15d9e-2820-74b7-ab80-5d6442086c30 | -€16.00 | €0.00 | matched |
| 4 | capture | 01a15d9e-335b-7a5b-8ac4-cdb783612d30 | €35.00 | €0.50 | matched |
| 5 | capture | 01a15d9e-4e35-7403-9862-dc69ccf6a38a | €15.00 | €0.26 | matched |
| 6 | capture | 01a15d9e-6b12-771d-b057-deb63f9df188 | €9.00 | €0.19 | matched |
| 7 | refund | 01a15d9e-6f25-7a77-a250-35eae35e60bd | -€29.00 | €0.00 | matched |
| 8 | capture | 01a15d9e-78ea-77fd-8b50-64456aeef014 | €15.00 | €0.26 | matched |
| 9 | capture | 01a15d9e-8497-7e18-875a-c5033891758d | €9.00 | €0.19 | matched |
| 10 | capture | 01a15d9e-92e5-77ef-b70d-8da873965f53 | €9.00 | €0.19 | matched |
| 11 | capture | 01a15d9e-acbd-7435-ac0c-d2689f6f84f2 | €9.00 | €0.19 | matched |
| 12 | capture | 01a15d9e-ae34-7fff-aa0d-4db293751b76 | €24.00 | €0.37 | matched |
| 13 | capture | 01a15d9e-ae47-7a96-acb6-a58226cf2885 | €35.00 | €0.50 | matched |
| 14 | capture | 01a15d9e-d182-74bb-9827-9331e804a29d | €49.00 | €0.67 | matched |
| 15 | capture | 01a15d9e-e65b-7e55-8718-369167dbc4db | €9.00 | €0.19 | matched |
| 16 | capture | 01a15d9e-eeeb-7fe1-a05a-0d5f8e9e5d7e | €35.00 | €0.50 | matched |
| 17 | capture | 01a15d9e-f1dd-71f3-be35-19cc98541693 | €24.00 | €0.37 | matched |
| 18 | capture | 01a15d9e-f3f1-7786-a04b-5014aa0e22f4 | €15.00 | €0.26 | matched |
| 19 | capture | 01a15d9f-4680-7ba0-aa6b-c5d1b148cab8 | €35.00 | €0.50 | matched |
| 20 | capture | 01a15d9f-4aae-793b-ba5c-de4537de8162 | €49.00 | €0.67 | matched |
| 21 | capture | 01a15d9f-6e64-7931-885e-2eae6dc116c1 | €24.00 | €0.37 | matched |
| 22 | refund | 01a15d9f-7190-70b6-a803-e855bcbdf66e | -€10.00 | €0.00 | matched |
| 23 | capture | 01a15d9f-763c-7fe6-942b-680b0b1de157 | €24.00 | €0.37 | matched |
| 24 | capture | 01a15da0-1948-756f-865e-83dc6cb15e34 | €15.00 | €0.26 | matched |
| 25 | capture | 01a15da0-1e76-74c5-8b10-0f7f2805b4ed | €24.00 | €0.37 | matched |
| 26 | capture | 01a15da0-29a4-71d5-9503-bbed7bf32463 | €35.00 | €0.50 | matched |
| 27 | capture | 01a15da0-310b-7315-bdb6-7c469c186a31 | €9.00 | €0.19 | matched |
| 28 | capture | 01a15da0-4e18-75aa-8387-0d7e5ca46f95 | €49.00 | €0.67 | matched |
| 29 | capture | 01a15da0-58f2-787e-83f4-2e1c090cd769 | €35.00 | €0.50 | matched |
| 30 | capture | 01a15da0-a742-70fd-ac54-7241251e682e | €15.00 | €0.26 | matched |
| 32 | capture | 01a15da0-a9ae-7e99-95b7-688914361347 | €15.00 | €0.26 | matched |
| 33 | capture | 01a15da0-c265-7bef-bf66-dfef99f63e46 | €35.00 | €0.50 | matched |
| 34 | capture | 01a15da1-055f-7b71-8d20-d9cd2a5ef811 | €9.00 | €0.19 | matched |
| 35 | capture | 01a15da1-2be0-7972-a22d-108d51a42374 | €35.00 | €0.50 | matched |
| 36 | capture | 01a15da1-6299-74d8-91a8-3ddc4c6c4691 | €24.00 | €0.37 | matched |
| 37 | capture | 01a15da1-6c24-7ab4-a945-00de6e172015 | €24.00 | €0.37 | matched |
| 38 | capture | 01a15da1-805c-7e49-94fb-640dddbaa154 | €35.00 | €0.50 | matched |
| 39 | capture | 01a15da1-a7c8-7313-8573-5be0b0a99e47 | €9.00 | €0.19 | matched |
| 40 | refund | 01a15da1-bf65-7abb-b11d-426b51b7c227 | -€22.00 | €0.00 | matched |
| 41 | capture | 01a15da1-c1ce-7239-92a6-7cc674e454b1 | €15.00 | €0.26 | matched |
| 42 | capture | 01a15da1-c2e8-79a2-b2fc-7f8f2174fb71 | €24.00 | €0.37 | matched |
| 43 | capture | 01a15da1-e8ec-748d-b7e8-59f2b15f4815 | €9.00 | €0.19 | matched |
| 44 | capture | 01a15da2-1c3a-7cca-a37f-4a271cfae227 | €49.00 | €0.67 | matched |
| 45 | capture | 01a15da2-2004-78ab-a9c1-32e83f775d99 | €9.00 | €0.19 | matched |
| 46 | capture | 01a15da2-24a2-7ee9-9b51-2bf5da3270ee | €24.00 | €0.37 | matched |
| 47 | capture | 01a15da2-2fd6-7cc0-b904-4d21724eba73 | €24.00 | €0.37 | matched |
| 48 | capture | 01a15da2-32cd-715e-b48f-c4fa814f89a8 | €24.00 | €0.37 | matched |
| 49 | capture | 01a15da2-3b79-7484-a049-9f6feeaba698 | €9.00 | €0.19 | matched |
| 50 | capture | 01a15da2-41b3-7cd1-9223-91239b7a5152 | €15.00 | €0.26 | matched |
| 51 | capture | 01a15da2-4739-7561-81c8-d3ada2748a5c | €15.00 | €0.26 | matched |
| 52 | capture | 01a15da2-73b2-7aa5-938c-89eb98efceef | €9.00 | €0.19 | matched |
| 53 | capture | 01a15da2-7957-7151-bed7-a60f1a21643c | €49.00 | €0.67 | matched |
| 54 | capture | 01a15da2-81e7-76de-853b-5df65202711a | €49.00 | €0.67 | matched |
| 55 | capture | 01a15da2-83b1-7cfa-8442-9b04a39d0584 | €15.00 | €0.26 | matched |
| 56 | capture | 01a15da2-85fa-7a90-9dc4-5fc4d239978b | €15.00 | €0.26 | matched |
| 57 | capture | 01a15da2-9010-7957-a3f9-65b3962c661e | €9.00 | €0.19 | matched |
| 58 | capture | 01a15da2-9849-72a5-8857-d8ae9b1d1735 | €35.00 | €0.50 | matched |
| 59 | capture | 01a15da2-9b18-78b3-a1ab-b563b319ea29 | €15.00 | €0.26 | matched |
| 60 | capture | 01a15da2-9f12-71f3-bf60-008af58bf0a8 | €49.00 | €0.67 | matched |
| 61 | capture | 01a15da2-e2c1-7783-a53a-7ed6f5d59413 | €24.00 | €0.37 | matched |
| 62 | capture | 01a15da3-11e6-72c1-8159-ddf8623320f9 | €24.00 | €0.37 | matched |
| 63 | capture | 01a15da3-1906-7056-be55-198f4969dc0e | €24.00 | €0.37 | matched |
| 64 | capture | 01a15da3-40ac-7185-be2b-d14b9f285039 | €49.00 | €0.67 | matched |
| 65 | capture | 01a15da3-4539-7275-9b4d-0050220175e4 | €15.00 | €0.26 | matched |
| 66 | capture | 01a15da3-6c2b-73fd-a6de-9219ea629d58 | €49.00 | €0.67 | matched |
| 67 | capture | 01a15da3-6fcb-743f-9434-fb8c7be5cb4b | €15.00 | €0.26 | matched |
| 68 | capture | 01a15da3-9de6-74db-b61d-070ee00d66fd | €9.00 | €0.19 | matched |
| 69 | capture | 01a15da3-9edb-76c2-9702-f38b8da2400f | €15.00 | €0.26 | matched |
| 70 | capture | 01a15da3-aeee-7c48-ac49-51bb38f9ddef | €15.00 | €0.26 | matched |
| 71 | capture | 01a15da3-c20f-787d-a657-fb391cfa5907 | €49.00 | €0.67 | matched |
| 72 | capture | 01a15da3-d81e-7398-96c3-1ef684108905 | €35.00 | €0.50 | matched |
| 73 | capture | 01a15da3-e329-7659-a1ad-5210d52a9fb5 | €9.00 | €0.19 | matched |
| 74 | capture | 01a15da3-d7c1-7abc-bcf8-3b3ecb4047a9 | €24.00 | €0.37 | matched |
| 75 | refund | 01a15da3-fbd4-7023-b060-719f1b1f8907 | -€9.00 | €0.00 | matched |
| 76 | capture | 01a15da4-0e9e-752e-a33f-f6c5a3225b4f | €49.00 | €0.67 | matched |
| 77 | capture | 01a15da4-1557-7c6c-bff1-6eb2f593725a | €15.00 | €0.26 | matched |
| 78 | capture | 01a15da4-2001-7598-87f0-d0e3578761a2 | €15.00 | €0.26 | matched |
| 79 | capture | 01a15da4-3d2f-7d65-9b51-f81c88fc679c | €9.00 | €0.19 | matched |
| 80 | capture | 01a15da4-5839-764f-872a-5e73e3f56886 | €35.00 | €0.50 | matched |
| 81 | capture | 01a15da4-69ca-71a6-a2ab-f1b2be26a665 | €24.00 | €0.37 | matched |
| 82 | capture | 01a15da4-6e1d-7be1-a025-917d654465d9 | €35.00 | €0.50 | matched |
| 83 | capture | 01a15da4-7b26-747e-af82-28b5dbc30b0e | €35.00 | €0.50 | matched |
| 84 | capture | 01a15da4-7de7-79be-b161-554c8126773a | €15.00 | €0.26 | matched |
| 85 | refund | 01a15da4-95c2-73e4-9555-d0bdf8d616be | -€15.00 | €0.00 | matched |
| 86 | capture | 01a15da4-a0ad-7e8d-bf2a-78047d136202 | €9.00 | €0.19 | matched |
| 87 | refund | 01a15da4-a45e-772d-887d-f3e9b0ba5433 | -€5.00 | €0.00 | matched |
| 88 | refund | 01a15da4-b87c-72b2-b614-75361b31ea44 | -€11.00 | €0.00 | matched |
| 89 | capture | 01a15da4-c2d2-796b-adfe-19acc7b3222b | €15.00 | €0.26 | matched |
| 90 | capture | 01a15da4-cc27-73ee-869b-5dbc32baf2a2 | €9.00 | €0.19 | matched |
| 91 | capture | 01a15da4-d701-7f42-bad2-99173130bcc4 | €35.00 | €0.50 | matched |
| 92 | capture | 01a15da4-ec8b-70ab-997f-8dd17281f96b | €49.00 | €0.67 | matched |
| 93 | capture | 01a15da5-1266-71c4-a2d7-d224ec751819 | €9.00 | €0.19 | matched |
| 94 | capture | 01a15da5-2bf0-78ca-bcce-7f01a6745f81 | €24.00 | €0.37 | matched |
| 95 | capture | 01a15da5-3be7-7b5d-88a2-587c2718a046 | €35.00 | €0.50 | matched |
| 96 | capture | 01a15da4-c528-7070-9388-a7b4bc206793 | €24.00 | €0.37 | matched |
| 97 | capture | 01a15da5-6ed1-737f-9017-33eb1a6e69a7 | €24.00 | €0.37 | matched |
| 98 | capture | 01a15da5-8268-777b-92d1-86519bbead28 | €35.00 | €0.50 | matched |
| 99 | capture | 01a15da5-87a5-71eb-b73e-50238a64f991 | €9.00 | €0.19 | matched |
| 100 | capture | 01a15da5-96bd-72dc-bdac-7d326f51b951 | €49.00 | €0.67 | matched |
| 101 | capture | 01a15da5-9b66-7e29-ae93-4f57b5ab92f7 | €9.00 | €0.19 | matched |
| 102 | capture | 01a15da5-bfab-7ab9-8846-4f82145adca1 | €15.00 | €0.26 | matched |
| 103 | capture | 01a15da5-ca20-7393-a73e-4e8bc7fb83d5 | €9.00 | €0.19 | matched |
| 104 | capture | 01a15da5-cb0f-7db7-a330-cdf758d3f33a | €49.00 | €0.67 | matched |
| 105 | capture | 01a15da5-d896-7a8a-9a35-eb4b15e658c4 | €15.00 | €0.26 | matched |
| 106 | capture | 01a15da6-0bc5-79d9-85bf-56fb6349c695 | €15.00 | €0.26 | matched |
| 107 | capture | 01a15da6-217a-72b3-997f-bc956681de98 | €24.00 | €0.37 | matched |
| 108 | capture | 01a15da6-4712-789c-937e-6e47c355da26 | €49.00 | €0.67 | matched |
| 109 | capture | 01a15da6-8928-7563-9326-ea9fae97224b | €24.00 | €0.37 | matched |
| 110 | capture | 01a15da6-9d3a-73c5-b013-3cac92172de8 | €35.00 | €0.50 | matched |
| 111 | capture | 01a15da6-b95c-76de-9f02-cfb07bcbfacd | €35.00 | €0.50 | matched |
| 112 | refund | 01a15da6-f262-7df9-abc4-c01858a6c9b2 | -€28.00 | €0.00 | matched |
| 113 | capture | 01a15da6-f4eb-7502-9177-91c74c0f2a34 | €15.00 | €0.26 | matched |
| 114 | capture | 01a15da6-f6bb-7cce-abb9-1192e8063663 | €15.00 | €0.26 | matched |
| 115 | capture | 01a15da7-06de-7938-977e-170967c92700 | €24.00 | €0.37 | matched |
| 116 | refund | 01a15da7-2dfa-7c91-9d5a-7ec7e26f8b88 | -€9.00 | €0.00 | matched |