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, 20:00

Gross

€3,099.00

PSP fee

€48.88

Net to the bank

€3,050.12

Settlement journal

#366818

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a303-3aa9-7a8f-86e5-324a6e24c389 is already settled by stl_EUR_2989560 line 57
  • duplicate linethe file lists it twicerefund:01a1a306-b8d5-7416-ad0a-1113d3aafcc2 is already settled by stl_EUR_2989560 line 105
  • duplicate linethe file lists it twicecapture:01a1a307-d159-7f5c-9369-f61d8bda5731 is already settled by stl_EUR_2989560 line 117
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1a305-5555-7cef-a65f-95e477c8c3b1 is in no file
  • missing linein the books, not in the filecapture:01a1a305-9bc7-76f3-8517-da7f9ed808c4 is in no file
LineKindReferenceGrossFeeStatus
48capture01a1a302-a818-748d-811c-3314282bca78€9.00€0.22fee difference
58capture01a1a303-3ad7-7c8e-8d4e-a6a10ebeeb87€35.00€0.50duplicate line
97capture01a1a306-0a2d-73fd-b9f2-c25a9346eb31€49.00€0.72fee difference
106refund01a1a306-b8d6-7bcc-951d-8be5fe3b5e88-€19.00€0.00duplicate line
118capture01a1a307-d185-758d-9472-7a62039b3f32€24.00€0.37duplicate line
1capture01a1a2f8-5d07-788e-8654-84553dbd617a€49.00€0.67matched
2capture01a1a2fa-a6d8-7d03-a877-84ad9778b5f0€49.00€0.67matched
3capture01a1a2fa-e0b6-7abe-be9d-6311e8668b9a€49.00€0.67matched
4capture01a1a2fb-c7ff-78c4-82e6-5477c5ae54b3€35.00€0.50matched
5refund01a1a2ff-4b11-7e47-bffa-d412b83c5d9d-€2.00€0.00matched
6capture01a1a2ff-7bf5-7da5-a08b-abc899ceee5f€49.00€0.67matched
7capture01a1a2ff-7ea7-78c7-83ea-8e03beff9aeb€15.00€0.26matched
8capture01a1a2ff-841c-724c-a3c4-f6d32a8f15b8€9.00€0.19matched
9capture01a1a2ff-8be0-7c13-9dfc-26df6577c2fc€9.00€0.19matched
10capture01a1a2ff-8ebe-72d0-9a7f-1ff9d94c0a2e€15.00€0.26matched
11capture01a1a2ff-9ef6-71d3-993a-f232e9838490€35.00€0.50matched
12capture01a1a2ff-a9f3-736d-9705-7eb318719a2b€49.00€0.67matched
13capture01a1a2ff-bd2e-77aa-9240-1ff0ea91d0e3€9.00€0.19matched
14capture01a1a300-03ad-7cbd-a95f-af717fdd394e€35.00€0.50matched
15refund01a1a300-13f7-760a-a315-a5510d5ba559-€16.00€0.00matched
16capture01a1a300-541d-7d64-aa43-a57e7591eb39€49.00€0.67matched
17capture01a1a300-5879-753a-8b92-7f09f9c2bd61€35.00€0.50matched
18capture01a1a300-9504-7dc4-9431-882f13b3931c€24.00€0.37matched
19capture01a1a300-c1a8-720b-ad3e-4d20e6bd9c9b€35.00€0.50matched
20capture01a1a300-e956-7d2a-8ace-b2bf7fd18eb7€9.00€0.19matched
21capture01a1a300-e95c-73b8-b116-08310131d5c3€15.00€0.26matched
22capture01a1a300-eb84-7647-9b4e-0cdd10b48421€15.00€0.26matched
23capture01a1a301-16a4-7786-93c0-1df156c042c8€35.00€0.50matched
24capture01a1a301-1a11-7a31-b448-c545668563af€35.00€0.50matched
25refund01a1a301-2107-7a27-b6a1-4a8981d41c81-€13.00€0.00matched
26refund01a1a301-2f65-73b5-98bd-5fb16cae466c-€14.00€0.00matched
27capture01a1a301-66d8-700b-8593-16d4be466874€49.00€0.67matched
28capture01a1a301-a9c1-7c82-84f0-248658f4bca8€49.00€0.67matched
29capture01a1a301-b3c2-7f8e-8e85-422a77e63145€35.00€0.50matched
30capture01a1a301-ba19-763a-b368-0b6b386e3d2e€49.00€0.67matched
31capture01a1a301-ba95-7769-ae6a-5e07ff65d32f€35.00€0.50matched
32capture01a1a301-c6ae-788e-9914-a530d58a0362€49.00€0.67matched
33capture01a1a301-d555-70ce-8114-10f54e5fe491€15.00€0.26matched
34capture01a1a301-e337-7fdf-8623-d1fe4a4c069e€9.00€0.19matched
35capture01a1a301-e9eb-74de-b859-5e5cf3aeea9b€9.00€0.19matched
36capture01a1a301-eead-7a02-ae5f-31d29b9908b8€15.00€0.26matched
37capture01a1a302-176f-74bc-918c-792a4d11a1e1€49.00€0.67matched
38capture01a1a302-1574-725d-818f-5dc45cfa0198€49.00€0.67matched
39capture01a1a302-204c-7c29-ab67-0c3192b669ad€9.00€0.19matched
40capture01a1a302-418b-73e3-b7cb-6e1b529df7c9€49.00€0.67matched
41capture01a1a302-4afa-7f71-97e1-539d85f6b5a2€9.00€0.19matched
42refund01a1a302-525f-779c-a023-87ba4c5cf8db-€5.00€0.00matched
43capture01a1a302-7738-73d8-97e0-1a40f257eaf7€49.00€0.67matched
44capture01a1a302-8a9a-74d9-b682-3193aeb94bd3€35.00€0.50matched
45capture01a1a302-9464-76e3-883c-91b4f1fbf06e€35.00€0.50matched
46capture01a1a302-9bf5-7364-b4f7-05f37d58d2f0€9.00€0.19matched
47capture01a1a302-a798-71d1-b589-0ec2a96efc7d€49.00€0.67matched
49capture01a1a302-c851-70c2-97a3-0f2f0c477716€35.00€0.50matched
50capture01a1a302-f099-73da-a08e-d91deed38323€35.00€0.50matched
51capture01a1a302-f464-7791-ac64-e57ffa2364d9€9.00€0.19matched
52capture01a1a302-f68e-77b3-bb31-82f0dc89fde4€9.00€0.19matched
53refund01a1a302-fe05-7c02-bc74-4d700351fc29-€10.00€0.00matched
54capture01a1a303-1c8f-76d7-9709-ace05139d812€15.00€0.26matched
55capture01a1a303-3321-780f-befe-9b0a666209f4€49.00€0.67matched
56refund01a1a303-3a4f-76fe-ad2f-ee93ed908d07-€9.00€0.00matched
57capture01a1a303-3ad7-7c8e-8d4e-a6a10ebeeb87€35.00€0.50matched
59capture01a1a303-3ed8-78ce-9ea6-434f32a95e32€15.00€0.26matched
60capture01a1a303-7d40-730c-9b0a-3986598e0e5e€35.00€0.50matched
61capture01a1a303-9713-789d-8497-8ab615046252€9.00€0.19matched
62capture01a1a303-b750-76e4-b27e-ab2e77a26644€49.00€0.67matched
63capture01a1a303-c279-7d33-9ff6-240b633dacb1€15.00€0.26matched
64capture01a1a303-e697-798d-89e7-6aa46e728e46€9.00€0.19matched
65capture01a1a304-13d7-7ff9-bec7-fe217e1dd9d6€15.00€0.26matched
66capture01a1a304-241c-73d1-9186-0ded5caff7f6€15.00€0.26matched
67capture01a1a304-27da-7ed5-ad54-29aafed30bbf€35.00€0.50matched
68capture01a1a304-322b-775e-89a8-950574651a41€35.00€0.50matched
69capture01a1a304-446e-78fb-bfe9-fd395d4bac0a€49.00€0.67matched
70capture01a1a304-7379-7bda-bd34-ac50f2757326€35.00€0.50matched
71capture01a1a304-8524-73aa-916d-f6cf96e20597€24.00€0.37matched
72capture01a1a304-936f-7c24-b6f1-985eebff8432€35.00€0.50matched
73capture01a1a304-94cc-706d-a48e-bf41e80ce369€15.00€0.26matched
74capture01a1a304-ab48-7f5a-9a5e-a881d6e130e7€24.00€0.37matched
75capture01a1a304-b6b4-746b-85fb-d5dc305b0f64€35.00€0.50matched
76capture01a1a304-bba3-77b9-98c5-0174ce0f42b6€9.00€0.19matched
77capture01a1a304-bc8a-7423-9ece-f9eb43477a0c€24.00€0.37matched
78capture01a1a304-cf55-73b1-b5ff-95dfc5461b6c€9.00€0.19matched
79capture01a1a304-d005-7a17-99fd-49294c8168ac€24.00€0.37matched
80capture01a1a304-e197-76ae-825d-bff1b1f02e2f€15.00€0.26matched
81refund01a1a304-e379-7a29-a560-5f314b964f57-€5.00€0.00matched
82capture01a1a304-fc00-774b-b535-ec84e2edd4d1€35.00€0.50matched
83refund01a1a305-151d-76ac-ad56-0c9e2b642a9d-€9.00€0.00matched
84capture01a1a305-1933-7099-b909-829b8ef2005b€35.00€0.50matched
85capture01a1a305-1e87-763e-863d-91cecf982320€49.00€0.67matched
86refund01a1a305-27d1-7592-baf4-5ebd1a66d282-€24.00€0.00matched
87capture01a1a305-33dd-7779-b6d9-55993fa3532d€49.00€0.67matched
88capture01a1a305-3ef4-7fdb-99c2-c1660fe2a6f8€15.00€0.26matched
89capture01a1a305-427f-7c83-bbc8-f95a89dad0c1€24.00€0.37matched
90capture01a1a305-4a2b-7a68-b735-fb277adb4943€49.00€0.67matched
91capture01a1a305-4b68-7541-94bb-7b74ae976ccc€35.00€0.50matched
92capture01a1a305-5e87-7631-9d29-04660c0657ed€49.00€0.67matched
93capture01a1a305-6858-7d96-8ea3-7becfdbcd2ac€24.00€0.37matched
94capture01a1a305-9df5-74bf-9508-f2508d7b463b€49.00€0.67matched
95capture01a1a305-b48a-7f96-bc3b-1ff29b76b5dc€35.00€0.50matched
96capture01a1a305-bff0-75cc-8596-07acecab0446€15.00€0.26matched
98capture01a1a306-2441-7668-a098-dd68a7729579€15.00€0.26matched
99capture01a1a306-4e54-7119-9f23-6e9e8710e46c€9.00€0.19matched
100capture01a1a306-50d6-71b5-8a93-2f056857c905€9.00€0.19matched
101capture01a1a306-6314-73e9-9176-664c586e70f3€24.00€0.37matched
102capture01a1a306-6a4e-7717-bda7-b2e9cf858ab2€49.00€0.67matched
103capture01a1a306-9422-773e-966c-e5713dea43f6€9.00€0.19matched
104capture01a1a306-9596-7e85-beea-cc5d983c90ca€9.00€0.19matched
105refund01a1a306-b8d6-7bcc-951d-8be5fe3b5e88-€19.00€0.00matched
107capture01a1a306-c352-7e29-83fc-8b1f76cb9e35€9.00€0.19matched
108refund01a1a306-c6c5-7e7a-8941-340e0496fe73-€9.00€0.00matched
109capture01a1a307-1234-7478-9a85-5b027253b97c€35.00€0.50matched
110capture01a1a307-18f9-7c11-80c3-1dd0337272e4€49.00€0.67matched
111capture01a1a307-2949-71e5-a96e-0f5a6276e803€49.00€0.67matched
112capture01a1a307-3a4f-7e69-aa12-18bcf5d36592€35.00€0.50matched
113capture01a1a307-826e-7a97-939f-f083750d6602€15.00€0.26matched
114refund01a1a307-a339-7e44-b510-0c9a0086d593-€26.00€0.00matched
115capture01a1a307-bb18-743f-80fd-92a58c7f691d€35.00€0.50matched
116capture01a1a307-cb10-72db-8911-3d6cbaa4837c€24.00€0.37matched
117capture01a1a307-d185-758d-9472-7a62039b3f32€24.00€0.37matched
119capture01a1a307-d766-7e05-a9fc-e96a936212aa€24.00€0.37matched
120capture01a1a307-f8e8-7c0d-957f-63b855c37a8d€49.00€0.67matched
121capture01a1a307-f96c-7fb9-8f29-e96c28a0d035€49.00€0.67matched
122capture01a1a308-0a9c-753f-ad85-e324fb363ed8€15.00€0.26matched
123refund01a1a308-0c12-7551-81de-a1fbf34ea389-€14.00€0.00matched
124capture01a1a308-12fb-7655-bd63-839d8ded2396€15.00€0.26matched
125capture01a1a308-17d1-7e5d-9206-22ece8261222€35.00€0.50matched
126capture01a1a308-21b5-706d-a7ef-c9273031e582€35.00€0.50matched
127capture01a1a308-4f39-7b27-987f-4e494f90a706€35.00€0.50matched
128capture01a1a308-50ed-76a2-a638-425a328b0cd3€35.00€0.50matched
129refund01a1a308-632f-7942-a4de-32f6505daf77-€10.00€0.00matched