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

5 Nov, 14:10

Gross

€2,603.00

PSP fee

€41.87

Net to the bank

€2,561.13

Settlement journal

#398921

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1ac10-018d-7dff-aff8-ee65ce4526f0 is already settled by stl_EUR_2989813 line 54
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1ac12-6375-7c95-bf35-ba1fdbc49a66 is in no file
LineKindReferenceGrossFeeStatus
34capture01a1ac0d-f855-78e4-a7dc-d90ce0b6c4c9€9.00€0.23fee difference
55refund01a1ac10-018f-773b-aac6-f06794db93fa-€35.00€0.00duplicate line
58capture01a1ac10-44f4-7b68-8426-0cbe6932d3b9€49.00€0.72fee difference
1capture01a1ac0b-8ee9-7f09-b83f-8b8d49d48be5€49.00€0.67matched
2capture01a1ac0b-9d76-7e4d-b39a-1833349ce546€9.00€0.19matched
3capture01a1ac0b-ae01-7f7b-95b5-1f1700790fa5€49.00€0.67matched
4capture01a1ac0b-d053-794f-b46b-ad4e4a5aad6e€24.00€0.37matched
5capture01a1ac0c-2664-7535-b731-a3bbe14a5b37€35.00€0.50matched
6capture01a1ac0c-27df-72e0-b553-f2e6b96a06ef€24.00€0.37matched
7capture01a1ac0c-5a7d-7e53-8e20-53cad95d3a8e€9.00€0.19matched
8capture01a1ac0c-9e6a-735e-9345-273ad083e011€24.00€0.37matched
9capture01a1ac0c-addb-7aa2-9b67-26a278b8ecf4€15.00€0.26matched
10capture01a1ac0c-d439-7a47-9716-358ac5855c97€24.00€0.37matched
11capture01a1ac0c-d7a2-741b-ae7e-f377656edc1d€9.00€0.19matched
12capture01a1ac0c-e554-7bab-b66f-92f3ad8e66b5€15.00€0.26matched
13capture01a1ac0c-e5fc-71fd-a455-18f8f29ba9dd€49.00€0.67matched
14capture01a1ac0c-f5e1-7f5f-b3f4-95959e4f5fcf€24.00€0.37matched
15capture01a1ac0d-0ff7-7cef-8925-58f3eba9bb98€15.00€0.26matched
16capture01a1ac0d-2213-7ea3-b99c-82de14f7849b€9.00€0.19matched
17capture01a1ac0d-1cdf-744a-9bbb-bce0ff976dfb€9.00€0.19matched
18capture01a1ac0d-2833-7d30-b457-73fb40c62c32€15.00€0.26matched
19capture01a1ac0d-4ab5-7e49-8e18-14ebd0168bd3€9.00€0.19matched
20refund01a1ac0d-54a3-76a5-85e7-844280a883c2-€16.00€0.00matched
21capture01a1ac0d-5706-7008-afb1-ac686ff19c6b€15.00€0.26matched
22capture01a1ac0d-6178-7819-9d30-1fd8b39dd463€9.00€0.19matched
23capture01a1ac0d-772e-70e3-8058-a89412ba8989€9.00€0.19matched
24capture01a1ac0d-812d-7f96-afc1-db4ad670c50c€15.00€0.26matched
25capture01a1ac0d-931b-7799-8d53-b5364a8ec7c0€15.00€0.26matched
26capture01a1ac0d-961b-7543-a102-32cd5a3a9e2a€35.00€0.50matched
27capture01a1ac0d-ad2b-70eb-9b7f-b2958352fa03€35.00€0.50matched
28capture01a1ac0d-b0c1-7c26-bb27-6fa290d017c4€49.00€0.67matched
29capture01a1ac0d-b665-7a35-8a35-a8eb8f8ba4e7€15.00€0.26matched
30capture01a1ac0d-b74f-79e0-b287-a4db7759053d€49.00€0.67matched
31capture01a1ac0d-c79d-7cd0-9237-b5aaff8be076€9.00€0.19matched
32capture01a1ac0d-c8f0-775c-a2a4-51128c35976c€9.00€0.19matched
33capture01a1ac0d-db9b-7374-96d7-56447b21ea75€24.00€0.37matched
35capture01a1ac0e-0e2b-7fe6-b29d-7a9730fb94d2€49.00€0.67matched
36capture01a1ac0e-1247-7ce3-bb4b-65ad9b592164€49.00€0.67matched
37capture01a1ac0e-235d-7b2f-b7c0-a775a3f00315€49.00€0.67matched
38capture01a1ac0e-4049-7601-bb6e-d8fb206c4801€15.00€0.26matched
39capture01a1ac0e-45c5-7d1b-ac73-31a86ab46364€24.00€0.37matched
40capture01a1ac0e-5308-7e00-ba13-a0ef9dd86567€9.00€0.19matched
41capture01a1ac0e-723f-7939-9631-f569a11ad957€15.00€0.26matched
42capture01a1ac0e-9b0a-7c90-b140-4bf861f627d4€15.00€0.26matched
43capture01a1ac0e-add4-77ad-b99d-cd731611cb6c€24.00€0.37matched
44capture01a1ac0e-b825-7330-ab4e-3d29e823eade€9.00€0.19matched
45capture01a1ac0f-0b6c-7c6f-942a-3204e1141234€35.00€0.50matched
46capture01a1ac0f-6524-7fca-85a3-befcbb55faf6€24.00€0.37matched
47capture01a1ac0f-9282-7243-ba61-230355fb2ea1€24.00€0.37matched
48capture01a1ac0f-9820-7853-ae1a-2c4a05548aa9€35.00€0.50matched
49capture01a1ac0f-adf3-75f4-96f5-abefb3327055€49.00€0.67matched
50capture01a1ac0f-b81a-7dfc-8a61-f12b25f09640€24.00€0.37matched
51capture01a1ac0f-c434-7de1-8590-5b9f04701445€49.00€0.67matched
52capture01a1ac0f-c4db-7a9c-ac20-8756bedcde47€35.00€0.50matched
53capture01a1ac0f-f7bd-7cff-a872-2156ef3c73ef€15.00€0.26matched
54refund01a1ac10-018f-773b-aac6-f06794db93fa-€35.00€0.00matched
56capture01a1ac10-23c1-7a07-88be-967fdb5789de€49.00€0.67matched
57refund01a1ac10-3027-7d8a-8706-a7794cb2f7ea-€26.00€0.00matched
59capture01a1ac10-4418-7597-b3f7-b9958c81df0b€35.00€0.50matched
60capture01a1ac10-6a78-7a2f-8e1c-3ad93e4ad102€15.00€0.26matched
61capture01a1ac10-6be1-70d0-a201-33a9325eeba4€49.00€0.67matched
62capture01a1ac10-64f5-797c-bb6e-a8eccb0d6b3c€24.00€0.37matched
63capture01a1ac10-d8b6-7a01-bdf8-e9ba272875e3€49.00€0.67matched
64capture01a1ac10-eef1-7ec2-8ede-96ef1eebf3c9€35.00€0.50matched
65capture01a1ac11-2668-7a9d-b1a8-cdb134b750b5€15.00€0.26matched
66capture01a1ac11-27c4-7270-9a61-9d39d05649e2€15.00€0.26matched
67capture01a1ac11-6300-7c72-b341-53037db2d5b1€24.00€0.37matched
68capture01a1ac11-63bf-7000-8f4d-6e4333788984€9.00€0.19matched
69capture01a1ac11-671a-7d95-a810-e79abd6970b6€49.00€0.67matched
70capture01a1ac11-73e2-798a-9451-934829d3409c€35.00€0.50matched
71capture01a1ac11-8d5c-7d7d-b681-f8447d271bc5€24.00€0.37matched
72capture01a1ac11-8ff6-700f-b580-215e2ae4e2b5€35.00€0.50matched
73capture01a1ac11-9293-7272-b15d-54e733de4137€15.00€0.26matched
74capture01a1ac11-92b5-79f5-bcaf-ba7191e66fe1€35.00€0.50matched
75capture01a1ac11-9750-7043-b645-f1c59d9a963a€15.00€0.26matched
76capture01a1ac11-b908-7ed2-a05e-8585967e071f€15.00€0.26matched
77refund01a1ac11-dd29-7c41-b7df-258e5553254e-€7.00€0.00matched
78capture01a1ac11-e1cd-7a4a-9f83-8fdb7922eb06€9.00€0.19matched
79capture01a1ac11-e436-764b-acce-d1ac7df0113e€24.00€0.37matched
80capture01a1ac11-e6ec-7576-9962-9ca78e152136€49.00€0.67matched
81capture01a1ac12-0469-7fb6-958c-3a590d008153€35.00€0.50matched
82capture01a1ac12-0d28-7469-856b-8c0f18449f59€35.00€0.50matched
83capture01a1ac12-324b-78ac-9c98-6713ee67cdd5€24.00€0.37matched
84capture01a1ac12-3fad-7ba0-ac5c-4e58ca0f2a2d€9.00€0.19matched
85refund01a1ac12-467a-76ed-8b7b-f673482fc718-€10.00€0.00matched
86capture01a1ac12-6077-7552-8fe3-42e7d60562fb€35.00€0.50matched
87capture01a1ac12-94eb-72f9-9293-3a71aae389e8€24.00€0.37matched
88capture01a1ac12-9658-7de2-a109-1add25d7b604€9.00€0.19matched
89capture01a1ac12-b2ec-783a-b856-b8e8fb8d326b€35.00€0.50matched
90capture01a1ac12-bb4c-7775-8061-91ecfd2117d6€9.00€0.19matched
91capture01a1ac12-e1a6-7dcc-91d3-508cbf920c5b€35.00€0.50matched
92capture01a1ac12-f747-7a42-8f6f-96d381f98f67€24.00€0.37matched
93capture01a1ac13-0989-7e6c-add6-078f8df5a9b4€15.00€0.26matched
94capture01a1ac13-1f48-713f-bc2c-41154b537aa0€15.00€0.26matched
95capture01a1ac13-2117-716e-8a78-d16da442f4b8€35.00€0.50matched
96capture01a1ac13-3993-78ff-93a6-1d6cc8604a88€24.00€0.37matched
97capture01a1ac13-66eb-7227-879c-d6becac0bcf8€49.00€0.67matched
98capture01a1ac13-7240-706e-a62b-7e962d92fc22€24.00€0.37matched
99capture01a1ac13-75d1-7774-9824-08490db3e46a€49.00€0.67matched
100capture01a1ac13-7b1c-7980-9b3a-064a2b29de63€9.00€0.19matched
101capture01a1ac13-8095-749c-b82c-a4002390cccb€49.00€0.67matched
102capture01a1ac13-83ef-70c2-abe1-02eb0fda1d45€9.00€0.19matched
103capture01a1ac13-88c3-7f80-bf3c-e6b73434a929€35.00€0.50matched
104capture01a1ac13-b18b-7b86-be71-7a024f683b8b€49.00€0.67matched
105capture01a1ac13-baf3-75bc-b615-6707233bb8b3€9.00€0.19matched
106refund01a1ac13-ce89-7cb9-ab2a-36d9b339b57e-€19.00€0.00matched
107capture01a1ac13-efd9-77d5-ab17-30c5b7de4948€35.00€0.50matched
108capture01a1ac14-1b72-745e-9d94-1fb8471c2fee€9.00€0.19matched
109capture01a1ac14-3bd1-7043-ad1c-908bd10ee6ad€15.00€0.26matched
110capture01a1ac14-4a6d-7be9-a2c3-a3a45d0f418e€35.00€0.50matched
111refund01a1ac14-5ce6-784c-829b-238ca0d05de2-€20.00€0.00matched
112capture01a1ac14-71b1-7c88-8a5e-44b81680c4f6€49.00€0.67matched
113capture01a1ac14-a2b9-7fe9-bd8b-819e7c2b20b9€49.00€0.67matched