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, 06:30

Gross

€3,079.00

PSP fee

€50.56

Net to the bank

€3,028.44

Settlement journal

#374785

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a546-b9ba-75e4-b605-1b5d28f206e5 is already settled by stl_EUR_2989623 line 102
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 5, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 5, the contract says 0
LineKindReferenceGrossFeeStatus
53capture01a1a544-2b2e-75e5-92e7-fd86599f013e€15.00€0.29fee difference
79refund01a1a545-5dba-78d3-9ff9-00cbc72df2c5-€22.00€0.05fee difference
82capture01a1a545-a295-7e4d-821c-9f11e1136c7f€15.00€0.30fee difference
85refund01a1a545-e1d6-7799-ba33-84cc92ca3862-€10.00€0.05fee difference
103capture01a1a546-b9fb-79b9-a3b4-f49de23d32c1€49.00€0.67duplicate line
1capture01a1a537-f81d-791d-b8dc-504559317531€35.00€0.50matched
2capture01a1a53a-48f8-745e-bde7-5a6a7cb76eeb€35.00€0.50matched
3capture01a1a53b-d1c0-7f7b-bce8-87ce1b670af7€9.00€0.19matched
4capture01a1a540-3433-7e73-bf22-56b82f068977€49.00€0.67matched
5capture01a1a540-4d15-7169-9382-9f9a1c0447ed€49.00€0.67matched
6capture01a1a540-621c-7245-a50b-353fd3162426€35.00€0.50matched
7capture01a1a540-6d74-75dd-9c2f-c620936239fb€15.00€0.26matched
8capture01a1a540-838e-706d-85c5-90a2492867ed€15.00€0.26matched
9capture01a1a540-8a12-763a-8887-f7bab0e8a5b9€15.00€0.26matched
10capture01a1a540-9feb-760d-930b-0af212803f8f€24.00€0.37matched
11capture01a1a540-a856-70d6-bd7d-fa10fe5370d4€9.00€0.19matched
12capture01a1a540-b965-7027-81d0-67ee165dacb4€35.00€0.50matched
13capture01a1a540-e8e6-72cd-957a-e89cb1188891€49.00€0.67matched
14capture01a1a540-e969-7560-b77c-c8a237ab0e98€9.00€0.19matched
15capture01a1a541-1277-754b-902c-2fc9ed63af42€9.00€0.19matched
16capture01a1a541-1bb4-767a-b995-1a222d3f7924€24.00€0.37matched
17capture01a1a541-2904-75ee-8a10-9667ffa303cb€24.00€0.37matched
18capture01a1a541-58a2-7434-817d-68bb747a6828€9.00€0.19matched
19capture01a1a541-64e7-70c5-8841-c9bf7b7fa982€9.00€0.19matched
20refund01a1a541-795d-7850-93c9-9652f89e6529-€10.00€0.00matched
21capture01a1a541-b997-78c5-925c-fd2d3f7efdea€9.00€0.19matched
22capture01a1a541-bf82-77ba-8992-206d14546fcb€35.00€0.50matched
23capture01a1a541-c7a0-7f28-9e8a-8bd40fa8284a€35.00€0.50matched
24capture01a1a541-d5a6-7a54-ad65-fb6167b89ca9€9.00€0.19matched
25capture01a1a541-fb8e-7933-a8b4-70e1379fe054€15.00€0.26matched
26capture01a1a541-ff87-7c95-86c0-4137015c9cc1€35.00€0.50matched
27capture01a1a542-25b3-7daa-a5e2-a3fd9b990e11€49.00€0.67matched
28capture01a1a542-2f70-79b8-bc47-759313351a3c€49.00€0.67matched
29capture01a1a542-6f29-70cb-ba51-ec71aae7c31b€49.00€0.67matched
30capture01a1a542-7849-787c-8b93-4337dc3d6336€24.00€0.37matched
31capture01a1a542-896f-7c2a-a13e-cc7cf158c435€15.00€0.26matched
32capture01a1a542-9c86-7859-9cc8-d0fc4a2f8c61€15.00€0.26matched
33capture01a1a542-b0cf-7993-9435-96e5dbc581d9€24.00€0.37matched
34capture01a1a542-b25b-7576-96c3-a2e0cc5fae38€24.00€0.37matched
35capture01a1a542-cc46-79e0-97bf-6344a924f459€35.00€0.50matched
36capture01a1a543-067d-7223-babe-c9a6bef78f7e€35.00€0.50matched
37capture01a1a542-fb42-7539-a115-2c83501389bf€15.00€0.26matched
38capture01a1a543-1b11-734b-afd0-a97aef99377e€49.00€0.67matched
39capture01a1a543-1e8f-76e0-ac77-0447f6820c79€15.00€0.26matched
40refund01a1a543-1f18-7c84-9072-6e6f95c98940-€31.00€0.00matched
41capture01a1a543-2ee5-747d-9d5f-3b2d2dd33dc7€9.00€0.19matched
42capture01a1a543-3f43-7d90-b859-907d49f263f0€15.00€0.26matched
43capture01a1a543-4d5a-7c4d-a804-bcb6a510c07a€49.00€0.67matched
44capture01a1a543-8a87-76d7-8b86-bf7946d3e2bc€49.00€0.67matched
45capture01a1a543-9650-7788-b405-0e335de50304€24.00€0.37matched
46refund01a1a543-cbe4-7652-88ec-5bbf9e51f2cb-€15.00€0.00matched
47capture01a1a543-cdb9-7035-9a72-6791e91054d1€35.00€0.50matched
48capture01a1a543-ff16-79cd-8295-ce921c769c7c€9.00€0.19matched
49capture01a1a544-0159-7859-8eb0-449947e7cd74€49.00€0.67matched
50capture01a1a544-084d-793d-b929-843ac34d393a€49.00€0.67matched
51capture01a1a544-0ffc-73b4-a795-a58f4845db02€9.00€0.19matched
52capture01a1a544-1a59-7a67-902d-78e1007fb786€9.00€0.19matched
54capture01a1a544-2d82-77d8-a6b0-840741f7e3d6€49.00€0.67matched
55capture01a1a544-2da7-7445-a6d4-cacfbfd7f9be€35.00€0.50matched
56refund01a1a544-3fe6-7619-a7dd-edad9822674e-€43.00€0.00matched
57capture01a1a544-46f3-7da1-9e9a-d2f491aaf97d€35.00€0.50matched
58capture01a1a544-5322-7cf6-afe8-d52b110d97dc€9.00€0.19matched
59capture01a1a544-64b6-79ac-bd0a-049e48824550€35.00€0.50matched
60capture01a1a544-69be-70a9-a4cd-5de77271ea3a€24.00€0.37matched
61capture01a1a544-7dc0-7f65-9e1a-cf95a9adf3bf€35.00€0.50matched
62capture01a1a544-8221-7bc2-b6f8-8b018cffe834€15.00€0.26matched
63refund01a1a544-a508-71bd-91de-4e2df22977ca-€11.00€0.00matched
64capture01a1a544-a665-724c-8eaf-f79f980dc977€49.00€0.67matched
65capture01a1a544-ab5c-7613-a86f-ad00226f4235€35.00€0.50matched
66capture01a1a544-abfd-7d61-9df3-ce4fcfbacfa6€9.00€0.19matched
67refund01a1a544-af9e-714d-9cd0-623ff5cd15bb-€31.00€0.00matched
68capture01a1a544-b492-7ea8-9c8a-e849c3b7e06f€15.00€0.26matched
69capture01a1a544-b6ae-77f1-95cb-d66e0ee5faf2€15.00€0.26matched
70capture01a1a544-ba87-79ed-a01a-3a279e16c9a6€15.00€0.26matched
71refund01a1a544-ce0b-799e-b41f-16e7d1d4ee01-€9.00€0.00matched
72capture01a1a544-cfb0-768d-afeb-88c2ee3c8bcb€9.00€0.19matched
73capture01a1a544-e8eb-739f-8d3a-f20f37ff8ef4€15.00€0.26matched
74capture01a1a544-f756-78cc-8b3e-25e807fae51d€35.00€0.50matched
75capture01a1a545-1e93-7e0b-8e88-10971f9f46a4€49.00€0.67matched
76capture01a1a545-2a37-763f-8cec-32e0363d733b€9.00€0.19matched
77capture01a1a545-3b9b-7524-a46d-82437289dec5€49.00€0.67matched
78capture01a1a545-4162-71db-af4a-ada2083a074b€24.00€0.37matched
80refund01a1a545-7ead-75b7-b08f-65325de8e63e-€9.00€0.00matched
81capture01a1a545-99a2-7403-a08f-40c1fded0aaf€15.00€0.26matched
83capture01a1a545-bf84-7cfc-883e-33423ba5b2c8€35.00€0.50matched
84capture01a1a545-c557-7670-96a9-8ba19b384705€9.00€0.19matched
86capture01a1a545-e34c-7e0a-9fb0-3bd94ff00b7f€49.00€0.67matched
87capture01a1a545-fc98-70cc-ae9f-b647cfa45c5d€24.00€0.37matched
88capture01a1a546-014f-7b7b-9158-bff33f8fe7c9€24.00€0.37matched
89refund01a1a546-0cf1-785d-92b3-a3b36680ce02-€2.00€0.00matched
90capture01a1a546-1f93-712b-a4c1-eea4488ba170€24.00€0.37matched
91capture01a1a546-2337-754b-ba8b-6b223f324810€35.00€0.50matched
92capture01a1a546-2620-7e50-89d3-72ad59d47b03€24.00€0.37matched
93capture01a1a546-30de-7aa2-81d4-83d22a56acfa€9.00€0.19matched
94capture01a1a546-53c3-719f-a175-9308ed4c12f9€49.00€0.67matched
95capture01a1a546-5621-7245-9441-f14d76381b00€24.00€0.37matched
96capture01a1a546-5839-7068-b558-843025645db9€15.00€0.26matched
97refund01a1a546-5def-70e3-b308-c6cbd4b40867-€33.00€0.00matched
98capture01a1a546-6168-748c-b647-77d6f2c991a6€35.00€0.50matched
99capture01a1a546-6453-7e5a-9fa8-441019c7f334€9.00€0.19matched
100capture01a1a546-7dae-71dc-bdb2-0be4d7b90347€24.00€0.37matched
101capture01a1a546-a134-703b-91fd-1b37f4422171€49.00€0.67matched
102capture01a1a546-b9fb-79b9-a3b4-f49de23d32c1€49.00€0.67matched
104capture01a1a546-bd3b-7902-8b9b-aa31ee9f7ea1€49.00€0.67matched
105capture01a1a546-c171-7390-8534-d94f0ce048be€35.00€0.50matched
106capture01a1a546-e530-7d6f-a3fb-3c810f042a72€9.00€0.19matched
107capture01a1a547-0893-76b3-a7f5-62cd3d04aa72€24.00€0.37matched
108refund01a1a547-11e9-751a-bc95-0eaf496fd01b-€20.00€0.00matched
109capture01a1a547-16f6-7306-b669-b28540d67ed0€49.00€0.67matched
110capture01a1a547-1e57-7714-b40b-a464320eea29€15.00€0.26matched
111capture01a1a547-48b5-7925-b62d-b63f66a8ef84€24.00€0.37matched
112capture01a1a547-4bb4-7caa-b08a-4ad0097b2206€9.00€0.19matched
113capture01a1a547-4ae0-7337-a985-6ff4de7f9083€24.00€0.37matched
114capture01a1a547-7317-792a-b470-91bb9baf290b€9.00€0.19matched
115capture01a1a547-82be-7aac-bb45-ed8eb1c32315€49.00€0.67matched
116capture01a1a547-8b9a-76eb-99cd-3b85eec8129f€15.00€0.26matched
117capture01a1a547-b5b8-7e0c-b203-fca7a44aacb9€49.00€0.67matched
118capture01a1a547-b91f-7628-bbbe-e3417d60eb25€49.00€0.67matched
119capture01a1a547-bd4d-7806-8993-638a028db402€24.00€0.37matched
120capture01a1a547-c95e-7cd1-9197-3d2f94c193b1€24.00€0.37matched
121capture01a1a547-cada-709e-925f-f529c8113449€15.00€0.26matched
122capture01a1a547-e806-7947-a714-33b855d9b7da€9.00€0.19matched
123refund01a1a547-f6e5-7e8a-96e1-7a01e6144774-€9.00€0.00matched
124capture01a1a548-1ee7-79ac-86da-6d594afb13db€15.00€0.26matched
125capture01a1a548-4da4-717f-b966-decd6c5968fa€49.00€0.67matched
126capture01a1a548-5698-7a49-99c7-c53251be4567€35.00€0.50matched
127capture01a1a548-783c-7682-80ba-e73a7f2535d1€15.00€0.26matched
128capture01a1a548-801f-7ee5-8793-77edbdc2ee8d€15.00€0.26matched
129capture01a1a548-8f97-7840-ab12-953959ac5f4f€9.00€0.19matched
130capture01a1a548-97d2-7090-ab5e-aa05d6f0c9be€35.00€0.50matched
131capture01a1a548-a645-7918-a6fc-e42bd56f8c59€9.00€0.19matched
132capture01a1a548-b130-74ec-96cd-1a4b7f2044a9€35.00€0.50matched
133capture01a1a548-aebf-7a64-a4fa-5c27889470cc€15.00€0.26matched
134capture01a1a548-b9e6-71b2-8065-5c43e343fe10€9.00€0.19matched
135refund01a1a548-c94e-79fd-a0d5-475462e0e5cf-€6.00€0.00matched
136capture01a1a548-ccd6-73b9-b9cf-7a9aea8a04a3€24.00€0.37matched
137capture01a1a548-d7c7-7bb3-8308-bd8da4877c88€24.00€0.37matched
138capture01a1a548-f777-7875-89b4-c250f90ca003€35.00€0.50matched
139capture01a1a548-f7d2-7569-8e41-00b98195cbf7€35.00€0.50matched
140capture01a1a549-13af-7b81-b4af-6ea08b13519b€24.00€0.37matched
141capture01a1a549-169a-77d0-8e87-5a7a5a38d7d5€15.00€0.26matched
142capture01a1a549-1c3c-7032-b18b-1e34c051f2b0€15.00€0.26matched