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, 21:30

Gross

€2,632.00

PSP fee

€40.77

Net to the bank

€2,591.23

Settlement journal

#386211

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a87f-8c24-7abe-8568-ce0c379932f8 is already settled by stl_EUR_2989713 line 87
  • duplicate linethe file lists it twicecapture:01a1a880-bab1-7c82-9a29-0247bba0286d is already settled by stl_EUR_2989713 line 99
  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
LineKindReferenceGrossFeeStatus
16refund01a1a878-df80-73fb-9dda-5ee0c9cc215a-€22.00€0.03fee difference
88capture01a1a87f-8c5f-7306-b968-0bf65ebf2fc4€35.00€0.50duplicate line
100capture01a1a880-bae4-795c-85d2-0f5fd7145991€15.00€0.26duplicate line
1capture01a1a86f-d4e3-7faa-9db0-6f06180d091e€9.00€0.19matched
2capture01a1a876-c24c-7c26-b54b-29709ac4e546€24.00€0.37matched
3capture01a1a876-e226-723e-8dab-e05a3eb38a26€24.00€0.37matched
4capture01a1a878-1a7c-7317-9d6e-da77061db580€9.00€0.19matched
5capture01a1a878-30f7-74a5-ae51-c7501596da44€9.00€0.19matched
6capture01a1a878-2e36-752d-8001-5442d99e553c€9.00€0.19matched
7capture01a1a878-43dc-773c-9aa2-977e2e7df884€35.00€0.50matched
8capture01a1a878-6406-7028-b278-3378661f8d74€49.00€0.67matched
9capture01a1a878-707e-7e64-91b7-a2cfebb33332€49.00€0.67matched
10capture01a1a878-89dc-7cdf-9776-554295206d24€15.00€0.26matched
11capture01a1a878-91bc-7b44-a199-4ff9f29ce286€24.00€0.37matched
12capture01a1a878-94d7-7a09-8112-796e303b4ec3€15.00€0.26matched
13capture01a1a878-9ae9-7fbb-a4e6-fb5567904e12€49.00€0.67matched
14capture01a1a878-c8ab-7d00-aa18-e2d9fa89e67c€24.00€0.37matched
15capture01a1a878-dba9-7258-86fc-1d14db5758c5€9.00€0.19matched
17refund01a1a879-0494-7960-af03-58f9ea60f067-€12.00€0.00matched
18capture01a1a879-1e7b-7dbe-8b25-147fa0e45493€15.00€0.26matched
19capture01a1a879-715d-7fb7-8660-4f04804c8b49€15.00€0.26matched
20capture01a1a879-8dc9-718a-993d-cfd175980859€35.00€0.50matched
21capture01a1a879-a7c7-7bec-a76e-a29513d9aec8€24.00€0.37matched
22capture01a1a879-aba6-771b-8f78-8f29304d507a€9.00€0.19matched
23capture01a1a879-cc14-724a-a344-1a4ff3cb22c8€9.00€0.19matched
24capture01a1a879-f585-70f2-958f-cdc6dfced1bc€24.00€0.37matched
25capture01a1a87a-32dd-774c-9169-dd693160c072€24.00€0.37matched
26capture01a1a87a-374d-704a-afd3-7428f4edf9e9€9.00€0.19matched
27capture01a1a87a-4d3f-70d6-9a3b-246b0c589671€35.00€0.50matched
28capture01a1a87a-5bd0-797a-88bd-bcf0b835c11e€49.00€0.67matched
29capture01a1a87a-74dd-7446-b051-fb1aa7e0720e€24.00€0.37matched
30capture01a1a87a-93e8-70d8-98dc-d2ca9a5122ee€9.00€0.19matched
31capture01a1a87a-aa08-764c-94bd-34d36a98b0f7€15.00€0.26matched
32refund01a1a87a-b12d-7a24-8026-10f87ced8c99-€32.00€0.00matched
33capture01a1a87a-bc2d-778b-90b0-cac576cd4061€15.00€0.26matched
34capture01a1a87a-ca96-7193-8f33-8beb6e3260c2€9.00€0.19matched
35capture01a1a87a-d14b-7c0b-9416-4740db71e70f€35.00€0.50matched
36capture01a1a87a-d219-7255-814b-844fa885baee€24.00€0.37matched
37capture01a1a87a-d79c-7c4d-89d7-9fc899962091€35.00€0.50matched
38capture01a1a87b-0e9e-708d-b108-0dd783059d2b€35.00€0.50matched
39capture01a1a87b-0efb-78a6-aeb3-39d18ebca73f€49.00€0.67matched
40capture01a1a87b-4174-7454-b7d9-bfbe0ddc4ad6€49.00€0.67matched
41capture01a1a87b-52c2-7403-ba5f-755da178dce0€49.00€0.67matched
42capture01a1a87b-5597-7d24-8a3f-1af2cdd1a572€9.00€0.19matched
43capture01a1a87b-70d6-758a-9410-227e37b30d7c€49.00€0.67matched
44capture01a1a87b-a02c-79a7-a54d-95086fcfafc9€35.00€0.50matched
45capture01a1a87b-bad8-7e38-ab07-c55bc41bbf00€9.00€0.19matched
46capture01a1a87b-cfcc-71fa-aeda-a54a49f1399b€15.00€0.26matched
47capture01a1a87b-e4af-7258-acdd-f36b83e18305€24.00€0.37matched
48capture01a1a87b-fad3-72d7-9533-0c3e39160fe3€24.00€0.37matched
49capture01a1a87b-fdea-780f-9aad-6b002babff3c€15.00€0.26matched
50capture01a1a87c-09a1-7939-ac2d-99711a976945€9.00€0.19matched
51capture01a1a87c-0bfd-7582-8997-aedd448d52bc€24.00€0.37matched
52capture01a1a87c-1291-7e6e-aa3e-5992a7e4ae4a€49.00€0.67matched
53capture01a1a87c-147e-762e-b7d3-322928baf965€49.00€0.67matched
54refund01a1a87c-550b-7906-977c-ca5d43535885-€16.00€0.00matched
55capture01a1a87c-7290-7eab-b570-0da3910c8d0a€35.00€0.50matched
56capture01a1a87c-7b97-7f21-bc7a-6cae41f4704b€49.00€0.67matched
57capture01a1a87c-8218-719b-a083-9d91f5398f9e€35.00€0.50matched
58capture01a1a87c-cd2a-761d-8879-c336c95b18f3€15.00€0.26matched
59capture01a1a87c-dd21-7664-ac82-3d18c3da83fc€35.00€0.50matched
60capture01a1a87d-333d-79a6-8adb-47344884d933€35.00€0.50matched
61capture01a1a87d-4be4-721a-9490-429f68cc46ed€49.00€0.67matched
62capture01a1a87d-645e-76f0-b3d4-9994d5a643c2€15.00€0.26matched
63capture01a1a87d-88af-7bb7-aa46-3825d043c9a7€35.00€0.50matched
64capture01a1a87d-af81-7884-9d79-a4b428a601de€9.00€0.19matched
65refund01a1a87d-c635-7764-9906-d6b8867260ba-€4.00€0.00matched
66capture01a1a87e-2293-7ef8-812a-781807745b90€15.00€0.26matched
67capture01a1a87e-241a-7122-a9f9-c2a901d6918d€9.00€0.19matched
68capture01a1a87e-2819-7167-a736-24a84b7afa76€49.00€0.67matched
69capture01a1a87e-4940-7c15-b555-9d95ac9507fe€9.00€0.19matched
70capture01a1a87e-61fb-72a9-b4a9-044a03708cb5€24.00€0.37matched
71capture01a1a87e-6b4e-713d-8985-e7953ad9ae0b€35.00€0.50matched
72capture01a1a87e-756b-7f25-a154-75e8d03e8eb5€49.00€0.67matched
73capture01a1a87e-7a41-736b-a8ea-680252dd3286€15.00€0.26matched
74capture01a1a87e-8532-7a0c-9ff9-26a0061732df€49.00€0.67matched
75capture01a1a87e-8792-7779-bdc9-3bf95126efc8€49.00€0.67matched
76capture01a1a87e-965c-7970-8e36-72eb8ad0f795€35.00€0.50matched
77capture01a1a87e-97ef-73e2-99b3-c6e889dabb21€15.00€0.26matched
78capture01a1a87e-a6dd-7ab3-bfc4-9f48aa3d168f€9.00€0.19matched
79capture01a1a87e-b1ce-7f4d-a923-273731d96a24€49.00€0.67matched
80capture01a1a87e-ba37-7f79-ad96-1271ad84fcbd€24.00€0.37matched
81capture01a1a87f-04e9-789a-aa08-124ccccfa59c€35.00€0.50matched
82capture01a1a87f-1eb4-7e04-a957-b401ae1fdf7d€15.00€0.26matched
83capture01a1a87f-4b84-7795-b6a6-dda242d25815€9.00€0.19matched
84capture01a1a87f-4d08-7230-a598-a1c670bb449a€24.00€0.37matched
85capture01a1a87f-62a8-73a6-b1bb-d4df857981e1€35.00€0.50matched
86capture01a1a87f-7d0c-79b9-855e-bcaf87da887f€9.00€0.19matched
87capture01a1a87f-8c5f-7306-b968-0bf65ebf2fc4€35.00€0.50matched
89capture01a1a87f-9c64-762d-ab20-c04fd1890653€24.00€0.37matched
90capture01a1a87f-dc8d-77e4-a98e-e277f90d32ec€49.00€0.67matched
91capture01a1a87f-fbef-7050-ba27-edea8b0ace2f€24.00€0.37matched
92capture01a1a87f-fcd7-75f5-b9fa-aebf6e722f2f€49.00€0.67matched
93capture01a1a880-1647-77fa-b342-953422182169€35.00€0.50matched
94capture01a1a880-3211-77c8-9438-d773d3cdb59f€49.00€0.67matched
95capture01a1a880-345a-7461-9a14-a4beabc9b741€9.00€0.19matched
96capture01a1a880-509d-7f9a-8e22-e2b872a53039€24.00€0.37matched
97capture01a1a880-5513-7284-8203-332aec3450d2€49.00€0.67matched
98capture01a1a880-9753-7f0a-acfa-07112cc4ab7d€49.00€0.67matched
99capture01a1a880-bae4-795c-85d2-0f5fd7145991€15.00€0.26matched
101capture01a1a880-c5b9-75aa-b159-4ff94810679f€15.00€0.26matched
102capture01a1a880-dd23-7881-9912-d45656650179€15.00€0.26matched
103capture01a1a880-f827-75ea-aa65-5c177a5bf1c1€9.00€0.19matched
104capture01a1a880-fafd-7dd8-a949-4e7d8ce82b11€49.00€0.67matched
105capture01a1a881-1e58-7bc5-bb9b-61eeaa83a058€35.00€0.50matched