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

5 Nov, 14:30

Gross

€2,960.00

PSP fee

€46.53

Net to the bank

€2,913.47

Settlement journal

#399163

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ac20-ddda-7edc-8bed-e1286fdf192c is already settled by stl_EUR_2989815 line 47
  • duplicate linethe file lists it twicecapture:01a1ac23-7085-7bdd-9f4b-88ca36f15691 is already settled by stl_EUR_2989815 line 74
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
LineKindReferenceGrossFeeStatus
1capture01a1ac16-7b13-7952-b547-1d67ede7612d€49.00€0.70fee difference
48capture01a1ac20-ddf5-7544-93cf-820ce0042dbe€49.00€0.67duplicate line
75capture01a1ac23-70a9-73b0-829e-aba785203bb2€15.00€0.26duplicate line
85capture01a1ac24-2aed-7233-a336-dc9cea893c48€24.00€0.40fee difference
2capture01a1ac1d-e456-7857-881a-830b787f6790€49.00€0.67matched
3capture01a1ac1d-ec2f-7978-b507-2cfe191da5de€24.00€0.37matched
4capture01a1ac1d-f10a-75d0-bf3b-a2841f0143f5€24.00€0.37matched
5capture01a1ac1d-f3ef-7360-98ac-aac372f76361€49.00€0.67matched
6capture01a1ac1d-f5ac-7160-8f30-52ded2455435€49.00€0.67matched
7capture01a1ac1e-23cb-7484-a17b-cd15c1c7c34c€49.00€0.67matched
8capture01a1ac1e-5908-7161-8a17-2c5183e9eae9€24.00€0.37matched
9capture01a1ac1e-624b-76b5-b55b-facbd94a0d09€15.00€0.26matched
10capture01a1ac1e-64c6-73ad-882a-d7e18ecaf3bf€15.00€0.26matched
11capture01a1ac1e-81f4-727b-b635-b086b6f94461€15.00€0.26matched
12capture01a1ac1e-8aac-7f70-b2ef-79a9ce20d8fe€24.00€0.37matched
13refund01a1ac1e-8e73-7097-83c4-1cb6e07431c8-€5.00€0.00matched
14capture01a1ac1e-99ba-7d4d-877c-18087b134c9a€24.00€0.37matched
15capture01a1ac1e-a464-7a25-a404-d412e5e082fd€15.00€0.26matched
16capture01a1ac1e-aef5-7cac-aa96-afb719448aff€49.00€0.67matched
17capture01a1ac1e-d409-7260-b149-c7b3ce3683b9€49.00€0.67matched
18capture01a1ac1f-0462-76cb-bc99-35da40aed17d€24.00€0.37matched
19capture01a1ac1f-090c-79bd-8b65-c206a2db9003€35.00€0.50matched
20capture01a1ac1f-1586-77c3-a42b-ef674b6fb594€15.00€0.26matched
21capture01a1ac1f-397f-7319-99e2-47dc18d6a09c€9.00€0.19matched
22capture01a1ac1f-4d14-7fef-9bff-98af21cd5f39€24.00€0.37matched
23capture01a1ac1f-8e1d-7295-a96b-7a79396c83a6€24.00€0.37matched
24capture01a1ac1f-92a2-704f-9aae-c3eaa688551b€35.00€0.50matched
25capture01a1ac1f-95fd-7e6f-846b-b5bb930a99c1€35.00€0.50matched
26capture01a1ac1f-b1ef-76e3-987e-34e1c44724c7€9.00€0.19matched
27capture01a1ac1f-cb12-7c98-965d-cbe20be34a07€15.00€0.26matched
28capture01a1ac1f-e649-70b5-a4cc-2ba992460961€35.00€0.50matched
29capture01a1ac1f-ff52-7688-a5c1-3daa3c149852€49.00€0.67matched
30capture01a1ac20-0063-7038-97f5-ccbfd2b95b36€9.00€0.19matched
31capture01a1ac20-068f-76dc-96e5-5a9d1c0d45e6€35.00€0.50matched
32capture01a1ac20-0c7a-7346-84a2-c6ef86f7ac56€49.00€0.67matched
33capture01a1ac20-3118-7c76-8195-0309473efe78€49.00€0.67matched
34capture01a1ac20-3b1f-7d76-b56f-b621f1abb433€15.00€0.26matched
35capture01a1ac20-3bb3-7552-ad13-66b331c1d784€9.00€0.19matched
36capture01a1ac20-3dc9-7a2d-b8aa-0ef126d8d452€35.00€0.50matched
37capture01a1ac20-46fc-780b-8c25-c8dc565c958e€49.00€0.67matched
38capture01a1ac20-4b4f-7775-b99b-89c7430a1c68€49.00€0.67matched
39capture01a1ac20-62a5-7d04-8477-14f4571ce089€9.00€0.19matched
40refund01a1ac20-7785-7bed-923e-24918e40985b-€26.00€0.00matched
41capture01a1ac20-7d9a-7e6a-8095-007e61eb9d93€24.00€0.37matched
42capture01a1ac20-871e-7326-9ba8-8a968b995d2b€15.00€0.26matched
43capture01a1ac20-ac1f-7dd8-979e-db4f4f52adc2€24.00€0.37matched
44capture01a1ac20-ceff-7026-89cc-b8b5ab793b30€15.00€0.26matched
45refund01a1ac20-d0bc-7d43-8ff5-f5dec9d1076e-€5.00€0.00matched
46capture01a1ac20-d60b-7c9e-bd85-0a118a6631cb€15.00€0.26matched
47capture01a1ac20-ddf5-7544-93cf-820ce0042dbe€49.00€0.67matched
49capture01a1ac21-16b6-7384-91ce-20ea0c9f7325€49.00€0.67matched
50capture01a1ac21-208b-78b3-8674-07bd6c11c46f€9.00€0.19matched
51capture01a1ac21-46c7-73ec-93c0-e286195dd383€9.00€0.19matched
52capture01a1ac21-9a6b-7901-a2cf-f74a3a85c623€9.00€0.19matched
53capture01a1ac21-ac0b-7720-8ae6-8bfe96ab2950€9.00€0.19matched
54capture01a1ac21-c33d-7391-9f9f-57b8cf4c21ab€15.00€0.26matched
55capture01a1ac21-c956-7ca7-b57b-e7276999113e€9.00€0.19matched
56capture01a1ac21-dcf9-77de-a888-56c072456404€9.00€0.19matched
57capture01a1ac21-e379-729f-9e62-a505b012474b€15.00€0.26matched
58capture01a1ac21-f303-7b4c-9af0-feca5267ee59€15.00€0.26matched
59capture01a1ac22-0041-7a7d-b1e1-c8f36a2bf6df€24.00€0.37matched
60capture01a1ac22-26be-797f-b280-a90b9d8d0294€35.00€0.50matched
61capture01a1ac22-27fd-78ac-b040-fe0a75fdcae2€15.00€0.26matched
62capture01a1ac22-2ff9-76d1-beaf-f835a50e10fd€35.00€0.50matched
63refund01a1ac22-56a4-7d14-a1c2-cc72d31e54e2-€13.00€0.00matched
64refund01a1ac22-9c2f-73b9-8d91-e4d900db9cf9-€32.00€0.00matched
65capture01a1ac22-a1dd-7df5-b18d-8c3f2b9693f0€49.00€0.67matched
66capture01a1ac22-b641-7c54-8d85-0bbae9c1355b€9.00€0.19matched
67capture01a1ac22-bc6e-78d8-917a-50ba61997f6b€24.00€0.37matched
68refund01a1ac22-d344-761a-a012-6d39ce7e0192-€45.00€0.00matched
69capture01a1ac23-29e3-780b-99fe-5abc3718fa75€24.00€0.37matched
70capture01a1ac23-2e4f-7280-a55a-fa341500a0c4€49.00€0.67matched
71capture01a1ac23-3fc2-76f2-bc51-53b64650c7d3€49.00€0.67matched
72capture01a1ac23-4014-770f-888d-3b0affb6db6e€24.00€0.37matched
73capture01a1ac23-601f-7c8f-a761-af37c46fc940€49.00€0.67matched
74capture01a1ac23-70a9-73b0-829e-aba785203bb2€15.00€0.26matched
76capture01a1ac23-75f1-7934-bda1-645037402fff€24.00€0.37matched
77capture01a1ac23-81e2-7cbb-83d7-5c7d56960272€49.00€0.67matched
78capture01a1ac23-894e-78e0-9bcd-b4f442e3b652€9.00€0.19matched
79capture01a1ac23-96e0-7d7c-9f70-895c1e6d5db1€24.00€0.37matched
80capture01a1ac23-a7e4-7fe0-9299-8fd63b187cd7€49.00€0.67matched
81capture01a1ac23-ac36-7c0c-bd75-afec5711372d€49.00€0.67matched
82capture01a1ac23-c1d5-7f3a-baaf-f3ceb769b26d€15.00€0.26matched
83capture01a1ac24-0261-71bd-9c4d-c11eff73dd69€24.00€0.37matched
84capture01a1ac24-2ad1-746e-8a9d-f8eca22796c6€15.00€0.26matched
86capture01a1ac24-2c65-7e56-b83d-1955d37b95e3€15.00€0.26matched
87refund01a1ac24-2cdb-7232-9d29-702ad9398208-€11.00€0.00matched
88capture01a1ac24-3078-7cea-b804-a2c46d67a219€24.00€0.37matched
89capture01a1ac24-6cd2-7002-a3ca-5e53ab02b462€35.00€0.50matched
90capture01a1ac24-c2e0-7bfd-8c5c-162c3f1f3e43€49.00€0.67matched
91capture01a1ac24-dbae-7dda-9958-de49229c4694€15.00€0.26matched
92capture01a1ac25-07d0-779c-b5b4-e0a88d5ca464€15.00€0.26matched
93capture01a1ac25-0f9a-7161-bea6-ec837f199301€49.00€0.67matched
94capture01a1ac25-121a-7eb9-83ae-06fa4e824264€15.00€0.26matched
95capture01a1ac25-37d6-7142-9f18-64cf145400a9€24.00€0.37matched
96capture01a1ac25-3a06-78c8-b546-d882727cb4d3€9.00€0.19matched
97capture01a1ac25-4d51-70a7-98d4-6446c48e88a3€9.00€0.19matched
98capture01a1ac25-5586-7544-a57b-660518e4e51f€49.00€0.67matched
99capture01a1ac25-5aa2-72ac-9d0b-5e5c0def2e8b€49.00€0.67matched
100capture01a1ac25-5d61-7525-b01b-604f8d66609f€24.00€0.37matched
101capture01a1ac25-759d-744a-9b32-06fbeb3945a1€15.00€0.26matched
102refund01a1ac25-7ca3-7a35-9f78-e27911629e60-€6.00€0.00matched
103capture01a1ac25-7cfe-7d9c-bad0-e0d91a50c420€24.00€0.37matched
104capture01a1ac25-8618-77ce-b87e-16a12cecb48b€35.00€0.50matched
105capture01a1ac25-b108-7df3-989e-90fb69d243b3€24.00€0.37matched
106capture01a1ac25-c314-7354-b7e6-f9abf9cea368€49.00€0.67matched
107capture01a1ac25-e5e8-7a33-800f-e6c6ff57f22e€15.00€0.26matched
108capture01a1ac25-f0bf-730e-9547-3bd66e2ad0bc€35.00€0.50matched
109capture01a1ac26-0a7f-7b6a-843c-b06223dc09a1€15.00€0.26matched
110capture01a1ac26-13df-7f2f-bd1a-c627c75bef6d€35.00€0.50matched
111capture01a1ac26-2fc9-7d18-8a75-b9bdd8057b81€49.00€0.67matched
112capture01a1ac26-5119-76dc-b99e-dd4181d786aa€15.00€0.26matched
113capture01a1ac26-8b07-72ac-842a-281cb5007a2e€15.00€0.26matched
114capture01a1ac26-9c68-7a6c-b8fd-c1c92ca1aae9€24.00€0.37matched
115capture01a1ac26-aa92-7a19-a847-652bbd879dc6€15.00€0.26matched
116capture01a1ac26-bd22-76f5-9f97-bdc3c318b420€49.00€0.67matched
117capture01a1ac26-c71f-7a7b-92e6-070328d065cb€49.00€0.67matched
118capture01a1ac26-cec7-7c50-9037-fa2af5e927ef€9.00€0.19matched
119refund01a1ac26-d506-79cc-90a4-45600858d758-€11.00€0.00matched
120capture01a1ac26-ef6a-7fa5-b955-c8e2de7e0ef3€35.00€0.50matched
121capture01a1ac26-f531-7624-bbe1-961dd0c42038€49.00€0.67matched