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

20 Oct, 18:50

Gross

€3,281.00

PSP fee

€51.52

Net to the bank

€3,229.48

Settlement journal

#110105

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a15aac-427c-7a5a-8cd6-df5d4f4be406 is already settled by stl_EUR_2987537 line 86
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • 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 23, the contract says 19
  • missing linein the books, not in the filecapture:01a15aac-ddc6-7d6c-b456-60268ed884b9 is in no file
LineKindReferenceGrossFeeStatus
7capture01a15aa6-5953-7217-8cf6-2767b4b2778e€49.00€0.70fee difference
80capture01a15aab-8b5d-7416-91b7-50b1dade911a€24.00€0.40fee difference
82capture01a15aab-b748-7d3a-ab4f-0bbc32bc2145€9.00€0.23fee difference
87capture01a15aac-429c-7808-8493-ba270ad7c244€49.00€0.67duplicate line
1capture01a15a9f-8d5d-72a3-b96e-d8d3eb81aff1€49.00€0.67matched
2capture01a15a9f-a687-7d01-9ce6-ffd06647af1f€24.00€0.37matched
3capture01a15aa0-1fd8-7614-a918-152db096fdde€24.00€0.37matched
4refund01a15aa2-401d-793d-b7cb-6b4db5eaef92-€3.00€0.00matched
5capture01a15aa4-efa6-78c5-8166-df8cbcd48100€35.00€0.50matched
6capture01a15aa6-3d6d-7819-89f4-3a7ea1912b6f€15.00€0.26matched
8capture01a15aa6-5bf9-788a-881b-0b0092efef60€15.00€0.26matched
9capture01a15aa6-6865-7ecb-a2fd-ae168b84131e€24.00€0.37matched
10capture01a15aa6-6d87-7797-a24c-a5af5bbc0381€15.00€0.26matched
11capture01a15aa6-71c5-7fe0-a404-afbfd86e8e43€24.00€0.37matched
12capture01a15aa6-732f-7413-89e0-22261d3a40c9€35.00€0.50matched
13capture01a15aa6-a130-787c-ade2-d3a23e14b74f€35.00€0.50matched
14capture01a15aa6-a167-74bc-b312-38b62156309f€35.00€0.50matched
15capture01a15aa6-adba-7dfd-9619-b8efef34588c€9.00€0.19matched
16capture01a15aa6-b837-7f5a-bdd0-a44e15177098€35.00€0.50matched
17capture01a15aa6-d5c6-72ab-be5c-965fcdf28212€15.00€0.26matched
18capture01a15aa6-ea83-7f32-b6a4-18bdc44af234€9.00€0.19matched
19capture01a15aa6-f840-7c39-939d-b5c148b36c32€9.00€0.19matched
20capture01a15aa7-0928-7a96-b5a5-8582c03b9d86€24.00€0.37matched
21refund01a15aa7-2d73-7bbc-b02c-d9558f2c6a9d-€27.00€0.00matched
22capture01a15aa7-3397-7671-8f28-dbed68e8974d€9.00€0.19matched
23capture01a15aa7-477d-7543-a41e-293073ef3763€24.00€0.37matched
24capture01a15aa7-56d2-700e-a58b-51f76454d0d3€9.00€0.19matched
25capture01a15aa7-5b0f-77ae-83ba-e417616e475b€24.00€0.37matched
26capture01a15aa7-5f69-7485-97a8-7a2965ea1c55€15.00€0.26matched
27capture01a15aa7-683a-75ff-9635-ff6b927b0732€49.00€0.67matched
28capture01a15aa7-69b6-75c9-9e4f-8a799b729f06€15.00€0.26matched
29capture01a15aa7-8c4c-7ced-a494-dc549f7c24a1€15.00€0.26matched
30capture01a15aa7-94ea-708b-88d2-dd7a9bb48507€35.00€0.50matched
31capture01a15aa7-9f82-76dd-94a1-0222e4a79384€15.00€0.26matched
32capture01a15aa7-ba31-7e86-b95d-d6de37a3ccbe€35.00€0.50matched
33capture01a15aa7-c8b0-7129-8221-47a67aeec0da€24.00€0.37matched
34capture01a15aa7-dac6-7a5d-8b3f-9f522f9d0498€49.00€0.67matched
35capture01a15aa7-e27f-7a0a-a340-a66364fc8dff€15.00€0.26matched
36capture01a15aa8-0a8c-7885-a9a2-6bd5b8003cbf€35.00€0.50matched
37capture01a15aa8-2333-7574-b5be-863eac13b1dd€15.00€0.26matched
38capture01a15aa8-27cc-736d-ad7a-e7c13e2f9cef€15.00€0.26matched
39capture01a15aa8-2bf8-779c-9547-077ea296760c€15.00€0.26matched
40capture01a15aa8-5533-7d3e-9371-a4fb4ce7d908€15.00€0.26matched
41capture01a15aa8-5a27-76d5-b0d0-c038a8775374€9.00€0.19matched
42capture01a15aa8-7034-7a87-99c0-a76f38d542f6€49.00€0.67matched
43capture01a15aa8-9375-7fce-ad23-47af946d5218€49.00€0.67matched
44capture01a15aa8-aa63-70b0-b484-e5f4097083dc€15.00€0.26matched
45capture01a15aa8-c1a8-7be5-9483-2ecc0ca83c15€15.00€0.26matched
46capture01a15aa8-c57c-729f-a163-eb0ebe8a9df4€35.00€0.50matched
47capture01a15aa9-0a46-756b-8123-f9ae7ff45c57€35.00€0.50matched
48capture01a15aa9-20e1-784b-ae10-74d42f25ea39€35.00€0.50matched
49capture01a15aa9-25c0-73c4-b234-a869f3ed6634€35.00€0.50matched
50capture01a15aa9-846f-7edf-86aa-f4e74b3c794a€15.00€0.26matched
51capture01a15aa9-a384-7083-b21e-6eef537280d9€49.00€0.67matched
52capture01a15aa9-b6c5-7d9d-be07-285d417ba6e6€9.00€0.19matched
53capture01a15aa9-eee9-7def-9eed-e6ea40c2261f€15.00€0.26matched
54capture01a15aa9-f0db-7a07-8348-eaf39ebeda10€49.00€0.67matched
55capture01a15aaa-0399-784a-8a43-a8d80f974247€49.00€0.67matched
56capture01a15aaa-1352-7e18-a5d1-21387916a108€15.00€0.26matched
57capture01a15aaa-5b6b-7812-a972-910dea069fa8€49.00€0.67matched
58capture01a15aaa-63a9-7a33-965a-812027c12d84€35.00€0.50matched
59capture01a15aaa-728a-7a1d-9709-ee30bfc2626e€9.00€0.19matched
60capture01a15aaa-7455-7ec5-927a-883748dc34ab€9.00€0.19matched
61capture01a15aaa-75aa-71d9-b4e1-aafe778893c3€15.00€0.26matched
62capture01a15aaa-7bdf-7fe7-9d45-f268f001903a€35.00€0.50matched
63capture01a15aaa-a058-7570-a83e-0d8f7d743235€24.00€0.37matched
64refund01a15aaa-a68a-7ea3-bf06-985a29ed50ed-€17.00€0.00matched
65capture01a15aaa-cfb8-7aab-9c3c-07d96c838b31€35.00€0.50matched
66capture01a15aaa-d169-7881-ba34-3eedddf00477€49.00€0.67matched
67refund01a15aab-0087-7cfa-b689-d5f23907da3a-€16.00€0.00matched
68capture01a15aab-03a2-70fe-9c2c-70ad85b1b66f€49.00€0.67matched
69capture01a15aab-16da-78d3-81d1-111f43fcf833€9.00€0.19matched
70capture01a15aab-1841-79f1-9444-ad6d34696fde€15.00€0.26matched
71capture01a15aab-1f36-78f5-8cb4-60930dda569a€35.00€0.50matched
72capture01a15aab-221f-7999-b5e4-44e74b57f8b7€9.00€0.19matched
73capture01a15aab-2890-77a2-9885-4dc67a0e4969€24.00€0.37matched
74capture01a15aab-340a-7640-952e-38b5d52dbc24€24.00€0.37matched
75capture01a15aab-46cd-75a3-9782-2e735ffe07f1€15.00€0.26matched
76capture01a15aab-5660-75fb-82e2-4e0860cb9017€15.00€0.26matched
77capture01a15aab-704d-763a-88c6-add511f52644€9.00€0.19matched
78capture01a15aab-7ccb-7224-9959-9f14b1a207a4€49.00€0.67matched
79capture01a15aab-8337-7dbd-a78a-9a7124bae3a4€35.00€0.50matched
81capture01a15aab-8b94-73c3-ae9c-8dba54fde927€49.00€0.67matched
83capture01a15aab-cbdb-7cb1-9d02-4ee19e46efd9€15.00€0.26matched
84capture01a15aab-d126-7965-ba69-3366c488d636€35.00€0.50matched
85capture01a15aac-1767-7686-a9e7-04fd25cdc87c€49.00€0.67matched
86capture01a15aac-429c-7808-8493-ba270ad7c244€49.00€0.67matched
88capture01a15aac-4ebc-7c22-ae43-8905c3f509aa€49.00€0.67matched
89capture01a15aac-54c6-75a4-a93f-d1cd85e402fb€9.00€0.19matched
90refund01a15aac-5b4c-7153-9081-5263af503a22-€13.00€0.00matched
91refund01a15aac-97c8-719d-acd8-a42d86fda5fe-€5.00€0.00matched
92capture01a15aac-9ee1-7261-9ae2-ae28e4666f3b€35.00€0.50matched
93capture01a15aac-aea4-7524-8e3c-9d37420c92f2€35.00€0.50matched
94capture01a15aac-d412-73aa-bdea-5b99e0fc83db€35.00€0.50matched
95capture01a15aac-f13a-780b-b4c0-76eede36d90e€15.00€0.26matched
96capture01a15aac-f4ed-70fb-af46-c581bebaf056€35.00€0.50matched
97capture01a15aad-1590-73d9-8bd2-831cd5f074cc€15.00€0.26matched
98capture01a15aad-3486-7520-8253-c7126434bec1€24.00€0.37matched
99capture01a15aad-3d98-7f76-a65a-3ff83ae685bb€9.00€0.19matched
100capture01a15aad-4106-73b5-a099-0aef65d3f863€9.00€0.19matched
101capture01a15aad-436d-7fec-9d71-836f5a7fb959€35.00€0.50matched
102refund01a15aad-52b8-7837-bd6c-dd876d9d5e9d-€14.00€0.00matched
103capture01a15aad-5b50-734a-9ed0-bf233af4b124€15.00€0.26matched
104refund01a15aad-60e7-7190-96f7-576f5a07bcdc-€5.00€0.00matched
105capture01a15aad-75be-7e28-a9b5-ed742786738a€35.00€0.50matched
106capture01a15aad-7ef2-798d-8af4-5ae8a86cbced€35.00€0.50matched
107refund01a15aad-b2e3-7f78-9970-5782a0c328b7-€24.00€0.00matched
108capture01a15aad-bfa2-7249-b866-0b80b47c6a5e€49.00€0.67matched
109capture01a15aad-c40a-7eee-bfe8-43a769ae84bb€49.00€0.67matched
110capture01a15aad-c4a7-7f72-8fde-1f3dafb76860€24.00€0.37matched
111capture01a15aad-c5ef-73e8-bbd1-8e64ea3177c1€35.00€0.50matched
112capture01a15aad-dfac-7043-86b5-f32757d55b62€9.00€0.19matched
113capture01a15aad-e902-73ac-acf4-238274328450€24.00€0.37matched
114capture01a15aae-065a-73d9-9534-36862ed13ef9€24.00€0.37matched
115capture01a15aae-256a-735e-a8fe-a33da6f02128€15.00€0.26matched
116capture01a15aae-27fc-7918-aae8-62db9d84ea35€24.00€0.37matched
117refund01a15aae-3228-729c-ae52-77e1e1e489ad-€7.00€0.00matched
118capture01a15aae-5b09-73fc-b5d7-5f8533266a17€35.00€0.50matched
119capture01a15aae-5b40-7968-9e3b-c23af9b9c075€24.00€0.37matched
120capture01a15aae-5c5a-792b-8202-97ed41a952d6€35.00€0.50matched
121capture01a15aae-5f3f-7971-8225-b15e2954d8a8€49.00€0.67matched
122capture01a15aae-6e3d-78a1-b64f-704b913a3268€35.00€0.50matched
123capture01a15aae-7230-7e3a-b9ac-d0d7f9b83d7b€9.00€0.19matched
124capture01a15aae-9591-7ed5-9e2c-5b5b64283eda€35.00€0.50matched
125capture01a15aae-a032-76d2-a0ce-2f31c58328de€49.00€0.67matched
126refund01a15aae-c6ea-7d8d-a25c-695bd6813985-€22.00€0.00matched
127capture01a15aae-ce27-7604-b6c3-47647478b9a9€9.00€0.19matched
128capture01a15aae-d1b9-7a6a-b22d-0901acbe5958€49.00€0.67matched
129capture01a15aae-d7a9-7b5e-87e1-8bedaf49a279€49.00€0.67matched
130capture01a15aae-d8f0-7171-b28a-5a8dd96619ec€9.00€0.19matched
131capture01a15aae-d924-7f0d-9e95-1fb2f6bddf90€24.00€0.37matched
132capture01a15aae-d937-7187-9227-e16e5fae72cf€35.00€0.50matched
133capture01a15aae-d94b-774c-a188-815078356bc4€49.00€0.67matched
134capture01a15aae-e51b-7fd5-b19d-84201e090827€35.00€0.50matched
135capture01a15aaf-29d9-7d98-a43b-65eca8c6eaab€15.00€0.26matched
136capture01a15aaf-38ea-7451-b902-fa6faaeb6b78€24.00€0.37matched
137capture01a15aaf-44cb-7aac-a013-4404dfded4f0€9.00€0.19matched