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, 13:40

Gross

€2,631.00

PSP fee

€41.32

Net to the bank

€2,589.68

Settlement journal

#398547

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
  • missing linein the books, not in the filecapture:01a1abf8-f3da-74fe-b2b2-204da54e9bb9 is in no file
LineKindReferenceGrossFeeStatus
29capture01a1abf2-34f9-7a55-b919-04735b6884ac€15.00€0.30fee difference
1refund01a1abf0-1596-76cd-bba3-3bcfdf1a7de4-€12.00€0.00matched
2refund01a1abf0-28db-7f0a-90c6-9a2b4a3e74ea-€10.00€0.00matched
3capture01a1abf0-3008-797c-91d1-e7c5c49713c9€9.00€0.19matched
4capture01a1abf0-301c-7bf2-b687-60fc85664067€9.00€0.19matched
5refund01a1abf0-5e44-7a48-ac49-f2f4e2f63c51-€9.00€0.00matched
6capture01a1abf0-6e91-799d-8361-0afc96bd4513€49.00€0.67matched
7capture01a1abf0-b41b-7045-af87-74cc9d1fcbf3€15.00€0.26matched
8capture01a1abf0-b7a3-701b-abef-b7588fce620c€35.00€0.50matched
9refund01a1abf0-f204-70b7-986b-db38685a72ab-€18.00€0.00matched
10capture01a1abf1-0c88-7251-ba14-54bcae8d0221€9.00€0.19matched
11capture01a1abf1-1c4d-7438-922a-13154a32e7b8€24.00€0.37matched
12capture01a1abf1-1d49-7157-b411-4b4cd5d1e322€24.00€0.37matched
13capture01a1abf1-4297-7dbd-af49-ad01d98ff4fe€35.00€0.50matched
14capture01a1abf1-43f2-75b5-b972-19717693bb52€49.00€0.67matched
15capture01a1abf1-51fe-7e81-a838-a3785820b9cb€49.00€0.67matched
16capture01a1abf1-59d1-7c50-911d-3c84fd19e75b€24.00€0.37matched
17capture01a1abf1-7277-793d-8602-43f3669418df€9.00€0.19matched
18capture01a1abf1-709d-7941-98e5-e9a07d6578bd€9.00€0.19matched
19capture01a1abf1-754f-786c-9a4f-118c2b9ab102€35.00€0.50matched
20capture01a1abf1-818d-7bcc-ab14-df95eaa0b3fa€9.00€0.19matched
21capture01a1abf1-842e-733d-aaf9-a329bc377bb1€24.00€0.37matched
22capture01a1abf1-a8b4-778d-a6e7-232d54135d4b€49.00€0.67matched
23capture01a1abf1-bb35-76e9-afd1-931c626ce27f€24.00€0.37matched
24capture01a1abf1-c71d-7df4-a65f-45f43b4963c3€9.00€0.19matched
25capture01a1abf1-ca21-7f61-ae5b-f30573823a0d€49.00€0.67matched
26capture01a1abf1-d50b-7497-88d4-e953e1af242e€24.00€0.37matched
27capture01a1abf1-fa1c-7ab2-895e-2b8921b5d5b6€15.00€0.26matched
28capture01a1abf2-310f-726e-8bce-997fdbf5d00e€15.00€0.26matched
30capture01a1abf2-48db-74dd-a808-4ae2de6f5a6c€15.00€0.26matched
31capture01a1abf2-583b-7997-8334-a78357e83a4d€49.00€0.67matched
32capture01a1abf2-5ae2-79f6-8145-4a392905949a€9.00€0.19matched
33capture01a1abf2-70e1-7748-b4ab-3758aafe6659€24.00€0.37matched
34capture01a1abf2-82dc-7534-bac7-1524ee21b7a8€49.00€0.67matched
35capture01a1abf2-ce61-752c-b3aa-88d38e2af369€49.00€0.67matched
36capture01a1abf2-d0be-794a-a766-8af4712c307b€24.00€0.37matched
37capture01a1abf2-ea6f-7355-a00a-823abd958bd9€24.00€0.37matched
38capture01a1abf3-2c5c-7edb-b6c3-9b4e7f1d4683€15.00€0.26matched
39capture01a1abf3-2e73-700c-8bb7-62eb5adff8ff€9.00€0.19matched
40capture01a1abf3-350b-7719-8ed4-d21b1946a886€24.00€0.37matched
41capture01a1abf3-37ca-7884-9fc1-54934d764490€9.00€0.19matched
42capture01a1abf3-3a07-7e80-af3e-75ad52e1d83e€49.00€0.67matched
43capture01a1abf3-4e75-7a98-8852-176186447d1e€49.00€0.67matched
44capture01a1abf3-54ed-7371-9a9c-bcbef496f6a1€9.00€0.19matched
45capture01a1abf3-5736-784d-abe5-8bb8b3e7dc03€35.00€0.50matched
46refund01a1abf3-7351-7aba-8624-9b66558aa4d0-€10.00€0.00matched
47capture01a1abf3-78c2-75f4-b7a1-632faf9a651c€15.00€0.26matched
48capture01a1abf3-b763-7882-b42b-d6535b7e77fe€9.00€0.19matched
49capture01a1abf3-c979-7e7d-808b-977f967b0427€15.00€0.26matched
50capture01a1abf3-cd94-7816-b5e4-6b574a200f5e€35.00€0.50matched
51capture01a1abf3-cd9b-7f1f-878f-ab2f7525a1e4€35.00€0.50matched
52capture01a1abf4-1ca2-78ff-bc67-10626b320bea€9.00€0.19matched
53capture01a1abf4-2c0d-7d16-a465-cbded671dbea€35.00€0.50matched
54capture01a1abf4-5b83-716b-82db-12da99a7021d€15.00€0.26matched
55capture01a1abf4-6130-7854-9a68-a96b92b12137€15.00€0.26matched
56capture01a1abf4-642b-7d7c-aa6b-19b61d52a040€24.00€0.37matched
57capture01a1abf4-7098-7800-a6b5-d577cff74115€35.00€0.50matched
58capture01a1abf4-74dd-721b-a2cf-66013e272459€15.00€0.26matched
59capture01a1abf4-b4fc-7078-a58c-1a742489cd77€24.00€0.37matched
60capture01a1abf4-c222-7620-843a-baff6ec2e375€9.00€0.19matched
61capture01a1abf4-e472-7eb2-ab90-ce0b2ea7fdd9€49.00€0.67matched
62capture01a1abf5-01ca-710f-8cfc-493dd8cc5cd9€35.00€0.50matched
63capture01a1abf5-3bed-7f4d-9174-41818c763e6a€35.00€0.50matched
64capture01a1abf5-5060-7d92-b78b-5e287e76738e€9.00€0.19matched
65capture01a1abf5-8e84-7bfd-bae5-bba5eb3ec458€35.00€0.50matched
66capture01a1abf5-bd86-7e69-b5fd-3682d0767b72€24.00€0.37matched
67capture01a1abf5-c863-7647-847f-66ffe15a62c8€35.00€0.50matched
68capture01a1abf5-d453-72a9-a83d-9198eb7db3d2€35.00€0.50matched
69capture01a1abf5-e8ad-7089-85f0-864de570a411€15.00€0.26matched
70capture01a1abf6-0f9d-7c98-a4b0-d51621ae09e6€49.00€0.67matched
71capture01a1abf6-2f99-7746-bdec-7c72f9b25a24€15.00€0.26matched
72capture01a1abf6-5f60-705b-9847-3abc3a2939bc€9.00€0.19matched
73capture01a1abf6-647f-7d66-8334-7d2ceaa26d16€24.00€0.37matched
74capture01a1abf6-7039-7740-927e-d0d950223b3c€15.00€0.26matched
75capture01a1abf6-7b41-7bc1-a4a2-67598286dda6€35.00€0.50matched
76capture01a1abf6-8a06-73a0-88b9-429fca3d82fc€9.00€0.19matched
77capture01a1abf6-9169-7a03-b606-87def6b7d142€49.00€0.67matched
78capture01a1abf6-a4d2-7147-9539-f1d0209009a6€24.00€0.37matched
79capture01a1abf6-aad4-71c1-8c5d-f89c9f5247e1€24.00€0.37matched
80capture01a1abf6-abbc-79e9-be80-e82c0cbd122d€24.00€0.37matched
81capture01a1abf6-d1c4-7ab3-a966-a19568bf91f4€15.00€0.26matched
82capture01a1abf6-d939-741e-bbfe-905862d952ad€9.00€0.19matched
83capture01a1abf6-f716-7305-a758-5d02115db011€9.00€0.19matched
84capture01a1abf6-fb70-7546-ab74-014f114de871€15.00€0.26matched
85capture01a1abf7-01f3-70cf-9a09-f143b92f2810€9.00€0.19matched
86capture01a1abf7-23f5-76bf-9cda-d4b5d2606156€15.00€0.26matched
87capture01a1abf7-2d38-7520-b0cb-fda4f4e6edba€35.00€0.50matched
88capture01a1abf7-40a5-7011-abfb-c7d404a33476€35.00€0.50matched
89capture01a1abf7-4a97-791b-846b-597eb913b2e2€15.00€0.26matched
90capture01a1abf7-4d52-75b9-aeb1-56123e0a795d€24.00€0.37matched
91capture01a1abf7-5149-76ea-9c09-df3820e79932€15.00€0.26matched
92capture01a1abf7-5db4-7d94-b384-5f72e1880e3d€24.00€0.37matched
93capture01a1abf7-728c-753d-a27e-f503cc4f4b40€24.00€0.37matched
94capture01a1abf7-9736-7843-bd3e-70c7c2873196€49.00€0.67matched
95refund01a1abf7-a03f-71bf-8a9d-e624c3d33b08-€19.00€0.00matched
96capture01a1abf7-aaf7-7c3e-88a4-885ea4996f52€24.00€0.37matched
97capture01a1abf7-da3c-7b83-b495-256070ea957c€49.00€0.67matched
98capture01a1abf7-dabd-7d56-9dd7-c0e630986806€24.00€0.37matched
99capture01a1abf7-f9eb-7491-8836-309dfb309400€9.00€0.19matched
100capture01a1abf8-11f4-740e-bf77-aaab850b2d0b€15.00€0.26matched
101capture01a1abf8-2e9c-7675-8f97-73220328e428€15.00€0.26matched
102capture01a1abf8-40f5-75e5-8a58-b3359ad4492b€49.00€0.67matched
103capture01a1abf8-4377-7677-8db6-0dfce7d36588€15.00€0.26matched
104capture01a1abf8-74f3-79c4-80ae-80ac01ba3514€15.00€0.26matched
105capture01a1abf8-7895-7039-8841-67becdd32294€49.00€0.67matched
106capture01a1abf8-8cc7-789d-9c62-aa44c7634442€35.00€0.50matched
107capture01a1abf8-9c9f-7e94-bc0d-6a7cdc8eebd6€9.00€0.19matched
108capture01a1abf8-bbf6-70da-b4d6-a591fdefb33b€9.00€0.19matched
109capture01a1abf8-bd86-7a80-87cd-1b19191d626b€49.00€0.67matched
110capture01a1abf8-c1c7-77ff-9141-3b8597d09696€9.00€0.19matched
111capture01a1abf8-c1e9-7fbd-9830-4b8b91f14ac3€24.00€0.37matched
112capture01a1abf8-f2a8-71a1-96ad-61d79ba10fa4€35.00€0.50matched
113capture01a1abf9-01bb-70fb-b3f3-0c644fdc007c€35.00€0.50matched
114capture01a1abf9-1fa5-7fe7-8b3f-2ca88aa321fc€49.00€0.67matched