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

20 Oct, 06:00

Gross

€2,609.00

PSP fee

€42.03

Net to the bank

€2,566.97

Settlement journal

#100379

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a157ec-1291-7c23-9dba-38d587eb7a25 is already settled by stl_EUR_2987460 line 84
LineKindReferenceGrossFeeStatus
85refund01a157ec-1292-7a69-ac71-34fc5d5c6540-€20.00€0.00duplicate line
1capture01a157e0-02ae-7d3a-b45d-f4dac5e455c0€24.00€0.37matched
2capture01a157e0-ea43-72ba-a349-81b94dbd5f1b€15.00€0.26matched
3capture01a157e2-b3f7-7d20-b309-611a11ef645b€24.00€0.37matched
4capture01a157e4-f3ba-7746-9d60-efb91136436a€15.00€0.26matched
5capture01a157e5-3eef-73c4-bd5f-5782c48460b8€49.00€0.67matched
6capture01a157e5-3f1a-7ddc-9412-6c12fb5d5b9b€49.00€0.67matched
7capture01a157e5-795e-761c-a6cf-4a64575a3aab€9.00€0.19matched
8capture01a157e5-ac52-7764-b86e-7906c0adc937€15.00€0.26matched
9capture01a157e5-cbba-7cb4-aea8-3d572de0e94d€15.00€0.26matched
10capture01a157e5-de83-7c59-936e-5f9873ba7bcd€24.00€0.37matched
11capture01a157e5-f997-7050-883b-ed551fdc175f€35.00€0.50matched
12capture01a157e6-144b-7445-ab08-01b7a80126c1€24.00€0.37matched
13capture01a157e6-1f83-79fe-960f-a02ad011d8e7€9.00€0.19matched
14capture01a157e6-675b-7473-bf45-8391aa7d7ee5€35.00€0.50matched
15capture01a157e6-6842-79d4-ba69-efdbc5f731c5€24.00€0.37matched
16capture01a157e6-8a0a-7d33-96e4-55cb86093d58€15.00€0.26matched
17capture01a157e6-b131-7560-a84c-cb18b0b8fa78€35.00€0.50matched
18capture01a157e6-d2cb-7f35-b781-cfaa3812a0de€15.00€0.26matched
19refund01a157e6-dd31-7760-9aec-ce3dc687360d-€21.00€0.00matched
20refund01a157e6-f30e-7708-820f-7ce5b836ae6c-€8.00€0.00matched
21capture01a157e7-063e-7819-84b8-a229d02c0766€49.00€0.67matched
22capture01a157e7-2324-7033-9230-2c44e4a8956d€24.00€0.37matched
23capture01a157e7-273c-7288-8b94-6cb31004da81€24.00€0.37matched
24capture01a157e7-36f4-725d-ab38-ec2916acd44f€49.00€0.67matched
25capture01a157e7-3b91-7199-bd6d-963b2f759d75€9.00€0.19matched
26capture01a157e7-42d6-743f-8cdd-b077c14d1833€15.00€0.26matched
27capture01a157e7-46fb-739d-a8d7-db85bebe3308€15.00€0.26matched
28capture01a157e7-4ccf-793c-b8df-4a39b36e2b9e€24.00€0.37matched
29capture01a157e7-51e8-7f36-a9fa-41d56c595557€24.00€0.37matched
30capture01a157e7-62e0-7134-8b84-fec17c82d25f€24.00€0.37matched
31capture01a157e7-6ad2-7a9c-926a-59eedc6c5077€24.00€0.37matched
32capture01a157e7-9061-7a1c-996b-acb04e72d499€9.00€0.19matched
33capture01a157e7-93cb-7c64-b858-93f4016d4cc9€9.00€0.19matched
34capture01a157e7-a238-71d3-b7de-f6282da45b9a€24.00€0.37matched
35capture01a157e7-a99d-7787-ba79-ef792b9c396a€35.00€0.50matched
36capture01a157e7-d043-79d0-b88b-74fbfae0f776€9.00€0.19matched
37refund01a157e7-d502-7d0f-a32d-84feaa0cc10f-€10.00€0.00matched
38capture01a157e8-1313-7fc1-a7bc-07b712024fdd€9.00€0.19matched
39capture01a157e8-139c-70c6-8298-aea7a1e8cc01€24.00€0.37matched
40refund01a157e8-1e49-7627-a1ee-7cc16f6b4cbb-€16.00€0.00matched
41capture01a157e8-2c17-7763-bdc9-ea386d6fa548€9.00€0.19matched
42capture01a157e8-8e1d-7762-adad-9ca2b4926bc1€35.00€0.50matched
43capture01a157e8-8fa1-7566-b9be-3f4c7a470397€24.00€0.37matched
44capture01a157e8-aa3a-7576-944e-b978caa937a6€35.00€0.50matched
45capture01a157e8-ca72-796d-b71f-b80f312a7451€15.00€0.26matched
46capture01a157e8-d55e-7d82-9b97-2f9ccf3a26a0€49.00€0.67matched
47capture01a157e8-d5db-7e45-b842-9fbb9cdc6361€35.00€0.50matched
48capture01a157e8-eec7-726c-93cc-11ffd9e623d7€35.00€0.50matched
49capture01a157e9-604a-71a5-bd3c-290fda7ac692€24.00€0.37matched
50capture01a157e9-c912-7e9a-a6f6-fc38c44de082€9.00€0.19matched
51capture01a157e9-ec3a-76e7-9cb7-902b1e65fa06€9.00€0.19matched
52capture01a157e9-f8bc-748e-94cf-353205b637a1€24.00€0.37matched
53capture01a157ea-15fe-7376-8c62-32248c0cac39€49.00€0.67matched
54refund01a157ea-417b-708d-a47c-6128166f906b-€22.00€0.00matched
55capture01a157ea-423f-7577-bfe5-1f55e2e7cf39€15.00€0.26matched
56capture01a157ea-4757-7329-9983-d6b5b5980222€49.00€0.67matched
57capture01a157ea-4955-7f96-9e46-8f43de174d88€35.00€0.50matched
58capture01a157ea-51bd-7d41-b883-7819a61ce9d1€15.00€0.26matched
59capture01a157ea-a986-7693-b075-94e3ab8d770e€24.00€0.37matched
60capture01a157ea-af9d-7a1b-bbae-f2e26425eeb0€15.00€0.26matched
61capture01a157ea-bb98-7755-b12c-b3bfc97fa594€9.00€0.19matched
62capture01a157ea-bd9f-7666-b584-0eb1dfc34d31€9.00€0.19matched
63capture01a157ea-c201-719d-babe-dd3b54e9793a€9.00€0.19matched
64capture01a157ea-d3ca-7f32-9e7f-f65692e74441€49.00€0.67matched
65capture01a157ea-d73d-7f9b-a2ed-0633d7df47aa€15.00€0.26matched
66capture01a157ea-ea0b-7659-a6ef-30b1d0e64c87€15.00€0.26matched
67capture01a157ea-f849-70e6-a04a-4116e3d01221€9.00€0.19matched
68capture01a157ea-ff3e-727a-ade6-762abccb5754€35.00€0.50matched
69capture01a157eb-03e6-742b-b553-fbf51024bc2e€35.00€0.50matched
70capture01a157eb-35aa-7a43-8efe-0089fd67c72b€24.00€0.37matched
71capture01a157eb-4ba7-7066-b634-45d768773c09€35.00€0.50matched
72capture01a157eb-521e-7ce7-8c04-b2569b903191€35.00€0.50matched
73capture01a157eb-52cd-78a8-a61a-3a354d65c998€49.00€0.67matched
74refund01a157eb-564b-73f7-a4f5-b7e0aa2fa68c-€22.00€0.00matched
75refund01a157eb-5d13-7874-a89b-7475dc4bbdfd-€10.00€0.00matched
76capture01a157eb-8400-7904-8f3c-c335ab784596€24.00€0.37matched
77capture01a157eb-9668-7883-bf9a-9b2726c4285e€9.00€0.19matched
78capture01a157eb-94c2-7578-80d0-0b595ff41ca2€24.00€0.37matched
79capture01a157eb-9f53-779c-91e9-262d4d1689aa€9.00€0.19matched
80capture01a157eb-bb4c-7316-94dc-7d9dda13340a€35.00€0.50matched
81capture01a157eb-c991-7cc3-8898-a063435e1da0€49.00€0.67matched
82capture01a157eb-fbf2-72d6-956e-4ad0c7f4e6c5€24.00€0.37matched
83refund01a157ec-0212-7e7d-b9ab-baefb0051a6a-€4.00€0.00matched
84refund01a157ec-1292-7a69-ac71-34fc5d5c6540-€20.00€0.00matched
86capture01a157ec-25fe-7dff-8d3d-c4f8561e82df€24.00€0.37matched
87capture01a157ec-4283-798a-9f51-02b3cb102c50€24.00€0.37matched
88capture01a157ec-50cc-7857-aa31-6ccffa49744e€35.00€0.50matched
89capture01a157ec-69bc-751c-8209-9e5c928c0ac8€49.00€0.67matched
90capture01a157ec-785f-753b-a4d9-6764ef39d977€49.00€0.67matched
91capture01a157ec-89df-7460-af67-552beb4086b9€9.00€0.19matched
92capture01a157ec-9322-7c0b-aaba-00db3d8767c1€24.00€0.37matched
93refund01a157ec-9c5b-7f8d-bcad-f669f3cc7dce-€9.00€0.00matched
94capture01a157ec-be1a-768c-b239-3c83414bb8e6€24.00€0.37matched
95capture01a157ec-cf9c-7066-8fd5-b88e5da9104c€15.00€0.26matched
96capture01a157ec-d4b7-777f-aea6-aabb3e670877€49.00€0.67matched
97capture01a157ec-d82a-7d09-b04a-cb5cbff490c0€35.00€0.50matched
98capture01a157ec-df14-7eb1-8bf6-bd4fd463ea9e€15.00€0.26matched
99capture01a157ec-eb16-7ab7-8e6c-9a7dd4efe81d€24.00€0.37matched
100capture01a157ec-eded-7003-b47e-63928a6a554d€24.00€0.37matched
101capture01a157ec-f2a3-7ab9-a462-19e0e8db146d€15.00€0.26matched
102capture01a157ed-13f3-7e0b-a121-238b0e5b27b3€49.00€0.67matched
103capture01a157ed-19f5-707c-9c5e-67e76e947a70€24.00€0.37matched
104capture01a157ed-2dc8-700a-b496-011a93c214f7€49.00€0.67matched
105capture01a157ed-3ff3-7c5f-8129-813e20da8cc4€35.00€0.50matched
106capture01a157ed-4575-7925-bf20-7c4cc88ba735€9.00€0.19matched
107capture01a157ed-606a-7d56-a4e2-cfa27a247d9f€9.00€0.19matched
108capture01a157ed-6706-74e7-a181-cfce36cf2e4e€15.00€0.26matched
109capture01a157ed-7e16-76f9-9a7c-f2719ee3159d€15.00€0.26matched
110capture01a157ed-83ae-7236-a054-d77d4260e794€24.00€0.37matched
111capture01a157ed-9492-7ff8-b4bc-cf61f97ae4dd€15.00€0.26matched
112capture01a157ed-9fa9-7b7f-a875-6c71979492e0€9.00€0.19matched
113capture01a157ed-b156-7207-8991-46d42cfdbe4c€24.00€0.37matched
114capture01a157ed-b9de-7a79-8d10-92406cc3368d€35.00€0.50matched
115capture01a157ed-be21-7e07-97cb-d1552e4b16f0€49.00€0.67matched
116capture01a157ed-d1c9-7058-bc70-dba23f4d73e9€49.00€0.67matched
117capture01a157ed-eff5-743d-aa0c-cca654791a3c€35.00€0.50matched
118capture01a157ee-0945-7550-99dd-9b4da61e1722€24.00€0.37matched
119capture01a157ee-41aa-7b88-9a96-28180ba42906€49.00€0.67matched