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

3 Nov, 16:10

Gross

€3,428.00

PSP fee

€53.53

Net to the bank

€3,374.47

Settlement journal

#363917

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a234-9b8a-7d29-8ea0-bc5803340858 is already settled by stl_EUR_2989537 line 118
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
LineKindReferenceGrossFeeStatus
63capture01a1a230-a492-7991-8b5b-382087eab72b€49.00€0.68fee difference
119capture01a1a234-9bc1-7f0c-b31f-b2843afcdca6€49.00€0.67duplicate line
1refund01a1a226-0d58-7562-8ae1-9f24ad16ba93-€14.00€0.00matched
2capture01a1a226-c6c1-7163-a4f7-23e74324527e€35.00€0.50matched
3capture01a1a22c-b703-7701-8e67-5a11ea4378c7€15.00€0.26matched
4capture01a1a22c-b848-7b89-8393-4553d5caf4d3€49.00€0.67matched
5capture01a1a22c-bb7e-7163-a8c6-28b158c59f31€15.00€0.26matched
6refund01a1a22c-c08c-72f1-b633-b9110418ada6-€3.00€0.00matched
7capture01a1a22c-c8a6-7334-b4ca-cbcae6aadfb1€35.00€0.50matched
8refund01a1a22c-cbba-700e-92ef-5f6869df5b5c-€7.00€0.00matched
9capture01a1a22c-ce61-789b-ac52-471e453f295d€9.00€0.19matched
10capture01a1a22c-d544-77b6-8b1a-d9da470b1568€24.00€0.37matched
11capture01a1a22d-0c07-7be4-9da1-e3feee8ddfaf€49.00€0.67matched
12capture01a1a22d-16e4-783d-a3d2-190a9d2f1a05€49.00€0.67matched
13capture01a1a22d-1e1d-79c6-8348-daa5823c0b04€9.00€0.19matched
14capture01a1a22d-1fad-72c8-af25-ac0ec6bf9d6e€35.00€0.50matched
15capture01a1a22d-416c-7dc0-b5a5-7421057fd55d€49.00€0.67matched
16capture01a1a22d-823e-7e84-9aa9-1a92dabe5e2b€15.00€0.26matched
17capture01a1a22d-84f5-7eaa-b652-154fefa514a0€49.00€0.67matched
18capture01a1a22d-9622-7979-ad76-e62ff0ea38d9€35.00€0.50matched
19capture01a1a22d-9bab-711f-9f17-58e868590945€35.00€0.50matched
20refund01a1a22d-b5e2-75be-996b-b7837f21f970-€20.00€0.00matched
21refund01a1a22d-b8c8-7abc-a6b2-a5cfd3ba1e8f-€11.00€0.00matched
22capture01a1a22d-c30c-74fc-a990-698e03674475€15.00€0.26matched
23capture01a1a22d-d618-7d32-8b6d-5e8ef4a21882€24.00€0.37matched
24capture01a1a22e-144b-7ef8-a7e1-91e4c90c88dc€9.00€0.19matched
25capture01a1a22e-19fd-76cf-9560-83472d6841a9€49.00€0.67matched
26capture01a1a22e-3b51-71c2-a835-b6869adfef91€9.00€0.19matched
27capture01a1a22e-3c62-7bb0-ae8e-cb74d199e480€35.00€0.50matched
28capture01a1a22e-48f0-7784-8614-17dbcf3a75d4€9.00€0.19matched
29capture01a1a22e-7c1d-778b-a344-20bec1f0c1a9€49.00€0.67matched
30capture01a1a22e-744a-736b-a041-f96daf914db5€9.00€0.19matched
31capture01a1a22e-be97-71fb-a3fa-54b862e7cb02€24.00€0.37matched
32capture01a1a22e-d4c7-7f0a-9069-4e7d720dfb88€35.00€0.50matched
33capture01a1a22e-d77b-783d-a8bd-932a7ba3ed5d€35.00€0.50matched
34capture01a1a22e-e105-71fd-872c-bed3ba5426b1€24.00€0.37matched
35capture01a1a22e-e8ba-7c15-8b13-5760f442b7ab€49.00€0.67matched
36capture01a1a22e-fa48-7146-a1ec-d7088fb539b9€9.00€0.19matched
37capture01a1a22e-fd96-78cf-99a5-715d9741c7a6€35.00€0.50matched
38capture01a1a22f-05a2-717f-a993-f05a4325cfcb€49.00€0.67matched
39capture01a1a22f-1889-762d-832a-67a5974e96b9€24.00€0.37matched
40capture01a1a22f-24b4-7899-a96f-ef17de235394€15.00€0.26matched
41capture01a1a22f-34f8-71bf-8a4c-f5cc5d93fd3c€15.00€0.26matched
42refund01a1a22f-36bd-73b7-9847-57ed96b2d326-€18.00€0.00matched
43capture01a1a22f-6097-7d32-a982-681d859c3285€49.00€0.67matched
44capture01a1a22f-7ee1-767d-8f9f-ce53a42e734f€49.00€0.67matched
45capture01a1a22f-8b4f-761e-bf05-ca91249bc3c6€35.00€0.50matched
46capture01a1a22f-994b-7675-9afc-2e8fb140216d€35.00€0.50matched
47capture01a1a22f-bdeb-74c7-8fc9-d550363633c6€15.00€0.26matched
48capture01a1a22f-d2e7-70e1-acfe-f7f10c2b2f37€49.00€0.67matched
49capture01a1a22f-e344-7c4c-93ea-4fdd001e08d5€49.00€0.67matched
50capture01a1a22f-f28e-72b0-a900-16f2ee4fe9ca€15.00€0.26matched
51capture01a1a230-12e1-73ee-ac53-9e6c1b2075a1€9.00€0.19matched
52capture01a1a230-3c61-781d-bb0f-e5fbf6de466b€15.00€0.26matched
53capture01a1a230-57dd-79e4-b816-7c5e8945e2bd€35.00€0.50matched
54capture01a1a230-5f84-786d-b05d-fb90e05083de€49.00€0.67matched
55capture01a1a230-6a4a-756f-b256-40181ed7590c€15.00€0.26matched
56capture01a1a230-7c0f-7fe8-92f4-8b8c55d391ea€24.00€0.37matched
57capture01a1a230-8029-7fa6-99b3-ca86b761c803€35.00€0.50matched
58capture01a1a230-80ee-7e1b-9092-46a954d44d16€49.00€0.67matched
59capture01a1a230-8d68-7990-91f0-1b3d2a153c3c€9.00€0.19matched
60capture01a1a230-9494-7192-b3b4-b10f3982b88c€49.00€0.67matched
61capture01a1a230-9ca0-70c5-8f62-c72a6f600759€9.00€0.19matched
62capture01a1a230-a351-74e1-afab-db8f8ff8014b€49.00€0.67matched
64capture01a1a230-a495-74e4-b06e-3e15cb29658f€9.00€0.19matched
65capture01a1a230-b73e-70cf-8f3b-b6cf12c9a88c€9.00€0.19matched
66capture01a1a230-d679-72d3-a1db-f0703cab1dd4€24.00€0.37matched
67refund01a1a230-dccf-7e15-b072-852f675a1ba9-€44.00€0.00matched
68capture01a1a231-01c6-7ece-bd3a-405e3af2502f€15.00€0.26matched
69capture01a1a231-2198-7081-9f39-a4f391fa96af€24.00€0.37matched
70capture01a1a231-641f-7ea0-a48f-bc214e5f2656€15.00€0.26matched
71capture01a1a231-a378-7a7b-b469-e4040b5774b4€9.00€0.19matched
72capture01a1a231-a427-738a-8e6e-0b03affdd5c0€35.00€0.50matched
73capture01a1a231-ac36-7c00-954d-d852a646b5ed€15.00€0.26matched
74capture01a1a231-ad7c-7256-b44a-c576059ed3ef€15.00€0.26matched
75capture01a1a231-bf25-7371-81d2-9196e2cdcfbd€49.00€0.67matched
76capture01a1a231-d624-75d0-b92d-859a47837cb3€24.00€0.37matched
77capture01a1a232-0198-706e-911c-81833ea627bb€15.00€0.26matched
78capture01a1a232-07af-7e98-8319-20bb54d793ba€35.00€0.50matched
79refund01a1a232-0a7a-74b8-9659-bf78bdd1d45d-€7.00€0.00matched
80capture01a1a232-1519-70ee-9a3a-53d207d4c66c€24.00€0.37matched
81capture01a1a232-1854-7b58-9e5f-851c233dd78d€9.00€0.19matched
82capture01a1a232-3495-7ca1-b4ef-f2e35fd526cc€9.00€0.19matched
83capture01a1a232-46dd-7dd0-8a02-ab1bf46294a2€24.00€0.37matched
84capture01a1a232-5c19-78a4-b225-f2c43032b410€49.00€0.67matched
85capture01a1a232-6860-7653-b38a-744023a704b9€35.00€0.50matched
86capture01a1a232-6d02-739e-be5e-fb1edf45864e€49.00€0.67matched
87capture01a1a232-6f09-7727-9665-7f5150a6179f€24.00€0.37matched
88capture01a1a232-8349-71a5-9c3c-03820d0001a8€49.00€0.67matched
89capture01a1a232-8fb3-762c-92b1-290a1fca7a68€15.00€0.26matched
90capture01a1a232-9168-7d90-bb24-4aa7eedf170d€9.00€0.19matched
91capture01a1a232-ad49-73e8-88ec-683e4c269a7b€35.00€0.50matched
92capture01a1a232-bea8-7b7b-b026-75cc6e73de5c€9.00€0.19matched
93capture01a1a232-c70e-701b-b004-4900b044f58e€24.00€0.37matched
94capture01a1a232-d449-7935-a0bf-ae8131bc0e13€15.00€0.26matched
95refund01a1a232-ecff-7646-beb8-c733a654ab3b-€19.00€0.00matched
96capture01a1a233-05c5-7070-9bf7-d3e1ef8db662€49.00€0.67matched
97capture01a1a233-16a7-756c-870c-720d64036012€49.00€0.67matched
98capture01a1a233-4f32-75fe-8a44-31e0184d1326€35.00€0.50matched
99capture01a1a233-5efb-72f6-be8a-9aadc2fdf7b0€24.00€0.37matched
100capture01a1a233-5fab-7ffa-8b60-612dc20bda8f€35.00€0.50matched
101capture01a1a233-6dbb-7d9d-93df-674ef4d34cb4€49.00€0.67matched
102capture01a1a233-7270-7973-a0cb-35ea65682cb4€35.00€0.50matched
103capture01a1a233-9b5f-7f09-a370-e1d7680de10a€9.00€0.19matched
104capture01a1a233-b741-78dc-b2c1-61e3de918077€35.00€0.50matched
105capture01a1a233-cb5c-7215-9d97-2d652236fb01€9.00€0.19matched
106capture01a1a233-d34a-7603-9508-61a1ff633176€9.00€0.19matched
107capture01a1a233-fc06-7d13-8dae-a6bbce00e769€49.00€0.67matched
108capture01a1a234-13f3-7988-b98e-2760e27bd354€15.00€0.26matched
109capture01a1a234-2140-7992-8738-04dc6018451f€49.00€0.67matched
110refund01a1a234-445b-7915-b0aa-847f5e98c3cf-€12.00€0.00matched
111capture01a1a234-478b-79d7-91d7-02128e2fc560€9.00€0.19matched
112refund01a1a234-499a-7816-8c14-f1e779238f13-€20.00€0.00matched
113capture01a1a234-4e3c-7eee-9a12-46b3b4f98bf9€15.00€0.26matched
114capture01a1a234-57d0-7f44-bf1d-1069634f4ee3€49.00€0.67matched
115capture01a1a234-5b0b-7efd-b796-a716914adf97€24.00€0.37matched
116capture01a1a234-7a22-7673-a1d7-664f400b328a€35.00€0.50matched
117capture01a1a234-83e6-7277-94fb-da74701b2abc€49.00€0.67matched
118capture01a1a234-9bc1-7f0c-b31f-b2843afcdca6€49.00€0.67matched
120capture01a1a234-a6f9-72ec-ad97-391960fc5cef€49.00€0.67matched
121capture01a1a234-b253-7f83-b1ec-c594865a4ba8€15.00€0.26matched
122capture01a1a234-c2d3-7c66-8314-9d14dabe3dcc€15.00€0.26matched
123capture01a1a234-c4c6-7bb1-92b2-ce47a6cb6262€15.00€0.26matched
124capture01a1a234-c4fe-7416-abae-506d0020b17d€24.00€0.37matched
125capture01a1a234-d608-731f-9284-6f77efe8ae29€15.00€0.26matched
126capture01a1a234-de1c-7085-bf41-2510c8a0842d€9.00€0.19matched
127capture01a1a235-07bd-7e72-bfe7-404771433af4€15.00€0.26matched
128capture01a1a235-1700-75ca-a9d0-e9d0d33e77ab€15.00€0.26matched
129capture01a1a235-1ab8-7284-9f73-7faf25683ae9€49.00€0.67matched
130capture01a1a235-2c81-7edc-946e-3ec8a7c7f64e€9.00€0.19matched
131capture01a1a235-6152-73bc-a40c-8243d19e2980€35.00€0.50matched
132capture01a1a235-6740-76aa-9c71-7bb5d7d33aa3€24.00€0.37matched
133capture01a1a235-6cba-7ff6-9e37-edf6379ea616€24.00€0.37matched
134capture01a1a235-71a3-7d0f-bc92-0a5ffb6f6604€49.00€0.67matched
135refund01a1a235-7dc0-75f5-8b2c-dd8565dbe534-€4.00€0.00matched
136capture01a1a235-b60e-72a1-b7a8-71a61ce50a53€24.00€0.37matched
137capture01a1a235-cc82-7688-805e-b3a67b92dca3€49.00€0.67matched
138capture01a1a235-cd09-782a-a5cf-d3dc8f2989cb€49.00€0.67matched