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

4 Nov, 07:20

Gross

€3,028.00

PSP fee

€46.99

Net to the bank

€2,981.01

Settlement journal

#375384

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a56f-d934-7c29-a585-54a112918e1c is already settled by stl_EUR_2989628 line 32
  • duplicate linethe file lists it twicerefund:01a1a572-68e6-7d0e-b071-616e35bdaebd is already settled by stl_EUR_2989628 line 67
  • duplicate linethe file lists it twicecapture:01a1a572-c399-7cfe-aff1-e1b57b6ba4a8 is already settled by stl_EUR_2989628 line 70
  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • missing linein the books, not in the filecapture:01a1a56e-9356-7a9b-8e3e-2dcdcb8fc090 is in no file
LineKindReferenceGrossFeeStatus
33capture01a1a56f-d961-76e3-88b8-3c6b8c32a7c5€24.00€0.37duplicate line
63capture01a1a572-24be-757d-b404-e2118640ddb7€24.00€0.38fee difference
68refund01a1a572-68e8-70f5-98cb-550cf3599533-€8.00€0.00duplicate line
71capture01a1a572-c3b9-74d4-8ee4-eb4225f89162€9.00€0.19duplicate line
1capture01a1a566-82a9-76bc-a785-0210586cb5c6€15.00€0.26matched
2capture01a1a56a-91d2-7003-a984-24f3770d14d3€24.00€0.37matched
3capture01a1a56a-c623-72ca-bb17-e08a3ba33366€15.00€0.26matched
4capture01a1a56d-def8-755a-84fa-417e315921c5€15.00€0.26matched
5capture01a1a56d-eebd-70eb-8eee-ef02c80d53d8€49.00€0.67matched
6capture01a1a56d-fb2e-7f51-bcac-332288c5fe4b€49.00€0.67matched
7capture01a1a56e-125a-7d37-bc81-150b4fb32c4c€35.00€0.50matched
8capture01a1a56e-176f-777d-8cbf-ebc0a320f9d9€35.00€0.50matched
9capture01a1a56e-27c0-7603-b04d-79bd3cb92eba€15.00€0.26matched
10capture01a1a56e-3e09-7207-92d7-85e471e13206€49.00€0.67matched
11capture01a1a56e-3e4d-7f93-87e1-11005eed7879€9.00€0.19matched
12capture01a1a56e-4673-7eda-8102-3fa5b07ead21€35.00€0.50matched
13capture01a1a56e-6521-7a3b-a408-2068e1d2cf99€35.00€0.50matched
14capture01a1a56e-8de9-7d5f-9529-f84643a10385€15.00€0.26matched
15capture01a1a56e-927e-7455-aa02-905ae015d625€24.00€0.37matched
16capture01a1a56e-c8ee-7eae-9bd9-c5f9e0cf5e0b€9.00€0.19matched
17capture01a1a56e-ca5d-7d56-9c1e-1032ed2ca714€35.00€0.50matched
18capture01a1a56e-e414-7264-ae40-695dd20883f2€15.00€0.26matched
19capture01a1a56f-19c4-7291-8d35-870f81e24696€35.00€0.50matched
20capture01a1a56f-2caf-75df-85d8-b04cd74178ec€15.00€0.26matched
21capture01a1a56f-3b3a-76fa-9e19-0bae427a09b8€49.00€0.67matched
22capture01a1a56f-3b8b-7266-b161-b0a18629a1dd€35.00€0.50matched
23capture01a1a56f-4118-7baa-b971-02c265f69b14€35.00€0.50matched
24capture01a1a56f-743b-7fe8-8722-af3f18d697ff€35.00€0.50matched
25refund01a1a56f-a191-7d9e-b511-2cd07652d6c2-€22.00€0.00matched
26capture01a1a56f-a446-742c-9ee7-723b923389e1€35.00€0.50matched
27capture01a1a56f-ab43-7f70-a390-cc99552e67e2€49.00€0.67matched
28capture01a1a56f-bcfd-7bc2-aeb6-a5a5cc367ddf€35.00€0.50matched
29capture01a1a56f-c475-79f9-bcca-f9955baebcfa€24.00€0.37matched
30capture01a1a56f-ca65-7d45-a7da-bcf0a58cf7c8€49.00€0.67matched
31capture01a1a56f-d419-72c1-84e0-23f924416099€35.00€0.50matched
32capture01a1a56f-d961-76e3-88b8-3c6b8c32a7c5€24.00€0.37matched
34capture01a1a56f-da56-7c01-918d-efb16ab70175€49.00€0.67matched
35capture01a1a56f-e235-7bf4-91c1-9b2c01ad7c95€35.00€0.50matched
36capture01a1a56f-f94b-7bab-b98f-953df67870a3€9.00€0.19matched
37capture01a1a570-051d-7b18-a021-6ee3c28cdb94€49.00€0.67matched
38capture01a1a570-1269-7f98-9139-afc73bf78e51€35.00€0.50matched
39capture01a1a570-36f1-7d64-94ef-4850513ddf34€15.00€0.26matched
40refund01a1a570-3c47-79d0-8afe-fe03e8077ded-€30.00€0.00matched
41capture01a1a570-4404-7bc3-8729-f5719bd10114€24.00€0.37matched
42capture01a1a570-6f79-7832-84d3-844baf400b86€49.00€0.67matched
43capture01a1a570-7c30-7be8-8f5a-7a6656ea504d€9.00€0.19matched
44capture01a1a570-86ee-7cef-83cc-2b3d6e850fc7€35.00€0.50matched
45capture01a1a570-9c17-70f9-ae5d-fb463f75648b€9.00€0.19matched
46capture01a1a570-bdb3-768f-ba82-a2e79dafc3da€24.00€0.37matched
47capture01a1a570-be3f-7dde-a02d-a54f59f5cf9a€9.00€0.19matched
48capture01a1a570-cbb6-7f05-8664-f8823d345cc5€15.00€0.26matched
49capture01a1a570-eaba-7d25-8141-2a4a110bf938€24.00€0.37matched
50capture01a1a570-e712-781b-8bb7-594685a22051€49.00€0.67matched
51capture01a1a571-1521-75a3-ba8d-2172daca34d1€9.00€0.19matched
52capture01a1a571-2314-7376-be92-9ca177b97d39€49.00€0.67matched
53capture01a1a571-526f-7f87-87a9-1d8ce797e9ab€15.00€0.26matched
54capture01a1a571-6974-73f8-9046-81b7b83105f4€9.00€0.19matched
55capture01a1a571-7474-724b-a346-b7f8012e43d5€15.00€0.26matched
56capture01a1a571-79a8-74b9-90fb-944eaf8dfa4c€24.00€0.37matched
57refund01a1a571-864b-7df6-b99d-527f6ef151ff-€13.00€0.00matched
58capture01a1a571-8f48-7f54-a246-0d0976f84848€24.00€0.37matched
59capture01a1a571-a55b-7204-8e16-962087075702€24.00€0.37matched
60capture01a1a571-df2e-7046-bd09-8211bc6b0b2e€49.00€0.67matched
61capture01a1a572-02be-7927-a657-b53038fecf6b€9.00€0.19matched
62capture01a1a572-0faf-7ea0-9e7f-7bdad5f48af9€35.00€0.50matched
64capture01a1a572-273e-79d1-8f55-7c6ac3859174€49.00€0.67matched
65capture01a1a572-2ce2-7120-be53-f19efc5c3b07€9.00€0.19matched
66capture01a1a572-4ae6-7524-a870-064a0560bc8e€15.00€0.26matched
67refund01a1a572-68e8-70f5-98cb-550cf3599533-€8.00€0.00matched
69capture01a1a572-87b7-7e54-8e8a-6709837fd77f€49.00€0.67matched
70capture01a1a572-c3b9-74d4-8ee4-eb4225f89162€9.00€0.19matched
72capture01a1a572-e3f7-733b-9192-94f259414f8f€15.00€0.26matched
73refund01a1a573-1eb5-7082-bac1-bd3c477885d9-€6.00€0.00matched
74capture01a1a573-9036-7f47-8aa3-d0c40f3a4801€24.00€0.37matched
75capture01a1a573-b717-7aa4-a496-8d2e9dbf3388€49.00€0.67matched
76capture01a1a573-cb5c-7f7a-8c1d-49d1b830ce7a€35.00€0.50matched
77capture01a1a573-d949-75cf-a214-55b4156b1994€49.00€0.67matched
78capture01a1a573-dfe8-725c-beff-b04f56cefe07€49.00€0.67matched
79capture01a1a574-3d6a-7d27-9705-4f91906f3e09€35.00€0.50matched
80capture01a1a574-46cd-7040-8077-a82635e9bd3a€49.00€0.67matched
81capture01a1a574-53c3-70fb-b146-72152b5a8060€24.00€0.37matched
82capture01a1a574-79aa-78cf-857d-1c7b80e6bdc9€49.00€0.67matched
83capture01a1a574-7c8c-7768-9763-5a4294989737€49.00€0.67matched
84capture01a1a574-9042-7e26-97b0-26e52b9308a3€35.00€0.50matched
85capture01a1a574-a674-767c-9ee6-02729452471a€24.00€0.37matched
86capture01a1a574-bbb4-73bd-af9f-f15af3329a10€49.00€0.67matched
87capture01a1a574-c11c-7189-ba7d-8d19f3418e86€15.00€0.26matched
88refund01a1a574-d12c-756f-bd20-4962ff3a4859-€10.00€0.00matched
89capture01a1a574-d46a-7c46-bd36-e1aa6ba15091€9.00€0.19matched
90capture01a1a574-dd12-701f-afd0-88ad832791b6€24.00€0.37matched
91capture01a1a574-e21f-7c13-90b7-645c86b292e9€35.00€0.50matched
92capture01a1a574-f36d-7d98-a452-fa5463805c34€24.00€0.37matched
93capture01a1a574-f53a-73a4-a494-b1cc7fde81ee€35.00€0.50matched
94capture01a1a574-f96d-7eb9-a8b1-415cc3470ce7€9.00€0.19matched
95refund01a1a575-0be6-79c9-8302-1d1465b832d9-€38.00€0.00matched
96capture01a1a575-1598-7311-92e8-28e3122a2444€9.00€0.19matched
97capture01a1a575-29f1-75af-bf08-6b2ba1b107f5€49.00€0.67matched
98capture01a1a575-283a-7327-b1d1-2af3a7f8f6c2€15.00€0.26matched
99capture01a1a575-33c2-7f80-97c2-c4daacf5b3f0€24.00€0.37matched
100capture01a1a575-4545-7d75-bc2c-fd570903a627€9.00€0.19matched
101capture01a1a575-5700-7fa3-8352-5bc068478f0a€24.00€0.37matched
102capture01a1a575-78ea-79cd-9202-cbcd22090a90€24.00€0.37matched
103capture01a1a575-9381-7aa5-adb7-860430408412€9.00€0.19matched
104capture01a1a575-a6ef-7e96-9197-a45db4d792c4€49.00€0.67matched
105capture01a1a575-c118-774c-991f-537f92c42c72€49.00€0.67matched
106capture01a1a575-f507-7d58-94c3-6127ee50c077€24.00€0.37matched
107capture01a1a575-f965-7310-b98f-488b18ce7f77€49.00€0.67matched
108capture01a1a576-06d2-7f0f-9d6e-40de34341726€24.00€0.37matched
109capture01a1a576-1153-7958-ade4-7f095f24b933€49.00€0.67matched
110capture01a1a576-1827-7637-8050-55c0351a3889€24.00€0.37matched
111capture01a1a576-3523-79d8-8e23-e583defd5c90€24.00€0.37matched
112capture01a1a576-3760-7023-a447-6732d925ad95€9.00€0.19matched
113capture01a1a576-5f37-7197-91d6-e9e706981cff€24.00€0.37matched
114capture01a1a576-8765-70e8-beb8-c51324219be7€24.00€0.37matched
115capture01a1a576-b53d-7662-b071-32ebcfa6f929€35.00€0.50matched
116capture01a1a576-b73d-7fd2-8257-95fda7e63286€49.00€0.67matched
117capture01a1a576-c3c0-7506-ac5f-963006742761€15.00€0.26matched
118capture01a1a576-c692-7059-8e02-29c563db3ccf€35.00€0.50matched
119capture01a1a576-e4c2-7dd7-91fe-b4840b9e4907€9.00€0.19matched