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

Gross

€2,581.00

PSP fee

€40.41

Net to the bank

€2,540.59

Settlement journal

#387609

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • missing linein the books, not in the filecapture:01a1a8e3-1de7-7a36-83bc-dbf53ea32906 is in no file
  • missing linein the books, not in the filecapture:01a1a8df-65c5-7ccc-85a5-7b32cc197e4b is in no file
LineKindReferenceGrossFeeStatus
66capture01a1a8e1-ea01-761e-8f7b-535b2e03e0c9€35.00€0.52fee difference
1capture01a1a8d7-c80e-7483-9522-8eaa8e34e742€35.00€0.50matched
2capture01a1a8da-6366-76d4-a285-350bfc16bf27€35.00€0.50matched
3capture01a1a8dc-ee2f-7cc3-b7e5-9c6559765586€9.00€0.19matched
4capture01a1a8dd-1fb7-774e-b27c-ec33066962a4€24.00€0.37matched
5capture01a1a8dd-306c-75c5-b6de-150dc1579c31€9.00€0.19matched
6capture01a1a8dd-3599-72e2-a998-1b11b57e651e€15.00€0.26matched
7capture01a1a8dd-54d2-71ba-8872-6ae8b35dda5a€24.00€0.37matched
8capture01a1a8dd-6267-7745-be1b-555419cfba72€35.00€0.50matched
9capture01a1a8dd-6f21-7dd0-90fa-1d632109a2b7€49.00€0.67matched
10capture01a1a8dd-8076-7873-bf24-9b7137302393€24.00€0.37matched
11capture01a1a8dd-854d-70c4-9874-973e441ba04b€35.00€0.50matched
12capture01a1a8dd-9f23-748b-82d2-a4a770d99273€9.00€0.19matched
13capture01a1a8dd-b34b-7a13-9f48-edf90135d3e6€24.00€0.37matched
14capture01a1a8dd-b887-70d9-89d8-054000f79b62€9.00€0.19matched
15capture01a1a8dd-c17c-75cf-8f45-b257888d07d3€35.00€0.50matched
16capture01a1a8dd-e1a0-7d6d-a4fa-6bf854911a40€15.00€0.26matched
17capture01a1a8dd-cf70-7ee3-8ee2-9ece70299dc3€15.00€0.26matched
18capture01a1a8dd-f407-7b72-a91d-2dde28686fac€24.00€0.37matched
19capture01a1a8de-17e3-7528-888b-d3dbb63a583d€15.00€0.26matched
20capture01a1a8de-46a9-7e72-87af-d4b92afd38e5€35.00€0.50matched
21capture01a1a8de-4f97-7019-894c-98421b8432de€15.00€0.26matched
22capture01a1a8de-7c6c-73cb-b2f6-7007e7cedab0€49.00€0.67matched
23capture01a1a8de-a81e-7689-83e9-5b8c9e02952f€15.00€0.26matched
24capture01a1a8de-ac96-7ecc-bba9-2fe23b7a0244€49.00€0.67matched
25capture01a1a8de-ba81-7e2d-86f9-2d76bfdcbecf€24.00€0.37matched
26capture01a1a8de-bb0e-77cf-a9d2-c72c4a502ba2€9.00€0.19matched
27capture01a1a8de-c271-7e3e-8cfe-d6594003e148€49.00€0.67matched
28capture01a1a8de-db70-704a-8980-818a088d4d80€9.00€0.19matched
29capture01a1a8de-dea0-799d-9150-faeece3db23c€15.00€0.26matched
30capture01a1a8df-08b9-7534-be63-bbeb6faf935a€35.00€0.50matched
31capture01a1a8df-15e9-7390-8500-336427960e4e€15.00€0.26matched
32capture01a1a8df-6b4e-75e9-841a-337803244b80€49.00€0.67matched
33capture01a1a8df-9185-7f5d-afcf-49e56ae19c29€24.00€0.37matched
34refund01a1a8df-a041-770f-b55d-907b1e52d0fe-€9.00€0.00matched
35capture01a1a8df-bd73-758c-ab94-eb679fc7fe97€15.00€0.26matched
36capture01a1a8df-bfb3-764c-b4d3-982c2a190061€15.00€0.26matched
37refund01a1a8df-c3a4-7e28-97d0-397938d30bd0-€43.00€0.00matched
38capture01a1a8df-d147-7f71-8d5f-31c80b2f7f95€9.00€0.19matched
39refund01a1a8e0-1032-75d7-949e-cf7218d4e08c-€4.00€0.00matched
40capture01a1a8e0-26a3-7a4f-983f-08806cb168ed€15.00€0.26matched
41capture01a1a8e0-3785-72f6-a15f-b795b5cfc465€49.00€0.67matched
42capture01a1a8e0-3dd8-74e0-9063-ee5e09af8241€15.00€0.26matched
43capture01a1a8e0-5035-7048-b4fc-193eca60659a€9.00€0.19matched
44capture01a1a8e0-7363-72a8-be0f-b762a27a247d€15.00€0.26matched
45capture01a1a8e0-89c9-728f-a08d-0b589626ef80€49.00€0.67matched
46capture01a1a8e0-993f-74b4-8578-c11507f8d144€24.00€0.37matched
47capture01a1a8e0-d10c-71e5-9337-7c74a76f3d50€35.00€0.50matched
48capture01a1a8e0-effb-77ff-b882-b8b07de95f98€9.00€0.19matched
49capture01a1a8e0-f324-7eae-9214-560ac4944ca0€35.00€0.50matched
50capture01a1a8e0-f3f7-7620-9048-f82b3b518e17€15.00€0.26matched
51capture01a1a8e1-0000-7cbd-a993-17ae7646f731€15.00€0.26matched
52capture01a1a8e1-1cdb-71de-92ed-7df7abd9069a€9.00€0.19matched
53capture01a1a8e1-2732-7dc2-86e2-76a216052c97€24.00€0.37matched
54capture01a1a8e1-3e00-72ed-8802-05997d67a6b6€24.00€0.37matched
55capture01a1a8e1-6011-7e50-bcf2-fc35ea4644ba€35.00€0.50matched
56capture01a1a8e1-65f5-7719-9ebf-77be3290452e€9.00€0.19matched
57capture01a1a8e1-6885-7459-ade8-244ced9bed33€15.00€0.26matched
58capture01a1a8e1-69e4-7170-a17e-9c6a648bbe00€49.00€0.67matched
59capture01a1a8e1-6dae-7326-b9c5-fc37ba9de7b4€15.00€0.26matched
60capture01a1a8e1-8844-7e2e-aacc-fffa746a1b5f€35.00€0.50matched
61capture01a1a8e1-8ce8-7307-89e9-a3ec91fdc5c7€9.00€0.19matched
62capture01a1a8e1-a4d1-7294-8f7c-1c38665a428f€35.00€0.50matched
63capture01a1a8e1-c4d4-74c8-a7fb-4596d41f67ac€24.00€0.37matched
64capture01a1a8e1-d226-7219-b63d-c1d124cebbb7€24.00€0.37matched
65capture01a1a8e1-e0b1-7493-ad6c-8cea1c2407cd€9.00€0.19matched
67capture01a1a8e2-1bde-7bf1-a29a-a3823bd39924€15.00€0.26matched
68capture01a1a8e2-43f1-7c3d-a737-a81a4d826bbc€9.00€0.19matched
69capture01a1a8e2-4d4c-728f-a7f8-e65582dbd054€24.00€0.37matched
70capture01a1a8e2-5360-7503-8f94-0da700b82af5€35.00€0.50matched
71capture01a1a8e2-a341-78a5-9f7f-7bd9a643995c€9.00€0.19matched
72capture01a1a8e2-c03e-7409-aebb-a0c841f34894€35.00€0.50matched
73capture01a1a8e2-c879-7906-8df7-0de6fbba4c4e€49.00€0.67matched
74capture01a1a8e2-ea41-7b09-9b0b-76de181c36bf€9.00€0.19matched
75capture01a1a8e3-00f3-7274-8ae7-24052dd89d9c€9.00€0.19matched
76capture01a1a8e3-4160-7a37-8bd4-d9527592c8ae€15.00€0.26matched
77capture01a1a8e3-5958-7003-97d0-606b32ecb7f2€15.00€0.26matched
78capture01a1a8e3-6105-70f4-a4ab-0647871aed35€49.00€0.67matched
79capture01a1a8e3-64e5-72d1-b8a0-ce82ca8501f6€49.00€0.67matched
80capture01a1a8e3-6e97-7954-ab58-9e3d0c8453d9€35.00€0.50matched
81capture01a1a8e3-a50f-7a2c-9d1d-d359534b6f57€49.00€0.67matched
82capture01a1a8e3-bb69-7dbb-94b0-58e2d32e887b€49.00€0.67matched
83refund01a1a8e3-bf3d-7c3d-89f7-328820f4d0e7-€22.00€0.00matched
84capture01a1a8e3-cd17-7dc2-8a8b-564550a50f77€49.00€0.67matched
85capture01a1a8e3-dc0b-720d-82ea-8d1048e8e052€15.00€0.26matched
86capture01a1a8e3-eaa2-7873-8bfc-dfcbc4d8c8ed€49.00€0.67matched
87capture01a1a8e3-fa4f-74cb-8ed9-32e1a70f8ce6€24.00€0.37matched
88refund01a1a8e4-119e-7878-8790-e79bf209bf30-€6.00€0.00matched
89capture01a1a8e4-2555-7dff-8529-8850f9fd6532€35.00€0.50matched
90capture01a1a8e4-31fd-7c8e-a89b-c45895702a85€15.00€0.26matched
91capture01a1a8e4-4d00-7fef-8cf1-2d74e4d858c7€35.00€0.50matched
92capture01a1a8e4-5587-79c3-b3d8-a35f1b9046d7€9.00€0.19matched
93capture01a1a8e4-7da1-7b88-8f58-069ed7fd7b50€35.00€0.50matched
94capture01a1a8e4-829b-7467-87fa-abd0464db772€49.00€0.67matched
95capture01a1a8e4-923a-7743-8433-9490d133e292€15.00€0.26matched
96capture01a1a8e4-9ce6-7325-8a69-2ad16aa08ad6€49.00€0.67matched
97capture01a1a8e4-bca6-78f3-b399-4e68add4b844€24.00€0.37matched
98capture01a1a8e4-cb50-78f5-8d6f-800958000100€9.00€0.19matched
99capture01a1a8e4-e3aa-74d8-8c9b-523640941793€35.00€0.50matched
100capture01a1a8e4-e99f-7070-b2ee-591203927744€15.00€0.26matched
101capture01a1a8e5-0de3-7701-95a8-db9131d55c7e€35.00€0.50matched
102refund01a1a8e5-32d2-7c59-92b0-01efa98aaa99-€5.00€0.00matched
103capture01a1a8e5-3cb0-7326-b1c4-cb9ec76598c0€35.00€0.50matched
104capture01a1a8e5-679f-7479-8e46-675e90d18e02€35.00€0.50matched
105capture01a1a8e5-88e5-7f95-a386-b7ce396158a9€35.00€0.50matched
106capture01a1a8e5-9eea-76d2-b404-30ab8b7a821d€24.00€0.37matched
107capture01a1a8e5-ac70-75ac-9f7e-e0238af96a90€24.00€0.37matched
108capture01a1a8e5-b755-7ca4-b7a2-6af09fd22bf4€49.00€0.67matched
109capture01a1a8e5-d20b-739f-9266-edc46eb563ee€9.00€0.19matched