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

Gross

€2,708.00

PSP fee

€41.69

Net to the bank

€2,666.31

Settlement journal

#368282

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a375-7360-7810-999c-0b695e7558d6 is already settled by stl_EUR_2989572 line 97
LineKindReferenceGrossFeeStatus
98capture01a1a375-737b-7dd8-9856-7e44ff5ee016€24.00€0.37duplicate line
1capture01a1a364-32ca-7ee1-a28c-ff019eb9d08f€9.00€0.19matched
2capture01a1a36d-3b02-7a55-a55c-1616b7f00a1e€24.00€0.37matched
3capture01a1a36d-61a7-7f54-a636-59887b3dc943€35.00€0.50matched
4capture01a1a36d-64f3-74a6-a742-00f344f753e4€15.00€0.26matched
5capture01a1a36d-6a19-7cc7-800b-30fa7c87c807€49.00€0.67matched
6capture01a1a36d-8f0b-7774-a456-07952cce2870€9.00€0.19matched
7capture01a1a36d-9d9b-7747-8114-fe5f70ad7d84€35.00€0.50matched
8capture01a1a36d-c76e-733d-a79b-02063147fb35€15.00€0.26matched
9capture01a1a36d-e8ae-785a-b0f1-76bd3a7862fd€15.00€0.26matched
10capture01a1a36e-0509-7120-bfc3-f42e62af396b€49.00€0.67matched
11capture01a1a36e-09e3-77cf-9446-24f0b404c2b2€49.00€0.67matched
12capture01a1a36e-0bc7-7690-85bb-73cc8a296afb€9.00€0.19matched
13capture01a1a36e-1c91-7498-8db6-85af39ced915€49.00€0.67matched
14capture01a1a36e-3e27-7d98-ba6b-1b3856eaec71€15.00€0.26matched
15capture01a1a36e-434d-7c2a-abfa-28ea9a8917b7€35.00€0.50matched
16capture01a1a36e-4d4b-7156-aee3-9502c3d6fb5d€15.00€0.26matched
17capture01a1a36e-4dca-7398-a829-ee04a9501661€15.00€0.26matched
18capture01a1a36e-81b2-7c5c-a8f8-9611662f8f99€24.00€0.37matched
19capture01a1a36e-8856-7279-9db1-0d1e6bfbeba7€49.00€0.67matched
20refund01a1a36e-890f-7c5f-99eb-ccd390ea8f97-€10.00€0.00matched
21capture01a1a36e-8fb4-7745-a418-2bcc601d4162€35.00€0.50matched
22capture01a1a36e-b1ec-74de-9f48-9ec93d9a40fd€49.00€0.67matched
23capture01a1a36e-c1f6-7539-addf-654970af0ad6€9.00€0.19matched
24capture01a1a36e-ce1d-7bbe-af76-c6e105b933cc€49.00€0.67matched
25capture01a1a36e-d09f-75df-bf1b-51710ee5c469€49.00€0.67matched
26refund01a1a36e-eb1d-7e09-a41c-a4bbe05c64ed-€20.00€0.00matched
27capture01a1a36e-ed37-742d-a827-87cba177338c€49.00€0.67matched
28capture01a1a36f-1326-7ef3-b41d-bef5a7f8da67€49.00€0.67matched
29capture01a1a36f-14ee-7219-bb0d-0561303d2944€35.00€0.50matched
30capture01a1a36f-30eb-7460-bcc3-f76c3e57ab80€49.00€0.67matched
31capture01a1a36f-433e-7102-8fc8-604524d33b8e€35.00€0.50matched
32capture01a1a36f-85a4-7e74-94bb-c496f2e3eef0€49.00€0.67matched
33capture01a1a36f-8ae3-7421-99f0-7fb52c0db275€24.00€0.37matched
34capture01a1a36f-e24b-7d04-8202-c789fdff580e€49.00€0.67matched
35capture01a1a36f-ffef-73fe-9957-8b33ed7ac56c€24.00€0.37matched
36capture01a1a370-08d9-7fcb-be65-b92663a8af1b€9.00€0.19matched
37capture01a1a370-168c-73fe-a5aa-8b153c34f007€24.00€0.37matched
38refund01a1a370-42f5-792d-84fa-020a9c06f686-€14.00€0.00matched
39capture01a1a370-5b2a-788a-a9fc-2a2c34fdf7ca€35.00€0.50matched
40capture01a1a370-5d0b-7476-9881-ab933d97dfbe€24.00€0.37matched
41capture01a1a370-6890-73ce-b7de-84175f660ee3€24.00€0.37matched
42capture01a1a370-9787-76d7-be86-7f74c3e7b10c€9.00€0.19matched
43capture01a1a370-9f06-7739-a6bf-5030c146d027€15.00€0.26matched
44capture01a1a371-03f3-7d1d-a14e-c0ebe57443de€35.00€0.50matched
45capture01a1a371-0e88-7ba8-82d0-bafea85e3869€15.00€0.26matched
46refund01a1a371-3aa2-73bd-85ca-638be0c6fc1c-€35.00€0.00matched
47capture01a1a371-47a1-70d9-bd0b-93fe5b264fa8€9.00€0.19matched
48capture01a1a371-733b-7020-a350-958e2c2da83e€9.00€0.19matched
49capture01a1a371-93fe-7de2-a550-738efabbf2b7€9.00€0.19matched
50capture01a1a371-a379-7024-82d3-7ee437d41b2f€15.00€0.26matched
51capture01a1a371-ac91-7e7e-825a-19ce6854dfdc€9.00€0.19matched
52refund01a1a371-e6e9-720d-b981-e46da8a89a89-€3.00€0.00matched
53capture01a1a371-e898-7773-9ddc-ca085eb5aade€15.00€0.26matched
54capture01a1a371-e8ad-73d3-a626-11f9119433be€15.00€0.26matched
55capture01a1a372-247b-71b2-a8a3-758eae2c7de1€15.00€0.26matched
56capture01a1a372-4d0c-7a7e-b491-f5132dd75198€49.00€0.67matched
57capture01a1a372-6273-7331-a881-587ad8abea75€49.00€0.67matched
58capture01a1a372-6b28-7a11-9e44-e65775a95b76€49.00€0.67matched
59capture01a1a372-9c67-71cd-bbe0-2d6fe84c9046€24.00€0.37matched
60capture01a1a372-c043-7a63-bff3-a6b7ccf746ca€49.00€0.67matched
61capture01a1a372-c795-7cb6-a08d-947fe3d12f6c€9.00€0.19matched
62capture01a1a372-cead-7092-9a15-3570a70ae103€49.00€0.67matched
63capture01a1a372-e114-77e3-afbd-646495f2224f€24.00€0.37matched
64capture01a1a372-e4b0-76e1-8134-def2ffb078af€24.00€0.37matched
65capture01a1a373-140f-77ad-b158-3a5adef40f52€15.00€0.26matched
66capture01a1a373-27ac-78a7-a5da-1d886bd69a57€49.00€0.67matched
67capture01a1a373-33f5-7e61-81eb-0a69ee3f563d€35.00€0.50matched
68capture01a1a373-45f7-7861-a793-77ca21c5f3aa€15.00€0.26matched
69capture01a1a373-48c0-74c5-b973-56fc6cbaef37€24.00€0.37matched
70capture01a1a373-5309-72dd-af65-685b0b521a24€35.00€0.50matched
71capture01a1a373-627b-7622-bca5-b8815195b862€9.00€0.19matched
72capture01a1a373-94b4-7fce-8906-96a73cddc9f6€9.00€0.19matched
73capture01a1a373-a10d-7e7c-af56-15982e8f7197€9.00€0.19matched
74capture01a1a373-a6f9-7969-9eb8-e5b555077d63€49.00€0.67matched
75capture01a1a373-a8e3-7758-a255-972d5e6641b0€24.00€0.37matched
76capture01a1a373-cb1b-7e3f-ba81-b4201fcefb03€24.00€0.37matched
77capture01a1a374-1889-7687-8c02-5a492afd0f90€9.00€0.19matched
78capture01a1a374-51f1-7797-805d-0ef63afaf150€35.00€0.50matched
79capture01a1a374-5327-720b-914d-0ee295aceec9€35.00€0.50matched
80capture01a1a374-6868-7c5a-a749-4e8b3a72bd2a€49.00€0.67matched
81capture01a1a374-6978-7f1b-a16f-70f42212d579€35.00€0.50matched
82capture01a1a374-7ab5-7350-829d-0ff5810baca5€15.00€0.26matched
83capture01a1a374-7e8d-7544-9119-cdd416f769dc€24.00€0.37matched
84capture01a1a374-8937-7a6b-b539-d02cb9674825€24.00€0.37matched
85capture01a1a374-940d-7569-89e5-f03ed34557c0€24.00€0.37matched
86capture01a1a374-ce43-77eb-8970-da752cbab13e€9.00€0.19matched
87capture01a1a374-e81e-7595-8fc5-523b5963b717€24.00€0.37matched
88capture01a1a374-f38c-72f8-9ce2-d8a86081bcec€24.00€0.37matched
89capture01a1a375-008b-79fe-8bd5-344ca6cf733a€9.00€0.19matched
90capture01a1a375-2680-7d95-a9a2-427e600976af€35.00€0.50matched
91refund01a1a375-2bbd-79f1-b2a2-30431b9c077d-€7.00€0.00matched
92capture01a1a375-468d-74d7-850e-dc0943a65591€35.00€0.50matched
93capture01a1a375-4a72-77a7-b7e6-dee5e4099876€49.00€0.67matched
94capture01a1a375-4c0c-72bd-a65f-36bb06ebfd2d€35.00€0.50matched
95capture01a1a375-5904-75a8-85e4-871538148ef7€15.00€0.26matched
96capture01a1a375-6c76-7c02-b417-3b54e82947d5€35.00€0.50matched
97capture01a1a375-737b-7dd8-9856-7e44ff5ee016€24.00€0.37matched
99capture01a1a375-75ac-7e7f-be05-eb366e1e1d0e€49.00€0.67matched
100capture01a1a375-8fff-727b-b242-038b16b55e9a€49.00€0.67matched
101capture01a1a375-a3ab-734b-9db3-77fd609bd6b4€15.00€0.26matched
102capture01a1a375-bf90-79cc-80a8-590ce8dd6445€35.00€0.50matched
103capture01a1a375-d149-7b90-80e8-6fb9f76b498e€49.00€0.67matched
104capture01a1a375-db8d-734c-af2b-003ccc26bc4a€15.00€0.26matched
105capture01a1a375-f2d4-7d5c-9d1b-9d67f212998c€24.00€0.37matched
106capture01a1a376-31f2-78e5-bf92-72ddf70a3edc€15.00€0.26matched