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

2 Nov, 04:00

Gross

€2,925.00

PSP fee

€45.95

Net to the bank

€2,879.05

Settlement journal

#336360

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a6c-b632-7338-93af-f827fb9df907 is already settled by stl_EUR_2989320 line 40
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • missing linein the books, not in the filecapture:01a19a6d-3348-773c-b4be-4b4d8b099819 is in no file
LineKindReferenceGrossFeeStatus
17refund01a19a6b-5829-751b-a6b3-fa1df3a81536-€17.00€0.02fee difference
41capture01a19a6c-d089-70bc-8ef3-fd2347e02d56€9.00€0.19duplicate line
50capture01a19a6d-ca36-71df-85bd-13d5c98300c3€35.00€0.54fee difference
1capture01a19a6a-0fc3-77ce-ba08-095d9e824cc0€24.00€0.37matched
2capture01a19a6a-18b2-71ec-b3c1-ab0e945a1a13€9.00€0.19matched
3capture01a19a6a-24a6-7014-b823-b0fb8bf931e9€35.00€0.50matched
4capture01a19a6a-320c-7d60-953a-37215af95f02€15.00€0.26matched
5refund01a19a6a-4b22-721c-8e22-885a5378d9f5-€8.00€0.00matched
6capture01a19a6a-6d84-72ed-8bd9-4ec415ab3acc€49.00€0.67matched
7capture01a19a6a-d041-7fbf-87c3-a9192b8202f5€9.00€0.19matched
8capture01a19a6a-d88b-7f4b-8315-02f7f77b4aa7€15.00€0.26matched
9capture01a19a6a-f526-760f-8e84-d5321278e9da€9.00€0.19matched
10capture01a19a6b-00d3-70cf-82f3-12ac81d55923€49.00€0.67matched
11capture01a19a6b-140c-73e6-94a4-9924e1bd5e5f€9.00€0.19matched
12capture01a19a6b-2c97-7abc-9a3e-5580f45edef3€24.00€0.37matched
13capture01a19a6b-2d9b-7ec9-9d79-11184df64f98€15.00€0.26matched
14capture01a19a6b-473c-70a3-b9bf-6350d6ebe42d€15.00€0.26matched
15capture01a19a6b-4c9a-7e33-9222-fde279f9b519€24.00€0.37matched
16capture01a19a6b-5685-777e-bd41-b675d04b8435€49.00€0.67matched
18capture01a19a6b-5993-738d-9cc5-768404c7e8cc€24.00€0.37matched
19capture01a19a6b-5b47-77b8-9e7f-a3539a2fe079€9.00€0.19matched
20capture01a19a6b-5d7b-7281-a2b8-f4520835d658€35.00€0.50matched
21capture01a19a6b-5e57-7ee7-a2d1-2ac575a9b3aa€9.00€0.19matched
22capture01a19a6b-9fb4-76e3-a0f5-16abed0db9d4€24.00€0.37matched
23refund01a19a6b-a66e-756d-914b-7dae7d67a914-€10.00€0.00matched
24capture01a19a6b-ccdd-7a11-a73d-eee01d5268c1€49.00€0.67matched
25capture01a19a6b-d7c5-7880-a284-6ab3fd0edae6€24.00€0.37matched
26capture01a19a6b-dd1b-7c13-9f22-a362158770e2€9.00€0.19matched
27capture01a19a6b-ec27-7a38-a5ed-14420752a553€49.00€0.67matched
28capture01a19a6c-21e0-7875-963a-b621e49f0dfd€9.00€0.19matched
29capture01a19a6c-283a-705a-94a7-591261d6d2f0€15.00€0.26matched
30capture01a19a6c-34c3-7ee2-a5bf-ee7a2ca9d733€15.00€0.26matched
31capture01a19a6c-394c-751a-b992-b7db4c008926€15.00€0.26matched
32capture01a19a6c-46e6-7b31-8ab3-38b2950f8a38€35.00€0.50matched
33capture01a19a6c-57e1-7818-a549-8d6515fc1ada€15.00€0.26matched
34capture01a19a6c-6627-70a7-a17b-b272cf3ed7c1€24.00€0.37matched
35capture01a19a6c-71e0-7724-beb6-723420367f11€15.00€0.26matched
36capture01a19a6c-7a9e-7035-96c8-ff7ca8007e93€49.00€0.67matched
37capture01a19a6c-913d-7615-a29a-8da27a24fc4c€35.00€0.50matched
38capture01a19a6c-9256-720b-a75f-f38c17e66319€35.00€0.50matched
39capture01a19a6c-b85d-7172-ab99-fbbca55560bb€49.00€0.67matched
40capture01a19a6c-d089-70bc-8ef3-fd2347e02d56€9.00€0.19matched
42capture01a19a6c-f025-773a-92bc-1ddacae28bf6€15.00€0.26matched
43capture01a19a6d-2417-7dcf-ad66-94ab4bb316e7€35.00€0.50matched
44capture01a19a6d-25bd-725f-950f-266f3fae1876€9.00€0.19matched
45capture01a19a6d-2df0-7759-91c3-39be3da8239d€49.00€0.67matched
46capture01a19a6d-3e29-7e7e-9505-2d4ec881b2d6€9.00€0.19matched
47capture01a19a6d-8666-7f85-b3d6-9e8eaa58754c€35.00€0.50matched
48capture01a19a6d-92f1-7f57-b361-03efa53faa71€35.00€0.50matched
49capture01a19a6d-af03-7e90-a703-a4e1a90407cb€9.00€0.19matched
51capture01a19a6d-d80e-712a-87e6-18b95deb3705€15.00€0.26matched
52capture01a19a6e-2246-794a-a219-47f0f5f48dac€24.00€0.37matched
53capture01a19a6e-2656-7955-90a1-16df48577552€9.00€0.19matched
54capture01a19a6e-3893-7453-afd3-4fee327e67f9€35.00€0.50matched
55capture01a19a6e-4028-7011-8b94-d2b3cfd60402€9.00€0.19matched
56capture01a19a6e-54a2-73a2-916e-dc538240c1c7€15.00€0.26matched
57capture01a19a6e-6676-731a-8098-ae190fbb48d6€35.00€0.50matched
58capture01a19a6e-7bb7-77e4-b62d-eff769045b97€9.00€0.19matched
59capture01a19a6e-824a-761f-ad49-33831541aae1€9.00€0.19matched
60capture01a19a6e-bd92-7c08-831f-fa13d4bc0c0a€49.00€0.67matched
61capture01a19a6e-d311-781c-b3c0-5a878ab59c73€24.00€0.37matched
62capture01a19a6e-eedc-79bd-8a38-38680fda0779€9.00€0.19matched
63refund01a19a6f-0dce-7c91-b519-495962ceb6d0-€14.00€0.00matched
64capture01a19a6f-0f29-75bc-b3cb-841fa41ccc46€24.00€0.37matched
65capture01a19a6f-1c24-708c-910d-21a252b4e0cf€49.00€0.67matched
66refund01a19a6f-4602-7aba-abad-137cabd706e2-€21.00€0.00matched
67capture01a19a6f-68f2-740d-a25d-3bb5948e81ee€35.00€0.50matched
68capture01a19a6f-69b6-7f50-a077-1c6fe34d39ba€9.00€0.19matched
69capture01a19a6f-789f-752e-97ef-9d915fac6d68€49.00€0.67matched
70capture01a19a6f-afff-783c-b31a-7218ecbc5d5b€15.00€0.26matched
71capture01a19a6f-d1f7-7955-8b24-48274789fe6a€9.00€0.19matched
72capture01a19a6f-d5f5-7999-9a21-ece7c8923265€35.00€0.50matched
73capture01a19a6f-de98-7667-acd9-065b2ef8e50a€49.00€0.67matched
74capture01a19a6f-e9e0-7df5-b2be-4b1d4924c039€9.00€0.19matched
75capture01a19a70-3255-7ea3-95ca-998833cbe697€35.00€0.50matched
76capture01a19a70-3bfd-77dd-9d9e-c4c0d05e2521€35.00€0.50matched
77capture01a19a70-4bcf-7059-a818-40400d0f8d52€15.00€0.26matched
78capture01a19a70-5381-7d5a-a244-929c44d8b6cf€24.00€0.37matched
79capture01a19a70-589d-7146-87d3-22ad874a6813€35.00€0.50matched
80capture01a19a70-6052-7cc3-bd34-0ac121d49df4€24.00€0.37matched
81capture01a19a70-65f3-72a2-9069-2fb8736e5677€24.00€0.37matched
82capture01a19a70-8904-759e-8125-ad9ae4b1670d€24.00€0.37matched
83capture01a19a70-9699-751c-a39a-d5bf3c718aea€9.00€0.19matched
84refund01a19a70-9a0d-7352-9013-273823ada10e-€32.00€0.00matched
85refund01a19a70-bfaa-7956-859e-bd2d4734e2be-€5.00€0.00matched
86capture01a19a70-c8ad-7781-959c-dd8d4d106573€24.00€0.37matched
87capture01a19a70-f03e-78f6-b396-3150fa050c0b€15.00€0.26matched
88capture01a19a70-f392-71d3-86f1-6d6371f70b6c€24.00€0.37matched
89capture01a19a70-feb7-76a4-9946-2ca69daf3930€9.00€0.19matched
90capture01a19a71-2533-73b0-95d9-aef0b0904999€35.00€0.50matched
91capture01a19a71-3c1b-71cd-a397-44d28658f710€49.00€0.67matched
92capture01a19a71-3d33-748f-935a-89d4c84cf122€9.00€0.19matched
93capture01a19a71-33eb-7bf0-b6c2-f75f8a7433d0€9.00€0.19matched
94capture01a19a71-552d-718a-b5dc-721dc06a860b€49.00€0.67matched
95capture01a19a71-6acb-73b3-9c00-42e1e8f27af7€35.00€0.50matched
96capture01a19a71-6dec-7bd3-937c-c1c7c86ec745€24.00€0.37matched
97capture01a19a71-76a5-7e6a-8550-94727a1ee035€24.00€0.37matched
98capture01a19a71-8ec2-78cf-ad6d-23e87d0969f9€35.00€0.50matched
99capture01a19a71-c14c-7707-9abd-7e7cf86f89e9€24.00€0.37matched
100capture01a19a71-c96d-7726-85a8-16e2cc3f96f4€24.00€0.37matched
101capture01a19a71-caec-7b83-a5ec-7e49d4b6e1ee€35.00€0.50matched
102capture01a19a71-d0d1-7284-ad36-04c70945f1a1€49.00€0.67matched
103capture01a19a71-d69e-72d9-93c5-339c7e5ad627€15.00€0.26matched
104capture01a19a71-f801-7918-9817-38671437ccd7€35.00€0.50matched
105capture01a19a71-fb7c-74f6-af2b-1177d1d8bd33€15.00€0.26matched
106capture01a19a71-ff09-701c-805d-73c90e2133a4€35.00€0.50matched
107capture01a19a72-05d1-780f-bf70-14ca1eeb5ece€49.00€0.67matched
108capture01a19a72-0ff5-7b63-8b24-a1091b1df91d€49.00€0.67matched
109capture01a19a72-12b2-7093-8fa7-47c60d86c3a6€24.00€0.37matched
110capture01a19a72-21d7-7eaf-8df1-6e16191c2f30€49.00€0.67matched
111capture01a19a72-44b1-765b-99c2-f76871e92a0a€24.00€0.37matched
112capture01a19a72-5578-772e-8215-67908d685a4d€24.00€0.37matched
113capture01a19a72-5d1c-729e-8af2-76dac5a481bc€35.00€0.50matched
114capture01a19a72-a875-786e-be70-b9942c111a2d€49.00€0.67matched
115capture01a19a72-abd0-7a33-bfb6-91417e6611e7€24.00€0.37matched
116capture01a19a72-b9a0-7cba-af02-db2ea264275d€15.00€0.26matched
117capture01a19a72-bca8-798a-b973-53696ea808fe€15.00€0.26matched
118capture01a19a72-b41f-775e-aac1-baaf758de42c€49.00€0.67matched
119capture01a19a72-c141-7cba-b2c6-728f575d91fd€49.00€0.67matched
120capture01a19a72-c1cd-72e0-b9d6-dcc0cfccb26d€24.00€0.37matched
121capture01a19a72-cd61-72d5-8c3c-1283e27c01d8€15.00€0.26matched
122capture01a19a72-eda0-7715-8b20-ba05a4504d53€49.00€0.67matched
123capture01a19a73-1bff-7fa6-a61a-797ca60c7478€9.00€0.19matched
124capture01a19a73-22b8-71cf-9633-a6477a4a39f1€15.00€0.26matched