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, 13:20

Gross

€2,804.00

PSP fee

€45.21

Net to the bank

€2,758.79

Settlement journal

#361754

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a193-5371-78ce-becd-31c3ed89a394 is already settled by stl_EUR_2989520 line 29
LineKindReferenceGrossFeeStatus
30capture01a1a193-6e5d-7e8a-b46f-2edf2b290e58€9.00€0.19duplicate line
1capture01a1a18c-a376-7566-ae25-c980059168b7€49.00€0.67matched
2refund01a1a18f-f024-74c5-97a4-3318d972c50e-€42.00€0.00matched
3capture01a1a191-1689-7510-b992-5fbc0477d4b1€24.00€0.37matched
4capture01a1a191-233d-79a9-8cc4-c4a86ab54db3€24.00€0.37matched
5capture01a1a191-31a3-77d2-b4e0-0523b409444a€35.00€0.50matched
6capture01a1a191-c1ba-7dbc-90c3-3c6cd67d9c28€24.00€0.37matched
7capture01a1a191-c400-7265-a4c4-c80c8a01defa€35.00€0.50matched
8capture01a1a191-db90-7b64-97fc-2323b61b9579€35.00€0.50matched
9capture01a1a192-05f9-7c8d-8547-9eec50282d08€35.00€0.50matched
10capture01a1a192-0d7b-79c7-be49-cf19a0003f35€9.00€0.19matched
11capture01a1a192-22cb-753f-8d49-d267f0643f6c€9.00€0.19matched
12capture01a1a192-3b0e-70c3-9313-8df6ccfdf21e€15.00€0.26matched
13capture01a1a192-3df5-790f-bfbc-9b8146d7c97c€15.00€0.26matched
14capture01a1a192-3eb7-7e6b-bbd4-5bf17ec2f7df€24.00€0.37matched
15capture01a1a192-66fb-70e3-a35b-faf0677f8e5a€49.00€0.67matched
16capture01a1a192-a084-7cd3-bf35-f8ade0ca5431€9.00€0.19matched
17capture01a1a192-a43b-75ec-aeda-a8dd8647b7bb€24.00€0.37matched
18capture01a1a192-ccaa-77c7-b534-565b6bbd1ed8€35.00€0.50matched
19capture01a1a192-dde8-7156-acfd-fefa20549d6c€24.00€0.37matched
20capture01a1a192-ea74-7236-a4cd-57f845320cab€49.00€0.67matched
21capture01a1a192-f070-7471-82bf-dfcb342b009e€9.00€0.19matched
22refund01a1a192-f760-716c-891a-dc47e39112b7-€23.00€0.00matched
23capture01a1a193-00c5-7642-ac43-8b077c807be5€49.00€0.67matched
24capture01a1a193-25b5-7f9d-a0e4-9075ed0672a8€35.00€0.50matched
25capture01a1a193-2b01-7c71-bdfd-311312bce7d1€24.00€0.37matched
26capture01a1a193-2d7f-70ac-89b4-9d3d69e2d3a6€49.00€0.67matched
27capture01a1a193-3251-76b9-95dc-b745009e5eaa€9.00€0.19matched
28capture01a1a193-5d27-7c5f-b5fc-e442d6bcaf1d€35.00€0.50matched
29capture01a1a193-6e5d-7e8a-b46f-2edf2b290e58€9.00€0.19matched
31capture01a1a193-712b-724d-8844-01038dcd5dc6€9.00€0.19matched
32capture01a1a193-8225-763f-9c32-98e67564a26e€35.00€0.50matched
33capture01a1a193-8e83-78e5-a0cf-d9908e15a4ba€24.00€0.37matched
34capture01a1a193-9a14-7f28-822a-27f38c8fb7a5€24.00€0.37matched
35refund01a1a193-b3ec-7d18-aa2e-410cad96b51e-€8.00€0.00matched
36capture01a1a193-cb8b-7d7e-8efe-f6efbb1efa2e€24.00€0.37matched
37capture01a1a193-f23f-7223-b6ef-b4bac038309a€49.00€0.67matched
38capture01a1a193-fcfb-7cd7-86c0-1f24260b4b04€49.00€0.67matched
39capture01a1a194-0d91-7431-a2af-5f41d70cbb97€24.00€0.37matched
40capture01a1a194-22f9-7c89-900a-77014eaa8dd4€49.00€0.67matched
41capture01a1a194-36be-78ce-9a3e-01badd8d9e88€49.00€0.67matched
42capture01a1a194-6ef3-7443-bed5-f3009732105c€49.00€0.67matched
43capture01a1a194-79a3-7099-a1b1-e9de49a738b8€15.00€0.26matched
44capture01a1a194-9e2f-79cb-a5f6-f47eb8ef3471€49.00€0.67matched
45refund01a1a194-a9bf-71eb-bc21-30a3e1dfd269-€12.00€0.00matched
46capture01a1a194-aeb6-78e7-9e15-69e91f4d6974€49.00€0.67matched
47capture01a1a194-e200-79ab-9b3b-3051d33b4e6e€35.00€0.50matched
48capture01a1a194-e9f6-78b4-9380-4b3508f51cb4€35.00€0.50matched
49refund01a1a194-fb50-7fbb-a03c-664f5d281d3b-€44.00€0.00matched
50capture01a1a195-08c3-7624-ae5b-6ed09a53e11f€24.00€0.37matched
51refund01a1a195-39ea-7395-b272-109a0b2b9a83-€15.00€0.00matched
52refund01a1a195-6350-7e9f-a29f-de3d09b01eae-€14.00€0.00matched
53capture01a1a195-7612-753c-ad72-fee248ee002f€24.00€0.37matched
54capture01a1a195-a22a-7cbc-8549-a80495d3ba7b€15.00€0.26matched
55capture01a1a195-c7fa-7a9a-88e2-5c8ba78f9777€15.00€0.26matched
56capture01a1a195-dd5f-7c20-a7b3-3d5b338168cc€49.00€0.67matched
57capture01a1a195-f701-72d2-86a0-02647595fdb9€9.00€0.19matched
58capture01a1a195-ff58-7a48-a363-fe3387278838€15.00€0.26matched
59capture01a1a196-0447-7fed-b069-5ea67dd291ce€15.00€0.26matched
60capture01a1a196-098c-7c02-b120-662afba87c27€49.00€0.67matched
61capture01a1a196-22f7-7855-9fb6-0a250dd149af€9.00€0.19matched
62capture01a1a196-3007-7531-9c98-ecdd4f9399c0€35.00€0.50matched
63capture01a1a196-2ae9-7cce-bf9c-ce5e04604e98€24.00€0.37matched
64capture01a1a196-3c07-7db1-9398-52648013c659€35.00€0.50matched
65capture01a1a196-3c6e-74ac-a965-7db3e630eabe€24.00€0.37matched
66capture01a1a196-517f-75b0-ba08-5c18d3aea334€15.00€0.26matched
67capture01a1a196-65e2-77d5-a6f7-c07d81767efc€35.00€0.50matched
68capture01a1a196-7412-70a1-ba27-9cbc8ac471eb€49.00€0.67matched
69capture01a1a196-7e81-7657-905d-1ce5f6fac614€15.00€0.26matched
70capture01a1a196-91b5-7416-b832-0dc4d57d183d€15.00€0.26matched
71refund01a1a196-b120-750f-8781-091ce0108a7b-€6.00€0.00matched
72capture01a1a196-c641-7c6d-b2df-682162448613€9.00€0.19matched
73capture01a1a196-d073-7a5f-a91a-f17301c56594€24.00€0.37matched
74capture01a1a196-d876-7347-af20-f665e4e6c687€49.00€0.67matched
75capture01a1a196-e525-76ec-b260-0686dac93db2€24.00€0.37matched
76capture01a1a196-e98f-77ea-9343-d60823b880bf€49.00€0.67matched
77capture01a1a197-006b-72d9-a487-2aae1252d43c€35.00€0.50matched
78capture01a1a197-103c-7772-9d42-2c4ae82b5525€15.00€0.26matched
79refund01a1a197-11e1-76aa-a721-b1399ac53a1b-€17.00€0.00matched
80capture01a1a197-214c-7d78-b88f-103cd3028a82€49.00€0.67matched
81capture01a1a197-2972-7ff9-bba8-3b68991e6566€15.00€0.26matched
82capture01a1a197-3dbf-7e5f-8577-4dd1e9b51c5a€24.00€0.37matched
83capture01a1a197-4b07-761b-b9f4-5de33dd1c6eb€15.00€0.26matched
84capture01a1a197-604e-7f02-9d3a-306693b70bc3€9.00€0.19matched
85capture01a1a197-63fe-7646-9c55-fd628ac987cf€35.00€0.50matched
86capture01a1a197-660c-7565-81df-6e9e9a3572e2€35.00€0.50matched
87capture01a1a197-95dd-7432-961a-26fd718c57a3€9.00€0.19matched
88capture01a1a197-ab3c-7e61-bcbd-fb3b02309e62€9.00€0.19matched
89capture01a1a197-baff-7fa3-b0dd-3cd188ee87c4€24.00€0.37matched
90capture01a1a198-09ad-75e2-8e2d-46a6db59cdb0€9.00€0.19matched
91capture01a1a198-2aa8-71e2-a797-d5b1ca20a8d0€24.00€0.37matched
92capture01a1a198-4544-7990-8cee-9bfe530bbf5f€15.00€0.26matched
93capture01a1a198-4b0b-75f3-921f-2b948decae00€49.00€0.67matched
94capture01a1a198-55fd-730e-8cee-80e36af84e4e€15.00€0.26matched
95capture01a1a198-5901-7a57-8d8d-da81b4f0f0ac€35.00€0.50matched
96refund01a1a198-6171-75e9-9635-c6947b2f4b05-€4.00€0.00matched
97capture01a1a198-6834-7038-9c13-251cf7276eef€9.00€0.19matched
98capture01a1a198-750f-75e0-aed7-7f7c3555f151€9.00€0.19matched
99capture01a1a198-76e6-796c-9d84-af0494dc10bf€35.00€0.50matched
100capture01a1a198-7788-7394-97cd-bd974280420e€35.00€0.50matched
101capture01a1a198-85bc-7620-a7e5-fd7ffc04b51b€15.00€0.26matched
102capture01a1a198-b5a7-7703-abef-3f3f41479ecd€24.00€0.37matched
103refund01a1a198-b8d7-750c-9c8a-3389c7b3716a-€7.00€0.00matched
104refund01a1a198-ba41-7819-a637-847fea2fa85d-€19.00€0.00matched
105capture01a1a198-c059-7d37-9640-374e588f40db€15.00€0.26matched
106capture01a1a198-e1ad-748e-b7db-55f25fb05c15€35.00€0.50matched
107capture01a1a199-270a-723f-b1f6-97c762efdabd€49.00€0.67matched
108refund01a1a199-2bbe-742e-ab33-ae58ec95c27f-€8.00€0.00matched
109capture01a1a199-332b-711d-b96e-684fe721e28a€49.00€0.67matched
110capture01a1a199-624a-7846-af4b-d5fab432c25f€15.00€0.26matched
111capture01a1a199-63bb-7bd1-af9b-94116b5a26f8€49.00€0.67matched
112capture01a1a199-74ab-7467-a802-e6c7f250bf36€24.00€0.37matched
113capture01a1a199-7af0-79b2-8738-e4e696d4afec€15.00€0.26matched
114capture01a1a199-a0f9-7fa2-99a1-89e6006ad8af€49.00€0.67matched
115capture01a1a199-d98e-7f51-9058-d1771040173d€24.00€0.37matched
116capture01a1a199-da69-7dd8-9bcf-59da94de0479€15.00€0.26matched
117capture01a1a199-db2c-762e-959d-8e3515ac654a€35.00€0.50matched
118capture01a1a199-e791-7f13-a4b9-32d486d08908€35.00€0.50matched
119capture01a1a199-fce4-75dc-823a-ff2935b135e1€15.00€0.26matched
120capture01a1a19a-0428-75fb-b2c7-b82ad271636b€9.00€0.19matched
121capture01a1a19a-0bb1-7b2d-8d99-35c842ceb6f8€24.00€0.37matched
122capture01a1a19a-27b8-71bd-945f-b5b2f7b58174€49.00€0.67matched
123capture01a1a19a-280c-74b4-bbba-8d163ad0af8e€24.00€0.37matched