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, 08:10

Gross

€2,315.00

PSP fee

€40.01

Net to the bank

€2,274.99

Settlement journal

#339502

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a19b51-6077-7dae-a5dd-60138b559595 is already settled by stl_EUR_2989345 line 32
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
LineKindReferenceGrossFeeStatus
23capture01a19b50-b390-7196-936e-715535e6b51f€49.00€0.70fee difference
33refund01a19b51-6079-722d-b59e-1623721bf029-€14.00€0.00duplicate line
79refund01a19b54-702d-77d0-b971-6e08a7965bf6-€33.00€0.03fee difference
1capture01a19b45-ea2c-7930-9246-4b86529a1d91€35.00€0.50matched
2refund01a19b4a-0e45-7e1f-bde8-55b952d55724-€11.00€0.00matched
3capture01a19b4e-e293-724b-9969-c9d62f772cde€24.00€0.37matched
4capture01a19b4e-ec32-73fe-8e7f-f8117f09b8f0€49.00€0.67matched
5capture01a19b4e-f480-7f01-9eba-e93c3333d1f6€35.00€0.50matched
6capture01a19b4e-f6b6-76e7-a646-f1374da858e3€49.00€0.67matched
7capture01a19b4e-f8b7-7d5c-a959-21fc529b2800€9.00€0.19matched
8capture01a19b4f-0826-7867-b165-82e2fae11377€15.00€0.26matched
9capture01a19b4f-190c-7430-a15b-17b2f61d29a1€9.00€0.19matched
10capture01a19b4f-1c0a-709c-862a-8108f9b86818€15.00€0.26matched
11capture01a19b4f-07b4-79ec-bf2d-3d370acd12f6€15.00€0.26matched
12refund01a19b4f-3d40-7063-b01a-362d08a358c5-€48.00€0.00matched
13capture01a19b4f-4ad9-7a4d-92de-17c927e9edd3€24.00€0.37matched
14capture01a19b4f-60f3-788f-aa7a-965f1ee335f7€24.00€0.37matched
15capture01a19b4f-aa6c-7c23-a20b-bc9c7ca2e80d€9.00€0.19matched
16capture01a19b4f-bd87-78fc-b0b2-1ca4845cc047€49.00€0.67matched
17capture01a19b4f-ecaa-7ce4-a2c5-d6baaa254c5a€9.00€0.19matched
18capture01a19b4f-f52d-7f86-836c-684488c04533€9.00€0.19matched
19capture01a19b50-1532-77a4-984c-a57ea84c72fd€35.00€0.50matched
20capture01a19b50-6119-7f53-ab2b-9980ed11ea02€24.00€0.37matched
21capture01a19b50-898d-7ab6-9750-a24c36a581c4€35.00€0.50matched
22capture01a19b50-950e-7ec8-8a6e-31328df46fe3€9.00€0.19matched
24capture01a19b50-b913-73f2-87cf-069ac05951a1€15.00€0.26matched
25capture01a19b50-e432-7ef1-b097-6fbe72c8e1cf€35.00€0.50matched
26capture01a19b50-e746-70ae-bdd2-35175eb81ec6€9.00€0.19matched
27capture01a19b51-097b-7a97-bced-e0da8670df0f€24.00€0.37matched
28capture01a19b51-0c7e-7a59-ae75-8312febd7f70€35.00€0.50matched
29capture01a19b51-1c81-7ce9-b411-ea766665f8d4€9.00€0.19matched
30capture01a19b51-2e7e-7935-91dc-430755b75f51€24.00€0.37matched
31capture01a19b51-5acb-7f9d-9d02-42daa1b6976f€24.00€0.37matched
32refund01a19b51-6079-722d-b59e-1623721bf029-€14.00€0.00matched
34capture01a19b51-5bf0-7512-82c0-a5556f8d7e4a€49.00€0.67matched
35capture01a19b51-86a5-7865-9ed4-4f03f8cca32c€9.00€0.19matched
36capture01a19b51-ac5d-7a5f-a950-7f83f39c64b7€24.00€0.37matched
37capture01a19b51-cb0e-7267-a5af-e52a52c4cb9c€35.00€0.50matched
38capture01a19b51-e2de-732b-afc7-b33d67d14919€49.00€0.67matched
39capture01a19b51-ed14-7f36-985c-539bdb303c0d€49.00€0.67matched
40capture01a19b51-f457-7c9f-8fa8-7c54f93aadd2€49.00€0.67matched
41capture01a19b51-ff14-7de6-b27a-4d67178c304f€24.00€0.37matched
42capture01a19b52-18b5-7f18-821b-2a85a46b1517€24.00€0.37matched
43refund01a19b52-18d4-7e66-a62a-be08c9164976-€28.00€0.00matched
44capture01a19b52-1c6b-70af-81fa-159bcf6ca4a5€49.00€0.67matched
45capture01a19b52-2eb4-75e9-816c-ad9e595d01c1€49.00€0.67matched
46refund01a19b52-3321-7d3a-957c-4d669cb4d3e7-€23.00€0.00matched
47capture01a19b52-4746-79b3-93d1-1aa0d81b6c33€15.00€0.26matched
48capture01a19b52-4d45-7151-a745-13149edaf2c7€49.00€0.67matched
49capture01a19b52-566d-7df4-a8c2-eb9383b96a06€9.00€0.19matched
50refund01a19b52-56b5-70b0-b288-f607b39d5a3d-€42.00€0.00matched
51capture01a19b52-710f-73f1-a910-f42f03dbf60e€24.00€0.37matched
52capture01a19b52-754a-7dbc-96ba-8c969ba194b1€15.00€0.26matched
53capture01a19b52-c1fa-71a9-a32e-bfb31494b1f3€49.00€0.67matched
54capture01a19b52-d3be-70c9-a913-ebf95c279681€49.00€0.67matched
55capture01a19b52-fd45-79d0-948e-3c0e8918ddf6€9.00€0.19matched
56capture01a19b52-fe3c-70bb-b937-be974716dbdd€15.00€0.26matched
57capture01a19b53-016a-738f-a339-e3fce6232638€49.00€0.67matched
58capture01a19b53-0a02-7db4-8a14-f5cdfae0bf04€49.00€0.67matched
59capture01a19b53-23b8-72e4-a161-4f9a6a380f01€49.00€0.67matched
60capture01a19b53-2bbe-73ac-9086-4fccddff4b62€15.00€0.26matched
61capture01a19b53-2ce0-771a-96f8-21a66cc2ed43€9.00€0.19matched
62refund01a19b53-7273-7490-bd47-8d13f76709a5-€24.00€0.00matched
63capture01a19b53-7cfa-7632-8cbc-a37a717639d0€35.00€0.50matched
64refund01a19b53-7ff4-75ba-a1ee-f8004e661819-€18.00€0.00matched
65capture01a19b53-872b-7a89-920a-df03ad311d61€9.00€0.19matched
66capture01a19b53-9162-7482-92c6-a518e34d26be€15.00€0.26matched
67capture01a19b53-adf7-7938-b254-c0c868574686€9.00€0.19matched
68capture01a19b53-cac1-71a8-aca7-71760afa19fe€35.00€0.50matched
69capture01a19b53-cddf-7dd0-a837-fe077bd1ebd5€15.00€0.26matched
70capture01a19b53-f1e4-766b-b293-cf274a47f1ec€24.00€0.37matched
71refund01a19b54-0752-7976-8c0c-6ab3707d73e7-€6.00€0.00matched
72capture01a19b54-20a8-7c3e-a15b-6251e6e03892€49.00€0.67matched
73capture01a19b54-30a1-778b-944a-ea0f630505e2€24.00€0.37matched
74capture01a19b54-3178-7322-b860-03969c3a5ca0€24.00€0.37matched
75capture01a19b54-46a3-7e4a-8995-a9cb72ed312e€15.00€0.26matched
76capture01a19b54-5781-74a4-9d48-718fcf725bf6€15.00€0.26matched
77capture01a19b54-5b10-775e-8b14-79716ccfe1a4€15.00€0.26matched
78capture01a19b54-66c6-7364-9f1e-0d27fc2f3e99€15.00€0.26matched
80refund01a19b54-82a0-737f-a260-94043c27d938-€14.00€0.00matched
81capture01a19b54-8efa-739e-8079-1bfbd4fed770€15.00€0.26matched
82capture01a19b54-a678-742a-a2e7-b94f7a5fa9a2€24.00€0.37matched
83capture01a19b54-b05b-71f1-aec6-cf1dba3d34ba€15.00€0.26matched
84refund01a19b54-b172-7f75-8798-9e59f5a1ed5b-€8.00€0.00matched
85capture01a19b54-c748-7193-975e-8106ba288809€9.00€0.19matched
86capture01a19b54-d414-707c-934b-a6d41b3fe22d€35.00€0.50matched
87capture01a19b54-ff0f-76ac-88ab-90cab83b8797€9.00€0.19matched
88capture01a19b55-09bc-7407-9eaf-c971e1e7574e€15.00€0.26matched
89capture01a19b55-357d-7066-94ad-21b5771db5f3€15.00€0.26matched
90capture01a19b55-49ca-7b8e-9c01-63e31342bc40€15.00€0.26matched
91capture01a19b55-626f-7a77-8c5c-44ef1a590bc6€35.00€0.50matched
92capture01a19b55-7315-7185-b3ca-c40b7f0e3c80€24.00€0.37matched
93capture01a19b55-85a1-71c5-9810-ebd554643677€24.00€0.37matched
94capture01a19b55-9afb-7ed6-b1a0-aca44b901b05€24.00€0.37matched
95capture01a19b55-adac-7212-91d0-9a9dd0178ff8€9.00€0.19matched
96capture01a19b55-b68d-7b8d-ba6a-aec616f7c064€9.00€0.19matched
97capture01a19b55-d339-7d5c-a258-9ebd81737ffc€24.00€0.37matched
98capture01a19b55-de1b-7dd7-8b33-081645f1c270€24.00€0.37matched
99capture01a19b55-e987-75fd-b0d2-986a7a72fb08€15.00€0.26matched
100capture01a19b56-00fb-7193-bd52-52d24d9e7663€9.00€0.19matched
101capture01a19b56-1efe-73b1-a6cb-6e8236f8ec75€15.00€0.26matched
102capture01a19b56-1f3a-73d4-a74b-90507318f3bc€9.00€0.19matched
103capture01a19b56-3645-748a-8004-e8f8cd1588d7€24.00€0.37matched
104capture01a19b56-4c77-7245-a3ce-2520f9c67cc4€35.00€0.50matched
105capture01a19b56-89e6-7fa3-bac3-f05a031d27a1€24.00€0.37matched
106capture01a19b56-934f-7dd2-bcb6-c7e38e80619d€15.00€0.26matched
107capture01a19b56-9aaf-7d7c-90ed-c0ad8f5bc34f€24.00€0.37matched
108capture01a19b56-b264-78c5-aae9-d082f125f759€35.00€0.50matched
109capture01a19b56-b927-74f9-bd97-1d5d1d03b4f5€24.00€0.37matched
110capture01a19b56-c764-7bcf-8896-97f56e03124d€15.00€0.26matched
111capture01a19b56-ca69-749d-9440-2ce8262ae5f3€9.00€0.19matched
112capture01a19b56-d302-740a-b3e1-aaca578cef98€35.00€0.50matched
113capture01a19b56-df9b-7bfc-9c41-6ac07c6b47dd€24.00€0.37matched
114capture01a19b56-f944-74b3-8745-0321f901e2ad€24.00€0.37matched
115capture01a19b57-3f62-75ae-a97e-f5d46ffbdd5c€15.00€0.26matched
116capture01a19b57-6914-7ef9-b925-3aefa570091e€9.00€0.19matched
117capture01a19b57-9f46-7115-8c76-1d967aac0468€15.00€0.26matched
118capture01a19b57-ba7e-70c1-bee8-e71fa77c91f1€24.00€0.37matched
119capture01a19b57-c7cc-71e5-bba1-a18516d17840€24.00€0.37matched
120capture01a19b57-e985-770b-b98b-7af702308184€15.00€0.26matched
121capture01a19b57-e9f9-77c5-adf8-70832891863f€15.00€0.26matched