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

5 Nov, 15:10

Gross

€3,001.00

PSP fee

€46.24

Net to the bank

€2,954.76

Settlement journal

#399673

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ac4b-4d39-7ccc-b10e-b1afe81669ce is already settled by stl_EUR_2989819 line 112
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
30capture01a1ac43-f524-7bcc-a3cf-5f9caf109318€35.00€0.51fee difference
113capture01a1ac4b-4d9d-7d68-bc4f-74740045e9c8€49.00€0.67duplicate line
1capture01a1ac3f-c724-7d20-8ce1-8d3bf950dbb0€24.00€0.37matched
2capture01a1ac40-c622-7b81-8597-b5ed6f27d733€15.00€0.26matched
3capture01a1ac42-8e37-7061-9925-2ebb9eb1474a€35.00€0.50matched
4capture01a1ac42-a06b-7d51-97fe-68a084cf59a3€35.00€0.50matched
5capture01a1ac42-a72b-7a91-9de7-8021917a9e10€49.00€0.67matched
6capture01a1ac42-a828-7e92-8437-20ba8e18d9c1€24.00€0.37matched
7capture01a1ac42-dbdd-7e74-a297-5f57f994b888€9.00€0.19matched
8capture01a1ac42-ef0b-76e7-8f0d-2448c60e8f0b€9.00€0.19matched
9capture01a1ac42-f205-703f-bb94-466559de9250€9.00€0.19matched
10capture01a1ac42-fe04-74dc-b9d6-d6e8e25da78d€24.00€0.37matched
11capture01a1ac43-026d-7018-906a-fe4500cc491b€35.00€0.50matched
12capture01a1ac43-0fa4-7606-a226-ab8286e1d786€24.00€0.37matched
13capture01a1ac43-134d-79f3-82a2-5c38e4f6768b€49.00€0.67matched
14capture01a1ac43-2e02-7065-8b1d-2c9b54993bd1€49.00€0.67matched
15capture01a1ac43-5c96-72df-bcd3-d6fc9044e9ed€35.00€0.50matched
16capture01a1ac43-5f20-73fa-a424-e93bb9ae9df5€15.00€0.26matched
17capture01a1ac43-6291-7515-9162-ad15de666746€24.00€0.37matched
18capture01a1ac43-6639-7394-ac26-4d324cf0631f€15.00€0.26matched
19capture01a1ac43-6975-7dd9-a198-b6015d0ae52e€24.00€0.37matched
20capture01a1ac43-7b5e-73a6-b1ce-37d6bf597e1f€35.00€0.50matched
21capture01a1ac43-adf6-7166-b616-d24ef054cf75€49.00€0.67matched
22capture01a1ac43-afa5-797b-ae18-f5b4c8d7605d€24.00€0.37matched
23refund01a1ac43-b063-7c01-b1f2-356434b2d114-€13.00€0.00matched
24refund01a1ac43-b20b-78d9-add6-cd8bb4ffbcb5-€6.00€0.00matched
25capture01a1ac43-b255-73da-a613-214f8ae72b59€35.00€0.50matched
26capture01a1ac43-b6a3-7c43-b4c3-fa72b9b81a96€35.00€0.50matched
27capture01a1ac43-be4e-7e92-a5c4-7783f4288598€35.00€0.50matched
28capture01a1ac43-c39c-7209-9b26-37aea1357a4b€35.00€0.50matched
29capture01a1ac43-c86e-7175-9580-e1c10e65615f€49.00€0.67matched
31capture01a1ac44-27ce-7b66-87a6-dc3f70be8a87€49.00€0.67matched
32capture01a1ac44-3114-75c0-83c6-87708487036b€49.00€0.67matched
33capture01a1ac44-372a-7116-98f8-c9192253aa4a€49.00€0.67matched
34capture01a1ac44-41e1-7a9d-8b30-762b36381622€9.00€0.19matched
35capture01a1ac44-4d4a-7917-9ddc-1de832ae64af€9.00€0.19matched
36capture01a1ac44-54de-733a-9677-421106a10063€49.00€0.67matched
37capture01a1ac44-72b8-74eb-8073-15c211d7671e€9.00€0.19matched
38refund01a1ac44-95e7-7f3f-be3f-bea0d565e5b9-€37.00€0.00matched
39capture01a1ac44-a3ec-70cf-a4c7-1198420be128€24.00€0.37matched
40capture01a1ac44-b1ed-7276-8702-5a950c936a44€49.00€0.67matched
41capture01a1ac44-b848-7002-ab8c-2d78b6f8e84c€9.00€0.19matched
42capture01a1ac44-fc4f-711a-8a2c-4c458298fa79€35.00€0.50matched
43capture01a1ac44-fef9-781d-a141-e7111b7e5aee€9.00€0.19matched
44capture01a1ac45-2256-7fa6-9d1a-5d02dddbac72€15.00€0.26matched
45capture01a1ac45-24c2-7c83-8aa1-f37a45eee9b1€35.00€0.50matched
46capture01a1ac45-300b-7bb8-b085-c57ac987ccee€49.00€0.67matched
47refund01a1ac45-57b7-7329-8638-fa9570c27ea0-€5.00€0.00matched
48capture01a1ac45-6e06-7fee-9d1b-8dfc6fc7e1f7€9.00€0.19matched
49capture01a1ac45-8148-704e-a8e5-9501539c6429€49.00€0.67matched
50capture01a1ac45-96b3-76aa-829c-a055aa164c0e€15.00€0.26matched
51capture01a1ac45-a6f4-703c-8490-d48a95c756b4€24.00€0.37matched
52capture01a1ac45-b716-7a75-8224-60455d6634e3€15.00€0.26matched
53capture01a1ac45-b9e2-7662-a127-4965d3eab4e4€15.00€0.26matched
54capture01a1ac45-d959-78f0-ac87-a417f69f9361€35.00€0.50matched
55capture01a1ac46-009b-7079-aefe-18511f22d976€35.00€0.50matched
56capture01a1ac46-334d-72a3-b82b-b23973c3d64e€24.00€0.37matched
57capture01a1ac46-5174-7dcc-9f8d-8eccb7f73150€35.00€0.50matched
58capture01a1ac46-6c56-7c72-b4b4-bfd0a451c504€9.00€0.19matched
59capture01a1ac46-794d-71c0-834f-c63db6618b62€35.00€0.50matched
60capture01a1ac46-921a-74f3-8f54-f778d97b9641€24.00€0.37matched
61capture01a1ac46-948e-7503-9d65-d5118411ff61€35.00€0.50matched
62capture01a1ac46-9526-722f-bcf9-f6f75dc4c0a8€35.00€0.50matched
63capture01a1ac46-a61a-752f-afc1-b0345cde5d34€9.00€0.19matched
64capture01a1ac46-b62b-7244-87aa-460296821827€9.00€0.19matched
65capture01a1ac46-fcfc-7ecd-bf21-fb782a7ffabf€15.00€0.26matched
66capture01a1ac47-3f93-7a7b-a7aa-b6a4ac80ccfa€49.00€0.67matched
67capture01a1ac47-5798-7150-ae25-4ca84430d00b€35.00€0.50matched
68capture01a1ac47-c082-7236-9302-b7d4606e9f81€24.00€0.37matched
69capture01a1ac48-0dc6-7881-bd2b-026c3f37aabc€24.00€0.37matched
70capture01a1ac48-187b-7615-a6b2-9f23cf65b5c8€49.00€0.67matched
71capture01a1ac48-4878-75ca-b118-294ca7b7a332€35.00€0.50matched
72capture01a1ac48-580a-7cc2-9c02-06fef1c72b9f€49.00€0.67matched
73capture01a1ac48-5bc6-75da-96f1-b574ea8c2a13€15.00€0.26matched
74refund01a1ac48-92c4-79a9-b0b9-d14a3da3930d-€11.00€0.00matched
75capture01a1ac48-9fd7-7aa6-bee2-637d0f05649a€9.00€0.19matched
76capture01a1ac48-b608-784a-8f6a-03a5bf7e5dee€49.00€0.67matched
77capture01a1ac48-cc88-79bf-a274-c886ef2eb540€15.00€0.26matched
78capture01a1ac48-d4b6-79fe-a0d8-ef44dd48d536€24.00€0.37matched
79capture01a1ac48-d87d-7bdc-b233-011332b2b386€24.00€0.37matched
80capture01a1ac49-2546-788b-9408-58e4480e7e67€9.00€0.19matched
81capture01a1ac49-28bc-75eb-a4c3-031cebbce7e5€24.00€0.37matched
82capture01a1ac49-3483-7f67-9214-e55899ecaff7€35.00€0.50matched
83capture01a1ac49-444f-79b1-8f8f-4c528c979538€49.00€0.67matched
84capture01a1ac49-4d9e-7906-8f63-ecdaaf429f4b€15.00€0.26matched
85capture01a1ac49-4ff3-783f-bc70-f4c10d2324a6€35.00€0.50matched
86capture01a1ac49-52cf-7fa2-a810-496e29a428f9€24.00€0.37matched
87capture01a1ac49-59f0-7698-a76b-2976a1dbc0e7€24.00€0.37matched
88capture01a1ac49-60d7-7fb3-969f-b5cfb6ea732b€24.00€0.37matched
89capture01a1ac49-635b-747b-8bae-8eb65b6c1f5d€35.00€0.50matched
90capture01a1ac49-8f79-77d2-b1ef-e3c593d3c426€9.00€0.19matched
91capture01a1ac49-9370-7437-9f39-7d58d4a114dd€15.00€0.26matched
92capture01a1ac49-9770-7278-94fe-4d04d0144578€35.00€0.50matched
93refund01a1ac49-9e97-7017-98e8-7b28d70d4107-€9.00€0.00matched
94capture01a1ac49-a23b-7644-96bb-422dafe8336c€24.00€0.37matched
95capture01a1ac49-c11a-70fc-9c8b-e6f8f8d9982f€9.00€0.19matched
96capture01a1ac49-d486-7fdb-bef1-f0ae15180aad€49.00€0.67matched
97capture01a1ac49-f1a7-765c-bb7b-4239cac01530€24.00€0.37matched
98capture01a1ac4a-0e79-79c8-856f-e2fd189bd0bc€24.00€0.37matched
99capture01a1ac4a-234e-7029-b3a8-f64f5112fc7f€49.00€0.67matched
100capture01a1ac4a-2dd7-7cd8-ac94-8975b0c4b431€35.00€0.50matched
101capture01a1ac4a-3371-73ed-bad3-ca564600e064€49.00€0.67matched
102capture01a1ac4a-634a-75b0-980e-a7e79d870b3a€49.00€0.67matched
103refund01a1ac4a-710b-76c7-87e1-f52c95ff67ba-€18.00€0.00matched
104refund01a1ac4a-8a85-705b-bff8-8a81a2658f01-€28.00€0.00matched
105capture01a1ac4a-ac30-7249-b34c-1fe5d9b1654f€49.00€0.67matched
106capture01a1ac4a-bb6d-78d8-a2fe-15345a44984e€24.00€0.37matched
107capture01a1ac4a-fcbf-78d2-b6c1-825f758e0e96€49.00€0.67matched
108capture01a1ac4b-07de-75c6-9819-2835621406c5€35.00€0.50matched
109capture01a1ac4b-0ba3-72d6-bb47-05d22249c91e€49.00€0.67matched
110capture01a1ac4b-14d0-77e9-95f4-d3dc00b7c1bc€15.00€0.26matched
111capture01a1ac4b-289f-71a4-a692-4296a3aca312€35.00€0.50matched
112capture01a1ac4b-4d9d-7d68-bc4f-74740045e9c8€49.00€0.67matched
114capture01a1ac4b-7993-7777-91fe-0806a6c547ca€9.00€0.19matched
115capture01a1ac4b-95b7-763b-84d3-b60ff4acd163€9.00€0.19matched