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

4 Nov, 09:00

Gross

€2,512.00

PSP fee

€39.71

Net to the bank

€2,472.29

Settlement journal

#376649

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a5ca-bcda-7ea5-a516-351d7201ca26 is already settled by stl_EUR_2989638 line 20
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
LineKindReferenceGrossFeeStatus
21capture01a1a5ca-bd08-7d1e-be6f-92a8ab77e822€24.00€0.37duplicate line
75capture01a1a5cf-2343-71fd-8360-a1e8986a3c9a€24.00€0.41fee difference
1capture01a1a5c2-1093-7bca-b88c-8ba0d673bd6c€9.00€0.19matched
2capture01a1a5c2-ca60-7b31-8cfb-cc1ef0eaa48a€15.00€0.26matched
3capture01a1a5c9-6aed-72dd-9c6d-a669b399e19e€15.00€0.26matched
4capture01a1a5c9-730e-7a4e-b3e2-85b3f3a1aff3€35.00€0.50matched
5capture01a1a5c9-86f2-7028-bb24-b404addd929e€24.00€0.37matched
6capture01a1a5c9-948e-7812-a328-9bbc1b71cc5e€9.00€0.19matched
7capture01a1a5c9-ae32-7903-97c2-cbdc90abd7dd€49.00€0.67matched
8capture01a1a5c9-df33-790f-bbe3-6922c58248bf€24.00€0.37matched
9capture01a1a5c9-e132-7c93-9195-09b4a8e91892€15.00€0.26matched
10capture01a1a5c9-e4de-7e86-87e9-11b48d0f23e6€24.00€0.37matched
11capture01a1a5ca-0c21-7d05-8ff2-1923ebd0087f€24.00€0.37matched
12capture01a1a5ca-1b8f-7daa-8ff9-af1b136b9859€15.00€0.26matched
13refund01a1a5ca-2216-7640-bb75-e70b2c32ea89-€29.00€0.00matched
14capture01a1a5ca-4245-7ea6-9143-a7d848f96dd1€35.00€0.50matched
15capture01a1a5ca-4abd-7d00-8c1a-99f0d6e3afc6€15.00€0.26matched
16capture01a1a5ca-5b04-743b-84ef-c38d8dea9287€49.00€0.67matched
17capture01a1a5ca-6420-7318-aee2-a42b94819fa3€15.00€0.26matched
18capture01a1a5ca-968d-7b76-bc13-ca53b9985c4c€15.00€0.26matched
19capture01a1a5ca-a678-7e95-9113-4c8a4167bcb8€35.00€0.50matched
20capture01a1a5ca-bd08-7d1e-be6f-92a8ab77e822€24.00€0.37matched
22capture01a1a5ca-f23c-71cf-91cd-fdc3b6ee5aa5€24.00€0.37matched
23capture01a1a5cb-15be-761c-a20c-730bb98d9d1f€35.00€0.50matched
24capture01a1a5cb-26b8-72fd-9d47-8f74bc9fa218€9.00€0.19matched
25capture01a1a5cb-5565-7e7c-a57b-251e0c5523d6€35.00€0.50matched
26capture01a1a5cb-604e-7d0f-b3f1-bfafd9325046€15.00€0.26matched
27capture01a1a5cb-7112-7c67-a0ac-d259c7a5ad45€35.00€0.50matched
28capture01a1a5cb-8d3e-7c51-a3dc-11d0a0868979€35.00€0.50matched
29capture01a1a5cb-8fac-7a4f-bd60-cdd2d3936a93€24.00€0.37matched
30capture01a1a5cb-a33b-76d1-ad6b-2521303dc991€35.00€0.50matched
31capture01a1a5cb-a4a8-7428-aac1-51d5c2231a00€9.00€0.19matched
32capture01a1a5cb-ac26-74e0-95e6-ed60d6fbab69€9.00€0.19matched
33capture01a1a5cb-b2cb-75c6-b268-80bb0cd9bba8€9.00€0.19matched
34capture01a1a5cb-bf71-7a11-99a6-52216e1be63f€24.00€0.37matched
35capture01a1a5cb-c230-7e71-8044-61c705644363€15.00€0.26matched
36capture01a1a5cb-d39e-7b57-93d7-cdc898f1ea44€49.00€0.67matched
37capture01a1a5cb-cf61-7629-bade-6a97f9ea15a5€49.00€0.67matched
38capture01a1a5cb-f099-7dd0-9d89-a6fab2e47906€9.00€0.19matched
39capture01a1a5cb-fb59-7f8c-b9f1-b564712648fe€9.00€0.19matched
40capture01a1a5cc-0367-7e16-b86f-5fd76d052f20€9.00€0.19matched
41capture01a1a5cc-045f-754e-9085-8e1a7be936b8€49.00€0.67matched
42capture01a1a5cc-3ea7-7110-b2f1-d28bc8ec811e€24.00€0.37matched
43capture01a1a5cc-6015-798b-bfc7-81a03bd33621€35.00€0.50matched
44capture01a1a5cc-696d-7c22-b39b-dd6b47b42028€15.00€0.26matched
45capture01a1a5cc-ac79-7981-875a-1e8a33708083€15.00€0.26matched
46capture01a1a5cc-b86f-7498-80f7-285862538319€9.00€0.19matched
47capture01a1a5cc-ea04-7229-a336-0552d26d3d90€15.00€0.26matched
48capture01a1a5cd-0cbd-74c5-8bb9-64c5b57c350f€49.00€0.67matched
49capture01a1a5cd-0ea8-7052-a851-b9572a629552€49.00€0.67matched
50capture01a1a5cd-4522-7915-8be4-5cc61e78662d€49.00€0.67matched
51capture01a1a5cd-49ba-7ef7-9ae4-c81ca6893c46€9.00€0.19matched
52capture01a1a5cd-5136-7fae-9109-579a51be32e1€15.00€0.26matched
53capture01a1a5cd-568b-7d95-abbf-062aa01f5313€49.00€0.67matched
54capture01a1a5cd-5adc-71c5-9479-879b2d476c0e€24.00€0.37matched
55capture01a1a5cd-6082-7379-bd68-cb3c862160a7€24.00€0.37matched
56capture01a1a5cd-6d1d-715f-81b6-0274031162c5€9.00€0.19matched
57capture01a1a5cd-e33e-7813-a4a9-6b65bd3f97fd€15.00€0.26matched
58capture01a1a5ce-055c-7f56-881f-c356bae66099€9.00€0.19matched
59capture01a1a5ce-182e-778b-8583-fbc977ea2dcd€35.00€0.50matched
60capture01a1a5ce-1a34-7716-8109-703ce5e16f4e€49.00€0.67matched
61capture01a1a5ce-2175-7091-8af3-371b8978b985€15.00€0.26matched
62capture01a1a5ce-48bd-7a0f-878f-84c52e8f76c3€9.00€0.19matched
63capture01a1a5ce-4a52-7dcd-a825-4b0b24d76aea€24.00€0.37matched
64capture01a1a5ce-635b-7e5b-a353-a41353091e93€15.00€0.26matched
65capture01a1a5ce-638a-7d60-8c69-73841abf25b8€15.00€0.26matched
66capture01a1a5ce-6a09-7399-b488-76316cc93812€9.00€0.19matched
67capture01a1a5ce-7d5d-79d4-a428-0dfdd42b66cf€9.00€0.19matched
68capture01a1a5ce-8946-73ff-9b54-2ba84f09a914€49.00€0.67matched
69capture01a1a5ce-886f-7270-b675-5abc264f44b6€15.00€0.26matched
70capture01a1a5ce-9454-77d8-8cba-30389884eb17€9.00€0.19matched
71capture01a1a5ce-973f-74df-82ae-95db803372fc€49.00€0.67matched
72capture01a1a5ce-97c6-7190-9303-94d391b6e2b9€15.00€0.26matched
73refund01a1a5ce-d4f3-79c4-9af0-cf8a961200f7-€7.00€0.00matched
74capture01a1a5cf-1745-7973-8bae-0284858ba6da€9.00€0.19matched
76capture01a1a5cf-3850-73cb-8d35-ba78bc6860da€15.00€0.26matched
77capture01a1a5cf-44c5-7378-b523-c675a15868c5€35.00€0.50matched
78capture01a1a5cf-4a96-7bef-9726-43ca2821618d€15.00€0.26matched
79capture01a1a5cf-5b2a-71c1-864f-9c4c04d1f2c6€49.00€0.67matched
80capture01a1a5cf-758e-7dfe-b73f-331922dfc8eb€35.00€0.50matched
81capture01a1a5cf-9345-79e6-8dbe-15dc9910bc03€49.00€0.67matched
82capture01a1a5cf-a428-703a-b432-786c960c0211€24.00€0.37matched
83capture01a1a5cf-c5c1-78f1-937d-9e1189e45952€15.00€0.26matched
84capture01a1a5cf-cc7b-74ca-86b0-13db8a8419c6€35.00€0.50matched
85capture01a1a5cf-d378-7464-903e-b99802f84d7e€49.00€0.67matched
86capture01a1a5cf-f4dc-713f-ab67-016a41fe3837€15.00€0.26matched
87capture01a1a5cf-f5eb-7878-9fab-6813cf519fdb€35.00€0.50matched
88capture01a1a5cf-f7b1-71d7-87fe-8539c1116a96€9.00€0.19matched
89capture01a1a5d0-2713-7ea2-a34c-e166a1adbe2f€9.00€0.19matched
90capture01a1a5d0-31a8-7071-92c7-68e41769b574€9.00€0.19matched
91refund01a1a5d0-3b30-7d3e-a9df-6d44a2bd9a85-€2.00€0.00matched
92capture01a1a5d0-51eb-7344-931e-a4342161d5dc€15.00€0.26matched
93capture01a1a5d0-680f-7ca9-96fc-aa4ae9f3c321€35.00€0.50matched
94capture01a1a5d0-6c66-756e-a75e-ad3df92bbc90€24.00€0.37matched
95capture01a1a5d0-cdc7-7f61-81cd-71b48b4eff22€15.00€0.26matched
96capture01a1a5d0-d9c0-7d40-9519-d7ebab9f69f6€15.00€0.26matched
97capture01a1a5d1-052c-7ca4-905e-1ddec489b24c€35.00€0.50matched
98capture01a1a5d1-11df-7a85-8ae5-404564f75700€9.00€0.19matched
99refund01a1a5d1-2e29-7248-8e04-0f6465dd7f1f-€8.00€0.00matched
100capture01a1a5d1-38f4-73a2-b490-1647a6da21de€24.00€0.37matched
101capture01a1a5d1-5c69-7ea0-a87a-4c6964c4906a€49.00€0.67matched
102capture01a1a5d1-5fcd-71fc-bce6-7ba3c723768a€15.00€0.26matched
103capture01a1a5d1-8593-70e4-88e1-6190c2e9d46c€35.00€0.50matched
104capture01a1a5d1-bfed-7b1c-841f-27bfe392fdc4€15.00€0.26matched
105capture01a1a5d1-c8c3-7db4-a4ca-d5f6d1d6eeb3€9.00€0.19matched
106capture01a1a5d1-d4de-7c32-8511-0c73a14554c9€49.00€0.67matched
107capture01a1a5d2-06a1-7800-a1ad-60f6bd24f246€15.00€0.26matched
108capture01a1a5d2-0ed0-7e2c-ac2b-f21e67e24ba3€9.00€0.19matched
109capture01a1a5d2-0f58-72be-a30f-8ed98663b12e€24.00€0.37matched
110refund01a1a5d2-1694-70cf-963c-3b5d9a142f6d-€18.00€0.00matched
111capture01a1a5d2-32bc-70e6-997b-d62338d6cec1€35.00€0.50matched
112capture01a1a5d2-568f-7d59-973d-fbfe7c6096a8€15.00€0.26matched
113capture01a1a5d2-7148-7d81-a170-aa445b960e5e€15.00€0.26matched