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

4 Nov, 11:40

Gross

€3,353.00

PSP fee

€52.36

Net to the bank

€3,300.64

Settlement journal

#378691

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
81capture01a1a660-c077-7487-9c8d-71921b8bf96b€24.00€0.39fee difference
135capture01a1a664-99f1-7728-be35-74101967d1b1€49.00€0.70fee difference
1capture01a1a658-4709-7709-a3ba-2d3b199292df€9.00€0.19matched
2refund01a1a65b-e2eb-7a8a-8302-ea1aea48acc8-€10.00€0.00matched
3capture01a1a65c-004c-7620-80e1-10f0172bb34d€49.00€0.67matched
4capture01a1a65c-04ae-775e-b309-5062d0388815€35.00€0.50matched
5capture01a1a65c-1a12-7695-8465-0c6129f30437€24.00€0.37matched
6capture01a1a65c-2909-7c0e-9cbd-9c83eccd361c€49.00€0.67matched
7capture01a1a65c-3f92-7d77-b622-8686cf7bab4c€35.00€0.50matched
8capture01a1a65c-63d0-7398-99bb-62aba78f7de0€15.00€0.26matched
9capture01a1a65c-6faa-7e3b-9884-018d246c4e99€15.00€0.26matched
10refund01a1a65c-70d3-7e29-a23c-9e3c30691c60-€23.00€0.00matched
11capture01a1a65c-723f-7630-80d1-098e9095402b€15.00€0.26matched
12capture01a1a65c-821d-76f3-bbe3-8ad7425af1b8€9.00€0.19matched
13capture01a1a65c-84d1-7159-af9a-13a0cb6f65e0€15.00€0.26matched
14capture01a1a65c-9965-786a-a29b-304279f31aaf€24.00€0.37matched
15capture01a1a65c-99a5-7db0-917d-341be69dbeef€49.00€0.67matched
16capture01a1a65c-b9fb-7021-8cad-d319c9b18e48€35.00€0.50matched
17capture01a1a65c-c298-75ee-8348-a3e65b7930cf€35.00€0.50matched
18capture01a1a65c-cb54-765d-8ee9-1ce126b6ff35€49.00€0.67matched
19capture01a1a65c-cd88-787c-aed1-7d84bd7f9ecd€35.00€0.50matched
20capture01a1a65c-d82a-7033-80b8-60d441850573€24.00€0.37matched
21capture01a1a65c-dda0-72e3-88c3-57276c8c8930€9.00€0.19matched
22capture01a1a65c-f2ad-712a-abc9-565330893352€24.00€0.37matched
23capture01a1a65c-f497-7c4b-9ddd-6f9bb53e0bcd€15.00€0.26matched
24capture01a1a65d-1060-71a9-8320-83f2505f2e2e€24.00€0.37matched
25capture01a1a65d-11f5-7855-85ab-7392d2d7ba5a€9.00€0.19matched
26capture01a1a65d-12f3-701b-bd99-9d096a07932f€9.00€0.19matched
27capture01a1a65d-1a47-72ad-af8a-599c23d2fc99€35.00€0.50matched
28capture01a1a65d-470a-7956-a5e7-9eaae60cb87e€15.00€0.26matched
29capture01a1a65d-4ac1-721a-9d54-96b744b7382e€24.00€0.37matched
30capture01a1a65d-4c25-7347-886a-f6e4cdd6375d€35.00€0.50matched
31capture01a1a65d-523c-77ff-a0fd-ef636ad87e2c€49.00€0.67matched
32capture01a1a65d-6fca-72ee-8d46-0d744c0dbde8€9.00€0.19matched
33capture01a1a65d-aaab-74da-babc-b21c94f3fae5€35.00€0.50matched
34capture01a1a65d-bbac-7943-9208-102afff105fc€35.00€0.50matched
35capture01a1a65d-bd53-7a0d-a063-146d18123ae6€9.00€0.19matched
36capture01a1a65d-d14f-7117-b225-3e5d9801a5dc€24.00€0.37matched
37capture01a1a65d-ea55-71fb-83ad-6cb7867e4877€9.00€0.19matched
38capture01a1a65d-f355-7ab4-b2f6-8d9dc0529ae0€35.00€0.50matched
39capture01a1a65e-0f9c-7863-a84d-19f5b7836d89€35.00€0.50matched
40capture01a1a65e-0d56-732a-9b9a-9fb44a19ca82€49.00€0.67matched
41refund01a1a65e-3d67-75c9-8064-5e9036d9777c-€7.00€0.00matched
42capture01a1a65e-6873-797f-8f9a-76ff32d57be0€35.00€0.50matched
43capture01a1a65e-6e8c-7427-a565-f3cceb6d0b5c€9.00€0.19matched
44capture01a1a65e-71d4-7e92-9e46-de0fbe41d53c€15.00€0.26matched
45capture01a1a65e-9774-7724-9d55-f5c0078ebbb3€24.00€0.37matched
46capture01a1a65e-affe-7dba-af2c-8822a9c4ca1e€9.00€0.19matched
47capture01a1a65e-daa6-7291-96be-4d9ab0ae645b€35.00€0.50matched
48capture01a1a65e-dddf-72e9-9a64-43013656f8be€49.00€0.67matched
49capture01a1a65e-e6d3-7880-b613-83ce9d369f90€9.00€0.19matched
50capture01a1a65e-e713-7238-b0fd-1bdd355b545d€9.00€0.19matched
51capture01a1a65e-e9ff-725b-8022-affecda2e5a4€24.00€0.37matched
52refund01a1a65e-fc3c-7203-bde5-0cb2839c5081-€5.00€0.00matched
53capture01a1a65e-fd12-7139-a7fd-d01b12a45fcd€15.00€0.26matched
54capture01a1a65f-0408-76f2-9abe-7341c26fdd39€49.00€0.67matched
55capture01a1a65f-1ae5-7ca7-9330-1cae56136221€15.00€0.26matched
56capture01a1a65f-273d-77ed-83d8-e6c807252397€9.00€0.19matched
57capture01a1a65f-2a24-717f-8bef-f5c6f9add793€49.00€0.67matched
58capture01a1a65f-2c7d-7352-b450-195c131b6058€49.00€0.67matched
59capture01a1a65f-4412-7daa-b40f-9382127d8dee€35.00€0.50matched
60capture01a1a65f-81d9-7c20-abdd-de6bdb61c826€35.00€0.50matched
61capture01a1a65f-9a78-76ea-943b-4c7939873038€9.00€0.19matched
62capture01a1a65f-c6eb-75b5-b10c-65c794b9a295€15.00€0.26matched
63capture01a1a65f-d14d-7d38-9d3e-a2bfec99c31e€35.00€0.50matched
64capture01a1a65f-d32f-7cf8-a020-21514fdbffa3€24.00€0.37matched
65capture01a1a65f-e801-7711-af62-d3070d2698a8€49.00€0.67matched
66capture01a1a65f-f35f-76be-9b30-88052f3b7df7€49.00€0.67matched
67capture01a1a65f-f3a0-77d9-a26b-610a8115c604€49.00€0.67matched
68capture01a1a660-05cd-759d-aa7f-e42404a4b96a€35.00€0.50matched
69refund01a1a660-1fa4-7f38-87f2-9f13a232ef45-€15.00€0.00matched
70capture01a1a660-324c-7247-b27d-48ead3399210€15.00€0.26matched
71capture01a1a660-3378-7b23-8700-7d71dd021fb3€35.00€0.50matched
72capture01a1a660-34ef-7f3f-b4f2-13c1cd10215c€49.00€0.67matched
73capture01a1a660-41eb-74b3-9c67-246a12857d28€24.00€0.37matched
74capture01a1a660-4c9e-7d6b-ad3a-277120598bf5€15.00€0.26matched
75capture01a1a660-5a4d-73b6-a12d-d66ee019d0ae€9.00€0.19matched
76capture01a1a660-7304-7646-b3c5-4fe6331463ab€35.00€0.50matched
77refund01a1a660-7db6-76a9-98a9-3cdfc50e7c02-€18.00€0.00matched
78capture01a1a660-8a13-74c4-89a2-e50b3c1f19f1€49.00€0.67matched
79capture01a1a660-adde-7eed-a85a-01f13ed0ba43€49.00€0.67matched
80capture01a1a660-c70c-700f-9726-cc2a3398248c€24.00€0.37matched
82capture01a1a660-d060-7679-a808-c62be4f93cf0€9.00€0.19matched
83capture01a1a660-daf2-7e7e-82f5-8bbbbdaeca24€24.00€0.37matched
84capture01a1a661-3df5-782c-93c5-8b2240d81ab0€49.00€0.67matched
85capture01a1a661-59fa-73b0-a4fe-dc604c2ca241€15.00€0.26matched
86capture01a1a661-62b6-7f0e-8780-0bd78e380be8€9.00€0.19matched
87capture01a1a661-6868-71c0-9a22-4dc67f3ff380€35.00€0.50matched
88capture01a1a661-6dd3-7cb4-97dc-bf4e5aee1c32€24.00€0.37matched
89capture01a1a661-9041-73bd-9f08-f4942d0ad7b5€24.00€0.37matched
90capture01a1a661-a359-7e67-be00-a6f6105147e1€35.00€0.50matched
91capture01a1a661-b6b4-71ae-a407-7331cb798b95€15.00€0.26matched
92capture01a1a661-b703-7d4e-910d-4e717f804405€35.00€0.50matched
93capture01a1a661-e4e3-7545-9027-5c17df463bfc€9.00€0.19matched
94capture01a1a661-faa5-7e15-8b81-b3de41b1b868€24.00€0.37matched
95capture01a1a662-1902-7cf0-8ea9-210e9c5990e6€35.00€0.50matched
96capture01a1a662-1ea3-71c5-b381-486c85ebce50€9.00€0.19matched
97capture01a1a662-7f8a-79f9-aa0d-ad9df52d4286€49.00€0.67matched
98capture01a1a662-85e7-7f77-b0f8-e7f838cbce61€9.00€0.19matched
99capture01a1a662-bcdc-7502-b6e3-57177c5f0f58€49.00€0.67matched
100capture01a1a662-bdca-7eb2-9753-0a74f32f922d€15.00€0.26matched
101capture01a1a662-c97f-7496-8ffa-4034fc622255€35.00€0.50matched
102capture01a1a662-ce63-7808-8fb5-7d229a5d1417€49.00€0.67matched
103capture01a1a662-d339-7abb-b3fc-0262e318361a€24.00€0.37matched
104capture01a1a662-db7f-76d3-b172-9c60b87ba3a7€9.00€0.19matched
105capture01a1a662-ed74-72b8-8039-26173b8d7d7d€9.00€0.19matched
106capture01a1a663-03d8-7beb-a714-395152ecdd6d€24.00€0.37matched
107capture01a1a663-10e1-7e76-be52-e72760e58105€49.00€0.67matched
108capture01a1a663-1b9a-7639-a47e-e9f8eb7fcf17€49.00€0.67matched
109refund01a1a663-31c1-7654-a25e-fb23c8ea5a23-€8.00€0.00matched
110capture01a1a663-4fe3-7a84-8885-a395733ea90b€24.00€0.37matched
111capture01a1a663-523f-7cea-a8ad-a086c237d330€15.00€0.26matched
112refund01a1a663-69c7-7b8f-b052-8a55110b6325-€23.00€0.00matched
113capture01a1a663-7a46-7280-9ee3-96e7fe0e7f83€24.00€0.37matched
114capture01a1a663-7f14-7218-ac46-03e79d4208ca€9.00€0.19matched
115capture01a1a663-9438-7a22-941c-9be057fef6e9€35.00€0.50matched
116capture01a1a663-9b9d-7abf-857b-d525a76e47d4€35.00€0.50matched
117capture01a1a663-a753-78c0-bbf7-3205293c513e€15.00€0.26matched
118capture01a1a663-abfe-79ab-9ba0-cd20a93504cb€24.00€0.37matched
119capture01a1a663-bf59-7429-bb95-772e0507f6fd€15.00€0.26matched
120capture01a1a663-cdd3-741e-8bcd-d8c544d16c58€24.00€0.37matched
121refund01a1a663-d599-71d3-be5a-25e299b23b2c-€6.00€0.00matched
122capture01a1a663-d60f-708a-869e-80a643e1f58b€15.00€0.26matched
123capture01a1a663-f409-78ef-a9d5-e9850767789c€49.00€0.67matched
124capture01a1a664-1d5f-7929-b867-507e170412d4€15.00€0.26matched
125capture01a1a664-238f-716b-91dc-6d8ac0928d9d€24.00€0.37matched
126capture01a1a664-3747-723d-93ed-55678d396f33€9.00€0.19matched
127capture01a1a664-576f-7d25-870a-89b71ab2295f€49.00€0.67matched
128capture01a1a664-5e9c-767a-ae80-909f25f7e082€15.00€0.26matched
129capture01a1a664-6b72-7bfa-b023-abb2868e34c6€49.00€0.67matched
130capture01a1a664-6d1a-7719-b4db-0047ac5dfb82€24.00€0.37matched
131capture01a1a664-703a-7d04-a2a6-3a7e030c2bbc€35.00€0.50matched
132capture01a1a664-7992-71d4-b7f6-609f6f23a642€49.00€0.67matched
133capture01a1a664-91df-770c-be24-5929dd638c33€15.00€0.26matched
134capture01a1a664-95d5-717e-8d9a-6d8ff22732c5€15.00€0.26matched
136refund01a1a664-9fec-72e9-8bda-c17086a83147-€10.00€0.00matched
137capture01a1a664-b8e6-72e9-aca6-e464a605087d€15.00€0.26matched
138refund01a1a664-bef8-7e0d-bbc4-c731ddb68f34-€15.00€0.00matched
139capture01a1a664-d783-7587-8d22-ae19c02d11b8€49.00€0.67matched