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, 01:40

Gross

€2,339.00

PSP fee

€37.80

Net to the bank

€2,301.20

Settlement journal

#407656

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae86-9ae1-737e-a35c-b5251f1e0fbd is already settled by stl_EUR_2989882 line 46
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
LineKindReferenceGrossFeeStatus
47capture01a1ae86-b4fd-7f08-abac-f5428c656cbb€24.00€0.37duplicate line
58capture01a1ae87-4abe-7ab1-a73b-bf75a4a8b54f€9.00€0.20fee difference
1capture01a1ae7d-36a9-791f-bbdc-c7c337bfe8c5€49.00€0.67matched
2capture01a1ae82-ded8-7bac-9fc6-2ce29df828ed€15.00€0.26matched
3capture01a1ae83-7110-7151-968b-6b653c6de7d3€24.00€0.37matched
4capture01a1ae83-8f65-732b-8062-1c2e4e009b67€24.00€0.37matched
5capture01a1ae83-92a2-768a-a2e8-84e1be3b2533€49.00€0.67matched
6capture01a1ae83-a61a-757e-a0c8-e5cdc9aff2eb€24.00€0.37matched
7capture01a1ae83-ac54-70f6-aa0b-891c9a8c7dc5€24.00€0.37matched
8capture01a1ae83-cca5-7d54-b9fb-1de4e9edb89a€15.00€0.26matched
9capture01a1ae83-db60-74f5-9e43-2be2af2c0dae€9.00€0.19matched
10capture01a1ae83-ddfd-74cb-b7ee-f53f6c3fe4e9€24.00€0.37matched
11capture01a1ae84-172d-7887-8199-276cdfa1c5fc€24.00€0.37matched
12capture01a1ae84-312d-7d1f-8d3e-3cb394718221€9.00€0.19matched
13capture01a1ae84-381d-7979-abbc-9b641a51b7d7€24.00€0.37matched
14capture01a1ae84-80bc-7db6-847b-2e28d57fd674€24.00€0.37matched
15capture01a1ae84-82e3-763e-8961-3ee8e292f1df€15.00€0.26matched
16capture01a1ae84-9e6d-75c4-a690-28e51ef00326€49.00€0.67matched
17capture01a1ae84-a4ec-7154-add6-3192a4784fc6€15.00€0.26matched
18capture01a1ae84-abc1-7bad-af73-0cd38e7b58e7€49.00€0.67matched
19capture01a1ae84-c8cb-745f-a062-740447fb5d7f€9.00€0.19matched
20capture01a1ae84-d51a-7b68-8494-06f75c83e39e€15.00€0.26matched
21capture01a1ae84-e495-7a0d-aea5-9228a8bf6fd4€15.00€0.26matched
22capture01a1ae84-f23a-791a-9341-57cda84e7db7€9.00€0.19matched
23capture01a1ae85-05ed-73ea-865d-a7889e561268€15.00€0.26matched
24capture01a1ae85-0718-764e-9ce4-ac722a24de7c€9.00€0.19matched
25refund01a1ae85-0c6e-7748-a869-312615bcb59c-€31.00€0.00matched
26capture01a1ae85-0cf2-7530-8118-c50bab14b870€24.00€0.37matched
27capture01a1ae85-1319-7068-9f44-720e6a1b357f€24.00€0.37matched
28capture01a1ae85-5a46-7440-a27e-0d4551ba2e91€15.00€0.26matched
29capture01a1ae85-74f0-79f3-b353-ee4c366318a3€24.00€0.37matched
30capture01a1ae85-94dd-7449-8b56-3e3ac6aafea4€49.00€0.67matched
31capture01a1ae85-a8c6-7491-8b17-37e194af4816€9.00€0.19matched
32capture01a1ae85-bcca-7361-9bc6-465890a1f69f€9.00€0.19matched
33capture01a1ae85-c342-729f-b982-95d757726bc3€35.00€0.50matched
34capture01a1ae85-d20a-765b-8485-ff912ec78976€15.00€0.26matched
35capture01a1ae85-ea75-7800-ae33-e7a6e7a99770€49.00€0.67matched
36capture01a1ae86-0f5b-7c96-9240-e47a67bbb5e3€9.00€0.19matched
37capture01a1ae86-5074-7867-97a4-9eb1da077b8f€9.00€0.19matched
38capture01a1ae86-52ba-770f-a732-4e351bbfc4ff€49.00€0.67matched
39capture01a1ae86-55b2-7358-9884-6eb76e6551bd€49.00€0.67matched
40capture01a1ae86-5ad5-7986-b686-4542277ea5ab€49.00€0.67matched
41capture01a1ae86-72c7-7d00-8897-33eb4c4c6da9€9.00€0.19matched
42capture01a1ae86-7791-7214-9e7b-b8c0783d2342€15.00€0.26matched
43capture01a1ae86-8485-78fd-b0d4-899fe84bff86€9.00€0.19matched
44capture01a1ae86-8a6f-73c3-9472-f64eb79a13d3€15.00€0.26matched
45capture01a1ae86-8cdc-7785-b3b9-e8935dcfcff5€9.00€0.19matched
46capture01a1ae86-b4fd-7f08-abac-f5428c656cbb€24.00€0.37matched
48refund01a1ae86-c199-7852-9f7f-3db450d9a1f6-€31.00€0.00matched
49capture01a1ae86-d5e3-75a7-800a-444e81364c6b€15.00€0.26matched
50capture01a1ae86-d623-7b68-a997-be62d6d0e8c3€49.00€0.67matched
51capture01a1ae86-d9ad-7f0f-b140-b7f458acdf2b€49.00€0.67matched
52capture01a1ae86-e10a-7a2a-8d43-2ae2bb0998f2€24.00€0.37matched
53capture01a1ae86-e315-7963-8887-d62188aab5fc€24.00€0.37matched
54capture01a1ae86-f1a5-76c3-b908-5a077a5131b4€49.00€0.67matched
55refund01a1ae87-1b57-725e-b380-21f4023c0124-€5.00€0.00matched
56capture01a1ae87-29af-7136-9b40-cd8082cbf6d0€9.00€0.19matched
57capture01a1ae87-35c8-71aa-8136-1a256aaa8c5d€9.00€0.19matched
59capture01a1ae87-5723-734c-9706-fa88f45e64b6€24.00€0.37matched
60capture01a1ae87-7c77-7833-8400-3672b6d87420€9.00€0.19matched
61capture01a1ae87-98e2-7ab7-a04d-c6b3be288d9e€9.00€0.19matched
62capture01a1ae87-a0b6-7897-b48f-ea76a9924010€9.00€0.19matched
63refund01a1ae87-ad80-730c-96fc-7eabaf64e872-€23.00€0.00matched
64capture01a1ae87-e01b-74b6-ae51-56bdcc40d02b€15.00€0.26matched
65capture01a1ae87-edc5-71b0-8267-7480cd70bab2€24.00€0.37matched
66capture01a1ae87-dddc-7524-b461-08f9f09b7c74€15.00€0.26matched
67capture01a1ae87-f7c1-7831-a280-ada31b05a6ac€9.00€0.19matched
68capture01a1ae88-15d5-7d57-b508-5451e6015c92€15.00€0.26matched
69capture01a1ae88-21f4-75e7-b553-43677d2d0a39€49.00€0.67matched
70capture01a1ae88-2616-75ba-8d8c-a563cb7360de€9.00€0.19matched
71capture01a1ae88-8adb-7708-9d75-2040e4f51e61€9.00€0.19matched
72capture01a1ae88-8bbd-7f37-80af-05b6785e70b7€15.00€0.26matched
73capture01a1ae88-a9a5-79f7-a940-70bba7f51e64€24.00€0.37matched
74capture01a1ae88-cf27-7524-8ab5-3a59eb383308€24.00€0.37matched
75capture01a1ae88-cfed-78d5-bd78-6e35e81ac01a€15.00€0.26matched
76capture01a1ae88-d8d6-7403-b5d8-23c5d903b2fb€24.00€0.37matched
77capture01a1ae88-f43d-7580-b0fe-b5ca98781800€24.00€0.37matched
78capture01a1ae88-fb40-71ac-9ab6-42ac6878264f€24.00€0.37matched
79capture01a1ae89-158c-7fc1-96bd-92c2d351b604€15.00€0.26matched
80refund01a1ae89-1857-78d5-a23c-0c67944f4bb3-€5.00€0.00matched
81capture01a1ae89-1d95-7008-bedc-1a6fc7445be9€24.00€0.37matched
82capture01a1ae89-353b-7c06-9af1-256616169ef6€24.00€0.37matched
83capture01a1ae89-3b24-7dfc-ba8a-78fe0ddc2e3c€15.00€0.26matched
84capture01a1ae89-8e95-7c1e-9d8f-90262e7cabf1€49.00€0.67matched
85capture01a1ae89-a67e-7430-84da-2631dacde8a8€15.00€0.26matched
86capture01a1ae89-b64d-7f8c-8375-8b9e49b47dc0€35.00€0.50matched
87capture01a1ae89-d568-727e-9663-ef0f6e14eae0€49.00€0.67matched
88capture01a1ae8a-81bf-7a0f-aaf6-c1091a6f61cf€49.00€0.67matched
89capture01a1ae8a-9f65-72fd-bf46-d364f19c279f€24.00€0.37matched
90capture01a1ae8a-b1e8-7ff3-b87d-84e05a5082a8€49.00€0.67matched
91capture01a1ae8a-b9a3-7d70-804f-e868e0de30db€15.00€0.26matched
92capture01a1ae8a-bfb7-78bb-9933-7d2e205ef833€35.00€0.50matched
93capture01a1ae8a-c531-7730-a481-8dd54592e48b€24.00€0.37matched
94capture01a1ae8a-c60b-70e6-b350-1f4933c37211€24.00€0.37matched
95capture01a1ae8a-d6ac-733e-b3ab-f5b98ea5acf3€35.00€0.50matched
96capture01a1ae8a-ec45-79ee-81b0-c8d3860ff5c1€15.00€0.26matched
97refund01a1ae8a-eee7-70bb-a483-c32c1922b7de-€23.00€0.00matched
98capture01a1ae8a-f597-7688-ad09-525936193a61€49.00€0.67matched
99capture01a1ae8b-2b70-774f-9407-bbe17b0790ca€49.00€0.67matched
100capture01a1ae8b-49bf-7990-958d-0cd56e561855€24.00€0.37matched
101capture01a1ae8b-607b-7781-81ff-2d980db061ce€49.00€0.67matched
102capture01a1ae8b-872a-78e0-9348-bb9f3325f28c€24.00€0.37matched
103capture01a1ae8b-be15-72cb-83ee-f3e42f5d391c€15.00€0.26matched
104capture01a1ae8b-ec83-7314-8214-45baf1e80c4c€24.00€0.37matched
105capture01a1ae8c-1716-78be-9f19-8a645e157da4€24.00€0.37matched
106capture01a1ae8c-2a24-74a8-9643-07b93e59339f€35.00€0.50matched
107capture01a1ae8c-2b19-7d20-89a5-acadf6c414c0€9.00€0.19matched
108capture01a1ae8c-3576-7ca3-90ae-43621c7ecd56€15.00€0.26matched