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, 23:50

Gross

€2,754.00

PSP fee

€43.57

Net to the bank

€2,710.43

Settlement journal

#369718

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a3d8-f7e6-7c37-b203-8f4e8ecd1f50 is already settled by stl_EUR_2989583 line 104
  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
LineKindReferenceGrossFeeStatus
19refund01a1a3d3-3d85-76c9-a11d-fd2ecda09296-€3.00€0.03fee difference
97capture01a1a3d8-a8e5-75b6-aa7d-c46dbff213e5€24.00€0.41fee difference
105capture01a1a3d9-185c-77da-84de-5e5b9f8159e8€9.00€0.19duplicate line
118capture01a1a3da-37f4-70f5-91ad-59435f0d07a4€49.00€0.72fee difference
1capture01a1a3c8-c3fb-7f1f-a2b0-4a043cc1220f€9.00€0.19matched
2capture01a1a3ca-163a-769a-9b62-917725888efc€9.00€0.19matched
3capture01a1a3cd-71f6-7109-a9e5-ad3a58f3baae€9.00€0.19matched
4capture01a1a3d1-fbf3-7366-a8a2-13474ad543aa€15.00€0.26matched
5capture01a1a3d1-fdd3-7b8b-baa9-1d68ff734093€9.00€0.19matched
6capture01a1a3d2-4019-70df-9642-130ab9c07046€9.00€0.19matched
7capture01a1a3d2-4faa-7e01-bc12-e62f5c47d7b8€24.00€0.37matched
8capture01a1a3d2-6ff3-716b-b5cd-abc04d441c75€15.00€0.26matched
9capture01a1a3d2-952c-7dbb-ae0f-cab8f16a4a4c€24.00€0.37matched
10capture01a1a3d2-bc29-7944-9c7f-892d0a5922de€24.00€0.37matched
11capture01a1a3d2-cbde-72b6-b9a1-b599271f39ca€9.00€0.19matched
12capture01a1a3d2-d08a-7405-ac4e-b6957b0a6ba7€9.00€0.19matched
13capture01a1a3d2-dc32-73f5-9da2-f9beafb9afd4€24.00€0.37matched
14capture01a1a3d2-dd7c-7286-a5e6-4ce10b5899d8€15.00€0.26matched
15capture01a1a3d2-f584-7932-8c72-0f2dab24e4d2€9.00€0.19matched
16capture01a1a3d3-0500-75e2-af82-bd18c29b04a7€9.00€0.19matched
17refund01a1a3d3-1288-740f-adfd-697e8da42b9e-€7.00€0.00matched
18capture01a1a3d3-1564-76e7-a45b-2612c5c1e447€49.00€0.67matched
20capture01a1a3d3-78af-726d-956e-d73709fd491f€9.00€0.19matched
21capture01a1a3d3-7f54-7882-a53f-cd9f621c05aa€49.00€0.67matched
22capture01a1a3d3-8b5a-7223-8c89-1a1cd7c9b18c€9.00€0.19matched
23capture01a1a3d3-99fe-74ea-ba02-f9be9a796fbd€49.00€0.67matched
24capture01a1a3d3-9dae-72ac-b40c-37dd178c7be6€9.00€0.19matched
25capture01a1a3d3-aacd-75bc-9159-4361e2508f8a€49.00€0.67matched
26capture01a1a3d3-cc6b-78c1-a089-a2d7f739beb5€9.00€0.19matched
27capture01a1a3d3-f816-74a9-a100-78185c524a6b€24.00€0.37matched
28capture01a1a3d4-0f8f-7059-a1c0-cffff0312eb5€15.00€0.26matched
29capture01a1a3d4-1b7b-7fac-b549-51d5102cbf09€49.00€0.67matched
30capture01a1a3d4-3347-78d0-b374-65cf2a797d50€15.00€0.26matched
31capture01a1a3d4-48f2-74e5-b7a9-eb7a93860a28€15.00€0.26matched
32capture01a1a3d4-626a-7b94-a393-032fc26b12c7€24.00€0.37matched
33capture01a1a3d4-6d0f-73f3-ab4b-ae4f5bc9689c€15.00€0.26matched
34capture01a1a3d4-745f-7781-b42a-8ea87f8aebc4€35.00€0.50matched
35capture01a1a3d4-78a2-741d-ba9e-086f2a0bf2f2€15.00€0.26matched
36capture01a1a3d4-8bf1-71c9-a176-83a9a41d1612€35.00€0.50matched
37capture01a1a3d4-a1ad-72fd-a4fc-d24ccc039f8d€35.00€0.50matched
38capture01a1a3d4-a408-75e4-9c8c-eae5da87aea4€35.00€0.50matched
39capture01a1a3d4-a449-7caa-a7b6-240385d35807€15.00€0.26matched
40capture01a1a3d4-a98e-7562-87c9-75a457ec78e7€49.00€0.67matched
41capture01a1a3d4-b72f-7ab4-b90a-bb57a99365cf€49.00€0.67matched
42capture01a1a3d4-c39b-778d-bf02-bde4a4075b8e€9.00€0.19matched
43capture01a1a3d4-e5de-7f81-ad3d-6f876eef293f€35.00€0.50matched
44capture01a1a3d4-e94f-7f85-96ac-451848d16f4c€15.00€0.26matched
45capture01a1a3d5-051e-770d-8b80-c27d5f308b7b€9.00€0.19matched
46capture01a1a3d5-348f-7ee5-8e21-4262c4f80959€24.00€0.37matched
47capture01a1a3d5-72ed-711f-8a4b-7a0b5d818d7c€9.00€0.19matched
48capture01a1a3d5-8452-7e69-958a-7856fa84677b€24.00€0.37matched
49capture01a1a3d5-8a00-7856-b903-1cdf862ffd81€15.00€0.26matched
50refund01a1a3d5-8e17-74de-afb3-ce16c5c687d3-€25.00€0.00matched
51capture01a1a3d5-b64c-7809-b315-70a21993c803€15.00€0.26matched
52capture01a1a3d5-dd8f-75d6-ba1d-2186337c224d€35.00€0.50matched
53capture01a1a3d5-e67b-7601-b498-7602c9101e99€49.00€0.67matched
54capture01a1a3d5-f1bd-7740-a468-dfee8e5d5db6€15.00€0.26matched
55capture01a1a3d6-2483-7892-98ac-d3200e051f17€49.00€0.67matched
56capture01a1a3d6-29c2-715e-8f07-0950477c2125€15.00€0.26matched
57refund01a1a3d6-3c04-7447-a966-45ac8bcd0d69-€7.00€0.00matched
58capture01a1a3d6-4494-7aa2-a01c-a6815adcb889€35.00€0.50matched
59capture01a1a3d6-5072-7801-9403-a71905e95071€9.00€0.19matched
60capture01a1a3d6-5d35-7286-af94-bd3b6d923718€24.00€0.37matched
61capture01a1a3d6-6d03-7bce-a67e-d52c843d1138€9.00€0.19matched
62capture01a1a3d6-7d07-7fd2-8280-8dfa96f14bd5€9.00€0.19matched
63capture01a1a3d6-b373-749a-be29-0f57e499ba1d€9.00€0.19matched
64capture01a1a3d6-bc03-7bb3-9347-6b6812ffc053€15.00€0.26matched
65capture01a1a3d6-c1e1-779f-80d8-6f4b4a3a7a9e€24.00€0.37matched
66capture01a1a3d6-e487-7933-a282-26bbf477e3ba€35.00€0.50matched
67capture01a1a3d6-ea3d-7393-b844-5989e4fcd54a€15.00€0.26matched
68capture01a1a3d6-eb6c-7184-b1f7-61c67caf30b0€49.00€0.67matched
69capture01a1a3d6-f278-7a4c-9dd6-e336c4fec75a€9.00€0.19matched
70capture01a1a3d7-346e-7415-ab6c-eb4b138404c8€49.00€0.67matched
71capture01a1a3d7-4913-7ce1-a587-9dd12ff4a0f1€9.00€0.19matched
72capture01a1a3d7-4c16-7e62-b34c-4c4964b085d6€24.00€0.37matched
73capture01a1a3d7-4fc6-719f-b699-b937887c0f81€15.00€0.26matched
74capture01a1a3d7-6581-721c-95b9-ec444cc3a68e€24.00€0.37matched
75capture01a1a3d7-abd9-7d35-bf68-786c8ce7829e€9.00€0.19matched
76capture01a1a3d7-c36d-7a6d-af63-707075c8ab83€35.00€0.50matched
77capture01a1a3d7-db8a-7115-891f-6a17383ba5fc€49.00€0.67matched
78capture01a1a3d7-e33f-72ad-8853-88a2e96b14a3€15.00€0.26matched
79capture01a1a3d7-e488-7204-9b68-d5c35baba581€49.00€0.67matched
80capture01a1a3d8-057e-72b4-aece-70daf5050e33€15.00€0.26matched
81capture01a1a3d8-083b-76c5-8de9-4c30429795db€49.00€0.67matched
82capture01a1a3d8-10a4-72ae-8909-da6f377a6e7d€24.00€0.37matched
83capture01a1a3d8-1725-786b-8b23-fdc6db70fc71€49.00€0.67matched
84capture01a1a3d8-2b1c-7ab5-99b5-d6ce8c0e7bd8€49.00€0.67matched
85capture01a1a3d8-483b-7314-8be4-4caf1040b583€35.00€0.50matched
86capture01a1a3d8-4985-72f4-91db-c6635e2ca128€9.00€0.19matched
87capture01a1a3d8-52ec-73a7-86a7-740149a8f6c6€49.00€0.67matched
88capture01a1a3d8-6655-7a4c-8c8e-07d1ab30acf1€35.00€0.50matched
89capture01a1a3d8-77a2-7ecf-9e7a-be47fb04f721€24.00€0.37matched
90capture01a1a3d8-77f6-722f-9894-5522f04f257e€24.00€0.37matched
91capture01a1a3d8-82d5-7f5a-aa34-0c4040240202€35.00€0.50matched
92capture01a1a3d8-8799-733d-b87d-3f7dc8263b38€24.00€0.37matched
93capture01a1a3d8-8ba7-7c7d-a226-ffa7017cd3e0€24.00€0.37matched
94capture01a1a3d8-8c8b-718f-af0a-f49d8058cf18€35.00€0.50matched
95capture01a1a3d8-9a41-7eb1-8000-f8d02c75795d€15.00€0.26matched
96capture01a1a3d8-9b9a-77dd-9eea-6ad67d5546b9€15.00€0.26matched
98capture01a1a3d8-af0f-7e90-9432-68b16036fd4e€49.00€0.67matched
99capture01a1a3d8-bb79-77c4-8d41-73b2269e0ef0€15.00€0.26matched
100refund01a1a3d8-bcf8-74bc-be19-edfab4132609-€26.00€0.00matched
101capture01a1a3d8-c094-7dd7-b9a0-79b6929c42e2€9.00€0.19matched
102capture01a1a3d8-eb3a-7a36-8fe8-d40cad064dac€24.00€0.37matched
103capture01a1a3d8-fe91-7b53-9a0c-20cc4c0fc28f€9.00€0.19matched
104capture01a1a3d9-185c-77da-84de-5e5b9f8159e8€9.00€0.19matched
106capture01a1a3d9-24af-7a4c-886e-669909431b49€15.00€0.26matched
107capture01a1a3d9-27fb-7462-b551-f44890ae7429€24.00€0.37matched
108capture01a1a3d9-66fd-7a5c-8e24-5f0f3416164d€35.00€0.50matched
109capture01a1a3d9-77c2-7925-a589-022bd44b3a49€9.00€0.19matched
110capture01a1a3d9-872a-7264-9c4c-d6cff744763c€35.00€0.50matched
111capture01a1a3d9-b379-7e51-a94f-dea1d4129072€9.00€0.19matched
112capture01a1a3d9-b3ca-7913-874b-a85a49f04b2b€15.00€0.26matched
113capture01a1a3d9-ca4f-7048-9fa7-6236a234e13a€35.00€0.50matched
114capture01a1a3d9-d0ce-7b89-b3e9-d6e965c90ad0€49.00€0.67matched
115capture01a1a3d9-d587-722a-8f7e-9e166acab504€24.00€0.37matched
116capture01a1a3da-08fa-7e7d-adfc-a94a284d8a70€9.00€0.19matched
117capture01a1a3da-33a9-7f8b-abcf-d586af6adb3d€35.00€0.50matched
119capture01a1a3da-72a5-76ee-8e73-9c3f934427df€24.00€0.37matched
120capture01a1a3da-a2e5-700b-9732-c6f9b9c976d5€15.00€0.26matched
121capture01a1a3da-adb9-7f5a-9e54-6da060e16016€15.00€0.26matched
122capture01a1a3da-afe6-78fa-9778-38f4e8ed92a6€35.00€0.50matched
123capture01a1a3da-d92d-7017-b288-13a083a3b50e€15.00€0.26matched