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

7 Nov, 13:50

Gross

€2,784.00

PSP fee

€44.23

Net to the bank

€2,739.77

Settlement journal

#435531

Breaks for a person to look at

  • missing linein the books, not in the filerefund:01a1b646-343f-7bdb-acc5-8375ffa1013e is in no file
  • missing linein the books, not in the filecapture:01a1b64a-8788-764c-ae96-c7763537491a is in no file
LineKindReferenceGrossFeeStatus
1capture01a1b641-babd-7bed-8d2c-77ee425ba6bf€15.00€0.26matched
2capture01a1b645-8a08-7f62-8219-ddf181654243€35.00€0.50matched
3refund01a1b645-fc81-711a-9cd2-42f74d96c1fa-€32.00€0.00matched
4capture01a1b646-2407-76ce-9b94-b08b89c2aea0€24.00€0.37matched
5capture01a1b646-339c-752e-ade4-daaaa65c337d€15.00€0.26matched
6capture01a1b646-3838-753c-9d9f-d2e971352232€49.00€0.67matched
7capture01a1b646-6472-7f9a-a454-45e85fa45a66€15.00€0.26matched
8capture01a1b646-669c-780c-bc50-3a6b2ab7ad4f€15.00€0.26matched
9capture01a1b646-6d32-7bd2-b1d4-a5a7a37b0ebe€35.00€0.50matched
10capture01a1b646-7a11-7722-9775-15988010bb68€9.00€0.19matched
11capture01a1b646-8636-787c-a991-22ce257b9f93€49.00€0.67matched
12capture01a1b646-95c4-703b-9b05-8ae2510fdab4€9.00€0.19matched
13refund01a1b646-a8eb-79dd-aaad-4a111becf49f-€20.00€0.00matched
14capture01a1b646-ac92-747b-87a1-8db043319350€9.00€0.19matched
15capture01a1b646-aeba-7e59-b435-17d936e4ee3f€9.00€0.19matched
16capture01a1b646-b36a-7a06-9afe-732586f86b5b€35.00€0.50matched
17capture01a1b646-dfb6-7cb3-871e-27db0a97aac8€9.00€0.19matched
18capture01a1b646-eb37-7777-aba1-b6401d7fe881€24.00€0.37matched
19capture01a1b646-ef73-7763-a3d6-d2e55e0b52f3€24.00€0.37matched
20capture01a1b646-f9c2-7e23-ab56-91068e638ccc€35.00€0.50matched
21capture01a1b647-15d3-7037-9f7a-c4700a17171a€15.00€0.26matched
22capture01a1b647-4046-7c10-abf7-f55e12869f42€24.00€0.37matched
23capture01a1b647-4143-77be-88e1-e7127ed4e9ba€35.00€0.50matched
24capture01a1b647-6867-703f-b78f-33967e0c2c42€24.00€0.37matched
25capture01a1b647-7753-755e-9fa9-7157c98352c9€35.00€0.50matched
26capture01a1b647-7e91-74bf-9628-3aeff15187d8€49.00€0.67matched
27capture01a1b647-914e-795c-8f6b-acca8204d834€9.00€0.19matched
28capture01a1b647-a34b-7239-a056-07e34d8c08e4€35.00€0.50matched
29capture01a1b647-a4d6-7ff5-8f82-f929aad1973f€15.00€0.26matched
30capture01a1b647-b99b-7d40-96ca-ca4ab0fdd097€49.00€0.67matched
31capture01a1b647-c068-7a32-9f48-46154f8d9340€9.00€0.19matched
32capture01a1b647-c673-7d7e-a6a7-1ba63aa04e83€49.00€0.67matched
33capture01a1b647-b008-74f6-a199-0490a90bf609€49.00€0.67matched
34capture01a1b647-d2d4-7881-be4f-1c31de7e209e€9.00€0.19matched
35capture01a1b647-d50e-7856-ba26-d8724cd62049€24.00€0.37matched
36capture01a1b647-e7e1-7a5d-8bba-27f5b023f609€15.00€0.26matched
37capture01a1b648-037c-7ba7-9033-84240e456851€24.00€0.37matched
38capture01a1b648-04d3-7a46-bbeb-67da6adaca81€49.00€0.67matched
39capture01a1b648-13b9-7b11-8a0f-a9e64d073adc€9.00€0.19matched
40refund01a1b648-14d1-7580-8a31-7ce634bb96d4-€24.00€0.00matched
41capture01a1b648-4c8c-721f-9ef0-0f0b9572fe7a€15.00€0.26matched
42capture01a1b648-831d-77fc-a23f-09fa9ef29460€35.00€0.50matched
43capture01a1b648-97d0-7be1-95cd-3e293710abfe€15.00€0.26matched
44capture01a1b648-db7c-773f-bc36-849d7a36e2c8€49.00€0.67matched
45capture01a1b648-df7a-7db0-9613-7652594b2179€49.00€0.67matched
46capture01a1b648-e581-7459-b38a-cdbb7b8c89a7€24.00€0.37matched
47capture01a1b648-fbee-781e-b772-c2de989792fd€9.00€0.19matched
48capture01a1b649-2cda-70d1-98b5-3cc8a30608c5€15.00€0.26matched
49capture01a1b649-4bee-7156-b220-385e8ee54123€24.00€0.37matched
50capture01a1b649-4dd2-76eb-8d68-c781f839e724€15.00€0.26matched
51capture01a1b649-6e83-7628-add6-866996eef1d7€35.00€0.50matched
52capture01a1b649-9c00-7983-b39f-2ec4f4cd3768€35.00€0.50matched
53capture01a1b649-9dd8-774d-add0-a7f7807be328€24.00€0.37matched
54capture01a1b649-b5f7-7dac-9ad4-ca6bba2e6c34€9.00€0.19matched
55capture01a1b649-d264-7276-9106-3f815637d07e€24.00€0.37matched
56capture01a1b649-db25-77a1-8355-4e52c3aabaed€35.00€0.50matched
57capture01a1b64a-11a7-75b4-9608-2a34ea1cea93€15.00€0.26matched
58capture01a1b64a-1cec-7f7c-bffe-48f91de3a60f€15.00€0.26matched
59refund01a1b64a-6719-7d48-a754-bc99f0ddb509-€4.00€0.00matched
60capture01a1b64a-6ccd-7248-af27-3d031c46f432€49.00€0.67matched
61capture01a1b64a-76bf-73ae-97de-b59dcfaa2baf€9.00€0.19matched
62capture01a1b64a-949c-718a-add7-c9ac4e2236aa€15.00€0.26matched
63capture01a1b64a-b0ae-7398-b909-12a97bdc9520€49.00€0.67matched
64capture01a1b64a-b5a8-76b2-86da-6f2f8ef6694f€49.00€0.67matched
65capture01a1b64a-b721-71f2-9ef9-f3d9ff304962€9.00€0.19matched
66capture01a1b64a-c446-796f-abd8-6ccf783a12f8€35.00€0.50matched
67capture01a1b64a-deb3-7620-adb8-0de6f60e0e8f€15.00€0.26matched
68refund01a1b64a-f190-761b-a81f-43110c29d2b9-€6.00€0.00matched
69capture01a1b64b-01e9-793e-be4b-e0a47c9aa8ae€49.00€0.67matched
70capture01a1b64b-118f-7dc6-9964-572ccdc07f4e€35.00€0.50matched
71capture01a1b64b-1d17-7c24-9e4e-99fdb7a1cffe€49.00€0.67matched
72capture01a1b64b-25d7-7d29-b914-2b9ee5d906f7€24.00€0.37matched
73capture01a1b64b-26e1-7f9f-825f-f538c630e44b€15.00€0.26matched
74capture01a1b64b-2af8-7f7c-83bd-e5e41af978b9€49.00€0.67matched
75capture01a1b64b-3d01-7342-bd55-eb8e936ba26d€35.00€0.50matched
76capture01a1b64b-4958-797a-b6f0-439d13cff0bf€9.00€0.19matched
77capture01a1b64b-4a95-76ab-8f73-72ba2873ff24€35.00€0.50matched
78capture01a1b64b-54cb-708d-97ba-590a8102c030€24.00€0.37matched
79capture01a1b64b-6351-7a37-bd40-f1b2e59f67eb€24.00€0.37matched
80capture01a1b64b-7ebd-7402-9038-beb158ed26b8€24.00€0.37matched
81capture01a1b64b-aa43-7340-bca8-aaf694606992€35.00€0.50matched
82refund01a1b64b-aeba-7f6a-9b50-db23281ba7d2-€21.00€0.00matched
83capture01a1b64b-b3d4-7048-96fe-b98f9187ec47€15.00€0.26matched
84capture01a1b64b-bd67-7876-be58-feb22d0fcdfa€15.00€0.26matched
85capture01a1b64b-eb49-74e4-b8ad-c565019e0055€24.00€0.37matched
86capture01a1b64c-6bb5-788d-a9cf-f9b2914a28fa€15.00€0.26matched
87capture01a1b64c-6ddd-70e8-a0c5-bc550280bd75€49.00€0.67matched
88capture01a1b64c-937b-7fdd-9be8-4f476fe7baf9€24.00€0.37matched
89capture01a1b64c-97dc-7dfc-9d46-d9002afe7c85€35.00€0.50matched
90capture01a1b64c-b6df-7f3c-8d3c-2eaf08a06ad4€9.00€0.19matched
91capture01a1b64c-bcd6-7f44-86a5-81fb28ee39c3€9.00€0.19matched
92capture01a1b64c-d214-79e3-8449-aa18fd53078e€49.00€0.67matched
93capture01a1b64c-e68e-7cd8-aae7-356ccdabc7fc€49.00€0.67matched
94capture01a1b64c-f1fa-7e41-aa43-d54532d934cd€49.00€0.67matched
95capture01a1b64d-01c8-767f-919e-c042200057ee€9.00€0.19matched
96capture01a1b64d-145a-7cf6-81d4-432f078a34f6€24.00€0.37matched
97capture01a1b64d-2717-74e7-9566-579850fa66e8€24.00€0.37matched
98capture01a1b64d-534a-7aaa-8384-2b8528b9f00b€15.00€0.26matched
99capture01a1b64d-5e65-7a10-a3d8-a9ea45df4c55€24.00€0.37matched
100capture01a1b64d-ae55-7d99-a87c-b0be78f318af€49.00€0.67matched
101capture01a1b64d-c38d-714d-8c29-75ff98b61b71€24.00€0.37matched
102capture01a1b64d-e078-711c-915e-7bb7eeb8b598€35.00€0.50matched
103capture01a1b64d-ea0d-7bcd-b259-610c5d5394a0€15.00€0.26matched
104capture01a1b64d-f625-72b0-b67f-7a923c446ee9€35.00€0.50matched
105capture01a1b64d-fc2c-795c-b4a9-c47916058ceb€24.00€0.37matched
106capture01a1b64e-0048-752d-9b90-9fb534976fad€9.00€0.19matched
107refund01a1b64e-44ba-70df-aed3-f0185cce0c88-€5.00€0.00matched
108capture01a1b64e-6143-771d-bee9-116c8e44f88d€49.00€0.67matched
109capture01a1b64e-6280-7772-977d-561a479b57ee€49.00€0.67matched
110capture01a1b64e-6453-7ff4-83fa-c5bae839d54e€9.00€0.19matched
111capture01a1b64e-7ca7-7b86-bf4c-40009a5dfd52€49.00€0.67matched
112capture01a1b64e-8069-7142-8184-06b585085041€49.00€0.67matched
113refund01a1b64e-987d-792c-8d5d-9eae82535da4-€45.00€0.00matched
114capture01a1b64e-e729-782f-8072-b27c3e8c7b83€35.00€0.50matched
115capture01a1b64e-ef70-7f20-8f78-4c5728749344€9.00€0.19matched
116capture01a1b64e-fc32-7eca-9f73-743524627665€9.00€0.19matched
117capture01a1b64e-ff65-775b-ace0-a60e9805cb1a€24.00€0.37matched
118capture01a1b64f-066a-75c0-abf6-2f74778252db€9.00€0.19matched