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, 03:00

Gross

€2,863.00

PSP fee

€46.70

Net to the bank

€2,816.30

Settlement journal

#372134

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a486-51b0-7fcf-9700-10c8376c1257 is already settled by stl_EUR_2989602 line 101
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • missing linein the books, not in the filecapture:01a1a485-438f-76cd-a30c-fe5a9f487562 is in no file
  • missing linein the books, not in the filecapture:01a1a486-7a33-7c9a-a231-19738cbb6c48 is in no file
LineKindReferenceGrossFeeStatus
41capture01a1a482-2f7d-736a-aeb7-84bfc6c5a4a3€35.00€0.51fee difference
102capture01a1a486-51e6-7595-bf81-9a8d3c154410€15.00€0.26duplicate line
1capture01a1a476-c0f1-781c-9a71-ac1c39bdec6d€35.00€0.50matched
2capture01a1a477-c919-7a7f-9ccd-2d9a064f9048€15.00€0.26matched
3capture01a1a478-5df5-733d-89bd-51a80681e4ae€15.00€0.26matched
4capture01a1a479-e0c6-7631-9095-8d26cada0160€35.00€0.50matched
5capture01a1a480-1256-7817-ba56-e6993387cd8f€35.00€0.50matched
6capture01a1a480-4fb0-770c-9911-436f7e8d63a9€35.00€0.50matched
7capture01a1a480-625a-7bea-9a7e-b3117d13b9f7€9.00€0.19matched
8capture01a1a480-70e0-7637-8f2f-d96ff16a591d€24.00€0.37matched
9capture01a1a480-9402-77b3-b609-f96401c1728d€24.00€0.37matched
10capture01a1a480-9d9e-71ea-9beb-52e7be19b8e7€35.00€0.50matched
11capture01a1a480-9fad-7cdb-9b81-80a83d9ae7d9€35.00€0.50matched
12capture01a1a480-a09f-7f72-9ca5-ac700e55ac39€24.00€0.37matched
13capture01a1a480-a1e0-730e-855d-dbca25df78b5€9.00€0.19matched
14capture01a1a480-a5eb-79f3-b444-f8afda5f5d75€9.00€0.19matched
15refund01a1a480-a7cd-7da6-bc31-ff0bc9089b05-€3.00€0.00matched
16capture01a1a480-a920-704d-9e5d-0befb152dbb8€9.00€0.19matched
17capture01a1a480-ad3d-7f52-8116-56f55cd0598d€15.00€0.26matched
18capture01a1a480-bb74-7f16-813e-9563b848580f€35.00€0.50matched
19capture01a1a480-c099-750b-9b86-ded4d9080661€15.00€0.26matched
20capture01a1a481-00df-7411-9905-8ded84ac460c€49.00€0.67matched
21capture01a1a481-18bf-714c-9e32-2aaecc3414ef€24.00€0.37matched
22capture01a1a481-1c7b-7c71-af0f-df6fb436a262€15.00€0.26matched
23capture01a1a481-224a-745b-b886-dfaadc84f48f€9.00€0.19matched
24capture01a1a481-231e-742a-bb93-9816fc419775€24.00€0.37matched
25capture01a1a481-2694-72b6-86c3-8b72b00d30a6€15.00€0.26matched
26capture01a1a481-287f-77c8-a953-0e9c2eb3317b€35.00€0.50matched
27capture01a1a481-32ee-763b-abc9-619184667d37€24.00€0.37matched
28capture01a1a481-5217-744d-bc49-e7052888bab4€35.00€0.50matched
29capture01a1a481-632c-7679-830e-612ed9b74f5f€49.00€0.67matched
30capture01a1a481-6637-773d-942a-444054d3d0d8€15.00€0.26matched
31refund01a1a481-6ab3-7765-8363-8258004fb1b3-€41.00€0.00matched
32capture01a1a481-73df-7b4c-ba04-bd007f86a7ec€15.00€0.26matched
33capture01a1a481-8acc-7fba-80a3-cae0bdde9904€35.00€0.50matched
34capture01a1a481-922a-7a33-a94d-f951b089bc5a€9.00€0.19matched
35capture01a1a481-a283-749e-9554-cfa40c03f360€24.00€0.37matched
36capture01a1a481-b005-7254-bb9a-2222c6674433€15.00€0.26matched
37capture01a1a481-bf62-7cd7-b6d0-789350d87738€15.00€0.26matched
38capture01a1a481-c4e9-7268-a3b8-fc97ff4d7a1a€49.00€0.67matched
39capture01a1a481-e9ca-74cb-9c6c-42ac00ac62da€49.00€0.67matched
40capture01a1a482-28f1-7819-9d2d-6f66f3dfc24e€35.00€0.50matched
42capture01a1a482-363d-71ab-a99a-c7b00bc43724€24.00€0.37matched
43refund01a1a482-3b02-7115-8204-2d1e3f8e082e-€15.00€0.00matched
44capture01a1a482-666b-7fa8-a015-0759d5e4de46€24.00€0.37matched
45refund01a1a482-70ef-7dd3-8390-c2a5aadde654-€17.00€0.00matched
46capture01a1a482-7c65-7335-83de-7fedaad4415c€9.00€0.19matched
47capture01a1a482-910a-71b4-86cd-db56516f6e0e€15.00€0.26matched
48capture01a1a482-9aae-7009-b32d-39849f62480c€49.00€0.67matched
49capture01a1a482-e546-7028-a227-4d82eb515648€24.00€0.37matched
50capture01a1a482-e769-7289-bec9-79535fc4cf0c€15.00€0.26matched
51capture01a1a482-e0c5-7fcb-900d-cdbbba936a4c€49.00€0.67matched
52capture01a1a482-ef02-7cc3-90a4-510f10f7532c€24.00€0.37matched
53capture01a1a482-f1cf-708d-895f-855a6584a548€15.00€0.26matched
54capture01a1a483-187b-7dca-857d-b5db5834ee20€24.00€0.37matched
55capture01a1a483-1df0-71f9-9433-eb6fa41e98fb€9.00€0.19matched
56capture01a1a483-3001-7714-93f3-47ff66cb631f€24.00€0.37matched
57capture01a1a483-315b-7651-92bb-87e55cae2d54€24.00€0.37matched
58capture01a1a483-527e-7489-8a7b-c9e35f337920€24.00€0.37matched
59capture01a1a483-5c55-754a-bfc3-3c587cbe13e0€15.00€0.26matched
60capture01a1a483-7e58-7195-b6d1-8e2e3bbd56a7€9.00€0.19matched
61capture01a1a483-9458-70d2-8388-8af40d9da019€24.00€0.37matched
62capture01a1a483-ac95-7ea4-8079-fd346cb8edef€49.00€0.67matched
63refund01a1a483-adbb-7eb7-8439-cdc201a7b069-€18.00€0.00matched
64refund01a1a483-d9da-79a1-9b69-f8cfd8639c15-€15.00€0.00matched
65capture01a1a483-df80-7ab4-95b1-b8eb248ba7dc€35.00€0.50matched
66capture01a1a483-e234-7989-a744-e309d9b04d97€9.00€0.19matched
67capture01a1a483-f3e0-7aa9-bc2f-93618ed2d493€24.00€0.37matched
68capture01a1a483-f58a-7db9-a4c2-18e0642575fe€49.00€0.67matched
69capture01a1a484-0da2-7d55-b35d-75128483ed47€15.00€0.26matched
70refund01a1a484-247a-7816-ae72-53f4400278ac-€20.00€0.00matched
71refund01a1a484-3207-762f-9d45-0c071c42a1fd-€21.00€0.00matched
72capture01a1a484-33e0-72c0-8414-9e56e03b374c€9.00€0.19matched
73capture01a1a484-5957-7732-819c-c3994b9b8d98€15.00€0.26matched
74capture01a1a484-654d-7a5c-9dfe-8187f6256e0d€49.00€0.67matched
75capture01a1a484-6553-76ee-bdcc-75313b60ed0a€9.00€0.19matched
76capture01a1a484-a71d-7562-b869-7902d0891cc8€24.00€0.37matched
77capture01a1a484-bf52-7bb8-9d06-0d912aa6e722€24.00€0.37matched
78capture01a1a484-ef65-738f-8dc4-8baa9a091e3c€49.00€0.67matched
79capture01a1a484-f015-7023-83ab-036a68587c2f€9.00€0.19matched
80capture01a1a485-0c9f-790b-a9a2-9094d2716e15€35.00€0.50matched
81capture01a1a485-0d8a-7c9b-bca6-670e57781af9€15.00€0.26matched
82capture01a1a485-28cc-7a91-85b8-158fd9495f8a€9.00€0.19matched
83capture01a1a485-34fb-75f1-a954-9a79bbfede80€49.00€0.67matched
84capture01a1a485-42b0-767b-8705-f6e3b062ac16€49.00€0.67matched
85capture01a1a485-543b-7fd7-816e-bb4636bc0d4e€9.00€0.19matched
86capture01a1a485-5e3e-7db1-a9a8-2c2d894b78e9€9.00€0.19matched
87capture01a1a485-5f33-7eed-b8e3-0b96964cbfa5€15.00€0.26matched
88capture01a1a485-60df-76d6-bdef-e01c7e523fd9€24.00€0.37matched
89capture01a1a485-7206-73d9-a4a0-e0e22b58ef4a€15.00€0.26matched
90capture01a1a485-78cf-74b4-93fe-e90059f3aba6€9.00€0.19matched
91capture01a1a485-95e6-7019-85c3-0e7d19e8e874€24.00€0.37matched
92capture01a1a485-a149-73b5-abcb-4199cafffe6e€24.00€0.37matched
93capture01a1a485-b423-7594-be14-45678aa2d4ec€24.00€0.37matched
94capture01a1a485-bca9-7e75-b154-8001c5407188€15.00€0.26matched
95capture01a1a485-e130-74bf-ac67-7196d268ba5a€49.00€0.67matched
96capture01a1a485-e616-790c-a16a-0ff9c025e6f0€49.00€0.67matched
97capture01a1a486-0379-7457-b55c-562580e76607€35.00€0.50matched
98refund01a1a486-1994-7207-9296-20c5f8eadab1-€39.00€0.00matched
99capture01a1a486-2460-74eb-9dee-47a705fca152€9.00€0.19matched
100capture01a1a486-2e25-7d3e-b767-fbc6e1b956e3€35.00€0.50matched
101capture01a1a486-51e6-7595-bf81-9a8d3c154410€15.00€0.26matched
103capture01a1a486-590a-7b6a-a019-e7e9c42c8136€49.00€0.67matched
104capture01a1a486-598e-7e06-b222-2afd4e502e53€15.00€0.26matched
105capture01a1a486-61d8-70fd-a6eb-b39b9a4fc609€9.00€0.19matched
106capture01a1a486-6eb8-7240-b49b-ec6b48740f27€49.00€0.67matched
107capture01a1a486-73af-7490-9337-890ce194a41b€9.00€0.19matched
108capture01a1a486-99da-7262-afd9-9f8772715646€24.00€0.37matched
109capture01a1a486-ad9d-7173-8faa-f3d16dc9e70a€9.00€0.19matched
110capture01a1a486-cb6b-71ac-ab98-da8a3fb7c43f€35.00€0.50matched
111capture01a1a486-cb88-7210-bea3-9a814d2c70da€49.00€0.67matched
112capture01a1a486-d79d-7b82-a99b-bf501eb1dd97€35.00€0.50matched
113capture01a1a486-e63a-7992-b1bd-798d85741c76€24.00€0.37matched
114capture01a1a486-f955-7e6e-93dd-7cf3fe8fe89e€15.00€0.26matched
115capture01a1a487-00b2-7be9-86a6-da789d1bcc7f€49.00€0.67matched
116capture01a1a487-1e1c-7989-af00-af4cde1a7834€24.00€0.37matched
117capture01a1a487-263a-74f8-a60e-fe28b86f2c2c€15.00€0.26matched
118capture01a1a487-6aec-734b-bc75-163fe5e0bac7€9.00€0.19matched
119capture01a1a487-8552-730e-b7c3-32e49cf95675€15.00€0.26matched
120capture01a1a487-9594-754f-81f2-73bc96cc71d5€49.00€0.67matched
121capture01a1a487-d174-765c-b57b-74686d280f1d€15.00€0.26matched
122capture01a1a487-f6ba-7df1-aad8-2956d782f83b€15.00€0.26matched
123capture01a1a488-1db7-7bce-a9db-1445271b1fe4€9.00€0.19matched
124capture01a1a488-1f3f-7066-bdc3-d2d6e4c26013€9.00€0.19matched
125capture01a1a488-2ac7-7871-8cd7-a5a67accedbf€35.00€0.50matched
126capture01a1a488-54be-7e0a-802e-77b4da1fbeed€35.00€0.50matched
127capture01a1a488-586a-7caf-860f-f6851cb2e42f€15.00€0.26matched
128capture01a1a488-5bac-791f-8385-79f879e95a0f€9.00€0.19matched
129capture01a1a488-7719-7318-a248-c4d83a89448d€49.00€0.67matched
130capture01a1a488-8a4a-73ea-af24-c64817c0c8b8€15.00€0.26matched
131capture01a1a488-bd0e-7276-8e71-6c5ec032f171€49.00€0.67matched
132capture01a1a488-bf3f-7b61-ab6a-72c6fd654a6b€15.00€0.26matched
133capture01a1a488-ce05-731d-abf0-3ef37c25e30a€9.00€0.19matched