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, 14:10

Gross

€2,630.00

PSP fee

€41.95

Net to the bank

€2,588.05

Settlement journal

#380566

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a6e8-89a9-7d8d-a88f-82a4b6819366 is already settled by stl_EUR_2989670 line 2
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
LineKindReferenceGrossFeeStatus
43capture01a1a6e8-065e-758f-bd1f-96864fe9aa30€49.00€0.71fee difference
1capture01a1a6e4-48ce-766a-b9c0-6509d9744d8c€15.00€0.26matched
2capture01a1a6e5-3288-750a-bd06-70f3e723bdab€9.00€0.19matched
3capture01a1a6e5-3856-7561-94a4-6571823ca34c€24.00€0.37matched
4capture01a1a6e5-42e6-7b60-9309-8d7140a064ab€9.00€0.19matched
5capture01a1a6e5-6668-764a-953d-7bbf7b1cbc2a€9.00€0.19matched
6capture01a1a6e5-6ed8-7e4b-9c73-f76c9f3086c2€49.00€0.67matched
7capture01a1a6e5-9589-7ef2-8b6a-bc12f17a8dc3€35.00€0.50matched
8capture01a1a6e5-95f2-7371-8a68-6c96fbf3b6c2€9.00€0.19matched
9refund01a1a6e5-a05b-7152-89be-011459888354-€7.00€0.00matched
10capture01a1a6e5-bf72-77de-b06e-f5200f5354d4€35.00€0.50matched
11capture01a1a6e5-c34a-7961-8a52-c7b4329683ca€15.00€0.26matched
12capture01a1a6e5-cd68-74d2-824d-d5ab2ed91e84€49.00€0.67matched
13capture01a1a6e5-d243-7384-bc19-eef18f4e5af8€49.00€0.67matched
14capture01a1a6e5-d528-76ee-b920-2bf6902a9aff€9.00€0.19matched
15capture01a1a6e5-d7af-768d-ae05-d8e1fac5416d€49.00€0.67matched
16capture01a1a6e5-d901-7ba2-96df-359fd7767069€9.00€0.19matched
17capture01a1a6e5-f2d5-7a7d-b109-c5327a0bf48c€9.00€0.19matched
18capture01a1a6e6-0873-7a39-8571-94c813b2b832€24.00€0.37matched
19capture01a1a6e6-0cd2-7676-b954-016877f44f50€9.00€0.19matched
20capture01a1a6e6-1496-7bf0-979d-c7d8e4e6c194€35.00€0.50matched
21capture01a1a6e6-162e-776c-81fe-b4c82b0f5796€49.00€0.67matched
22refund01a1a6e6-2cce-7f70-a5c2-88a27abe5386-€32.00€0.00matched
23capture01a1a6e6-2d7a-70ea-8060-7c4ad88be921€9.00€0.19matched
24capture01a1a6e6-303a-7b80-8da8-b079d578a78e€15.00€0.26matched
25refund01a1a6e6-3b44-7d34-93e8-5ac61cfc9349-€4.00€0.00matched
26capture01a1a6e6-504c-707f-a58a-88fd52836271€49.00€0.67matched
27refund01a1a6e6-63b5-7b28-91aa-fb3a0f9f1602-€11.00€0.00matched
28refund01a1a6e6-65be-7157-822f-4438f4ab551d-€12.00€0.00matched
29capture01a1a6e6-8844-70b8-a735-0551dda0c64a€9.00€0.19matched
30capture01a1a6e6-9168-7886-a895-205167d86865€24.00€0.37matched
31capture01a1a6e6-97e0-7dbf-9ed0-28949754364c€35.00€0.50matched
32capture01a1a6e6-e3a7-7184-8771-64bbc9147d1d€9.00€0.19matched
33capture01a1a6e6-ffd2-74d3-9953-c52a4f848f58€15.00€0.26matched
34capture01a1a6e7-0115-7dd6-8f5d-b48963c8083a€35.00€0.50matched
35capture01a1a6e7-27a9-752e-9207-8eaadc256337€24.00€0.37matched
36capture01a1a6e7-4573-7cd1-9a92-452e03aae3d4€9.00€0.19matched
37refund01a1a6e7-5ac6-740f-bbd4-dcf2f3b97491-€7.00€0.00matched
38capture01a1a6e7-7864-761b-b700-55c7013ad77c€24.00€0.37matched
39capture01a1a6e7-9002-7df0-9dae-d948e400016b€9.00€0.19matched
40capture01a1a6e7-9472-7126-b418-dcd8d7ebf721€49.00€0.67matched
41capture01a1a6e7-d0b7-7dc0-9435-54962641c609€15.00€0.26matched
42capture01a1a6e7-f1f1-7a75-a572-baf8a1378563€49.00€0.67matched
44capture01a1a6e8-125c-7f04-861d-4630a27f3c75€49.00€0.67matched
45capture01a1a6e8-1fbf-72f1-82bb-a6aa0a3744be€15.00€0.26matched
46capture01a1a6e8-34a4-7243-a391-39f821f4041e€35.00€0.50matched
47capture01a1a6e8-3df4-70d6-984b-b6b86b0e7157€15.00€0.26matched
48capture01a1a6e8-46c0-7c54-90f7-8ac26e79a63e€15.00€0.26matched
49capture01a1a6e8-7300-7e9d-9275-4aea16e714c7€24.00€0.37matched
50capture01a1a6e8-7903-7ca2-ab98-98ac2878a2f0€9.00€0.19matched
51capture01a1a6e8-8264-7278-b536-838712b213e4€15.00€0.26matched
52capture01a1a6e9-1cb3-74e3-8af3-dd9d86a65c1a€35.00€0.50matched
53capture01a1a6e9-6066-7a99-a8ce-c28c229f5f81€24.00€0.37matched
54capture01a1a6e9-6565-7379-be97-84bd883ffe80€24.00€0.37matched
55capture01a1a6e9-694c-7f34-94b1-b47e02fdc839€35.00€0.50matched
56capture01a1a6e9-69b1-7d14-be1b-7a428496cbc3€15.00€0.26matched
57capture01a1a6e9-702a-794c-87c1-83c95022f9b1€35.00€0.50matched
58capture01a1a6e9-848b-733c-9258-c63adad91a91€24.00€0.37matched
59capture01a1a6e9-88a9-700e-9398-ccd2c38b998a€35.00€0.50matched
60capture01a1a6e9-8ee0-72a9-84ae-453c8d959f62€9.00€0.19matched
61capture01a1a6e9-a270-78e7-9a03-a104d1be42fd€15.00€0.26matched
62capture01a1a6e9-a5a7-7a8d-8b2f-f325a1f1e9a0€15.00€0.26matched
63capture01a1a6e9-aaa0-7d90-84e4-51dd644a76fe€24.00€0.37matched
64capture01a1a6e9-b636-7868-a1a3-1afa3b233c10€35.00€0.50matched
65refund01a1a6e9-d120-7667-b07c-7c1fa555ca10-€6.00€0.00matched
66refund01a1a6e9-fc6b-773e-976a-701d1132965a-€23.00€0.00matched
67capture01a1a6ea-1909-78ca-987f-222e223ade72€24.00€0.37matched
68capture01a1a6ea-2b5a-7dd2-8dcd-3c165f702ddd€35.00€0.50matched
69capture01a1a6ea-6a49-7781-ba5d-5a3fbf11a5f2€24.00€0.37matched
70capture01a1a6ea-6ff6-71d3-8b2d-023e8ce3bdb0€24.00€0.37matched
71capture01a1a6ea-75ea-72c8-85e9-21a1caf28a90€9.00€0.19matched
72capture01a1a6ea-7a23-7748-b780-425bd6678e0d€9.00€0.19matched
73capture01a1a6ea-8d1c-7b56-a3d4-289053fde713€24.00€0.37matched
74capture01a1a6ea-8dd4-7493-bb9b-009551fc8bad€35.00€0.50matched
75capture01a1a6ea-9148-730a-9933-8508e4d8aaba€9.00€0.19matched
76capture01a1a6ea-95ac-734c-a1d1-9581c0989c1c€24.00€0.37matched
77capture01a1a6ea-bf5a-75a4-b1cb-eb06578b772b€35.00€0.50matched
78capture01a1a6ea-d258-7e34-94f7-78e6cda25ec6€15.00€0.26matched
79capture01a1a6ea-fd22-7b50-b21b-a09b9778ed0e€49.00€0.67matched
80capture01a1a6eb-02f6-757b-9c49-46735f092793€24.00€0.37matched
81capture01a1a6eb-1824-76ed-a50f-58a4ed025e9d€49.00€0.67matched
82refund01a1a6eb-2d28-7a5a-868e-8824de3dc277-€15.00€0.00matched
83capture01a1a6eb-764c-75a3-b718-09a393c7bba7€9.00€0.19matched
84capture01a1a6eb-8190-7dbb-9822-2dc47fabc9fa€15.00€0.26matched
85capture01a1a6eb-a997-79d4-907f-d18e4803a73e€24.00€0.37matched
86capture01a1a6eb-d2ce-7397-9b18-e354a1f5f571€49.00€0.67matched
87capture01a1a6eb-e42b-7655-9d18-7b9b31ecb90b€35.00€0.50matched
88capture01a1a6eb-ecfd-7611-9f1f-4b175ed6221f€49.00€0.67matched
89capture01a1a6eb-fb87-7a1f-b0e6-60c0e4d25f05€35.00€0.50matched
90capture01a1a6ec-08a0-73f6-853d-3c0a99d66d07€24.00€0.37matched
91capture01a1a6ec-02ec-776a-9cea-29ae35f2be50€24.00€0.37matched
92capture01a1a6ec-469d-7e1e-a540-67174054a671€15.00€0.26matched
93capture01a1a6ec-5727-72e7-b924-f121d0c87b0e€49.00€0.67matched
94capture01a1a6ec-5dc3-716b-8cfb-dd02a9a20adf€35.00€0.50matched
95capture01a1a6ec-66b9-71e4-801d-2f7d6b945d5c€35.00€0.50matched
96capture01a1a6ec-a8bf-760c-9a7e-04a2111990b8€9.00€0.19matched
97capture01a1a6ec-abc0-7c60-8d7d-a943c4838728€9.00€0.19matched
98capture01a1a6ec-acab-772e-a863-c46c547e02f9€9.00€0.19matched
99capture01a1a6ec-bc18-7831-b3f7-a1c154c8497f€15.00€0.26matched
100capture01a1a6ec-caad-7d64-bd39-913db7b4a4d3€49.00€0.67matched
101capture01a1a6ec-d96e-7baa-90a4-95597d0e3cad€49.00€0.67matched
102capture01a1a6ed-0dad-74bf-abcc-4d4ea7eea7bf€9.00€0.19matched
103refund01a1a6ed-3092-7962-86e1-c08bd65465d2-€28.00€0.00matched
104capture01a1a6ed-35ae-7bd5-9da1-8f8adcace883€35.00€0.50matched
105capture01a1a6ed-5fcc-7833-bea0-bc7b04ebea7f€35.00€0.50matched
106capture01a1a6ed-679a-7c15-9f96-2d2148359b4b€24.00€0.37matched
107capture01a1a6ed-8206-760e-8157-6181abbd299a€35.00€0.50matched
108capture01a1a6ed-9dbd-7abd-9414-f8d17b7138c5€9.00€0.19matched
109capture01a1a6ed-ba5c-72d0-a5aa-f029e0dde211€15.00€0.26matched
110capture01a1a6ed-c674-7a17-8753-4cec9d318ed6€35.00€0.50matched
111capture01a1a6ed-c9b6-7d12-8853-48f7d6ebb619€15.00€0.26matched
112capture01a1a6ed-cd7c-7aab-84ca-00a73127e178€35.00€0.50matched
113capture01a1a6ed-e426-77e8-8a38-354417b2ad03€49.00€0.67matched
114capture01a1a6ed-f766-7f5e-a513-4e5fd30a6e3e€49.00€0.67matched
115capture01a1a6ee-1f78-7d3d-8811-beb375bef46e€24.00€0.37matched
116capture01a1a6ee-2a29-74ca-b81e-4dd2b9f4ba7b€49.00€0.67matched