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, 20:30

Gross

€3,126.00

PSP fee

€51.62

Net to the bank

€3,074.38

Settlement journal

#367239

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • missing linein the books, not in the filecapture:01a1a31d-3439-736c-9a2a-f2b4dcd730fe is in no file
  • missing linein the books, not in the filecapture:01a1a322-b269-7dc4-b2ad-0aa6dbc57ea7 is in no file
LineKindReferenceGrossFeeStatus
17capture01a1a31b-818f-7c4c-a491-e81bf571e104€24.00€0.42fee difference
97capture01a1a320-8239-750f-98db-f309518676c9€9.00€0.20fee difference
1capture01a1a313-9055-7bef-8970-48b02207dace€35.00€0.50matched
2capture01a1a317-10f2-7cbf-99d7-8e24ffbcb53e€15.00€0.26matched
3capture01a1a318-456e-7b4e-bbf3-9f8797e40d95€15.00€0.26matched
4capture01a1a318-9567-72fb-b0cc-9d54abf71c27€15.00€0.26matched
5capture01a1a31a-c568-748e-be5b-558ce2dd51f4€49.00€0.67matched
6capture01a1a31a-c8ca-769b-86fa-39a22723bdc3€24.00€0.37matched
7capture01a1a31a-d771-7d8b-bc45-fee48412071f€35.00€0.50matched
8capture01a1a31a-e475-7abf-8ed0-49bb788d5ec9€35.00€0.50matched
9capture01a1a31a-d436-7d64-8a92-cb8dfa2466d2€35.00€0.50matched
10capture01a1a31a-e7b4-77a4-be36-44d182839e16€9.00€0.19matched
11capture01a1a31b-1870-79bc-a8f7-0061b6b28107€24.00€0.37matched
12capture01a1a31b-2ef3-7909-819f-1d0021f1e116€49.00€0.67matched
13capture01a1a31b-3282-7e22-8c42-e1de226a44b7€49.00€0.67matched
14capture01a1a31b-4664-77cd-8b02-c172a35a6c15€49.00€0.67matched
15refund01a1a31b-65d2-7d1d-8151-b4e722e39303-€18.00€0.00matched
16capture01a1a31b-77a0-7124-9578-09302efed986€24.00€0.37matched
18capture01a1a31b-83ac-751a-8d75-8864c3b0dc36€24.00€0.37matched
19capture01a1a31b-8cff-7ef1-8af1-58dae86994c1€15.00€0.26matched
20capture01a1a31b-a6e2-7467-8d8b-34628f65f092€49.00€0.67matched
21capture01a1a31b-a8c1-76f4-b5f2-fcbf9fa2995d€49.00€0.67matched
22capture01a1a31b-a8e0-76c1-bfd4-082ed3d9e356€49.00€0.67matched
23capture01a1a31b-dff2-757f-8f89-007eb0657e4d€35.00€0.50matched
24capture01a1a31b-e34f-72c7-ad85-bddd152805ba€49.00€0.67matched
25capture01a1a31b-f172-7d87-aeb6-f7d6f10bc6f3€24.00€0.37matched
26capture01a1a31b-f823-7bb7-a8d5-ea484aad5369€15.00€0.26matched
27capture01a1a31b-fe4b-7543-839e-df956e8923c6€24.00€0.37matched
28capture01a1a31c-14b0-7004-9d2c-a1143fed956b€9.00€0.19matched
29capture01a1a31c-31b8-7a9f-adfe-374af2a45e90€9.00€0.19matched
30capture01a1a31c-5801-7e85-bcfd-065a372894a6€15.00€0.26matched
31capture01a1a31c-6258-797d-95ff-a119649b030c€24.00€0.37matched
32capture01a1a31c-69ee-7d3a-87ab-c1a6aa8520d0€49.00€0.67matched
33capture01a1a31c-89e7-7060-bc90-dde7450095e4€35.00€0.50matched
34capture01a1a31c-98cc-72b5-bf11-39718a029448€24.00€0.37matched
35capture01a1a31c-a49f-799a-983a-d8643208f327€49.00€0.67matched
36capture01a1a31c-a9fc-73f1-b540-52f3fa9d20a0€49.00€0.67matched
37capture01a1a31c-aa58-7a11-b5c4-5a20779adc66€24.00€0.37matched
38capture01a1a31c-ba4e-7dfb-a13f-cb85549a88dd€15.00€0.26matched
39capture01a1a31c-f059-7892-b157-471bfa9023f6€24.00€0.37matched
40capture01a1a31d-09bf-7344-a4b2-03add2bcdc0f€9.00€0.19matched
41capture01a1a31d-0bdb-740f-9bd6-1ca9c50879c0€15.00€0.26matched
42capture01a1a31d-0c01-7337-bda6-f24e469da2e1€24.00€0.37matched
43capture01a1a31d-1ec2-7761-97c6-5251c574110b€24.00€0.37matched
44capture01a1a31d-22e1-7539-9dc8-8da12eb47a70€35.00€0.50matched
45capture01a1a31d-31eb-7072-88de-c9181b8280ac€49.00€0.67matched
46capture01a1a31d-32a7-72db-ab09-b008a7b7d4e3€15.00€0.26matched
47capture01a1a31d-3a50-7293-864b-3cb0fe2dbdf6€9.00€0.19matched
48capture01a1a31d-3b5a-7bd0-a58e-c6d09f953759€49.00€0.67matched
49capture01a1a31d-56b5-7736-a240-207393d4478e€9.00€0.19matched
50refund01a1a31d-6dbe-754d-a158-e37a44628c5e-€19.00€0.00matched
51refund01a1a31d-7cda-7425-b6bd-5df0adbe0b60-€14.00€0.00matched
52capture01a1a31d-98bc-7759-bac3-d426baaacf6f€15.00€0.26matched
53capture01a1a31d-b5b7-7fa7-937a-ab14c64f1055€15.00€0.26matched
54capture01a1a31d-c910-7bc7-9eed-4558c74be2c2€24.00€0.37matched
55capture01a1a31d-d5b4-7235-b14d-e7b66dafd6f6€49.00€0.67matched
56capture01a1a31d-de9f-7004-9678-c5644668728d€9.00€0.19matched
57capture01a1a31d-e2cf-72f9-aa73-31e1d4564e55€49.00€0.67matched
58capture01a1a31d-ed98-75ef-8264-e8ec5c483346€35.00€0.50matched
59capture01a1a31e-0d80-7cc4-b7f3-3d68a8fdfdbe€49.00€0.67matched
60refund01a1a31e-1510-7fae-b953-97da7252b6c0-€45.00€0.00matched
61capture01a1a31e-2330-7a14-bb3b-67094f7f0dfc€24.00€0.37matched
62capture01a1a31e-24b5-744a-b776-a7eb8100eb88€9.00€0.19matched
63capture01a1a31e-39b1-74ba-94cc-76d69cb4b06d€9.00€0.19matched
64capture01a1a31e-808e-73f5-bb90-1ebd78240fec€24.00€0.37matched
65capture01a1a31e-9fed-714d-8e7e-59f9a5e34ded€9.00€0.19matched
66capture01a1a31e-a979-7ce3-aa5e-21c46a69fcae€24.00€0.37matched
67capture01a1a31e-c384-7fe2-9d0f-f507c6f2635d€24.00€0.37matched
68capture01a1a31e-d66d-72fb-8e7c-57a035a76025€24.00€0.37matched
69capture01a1a31e-ecfe-7890-81c7-a89f03e15967€9.00€0.19matched
70capture01a1a31e-efb2-7c46-bdf7-1b3fc48c1597€24.00€0.37matched
71capture01a1a31e-fa66-7d2d-9600-f39a34d9cdb0€24.00€0.37matched
72capture01a1a31f-1974-7293-b694-dc18b61a88eb€15.00€0.26matched
73capture01a1a31f-318e-72b8-ab48-9cc8d25041b8€15.00€0.26matched
74capture01a1a31f-358f-7d60-ada9-a1208bdb7c2f€24.00€0.37matched
75capture01a1a31f-40bf-7feb-a8eb-2e17dcca7255€24.00€0.37matched
76capture01a1a31f-49d7-7e60-9207-85799fd659fd€15.00€0.26matched
77capture01a1a31f-59d1-7904-a288-17ff09567d8d€49.00€0.67matched
78capture01a1a31f-6145-7a76-939a-3e890685fd7b€49.00€0.67matched
79capture01a1a31f-6a26-79a5-af95-35ba482bb75f€49.00€0.67matched
80capture01a1a31f-6cf0-7bf8-91ba-08f04aecfb8d€15.00€0.26matched
81capture01a1a31f-7036-7911-881a-15249f2e7b59€15.00€0.26matched
82capture01a1a31f-7567-7dee-98c2-dbcccce3cdfe€9.00€0.19matched
83refund01a1a31f-9c0b-7d97-a8cd-bcaaa52084cd-€45.00€0.00matched
84refund01a1a31f-c8ba-7f9d-8005-6b2e2a12966a-€10.00€0.00matched
85capture01a1a31f-f63f-7727-9da6-e4d4fdf63a9e€15.00€0.26matched
86capture01a1a31f-fa9c-7f60-ad09-c35491b7257e€49.00€0.67matched
87capture01a1a31f-fc3f-72a5-b7bf-a82b7616f440€24.00€0.37matched
88capture01a1a320-00eb-72c6-9b5f-132a902ac4cb€15.00€0.26matched
89capture01a1a320-0c98-71ff-bd13-3daf1ff3d03a€15.00€0.26matched
90capture01a1a320-21cf-7a75-8255-5989d724373d€35.00€0.50matched
91capture01a1a320-24be-7d6a-9f8b-5b6e537ff813€35.00€0.50matched
92capture01a1a320-4afe-7db3-855e-e3adb1ab73b0€35.00€0.50matched
93refund01a1a320-56b8-7838-94fe-179b829832a1-€29.00€0.00matched
94capture01a1a320-5ffc-7581-befd-fe94a13fc5b0€49.00€0.67matched
95capture01a1a320-7d80-7047-835f-7120042847fa€15.00€0.26matched
96refund01a1a320-81fb-769a-b2e7-80a3fc45aa52-€15.00€0.00matched
98capture01a1a320-916e-7ea2-b139-4e8b8d889e69€35.00€0.50matched
99capture01a1a320-a02a-7670-9dfc-1881d66875a3€9.00€0.19matched
100capture01a1a320-ac30-73ab-80f0-5c6886486b9c€9.00€0.19matched
101capture01a1a320-b3c6-7c9b-91ab-517b28361ecf€9.00€0.19matched
102capture01a1a320-ce52-7fa7-a412-5cd3901deb6e€9.00€0.19matched
103refund01a1a320-d204-7227-8f21-6de3e0a4808a-€6.00€0.00matched
104capture01a1a320-e0de-7342-a365-60a2284dfacb€24.00€0.37matched
105refund01a1a321-0b04-710d-b833-636b18243b4f-€21.00€0.00matched
106capture01a1a321-126c-71dd-b983-94541ad4aa9f€49.00€0.67matched
107capture01a1a321-1a0c-7d3a-be8d-e65a31b6e00c€15.00€0.26matched
108capture01a1a321-263d-7f6a-94d4-3925b6f2aede€15.00€0.26matched
109capture01a1a321-2bf9-73d6-88be-5876c4f83ab0€15.00€0.26matched
110capture01a1a321-44ef-7632-a0f4-742a08dff58b€9.00€0.19matched
111refund01a1a321-5b34-78c4-b4b4-01f6ac514581-€15.00€0.00matched
112capture01a1a321-6b81-76a4-bcb2-1c10f1e23be7€9.00€0.19matched
113capture01a1a321-7f44-71f4-8f69-536652d2e79c€15.00€0.26matched
114capture01a1a321-98d3-765f-ad99-3f3400567b16€15.00€0.26matched
115capture01a1a321-b000-77ba-8aa9-fc1a7ff46871€9.00€0.19matched
116capture01a1a321-b98a-7e95-a311-0c224bda2726€9.00€0.19matched
117capture01a1a321-cb15-73ad-bae1-4c537f6405e0€15.00€0.26matched
118capture01a1a321-d1bf-719a-942b-7250fe3f7ab2€24.00€0.37matched
119capture01a1a321-d40a-7b6e-b4ac-48e6fcbcd3ff€9.00€0.19matched
120capture01a1a321-ef92-73c0-986b-490ac5c5501a€9.00€0.19matched
121capture01a1a321-f99c-7a06-aab1-6326e903583c€15.00€0.26matched
122capture01a1a321-f9ba-7ed3-bc89-9774ff5def6e€9.00€0.19matched
123capture01a1a321-fddf-7270-9fa3-beab6c215006€35.00€0.50matched
124capture01a1a322-0b19-7c10-ae00-128461c31595€35.00€0.50matched
125capture01a1a322-17d4-736a-8342-a866686d5375€24.00€0.37matched
126capture01a1a322-1e0d-72de-8ce1-6c821e817c4c€24.00€0.37matched
127capture01a1a322-48fd-7f47-bb67-4f7698578d28€35.00€0.50matched
128capture01a1a322-58f4-7d7c-b752-79b7c86dfc85€9.00€0.19matched
129capture01a1a322-6e2a-7051-9473-3e4d315947ad€35.00€0.50matched
130refund01a1a322-b18c-7081-8072-688c299d8b6a-€26.00€0.00matched
131capture01a1a322-b649-7500-bf07-8ae37ef82238€9.00€0.19matched
132capture01a1a322-c3e2-7162-9b13-8886934477c0€24.00€0.37matched
133capture01a1a322-cfbd-7875-8c48-b4cebbd5621a€35.00€0.50matched
134capture01a1a323-06c6-72b4-807c-2578b63add12€49.00€0.67matched
135capture01a1a323-49c3-7a91-bc3a-51b6cbe3ca2d€35.00€0.50matched
136capture01a1a323-4dd4-719f-b573-285da6fefd98€49.00€0.67matched
137capture01a1a323-55fe-7070-81ea-8a2a245aeae0€15.00€0.26matched
138capture01a1a323-61d0-70a7-bf85-84165a65a868€35.00€0.50matched
139refund01a1a323-6ceb-7534-bfa3-f33d31c800d1-€7.00€0.00matched
140capture01a1a323-6fde-7d61-b0ef-e4c197111906€35.00€0.50matched
141capture01a1a323-7a88-754c-91ea-7cbc92d2c572€24.00€0.37matched
142capture01a1a323-91b8-7587-91dd-7da4998741b9€15.00€0.26matched
143capture01a1a323-a364-7f4c-9f01-0c2afab81b01€24.00€0.37matched
144capture01a1a323-c0b4-75e9-b576-578a436e43bd€49.00€0.67matched
145capture01a1a323-cae4-778e-a2d6-a6f90e4b131c€9.00€0.19matched
146capture01a1a323-d17c-76c0-9a33-b7c33b42ce8b€49.00€0.67matched