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, 03:20

Gross

€2,972.00

PSP fee

€45.03

Net to the bank

€2,926.97

Settlement journal

#354197

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a19f6b-becd-7be8-be18-9e2abdfa4896 is already settled by stl_EUR_2989460 line 2
LineKindReferenceGrossFeeStatus
3refund01a19f6b-bed0-77d7-b1bd-4c54501f6ffa-€9.00€0.00duplicate line
1capture01a19f67-03ca-7cf6-ac97-1e9d9bf884db€49.00€0.67matched
2refund01a19f6b-bed0-77d7-b1bd-4c54501f6ffa-€9.00€0.00matched
4capture01a19f6c-11b1-7a2d-b4e1-ac559c58998c€35.00€0.50matched
5capture01a19f6c-2c41-764c-9aac-fca3b29bff56€49.00€0.67matched
6capture01a19f6c-5fd0-7008-871f-9932ad7f29e8€15.00€0.26matched
7capture01a19f6c-77b2-79ff-9bb4-dfca5e8155e8€35.00€0.50matched
8capture01a19f6c-81d0-7e12-8f00-7b01e9317f19€35.00€0.50matched
9capture01a19f6c-9140-7748-b22a-1934236ed0b5€49.00€0.67matched
10capture01a19f6c-a09b-783c-8d54-b97ed059e03a€24.00€0.37matched
11capture01a19f6c-b59d-7576-8966-23b68252f0af€35.00€0.50matched
12capture01a19f6c-b766-70d7-bce5-afa28ca406d2€35.00€0.50matched
13capture01a19f6c-bcdb-7907-95b0-2089b17bf929€35.00€0.50matched
14capture01a19f6c-d299-715f-ae80-e092a56e299b€24.00€0.37matched
15refund01a19f6c-e4fd-74a3-af08-56296c91a0f2-€18.00€0.00matched
16capture01a19f6c-e54f-7f00-9f25-517725e69ada€49.00€0.67matched
17capture01a19f6c-fc1d-7374-965f-5fd428bab5ae€49.00€0.67matched
18capture01a19f6d-07b4-756e-ab36-d1fabcdde5bb€49.00€0.67matched
19capture01a19f6d-0998-73ed-907e-f65e9b5cead4€9.00€0.19matched
20capture01a19f6d-2541-7efc-b694-00802b2b4a2b€49.00€0.67matched
21capture01a19f6d-2a81-7ce1-a3af-344903339ad7€9.00€0.19matched
22capture01a19f6d-416c-7dce-8cb3-6b51646123f3€49.00€0.67matched
23capture01a19f6d-41db-7284-bc26-1179959c7480€15.00€0.26matched
24capture01a19f6d-50d0-75e4-a74b-fc493e2357a4€24.00€0.37matched
25capture01a19f6d-61a2-7f2d-ad5d-f4adab2209ee€49.00€0.67matched
26capture01a19f6d-b20d-71e9-87e7-42aa732633d7€35.00€0.50matched
27capture01a19f6d-dcf7-7131-82c1-81c7c3162846€9.00€0.19matched
28capture01a19f6d-e2af-7364-806c-453349ee490a€35.00€0.50matched
29refund01a19f6e-14a0-752b-a6be-457840352e77-€7.00€0.00matched
30capture01a19f6e-1634-73ee-9404-1057065503f2€35.00€0.50matched
31capture01a19f6e-1a14-7450-87f0-de07e446c927€24.00€0.37matched
32capture01a19f6e-2a49-7c85-80a6-d516acf00750€9.00€0.19matched
33capture01a19f6e-2f80-70b4-9ff4-c635a1bcc869€49.00€0.67matched
34capture01a19f6e-45aa-762d-8d16-c376c9cb3acd€35.00€0.50matched
35refund01a19f6e-59a8-724a-bdb5-7a9fd1594f8a-€16.00€0.00matched
36capture01a19f6e-65e0-7917-a388-3072337f5363€15.00€0.26matched
37capture01a19f6e-672d-727d-8af6-a9c8b282b8e3€49.00€0.67matched
38capture01a19f6e-745a-73b1-b72a-9d179952586a€24.00€0.37matched
39capture01a19f6e-7d65-7f7d-b27c-dddadfe2f189€9.00€0.19matched
40capture01a19f6e-84ea-7272-84e5-e75db5a91b24€49.00€0.67matched
41capture01a19f6e-9096-7c7c-9c23-e25c051e6756€49.00€0.67matched
42capture01a19f6e-ab5b-740e-9bfd-1a15a58c94ec€9.00€0.19matched
43capture01a19f6e-b7e4-7357-8508-44cbfda02dbe€24.00€0.37matched
44capture01a19f6e-be92-7d2f-a536-68c6545bc95f€49.00€0.67matched
45capture01a19f6e-c04b-70c3-9be0-d6490801c300€15.00€0.26matched
46capture01a19f6e-c95e-7696-b15e-6d548e834f46€49.00€0.67matched
47capture01a19f6e-d88b-7e74-92f9-2d45a18e270e€24.00€0.37matched
48capture01a19f6e-dd35-71bb-9efa-07b03c0746ac€15.00€0.26matched
49capture01a19f6e-f5e1-7e81-aae8-74e4ca5ddd57€15.00€0.26matched
50capture01a19f6e-f85d-717d-aee3-fe901ef6c5b2€15.00€0.26matched
51capture01a19f6f-0780-7ebd-9c1c-0f92305eaaf1€49.00€0.67matched
52capture01a19f6f-0882-73a3-a578-c80e0b6668fb€49.00€0.67matched
53capture01a19f6f-2440-7206-8bb5-d42d18c599b6€35.00€0.50matched
54capture01a19f6f-2940-7fa6-a912-db7e779cc048€24.00€0.37matched
55capture01a19f6f-48e8-7aa3-a06b-ae7f4422e910€9.00€0.19matched
56capture01a19f6f-4bc2-7b3a-af09-3d5b5bb55bf0€35.00€0.50matched
57capture01a19f6f-6f6c-7803-8041-2a016d43fd2b€9.00€0.19matched
58capture01a19f6f-866f-7f51-bef5-21becf8726d7€49.00€0.67matched
59capture01a19f6f-b4eb-7e5f-8ed2-cf2d3892f338€35.00€0.50matched
60capture01a19f6f-b873-7e40-835b-979459034d9d€24.00€0.37matched
61capture01a19f6f-d994-7ceb-aebc-b471c4d5111c€9.00€0.19matched
62capture01a19f6f-ef55-7c0e-abd3-335de2e8d881€24.00€0.37matched
63capture01a19f6f-febb-7e54-b743-cb6291f56ca7€15.00€0.26matched
64capture01a19f70-0030-7bc1-ac3f-0bdce2ea2a41€15.00€0.26matched
65capture01a19f70-1553-7356-92e3-88e321d2f94f€15.00€0.26matched
66refund01a19f70-1bf0-7ce3-bc7e-654d1c0f27cf-€5.00€0.00matched
67capture01a19f70-495d-775a-a891-8d4e5aa2f92a€9.00€0.19matched
68refund01a19f70-4c5a-787e-870c-308cdd88fb4f-€12.00€0.00matched
69refund01a19f70-6266-7f21-8b0a-22df93cbb3c4-€5.00€0.00matched
70capture01a19f70-7bdb-778c-b635-08114f4329e5€24.00€0.37matched
71capture01a19f70-9a07-7ed3-956a-b0fd6cdf8abb€15.00€0.26matched
72capture01a19f70-a3e8-7bf4-a055-dae81c7540ce€49.00€0.67matched
73capture01a19f70-af44-754f-b9e7-3a408aeb9e59€15.00€0.26matched
74capture01a19f70-cac1-7574-abda-1e11de32eef8€49.00€0.67matched
75capture01a19f70-f51d-724a-915b-e3923e883ef9€49.00€0.67matched
76capture01a19f70-fc56-7fb3-bd36-2c38bb842f56€24.00€0.37matched
77capture01a19f71-4733-74b2-bd9c-3042485e65e2€9.00€0.19matched
78capture01a19f71-66c0-7dff-8dfd-f3e2eef638ac€15.00€0.26matched
79capture01a19f71-acc8-7aaa-8eaf-8f37c83862cb€49.00€0.67matched
80capture01a19f71-b4bc-7ecc-b27f-2e03776bcdff€15.00€0.26matched
81capture01a19f71-b600-7726-a56f-7888a3d9eb11€35.00€0.50matched
82capture01a19f71-ddcc-7bb1-b989-fe8ed7e18e8f€35.00€0.50matched
83refund01a19f71-fb8c-78e8-ae43-008585d7d843-€23.00€0.00matched
84capture01a19f72-1cbc-7f02-94e0-184090ddcbea€15.00€0.26matched
85capture01a19f72-45d2-7e2a-ad27-cc334de39487€35.00€0.50matched
86capture01a19f72-595b-7d2a-9947-58871ad7356f€24.00€0.37matched
87capture01a19f72-5f0e-74d2-b80f-1a3247fda3a9€35.00€0.50matched
88capture01a19f72-74a8-7d25-86f5-f43e797b6165€15.00€0.26matched
89capture01a19f72-8df7-7fe5-b700-4c4af381152c€49.00€0.67matched
90capture01a19f72-c74e-7c36-95a1-50ce8579b010€49.00€0.67matched
91capture01a19f72-cfd4-76ab-b4a9-05d813217f73€35.00€0.50matched
92capture01a19f73-06ba-7780-9119-7343acce2dda€49.00€0.67matched
93capture01a19f73-0de4-7c39-a71d-05dbd36c087e€35.00€0.50matched
94capture01a19f73-255f-75e4-be36-c35d3cb848f0€49.00€0.67matched
95capture01a19f73-60ca-78b9-88ed-50fc77338e02€35.00€0.50matched
96capture01a19f73-718e-7dcc-adb5-1661a4c47ba8€49.00€0.67matched
97capture01a19f73-9c1d-7c79-bc8a-4cd6ff8b701b€15.00€0.26matched
98capture01a19f73-a83d-7b3a-9b9b-4aa5122b5f19€9.00€0.19matched
99capture01a19f73-ad9a-7030-872f-b5b02a561541€49.00€0.67matched
100capture01a19f73-deba-7366-a2a4-2762b8ff0611€35.00€0.50matched
101capture01a19f74-0720-739b-9060-06f67ad6914e€49.00€0.67matched
102capture01a19f74-13a3-765f-aab7-2cbe390d9c37€49.00€0.67matched
103capture01a19f74-1a0d-71a2-a352-be26186ce432€9.00€0.19matched
104capture01a19f74-48e9-7d2a-a732-f1c46a851196€15.00€0.26matched
105capture01a19f74-74d1-7d78-82b8-ea873bed1909€24.00€0.37matched
106capture01a19f74-808c-747a-9369-44dd9e68dfdd€49.00€0.67matched
107capture01a19f74-8722-78e4-b1ed-fe4a45f2ae17€35.00€0.50matched
108capture01a19f74-93d5-7354-b3ec-8eb5a3ab79b3€49.00€0.67matched
109capture01a19f74-afd4-71cf-b7f9-3a96e8c0a0af€15.00€0.26matched