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, 14:10

Gross

€2,794.00

PSP fee

€44.36

Net to the bank

€2,749.64

Settlement journal

#362343

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a1be-e870-7b78-91a7-868d55b54a10 is already settled by stl_EUR_2989525 line 5
  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
LineKindReferenceGrossFeeStatus
6capture01a1a1be-e89f-7f67-93fd-2488e3781835€15.00€0.26duplicate line
70capture01a1a1c4-402f-7fc9-9e0c-acafa27bf982€24.00€0.38fee difference
83capture01a1a1c5-36a1-7972-b0e4-ed4d4268f413€9.00€0.22fee difference
1capture01a1a1b8-128c-75a7-b234-59759d1e9720€9.00€0.19matched
2capture01a1a1be-8ee7-72cb-b066-dd70ebe012e8€15.00€0.26matched
3capture01a1a1be-d334-73ef-81ac-9c4559df0692€9.00€0.19matched
4capture01a1a1be-e356-7482-8249-c96fd7cdcc7c€9.00€0.19matched
5capture01a1a1be-e89f-7f67-93fd-2488e3781835€15.00€0.26matched
7capture01a1a1be-f3bd-7490-8c8b-598def405f4d€15.00€0.26matched
8capture01a1a1bf-1642-7894-97a6-3a9ffd00ddec€35.00€0.50matched
9capture01a1a1bf-6d59-767f-a5a5-65edea54c753€15.00€0.26matched
10capture01a1a1bf-7e53-7fb9-90c7-9633202d1d3d€15.00€0.26matched
11capture01a1a1bf-8042-7163-979e-deea1508091a€9.00€0.19matched
12capture01a1a1bf-860b-7f4b-b142-e9ccd0665643€9.00€0.19matched
13capture01a1a1bf-ae03-79a7-bb3e-4eadce1a2518€35.00€0.50matched
14capture01a1a1bf-b9d4-7f59-901a-b51fbb81c447€49.00€0.67matched
15refund01a1a1bf-cb7f-7945-915f-82598d018cc3-€11.00€0.00matched
16capture01a1a1bf-e16f-789a-b5a6-ae67f0cfc20b€35.00€0.50matched
17capture01a1a1bf-f2f6-7f15-886f-03b7098e4675€9.00€0.19matched
18refund01a1a1bf-f640-7edd-9c1f-18c9015f7516-€21.00€0.00matched
19capture01a1a1c0-0a79-7b27-9a54-42b3aa0c36ee€35.00€0.50matched
20capture01a1a1c0-2062-7da0-8317-919e06416aa2€15.00€0.26matched
21capture01a1a1c0-354b-70bb-ad42-1c249c7a47c0€24.00€0.37matched
22capture01a1a1c0-4313-7e19-92db-9d472fb5694a€15.00€0.26matched
23capture01a1a1c0-74da-7125-8074-38fe63003a0a€15.00€0.26matched
24refund01a1a1c0-8e36-7d6d-9c46-947478ebc311-€12.00€0.00matched
25capture01a1a1c0-9ba4-7c03-82b4-4c16c93d4134€9.00€0.19matched
26capture01a1a1c0-a3ab-7ea9-a858-b0a5455c13d9€24.00€0.37matched
27capture01a1a1c0-ad72-7fed-92ca-881ee02dc640€9.00€0.19matched
28capture01a1a1c0-cd40-79bc-ad71-18b5df65cb29€49.00€0.67matched
29capture01a1a1c0-d263-7dbd-87d3-b104f96f6b5a€49.00€0.67matched
30capture01a1a1c0-d84f-79e6-a250-8a30ea2ec5e7€15.00€0.26matched
31capture01a1a1c0-ed55-7690-9033-cab1c0c6d9c6€49.00€0.67matched
32capture01a1a1c0-f899-7426-9a7c-0719d1df11e4€35.00€0.50matched
33capture01a1a1c1-07f4-7a9c-9859-4b63940d1d79€35.00€0.50matched
34refund01a1a1c1-1b93-7ff5-915e-ed097c6cb6ff-€9.00€0.00matched
35capture01a1a1c1-283b-7391-a125-44afaca52647€49.00€0.67matched
36capture01a1a1c1-2954-75fc-b10d-0c36b5ec8d87€24.00€0.37matched
37capture01a1a1c1-2a0f-7730-bb34-61fcf1902c83€9.00€0.19matched
38capture01a1a1c1-4c46-7714-8c6d-ee57d9b2e46f€24.00€0.37matched
39capture01a1a1c1-617a-73c8-808f-d1ed48c35d83€49.00€0.67matched
40refund01a1a1c1-682b-7c3f-9fbe-c26942c9e9c0-€20.00€0.00matched
41capture01a1a1c1-7057-78ca-b928-05861c6e2c8c€9.00€0.19matched
42refund01a1a1c1-74c8-7e0d-8aae-c0974ecc208d-€6.00€0.00matched
43capture01a1a1c1-9d08-75e8-b0cc-cce7c1d52b52€35.00€0.50matched
44capture01a1a1c1-a866-73d7-aa1f-b7ff22f59737€49.00€0.67matched
45capture01a1a1c1-e549-70f4-aa17-902009b56a19€24.00€0.37matched
46capture01a1a1c2-0ac7-7bb4-9ea4-70a23b9da76d€49.00€0.67matched
47capture01a1a1c2-0ad0-71b6-938a-9cf0e18bcb0c€9.00€0.19matched
48capture01a1a1c2-0d80-7c2d-a290-0906a925eb70€15.00€0.26matched
49capture01a1a1c2-1d27-726a-9322-ac76a691f82b€49.00€0.67matched
50capture01a1a1c2-6525-7e0b-bd89-657ec2cbd0eb€49.00€0.67matched
51capture01a1a1c2-7481-7511-bf47-06960096c4e9€49.00€0.67matched
52capture01a1a1c2-8b63-7b1c-95a6-733a05a60150€24.00€0.37matched
53capture01a1a1c2-b463-7d90-bfd7-27b0129e4b1f€35.00€0.50matched
54capture01a1a1c2-b97c-7480-b6a5-6d02d251eb5d€9.00€0.19matched
55capture01a1a1c2-e88a-7bf3-9342-c7133caf0bd3€49.00€0.67matched
56capture01a1a1c3-0029-761b-9317-a1ddd9b50094€15.00€0.26matched
57capture01a1a1c3-2df2-789c-b183-475281a02744€24.00€0.37matched
58capture01a1a1c3-58bc-7339-baa0-1f99fc9343ca€35.00€0.50matched
59refund01a1a1c3-5bef-7179-9c64-cd23eda56b83-€5.00€0.00matched
60capture01a1a1c3-715c-7318-a417-3d4f6b4c65c8€49.00€0.67matched
61capture01a1a1c3-936a-76c3-956d-cc0d9acae6a7€15.00€0.26matched
62capture01a1a1c3-c26c-77d1-b393-118d3945ed70€9.00€0.19matched
63capture01a1a1c3-ca5e-7373-9111-82f4464a1299€35.00€0.50matched
64capture01a1a1c3-cebd-7de5-91dd-8d2560d0c905€9.00€0.19matched
65capture01a1a1c3-d4ca-709c-8bb9-ecdcb203baf1€15.00€0.26matched
66refund01a1a1c4-0371-7dde-88ea-e35f30f54881-€5.00€0.00matched
67capture01a1a1c4-3375-7f0e-902a-de8f05a10dea€35.00€0.50matched
68capture01a1a1c4-3863-734e-a5f0-58a5600346c2€24.00€0.37matched
69capture01a1a1c4-3f21-7434-b423-b3fd7d8aaf1d€15.00€0.26matched
71capture01a1a1c4-40c8-7a5c-a029-2441beed7d71€49.00€0.67matched
72capture01a1a1c4-57e0-7ab2-a3d9-27576206f541€15.00€0.26matched
73capture01a1a1c4-7006-7e2f-89a8-405ce73d85cf€49.00€0.67matched
74refund01a1a1c4-7028-708c-9940-28da204002ce-€42.00€0.00matched
75capture01a1a1c4-9d7b-7fac-b604-3e40180820c9€35.00€0.50matched
76capture01a1a1c4-9ee7-7322-a691-2793af6a210a€49.00€0.67matched
77capture01a1a1c4-a595-7a02-bffa-4b5f17e87c9a€9.00€0.19matched
78capture01a1a1c4-b12e-79f2-a5b4-91b4fa3cd2b0€49.00€0.67matched
79refund01a1a1c4-e645-7550-9e87-1edc448cc376-€7.00€0.00matched
80capture01a1a1c5-0fc2-7392-9ca5-1328feeb5078€24.00€0.37matched
81capture01a1a1c5-1dd1-7705-920d-fcd63985d3d6€9.00€0.19matched
82capture01a1a1c5-3539-7dd9-aabc-659736247559€35.00€0.50matched
84capture01a1a1c5-5ca8-716b-a83b-8f6398f054bb€24.00€0.37matched
85capture01a1a1c5-60ba-781f-97ea-3c14e06d8461€24.00€0.37matched
86capture01a1a1c5-b107-7488-86de-6ee586d3c673€9.00€0.19matched
87capture01a1a1c5-c38e-71c8-bfa0-9157147bbe50€9.00€0.19matched
88capture01a1a1c5-d30e-766f-b089-d771db739e13€35.00€0.50matched
89capture01a1a1c5-df3d-779d-a4e3-e8e1ad8701de€15.00€0.26matched
90capture01a1a1c5-e6b1-7e0e-8552-6bbc9c92372e€49.00€0.67matched
91capture01a1a1c5-fa1c-74ae-ac0f-112dcd4f02ec€9.00€0.19matched
92capture01a1a1c6-2238-7e58-b7f2-f143b1b0c138€15.00€0.26matched
93capture01a1a1c6-2e37-7cd2-9686-37de1e109945€35.00€0.50matched
94capture01a1a1c6-5f68-75a8-8f4b-e6ad5a00bf16€49.00€0.67matched
95capture01a1a1c6-62d1-7862-af7a-7912b3c01845€49.00€0.67matched
96capture01a1a1c6-7398-747d-8bde-45b7f2cdf35e€49.00€0.67matched
97capture01a1a1c6-b626-74fe-a969-7f07960db15a€15.00€0.26matched
98capture01a1a1c6-c437-721c-831a-3519e1b90680€35.00€0.50matched
99capture01a1a1c6-c7c2-7134-bbc7-1c3f8048b59a€35.00€0.50matched
100capture01a1a1c6-cd65-7157-a5b5-1f558f9979fe€35.00€0.50matched
101capture01a1a1c6-eb93-7d54-9348-2c669637ab06€15.00€0.26matched
102capture01a1a1c7-0ccd-76a9-bd40-467fc5e02322€15.00€0.26matched
103refund01a1a1c7-1253-7129-a42d-3287a471afa3-€23.00€0.00matched
104capture01a1a1c7-1bc1-73e4-ab7b-510c22a0ea1d€49.00€0.67matched
105capture01a1a1c7-1ede-7e6c-81fb-051ca99364ba€35.00€0.50matched
106capture01a1a1c7-37e6-7e84-b10c-087aae11a1a0€49.00€0.67matched
107capture01a1a1c7-4d0b-78f6-9dfc-68794258391f€49.00€0.67matched
108capture01a1a1c7-4e75-74f6-bbe8-fddd16fd5d91€49.00€0.67matched
109capture01a1a1c7-5c70-7873-9b41-79d7bcf82a95€9.00€0.19matched
110refund01a1a1c7-7049-7d5c-802e-97d0d458bb9f-€21.00€0.00matched
111capture01a1a1c7-7651-7820-836d-66013be9839f€49.00€0.67matched
112capture01a1a1c7-824a-70ff-ae51-d8767002f34b€24.00€0.37matched
113capture01a1a1c7-8ea4-7726-8422-83562c9ef363€49.00€0.67matched
114capture01a1a1c7-9ee2-703b-b1b8-8dcaf164ea2f€24.00€0.37matched
115capture01a1a1c7-b247-7ddb-91e2-7d7c9c0ff7b8€49.00€0.67matched
116capture01a1a1c7-b3a7-7614-821a-f88028341daa€15.00€0.26matched
117capture01a1a1c7-e480-7c7d-82ce-dd3493bc019e€35.00€0.50matched
118capture01a1a1c7-e591-72c5-ab51-590776e89a8f€49.00€0.67matched