Car Wash Ledger

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

2 Nov, 16:40

Gross

€2,730.00

PSP fee

€42.38

Net to the bank

€2,687.62

Settlement journal

#345972

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a19d27-e444-7fe9-ab01-836b38d401db is already settled by stl_EUR_2989396 line 77
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
LineKindReferenceGrossFeeStatus
78refund01a19d27-e447-76e8-a6b6-5bcc0818a295-€19.00€0.00duplicate line
86capture01a19d28-34a3-7cb4-81ff-700e831b1bc3€35.00€0.55fee difference
1refund01a19d1b-13e8-7161-a304-6beab2e6a3e7-€33.00€0.00matched
2capture01a19d1f-3395-79bd-b431-2a029f2b00ff€35.00€0.50matched
3capture01a19d1f-49c9-708a-b0cb-cad86acc3b21€15.00€0.26matched
4capture01a19d21-cede-78ad-9538-b5031a6bd11c€15.00€0.26matched
5capture01a19d22-09da-7f41-acd5-d6780d9a7418€24.00€0.37matched
6capture01a19d22-1b94-7911-bbcd-fd8de331e3dd€24.00€0.37matched
7capture01a19d22-2752-7327-a819-790dad5d4e9c€9.00€0.19matched
8capture01a19d22-28f1-717a-83d5-3e3835bb3c00€15.00€0.26matched
9capture01a19d22-2dd4-7991-a92b-1a60f8374287€9.00€0.19matched
10capture01a19d22-3c7d-728d-8153-b56f7a4a3735€24.00€0.37matched
11capture01a19d22-3d4f-742f-87bc-ef36ca5ecb79€9.00€0.19matched
12capture01a19d22-49a3-7512-8cd0-73cf515c3bcb€35.00€0.50matched
13capture01a19d22-6791-7dc6-9075-4d5d7adb81ed€9.00€0.19matched
14capture01a19d22-6dbd-7968-8f6c-bd6b4822749f€49.00€0.67matched
15capture01a19d22-b1fb-700f-bfa5-a0900e362d2b€35.00€0.50matched
16capture01a19d22-d757-77a9-86da-eeade85e16da€49.00€0.67matched
17capture01a19d22-eb34-74f0-96a0-9b8da9ec15c9€49.00€0.67matched
18capture01a19d22-fcaa-76f4-890a-9aa71d5f1e0d€24.00€0.37matched
19capture01a19d23-26d4-7b79-9472-8bea88ce499e€24.00€0.37matched
20capture01a19d23-2da9-76a3-b04e-f840b58cc735€49.00€0.67matched
21capture01a19d23-6b10-750b-b398-6bd6719f4085€15.00€0.26matched
22capture01a19d23-9344-722f-b3f2-8ea43df27c74€35.00€0.50matched
23capture01a19d23-c656-7cf7-bb2e-b73b873eee63€49.00€0.67matched
24capture01a19d23-cf6c-7c55-b673-2dfd02e6195e€15.00€0.26matched
25capture01a19d23-cff5-74de-a905-780fb3996293€9.00€0.19matched
26capture01a19d23-ef5a-7c53-9ff6-ccd4482c6ba9€35.00€0.50matched
27capture01a19d24-0e9c-7e39-96e0-997191679826€9.00€0.19matched
28capture01a19d24-1c30-7243-acc7-7c161117339f€35.00€0.50matched
29refund01a19d24-1ce3-7fcd-8d2e-97799a8690c6-€7.00€0.00matched
30capture01a19d24-1e5b-725d-97e4-a53c730270d7€9.00€0.19matched
31capture01a19d24-1fe8-73e5-bae4-2583c48f40c3€24.00€0.37matched
32capture01a19d24-38a7-7e34-836f-a66bdfd825ac€35.00€0.50matched
33capture01a19d24-4cf6-79d5-ac05-0a8731e6b82e€49.00€0.67matched
34capture01a19d24-55e8-74fe-9795-c6429fa83cb7€9.00€0.19matched
35capture01a19d24-6553-77b0-8466-ce6b3d68a247€35.00€0.50matched
36capture01a19d24-6e76-701a-8113-ef6f5167c5f2€49.00€0.67matched
37capture01a19d24-7981-7b8c-b38c-b868969782a7€49.00€0.67matched
38capture01a19d24-8bbb-7565-9824-ccd14ad0e409€15.00€0.26matched
39capture01a19d24-9082-704f-a358-b85cbb4898b1€9.00€0.19matched
40capture01a19d24-a464-79cc-a866-643c7eca2827€15.00€0.26matched
41capture01a19d24-a573-7c32-ba71-9be9ad88bfb9€15.00€0.26matched
42capture01a19d24-b910-7e67-9f18-4accaad138f4€9.00€0.19matched
43capture01a19d24-ed8d-7d50-82be-0026e65e121d€15.00€0.26matched
44capture01a19d25-3026-787a-9794-bd69122e19e5€15.00€0.26matched
45capture01a19d25-3685-7f1f-9033-28526dc9604a€35.00€0.50matched
46capture01a19d25-3fc9-778b-8244-4d246e0b50d4€35.00€0.50matched
47capture01a19d25-984b-7805-b85a-cda0523c3cd7€35.00€0.50matched
48capture01a19d25-a4da-7193-8d51-c1a2f239ed1f€24.00€0.37matched
49capture01a19d25-aa98-7ebf-bea8-68a3670aa8e9€35.00€0.50matched
50capture01a19d25-b9d1-74c4-bfe1-f0f7d2ea73f7€35.00€0.50matched
51capture01a19d25-baf3-713f-a7da-7c62f407a18f€35.00€0.50matched
52capture01a19d25-d404-7745-8c8f-cd337f8047f3€35.00€0.50matched
53capture01a19d25-dafa-7f62-8ef1-9fa94bafce9e€24.00€0.37matched
54capture01a19d26-12c8-7858-a43b-2092b81d9757€35.00€0.50matched
55capture01a19d26-1f7c-7591-847d-632f781eec4b€35.00€0.50matched
56capture01a19d26-4c09-7158-93b3-d736b7804386€35.00€0.50matched
57capture01a19d26-53f9-7f94-821b-41917d4d3137€49.00€0.67matched
58capture01a19d26-5b2e-779b-abce-586b42d6af47€9.00€0.19matched
59capture01a19d26-6df4-7ea4-ad97-ba54361c3efa€9.00€0.19matched
60capture01a19d26-784a-7b18-8e60-1100f5ee9260€49.00€0.67matched
61capture01a19d26-786c-7f01-bea7-256628a0cf52€9.00€0.19matched
62capture01a19d26-7c05-7d10-b4ef-91f3589ed70f€9.00€0.19matched
63capture01a19d26-855b-77d5-b18b-2b29c9c6cbf9€35.00€0.50matched
64capture01a19d26-909b-7b38-9afe-e167ba727a94€35.00€0.50matched
65capture01a19d26-924b-767e-ac29-6d7efd7f7937€15.00€0.26matched
66capture01a19d26-9fc9-74cf-805d-af9b64e98bc1€15.00€0.26matched
67capture01a19d26-cc6a-7c2a-89e4-ba2cb48ba30d€9.00€0.19matched
68capture01a19d27-0d2c-7742-96a2-aef46f2cddd8€49.00€0.67matched
69capture01a19d27-282c-7dc0-ae00-c28d14b8b3e7€35.00€0.50matched
70capture01a19d27-5a08-78b0-b7b0-7a567d8e5646€9.00€0.19matched
71capture01a19d27-7354-7c9f-b7ef-e258b4af61fa€9.00€0.19matched
72capture01a19d27-7760-7971-849e-d4183e521074€49.00€0.67matched
73capture01a19d27-9215-749a-b2ed-48d14cb716a8€24.00€0.37matched
74capture01a19d27-b416-7354-ba00-584974aacfaa€15.00€0.26matched
75capture01a19d27-b617-7483-b049-008847b3e338€24.00€0.37matched
76capture01a19d27-b847-7046-93c8-17188361af0b€35.00€0.50matched
77refund01a19d27-e447-76e8-a6b6-5bcc0818a295-€19.00€0.00matched
79capture01a19d27-e563-7634-9764-21bb3e15b884€49.00€0.67matched
80capture01a19d28-03a4-7b7a-b87e-723b737f0b2d€49.00€0.67matched
81capture01a19d28-077f-77dc-a34b-766724237d46€24.00€0.37matched
82capture01a19d28-08d9-7499-97b1-e542704c4587€35.00€0.50matched
83capture01a19d28-16d8-72f5-a33c-23ca854f54a1€35.00€0.50matched
84capture01a19d28-1a33-744c-8993-d240a8b9986d€24.00€0.37matched
85capture01a19d28-2871-788f-9d54-6e09f77c8b1b€9.00€0.19matched
87capture01a19d28-4e0e-7997-9ce8-595bf64da52a€49.00€0.67matched
88capture01a19d28-78de-77ba-8786-4621d3dfe336€9.00€0.19matched
89capture01a19d28-7c6e-773d-8cc3-3ccf075605a8€49.00€0.67matched
90capture01a19d28-87a6-7f74-af60-c465a9fde905€49.00€0.67matched
91capture01a19d28-95a8-7b2f-b789-7443dbb266f0€35.00€0.50matched
92refund01a19d28-b463-77a5-bb2d-92f66019b859-€5.00€0.00matched
93capture01a19d28-ff89-715a-8fd8-9d8e4244c205€35.00€0.50matched
94capture01a19d29-0c8a-70b4-8e4b-504b7678a230€24.00€0.37matched
95capture01a19d29-0d74-7365-94ea-bb03721dc2fb€35.00€0.50matched
96capture01a19d29-305f-7939-8859-bf370057f420€9.00€0.19matched
97capture01a19d29-4112-71da-8a79-a56d362e489e€49.00€0.67matched
98capture01a19d29-5e3a-7f27-8207-a370c82c4266€35.00€0.50matched
99capture01a19d29-5f25-7c10-a6bd-2b6042b088b3€49.00€0.67matched
100refund01a19d29-6526-73b7-8726-b1b60004e618-€5.00€0.00matched
101capture01a19d29-6628-716b-bed7-ac93b2cccc3d€24.00€0.37matched
102capture01a19d29-92a5-7674-8e46-47f8fbabf94a€9.00€0.19matched
103capture01a19d29-aa05-77c3-8921-668c1374ce1c€9.00€0.19matched
104capture01a19d29-c548-73d0-9536-53937e08e3e4€15.00€0.26matched
105capture01a19d29-cb21-7d26-a59f-2692b5de1635€15.00€0.26matched
106capture01a19d2a-8a2e-7fdb-b5e4-820bcf7c6d18€15.00€0.26matched
107capture01a19d2a-8e4f-73ba-a051-8e06ad8e0a53€24.00€0.37matched
108capture01a19d2a-bc2e-7e66-a350-5ff239dc596a€15.00€0.26matched
109capture01a19d2a-c34f-738a-bc6e-941cf31e775d€35.00€0.50matched
110capture01a19d2a-dfbd-7a1b-81d3-d56e4cba619a€9.00€0.19matched
111capture01a19d2a-efec-72f7-ab62-1c389c9d7793€15.00€0.26matched