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

28 Oct, 22:30

Gross

€2,823.00

PSP fee

€44.00

Net to the bank

€2,779.00

Settlement journal

#258981

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a184a4-72f3-7627-a8af-721b6bc09fb4 is already settled by stl_EUR_2988711 line 26
  • duplicate linethe file lists it twicecapture:01a184a6-9aa7-7579-ab84-96edad522f4e is already settled by stl_EUR_2988711 line 66
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
27capture01a184a4-7602-7175-8046-e180cfb19fec€24.00€0.37duplicate line
37capture01a184a4-f61c-7ca1-b496-84e7a991f0b9€9.00€0.21fee difference
67capture01a184a6-9c4f-767e-8624-5b3999b82d53€49.00€0.67duplicate line
1capture01a1849b-1270-7e4c-935b-3834a85f63f2€15.00€0.26matched
2capture01a1849c-bfb4-7367-ad98-0901ddd6de7b€35.00€0.50matched
3capture01a184a2-8301-74d1-afc1-10c39fc6f4ac€24.00€0.37matched
4capture01a184a2-a201-73d3-9f6c-7ed8f55fec98€9.00€0.19matched
5capture01a184a2-aeef-7418-b210-4785b83d19d0€15.00€0.26matched
6capture01a184a2-fa25-788d-bc25-5250686ca5a8€24.00€0.37matched
7capture01a184a3-1ce0-75e0-a4e5-b9bdecb8e39c€24.00€0.37matched
8capture01a184a3-25a0-7b91-8a5f-8597ade9239d€35.00€0.50matched
9capture01a184a3-5353-7938-948b-6b94f0653389€49.00€0.67matched
10capture01a184a3-6867-7a36-8b1b-4437a7375059€24.00€0.37matched
11capture01a184a3-76e0-746e-8878-06f7a12ba40b€24.00€0.37matched
12capture01a184a3-8bb5-7eee-8bbe-0d2a8a1f4b56€9.00€0.19matched
13capture01a184a3-8d14-75ca-84df-37418394e74e€35.00€0.50matched
14capture01a184a3-8f0c-75ea-953c-18ac1df3e42d€24.00€0.37matched
15capture01a184a3-a94f-7d26-859e-ffea3f4083df€24.00€0.37matched
16capture01a184a3-9e49-7041-a0bc-fdd03175ae34€15.00€0.26matched
17capture01a184a3-c531-7030-901f-08c8616eb80c€9.00€0.19matched
18capture01a184a3-d975-77bf-bb4c-2ebc7f137e3b€35.00€0.50matched
19capture01a184a3-e0c3-71dd-a7d6-e37ac652ed26€24.00€0.37matched
20capture01a184a3-e7eb-7793-b426-08dac70e2ac1€35.00€0.50matched
21capture01a184a3-ef3b-7030-b750-0aa0c9dd8b97€24.00€0.37matched
22capture01a184a4-1c80-7798-872a-ee1c453bdeab€9.00€0.19matched
23capture01a184a4-2d9c-7a90-adf6-e9b6d786f336€24.00€0.37matched
24capture01a184a4-492b-78e3-a429-67c4f72ba676€24.00€0.37matched
25capture01a184a4-67e7-7746-86b2-2eaa3a080564€35.00€0.50matched
26capture01a184a4-7602-7175-8046-e180cfb19fec€24.00€0.37matched
28capture01a184a4-8372-7e2e-b42c-63f560778704€35.00€0.50matched
29capture01a184a4-85b5-7a48-9e67-43fa0ea676d6€24.00€0.37matched
30capture01a184a4-8ebf-72e7-a1cb-cbe78401f054€9.00€0.19matched
31capture01a184a4-a011-785d-8356-e7a22f8516f3€35.00€0.50matched
32capture01a184a4-a147-7e5e-96ef-63d4b4f4a7ed€9.00€0.19matched
33capture01a184a4-c52d-7917-b61d-537fe9bd970a€49.00€0.67matched
34capture01a184a4-c539-7c2d-9924-4717e9a51648€49.00€0.67matched
35capture01a184a4-d3cb-7fab-90bd-656f4b059549€35.00€0.50matched
36capture01a184a4-dd88-7da2-b3b8-7d02c6e1d919€24.00€0.37matched
38refund01a184a4-f79e-7301-839f-347f8c246b53-€4.00€0.00matched
39capture01a184a5-0a79-7dec-bc59-63a7843235ff€49.00€0.67matched
40capture01a184a5-0ee5-774e-a74e-53a9bd231cd8€35.00€0.50matched
41refund01a184a5-2ac7-7aa0-a608-ea7d01bbcfba-€41.00€0.00matched
42refund01a184a5-3f20-7abc-b250-fd479df76da2-€2.00€0.00matched
43capture01a184a5-4490-7495-8372-d8ebd1144010€49.00€0.67matched
44capture01a184a5-72ea-7337-a136-f1457316df7d€9.00€0.19matched
45capture01a184a5-93ac-7bf9-a4cc-b5dc9ad08d25€15.00€0.26matched
46capture01a184a5-bf78-713f-847e-0984aa1bd10a€35.00€0.50matched
47capture01a184a5-c5cc-79c9-a39c-5b83beb37933€9.00€0.19matched
48capture01a184a5-c94c-7f3c-a267-3d1721d3efb5€49.00€0.67matched
49capture01a184a5-ca81-7bb7-ab16-ab60ec987722€9.00€0.19matched
50capture01a184a5-e1dc-7604-a4d3-5679d02808f3€49.00€0.67matched
51capture01a184a5-e391-78c1-abc9-23a0671408a1€35.00€0.50matched
52capture01a184a5-fdcc-752c-aa2c-50fca1df4170€49.00€0.67matched
53capture01a184a6-2a32-721a-b2ea-82f3ef92d8b9€35.00€0.50matched
54capture01a184a6-2c31-70ca-9799-22485d4be82c€35.00€0.50matched
55capture01a184a6-30b5-71ff-9445-a6329060dbf2€15.00€0.26matched
56capture01a184a6-427d-74a0-9dfd-fab8fed0c338€49.00€0.67matched
57capture01a184a6-5b15-7c29-932b-13850c921669€49.00€0.67matched
58capture01a184a6-5f44-78e2-bd8c-38ac598cde05€49.00€0.67matched
59capture01a184a6-71a5-7467-a795-2de2b6f635ea€9.00€0.19matched
60capture01a184a6-7294-7c5c-ab6f-b8db5e542d2a€49.00€0.67matched
61capture01a184a6-84a2-7dce-ab9f-7c7f3e271932€24.00€0.37matched
62capture01a184a6-8608-7cf2-b195-452b95212293€9.00€0.19matched
63capture01a184a6-88ea-777c-a395-ec7775bf5924€9.00€0.19matched
64capture01a184a6-8fa9-7625-8758-820925a4205b€15.00€0.26matched
65capture01a184a6-98f1-7c88-9581-2fa90e911ef9€49.00€0.67matched
66capture01a184a6-9c4f-767e-8624-5b3999b82d53€49.00€0.67matched
68capture01a184a6-a1bb-792a-9296-95244d854e5c€49.00€0.67matched
69capture01a184a6-b7e6-7b94-b9c8-9ade02fbd798€9.00€0.19matched
70capture01a184a6-fc83-7c0e-afdb-f6d2d9c289c1€9.00€0.19matched
71refund01a184a6-fd01-794e-bad9-eacf8f64a833-€47.00€0.00matched
72capture01a184a7-3056-7f83-b5c0-6c4ed16adf0d€35.00€0.50matched
73capture01a184a7-437d-752d-b39d-fd6556095895€35.00€0.50matched
74capture01a184a7-6f94-70d8-8408-428e9572f2cc€49.00€0.67matched
75capture01a184a7-72c9-7ac0-be20-4a15b51db9a5€9.00€0.19matched
76capture01a184a7-9a1e-7db0-a76c-b38c68ba59af€9.00€0.19matched
77refund01a184a7-a623-7549-8980-ea214493bbfe-€9.00€0.00matched
78capture01a184a7-b10d-7eb0-9677-a7dc71822e2f€24.00€0.37matched
79capture01a184a7-b51f-7d51-904d-0c40d55d096f€15.00€0.26matched
80capture01a184a7-b795-731e-bcb1-a21d4e03c291€9.00€0.19matched
81capture01a184a7-e47d-74a0-8e37-462351f6e59b€49.00€0.67matched
82capture01a184a7-fea9-7f95-958a-73959fd2a198€49.00€0.67matched
83capture01a184a8-0c5d-755a-b58f-00ad20172f87€24.00€0.37matched
84capture01a184a8-1fa9-7a31-ad65-db5685454007€35.00€0.50matched
85capture01a184a8-223d-77a5-a9c7-1019ac5470c1€9.00€0.19matched
86capture01a184a8-3666-7791-b1de-fa859b2ef1af€9.00€0.19matched
87capture01a184a8-5120-7e72-8f3c-846f54e27e29€24.00€0.37matched
88capture01a184a8-5880-76f2-92fe-e1fd9ed406f6€24.00€0.37matched
89capture01a184a8-a52c-7117-944c-b94e7fefc5eb€15.00€0.26matched
90capture01a184a8-d4fb-7779-a940-5f2ae1bc263d€35.00€0.50matched
91capture01a184a9-3149-7128-9451-4af536923f99€24.00€0.37matched
92capture01a184a9-6f10-7641-90ac-a80e98ccb6d1€15.00€0.26matched
93capture01a184a9-8ed8-7b45-9932-1c4e2fb5b946€49.00€0.67matched
94capture01a184a9-906c-7a1b-8423-d4febef1c4e8€49.00€0.67matched
95capture01a184a9-b64f-79f6-a08b-fb968c7230e0€49.00€0.67matched
96capture01a184a9-d259-7421-b5de-1af92952827d€9.00€0.19matched
97capture01a184a9-e383-7cf7-a475-762533d22cd8€9.00€0.19matched
98capture01a184a9-f9bf-7269-b2b7-d0a2ca16e4a1€9.00€0.19matched
99capture01a184aa-1e2d-7529-b8c1-6f0cf549b75a€15.00€0.26matched
100capture01a184aa-3828-7393-ad65-a47db9bd74ee€15.00€0.26matched
101capture01a184aa-39ea-75a0-92c1-a731715e9cf7€49.00€0.67matched
102capture01a184aa-5540-7fbd-8cef-04e9729b3bac€9.00€0.19matched
103capture01a184aa-7336-7497-a636-493b7d30843d€15.00€0.26matched
104capture01a184aa-78c1-76d5-9679-095dc581e280€49.00€0.67matched
105capture01a184aa-855b-77d6-93b0-7b9c2f70bdc9€9.00€0.19matched
106capture01a184aa-9ac9-7280-8faa-857db696a580€35.00€0.50matched
107capture01a184aa-a132-7089-81ca-6cdb823954fc€35.00€0.50matched
108capture01a184aa-dd14-78a9-8e69-37f4e677b35a€15.00€0.26matched
109capture01a184ab-184a-75d7-842d-a53141904676€49.00€0.67matched
110capture01a184ab-32f7-7d63-bf4c-cf65c7a64b85€15.00€0.26matched
111capture01a184ab-4784-77fd-8e4b-22a42e26dba4€9.00€0.19matched
112capture01a184ab-4892-79a0-9932-7543c5162f80€9.00€0.19matched
113capture01a184ab-69aa-762c-9783-0b68d81df124€35.00€0.50matched
114capture01a184ab-81be-7ab6-848d-eb635499d494€9.00€0.19matched