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

6 Nov, 12:30

Gross

€2,948.00

PSP fee

€44.90

Net to the bank

€2,903.10

Settlement journal

#416099

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b0d9-84d4-72aa-86e3-38b33830c3e0 is already settled by stl_EUR_2989947 line 41
LineKindReferenceGrossFeeStatus
42capture01a1b0d9-84f5-7625-af4b-e963c16c3e37€15.00€0.26duplicate line
1capture01a1b0d5-b9fe-7294-adde-1679a6ddaf77€49.00€0.67matched
2capture01a1b0d6-2dd9-772e-8f8a-95011ced310f€49.00€0.67matched
3capture01a1b0d6-8876-77a5-81a6-c43654dd764f€49.00€0.67matched
4capture01a1b0d6-b4eb-7238-a76f-113ebf14d6eb€9.00€0.19matched
5capture01a1b0d6-c214-7b92-a8de-e2c3e8638d5a€9.00€0.19matched
6capture01a1b0d6-d323-7f7d-b523-cdc367647adf€15.00€0.26matched
7capture01a1b0d7-1eb8-7300-a70b-44f887b73588€9.00€0.19matched
8capture01a1b0d7-3481-7664-8da9-e057ca7be953€15.00€0.26matched
9capture01a1b0d7-48f1-7df9-8f4a-7b37ab583efd€9.00€0.19matched
10capture01a1b0d7-52c7-72ff-a9c5-558441b42ed4€24.00€0.37matched
11capture01a1b0d7-581e-7f29-b484-6e6b162a08b1€24.00€0.37matched
12capture01a1b0d7-6547-7eb4-9d23-805c193e05f7€9.00€0.19matched
13capture01a1b0d7-79cb-72cd-ae5b-489945689a9d€49.00€0.67matched
14capture01a1b0d7-7b39-74ee-8f84-6e5a25163916€35.00€0.50matched
15capture01a1b0d7-7f83-73d7-a8d3-78aab8dd761c€9.00€0.19matched
16capture01a1b0d7-863c-7285-bb7a-b33cf10150ba€9.00€0.19matched
17capture01a1b0d7-94f0-7930-918c-fcf90715095a€24.00€0.37matched
18capture01a1b0d7-b2f0-7987-88dd-75fd189032ba€49.00€0.67matched
19capture01a1b0d7-b9b9-7569-9660-f9c02209bfb8€49.00€0.67matched
20capture01a1b0d7-ca8b-702f-83cc-96ee806e88a5€9.00€0.19matched
21capture01a1b0d7-cf7f-7942-a941-088c1de565a6€24.00€0.37matched
22capture01a1b0d7-d47f-7128-ba15-fb5316134f56€49.00€0.67matched
23capture01a1b0d7-f2dd-7602-9fca-cc3cece7f64c€24.00€0.37matched
24capture01a1b0d7-f9cb-790e-959f-688c135c4b13€35.00€0.50matched
25capture01a1b0d8-0564-77f9-abf2-8136f1930047€24.00€0.37matched
26capture01a1b0d8-291c-7a37-abee-6f60c20d85ce€24.00€0.37matched
27capture01a1b0d8-3393-7fbd-a7be-838ecc9e1cac€49.00€0.67matched
28capture01a1b0d8-57e0-7624-8c6c-8959dbb5d36f€24.00€0.37matched
29capture01a1b0d8-6136-72a6-93d8-b21c8ff6ae83€15.00€0.26matched
30capture01a1b0d8-8c67-74b1-8a90-bf3d1ca77e22€15.00€0.26matched
31capture01a1b0d8-e12a-78e4-99cd-9d8256145dc7€35.00€0.50matched
32capture01a1b0d8-e695-7eae-9dcd-472557caf4fa€49.00€0.67matched
33refund01a1b0d8-ff8b-7fac-9296-389f90eb8328-€4.00€0.00matched
34capture01a1b0d9-09c2-7f55-9d9f-bb59a3ab3ba8€49.00€0.67matched
35refund01a1b0d9-16ed-7ecd-828d-8241b04fd39f-€16.00€0.00matched
36capture01a1b0d9-30f6-7c5b-aab0-e717845d5e06€15.00€0.26matched
37capture01a1b0d9-348f-7953-bc7a-adceeb9a9b0c€35.00€0.50matched
38capture01a1b0d9-4876-77a6-a516-fd9445e377f4€15.00€0.26matched
39capture01a1b0d9-5440-7556-ab3c-b4618995e1b6€35.00€0.50matched
40capture01a1b0d9-66ba-7a2b-8680-24d0a2046473€35.00€0.50matched
41capture01a1b0d9-84f5-7625-af4b-e963c16c3e37€15.00€0.26matched
43capture01a1b0d9-85d1-793b-bbc9-9d8fd77e9183€49.00€0.67matched
44capture01a1b0d9-b1ee-7725-a9a9-8b7215ea0f48€24.00€0.37matched
45capture01a1b0d9-c2d4-70b6-913a-9577333974ce€24.00€0.37matched
46capture01a1b0d9-ca51-76ef-b893-06f233723387€24.00€0.37matched
47capture01a1b0d9-e279-7a7d-9aff-92592c17f7f2€35.00€0.50matched
48refund01a1b0d9-eb85-7b9b-9cb8-5ae74987b918-€13.00€0.00matched
49capture01a1b0d9-e5fe-7207-8093-d90102b7f2b2€9.00€0.19matched
50refund01a1b0d9-f3e1-7865-a33b-3bdfd8c8b9f3-€7.00€0.00matched
51capture01a1b0d9-f706-742f-8106-715323ec5aa9€49.00€0.67matched
52capture01a1b0da-2531-7a20-8ade-356b2153389f€49.00€0.67matched
53capture01a1b0da-678e-7dba-b340-cd9f2d02e5a7€24.00€0.37matched
54capture01a1b0da-6bd1-72e6-b66e-26ccedc3532a€49.00€0.67matched
55capture01a1b0da-6bd6-793a-a5b2-ec5d6d6b6271€24.00€0.37matched
56capture01a1b0da-a50b-783e-b49b-5003d82bee69€24.00€0.37matched
57capture01a1b0da-c7fb-74e9-9013-384604bc5880€9.00€0.19matched
58capture01a1b0da-cca2-79e1-a6d6-46f4f09c3947€24.00€0.37matched
59capture01a1b0da-f5ad-73d0-a274-fb81696e5843€9.00€0.19matched
60capture01a1b0db-744c-7e9e-bc42-915c3842cb05€35.00€0.50matched
61capture01a1b0db-8021-70e6-addb-b960371ea31c€24.00€0.37matched
62capture01a1b0db-b0ee-7b29-8cc2-1874004ce263€15.00€0.26matched
63capture01a1b0db-b971-7d27-9dc5-fa6e3c0a3db2€35.00€0.50matched
64capture01a1b0db-cf10-76f6-b41b-bafe5c145acf€24.00€0.37matched
65capture01a1b0db-cfb2-7fb5-98a7-2cbfbaa0207f€9.00€0.19matched
66capture01a1b0db-e891-7f48-95f2-d75112c01740€35.00€0.50matched
67capture01a1b0db-ec38-7a6c-9638-5e04d83309ba€9.00€0.19matched
68capture01a1b0db-ec61-70e7-834f-1a9126a555e7€35.00€0.50matched
69capture01a1b0db-efd6-7ffe-be65-fed77f34edf4€9.00€0.19matched
70capture01a1b0dc-026f-727b-839a-4f73cd4cf0d3€9.00€0.19matched
71capture01a1b0dc-0500-781c-ac4c-954edb51e551€24.00€0.37matched
72capture01a1b0dc-0c9d-74f7-8cf2-91f4de70fdb0€24.00€0.37matched
73refund01a1b0dc-19bd-7c17-86df-57aa3af71ac7-€4.00€0.00matched
74capture01a1b0dc-1f14-7972-9898-a0e05d56751c€35.00€0.50matched
75capture01a1b0dc-24cf-727f-9543-d1f56ba950bd€35.00€0.50matched
76capture01a1b0dc-405f-796a-b578-21a7db9814ca€49.00€0.67matched
77capture01a1b0dc-4431-7cbe-bdc8-e9a75a05f281€49.00€0.67matched
78capture01a1b0dc-54f4-781f-944f-8dde6b3af188€24.00€0.37matched
79capture01a1b0dc-61b0-7e7e-a079-237e1de78f22€15.00€0.26matched
80capture01a1b0dc-7060-798c-8f1e-3e894307de3f€15.00€0.26matched
81capture01a1b0dc-805c-718d-9560-76e8db22ab1e€35.00€0.50matched
82capture01a1b0dc-9420-77c0-badc-aa5749e4b16f€15.00€0.26matched
83capture01a1b0dc-afde-79de-90a9-b8a0cf7d17af€49.00€0.67matched
84refund01a1b0dc-a4b3-78f8-aad3-486d4ab4306d-€5.00€0.00matched
85capture01a1b0dd-1022-7b79-a1a7-385389201a62€49.00€0.67matched
86capture01a1b0dd-3687-7a2b-b89d-4756ca5d0b66€15.00€0.26matched
87capture01a1b0dd-5821-7a18-805b-1e356ab17d9f€15.00€0.26matched
88capture01a1b0dd-6252-71ce-aaac-ec9c5541850b€15.00€0.26matched
89capture01a1b0dd-68f8-7f57-aafe-135d9c71d868€35.00€0.50matched
90capture01a1b0dd-6abc-7b49-9050-f30419413ede€35.00€0.50matched
91capture01a1b0dd-6f87-72d1-a416-8649fdfa9b5a€35.00€0.50matched
92capture01a1b0dd-78c1-7f64-a8bd-809ac899e177€35.00€0.50matched
93capture01a1b0dd-a62d-703b-9134-a0b790951189€9.00€0.19matched
94capture01a1b0dd-c510-75d9-97b3-5d26718447cb€24.00€0.37matched
95capture01a1b0dd-e89c-74a8-aba9-d0b7538607f8€9.00€0.19matched
96capture01a1b0de-0d8a-78da-96c9-c191ccd3ae21€24.00€0.37matched
97capture01a1b0de-10bf-7549-92dc-be0eb9b6469e€9.00€0.19matched
98capture01a1b0de-2422-744c-90b0-c8e1756ef8fd€15.00€0.26matched
99capture01a1b0de-39ce-727a-abf4-91752d306890€49.00€0.67matched
100capture01a1b0de-78cd-70b6-aa32-0ac04a026c6e€35.00€0.50matched
101capture01a1b0de-815a-7f9c-ae9c-8c457743a0df€15.00€0.26matched
102capture01a1b0de-94ea-7cdc-9773-2630705abbb9€35.00€0.50matched
103capture01a1b0de-d1b1-7320-b871-c1bff3dbbf3d€49.00€0.67matched
104capture01a1b0de-e498-760a-8e44-57927f6bdf31€24.00€0.37matched
105capture01a1b0de-eb39-7992-8264-042452f10e93€49.00€0.67matched
106capture01a1b0de-f746-7b73-95c5-3116561f8851€24.00€0.37matched
107capture01a1b0de-fedd-7927-9ad4-768089db5a63€15.00€0.26matched
108capture01a1b0df-0d14-7923-9f1d-b1532d044da7€15.00€0.26matched
109capture01a1b0df-2ff2-74b1-a50d-de0e6b4b3ff5€35.00€0.50matched
110capture01a1b0df-3556-7bfb-9420-25eabc00e9a3€15.00€0.26matched
111capture01a1b0df-4019-7841-82b1-5598d9fe7535€49.00€0.67matched
112capture01a1b0df-4a2e-765a-b460-2213488bbdcf€15.00€0.26matched
113capture01a1b0df-5154-7613-9bb0-377f6bfd1f38€49.00€0.67matched
114capture01a1b0df-5436-7691-aebc-504db8a043b4€9.00€0.19matched
115capture01a1b0df-5ecf-7722-9c8d-d23d33eef87d€24.00€0.37matched
116capture01a1b0df-7c04-778f-a114-3a5637c0a02d€49.00€0.67matched