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

Gross

€2,581.00

PSP fee

€41.81

Net to the bank

€2,539.19

Settlement journal

#359015

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a0cd-4ea4-71fb-81f4-7235186fdca9 is already settled by stl_EUR_2989498 line 81
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • missing linein the books, not in the filecapture:01a1a0c8-1375-7e15-b3c2-da878a485aef is in no file
  • missing linein the books, not in the filecapture:01a1a0cd-de26-740c-89df-2ee8aff1186f is in no file
LineKindReferenceGrossFeeStatus
41capture01a1a0ca-2bf7-79cf-bb3b-cfa38a747981€9.00€0.22fee difference
47capture01a1a0ca-b04b-71bd-87b0-d68215917f09€9.00€0.20fee difference
61capture01a1a0cb-9800-7ffa-adde-cf5f7ba3dc58€49.00€0.70fee difference
82capture01a1a0cd-4ee3-7aa3-a58d-78a369b72f37€9.00€0.19duplicate line
1capture01a1a0c5-8784-75b5-a401-98a23b751b0a€9.00€0.19matched
2capture01a1a0c7-2501-7e6e-8c8a-e0540b94807a€9.00€0.19matched
3capture01a1a0c7-ab30-794d-be44-f96c3a6ef34a€9.00€0.19matched
4capture01a1a0c7-b6f5-7b79-847c-fd6a55cf37fa€9.00€0.19matched
5capture01a1a0c7-bdca-7de7-b3d1-75b9dabaa77b€24.00€0.37matched
6capture01a1a0c7-c8dd-71ba-a476-118b0a25c4cd€15.00€0.26matched
7capture01a1a0c7-f8bd-7c6e-b382-9e1b363dc88b€35.00€0.50matched
8capture01a1a0c8-001e-7222-85d0-fdcdcbf8b387€24.00€0.37matched
9capture01a1a0c8-0c31-758e-8ec9-9bc1fca69122€49.00€0.67matched
10capture01a1a0c8-0ffa-7dfb-8c4d-7bf95ba6d0de€24.00€0.37matched
11capture01a1a0c8-19c3-792c-b6a2-c0a59fbe2c0e€24.00€0.37matched
12capture01a1a0c8-4382-71d0-9804-68ed152c51ac€49.00€0.67matched
13capture01a1a0c8-6106-704a-8d29-c325ace70e72€15.00€0.26matched
14capture01a1a0c8-8b97-7107-8ee0-58124b22b81f€15.00€0.26matched
15capture01a1a0c8-95a0-7714-a36a-a9f5c98ca6a8€24.00€0.37matched
16capture01a1a0c8-965b-7fe2-a3fe-6f2846a6ff34€15.00€0.26matched
17capture01a1a0c8-ab9f-7df3-b7a0-f1acbb7ed263€24.00€0.37matched
18capture01a1a0c8-b5bd-70b7-90e3-1ca6007c86aa€24.00€0.37matched
19capture01a1a0c8-b7c7-775a-9de3-223bc676a60b€49.00€0.67matched
20capture01a1a0c8-b82a-702c-bf91-6101a819176a€35.00€0.50matched
21capture01a1a0c8-d2a7-7956-8841-83fc514f4543€9.00€0.19matched
22capture01a1a0c8-dcf3-78f2-8033-3674191623a6€9.00€0.19matched
23capture01a1a0c8-f265-7e95-b350-c0a3eb1e6a50€49.00€0.67matched
24refund01a1a0c8-fcfd-7504-9ada-1b369d6c9352-€14.00€0.00matched
25refund01a1a0c9-01a6-75b7-b9f9-4e717740b7f4-€22.00€0.00matched
26capture01a1a0c9-0425-7f8b-a65a-0cb1b9902ca1€35.00€0.50matched
27capture01a1a0c9-17ef-7d81-845a-3f793d2aed00€49.00€0.67matched
28refund01a1a0c9-2bc1-7c27-9557-267f0f3a8a39-€20.00€0.00matched
29capture01a1a0c9-40f8-7600-bc47-7162e9aea34a€9.00€0.19matched
30capture01a1a0c9-5329-71fe-8857-a3e52f553e61€35.00€0.50matched
31capture01a1a0c9-8032-7921-bed3-903aa957ca84€24.00€0.37matched
32refund01a1a0c9-823f-7ed1-ad48-3807b949615f-€25.00€0.00matched
33capture01a1a0c9-8bf3-702a-a6a8-c3298b3ec3a6€35.00€0.50matched
34capture01a1a0c9-903f-706a-af89-f5da90d8fd4b€24.00€0.37matched
35capture01a1a0c9-9c35-79fe-86b4-bfc9a94dfba1€49.00€0.67matched
36capture01a1a0c9-b8de-74c8-996a-8d18f7e21d97€35.00€0.50matched
37capture01a1a0ca-009f-7395-9150-8e6be8968135€24.00€0.37matched
38capture01a1a0ca-191b-7e98-8129-347e38409aea€49.00€0.67matched
39capture01a1a0ca-1fb5-7705-8295-36c547d1206d€24.00€0.37matched
40capture01a1a0ca-21cd-7540-afb7-531fddcf256f€24.00€0.37matched
42capture01a1a0ca-492b-72cc-ba2b-27d1f0065560€9.00€0.19matched
43capture01a1a0ca-5425-7046-9d1b-4431766a1c20€15.00€0.26matched
44capture01a1a0ca-8484-7d28-9c68-3e62b8fcada4€15.00€0.26matched
45capture01a1a0ca-97c2-786d-a32a-a1e120cf7344€35.00€0.50matched
46capture01a1a0ca-a670-7f59-a79b-385cc0688d68€49.00€0.67matched
48capture01a1a0ca-b19b-7429-8ac2-6323b9a565b2€24.00€0.37matched
49capture01a1a0ca-d113-7692-add9-97279aca71ea€24.00€0.37matched
50capture01a1a0ca-da7b-7eb1-aa67-8cfc090d70f1€9.00€0.19matched
51capture01a1a0ca-de24-7dec-8727-091d92471609€24.00€0.37matched
52capture01a1a0ca-eb7e-7940-beb3-792046ae054d€15.00€0.26matched
53capture01a1a0cb-1b4f-716c-934f-95b1737586be€49.00€0.67matched
54capture01a1a0cb-1db8-71ed-8f23-d0fc30fd5e4c€35.00€0.50matched
55capture01a1a0cb-2845-7229-9330-fa89014cd938€24.00€0.37matched
56capture01a1a0cb-2cae-7c1a-aa6c-33ab90eb0b12€24.00€0.37matched
57capture01a1a0cb-2d69-7b78-8dd7-36578ba44bf7€24.00€0.37matched
58refund01a1a0cb-3d4b-75e7-8e7a-48148c46f972-€6.00€0.00matched
59capture01a1a0cb-7544-73d3-9576-a6b2230009d6€24.00€0.37matched
60capture01a1a0cb-86b9-7d67-949e-2943dba25a88€9.00€0.19matched
62capture01a1a0cb-b970-7d14-9d02-af777ffccac2€35.00€0.50matched
63capture01a1a0cb-d2cb-777b-8dd9-454fd21c7c79€15.00€0.26matched
64capture01a1a0cc-004f-791d-a262-75dae7ba896c€9.00€0.19matched
65capture01a1a0cc-156d-763e-87dc-0d9f01c4e3c8€35.00€0.50matched
66capture01a1a0cc-4bb3-72c6-b6bf-bcb9811bf160€49.00€0.67matched
67capture01a1a0cc-4c31-77f7-aec6-1c404c6c3d42€9.00€0.19matched
68capture01a1a0cc-5320-7b93-aaed-3b7aa552049f€15.00€0.26matched
69capture01a1a0cc-58ff-7924-ac09-5043b88c2a51€24.00€0.37matched
70capture01a1a0cc-736f-71c5-b9d2-233c32bf69e7€15.00€0.26matched
71capture01a1a0cc-78a6-73dd-9725-66df5b1d45a6€9.00€0.19matched
72capture01a1a0cc-8053-70ae-acb5-5ceea1d5f2f1€9.00€0.19matched
73refund01a1a0cc-97ce-7eca-9d45-9373c42b1723-€8.00€0.00matched
74capture01a1a0cc-abd3-7189-96a5-d280c7c0159d€9.00€0.19matched
75refund01a1a0cc-cd9a-787b-8809-d736610bbc14-€10.00€0.00matched
76capture01a1a0cc-db49-771c-9069-407d64d4cd15€15.00€0.26matched
77capture01a1a0cc-e3f4-7be3-b180-679feeadd0e5€15.00€0.26matched
78capture01a1a0cc-f21e-7056-8303-49451f8706e3€49.00€0.67matched
79capture01a1a0cc-f259-700d-9d28-96d18a7c014b€9.00€0.19matched
80capture01a1a0cd-3943-700c-b94d-85ca7d8a87e0€15.00€0.26matched
81capture01a1a0cd-4ee3-7aa3-a58d-78a369b72f37€9.00€0.19matched
83capture01a1a0cd-5be6-755d-ba70-23a5bcedbbcd€15.00€0.26matched
84capture01a1a0cd-7817-7598-9e57-5e4781cf7292€49.00€0.67matched
85capture01a1a0cd-ba51-7705-83c7-95a4fa1339c7€9.00€0.19matched
86capture01a1a0cd-fe1a-78df-aa48-df243d09d7e1€15.00€0.26matched
87capture01a1a0ce-2439-7580-923a-6e62fd261a20€35.00€0.50matched
88capture01a1a0ce-31d8-7544-81bb-0c7cd15fad10€49.00€0.67matched
89capture01a1a0ce-8de0-7c96-afb2-729f94cfd17f€35.00€0.50matched
90refund01a1a0ce-9ec2-7e1f-b180-12817c9b807b-€15.00€0.00matched
91capture01a1a0ce-c201-75f9-8a6d-f70a7c745dd1€24.00€0.37matched
92capture01a1a0ce-ded6-7148-b133-d610587a0e81€49.00€0.67matched
93capture01a1a0ce-e780-7c2c-be71-1273cc1f8329€9.00€0.19matched
94capture01a1a0cf-1bd8-74f8-814a-40f0794fe323€9.00€0.19matched
95capture01a1a0cf-2683-70ac-ab7f-0077efc1b20a€49.00€0.67matched
96capture01a1a0cf-2a6c-7b89-aa13-f5a15b564a20€15.00€0.26matched
97capture01a1a0cf-49b7-7cd5-9293-d079c009d63b€35.00€0.50matched
98capture01a1a0cf-4a04-72d5-9632-bed30c336175€24.00€0.37matched
99capture01a1a0cf-41e6-76d1-821b-3ae4d1ce8832€35.00€0.50matched
100capture01a1a0cf-4e09-7926-83fc-c7531773ef43€49.00€0.67matched
101capture01a1a0cf-599f-7cec-bc42-307b545cdcfb€35.00€0.50matched
102refund01a1a0cf-7511-7364-8970-dd5ad18e7b5d-€8.00€0.00matched
103capture01a1a0cf-8247-7452-839c-1d0922f8f5de€24.00€0.37matched
104capture01a1a0cf-a5c9-7c20-a105-b23f606dd738€9.00€0.19matched
105capture01a1a0cf-af66-72b8-8f9a-1d1e6414a4a2€9.00€0.19matched
106capture01a1a0cf-be00-79a1-bf80-f892d149d349€35.00€0.50matched
107capture01a1a0cf-bed8-7f5c-9d84-4a282acfd558€15.00€0.26matched
108capture01a1a0d0-26de-7672-8fe5-25746029f49a€35.00€0.50matched
109capture01a1a0d0-3f25-7c9d-a2f5-b66e5064a487€49.00€0.67matched
110capture01a1a0d0-646e-7985-95c7-633f21037bf5€49.00€0.67matched
111capture01a1a0d0-724e-7233-9727-86bdd1f3e61d€49.00€0.67matched
112capture01a1a0d0-737a-7451-acba-4c4bebbbc404€49.00€0.67matched
113capture01a1a0d0-736a-7bf3-a25a-0a727729aa28€15.00€0.26matched
114capture01a1a0d0-96fc-7267-899a-d8f4e375c329€9.00€0.19matched
115refund01a1a0d0-b33a-7697-a807-b9df76204a3b-€44.00€0.00matched
116capture01a1a0d0-b957-794c-b2fe-b1713ba3b931€49.00€0.67matched
117capture01a1a0d0-be99-7943-8fbc-2405bb01e320€24.00€0.37matched