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, 00:50

Gross

€2,500.00

PSP fee

€39.96

Net to the bank

€2,460.04

Settlement journal

#352347

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19ee4-a99a-73c7-94e9-3338b1a32174 is already settled by stl_EUR_2989445 line 39
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 5, the contract says 0
  • missing linein the books, not in the filecapture:01a19ee5-3a04-7674-8a74-fa1d1279874c is in no file
LineKindReferenceGrossFeeStatus
40capture01a19ee4-a9cc-73db-9162-afb6b7ac53e1€49.00€0.67duplicate line
71refund01a19ee7-db81-742f-8dd2-01ff8276d541-€14.00€0.02fee difference
74capture01a19ee8-8443-7372-a5f5-2dad50813dd4€49.00€0.72fee difference
93refund01a19ee9-bfb3-735c-a374-c190107e0c58-€8.00€0.05fee difference
1capture01a19ed9-5c9d-7ee6-8678-4c2141f9a830€35.00€0.50matched
2capture01a19eda-1124-78de-9711-c5ce4e88ff99€35.00€0.50matched
3capture01a19eda-8dc6-7be6-a717-cd8b77076ee1€49.00€0.67matched
4capture01a19edf-0df4-76b2-8a1e-489a29bdda74€24.00€0.37matched
5capture01a19edf-42fd-7930-8bcb-22686f746dbf€35.00€0.50matched
6capture01a19ee2-6868-7110-84a9-a71a2e1d7ba1€35.00€0.50matched
7capture01a19ee2-80db-7698-967e-fbfd7bc3b23c€15.00€0.26matched
8capture01a19ee2-92e8-7d42-bda6-2d446e2a31f8€9.00€0.19matched
9capture01a19ee2-c650-7cae-841a-adb417d30d2d€49.00€0.67matched
10capture01a19ee2-c933-77ae-ba5d-f81d4bb37b1f€49.00€0.67matched
11capture01a19ee2-d50f-764f-b795-8054e458a18e€24.00€0.37matched
12capture01a19ee3-073b-7402-93e1-881acb1a43cc€15.00€0.26matched
13capture01a19ee3-091d-7149-8e67-e1456b638fef€24.00€0.37matched
14capture01a19ee3-23b9-7bfb-96da-91d2aefa02ff€24.00€0.37matched
15capture01a19ee3-44ea-798f-a2de-9b7c1936f697€49.00€0.67matched
16capture01a19ee3-5020-7a70-b649-0bd1ac5571f6€24.00€0.37matched
17capture01a19ee3-5e80-7fab-a84e-0f77561cf820€35.00€0.50matched
18capture01a19ee3-606f-7637-ac1d-888d43484718€9.00€0.19matched
19capture01a19ee3-61cd-74fa-8b18-ed221d70f4db€35.00€0.50matched
20capture01a19ee3-61cd-7536-84e5-095ab9ba36dd€15.00€0.26matched
21capture01a19ee3-9ef2-7155-9e97-1bb7a96f4260€49.00€0.67matched
22capture01a19ee3-a258-7819-bfbc-f188955e644f€35.00€0.50matched
23capture01a19ee3-abfc-708b-8006-52a985e335f6€9.00€0.19matched
24capture01a19ee3-c2e1-7833-9818-09341454d76b€24.00€0.37matched
25capture01a19ee3-fa14-7889-beca-27f5295d79c0€35.00€0.50matched
26capture01a19ee4-1305-76cf-b48a-1a1507d1f0e4€15.00€0.26matched
27refund01a19ee4-1640-7730-a2a4-58f3ed712f50-€25.00€0.00matched
28capture01a19ee4-20d1-7828-9538-a5af2db1a3ad€49.00€0.67matched
29capture01a19ee4-31db-7620-b6f8-8bccdaeab42e€9.00€0.19matched
30capture01a19ee4-38b4-7c1c-9002-54a9881c64e4€15.00€0.26matched
31capture01a19ee4-4993-7489-a98e-ebc9ddfa4e00€9.00€0.19matched
32capture01a19ee4-4a52-7678-8aba-18c1e2d7a2e6€35.00€0.50matched
33capture01a19ee4-77f4-7abe-87a8-9990724dd4e8€35.00€0.50matched
34capture01a19ee4-78f3-72ce-9862-5b34045158e4€24.00€0.37matched
35capture01a19ee4-7ce0-70a0-86a9-1a8311a52981€49.00€0.67matched
36capture01a19ee4-8866-76dd-939d-7c2fb514c1f4€24.00€0.37matched
37capture01a19ee4-91d9-7ee1-9898-fd2ad16f10da€15.00€0.26matched
38refund01a19ee4-a54c-7fc7-8486-6dae0e2abdc3-€7.00€0.00matched
39capture01a19ee4-a9cc-73db-9162-afb6b7ac53e1€49.00€0.67matched
41refund01a19ee4-d3b3-7eb3-b0a1-d069eb2d355a-€48.00€0.00matched
42capture01a19ee5-0189-7753-b83e-3c59ea0a8606€49.00€0.67matched
43capture01a19ee5-33f1-7bae-a13f-f5d31ed78928€24.00€0.37matched
44capture01a19ee5-5625-7b65-88e5-41f0d51ce58f€9.00€0.19matched
45capture01a19ee5-58bc-7d2a-a5f0-66c3b2a110c1€35.00€0.50matched
46capture01a19ee5-5cc5-761d-bd09-cdf98c9d8293€9.00€0.19matched
47capture01a19ee5-7681-7f5e-a3fb-6904a129070e€35.00€0.50matched
48capture01a19ee5-7b1f-7713-a1af-0f9c422242ed€15.00€0.26matched
49capture01a19ee5-a3e0-7f3a-9372-9852171f31a9€15.00€0.26matched
50capture01a19ee5-cca8-7fbd-89ce-b0f15df70c35€24.00€0.37matched
51capture01a19ee5-de68-78eb-9687-8760bf00420d€24.00€0.37matched
52capture01a19ee6-3c68-7f72-b0e8-db4ab7bf9717€9.00€0.19matched
53capture01a19ee6-3fc0-7d9b-a961-0251169c1c6b€15.00€0.26matched
54capture01a19ee6-4e46-7130-a6c1-f5ec98352af7€35.00€0.50matched
55capture01a19ee6-6260-768f-a8f4-33f0dfa53930€9.00€0.19matched
56capture01a19ee6-958f-74b0-9130-c5ac799c894d€9.00€0.19matched
57capture01a19ee6-a62f-73a7-a0ea-e96a895d4d8f€24.00€0.37matched
58capture01a19ee6-d2a0-7068-9817-0be01fe9244f€15.00€0.26matched
59refund01a19ee6-dea9-741a-9848-26d8ff6ef933-€13.00€0.00matched
60capture01a19ee6-f4c1-7e63-8389-98a347d27b06€35.00€0.50matched
61capture01a19ee7-21c6-7623-ac27-aa5996c0537d€15.00€0.26matched
62capture01a19ee7-3842-7769-87b9-13c958a4f36d€24.00€0.37matched
63capture01a19ee7-3b92-7531-b65d-4b4fd5e8e513€15.00€0.26matched
64capture01a19ee7-7eaf-7b9d-b683-ed9f43ef5a30€35.00€0.50matched
65capture01a19ee7-9a02-7581-a93a-9aa93d7d9d7b€35.00€0.50matched
66capture01a19ee7-a60f-749c-bf3c-604e47661fe7€35.00€0.50matched
67capture01a19ee7-a8ee-7f67-8844-e36bca849b23€24.00€0.37matched
68capture01a19ee7-b47d-75ac-aa0a-7ba8c5ebd3d8€49.00€0.67matched
69capture01a19ee7-c3f0-7d68-badf-2ff10e9d84af€9.00€0.19matched
70capture01a19ee7-d3df-74bc-a140-801c4e36b8ea€49.00€0.67matched
72capture01a19ee8-1ac6-7b8d-81aa-4ab1aea3d9e2€15.00€0.26matched
73capture01a19ee8-4cd4-7a79-9020-3f1711854c53€24.00€0.37matched
75capture01a19ee8-9413-7473-b899-bc54c2a3140f€49.00€0.67matched
76capture01a19ee8-a64e-7593-a843-928fe34f8993€15.00€0.26matched
77capture01a19ee8-b545-7446-b665-69fb634195b7€9.00€0.19matched
78capture01a19ee8-d4ec-77be-942d-ef42bf5e6631€24.00€0.37matched
79capture01a19ee8-f153-73f8-b1d5-5a777ca34e08€15.00€0.26matched
80capture01a19ee8-f957-7c5c-a90d-024186e89293€9.00€0.19matched
81capture01a19ee9-0a02-77fc-b0b2-cb0e7c7d0463€24.00€0.37matched
82capture01a19ee9-2ee8-7242-bf2c-15e81ccdf63f€24.00€0.37matched
83capture01a19ee9-45d5-73f3-bb71-1fbe1aa1e1b7€35.00€0.50matched
84capture01a19ee9-6d6e-7fb7-b98e-57d590b5c892€15.00€0.26matched
85capture01a19ee9-858b-7e90-9901-5115a18921ac€9.00€0.19matched
86capture01a19ee9-9f99-71f5-9c19-1d5054617302€24.00€0.37matched
87capture01a19ee9-9fc5-7c20-97bb-2a76dd6d3fbc€9.00€0.19matched
88capture01a19ee9-a414-754b-a22b-661815cc6d08€15.00€0.26matched
89capture01a19ee9-aeb9-75c8-802c-47d499c77902€24.00€0.37matched
90capture01a19ee9-b729-7657-8fbd-93fa78ba79f6€9.00€0.19matched
91capture01a19ee9-b749-7c4a-9986-1ab25931b3d6€9.00€0.19matched
92capture01a19ee9-bdfa-722c-91e7-bc8acd84c1b7€35.00€0.50matched
94refund01a19ee9-ef40-77a9-bca6-b5d823983476-€10.00€0.00matched
95refund01a19ee9-fee2-7038-8a2e-60eac2c2936f-€5.00€0.00matched
96capture01a19eea-2c80-750d-87c4-e4113e8b86d7€15.00€0.26matched
97capture01a19eeb-1878-7bdf-9374-bcf0371e2694€35.00€0.50matched
98capture01a19eeb-2d9d-79f9-95e2-2d5fad663e21€9.00€0.19matched
99capture01a19eeb-3521-746c-8309-cc2679c3f25d€24.00€0.37matched
100capture01a19eeb-35e6-7b44-a309-34955d5c2c8e€24.00€0.37matched
101capture01a19eeb-3ea5-7666-bd53-544f9f153e19€24.00€0.37matched
102capture01a19eeb-3eac-7ea8-a073-059ee2143da6€24.00€0.37matched
103capture01a19eeb-48da-76f2-b902-549dc72b5151€15.00€0.26matched
104capture01a19eeb-4f18-721b-96b6-58a1036be9e0€49.00€0.67matched
105capture01a19eeb-6261-7036-b47b-a0850968b0e1€49.00€0.67matched
106capture01a19eeb-6453-7678-9f49-faebef377944€35.00€0.50matched
107capture01a19eeb-6a5b-7299-8b89-c0aa55b0c317€35.00€0.50matched
108capture01a19eeb-6aed-7527-84a4-1bf08c6dc389€9.00€0.19matched
109capture01a19eeb-711e-74ed-86b4-e9cb8d533664€35.00€0.50matched
110capture01a19eeb-7730-74b6-b423-7afcf55412e3€9.00€0.19matched