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, 04:20

Gross

€3,018.00

PSP fee

€48.57

Net to the bank

€2,969.43

Settlement journal

#354978

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19fa8-3d74-76c6-9a11-54b1277e6cb7 is already settled by stl_EUR_2989466 line 83
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
LineKindReferenceGrossFeeStatus
63capture01a19fa6-ef5e-731c-a7cc-d0af707ee8a3€24.00€0.40fee difference
84capture01a19fa8-3d91-7dd6-b438-9cb27ef08794€49.00€0.67duplicate line
92capture01a19fa8-fb99-7961-a03b-d3cbf2030fa1€35.00€0.55fee difference
1capture01a19fa0-951b-783b-a873-d5c3a05cd67c€15.00€0.26matched
2capture01a19fa0-bcfc-7472-835e-db4184e16129€24.00€0.37matched
3refund01a19fa2-c0b6-7d5a-a938-a4f43cdccf0b-€3.00€0.00matched
4capture01a19fa2-da2f-7f15-adfe-83888873cffb€15.00€0.26matched
5capture01a19fa2-dcdf-777f-8072-6146d02c5660€35.00€0.50matched
6capture01a19fa2-e2c8-7a69-80bf-cb21de9dc3f1€49.00€0.67matched
7capture01a19fa2-ece9-71e4-b291-2b35c12ff2d4€49.00€0.67matched
8capture01a19fa2-ffa0-7f93-89fd-cced6fa1dc0e€24.00€0.37matched
9capture01a19fa3-4355-7143-8382-483536522632€35.00€0.50matched
10capture01a19fa3-5893-7c37-9eaa-5e466359e667€35.00€0.50matched
11capture01a19fa3-8012-74ae-9932-ea44e206244c€49.00€0.67matched
12capture01a19fa3-bbd0-7616-adb0-dab1978b02d7€35.00€0.50matched
13refund01a19fa3-c9a5-7da1-a34c-d5d979088a65-€11.00€0.00matched
14capture01a19fa3-f736-7791-866d-5de0eaa49f4b€49.00€0.67matched
15capture01a19fa4-2a17-76ba-9e9e-7c6bff9ef6d2€15.00€0.26matched
16capture01a19fa4-5974-79a5-adb2-e5fc03f20ec2€35.00€0.50matched
17capture01a19fa4-640e-7d2b-b88f-fea76aed6d1c€35.00€0.50matched
18capture01a19fa4-ad8c-72ad-9046-242ecae9c8a8€35.00€0.50matched
19capture01a19fa4-cadb-7698-836b-d23456bb7a29€15.00€0.26matched
20capture01a19fa4-ce0f-77be-b42d-edde15d966c5€24.00€0.37matched
21capture01a19fa4-d820-7f5c-b92a-b3f926eac9eb€24.00€0.37matched
22capture01a19fa4-f7d9-79a6-8dbc-c1c5a1b49671€24.00€0.37matched
23capture01a19fa4-f989-7e74-871f-f8e83110b58f€15.00€0.26matched
24capture01a19fa4-fe7a-77e1-afda-27073f7d0174€24.00€0.37matched
25refund01a19fa5-0396-717f-977e-238c980fb412-€8.00€0.00matched
26capture01a19fa5-0a8f-7838-ada3-46c1a26d9c53€15.00€0.26matched
27capture01a19fa5-1242-7c1a-8711-1e3f38dabc66€49.00€0.67matched
28capture01a19fa5-1941-776b-9b53-219144c633df€15.00€0.26matched
29capture01a19fa5-23c8-735a-9d86-d633ee979a25€15.00€0.26matched
30capture01a19fa5-39ca-7001-9b7e-770320f2f9d4€9.00€0.19matched
31capture01a19fa5-4d71-7b50-a3c1-cf5c832bf5d6€35.00€0.50matched
32capture01a19fa5-629f-7931-8e13-9fba3c12a9c7€35.00€0.50matched
33capture01a19fa5-6feb-7dce-9ca7-3de9732f0f15€49.00€0.67matched
34capture01a19fa5-8db3-7f15-951d-6dab7514017e€9.00€0.19matched
35refund01a19fa5-ac96-74f4-b283-8f77d6b9e9b2-€6.00€0.00matched
36capture01a19fa5-b1a9-7a24-86a2-e8426a496861€49.00€0.67matched
37capture01a19fa5-c363-7f2a-9a62-0384e00cc8eb€9.00€0.19matched
38capture01a19fa5-d240-74d9-998e-23cc0994704d€15.00€0.26matched
39capture01a19fa5-dc06-7dd9-b5d4-b1967c0e8069€9.00€0.19matched
40refund01a19fa5-dca3-7280-be5d-402da8235042-€24.00€0.00matched
41capture01a19fa5-e676-7177-8f1b-5bbc28f783fe€35.00€0.50matched
42capture01a19fa5-e87f-7c7c-8962-3b5c6f4c988c€24.00€0.37matched
43capture01a19fa5-ff7d-73dc-ba4c-ceae5361ce85€24.00€0.37matched
44capture01a19fa6-0c22-7484-8cb7-27d1c0d2f70f€35.00€0.50matched
45capture01a19fa6-13ef-754a-8648-f4613493d804€49.00€0.67matched
46capture01a19fa6-1ad7-724c-b2c3-44338262a21d€24.00€0.37matched
47capture01a19fa6-24b5-7705-8b7f-ac042944a237€49.00€0.67matched
48capture01a19fa6-3053-7e58-9477-7b355d43fd70€15.00€0.26matched
49capture01a19fa6-3f3a-7179-9125-01010d1bb59a€9.00€0.19matched
50capture01a19fa6-456f-7c54-a563-f3b59a4dc02c€15.00€0.26matched
51capture01a19fa6-523b-7ee5-9ba8-3f853bf8ead9€9.00€0.19matched
52capture01a19fa6-6e26-7fe9-9c0e-ace7ebca46fd€49.00€0.67matched
53capture01a19fa6-7894-7333-a44a-9e2d24028f22€35.00€0.50matched
54capture01a19fa6-7fda-77ed-8386-8f5f3b882267€15.00€0.26matched
55capture01a19fa6-8187-7a51-ae1e-41c43f5642cc€49.00€0.67matched
56capture01a19fa6-a083-7357-894e-18f23b95f90f€49.00€0.67matched
57refund01a19fa6-b099-70aa-8a8c-72a4d75aae21-€4.00€0.00matched
58capture01a19fa6-b649-720b-ba0d-3e9cac1cc925€24.00€0.37matched
59refund01a19fa6-c7b4-78e9-97f4-8bfb951bab4a-€9.00€0.00matched
60capture01a19fa6-d5bb-700f-b5fe-0e7925d94662€15.00€0.26matched
61capture01a19fa6-e2d4-7d95-b882-cf406a3c99cd€49.00€0.67matched
62capture01a19fa6-eb98-7d26-8812-fa9cce1bf533€49.00€0.67matched
64capture01a19fa6-f125-7bc1-8e8b-0e2c12666114€35.00€0.50matched
65capture01a19fa6-f1bd-7003-8d04-2b0ee9cea4bf€15.00€0.26matched
66capture01a19fa7-0986-7e87-bded-5944c080e465€24.00€0.37matched
67refund01a19fa7-184b-7624-bd83-d49a80479977-€22.00€0.00matched
68capture01a19fa7-1ae6-7b38-b40c-d02d87ecc3b2€24.00€0.37matched
69capture01a19fa7-2416-75ca-99d8-003f89f2874c€49.00€0.67matched
70capture01a19fa7-2a40-7b71-bfa4-81edd2d8cab9€35.00€0.50matched
71capture01a19fa7-31b6-72e1-88a4-77d947e12224€15.00€0.26matched
72capture01a19fa7-5194-770c-a01b-2cd39af0dc89€24.00€0.37matched
73capture01a19fa7-638f-74f5-8836-a0bf83dc5d31€35.00€0.50matched
74capture01a19fa7-6431-722d-9110-0326cac9d3f6€15.00€0.26matched
75capture01a19fa7-9d6c-77c2-8e10-eb792bb002f4€35.00€0.50matched
76capture01a19fa7-b272-7443-a72d-b590df1daeb2€15.00€0.26matched
77capture01a19fa7-fc7a-7a30-bef6-9f6c7dd40534€15.00€0.26matched
78capture01a19fa8-0699-7d35-8950-e660578b3770€9.00€0.19matched
79capture01a19fa8-0bc1-7797-8a1f-941724062feb€35.00€0.50matched
80capture01a19fa8-114e-7739-8a91-8d8e86222439€9.00€0.19matched
81capture01a19fa8-14da-751d-97ba-4a20f1f0f746€35.00€0.50matched
82capture01a19fa8-367d-7934-a429-c36abd6e8b77€15.00€0.26matched
83capture01a19fa8-3d91-7dd6-b438-9cb27ef08794€49.00€0.67matched
85capture01a19fa8-45ad-7482-89ff-8eb0b3f3c6e7€49.00€0.67matched
86capture01a19fa8-5dee-70dc-9d87-b28524dd53fb€24.00€0.37matched
87capture01a19fa8-af56-7ebc-8f1b-254f33833c99€9.00€0.19matched
88capture01a19fa8-b372-7f47-be2b-f3303d618678€24.00€0.37matched
89capture01a19fa8-d2f7-7a4b-86c9-42c30e338aab€9.00€0.19matched
90capture01a19fa8-d696-768b-a5f9-eef9955610d2€35.00€0.50matched
91capture01a19fa8-edf4-75bf-a7db-573b1a4ceae4€24.00€0.37matched
93refund01a19fa9-3517-7013-8ffb-16295eb992cc-€9.00€0.00matched
94capture01a19fa9-4a71-7006-94eb-cb6a5fa78635€9.00€0.19matched
95capture01a19fa9-4f47-72e1-913d-38d658573f70€15.00€0.26matched
96capture01a19fa9-6ffa-79e8-9b00-eace52133b94€35.00€0.50matched
97capture01a19fa9-7301-777e-ad35-f7b9df1a7b31€9.00€0.19matched
98capture01a19fa9-83d0-769c-a5dc-344a0fab5237€49.00€0.67matched
99capture01a19fa9-ad4d-7474-8273-7ff9e18147c5€49.00€0.67matched
100capture01a19fa9-bfef-705f-8dff-7e94476af5b1€24.00€0.37matched
101refund01a19fa9-d955-7631-bd9e-43bc36e9a7bc-€29.00€0.00matched
102capture01a19fa9-dd4d-792a-9d78-e3bea27818e9€24.00€0.37matched
103capture01a19fa9-de9e-7e90-91b1-06553eb50cf0€49.00€0.67matched
104capture01a19fa9-ea57-7023-80ba-5ccabbc30231€15.00€0.26matched
105capture01a19fa9-fadc-7764-9aab-9151e5c14c8a€9.00€0.19matched
106capture01a19faa-0051-70dd-80de-e73835b48387€24.00€0.37matched
107capture01a19faa-0b14-7fc5-8200-b4ce7fc2f67e€9.00€0.19matched
108capture01a19faa-0f62-7f56-b73d-bcc5432193c1€49.00€0.67matched
109capture01a19faa-230e-73d8-a8d8-5c28f9a6ac9b€49.00€0.67matched
110capture01a19faa-2def-7ed0-abc0-360650adf6d6€35.00€0.50matched
111capture01a19faa-3041-79ce-8836-94b84135724b€9.00€0.19matched
112capture01a19faa-4c7a-7157-856a-7a87709c3ae3€15.00€0.26matched
113refund01a19faa-6f18-7cc8-a4ac-4376f9e5851b-€38.00€0.00matched
114capture01a19faa-6b6d-7df9-8357-4c43ebdfa7b1€9.00€0.19matched
115capture01a19faa-8887-7df6-b83d-678533c6641e€49.00€0.67matched
116refund01a19faa-b15e-7652-9a1a-4b803286623e-€8.00€0.00matched
117capture01a19faa-d7f5-7846-ac13-2e7ac464f4b8€9.00€0.19matched
118capture01a19faa-f125-7be4-8eb7-2e1225b3ed7c€24.00€0.37matched
119capture01a19faa-fdd8-7c68-8fc0-e51a32c8daf0€24.00€0.37matched
120capture01a19fab-0782-7fd2-8f74-21eb6cbaadd1€15.00€0.26matched
121capture01a19fab-0b3c-7310-bc54-84ba467d17dc€9.00€0.19matched
122capture01a19fab-3a5f-7e81-9e81-c01b76cc8323€49.00€0.67matched
123capture01a19fab-48e2-74e3-82bc-ef5122131f6e€9.00€0.19matched
124capture01a19fab-5146-763f-8337-4cbda0eb85f7€15.00€0.26matched
125capture01a19fab-6fa9-706e-a4ad-45fff143395a€15.00€0.26matched
126refund01a19fab-70ec-79de-9102-aa9e848e8097-€18.00€0.00matched
127refund01a19fab-7f9a-7f83-96af-40f48ec0637c-€6.00€0.00matched
128capture01a19fab-8488-7c3c-86d7-323f49e72c79€24.00€0.37matched
129capture01a19fab-9587-7814-a50b-9ef0ae32eee0€35.00€0.50matched
130capture01a19fab-9c43-7b99-a16a-8c97948fefcf€15.00€0.26matched
131capture01a19fab-abd1-773d-a4cd-8b32a78f90ef€9.00€0.19matched
132capture01a19fab-ba7d-7c21-afd7-3094706f95ad€49.00€0.67matched
133refund01a19fab-ca07-704a-957e-174cf5ba8588-€23.00€0.00matched
134capture01a19fab-ce8d-7d8e-8f73-324ce7145776€35.00€0.50matched