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
- 27 Oct, 23:30135 lines2 breaks
- 27 Oct, 23:20141 lines4 breaks
- 27 Oct, 23:10143 lines4 breaks
- 27 Oct, 23:00131 lines2 breaks
- 27 Oct, 22:50134 lines3 breaks
- 27 Oct, 22:40118 lines4 breaks
- 27 Oct, 22:30134 lines6 breaks
- 27 Oct, 22:20108 lines3 breaks
- 27 Oct, 22:10143 lines4 breaks
- 27 Oct, 22:00124 lines3 breaks
- 27 Oct, 21:50115 linesclean
- 27 Oct, 21:40117 lines1 break
- 27 Oct, 21:30131 lines2 breaks
- 27 Oct, 21:20114 lines2 breaks
27 Oct, 22:30
Gross
€3,378.00
PSP fee
€52.74
Net to the bank
€3,325.26
Settlement journal
#240510
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a17f83-e89c-7528-a74c-9e1f155b4b64 is already settled by stl_EUR_2988567 line 115
- fee differencethe fee is not the contract feethe fee is 69, the contract says 67
- fee differencethe fee is not the contract feethe fee is 22, the contract says 19
- fee differencethe fee is not the contract feethe fee is 41, the contract says 37
- fee differencethe fee is not the contract feethe fee is 27, the contract says 26
- missing linein the books, not in the filecapture:01a17f84-ff1c-757f-85f3-d8a72711f557 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 24 | capture | 01a17f7d-a4cc-7aba-a063-72a7afbb43bc | €49.00 | €0.69 | fee difference |
| 103 | capture | 01a17f83-38c2-7931-b064-cdc98b81c842 | €9.00 | €0.22 | fee difference |
| 116 | refund | 01a17f83-e89e-72d8-b7ce-d91eb4025efb | -€3.00 | €0.00 | duplicate line |
| 119 | capture | 01a17f84-0481-7532-be4c-deebbd8552a6 | €24.00 | €0.41 | fee difference |
| 134 | capture | 01a17f85-3737-702a-9b0f-9e3080a994c9 | €15.00 | €0.27 | fee difference |
| 1 | capture | 01a17f75-b1a8-7e95-8ce3-a335c469ce79 | €49.00 | €0.67 | matched |
| 2 | capture | 01a17f78-5326-7479-9324-111905c538d6 | €49.00 | €0.67 | matched |
| 3 | capture | 01a17f79-9e2c-705c-bc5e-1be92e1c8d46 | €15.00 | €0.26 | matched |
| 4 | capture | 01a17f7a-1e29-76e1-8ac2-6986c02decca | €15.00 | €0.26 | matched |
| 5 | capture | 01a17f7a-66e0-7f14-918a-79f5f1ae5c47 | €35.00 | €0.50 | matched |
| 6 | capture | 01a17f7c-156e-7543-bd17-5d4456789467 | €35.00 | €0.50 | matched |
| 7 | refund | 01a17f7c-433f-7bfc-8dfe-b69c6d86078d | -€25.00 | €0.00 | matched |
| 8 | capture | 01a17f7c-48d5-793b-899c-8741492fe7af | €49.00 | €0.67 | matched |
| 9 | capture | 01a17f7c-4c57-72c9-aac8-662851da855a | €49.00 | €0.67 | matched |
| 10 | capture | 01a17f7c-6c38-7abf-a84f-d33ae5996e1c | €35.00 | €0.50 | matched |
| 11 | capture | 01a17f7c-8f11-72f0-b3ff-046cc7fc9554 | €24.00 | €0.37 | matched |
| 12 | capture | 01a17f7c-b349-7810-8665-51e122ad3cc4 | €9.00 | €0.19 | matched |
| 13 | capture | 01a17f7c-eea1-77b8-bc9f-3d5aa7dfb74e | €35.00 | €0.50 | matched |
| 14 | capture | 01a17f7c-f1e2-7c87-8424-0eb7dd5da109 | €15.00 | €0.26 | matched |
| 15 | capture | 01a17f7d-1432-715c-8ae1-2c5061240e08 | €49.00 | €0.67 | matched |
| 16 | capture | 01a17f7d-143b-7805-a835-99141c844aec | €9.00 | €0.19 | matched |
| 17 | capture | 01a17f7d-164d-7bd5-91cf-0e7328ce9671 | €15.00 | €0.26 | matched |
| 18 | capture | 01a17f7d-4564-7dd7-bdb2-8c0330666ecc | €24.00 | €0.37 | matched |
| 19 | refund | 01a17f7d-5929-7e8b-a4aa-d67634610564 | -€9.00 | €0.00 | matched |
| 20 | capture | 01a17f7d-5975-7b3b-9440-9092ccbafd9b | €35.00 | €0.50 | matched |
| 21 | capture | 01a17f7d-75e9-750f-ba58-450bfd2ba669 | €49.00 | €0.67 | matched |
| 22 | capture | 01a17f7d-7ceb-7249-bfce-78290ddd50fc | €24.00 | €0.37 | matched |
| 23 | capture | 01a17f7d-8d11-7585-a419-8dfb4bf8b431 | €24.00 | €0.37 | matched |
| 25 | capture | 01a17f7d-a7d8-798b-a7b2-3d255a952a30 | €35.00 | €0.50 | matched |
| 26 | capture | 01a17f7d-b7e3-7c5d-997f-4d2a6565b34e | €49.00 | €0.67 | matched |
| 27 | capture | 01a17f7d-bd28-76be-9bc2-101f616067fb | €24.00 | €0.37 | matched |
| 28 | refund | 01a17f7d-de68-7550-a884-ca00887065fa | -€30.00 | €0.00 | matched |
| 29 | refund | 01a17f7d-e101-76ac-abb4-52d099bce8e3 | -€19.00 | €0.00 | matched |
| 30 | capture | 01a17f7d-e12c-7772-9efa-80c143a0327d | €9.00 | €0.19 | matched |
| 31 | capture | 01a17f7e-0100-760e-8b60-1555409d08be | €15.00 | €0.26 | matched |
| 32 | capture | 01a17f7e-04d9-7398-ba15-093fd60cfc32 | €24.00 | €0.37 | matched |
| 33 | capture | 01a17f7e-0595-7bbf-bf0b-c89bb514267f | €35.00 | €0.50 | matched |
| 34 | capture | 01a17f7e-3268-79b6-884f-e5e66ed98ff4 | €15.00 | €0.26 | matched |
| 35 | capture | 01a17f7e-33d5-7877-875f-a4ee67e8b165 | €35.00 | €0.50 | matched |
| 36 | refund | 01a17f7e-66e1-752f-8bdf-d53c36bddef3 | -€13.00 | €0.00 | matched |
| 37 | capture | 01a17f7e-69b2-7410-b9c8-d9025cfbc057 | €35.00 | €0.50 | matched |
| 38 | capture | 01a17f7e-83c8-75ff-b6f3-d6d3e8f79665 | €35.00 | €0.50 | matched |
| 39 | refund | 01a17f7e-a0cb-7e9e-b34c-bd60627595aa | -€14.00 | €0.00 | matched |
| 40 | capture | 01a17f7e-aa69-74cf-97a1-fb853c28f31b | €9.00 | €0.19 | matched |
| 41 | capture | 01a17f7e-b8d0-7dff-bbb1-a8d1fe0b82e4 | €49.00 | €0.67 | matched |
| 42 | capture | 01a17f7e-cc09-798a-9444-d5bbea40ac35 | €49.00 | €0.67 | matched |
| 43 | capture | 01a17f7e-d0e3-74f8-b3bd-840e4d0ec2bd | €15.00 | €0.26 | matched |
| 44 | capture | 01a17f7e-e57b-7f8c-8e3c-74a14a6bf90b | €35.00 | €0.50 | matched |
| 45 | capture | 01a17f7e-e9eb-7bf6-94a8-7cbf4e168dc6 | €49.00 | €0.67 | matched |
| 46 | capture | 01a17f7f-04b8-7555-acda-e51e7309a2b1 | €15.00 | €0.26 | matched |
| 47 | refund | 01a17f7f-08d6-7e0e-994c-b89eb943e5ff | -€4.00 | €0.00 | matched |
| 48 | capture | 01a17f7f-273d-7c05-a874-62494969f873 | €24.00 | €0.37 | matched |
| 49 | capture | 01a17f7f-3ac2-76cd-9828-4b503a5a3a70 | €49.00 | €0.67 | matched |
| 50 | capture | 01a17f7f-526e-7db4-8657-fc54143cc061 | €15.00 | €0.26 | matched |
| 51 | capture | 01a17f7f-61c8-7eab-a01c-a4bd89aaa50f | €35.00 | €0.50 | matched |
| 52 | capture | 01a17f7f-9dd4-790a-b01e-26785c8c4c42 | €49.00 | €0.67 | matched |
| 53 | capture | 01a17f7f-ba18-7f75-868b-294e59faf941 | €24.00 | €0.37 | matched |
| 54 | capture | 01a17f7f-e1b5-724e-8d7f-6c4170fb77c7 | €49.00 | €0.67 | matched |
| 55 | capture | 01a17f7f-e3a9-7c30-a479-698bd8eb48ae | €9.00 | €0.19 | matched |
| 56 | capture | 01a17f7f-ec52-77f0-aebb-79fa619108de | €35.00 | €0.50 | matched |
| 57 | capture | 01a17f80-1082-70a3-adb4-22ef7cde0823 | €35.00 | €0.50 | matched |
| 58 | capture | 01a17f80-1401-7bd5-a26a-0c40dae5600b | €49.00 | €0.67 | matched |
| 59 | capture | 01a17f80-21d0-796a-b8de-3d15d883eece | €15.00 | €0.26 | matched |
| 60 | capture | 01a17f80-2435-7a70-b5fa-aadba0be8e62 | €35.00 | €0.50 | matched |
| 61 | capture | 01a17f80-6fb8-78ab-8aa9-7511cbfa83f5 | €9.00 | €0.19 | matched |
| 62 | refund | 01a17f80-a8d6-7068-b661-c81549a6411c | -€9.00 | €0.00 | matched |
| 63 | capture | 01a17f80-c731-76f0-99ed-1674b113b69d | €24.00 | €0.37 | matched |
| 64 | capture | 01a17f80-d871-79f5-a677-c1fe4c137681 | €35.00 | €0.50 | matched |
| 65 | capture | 01a17f80-e4b1-78ab-90d1-ce0967be12d3 | €15.00 | €0.26 | matched |
| 66 | capture | 01a17f80-f253-7f08-85a9-f08f6d9f8158 | €49.00 | €0.67 | matched |
| 67 | capture | 01a17f80-f630-7e7b-a36d-743e49c98e84 | €35.00 | €0.50 | matched |
| 68 | capture | 01a17f80-fdbc-7751-8656-69683d3d6d07 | €49.00 | €0.67 | matched |
| 69 | capture | 01a17f81-0825-739f-a80e-b9391c8fe21c | €35.00 | €0.50 | matched |
| 70 | capture | 01a17f81-09c1-7417-804c-79f33e441a0f | €35.00 | €0.50 | matched |
| 71 | capture | 01a17f81-0c1d-7571-bfdb-6160e409e734 | €49.00 | €0.67 | matched |
| 72 | capture | 01a17f81-1cc4-7963-ac81-c2ca1b10a986 | €15.00 | €0.26 | matched |
| 73 | capture | 01a17f81-1cd3-7734-b100-adcdf9afd5f6 | €9.00 | €0.19 | matched |
| 74 | refund | 01a17f81-2b74-78f8-b84b-f291ac3ad8ab | -€6.00 | €0.00 | matched |
| 75 | capture | 01a17f81-35f5-739f-82aa-1232ea9f8271 | €15.00 | €0.26 | matched |
| 76 | capture | 01a17f81-4baf-753f-b32b-384bc9adf500 | €9.00 | €0.19 | matched |
| 77 | refund | 01a17f81-5182-78da-9afd-014cc2fdcda2 | -€20.00 | €0.00 | matched |
| 78 | capture | 01a17f81-5386-75e5-afa5-99232e074cae | €15.00 | €0.26 | matched |
| 79 | refund | 01a17f81-6fe8-7ed5-af86-37a733306a3a | -€19.00 | €0.00 | matched |
| 80 | capture | 01a17f81-70f3-78a1-9455-8ab418b5007d | €24.00 | €0.37 | matched |
| 81 | capture | 01a17f81-91e4-7184-ad22-fa9d7a0e62ed | €35.00 | €0.50 | matched |
| 82 | capture | 01a17f81-9761-7785-bc00-c8f0920c6231 | €24.00 | €0.37 | matched |
| 83 | capture | 01a17f81-a8aa-713c-849a-ef2632beb4ae | €49.00 | €0.67 | matched |
| 84 | capture | 01a17f81-ee54-7dfe-8632-cb4a5e66c453 | €15.00 | €0.26 | matched |
| 85 | capture | 01a17f82-102d-7fe5-a088-67441ea94b1e | €49.00 | €0.67 | matched |
| 86 | capture | 01a17f82-25f5-76a6-9ec3-1a4be8fdf0ce | €49.00 | €0.67 | matched |
| 87 | capture | 01a17f82-28d0-70e0-998c-f2a7c49c40de | €9.00 | €0.19 | matched |
| 88 | capture | 01a17f82-2ab3-7f30-88a4-d63701636301 | €9.00 | €0.19 | matched |
| 89 | capture | 01a17f82-545f-7f13-8691-d3ff4ab6b6a8 | €35.00 | €0.50 | matched |
| 90 | capture | 01a17f82-58e7-7332-a301-a670e6705340 | €49.00 | €0.67 | matched |
| 91 | capture | 01a17f82-7087-77df-b258-066daeea4987 | €49.00 | €0.67 | matched |
| 92 | capture | 01a17f82-83a4-71c9-a4d2-f5b29998fd30 | €9.00 | €0.19 | matched |
| 93 | refund | 01a17f82-9010-7df3-bafc-8adbdd5a9fbf | -€22.00 | €0.00 | matched |
| 94 | capture | 01a17f82-ac1b-782a-850d-81cdd7150c9b | €15.00 | €0.26 | matched |
| 95 | capture | 01a17f82-b65b-71cc-8ab1-7911b82a5f45 | €49.00 | €0.67 | matched |
| 96 | capture | 01a17f82-d63e-73c5-9acd-44422dfcf910 | €15.00 | €0.26 | matched |
| 97 | capture | 01a17f82-e506-7411-a21d-9e659db96d78 | €49.00 | €0.67 | matched |
| 98 | capture | 01a17f82-e702-7434-966f-2b0c87d9f703 | €24.00 | €0.37 | matched |
| 99 | capture | 01a17f82-e729-760b-a2fd-bae9eeb9e621 | €35.00 | €0.50 | matched |
| 100 | capture | 01a17f82-f300-7ce2-804e-f12c5c2f4b9a | €49.00 | €0.67 | matched |
| 101 | capture | 01a17f83-0b7d-70b1-a856-11cf64ebfad7 | €35.00 | €0.50 | matched |
| 102 | capture | 01a17f83-27de-7b5e-84b3-21ab44c36a0a | €49.00 | €0.67 | matched |
| 104 | capture | 01a17f83-4338-7a6c-be93-16b2290002d6 | €35.00 | €0.50 | matched |
| 105 | capture | 01a17f83-4a64-75f4-8c14-c27227b1f4f6 | €35.00 | €0.50 | matched |
| 106 | capture | 01a17f83-586e-7984-bfa3-797f7204e478 | €9.00 | €0.19 | matched |
| 107 | capture | 01a17f83-634d-7c58-99cd-3139f7e31074 | €49.00 | €0.67 | matched |
| 108 | capture | 01a17f83-83f3-7fae-bd40-53df1e82ec6a | €35.00 | €0.50 | matched |
| 109 | capture | 01a17f83-8ea2-7e0f-a81f-06dfe21eb2fb | €9.00 | €0.19 | matched |
| 110 | capture | 01a17f83-a78d-7896-be3a-30a832c4dd30 | €49.00 | €0.67 | matched |
| 111 | capture | 01a17f83-a95a-70ce-a70c-e1d17724cc63 | €15.00 | €0.26 | matched |
| 112 | capture | 01a17f83-ae3f-7870-9e47-f37bbd4d1d92 | €15.00 | €0.26 | matched |
| 113 | capture | 01a17f83-b701-770a-961b-76aa0dbf8d41 | €9.00 | €0.19 | matched |
| 114 | capture | 01a17f83-e514-7466-90b4-ec0705e2ec68 | €9.00 | €0.19 | matched |
| 115 | refund | 01a17f83-e89e-72d8-b7ce-d91eb4025efb | -€3.00 | €0.00 | matched |
| 117 | refund | 01a17f83-f580-7d22-8c21-7d9d2b3ce897 | -€8.00 | €0.00 | matched |
| 118 | capture | 01a17f84-002a-79e7-9ce8-e05d7665ed71 | €9.00 | €0.19 | matched |
| 120 | capture | 01a17f84-0a9c-7a62-8fdb-f477fd28ccb9 | €49.00 | €0.67 | matched |
| 121 | capture | 01a17f84-2aa3-707c-8dfb-da19fb6f7165 | €49.00 | €0.67 | matched |
| 122 | capture | 01a17f84-2ce0-74b8-86f0-04370d2c8783 | €15.00 | €0.26 | matched |
| 123 | capture | 01a17f84-86c0-77ef-8058-ca5fc88c6a4c | €35.00 | €0.50 | matched |
| 124 | capture | 01a17f84-9454-7562-94c4-73a11544be14 | €49.00 | €0.67 | matched |
| 125 | capture | 01a17f84-a98e-70f3-9382-89bcd9773899 | €15.00 | €0.26 | matched |
| 126 | capture | 01a17f84-b32b-7532-b2cc-31808a2cfe20 | €15.00 | €0.26 | matched |
| 127 | capture | 01a17f84-b41b-72b1-be22-0924be6b7aad | €49.00 | €0.67 | matched |
| 128 | capture | 01a17f84-d196-76ca-9c27-9780c3acac1d | €24.00 | €0.37 | matched |
| 129 | capture | 01a17f84-da4c-736d-a306-3d130cb3b57e | €49.00 | €0.67 | matched |
| 130 | capture | 01a17f84-fa8a-7155-9df8-e4ff75a9c86f | €15.00 | €0.26 | matched |
| 131 | capture | 01a17f84-fea3-71c7-97c5-bbf9453f2268 | €49.00 | €0.67 | matched |
| 132 | capture | 01a17f85-2664-7e2f-83fa-38354078fb49 | €24.00 | €0.37 | matched |
| 133 | capture | 01a17f85-2951-7efb-b270-695d53602125 | €49.00 | €0.67 | matched |