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

2 Nov, 09:10

Gross

€3,107.00

PSP fee

€49.30

Net to the bank

€3,057.70

Settlement journal

#340283

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19b8c-afb3-7cd6-b8c2-d5f605b5bbde is already settled by stl_EUR_2989351 line 96
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
LineKindReferenceGrossFeeStatus
86capture01a19b8c-22e2-73c9-9755-61424766eb84€9.00€0.23fee difference
97capture01a19b8c-b00e-7175-8ad5-a4289425cd29€9.00€0.19duplicate line
1capture01a19b7e-e369-7440-9241-4d70577096a2€9.00€0.19matched
2capture01a19b7f-c528-7c79-ba08-342772bb0be1€49.00€0.67matched
3capture01a19b80-e65c-7ff2-9793-cf0d1bd83d1f€49.00€0.67matched
4capture01a19b81-859b-722c-ba57-17900fe02e7c€9.00€0.19matched
5capture01a19b85-f8a7-7d5f-a2e2-eb7c314080e8€49.00€0.67matched
6capture01a19b85-fcac-71de-ad56-002a4f82eff5€35.00€0.50matched
7capture01a19b86-20c7-7cd9-bc25-48009db44a1b€9.00€0.19matched
8capture01a19b86-22c7-7307-b897-96b56b998b62€15.00€0.26matched
9capture01a19b86-2fd6-7849-b4a6-975f2cdefafa€35.00€0.50matched
10capture01a19b86-46b8-7f12-a7a5-0204c85cbbe3€49.00€0.67matched
11refund01a19b86-5f10-79c3-97b8-dc86ef961b15-€34.00€0.00matched
12refund01a19b86-99d3-717d-838c-50491ca8c427-€28.00€0.00matched
13capture01a19b86-a1a2-731a-a742-6c3e6f0a9312€49.00€0.67matched
14capture01a19b86-b5e7-7e56-bc03-994694e74fd0€24.00€0.37matched
15capture01a19b86-d5c4-7a7c-a7f3-dbf1a45a661a€35.00€0.50matched
16capture01a19b86-db25-7e03-bd49-18d83831f6b5€35.00€0.50matched
17capture01a19b87-0a9f-78c7-b9dd-47a69dfa78fa€49.00€0.67matched
18capture01a19b87-1106-7bff-96c9-b794b6b569b6€15.00€0.26matched
19capture01a19b87-31d7-7e88-9075-71df9a149ab0€49.00€0.67matched
20capture01a19b87-4565-785b-b079-ded1e95adb1c€35.00€0.50matched
21capture01a19b87-540d-7530-803b-8a7fec897bea€35.00€0.50matched
22capture01a19b87-5c9f-7a3a-97f2-13885f19a8dc€35.00€0.50matched
23capture01a19b87-794a-7077-bde2-93be0530103e€49.00€0.67matched
24capture01a19b87-8011-7bd2-b92d-6a48891bd10f€9.00€0.19matched
25capture01a19b87-9313-7e8d-89f8-e646b775cd1f€15.00€0.26matched
26capture01a19b87-d5df-7544-90cb-722196bfed45€24.00€0.37matched
27capture01a19b87-d7fb-7754-bc60-7ada9d7123da€9.00€0.19matched
28capture01a19b87-dfe4-7ef7-8061-e612d0ed35fc€35.00€0.50matched
29capture01a19b87-ec90-74be-b548-b5e7665d089c€24.00€0.37matched
30capture01a19b87-fef1-76ac-a6ff-86fd72a22e19€9.00€0.19matched
31capture01a19b88-14d5-773c-b290-cf6cf08f82d7€15.00€0.26matched
32capture01a19b88-14e9-7ab6-b166-849782efdb7d€35.00€0.50matched
33capture01a19b88-4aa5-7219-b4a1-05f3d37b3b7b€49.00€0.67matched
34capture01a19b88-5bd9-75eb-a4fd-b95f5867ee46€35.00€0.50matched
35capture01a19b88-680b-733e-abd5-a6579e05d57a€35.00€0.50matched
36capture01a19b88-751a-7191-ab4f-25a91776301a€15.00€0.26matched
37capture01a19b88-81c2-74ea-a113-46dbe168fa62€9.00€0.19matched
38capture01a19b88-966c-703e-8f34-e8004d0d8eba€49.00€0.67matched
39capture01a19b88-ae15-7413-8efc-0d5eadc32c91€35.00€0.50matched
40capture01a19b88-c69e-7269-b4f9-1e4a417557b7€24.00€0.37matched
41capture01a19b88-ccf8-78d8-895a-aacd08823295€49.00€0.67matched
42capture01a19b88-f09f-7d92-87d2-7f541dbb1e35€15.00€0.26matched
43capture01a19b88-f10c-79ef-bceb-f62a592d29c5€35.00€0.50matched
44capture01a19b88-f468-7aa1-841f-ad793c64ef69€35.00€0.50matched
45refund01a19b88-f78d-72ea-abe8-c712c4640e4f-€35.00€0.00matched
46capture01a19b88-fa1e-7c03-98c3-9d684969f106€9.00€0.19matched
47capture01a19b89-3373-7e4b-82e8-ab27457fb702€15.00€0.26matched
48capture01a19b89-4498-772d-84a9-6b9c1c98e8f0€49.00€0.67matched
49capture01a19b89-4177-7157-a0c6-d00a0aa39183€15.00€0.26matched
50capture01a19b89-4c40-7eb9-a01b-a2d0ef4d2fef€49.00€0.67matched
51capture01a19b89-6e83-7f8d-b172-b2db6d262d72€15.00€0.26matched
52refund01a19b89-918e-798c-8f06-20c58de2d05c-€6.00€0.00matched
53capture01a19b89-a32c-73cf-82d5-88aa6231f70d€35.00€0.50matched
54capture01a19b89-b7e3-777b-b12c-9cfef12bc833€24.00€0.37matched
55capture01a19b89-bb97-7511-95f5-669c017467bf€35.00€0.50matched
56capture01a19b89-d9f2-76d8-8b0c-6f740d2878cf€35.00€0.50matched
57capture01a19b89-e2e1-782b-abd7-34b60972d21a€49.00€0.67matched
58capture01a19b89-e462-7db6-8092-71dc4a956bb8€9.00€0.19matched
59capture01a19b89-f534-7e23-b730-7758665d98ef€24.00€0.37matched
60capture01a19b8a-04ee-7e5b-80bc-8acb601308ee€35.00€0.50matched
61capture01a19b8a-0650-7d7a-b6bc-7b84cf80d8c8€24.00€0.37matched
62capture01a19b8a-087e-7fad-a4e7-db85c4bae800€49.00€0.67matched
63capture01a19b8a-0a9a-7059-97a8-5aecf31d18e8€35.00€0.50matched
64capture01a19b8a-6499-75fa-8907-e3ed8145da95€35.00€0.50matched
65refund01a19b8a-660f-715f-9b23-d20723614b00-€17.00€0.00matched
66capture01a19b8a-f043-73f2-8efc-0c70c8127965€9.00€0.19matched
67capture01a19b8b-0a78-7002-ab96-a6bbdd03792b€49.00€0.67matched
68capture01a19b8b-1455-7c73-9907-ddf090186a83€49.00€0.67matched
69capture01a19b8b-1fba-7d35-8f62-cc07553e87bf€9.00€0.19matched
70capture01a19b8b-4def-76dc-895b-5eea7c3f2be5€35.00€0.50matched
71capture01a19b8b-6d56-7782-8770-0b4c3ea718ca€35.00€0.50matched
72capture01a19b8b-77b4-7f4e-b3f6-70e4d4a86d54€9.00€0.19matched
73capture01a19b8b-8425-7ce8-8144-801ead927b75€24.00€0.37matched
74capture01a19b8b-9992-7393-88de-48f6bb9e3d43€15.00€0.26matched
75capture01a19b8b-9c7e-76de-9d19-57d4f4ac1f28€49.00€0.67matched
76capture01a19b8b-acee-7c21-ab81-bb8fd3e34729€49.00€0.67matched
77capture01a19b8b-ad3d-7c29-ae60-45b4feab0a23€15.00€0.26matched
78capture01a19b8b-b5ed-7296-a72c-3a6ecd65bcb7€9.00€0.19matched
79capture01a19b8b-bdbe-76bd-9bea-68aa81f5162e€15.00€0.26matched
80capture01a19b8b-c61f-7358-aeb9-5ed3a6fc0c09€49.00€0.67matched
81capture01a19b8b-db7a-7e96-a35d-a182e2449a91€35.00€0.50matched
82capture01a19b8b-de18-7839-a606-03e5fac86758€35.00€0.50matched
83capture01a19b8b-e7b1-75b7-ad1b-958a98159a7a€49.00€0.67matched
84capture01a19b8b-f59c-7e80-afb6-c40f839081d2€35.00€0.50matched
85refund01a19b8c-1565-780c-a4c1-12183a19d214-€16.00€0.00matched
87capture01a19b8c-2860-7e88-b912-7d18b15451ad€24.00€0.37matched
88capture01a19b8c-425d-75f8-9f5b-cd270b054690€9.00€0.19matched
89refund01a19b8c-5287-7314-9470-9d8f5db67cc7-€25.00€0.00matched
90capture01a19b8c-5cab-7ce2-be68-6840c2dae38e€24.00€0.37matched
91capture01a19b8c-65f3-7751-acf0-9f60125e3eb0€15.00€0.26matched
92capture01a19b8c-659c-74fe-967e-36c6148468f2€9.00€0.19matched
93capture01a19b8c-7d3a-78f0-bd64-91a7d01c2f7b€9.00€0.19matched
94capture01a19b8c-9b04-763a-bf28-8d474173091d€49.00€0.67matched
95capture01a19b8c-a450-7544-99c5-7c2fc3a0874a€35.00€0.50matched
96capture01a19b8c-b00e-7175-8ad5-a4289425cd29€9.00€0.19matched
98capture01a19b8c-d855-76cd-bb80-56b5c7f9d5d5€35.00€0.50matched
99capture01a19b8d-0c95-7c85-9bd3-7c5463549ff4€15.00€0.26matched
100capture01a19b8d-1651-78d8-9181-db31f225e190€9.00€0.19matched
101capture01a19b8d-46e1-7915-8c2f-177112e464ef€24.00€0.37matched
102capture01a19b8d-5199-7221-989b-b8eedcfc5543€49.00€0.67matched
103capture01a19b8d-54d7-7f7e-aa3a-08e4a47c9dea€24.00€0.37matched
104capture01a19b8d-7bd7-7779-94f7-28e204ee6f3f€15.00€0.26matched
105capture01a19b8d-7ed1-7f68-bfd2-2e0cc904276c€35.00€0.50matched
106capture01a19b8d-84b7-7683-9e5c-c637a9459f54€15.00€0.26matched
107capture01a19b8d-938e-797f-8430-203c4df33885€49.00€0.67matched
108capture01a19b8d-aac4-76c4-8c70-116145bc530c€24.00€0.37matched
109capture01a19b8d-bc84-7924-b84b-1e3f771d297f€49.00€0.67matched
110refund01a19b8d-cb2a-7d9b-b60e-96c8da9548fb-€13.00€0.00matched
111capture01a19b8d-ea61-7380-8100-f7b501d8ba6e€15.00€0.26matched
112capture01a19b8d-f250-7c0f-b2b7-4b96a8f2eccd€24.00€0.37matched
113capture01a19b8e-0f90-7145-b731-28329b7346d5€49.00€0.67matched
114refund01a19b8e-193b-73df-8cd6-b804aa9bb6a1-€13.00€0.00matched
115capture01a19b8e-5a0b-7fba-ac6c-1ca7449a6836€49.00€0.67matched
116capture01a19b8e-65b7-7994-b190-54178b16eab2€35.00€0.50matched
117capture01a19b8e-817e-7711-b7a8-87eb2b80e34c€35.00€0.50matched
118capture01a19b8e-83d8-7672-bd31-35b7e09c5078€24.00€0.37matched
119capture01a19b8e-9576-7783-bacb-2cc448f7d4e7€9.00€0.19matched
120refund01a19b8e-969d-7949-ad2d-dec77fce9a0b-€27.00€0.00matched
121capture01a19b8e-a75a-7002-996d-563ee548e618€49.00€0.67matched
122capture01a19b8e-c277-7864-869f-eb7febc1389d€15.00€0.26matched
123capture01a19b8e-c669-7e2c-ab70-6753f168417a€15.00€0.26matched
124capture01a19b8e-d18c-7301-a663-f0d8d43b931c€15.00€0.26matched
125capture01a19b8e-f1fd-7fdc-b9d2-6d6336eb7e09€35.00€0.50matched
126capture01a19b8e-f3ed-7f6d-ab63-65176d79e6ba€15.00€0.26matched