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

Gross

€2,097.00

PSP fee

€33.00

Net to the bank

€2,064.00

Settlement journal

#406073

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae1d-fe77-715a-8cfe-54a3a7487b93 is already settled by stl_EUR_2989870 line 91
  • missing linein the books, not in the filecapture:01a1ae16-02ec-7e8c-9b08-c10a4075f459 is in no file
  • missing linein the books, not in the filecapture:01a1ae18-2eeb-7d2d-8dda-812923048a1b is in no file
LineKindReferenceGrossFeeStatus
92capture01a1ae1d-fe8d-7531-82a8-57298c8e6eb5€15.00€0.26duplicate line
1refund01a1ae0d-b5c3-70f1-8dbc-1a1c4f3cabe1-€3.00€0.00matched
2capture01a1ae15-7039-7bbc-a57b-396d26f9fbf6€35.00€0.50matched
3capture01a1ae15-83bc-786e-936c-0c402865dda3€24.00€0.37matched
4capture01a1ae15-b066-76b6-8e4e-44cfd0ec8c76€35.00€0.50matched
5capture01a1ae15-b8c5-7914-8785-855b124fa59b€24.00€0.37matched
6capture01a1ae16-1d11-73f0-a2f1-c522ea252edf€24.00€0.37matched
7capture01a1ae16-8079-7588-9d60-6d3c2e436f0c€15.00€0.26matched
8capture01a1ae16-9cce-71fc-a9fe-2a013a45447e€35.00€0.50matched
9capture01a1ae16-be41-7d12-807e-5a106e3a52ce€9.00€0.19matched
10capture01a1ae16-dd0b-777a-bcd5-5fbac3dabe8f€49.00€0.67matched
11capture01a1ae16-e273-7489-a5d1-857662b2aa16€35.00€0.50matched
12capture01a1ae17-2ce8-74e5-9453-c3f6e5333738€9.00€0.19matched
13capture01a1ae17-43fb-7105-9e1e-d7ff6a96ea90€15.00€0.26matched
14capture01a1ae17-4cd7-7ed0-89bf-03b8824336af€24.00€0.37matched
15capture01a1ae17-51f7-7a4f-9c9b-755ee980ab18€15.00€0.26matched
16refund01a1ae17-6a22-7878-90c7-09ce51e8cd06-€5.00€0.00matched
17capture01a1ae17-7058-7e60-9e12-16f65f73fbab€9.00€0.19matched
18capture01a1ae17-8e81-79fc-bc5b-bb951a9d3e57€9.00€0.19matched
19capture01a1ae17-abec-7c7e-877c-1a2189858881€24.00€0.37matched
20capture01a1ae17-aca5-7a11-9ac6-4a4c04e82745€15.00€0.26matched
21capture01a1ae17-b3ae-7fa3-825c-e5435967162d€49.00€0.67matched
22capture01a1ae17-ba9f-705c-aec2-aba120425535€15.00€0.26matched
23capture01a1ae17-c7f1-7df5-b3e7-fad054ce04c2€9.00€0.19matched
24capture01a1ae17-e604-766d-b33c-1fcf18a5b3ea€35.00€0.50matched
25capture01a1ae18-08e3-75b0-b8e3-86cae59231a1€24.00€0.37matched
26capture01a1ae18-0973-73e2-886d-d306cf81bd7d€35.00€0.50matched
27capture01a1ae18-134b-7b3d-a60f-b408e664373a€15.00€0.26matched
28capture01a1ae18-234d-7386-afc0-ac7e1d6ce834€35.00€0.50matched
29capture01a1ae18-33c0-7465-b1ce-7598d6bb2642€24.00€0.37matched
30capture01a1ae18-5327-7b62-9df8-47d39640bd58€49.00€0.67matched
31capture01a1ae18-8589-7774-8bf9-1333e8ebab3b€49.00€0.67matched
32capture01a1ae18-a6d7-73d1-b60e-ef1e90ff5e6f€24.00€0.37matched
33capture01a1ae18-c3bd-77b9-980f-8baca3f77778€9.00€0.19matched
34capture01a1ae18-cf62-7b95-a076-096e6d27b852€35.00€0.50matched
35capture01a1ae18-e085-7002-8005-1a96235b8514€9.00€0.19matched
36capture01a1ae19-0f61-7860-b638-09f3134365fe€15.00€0.26matched
37capture01a1ae19-17e4-707b-9759-145fd1dc747a€35.00€0.50matched
38capture01a1ae19-29aa-7c87-840e-8a90e1ba2c32€35.00€0.50matched
39capture01a1ae19-51b7-73d8-8e1a-bb1972d80a0f€24.00€0.37matched
40capture01a1ae19-89f8-7fd4-bc25-149aa321b19b€35.00€0.50matched
41capture01a1ae19-8aee-7b4e-8399-6d9a5857398e€15.00€0.26matched
42capture01a1ae19-bc97-7904-84d5-3d601fe62c5a€15.00€0.26matched
43capture01a1ae19-caed-7c20-9438-2be24915708d€9.00€0.19matched
44capture01a1ae19-cbd4-7dd3-b261-b728fe58d939€24.00€0.37matched
45capture01a1ae19-d7bb-7993-8303-1f9117cc2dde€24.00€0.37matched
46refund01a1ae1a-1ca5-72c1-ac6c-bfbb49c16e05-€7.00€0.00matched
47capture01a1ae1a-265f-7287-a9de-6697413bff2e€24.00€0.37matched
48capture01a1ae1a-3343-7474-868d-ed255bc08780€49.00€0.67matched
49capture01a1ae1a-3dd9-76cf-b083-537055680f58€24.00€0.37matched
50capture01a1ae1a-4b6c-7354-b30b-12b068ca5bd1€9.00€0.19matched
51capture01a1ae1a-6e94-7444-997d-32a62f5fff83€35.00€0.50matched
52capture01a1ae1a-739a-7041-921a-9da8c9877848€49.00€0.67matched
53capture01a1ae1a-7df9-7aab-a6ba-4ce9ddd60ee4€35.00€0.50matched
54capture01a1ae1a-964b-79d1-968f-4061c737f63b€15.00€0.26matched
55capture01a1ae1a-b08f-7390-a599-f6d39bea6cc1€9.00€0.19matched
56capture01a1ae1a-bf29-769e-852a-421a8a220c64€15.00€0.26matched
57capture01a1ae1a-cc77-704d-98c2-6605751131c3€9.00€0.19matched
58capture01a1ae1a-cf68-75c8-9c72-b520f4d5ac99€35.00€0.50matched
59capture01a1ae1a-fe45-77ad-855d-65439487815c€15.00€0.26matched
60capture01a1ae1b-72a4-76c7-939c-5fc2713443c0€49.00€0.67matched
61capture01a1ae1b-88e1-72db-99e6-de417990a8e1€35.00€0.50matched
62capture01a1ae1b-8e53-7076-97be-adac94225a1e€9.00€0.19matched
63capture01a1ae1b-b62f-7dc3-8952-83e3b9b702e1€24.00€0.37matched
64capture01a1ae1b-e49e-7d66-b1e3-2b7876172903€9.00€0.19matched
65capture01a1ae1b-fbf4-76e1-8e48-b27e78809c4c€35.00€0.50matched
66capture01a1ae1c-608f-7317-878c-e499860fa380€24.00€0.37matched
67capture01a1ae1c-6db6-7886-bf18-b02a513367a3€15.00€0.26matched
68capture01a1ae1c-6ee9-7c62-a5a6-782386430d36€15.00€0.26matched
69capture01a1ae1c-828f-7834-8d8a-0fcfa38a3b42€35.00€0.50matched
70capture01a1ae1c-8757-77f8-96b6-fbb02efc5b11€15.00€0.26matched
71capture01a1ae1c-a65a-758f-9fed-421110187c50€9.00€0.19matched
72capture01a1ae1c-b6fe-7de7-8eec-845a7b788e1f€9.00€0.19matched
73capture01a1ae1c-cafe-70f6-91d3-b61b5df3a028€15.00€0.26matched
74capture01a1ae1c-fa1f-74e4-92d9-3d636e048835€24.00€0.37matched
75capture01a1ae1c-fc66-70f0-836f-bd2e02eaf074€9.00€0.19matched
76capture01a1ae1d-0a6d-7c20-9832-928d625ed3c1€15.00€0.26matched
77capture01a1ae1d-2b32-732f-bac8-c65e884517dc€15.00€0.26matched
78capture01a1ae1d-304e-7de0-b763-5843b0795055€15.00€0.26matched
79capture01a1ae1d-3988-7696-977b-e4ab497832f1€15.00€0.26matched
80capture01a1ae1d-4331-726a-a3e2-e7b03fc17ec3€9.00€0.19matched
81capture01a1ae1d-62cb-7769-99b3-fecc070fe993€35.00€0.50matched
82capture01a1ae1d-831f-7933-a6e1-f0cd9f0aa760€24.00€0.37matched
83capture01a1ae1d-859c-72ed-a031-46acbb157d59€49.00€0.67matched
84refund01a1ae1d-8f0d-77a0-9d63-d73ac884eca4-€13.00€0.00matched
85capture01a1ae1d-99c5-7e67-bc2a-95acda729b34€35.00€0.50matched
86capture01a1ae1d-ae1f-7188-bd2f-ee0efc7af2b9€15.00€0.26matched
87capture01a1ae1d-c0e3-750e-8afe-bec5f9286049€9.00€0.19matched
88capture01a1ae1d-d6b2-7a87-8cdd-e4485656c2ba€15.00€0.26matched
89capture01a1ae1d-ef0a-733e-abe7-9a6c6ce57777€15.00€0.26matched
90refund01a1ae1d-f706-755f-8347-98826f599e01-€4.00€0.00matched
91capture01a1ae1d-fe8d-7531-82a8-57298c8e6eb5€15.00€0.26matched
93capture01a1ae1e-3fa9-7882-9465-401126a3f174€24.00€0.37matched
94capture01a1ae1e-45a0-7193-bc91-749e57c83adf€49.00€0.67matched
95capture01a1ae1e-4b9e-7c6d-ae18-50d7e6685cd6€24.00€0.37matched
96capture01a1ae1e-57ee-71e7-97b0-d4ce861605d9€15.00€0.26matched
97capture01a1ae1e-7168-7037-986b-1c847dd7c6ce€15.00€0.26matched