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
- 19 Oct, 08:30107 linesclean
- 19 Oct, 08:20146 lines4 breaks
- 19 Oct, 08:10119 lines3 breaks
- 19 Oct, 08:00119 lines4 breaks
- 19 Oct, 07:50104 lines3 breaks
- 19 Oct, 07:40127 lines3 breaks
- 19 Oct, 07:30103 lines1 break
- 19 Oct, 07:20129 lines1 break
- 19 Oct, 07:10128 lines2 breaks
- 19 Oct, 07:00128 lines3 breaks
- 19 Oct, 06:50120 linesclean
- 19 Oct, 06:40119 lines4 breaks
- 19 Oct, 06:30124 lines3 breaks
- 19 Oct, 06:20124 lines3 breaks
19 Oct, 07:50
Gross
€2,212.00
PSP fee
€35.89
Net to the bank
€2,176.11
Settlement journal
#83642
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1532b-93a2-7eda-96fb-1f27b89eef96 is already settled by stl_EUR_2987327 line 93
- fee differencethe fee is not the contract feethe fee is 54, the contract says 50
- missing linein the books, not in the filecapture:01a15328-b76c-7000-abca-88216f5fca64 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 32 | capture | 01a15326-96d3-78bc-9354-8be3718a7538 | €35.00 | €0.54 | fee difference |
| 94 | capture | 01a1532b-93be-7185-b1ef-23f574b72677 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1531c-e8ef-7cb9-b4a2-2bed585092ae | €35.00 | €0.50 | matched |
| 2 | refund | 01a15323-972a-769d-b5fc-4829f04be67b | -€47.00 | €0.00 | matched |
| 3 | capture | 01a15323-b69c-79e7-9620-f7099f7006dd | €35.00 | €0.50 | matched |
| 4 | capture | 01a15323-f830-7984-91de-8f27f72d0a6c | €15.00 | €0.26 | matched |
| 5 | capture | 01a15324-4c66-7646-80ce-bfdc9c46d54b | €24.00 | €0.37 | matched |
| 6 | capture | 01a15324-6d38-7e5b-854d-2a2fccd4b2f2 | €15.00 | €0.26 | matched |
| 7 | capture | 01a15324-7204-7081-8e14-fffc55971de4 | €9.00 | €0.19 | matched |
| 8 | capture | 01a15324-7f03-7710-abe7-5f75136d7989 | €9.00 | €0.19 | matched |
| 9 | capture | 01a15324-9f02-77b6-a284-6e252e3e702f | €15.00 | €0.26 | matched |
| 10 | capture | 01a15324-afca-7461-be2e-cea5f8696982 | €9.00 | €0.19 | matched |
| 11 | capture | 01a15324-c8c9-774f-9abb-49ff9131521b | €9.00 | €0.19 | matched |
| 12 | capture | 01a15324-ca52-71c3-a595-2107253100aa | €49.00 | €0.67 | matched |
| 13 | capture | 01a15324-ff37-7c0b-997a-f281beb67b69 | €24.00 | €0.37 | matched |
| 14 | capture | 01a15325-033f-763b-9a6f-97a2cb00f015 | €15.00 | €0.26 | matched |
| 15 | capture | 01a15325-0390-76c3-9d34-7e5a87deb2f8 | €9.00 | €0.19 | matched |
| 16 | capture | 01a15325-13c1-7433-be56-558e7fc9b445 | €24.00 | €0.37 | matched |
| 17 | capture | 01a15325-2596-7141-baac-600099256e8b | €24.00 | €0.37 | matched |
| 18 | refund | 01a15325-3137-7226-8976-33e93b329848 | -€3.00 | €0.00 | matched |
| 19 | capture | 01a15325-3fcc-7abb-a00c-48ab35be6ea8 | €49.00 | €0.67 | matched |
| 20 | capture | 01a15325-85ab-7cb1-b3ee-17cb31e49082 | €35.00 | €0.50 | matched |
| 21 | capture | 01a15325-9f28-7a33-b487-1d2503ce6241 | €15.00 | €0.26 | matched |
| 22 | capture | 01a15325-ccfe-79cb-843e-d1d5460661a1 | €35.00 | €0.50 | matched |
| 23 | capture | 01a15325-d3b6-7fda-b8cc-aa9645ed8f1e | €49.00 | €0.67 | matched |
| 24 | capture | 01a15325-dae5-7f20-a20c-03bbb9a1a0a0 | €9.00 | €0.19 | matched |
| 25 | capture | 01a15325-eb5b-71a3-8fbd-14fb9a4dbea1 | €24.00 | €0.37 | matched |
| 26 | capture | 01a15326-2368-7c1a-8044-3ad06d2ec244 | €9.00 | €0.19 | matched |
| 27 | capture | 01a15326-5ec4-71ac-bb8c-d2b6b9b86b4d | €35.00 | €0.50 | matched |
| 28 | capture | 01a15326-723e-768f-8b66-ce06bf89269c | €9.00 | €0.19 | matched |
| 29 | capture | 01a15326-824c-7728-b682-93a31acdc5c4 | €49.00 | €0.67 | matched |
| 30 | capture | 01a15326-90cb-7ebf-8694-2289cc7dfa50 | €49.00 | €0.67 | matched |
| 31 | capture | 01a15326-95e3-701f-943b-5b79eea39644 | €24.00 | €0.37 | matched |
| 33 | capture | 01a15326-bfeb-7d3c-a03e-3dd4b579b878 | €24.00 | €0.37 | matched |
| 34 | capture | 01a15326-d663-7bd6-a299-56e841a90edf | €35.00 | €0.50 | matched |
| 35 | refund | 01a15326-e088-7348-ad25-2d2ab130b147 | -€5.00 | €0.00 | matched |
| 36 | capture | 01a15326-e6ed-7e34-a4e6-e9dcb2e53cb6 | €9.00 | €0.19 | matched |
| 37 | capture | 01a15327-25cc-7f18-bebe-54cc01f1a039 | €49.00 | €0.67 | matched |
| 38 | capture | 01a15327-3392-7e06-a1c7-0ea738a0f91b | €24.00 | €0.37 | matched |
| 39 | capture | 01a15327-5985-7ca1-964d-e1164ef38c5f | €15.00 | €0.26 | matched |
| 40 | capture | 01a15327-6ef5-774d-8e6d-ea2b5f85938b | €24.00 | €0.37 | matched |
| 41 | capture | 01a15327-8539-7659-9ea8-a58275abf896 | €35.00 | €0.50 | matched |
| 42 | capture | 01a15327-89e5-7deb-aa5d-8e54ce5ddfbb | €9.00 | €0.19 | matched |
| 43 | refund | 01a15327-907e-7122-b034-9b1e97ef8e68 | -€24.00 | €0.00 | matched |
| 44 | capture | 01a15327-96c2-76a7-84c4-4101a0d88934 | €9.00 | €0.19 | matched |
| 45 | capture | 01a15327-9ea9-7bae-b185-fc24ef56ac23 | €49.00 | €0.67 | matched |
| 46 | capture | 01a15327-a601-7593-bfbd-91dc26f139f9 | €49.00 | €0.67 | matched |
| 47 | refund | 01a15327-d923-7031-9593-0af0903249a2 | -€3.00 | €0.00 | matched |
| 48 | capture | 01a15328-0d17-7366-bc11-c9a9e50e9547 | €49.00 | €0.67 | matched |
| 49 | capture | 01a15328-1837-7d8e-9e18-1b8a01b0b2fc | €9.00 | €0.19 | matched |
| 50 | capture | 01a15328-2713-76ec-aa42-50a32ec2de45 | €9.00 | €0.19 | matched |
| 51 | capture | 01a15328-616a-72f7-aed5-d329f5bef085 | €24.00 | €0.37 | matched |
| 52 | capture | 01a15328-741b-74f9-9862-61bb07db8491 | €24.00 | €0.37 | matched |
| 53 | capture | 01a15328-7778-7e0f-a87a-0866e2176801 | €35.00 | €0.50 | matched |
| 54 | capture | 01a15328-8097-7a96-b39c-89d46a44b078 | €9.00 | €0.19 | matched |
| 55 | capture | 01a15328-8524-7bfc-a436-b914f70856f9 | €15.00 | €0.26 | matched |
| 56 | capture | 01a15328-b686-77db-bddf-50a98285b5a6 | €15.00 | €0.26 | matched |
| 57 | capture | 01a15328-c43e-7eaa-8a06-38449be8198c | €35.00 | €0.50 | matched |
| 58 | capture | 01a15328-c56d-7771-ad0e-c7e20312eb82 | €49.00 | €0.67 | matched |
| 59 | capture | 01a15328-e154-792d-935e-b923c784cb86 | €49.00 | €0.67 | matched |
| 60 | capture | 01a15329-3138-778b-b058-d2ac89fb034b | €15.00 | €0.26 | matched |
| 61 | capture | 01a15329-3587-73c9-a149-9e1c0ee0abfb | €24.00 | €0.37 | matched |
| 62 | capture | 01a15329-373f-735f-905c-3db282c59cd5 | €9.00 | €0.19 | matched |
| 63 | capture | 01a15329-40aa-767d-bc77-5603a87b9f05 | €49.00 | €0.67 | matched |
| 64 | capture | 01a15329-48aa-7451-afea-d6b5bd6b7a5e | €24.00 | €0.37 | matched |
| 65 | capture | 01a15329-5fd8-7f46-bb15-c71207c9bda6 | €15.00 | €0.26 | matched |
| 66 | capture | 01a15329-686b-7d4b-87c0-28fd1e541090 | €49.00 | €0.67 | matched |
| 67 | capture | 01a15329-7014-7004-848e-0187089d5172 | €9.00 | €0.19 | matched |
| 68 | capture | 01a15329-88c1-7ff3-a84c-bfb58191049c | €9.00 | €0.19 | matched |
| 69 | capture | 01a15329-8c0a-79a9-84af-e72c4b578cf4 | €15.00 | €0.26 | matched |
| 70 | capture | 01a15329-9fa4-737e-9ad7-21b925c11829 | €9.00 | €0.19 | matched |
| 71 | refund | 01a15329-d561-76a0-b2dc-48d66e9c1e00 | -€23.00 | €0.00 | matched |
| 72 | capture | 01a15329-d649-7dfe-9cfc-8d04f29ab21c | €9.00 | €0.19 | matched |
| 73 | refund | 01a15329-e5f5-7e5e-8cd6-fdc3cbd0a428 | -€4.00 | €0.00 | matched |
| 74 | capture | 01a15329-ed4c-7073-ac54-8d6100e89c84 | €9.00 | €0.19 | matched |
| 75 | capture | 01a15329-ee0a-706a-b532-b23ca08b10dc | €9.00 | €0.19 | matched |
| 76 | capture | 01a15329-f876-779f-8935-435288b87620 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1532a-36d2-7161-8944-53191404a1c4 | €15.00 | €0.26 | matched |
| 78 | capture | 01a1532a-4b8e-7779-b98d-0a135a252f38 | €35.00 | €0.50 | matched |
| 79 | capture | 01a1532a-4cc3-73a6-a2ab-99b51443ec06 | €15.00 | €0.26 | matched |
| 80 | capture | 01a1532a-6463-7157-9e78-7855617a39f9 | €15.00 | €0.26 | matched |
| 81 | capture | 01a1532a-9862-79a2-8794-5e89344205eb | €35.00 | €0.50 | matched |
| 82 | capture | 01a1532a-c802-7898-a097-c747014e24b3 | €15.00 | €0.26 | matched |
| 83 | refund | 01a1532a-d395-711e-a812-c91ba110eac0 | -€13.00 | €0.00 | matched |
| 84 | capture | 01a1532a-d0a3-739c-9402-2a97c72697bd | €15.00 | €0.26 | matched |
| 85 | capture | 01a1532a-dd7a-7033-8cce-18e5dc723c7c | €15.00 | €0.26 | matched |
| 86 | capture | 01a1532a-eee2-7b58-b483-4cfe4627ab5e | €35.00 | €0.50 | matched |
| 87 | capture | 01a1532b-065f-7ead-9a7b-c5ec14a16ac9 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1532b-1b3c-7e8f-a9b7-6f68ff11cb42 | €35.00 | €0.50 | matched |
| 89 | capture | 01a1532b-1b54-7d4c-b405-217a59598b30 | €15.00 | €0.26 | matched |
| 90 | capture | 01a1532b-4aef-7195-a066-c169a5da6485 | €24.00 | €0.37 | matched |
| 91 | capture | 01a1532b-6482-7024-b9a4-2882daab7004 | €35.00 | €0.50 | matched |
| 92 | capture | 01a1532b-6871-7d3f-819a-d6c80ef4db59 | €24.00 | €0.37 | matched |
| 93 | capture | 01a1532b-93be-7185-b1ef-23f574b72677 | €49.00 | €0.67 | matched |
| 95 | capture | 01a1532b-be01-70af-bbf3-094591dd79e5 | €35.00 | €0.50 | matched |
| 96 | capture | 01a1532b-c037-77c7-b4c8-d0d4899ed47a | €15.00 | €0.26 | matched |
| 97 | capture | 01a1532b-c3e9-700b-bd7f-526817897daf | €24.00 | €0.37 | matched |
| 98 | capture | 01a1532b-e4aa-7fbb-a0db-bcf6d0bfd683 | €15.00 | €0.26 | matched |
| 99 | refund | 01a1532b-f276-71ea-bdae-82b9bffaa894 | -€11.00 | €0.00 | matched |
| 100 | capture | 01a1532b-fc8c-7931-8181-80f1309e7be6 | €24.00 | €0.37 | matched |
| 101 | capture | 01a1532b-fe86-744c-90d2-8661cb2d4458 | €15.00 | €0.26 | matched |
| 102 | capture | 01a1532c-00be-7970-b478-4c274253c386 | €35.00 | €0.50 | matched |
| 103 | capture | 01a1532c-287e-7742-8783-3db3e57d423b | €24.00 | €0.37 | matched |
| 104 | capture | 01a1532c-64e9-7ea9-8a96-167e8ab73d4c | €15.00 | €0.26 | matched |