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, 03:40

Gross

€2,415.00

PSP fee

€38.59

Net to the bank

€2,376.41

Settlement journal

#354432

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19f87-24de-70a9-9b45-5834d09cac85 is already settled by stl_EUR_2989462 line 110
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • missing linein the books, not in the filecapture:01a19f7e-9170-7699-a32f-81afbecfca35 is in no file
LineKindReferenceGrossFeeStatus
33capture01a19f81-3556-7891-86be-4a89bd8c0a04€24.00€0.40fee difference
49capture01a19f82-8e52-78d6-8074-12f80405a7e9€24.00€0.40fee difference
85capture01a19f84-fac0-7d95-80e0-98767dfe6bb4€15.00€0.29fee difference
111capture01a19f87-2508-7d0a-b563-d321f49a2f80€35.00€0.50duplicate line
1capture01a19f76-6485-75c8-992a-2d47f01b2cf9€49.00€0.67matched
2capture01a19f76-7fd6-7198-9be2-3b9934f5b04a€24.00€0.37matched
3capture01a19f7a-115e-755c-b110-f35f1c45da8d€24.00€0.37matched
4capture01a19f7c-3084-7fb7-a473-dc8c8d88cff7€24.00€0.37matched
5capture01a19f7e-1fac-791f-9c47-63d9579e706c€24.00€0.37matched
6capture01a19f7e-3155-76ea-83ce-2d98d6c1ba57€24.00€0.37matched
7capture01a19f7e-4038-78a0-9ad7-d56d2b929f01€9.00€0.19matched
8capture01a19f7e-4fd5-740e-be92-2852e6958ac9€35.00€0.50matched
9capture01a19f7e-5b76-7b99-9ca0-276a57df0ab7€15.00€0.26matched
10capture01a19f7e-613a-7360-8c88-94ef8383c96f€15.00€0.26matched
11capture01a19f7e-78e6-7d65-8389-f42f0583f395€24.00€0.37matched
12capture01a19f7e-95c8-78eb-897e-d5010a47cd39€24.00€0.37matched
13capture01a19f7e-ad8a-7298-88e0-66aef53079da€49.00€0.67matched
14capture01a19f7f-2746-7615-a7f3-cdaeb54c2b6d€49.00€0.67matched
15capture01a19f7f-4d2a-7d6b-8823-5c6c648e9d99€24.00€0.37matched
16capture01a19f7f-6c68-7a9e-ae8c-969d90064381€24.00€0.37matched
17capture01a19f7f-784c-7520-994b-6d67c567fc55€9.00€0.19matched
18capture01a19f7f-8059-7280-a2fc-e263ee08a509€15.00€0.26matched
19capture01a19f7f-b0e8-757a-9052-dc08eddfa81f€9.00€0.19matched
20capture01a19f7f-f617-711d-b7c0-cd4cfabb69b7€49.00€0.67matched
21capture01a19f7f-fb49-7a29-91c8-289deff8d795€9.00€0.19matched
22capture01a19f80-1838-7e6c-8826-037d24c035e5€35.00€0.50matched
23capture01a19f80-2417-7921-ba68-05a52bfc8e18€24.00€0.37matched
24refund01a19f80-3356-7d7c-824f-7afbfdeebc0c-€5.00€0.00matched
25capture01a19f80-4d34-79ce-8c32-a17c2a920056€9.00€0.19matched
26capture01a19f80-5924-7dda-846a-ea57498c4dcd€24.00€0.37matched
27capture01a19f80-8f8e-730b-95e1-f98ef7d831b4€9.00€0.19matched
28capture01a19f80-c1e9-70e3-a44f-f568a72a1ce5€9.00€0.19matched
29capture01a19f80-cf30-7f69-a179-3a5912346482€49.00€0.67matched
30capture01a19f81-11c6-7a4b-9b21-320a46ac6082€49.00€0.67matched
31capture01a19f81-2def-727b-b8b9-7cfc1e992616€35.00€0.50matched
32capture01a19f81-33bd-7eab-aed8-3ccaa9eb7a45€9.00€0.19matched
34capture01a19f81-5467-7d0b-82b7-634b786d704f€24.00€0.37matched
35capture01a19f81-69ac-789a-a0a8-75b2ea9fdf3f€9.00€0.19matched
36capture01a19f81-70e5-7b63-9a8a-b16dfbc59820€24.00€0.37matched
37capture01a19f81-7d77-742f-8afd-db59cb1278df€15.00€0.26matched
38capture01a19f81-846d-729c-b561-4cf9445d227e€15.00€0.26matched
39capture01a19f81-9140-75aa-98c5-98d818e5a9cb€35.00€0.50matched
40capture01a19f81-aeeb-72ee-9931-431af130365a€9.00€0.19matched
41capture01a19f81-b926-76c6-946b-d38bf17e7b9e€24.00€0.37matched
42capture01a19f81-f8d0-70e7-ab3b-981a3a2b32c3€9.00€0.19matched
43capture01a19f82-02f0-7f54-b776-f5bb02869593€24.00€0.37matched
44capture01a19f82-06c1-71fc-a430-c8e6dc909c90€24.00€0.37matched
45capture01a19f82-3d06-7e9b-bbd7-24f60fe876bf€15.00€0.26matched
46capture01a19f82-49d8-70a4-b5cc-33372c995a0f€24.00€0.37matched
47capture01a19f82-65f4-7c45-be1d-3c32e90ad1db€35.00€0.50matched
48capture01a19f82-896b-719a-99fb-15bd3409af83€9.00€0.19matched
50refund01a19f82-9189-7444-8bc7-69be2285baac-€4.00€0.00matched
51capture01a19f82-a8a0-70a1-9e2a-4dd7c936afd3€49.00€0.67matched
52capture01a19f82-b585-7696-8ca0-4aa1b9165efa€15.00€0.26matched
53capture01a19f82-cc8f-712a-b985-bcff04c88f76€35.00€0.50matched
54capture01a19f83-16ce-715d-a852-0878e0f16700€35.00€0.50matched
55capture01a19f83-1925-7847-b1cd-77da580820e5€24.00€0.37matched
56refund01a19f83-1c6c-7fd1-b7bc-71fb04d8ebb1-€33.00€0.00matched
57capture01a19f83-260f-7866-b7e8-eb4ddcd91924€24.00€0.37matched
58capture01a19f83-38d1-7c6a-a216-4fa825c7b38b€9.00€0.19matched
59capture01a19f83-3e80-7ddb-b537-04090fed2800€9.00€0.19matched
60capture01a19f83-4347-7079-a767-675ab2cc5284€35.00€0.50matched
61capture01a19f83-4d77-743f-a5c6-3d8525c86987€24.00€0.37matched
62capture01a19f83-6bb8-7e87-80c5-455f6eecb3cd€24.00€0.37matched
63capture01a19f83-74a9-72d2-ab25-3df4249ce236€49.00€0.67matched
64refund01a19f83-980d-7bc3-bec9-701c6aef07de-€7.00€0.00matched
65capture01a19f83-a4b0-7a74-b0f6-2a317cd70eee€24.00€0.37matched
66capture01a19f83-b06c-7465-8734-3e4dad7f3637€49.00€0.67matched
67capture01a19f83-d1bb-7a44-a219-66cf874885bd€9.00€0.19matched
68capture01a19f83-d927-7373-8c26-2a390c9fd8bd€9.00€0.19matched
69capture01a19f83-e667-7b0f-bc06-c3ced025aece€24.00€0.37matched
70capture01a19f83-e720-7282-9359-f98317cd8a8e€49.00€0.67matched
71capture01a19f84-062b-73b4-a395-6e7d59b43fe2€9.00€0.19matched
72capture01a19f84-0f6b-7806-b4ac-56d28ac79fb2€9.00€0.19matched
73capture01a19f84-62e7-746c-be81-52e9b983de04€9.00€0.19matched
74capture01a19f84-7f51-7d9f-a356-dc47559215ae€9.00€0.19matched
75capture01a19f84-85a8-7066-8e18-ff1533fd695b€15.00€0.26matched
76capture01a19f84-8cb7-73fa-8948-733198f412b6€24.00€0.37matched
77capture01a19f84-908f-7e5f-86eb-55e42dd8ecce€49.00€0.67matched
78capture01a19f84-9487-7cdd-8e73-ed55b33c951f€9.00€0.19matched
79capture01a19f84-a510-76ec-a595-a068578896a7€15.00€0.26matched
80capture01a19f84-a5b2-7ce4-8f00-df64d9a5fa10€35.00€0.50matched
81capture01a19f84-aeb7-7b3e-84f0-ab74364c28ca€15.00€0.26matched
82capture01a19f84-b7fe-7cd4-bc1a-59306a22ba83€24.00€0.37matched
83capture01a19f84-dbf7-7212-bf46-4895b8607828€35.00€0.50matched
84capture01a19f84-ee66-79f1-8567-7f6ef7e53fe3€24.00€0.37matched
86capture01a19f85-008f-75f8-8770-f86bb718d9da€49.00€0.67matched
87capture01a19f85-1c85-7e21-9714-d5c29cef6783€15.00€0.26matched
88capture01a19f85-4933-704f-be69-f6ffe6dc75ff€35.00€0.50matched
89capture01a19f85-6722-79d4-be7d-4f0d8ac26aa7€35.00€0.50matched
90capture01a19f85-7629-7f75-b11e-72802512bb37€9.00€0.19matched
91capture01a19f85-84a0-7da2-b2d4-170c2846d8c5€49.00€0.67matched
92refund01a19f85-8f82-7301-9ebe-45e2c137fe1b-€25.00€0.00matched
93capture01a19f86-1657-7b4e-8e08-1012f9d67f2a€9.00€0.19matched
94capture01a19f86-3a4f-7096-890b-a438690d6ef2€9.00€0.19matched
95capture01a19f86-57b2-7b99-884b-63a13d7434b1€9.00€0.19matched
96capture01a19f86-5861-72cb-9565-68ea02ba532a€49.00€0.67matched
97capture01a19f86-6ade-78b0-8f6e-e3e9614c8dda€35.00€0.50matched
98capture01a19f86-6d02-7d22-98b8-1ba64a4b77b7€9.00€0.19matched
99capture01a19f86-6dc2-7f0c-a051-4bacb4c1b06a€15.00€0.26matched
100capture01a19f86-894f-7822-987a-bc24825a7295€15.00€0.26matched
101capture01a19f86-8e66-7a1e-899f-3e269c6237c2€9.00€0.19matched
102capture01a19f86-9f39-7757-9646-eeba07dc7ce5€9.00€0.19matched
103capture01a19f86-b27c-7705-a2c2-c3046787d95f€24.00€0.37matched
104capture01a19f86-bb06-79b7-951d-c0b06b1274f1€49.00€0.67matched
105refund01a19f86-d057-7e9f-bf3c-7dc3fa4b692c-€5.00€0.00matched
106capture01a19f86-dc64-7c81-89a7-d6e4f6e8deb3€35.00€0.50matched
107capture01a19f87-115f-7f93-b6c5-1c3a55d32e3b€15.00€0.26matched
108refund01a19f87-181e-7386-b3ae-8d8fbab11920-€9.00€0.00matched
109capture01a19f87-2150-73a8-b129-fd6019337efb€35.00€0.50matched
110capture01a19f87-2508-7d0a-b563-d321f49a2f80€35.00€0.50matched