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, 18:30

Gross

€2,944.00

PSP fee

€47.01

Net to the bank

€2,896.99

Settlement journal

#402206

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ad00-0983-764b-94cb-22d53a443913 is already settled by stl_EUR_2989839 line 93
LineKindReferenceGrossFeeStatus
94capture01a1ad00-09bd-76ac-a34c-c93644271162€49.00€0.67duplicate line
1capture01a1acf9-a544-7461-9f7a-6fecd9361890€24.00€0.37matched
2capture01a1acf9-ab15-77e0-9820-7100c60a9223€24.00€0.37matched
3capture01a1acf9-c2e5-757d-bd25-c77012de28f7€49.00€0.67matched
4capture01a1acf9-ce37-797e-abe4-f95392005d2f€9.00€0.19matched
5capture01a1acf9-dc9e-74a8-bb9f-cdeb0e5b1623€35.00€0.50matched
6capture01a1acf9-facb-715f-84f6-d43e445f6e7c€9.00€0.19matched
7capture01a1acfa-236b-7e75-8797-71c8c3dacb5b€24.00€0.37matched
8capture01a1acfa-2a08-7a19-93aa-1e7f3b50670c€49.00€0.67matched
9capture01a1acfa-33d9-7ec9-a005-d434ee1c45b9€35.00€0.50matched
10capture01a1acfa-3555-70cc-bd16-9db5fbabaec6€49.00€0.67matched
11capture01a1acfa-4c13-7649-a349-e8a85de8ea00€15.00€0.26matched
12capture01a1acfa-547b-7a23-b2d3-d2d9c6bbf8ac€24.00€0.37matched
13capture01a1acfa-6f8e-7b86-8add-d7d4793c9ed0€9.00€0.19matched
14capture01a1acfa-749f-760d-bd34-5afb548f9a0c€24.00€0.37matched
15capture01a1acfa-7621-7176-a60b-9ce17befdbdb€49.00€0.67matched
16capture01a1acfa-7cbf-7455-92c7-b2ac682ca262€35.00€0.50matched
17capture01a1acfa-ad23-731f-89b6-42f48331da82€15.00€0.26matched
18refund01a1acfa-b40a-7e5e-a5ea-366257eaf75d-€5.00€0.00matched
19capture01a1acfa-b850-7eea-92c9-a8b457a622ef€24.00€0.37matched
20capture01a1acfa-be4c-7231-b090-6a83e5ce7639€15.00€0.26matched
21capture01a1acfa-d5cf-77b0-ab85-4d172d194eef€9.00€0.19matched
22capture01a1acfa-f1f0-7fb8-8bea-0d5bedbab1ef€49.00€0.67matched
23capture01a1acfb-0371-71e7-800b-86ec5c561f6d€24.00€0.37matched
24capture01a1acfb-0a56-787a-bc80-7dd07f1861f5€9.00€0.19matched
25capture01a1acfb-0af6-7898-884e-2e6f77eada62€35.00€0.50matched
26capture01a1acfb-1578-71f6-8029-a410f8a790ef€15.00€0.26matched
27capture01a1acfb-1f48-795c-9cd9-7cf67306ee92€35.00€0.50matched
28capture01a1acfb-5c92-792a-b276-6d4e4e1fe530€24.00€0.37matched
29capture01a1acfb-7338-7471-a74b-b5f035ddb70d€35.00€0.50matched
30capture01a1acfb-7d59-7ec1-b88e-d3ae86dcdc7b€35.00€0.50matched
31capture01a1acfb-8673-7c4e-b8ea-91facf88a68b€24.00€0.37matched
32capture01a1acfb-8dce-707c-bccc-51e8d9159bd7€15.00€0.26matched
33capture01a1acfb-bbab-706c-b0e4-2fc5b263304d€15.00€0.26matched
34capture01a1acfb-bd31-711a-9dee-f6bafd98a80e€35.00€0.50matched
35capture01a1acfb-be4a-7c2c-adb8-936809f3fdf3€24.00€0.37matched
36capture01a1acfb-c8c7-7bec-9f6d-19dd5717b30c€49.00€0.67matched
37capture01a1acfb-df85-72a9-840f-9a36da0460cd€49.00€0.67matched
38capture01a1acfb-e935-7b49-bdb7-fcac61bb4b27€49.00€0.67matched
39capture01a1acfc-09fd-7d9d-a305-57fd6314a53f€49.00€0.67matched
40refund01a1acfc-10c6-7e3e-83bf-e47c45a797e6-€29.00€0.00matched
41capture01a1acfc-14af-7ddb-b968-93ee13df4b0f€35.00€0.50matched
42capture01a1acfc-3595-7407-b649-d2890b43ba7d€24.00€0.37matched
43capture01a1acfc-48d0-7c77-afd6-b268ec6a5250€35.00€0.50matched
44capture01a1acfc-67f8-70e1-a02e-2609aace18d6€35.00€0.50matched
45capture01a1acfc-905a-7239-a321-ecdc8eba3f90€9.00€0.19matched
46capture01a1acfc-9a40-786b-896b-f177e5b1d575€9.00€0.19matched
47capture01a1acfc-9db3-7501-93a2-73cafa5bfb77€49.00€0.67matched
48capture01a1acfc-a29b-7e59-ad0b-bb985f661d8b€35.00€0.50matched
49capture01a1acfc-cd2a-7584-a9f6-d1df157b9456€9.00€0.19matched
50capture01a1acfc-cf8b-73af-99fc-173436a52eba€35.00€0.50matched
51capture01a1acfc-eb6b-7d7c-925b-39e58f3bfad1€15.00€0.26matched
52capture01a1acfd-08d2-78d3-9384-58d68f07fae0€9.00€0.19matched
53capture01a1acfd-0a70-7283-b0f9-cc09dbcf65ed€9.00€0.19matched
54capture01a1acfd-1936-76ea-a4a4-34b167b25b91€15.00€0.26matched
55capture01a1acfd-2a41-7ba9-a9e8-dbd6d61c4f03€9.00€0.19matched
56capture01a1acfd-2ef1-7ec5-8d76-7bd65e0f9232€24.00€0.37matched
57capture01a1acfd-4cba-733f-8cb4-701651a3c97a€9.00€0.19matched
58capture01a1acfd-7057-778e-a539-739a855d37eb€24.00€0.37matched
59capture01a1acfd-7971-7a5a-9ef2-a1146ce863ae€24.00€0.37matched
60capture01a1acfd-880e-7602-84d5-64b45cfa1f5e€35.00€0.50matched
61capture01a1acfd-ad27-787d-9427-b846c6d47db4€24.00€0.37matched
62refund01a1acfd-bec2-7973-ba18-db7add2b2760-€23.00€0.00matched
63capture01a1acfd-bee1-7968-bd86-209621236bbd€35.00€0.50matched
64capture01a1acfd-c81c-7502-9037-4a9375dd5c2b€24.00€0.37matched
65capture01a1acfd-c88b-78d8-99c9-f94d0d38de4d€35.00€0.50matched
66capture01a1acfd-de4b-719a-a270-bed3c0d91d4e€35.00€0.50matched
67capture01a1acfe-1442-7c94-9231-57fee1990c9e€35.00€0.50matched
68capture01a1acfe-264a-7307-8276-c686ce472486€35.00€0.50matched
69capture01a1acfe-2a89-7202-bbd6-e1f2b4aff4ab€49.00€0.67matched
70capture01a1acfe-2b7d-73d8-a9a7-b5367119caa1€15.00€0.26matched
71capture01a1acfe-3241-7bce-9c97-5bd313d3cb69€49.00€0.67matched
72capture01a1acfe-35ec-75ec-9a53-7730b5c7a341€35.00€0.50matched
73capture01a1acfe-5e2a-7fcc-84b0-36dfbf05cca8€9.00€0.19matched
74capture01a1acfe-7f36-72b2-8139-c5e1f2eb913e€24.00€0.37matched
75capture01a1acfe-89e7-7372-b6f2-36b9148445dd€24.00€0.37matched
76capture01a1acfe-941f-70c2-8e53-3bedc4322b90€49.00€0.67matched
77capture01a1acfe-9460-7595-92b0-9e9961c42975€9.00€0.19matched
78capture01a1acfe-9923-74e7-bd4a-49a2cc232cfa€49.00€0.67matched
79capture01a1acfe-e3be-756b-92b3-dd45659ea368€9.00€0.19matched
80refund01a1acfe-ea85-75bf-8d52-58fd3d81f252-€25.00€0.00matched
81capture01a1acfe-f4b7-7739-b788-997b1e957439€9.00€0.19matched
82capture01a1acff-161e-76a2-b8f4-257a2ebf78b9€35.00€0.50matched
83capture01a1acff-26f0-73f4-ba3e-1ba4fce636e7€35.00€0.50matched
84capture01a1acff-4553-7eaf-ad25-0a55b92847ad€49.00€0.67matched
85capture01a1acff-5a80-702b-85a5-07dab9bc262d€9.00€0.19matched
86capture01a1acff-5d8b-7380-ae52-a63db534441d€15.00€0.26matched
87capture01a1acff-5fd8-7b8e-a4a5-b378c1d5d94d€49.00€0.67matched
88capture01a1acff-79ae-716b-933b-27696b72d48a€9.00€0.19matched
89capture01a1acff-9346-70e5-b397-715ab553d57a€24.00€0.37matched
90capture01a1acff-9cb6-7d04-a12e-c2705b85f7d6€24.00€0.37matched
91capture01a1acff-b26b-79a6-b173-c8769d0896c3€9.00€0.19matched
92capture01a1acff-c233-701d-8c45-62b8d0837fbd€24.00€0.37matched
93capture01a1ad00-09bd-76ac-a34c-c93644271162€49.00€0.67matched
95capture01a1ad00-0e0f-7a37-8176-917121a47c38€9.00€0.19matched
96capture01a1ad00-125e-7a60-9816-16a61dd26371€15.00€0.26matched
97capture01a1ad00-1604-7b2e-a17e-8ddba7408c5e€24.00€0.37matched
98capture01a1ad00-30c4-7d7b-b629-3b02bb969f67€15.00€0.26matched
99capture01a1ad00-4138-78f5-bb97-c6dfefee1efe€15.00€0.26matched
100capture01a1ad00-63c2-73cb-9687-1c5be65af08f€24.00€0.37matched
101capture01a1ad00-7b4c-7da0-9c83-43af816b1029€24.00€0.37matched
102capture01a1ad00-9f9b-719e-9ecf-aa294fd4fdb1€35.00€0.50matched
103refund01a1ad00-a078-7db1-8489-10a57213c9a5-€11.00€0.00matched
104capture01a1ad00-c10c-73a6-a5f2-c2d4a3f68656€15.00€0.26matched
105capture01a1ad00-d73c-7305-af98-dda458c29136€49.00€0.67matched
106capture01a1ad00-dff6-7f7c-bc7f-3811896b4616€15.00€0.26matched
107capture01a1ad00-e5d4-73a8-a0df-094ecc68c64f€35.00€0.50matched
108refund01a1ad00-eb47-750c-af3b-efc16ec819a4-€4.00€0.00matched
109capture01a1ad00-f3e1-7dd9-bca3-79f38edd5c2d€49.00€0.67matched
110capture01a1ad00-fd21-7d58-95ae-480a255df54a€35.00€0.50matched
111capture01a1ad01-073c-7dd1-954c-96571d27a1a6€49.00€0.67matched
112capture01a1ad01-1cd6-72a1-ad01-fffa73df8324€35.00€0.50matched
113capture01a1ad01-2719-7f86-ad6b-5eb448cd1b72€15.00€0.26matched
114capture01a1ad01-4065-7f3b-a296-9a92fea67f51€9.00€0.19matched
115capture01a1ad01-4360-7170-ae4d-f7151d2de9cf€9.00€0.19matched
116capture01a1ad01-4485-747c-a00f-c3d6026fc66b€24.00€0.37matched
117capture01a1ad01-4936-754f-9c13-8a061a2cd351€9.00€0.19matched
118refund01a1ad01-5a6a-7dbe-9942-cd551702be34-€46.00€0.00matched
119capture01a1ad01-8bde-7bf5-86cf-987b15166b3b€35.00€0.50matched
120capture01a1ad01-a1f7-7892-a267-3d53adf2e4fb€15.00€0.26matched
121capture01a1ad01-b59f-7855-b8a4-6cd0420980f3€9.00€0.19matched
122capture01a1ad01-bf71-766c-aef0-1a680de7973a€35.00€0.50matched
123capture01a1ad01-ce6d-7347-b4b8-343e9b925239€15.00€0.26matched
124refund01a1ad02-0cb1-7f20-bb0a-2d459c5e5c66-€32.00€0.00matched
125capture01a1ad02-52be-70ab-b9b1-aaed92bf0962€9.00€0.19matched
126capture01a1ad02-63d7-772c-813d-11c4e5141043€15.00€0.26matched