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

3 Nov, 07:30

Gross

€3,195.00

PSP fee

€49.13

Net to the bank

€3,145.87

Settlement journal

#357377

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a058-830a-7d08-aa4f-53f9850d510e is already settled by stl_EUR_2989485 line 104
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
LineKindReferenceGrossFeeStatus
41capture01a1a053-224d-753e-9dd2-5f737227fe16€49.00€0.72fee difference
105capture01a1a058-832f-766d-80ce-0c94e4bdaa6d€49.00€0.67duplicate line
112capture01a1a058-f83f-7cc3-a21b-7f326b45a731€49.00€0.69fee difference
1capture01a1a049-2f66-7347-93ed-5156d3b9f537€35.00€0.50matched
2capture01a1a050-b7b9-745f-b868-6a58d542f17f€49.00€0.67matched
3capture01a1a050-bf9c-73a5-9dff-63b8ca9f51fd€24.00€0.37matched
4capture01a1a050-d05e-784e-bdfb-6eb0f8b795f4€24.00€0.37matched
5capture01a1a051-2d31-77ba-a0d6-ee655dd1ecbc€35.00€0.50matched
6capture01a1a051-4c97-71e2-a10e-580f5f5cca60€35.00€0.50matched
7capture01a1a051-655d-7810-b7a3-2f8eab71f9af€9.00€0.19matched
8capture01a1a051-77f5-724a-8b4d-09a682aaca3a€49.00€0.67matched
9capture01a1a051-957e-783a-a7f6-3ccd2f7cb45e€49.00€0.67matched
10capture01a1a051-9e14-7208-aab5-f49197015323€24.00€0.37matched
11capture01a1a051-a9e0-7f73-bb5a-15d621d5665f€35.00€0.50matched
12capture01a1a051-cfe6-762d-92e1-2d789a20a550€49.00€0.67matched
13refund01a1a051-dbb4-769e-bca5-8d7b9c6bc696-€35.00€0.00matched
14capture01a1a051-f4e3-7cb0-8a97-49e203f7d147€35.00€0.50matched
15capture01a1a051-f612-72f0-ad12-1697ccec4e0b€35.00€0.50matched
16capture01a1a052-0d4b-7a26-a98f-c023478c735b€35.00€0.50matched
17capture01a1a052-13af-73dd-b026-954bd736f84b€9.00€0.19matched
18capture01a1a052-2152-7101-9a07-f033219f4d89€49.00€0.67matched
19capture01a1a052-3645-7db5-9c5f-318134f7e02c€15.00€0.26matched
20capture01a1a052-3a89-7419-96f1-5c7c81b461b6€35.00€0.50matched
21capture01a1a052-4277-7d78-8a6e-12c65497bf8a€24.00€0.37matched
22capture01a1a052-4c70-7127-825d-c2756c7e7eac€15.00€0.26matched
23capture01a1a052-5655-77a6-a3ed-f3158b110bc0€49.00€0.67matched
24capture01a1a052-61c4-785e-b629-8c4d3ef97d37€49.00€0.67matched
25capture01a1a052-6686-7bc9-b9a5-bb25acbc0bd6€9.00€0.19matched
26capture01a1a052-9019-7a07-a5bf-fa92b0a02a4a€9.00€0.19matched
27capture01a1a052-a5e3-74ec-be66-f04588cacc2f€49.00€0.67matched
28refund01a1a052-a6d4-7532-b6e9-6f36d59ca69e-€12.00€0.00matched
29capture01a1a052-d6cb-7c05-93b4-1b328ce4ff12€49.00€0.67matched
30capture01a1a052-db7e-75e7-a578-ee1c446b83d3€9.00€0.19matched
31capture01a1a052-eaab-74aa-a8c9-be244872917c€9.00€0.19matched
32capture01a1a052-f394-7f2a-b4d4-79d589619017€15.00€0.26matched
33capture01a1a052-f31f-71ef-95d9-40a068c5c169€24.00€0.37matched
34capture01a1a052-fab8-74dd-ab37-2410cea9bba2€24.00€0.37matched
35capture01a1a053-025a-7c0d-99ef-0b5712e8daf2€9.00€0.19matched
36capture01a1a053-0498-7390-b114-1fc7124f20c3€35.00€0.50matched
37capture01a1a053-11ca-7c26-b616-bf31b3421c42€35.00€0.50matched
38capture01a1a053-1cd0-7bad-9b05-eedd716ed1c5€35.00€0.50matched
39capture01a1a053-1da5-7ffe-a53a-00bd84a4abd0€15.00€0.26matched
40refund01a1a053-1faa-7f26-a0cd-2d0e21384065-€21.00€0.00matched
42capture01a1a053-3ca1-7d3b-824c-929cdfaf92be€9.00€0.19matched
43capture01a1a053-5894-772a-bec4-920c6c70d93b€15.00€0.26matched
44refund01a1a053-8adf-7a09-afec-40e4b774a59c-€12.00€0.00matched
45capture01a1a053-8f00-7c68-93fb-71a746d2cad9€15.00€0.26matched
46capture01a1a053-a5cc-7543-9099-4e6de2ec3db1€15.00€0.26matched
47capture01a1a053-abca-78c6-8e22-1a46c0619c12€9.00€0.19matched
48capture01a1a053-c066-7991-b4c3-5ff9ad8900da€15.00€0.26matched
49capture01a1a053-ca01-7f28-b95c-d75fdbf95157€24.00€0.37matched
50capture01a1a053-cb86-7dfc-bcd2-63eb2bf9c123€9.00€0.19matched
51capture01a1a053-dd4e-7cb5-a668-eeda1d222f58€35.00€0.50matched
52capture01a1a053-eb57-762b-9727-edfad5861883€35.00€0.50matched
53capture01a1a053-f278-7668-98bd-e9438c92f9ab€49.00€0.67matched
54refund01a1a054-234b-7f95-ba59-639de5669230-€15.00€0.00matched
55capture01a1a054-27bd-7a53-9518-073bf160ce7d€15.00€0.26matched
56capture01a1a054-2ea0-73d7-b64e-bc03bf92c36e€49.00€0.67matched
57capture01a1a054-4ce0-7596-80d4-a3f5409c7aeb€24.00€0.37matched
58capture01a1a054-68f4-716d-b68d-1166f68bc0db€9.00€0.19matched
59capture01a1a054-9295-7711-ba2f-c097373c8b1b€49.00€0.67matched
60capture01a1a054-9da3-79c2-8c16-35a4b1a7f375€24.00€0.37matched
61capture01a1a054-a7b3-7920-9a65-20079e0d79ce€9.00€0.19matched
62capture01a1a054-b03a-773a-8f0c-2c088e9ccdef€24.00€0.37matched
63capture01a1a054-c6aa-7e9a-8cdd-58c343a34477€49.00€0.67matched
64capture01a1a054-ccea-7a10-9d36-e78cc93f3d0e€49.00€0.67matched
65capture01a1a054-e5fb-7658-934a-54d9442ba24b€35.00€0.50matched
66capture01a1a054-f448-7d25-aa3d-1334e2b823c5€24.00€0.37matched
67capture01a1a055-2c80-75f3-9c50-ec72781803b3€35.00€0.50matched
68capture01a1a055-2edf-7994-aa99-ddd934d07f7a€35.00€0.50matched
69capture01a1a055-5450-733f-bf14-6da7746a4772€49.00€0.67matched
70capture01a1a055-6de3-71da-9cd6-fbce1c73cd32€15.00€0.26matched
71capture01a1a055-8335-7f5e-b898-d9ea7cfbcfaf€35.00€0.50matched
72capture01a1a055-8f6a-72bb-adba-466d7a399ebc€49.00€0.67matched
73capture01a1a055-9b4c-7809-a688-e4d952fd5b42€15.00€0.26matched
74capture01a1a055-9d5c-7200-9fde-40e9bed151fd€15.00€0.26matched
75capture01a1a055-e4d2-7b9c-8df3-85b27ccec7db€9.00€0.19matched
76capture01a1a055-fd4f-7c57-aa19-d8936eb95180€24.00€0.37matched
77capture01a1a056-0721-7005-a8ab-9e993b679008€24.00€0.37matched
78capture01a1a056-097e-74af-85ed-f06a26a6d30b€24.00€0.37matched
79capture01a1a056-42a3-78c7-9283-a02c3f5154ae€24.00€0.37matched
80capture01a1a056-461b-7251-a3dd-0695a982e3e3€35.00€0.50matched
81refund01a1a056-4753-7c6f-a6bb-b5961e30e7a2-€14.00€0.00matched
82capture01a1a056-7476-7822-9e60-3013e967bc93€9.00€0.19matched
83capture01a1a056-b2df-730b-af3a-3f044db7da9f€9.00€0.19matched
84capture01a1a056-cb6d-796b-85fb-0a663dc6fac3€49.00€0.67matched
85capture01a1a056-dd6e-7568-bd72-f1722abf1dac€49.00€0.67matched
86capture01a1a056-de3f-7781-805d-99b4de49c74f€15.00€0.26matched
87capture01a1a057-28d2-79d3-8ace-26277591a4e4€15.00€0.26matched
88capture01a1a057-2edc-77a9-b648-0ad4b732ec8b€49.00€0.67matched
89capture01a1a057-452f-7caf-91a1-81a76e15cdce€35.00€0.50matched
90capture01a1a057-51da-7995-9827-6b9c51173947€35.00€0.50matched
91capture01a1a057-6ea2-77a5-9d26-814cd71d2e93€15.00€0.26matched
92capture01a1a057-9bae-7ef9-af89-b347b53da972€15.00€0.26matched
93capture01a1a057-a343-711c-865a-e53f32ac4188€9.00€0.19matched
94capture01a1a057-a66f-7da8-973c-66873e331dae€15.00€0.26matched
95capture01a1a057-b465-7455-8b76-7aebf1c2ae41€9.00€0.19matched
96capture01a1a057-bf58-7f96-9e24-0c53e5791378€35.00€0.50matched
97capture01a1a057-ca66-77ce-a982-b07abba4d87c€15.00€0.26matched
98capture01a1a057-caaa-7a9f-a0d3-048fcfecf5ca€35.00€0.50matched
99capture01a1a057-cf81-75a6-9825-c9f6610de274€15.00€0.26matched
100capture01a1a057-df2b-7608-9470-32cd07a2a8a6€9.00€0.19matched
101capture01a1a058-12a8-7cda-a935-494887997375€49.00€0.67matched
102capture01a1a058-57a6-7302-8988-1f178166b811€35.00€0.50matched
103capture01a1a058-81b7-716c-bad8-e6b608fd4be8€35.00€0.50matched
104capture01a1a058-832f-766d-80ce-0c94e4bdaa6d€49.00€0.67matched
106capture01a1a058-854f-7271-bacf-670679933e5f€49.00€0.67matched
107capture01a1a058-89ba-7569-b261-211bf70557d5€35.00€0.50matched
108capture01a1a058-ad0d-7568-85ba-8f5b72ddbda6€35.00€0.50matched
109capture01a1a058-d524-73eb-82c3-785cb04368ee€35.00€0.50matched
110capture01a1a058-de5b-72ef-91f3-c121d769d9e1€9.00€0.19matched
111capture01a1a058-fa1c-7600-8b36-a6d084a2dd48€9.00€0.19matched
113capture01a1a059-0940-72fa-ace9-d328816b1359€49.00€0.67matched
114capture01a1a059-0b79-7ed7-8bc9-9da670b7c604€35.00€0.50matched
115capture01a1a059-0f36-7b27-a814-00db50cc3455€9.00€0.19matched
116capture01a1a059-2012-7e9c-a34f-1c4d60aff868€35.00€0.50matched
117capture01a1a059-27c0-7eae-8450-3822585164cd€49.00€0.67matched
118capture01a1a059-4837-779b-a8ed-e329978baf90€15.00€0.26matched
119capture01a1a059-4951-7c76-ad92-9cc19e21fda9€24.00€0.37matched
120capture01a1a059-6dd8-765f-8d64-32913f69409c€9.00€0.19matched
121capture01a1a059-7c6d-75cb-9e1a-bfcc265e31a5€49.00€0.67matched
122capture01a1a059-c3c3-701b-9d8d-a54235f8a246€35.00€0.50matched