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

2 Nov, 13:40

Gross

€3,045.00

PSP fee

€47.75

Net to the bank

€2,997.25

Settlement journal

#343758

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19c7d-85b8-7a9e-9a3f-34afef1140fc is already settled by stl_EUR_2989378 line 13
  • duplicate linethe file lists it twicecapture:01a19c81-dbef-7b20-a248-29054b53a3d4 is already settled by stl_EUR_2989378 line 74
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • missing linein the books, not in the filecapture:01a19c7e-9012-7173-ba99-a05cfee9d9b9 is in no file
  • missing linein the books, not in the filecapture:01a19c83-d1c7-756d-b201-95decc7f1652 is in no file
LineKindReferenceGrossFeeStatus
9capture01a19c7d-4d59-765b-b776-977be38b2225€15.00€0.29fee difference
14capture01a19c7d-85f7-73aa-a4e9-67805c57b7f4€9.00€0.19duplicate line
31capture01a19c7f-0143-79aa-be9a-57e3e80e36c8€35.00€0.55fee difference
72capture01a19c81-b72b-75d9-9a89-2c75056239b9€35.00€0.51fee difference
75capture01a19c81-dc1b-7b22-8949-3b2ae768cbf1€35.00€0.50duplicate line
1capture01a19c77-2c38-73b2-b212-5f94cd99141e€24.00€0.37matched
2capture01a19c79-3e1f-70d1-8c54-bea9f08a216b€35.00€0.50matched
3refund01a19c79-722b-7b45-b86b-4ee17201137b-€14.00€0.00matched
4capture01a19c79-933d-771e-a9b8-8dd55824545b€9.00€0.19matched
5capture01a19c7a-be14-7018-a7bd-ef6ec5d18952€49.00€0.67matched
6capture01a19c7d-3020-7d00-959d-8c6fcc355c2c€49.00€0.67matched
7capture01a19c7d-3b51-7df5-bee6-11d31393f398€49.00€0.67matched
8capture01a19c7d-430a-7909-9d6d-caa8f57c850a€49.00€0.67matched
10capture01a19c7d-740c-7107-a9ad-efa60f25a45d€35.00€0.50matched
11capture01a19c7d-74ee-7221-ae9d-7227d90fb3c2€49.00€0.67matched
12capture01a19c7d-78b0-75b8-8037-24a68d5240c7€35.00€0.50matched
13capture01a19c7d-85f7-73aa-a4e9-67805c57b7f4€9.00€0.19matched
15capture01a19c7d-d1d9-76ea-b055-debc9ee9b78f€9.00€0.19matched
16capture01a19c7d-db3f-7b3b-b71e-3f71e8da191b€15.00€0.26matched
17capture01a19c7e-0a2d-7b6b-8636-d02dda949538€15.00€0.26matched
18capture01a19c7e-0cab-7c01-b784-8f4628d1437f€24.00€0.37matched
19capture01a19c7e-1d09-774a-a19b-55bb0821af54€15.00€0.26matched
20capture01a19c7e-31c9-72ea-b7c9-67300e85495d€49.00€0.67matched
21capture01a19c7e-3cfb-71c6-8bc5-2f78eb5f0aa7€15.00€0.26matched
22capture01a19c7e-7614-7bb6-a9a5-51fdcd45ff25€9.00€0.19matched
23capture01a19c7e-7719-7e39-81f9-503ce396e1e1€35.00€0.50matched
24capture01a19c7e-9b6a-7303-aeed-d64ea42115e9€49.00€0.67matched
25capture01a19c7e-aa06-7a39-9ae0-9fe3ada63744€49.00€0.67matched
26capture01a19c7e-ae93-758f-842a-fcaaea10c2c6€15.00€0.26matched
27capture01a19c7e-b773-76ce-9cca-8594c4741375€24.00€0.37matched
28capture01a19c7e-dd12-794e-b6a2-309aa396e392€9.00€0.19matched
29capture01a19c7e-eeeb-710f-a1dd-7ff73a719569€49.00€0.67matched
30capture01a19c7e-eff6-7c54-ae54-095993a24310€24.00€0.37matched
32capture01a19c7f-0e58-7696-a6ba-544de8cc4d45€24.00€0.37matched
33capture01a19c7f-182f-7541-b77d-ab1e0e27f3f6€24.00€0.37matched
34capture01a19c7f-4fa2-7775-b34b-5904d36670a4€24.00€0.37matched
35capture01a19c7f-50df-76a3-ae2e-9f8d26ea7b63€49.00€0.67matched
36capture01a19c7f-62b0-7401-a9fe-76c179e8c03e€35.00€0.50matched
37capture01a19c7f-6517-7c43-9326-3fe61b5dc907€24.00€0.37matched
38capture01a19c7f-7884-79cb-8d69-39cfd1af735d€49.00€0.67matched
39capture01a19c7f-8f0b-77e0-9d18-347048d610a3€15.00€0.26matched
40capture01a19c7f-8f82-79dd-9c1f-1ef1e6b0e3bb€35.00€0.50matched
41capture01a19c7f-9c86-72c3-8ebe-29e2124cae2f€9.00€0.19matched
42capture01a19c7f-ab49-7299-9617-84a2022ed9e2€24.00€0.37matched
43capture01a19c7f-b6e2-75c5-8d91-db12f7eb343d€24.00€0.37matched
44capture01a19c7f-ce04-7676-8e57-e7017cd65fd0€35.00€0.50matched
45capture01a19c7f-cef5-7617-a0ce-6cd840a29e7f€24.00€0.37matched
46capture01a19c7f-e6b7-733c-b139-f5ea69232116€35.00€0.50matched
47capture01a19c7f-eb24-7457-8419-9d31aefc452c€24.00€0.37matched
48capture01a19c7f-f551-73bc-b442-d1479a5595eb€15.00€0.26matched
49capture01a19c80-2ff7-7c23-9b7f-edba1210a17a€49.00€0.67matched
50refund01a19c80-3a29-760f-9504-5c3ae9102721-€13.00€0.00matched
51capture01a19c80-467d-789d-91b8-dc9348326e68€15.00€0.26matched
52capture01a19c80-5fed-7f4d-8b40-3534116efef5€35.00€0.50matched
53capture01a19c80-7e5d-7565-b490-8ebfe3fa1a9c€49.00€0.67matched
54capture01a19c80-990a-71f1-9724-959bfd97c68c€49.00€0.67matched
55capture01a19c80-9a8c-780a-9e98-44bbd946f783€35.00€0.50matched
56refund01a19c80-a033-79d8-8578-4554fe17b755-€27.00€0.00matched
57capture01a19c80-c9b5-7f0b-bb50-7497b315eba2€9.00€0.19matched
58capture01a19c80-cabd-793d-921f-04174a2d271f€49.00€0.67matched
59capture01a19c80-df51-78ca-9a0d-c1f893383605€15.00€0.26matched
60capture01a19c80-e56b-7286-9fa6-e9f4ddfe3797€49.00€0.67matched
61capture01a19c80-fac8-77ab-93a7-bf5800230e7b€15.00€0.26matched
62capture01a19c81-09a8-7fbc-a879-c1a1359e2539€15.00€0.26matched
63capture01a19c81-0d75-7842-ab0f-a4c32fc937f1€49.00€0.67matched
64capture01a19c81-30f4-70f7-96b4-62d8b2a5a702€24.00€0.37matched
65capture01a19c81-3719-741c-b81c-1a49f64f5e3a€15.00€0.26matched
66refund01a19c81-4de5-7a9f-9696-b318ddbb5269-€7.00€0.00matched
67refund01a19c81-5c2b-7727-b28e-c4101dd69cd5-€20.00€0.00matched
68refund01a19c81-640a-73af-b667-770198fbc854-€13.00€0.00matched
69capture01a19c81-7bf7-7b7a-8dbf-2310e036a12d€15.00€0.26matched
70capture01a19c81-86e1-7d4f-8dfb-8bfc7cc846ec€35.00€0.50matched
71capture01a19c81-8717-7286-b9e4-dd89c3e94f79€9.00€0.19matched
73capture01a19c81-c93f-700f-bb9c-73e0f0f51a02€49.00€0.67matched
74capture01a19c81-dc1b-7b22-8949-3b2ae768cbf1€35.00€0.50matched
76capture01a19c81-e98b-7d0f-a8d2-c19d6312b1be€24.00€0.37matched
77capture01a19c81-f12e-799a-8d77-081bf77f8f3c€24.00€0.37matched
78capture01a19c81-f3c9-773a-8396-6817462b7fef€9.00€0.19matched
79capture01a19c81-fe66-7c3f-bb4a-2625e34a79cf€24.00€0.37matched
80capture01a19c82-027f-7746-960e-3bc7455921f9€35.00€0.50matched
81capture01a19c82-0a49-75b2-ac21-4c9441a19f86€9.00€0.19matched
82capture01a19c82-1a5d-7172-98cf-ad13d6f3c3fa€9.00€0.19matched
83capture01a19c82-4f14-741b-bbc3-890dda01284c€9.00€0.19matched
84capture01a19c82-554f-7df4-beaa-24597f7bc0e9€24.00€0.37matched
85capture01a19c82-7f90-736d-9820-e2860e3d0a97€15.00€0.26matched
86capture01a19c82-8a84-7fbc-9f77-f82a70ff75ca€15.00€0.26matched
87capture01a19c82-b636-7630-be7d-08d17535308a€49.00€0.67matched
88capture01a19c82-d87d-7327-a4bc-994cf5e2436b€24.00€0.37matched
89capture01a19c82-ddd3-7dc8-a83c-ff4eff370522€49.00€0.67matched
90capture01a19c82-df18-7ec9-b57e-8900e8fea753€49.00€0.67matched
91capture01a19c82-fa75-7362-84eb-2bbbf927b60f€9.00€0.19matched
92refund01a19c83-1749-704c-af7d-b3a09b3e4a23-€18.00€0.00matched
93capture01a19c83-46c9-754f-b44f-0583cefb0399€9.00€0.19matched
94capture01a19c83-488b-7e29-9e8c-5f7e668bb30f€49.00€0.67matched
95capture01a19c83-519b-70d0-bfa9-d20a954d959d€35.00€0.50matched
96capture01a19c83-615e-76d9-8ff5-fdb13822f3cc€49.00€0.67matched
97capture01a19c83-70e4-78f1-b633-1a1a60d7ce7b€35.00€0.50matched
98capture01a19c83-9482-7ba7-a786-d84d2cc3c277€35.00€0.50matched
99capture01a19c83-b076-7fd5-8d4f-180c9f5763b5€24.00€0.37matched
100capture01a19c83-dde9-7287-95ac-bee450d5e29f€24.00€0.37matched
101capture01a19c83-e602-7a78-a6ff-0a79a4cf73ff€15.00€0.26matched
102capture01a19c83-ebae-7723-8362-ba6cf45e8446€9.00€0.19matched
103capture01a19c83-fc2a-7111-89ef-58b81383fec5€15.00€0.26matched
104capture01a19c84-1056-7edc-896c-7bc1e866d3f0€9.00€0.19matched
105refund01a19c84-1e68-7288-9ab0-8af82668cf60-€2.00€0.00matched
106capture01a19c84-625f-72bc-9b23-0f4b70a62fcc€24.00€0.37matched
107capture01a19c84-6d50-7116-a743-580369179f30€9.00€0.19matched
108capture01a19c84-73ba-77b4-921b-97d95df2fbab€9.00€0.19matched
109capture01a19c84-7720-7e22-91d9-26825e50d97d€15.00€0.26matched
110capture01a19c84-7bd6-79f1-b091-df2fce315952€9.00€0.19matched
111capture01a19c84-88f9-7353-b458-dcbf3efe835c€24.00€0.37matched
112capture01a19c84-926e-7fda-9044-40cd545cc595€9.00€0.19matched
113capture01a19c84-c434-77ee-b5b3-8c4942cb2ee5€24.00€0.37matched
114capture01a19c84-e403-7cf6-bf89-451d66d09480€15.00€0.26matched
115capture01a19c84-f6dd-7aac-98c3-3733782f640a€24.00€0.37matched
116capture01a19c84-f972-7e37-a20d-0a3b2963dbdf€15.00€0.26matched
117capture01a19c85-0ae9-78e1-babe-c68e1c14b3f6€49.00€0.67matched
118capture01a19c85-2249-768d-9e67-698c70dc658b€24.00€0.37matched
119capture01a19c85-523c-70a7-a047-5e2ecc3d7ea9€15.00€0.26matched
120capture01a19c85-bae4-78f5-8654-073407f100a4€9.00€0.19matched
121capture01a19c85-bf97-743b-be41-3bc17ed1800e€15.00€0.26matched
122capture01a19c85-c314-7a49-9f2a-91feb079441a€9.00€0.19matched
123capture01a19c85-cf9c-72ce-ac64-f750437f5b74€24.00€0.37matched
124capture01a19c85-e72f-7c18-8f4e-3277d4bc44cb€35.00€0.50matched
125capture01a19c85-e90c-76d0-a573-3c55845c89ea€24.00€0.37matched
126capture01a19c85-f0d3-76d5-8e3e-dc0e336e3f58€24.00€0.37matched
127capture01a19c85-f2a0-7044-a741-f050ed0ca013€35.00€0.50matched
128capture01a19c86-0cc8-79d0-b857-678b9d7ef9c1€24.00€0.37matched