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

Gross

€3,013.00

PSP fee

€48.07

Net to the bank

€2,964.93

Settlement journal

#392830

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aa5a-a06c-7a5a-af19-1c471d805dd9 is already settled by stl_EUR_2989765 line 91
  • duplicate linethe file lists it twicecapture:01a1aa5b-8465-71a6-8ecb-fbdf7b05246e is already settled by stl_EUR_2989765 line 103
  • 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 38, the contract says 37
LineKindReferenceGrossFeeStatus
74capture01a1aa59-759d-757c-a4a2-70eb55acd34d€9.00€0.20fee difference
87capture01a1aa5a-5607-73d3-9af7-9a4d3308cabf€24.00€0.38fee difference
92capture01a1aa5a-a117-7d7c-8001-7b79615dbe4e€15.00€0.26duplicate line
104capture01a1aa5b-8488-728b-8547-d10e8f907864€35.00€0.50duplicate line
1capture01a1aa4b-dc7b-732e-91c9-e3ee24253d35€24.00€0.37matched
2capture01a1aa4e-f288-77d1-ac79-ea9ebc1fc10e€49.00€0.67matched
3refund01a1aa4f-2726-7101-a16f-3d7ca6cee682-€7.00€0.00matched
4capture01a1aa54-1aca-7865-923c-8dd32044b07c€9.00€0.19matched
5capture01a1aa54-2594-7e23-a41b-e5cd0e6890ca€15.00€0.26matched
6capture01a1aa54-2a63-7138-bdde-67d9afcb4589€9.00€0.19matched
7capture01a1aa54-36b9-766a-a371-2e906eb53bfe€15.00€0.26matched
8capture01a1aa54-3319-71b6-8ae7-b92052660dac€15.00€0.26matched
9capture01a1aa54-6126-739f-8647-52eab883fd87€49.00€0.67matched
10capture01a1aa54-692f-7d9f-8ca5-8c2f3d6eede3€49.00€0.67matched
11capture01a1aa54-7436-7f8a-9782-b7467477dec1€49.00€0.67matched
12capture01a1aa54-83d1-7717-b2f9-8f1ef882e4cf€35.00€0.50matched
13capture01a1aa54-960e-75c1-9834-7708e22d3578€24.00€0.37matched
14capture01a1aa54-9fbe-7b5e-86d1-9a6045012189€9.00€0.19matched
15capture01a1aa54-a120-7551-8543-c87b68dddae4€49.00€0.67matched
16capture01a1aa54-d1b0-7cbf-8700-aae899661cd0€15.00€0.26matched
17capture01a1aa54-dff8-7f93-b3d1-19f170156108€24.00€0.37matched
18capture01a1aa54-e643-716f-8e3e-b24729b3ba6c€49.00€0.67matched
19capture01a1aa54-ef27-7cd4-8fca-fd4d95df1892€9.00€0.19matched
20capture01a1aa55-3b82-7bbe-a4fd-8f8fa6731894€9.00€0.19matched
21capture01a1aa55-3d27-750c-aac1-488f2d154a98€9.00€0.19matched
22refund01a1aa55-4b35-7572-a404-9bcf7de4f8ff-€32.00€0.00matched
23capture01a1aa55-4d0f-732b-98f7-67555bc383fb€24.00€0.37matched
24capture01a1aa55-8228-75e1-892d-362c05540ef4€15.00€0.26matched
25capture01a1aa55-83a3-7bc6-8cfc-01cd63539b75€24.00€0.37matched
26capture01a1aa55-8fd8-736f-82dd-b45143c531aa€35.00€0.50matched
27capture01a1aa55-9434-7efc-adc0-f710b4c70928€9.00€0.19matched
28capture01a1aa55-9d31-72c3-968a-a024fdb96c24€15.00€0.26matched
29capture01a1aa55-a891-78b1-9a93-66b5daff1b75€9.00€0.19matched
30capture01a1aa55-f921-76f5-821d-04cb25743388€49.00€0.67matched
31capture01a1aa56-2bbd-70fc-aeaf-7130300198ec€24.00€0.37matched
32capture01a1aa56-52b6-7961-8de1-61ffa9953fb2€35.00€0.50matched
33capture01a1aa56-54d9-7c2d-9194-1f9d91dc7126€49.00€0.67matched
34capture01a1aa56-7049-7cba-af39-7f1582ad1331€24.00€0.37matched
35capture01a1aa56-7dec-76b6-8d17-bd8156a9489f€9.00€0.19matched
36capture01a1aa56-75f4-7014-87ff-56372a0a2f21€49.00€0.67matched
37capture01a1aa56-820a-7cb6-8f32-35573b1d6817€9.00€0.19matched
38capture01a1aa56-985e-7376-b51d-b0e738dbf3c9€15.00€0.26matched
39capture01a1aa56-ad6a-73e7-93a9-d7e5d4c67d3e€49.00€0.67matched
40capture01a1aa56-b6f9-73c7-86f9-bfd1134b4ff7€24.00€0.37matched
41capture01a1aa56-d231-70e5-8c70-e6dfff349cb4€9.00€0.19matched
42capture01a1aa56-e3d5-7ffc-ac0c-46bc5db85585€15.00€0.26matched
43capture01a1aa56-fa41-7eaf-91b2-51514afdbcbf€49.00€0.67matched
44capture01a1aa56-fe63-7655-89fb-c7d1b0d8e4d9€9.00€0.19matched
45capture01a1aa57-2a73-76f3-b60b-01da4fd25d02€9.00€0.19matched
46capture01a1aa57-3398-719c-8227-b135a0f24445€49.00€0.67matched
47capture01a1aa57-34cb-7895-9e72-d251eace853a€9.00€0.19matched
48capture01a1aa57-4435-7e6f-ab7d-f1d3f0631c75€9.00€0.19matched
49capture01a1aa57-4a05-7bb8-bf39-0a7a1bd1f7e6€35.00€0.50matched
50capture01a1aa57-4b2f-763b-87b5-2bf9b44859be€24.00€0.37matched
51capture01a1aa57-792c-75b6-9c96-328f7b68b272€49.00€0.67matched
52capture01a1aa57-8784-7f42-85b1-d66425cb5e4e€35.00€0.50matched
53capture01a1aa57-9802-746b-b200-3d1998a8dfc0€49.00€0.67matched
54capture01a1aa57-985b-7a6f-bf32-b6c9f01660a6€49.00€0.67matched
55capture01a1aa57-df01-7e1f-9063-78928fc42517€9.00€0.19matched
56capture01a1aa57-e79a-7846-be9a-6d7a5d313a74€35.00€0.50matched
57capture01a1aa57-efd3-7cc1-b7fe-f8d051c84421€15.00€0.26matched
58capture01a1aa58-583d-7d5f-a055-b3d679e0f08a€9.00€0.19matched
59capture01a1aa58-69ab-78f6-9400-df63d3e8dea7€24.00€0.37matched
60capture01a1aa58-7265-7626-93ee-e7838b1d91ba€9.00€0.19matched
61capture01a1aa58-8c04-740f-8e6a-74aea5d99204€15.00€0.26matched
62capture01a1aa58-8d85-7401-9cd5-6bf8ce43893c€15.00€0.26matched
63capture01a1aa58-9b9f-7634-904d-d0283c342a10€15.00€0.26matched
64capture01a1aa58-c223-7aaf-88df-a0fb3da0a0bc€15.00€0.26matched
65capture01a1aa58-de45-7044-be8a-05df7438ec2b€35.00€0.50matched
66capture01a1aa58-e400-79e7-8047-21e6b0067bc3€24.00€0.37matched
67capture01a1aa58-e9b2-7ef3-b4c7-178c75888070€24.00€0.37matched
68capture01a1aa58-f149-7a13-a769-e1ded312feb3€35.00€0.50matched
69capture01a1aa59-1b85-76d3-85e3-52905642abca€24.00€0.37matched
70capture01a1aa59-2632-7f41-bf94-a0b43ebb81a6€35.00€0.50matched
71capture01a1aa59-2c8f-7509-ad51-d7de0b69d6bc€49.00€0.67matched
72capture01a1aa59-2da8-717b-8473-ca72d740765d€9.00€0.19matched
73capture01a1aa59-4edf-748d-b9ac-f6b3e886ad53€15.00€0.26matched
75capture01a1aa59-7b74-7825-a75d-83e084713ed5€15.00€0.26matched
76capture01a1aa59-a905-7452-8350-64696bd426f3€15.00€0.26matched
77capture01a1aa59-d13b-7745-942b-512b685ba9ad€49.00€0.67matched
78capture01a1aa59-d584-7002-89ef-e60cfb465ee7€9.00€0.19matched
79refund01a1aa59-dd03-79b3-976b-567a5a7de04b-€5.00€0.00matched
80capture01a1aa59-eada-79a6-a46e-4e7ef31d1bb3€15.00€0.26matched
81capture01a1aa5a-076e-7c1b-9544-e258544262ad€15.00€0.26matched
82capture01a1aa5a-1677-7483-a582-6f211341a1f8€24.00€0.37matched
83capture01a1aa5a-1cb9-7118-855c-9417b1af53db€35.00€0.50matched
84capture01a1aa5a-1f49-71f6-bc55-cbc26288fd84€9.00€0.19matched
85capture01a1aa5a-440e-773f-8a42-92e60cad5a0e€15.00€0.26matched
86capture01a1aa5a-455f-7ea0-91fb-f68ce46bfb74€15.00€0.26matched
88capture01a1aa5a-58aa-7cd2-aa66-134a9b35fa9f€24.00€0.37matched
89capture01a1aa5a-6568-75f2-a712-eac1fc1538d8€35.00€0.50matched
90refund01a1aa5a-6f44-7530-85b1-f737bb216029-€9.00€0.00matched
91capture01a1aa5a-a117-7d7c-8001-7b79615dbe4e€15.00€0.26matched
93capture01a1aa5a-aaae-7666-9839-29abdcf47d3a€49.00€0.67matched
94capture01a1aa5b-02b8-7627-b7e1-518357bef2be€9.00€0.19matched
95refund01a1aa5b-198c-7e71-b7b2-1e7897f24ff3-€29.00€0.00matched
96capture01a1aa5b-1daf-7d8f-bb5c-b47c666f235f€9.00€0.19matched
97capture01a1aa5b-1e1b-7bbe-a8d6-1aa130fe2562€24.00€0.37matched
98capture01a1aa5b-2251-73a9-b572-38037dd09346€49.00€0.67matched
99capture01a1aa5b-63cd-745d-bed6-94be9956a4d7€24.00€0.37matched
100capture01a1aa5b-6439-7daf-ae0c-81c1ff663563€24.00€0.37matched
101capture01a1aa5b-6bda-72b2-8d1b-d47cf0546b21€15.00€0.26matched
102capture01a1aa5b-8175-7cda-bc06-0e951f293d3f€24.00€0.37matched
103capture01a1aa5b-8488-728b-8547-d10e8f907864€35.00€0.50matched
105capture01a1aa5b-84ba-7d82-8300-fcea31b649ca€15.00€0.26matched
106capture01a1aa5b-87af-73a0-a65b-747f9f25a535€35.00€0.50matched
107refund01a1aa5b-8ab2-73cb-bbc4-1c8dcda4447d-€15.00€0.00matched
108capture01a1aa5b-920a-70cf-9a9b-5db838418517€49.00€0.67matched
109capture01a1aa5b-9752-76bf-b462-63c08e7d53f9€49.00€0.67matched
110capture01a1aa5b-a25b-72e0-b7ce-9c3664145c0e€9.00€0.19matched
111capture01a1aa5b-9aac-7a87-bbe1-575067e31e83€9.00€0.19matched
112refund01a1aa5b-be3f-703d-9484-624dbaf980f6-€25.00€0.00matched
113capture01a1aa5b-c2e8-7efd-924d-112b0394e1d6€49.00€0.67matched
114capture01a1aa5b-c338-7925-8a34-d0607c0242e1€49.00€0.67matched
115capture01a1aa5b-cb1b-75c9-8a01-c8af72cad7e2€24.00€0.37matched
116capture01a1aa5c-04a5-7fa1-ac0c-c1eab78b1554€24.00€0.37matched
117capture01a1aa5c-1b82-7e32-9505-aa6d855942d4€35.00€0.50matched
118capture01a1aa5c-1f17-78cd-baf7-34afc1cf368b€35.00€0.50matched
119capture01a1aa5c-3a9f-7b8f-ba1b-063b5519cc49€24.00€0.37matched
120refund01a1aa5c-4042-7a82-89b4-6fd7737f81f3-€16.00€0.00matched
121refund01a1aa5c-419b-7490-816e-3cad2f3f5d4c-€13.00€0.00matched
122capture01a1aa5c-4605-7248-88b1-08d9ad8a9662€9.00€0.19matched
123capture01a1aa5c-5f21-75a3-82a1-0c2e32b3dd7d€49.00€0.67matched
124capture01a1aa5c-62a6-7529-9807-e2f658d3faff€49.00€0.67matched
125capture01a1aa5c-7f96-7b67-b348-06d140dcc20b€9.00€0.19matched
126capture01a1aa5c-920f-7e9b-a909-4c48b0982157€49.00€0.67matched
127capture01a1aa5c-9daf-75c4-b725-079ae4ba8671€24.00€0.37matched
128capture01a1aa5c-abdc-7a73-8b89-f834479aae46€24.00€0.37matched
129capture01a1aa5c-c8af-7345-85a9-5e2fd4cf83de€15.00€0.26matched
130capture01a1aa5c-d626-7efa-8249-ec39576ca686€24.00€0.37matched
131capture01a1aa5d-0de4-72a9-a578-87490b72f51e€49.00€0.67matched
132capture01a1aa5d-2da5-78fd-b664-27c161dcdf61€15.00€0.26matched
133capture01a1aa5d-3b48-7bb1-9fc8-f3ea13c60531€15.00€0.26matched