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

4 Nov, 11:20

Gross

€2,538.00

PSP fee

€40.19

Net to the bank

€2,497.81

Settlement journal

#378423

Breaks for a person to look at

  • missing linein the books, not in the filecapture:01a1a64a-2b16-71c7-b483-2b10b061d9ae is in no file
  • missing linein the books, not in the filecapture:01a1a64f-c34c-7b40-b29e-115293f026fa is in no file
LineKindReferenceGrossFeeStatus
1capture01a1a641-6e21-71bc-8696-eb5303c97d36€24.00€0.37matched
2refund01a1a644-416d-7be2-9116-fa9845ef85ca-€11.00€0.00matched
3capture01a1a646-6d9d-7655-acf7-a97d726a0da3€49.00€0.67matched
4capture01a1a647-d294-79a1-9553-16b2e2d0088f€9.00€0.19matched
5capture01a1a649-5688-72af-80e2-a98e4483dc03€9.00€0.19matched
6capture01a1a649-9d8a-7bb2-965a-89361d3fc72c€24.00€0.37matched
7capture01a1a649-a716-7ea2-a6b3-fcea45b56e16€35.00€0.50matched
8capture01a1a649-b320-787c-8cb8-0ba6e9a2db2a€15.00€0.26matched
9capture01a1a649-ce0f-7561-b561-a2134fce7864€9.00€0.19matched
10capture01a1a649-ff40-7fce-a6c4-1a9cfdddbef8€24.00€0.37matched
11capture01a1a64a-1d35-7fa3-826b-ad758dd5efe9€49.00€0.67matched
12capture01a1a64a-2ace-7899-a11c-5a991032ac30€24.00€0.37matched
13capture01a1a64a-308c-738c-9556-39d406c4c019€35.00€0.50matched
14capture01a1a64a-42b8-706c-8067-249b9064cfbd€24.00€0.37matched
15refund01a1a64a-51cc-7214-b516-2600ddedf50a-€24.00€0.00matched
16capture01a1a64a-5825-71fd-aa07-4c75e07f93c3€24.00€0.37matched
17capture01a1a64a-5c2f-7193-b708-0f3bbd775ba0€9.00€0.19matched
18capture01a1a64a-6afa-7293-b514-174dfde929f8€35.00€0.50matched
19capture01a1a64a-8308-733f-adf1-21efd56be0c2€24.00€0.37matched
20capture01a1a64a-9fa0-7c05-a42c-bd5523282116€49.00€0.67matched
21capture01a1a64a-d02d-7a68-bd25-f85670bf3e80€24.00€0.37matched
22refund01a1a64a-eadb-743e-9ac9-abd2c495e518-€10.00€0.00matched
23capture01a1a64a-eb18-79fb-8c5b-42be39d1d763€9.00€0.19matched
24capture01a1a64a-f826-7f14-851b-3f527ec061e7€35.00€0.50matched
25capture01a1a64b-08bb-785e-96e5-43aece2d0eae€24.00€0.37matched
26refund01a1a64b-14ef-7260-8b4e-e2665033e548-€30.00€0.00matched
27capture01a1a64b-1b28-7dd9-a8f6-60cff1b02ad6€49.00€0.67matched
28capture01a1a64b-1e9e-7354-ae81-eaed3372c7ac€9.00€0.19matched
29capture01a1a64b-276c-71cd-af8d-4988d1c18b48€9.00€0.19matched
30capture01a1a64b-5465-7260-82cf-0eb7164fafe4€24.00€0.37matched
31capture01a1a64b-5fad-7eb8-ba3f-0ec6e55b0f20€9.00€0.19matched
32capture01a1a64b-7121-790a-8b1b-2cbed685c074€9.00€0.19matched
33capture01a1a64b-c0be-7f3a-82e5-b96ad6fec93b€35.00€0.50matched
34capture01a1a64b-c54a-7a14-9cf9-aefc5a7df536€24.00€0.37matched
35capture01a1a64b-e8c5-7a6f-bd46-5a41bab78a8c€49.00€0.67matched
36capture01a1a64b-eaea-70a8-b4c2-5cd4b154bf0d€9.00€0.19matched
37capture01a1a64b-fe7a-77fe-9e67-72034ff10372€15.00€0.26matched
38capture01a1a64c-1ffa-72f1-b4e1-e3c7e6de7f60€49.00€0.67matched
39capture01a1a64c-3178-72b0-8e73-3262e1184b7c€24.00€0.37matched
40capture01a1a64c-3690-799a-86f0-727180451244€49.00€0.67matched
41capture01a1a64c-3b2c-7447-a1fc-b236b4b92152€15.00€0.26matched
42capture01a1a64c-4052-73ec-a93f-97158e41e23a€24.00€0.37matched
43capture01a1a64c-6bb0-706d-a030-d7ad766a7e20€9.00€0.19matched
44capture01a1a64c-90b7-7e20-b8d9-70da81116dd6€35.00€0.50matched
45capture01a1a64c-a197-724b-9aba-06cf7bc53714€9.00€0.19matched
46capture01a1a64c-b59d-727e-a937-3ff0414babaa€15.00€0.26matched
47capture01a1a64c-c60b-70d9-9d60-8f3e774d6743€49.00€0.67matched
48capture01a1a64c-de4b-7f27-8623-12526bea2a2b€15.00€0.26matched
49capture01a1a64c-e4bc-75b3-be7e-7b3b74823778€9.00€0.19matched
50capture01a1a64d-0625-72d6-b2cc-030e5c8d72bf€35.00€0.50matched
51refund01a1a64d-142b-7755-be8f-8285cf0e6042-€9.00€0.00matched
52capture01a1a64d-1c22-7df7-98bb-3bc19b03ad72€49.00€0.67matched
53capture01a1a64d-27ee-76f6-8954-643ebac66163€24.00€0.37matched
54refund01a1a64d-3690-781b-90cc-c56b29c6e4ef-€13.00€0.00matched
55capture01a1a64d-67d6-7440-9124-05488dba0996€24.00€0.37matched
56capture01a1a64d-bbe9-77d0-914c-ad1f83d5d63a€24.00€0.37matched
57capture01a1a64d-bf90-77a6-86a8-1d6b7cc43920€49.00€0.67matched
58capture01a1a64d-e5e9-7f22-8169-d7cb78cb3bd0€35.00€0.50matched
59capture01a1a64d-eae2-7abb-bb99-63acc04260fa€9.00€0.19matched
60capture01a1a64d-f43f-7eee-b436-add63f2d109d€49.00€0.67matched
61capture01a1a64e-0426-7df7-8ff3-293a654afcaf€9.00€0.19matched
62capture01a1a64e-1995-722c-8d4c-b8a9ae5a6b45€49.00€0.67matched
63capture01a1a64e-1d0c-7fe3-a641-d1147a574fa1€35.00€0.50matched
64capture01a1a64e-2901-76e4-8879-424bfc9da7b8€9.00€0.19matched
65capture01a1a64e-478e-7dd5-8a31-5f2ab127c531€9.00€0.19matched
66capture01a1a64e-48ae-7cd9-8d41-6ca44aaa9b7a€24.00€0.37matched
67refund01a1a64e-51fd-78e9-b376-156f82d5bc3d-€8.00€0.00matched
68capture01a1a64e-67d7-7032-a10d-40bc2f999ebc€35.00€0.50matched
69capture01a1a64e-6df2-7985-bd8e-5053993aa812€9.00€0.19matched
70capture01a1a64e-7b3a-7ca4-b51a-0bf5977ac423€24.00€0.37matched
71refund01a1a64e-7d6c-7746-9d53-2f903661a4ce-€7.00€0.00matched
72capture01a1a64e-9e17-7d7e-9d38-1f398f4d61c7€49.00€0.67matched
73capture01a1a64e-ae67-7aab-a892-0132b131aee2€49.00€0.67matched
74capture01a1a64e-afb5-7e61-b1ed-8ec663b1fe0b€15.00€0.26matched
75capture01a1a64e-b44d-70ef-8232-c1b46a4d17bc€24.00€0.37matched
76capture01a1a64e-bfd1-7d2f-b51e-724483ea9fdf€35.00€0.50matched
77capture01a1a64e-e0e8-77ca-bb9f-a8d8fdfc8936€15.00€0.26matched
78capture01a1a64f-4d79-7f0d-83f0-96dafced7436€9.00€0.19matched
79capture01a1a64f-579b-7f8f-8106-20b42db77766€15.00€0.26matched
80capture01a1a64f-68b0-75f0-95ba-a87feac6e97b€35.00€0.50matched
81capture01a1a64f-7339-7a8b-abb5-f2322265ae05€35.00€0.50matched
82capture01a1a64f-a5aa-7421-8b4e-b6f746e60feb€9.00€0.19matched
83capture01a1a64f-b393-7626-936f-5fb3c4e73022€15.00€0.26matched
84capture01a1a64f-d19a-7b55-a6b1-9566e8c8c80d€49.00€0.67matched
85capture01a1a64f-d6d0-747a-84b9-1981054b7345€24.00€0.37matched
86capture01a1a650-0b50-7671-a386-b1b442061c0b€15.00€0.26matched
87capture01a1a650-35aa-77db-b5b7-6d96e511bef0€15.00€0.26matched
88capture01a1a650-6083-7276-886a-55525ccab52f€24.00€0.37matched
89capture01a1a650-611c-7ec9-b5f6-8a3bbbe8e7bd€35.00€0.50matched
90capture01a1a650-6dcb-7c5c-9054-71490866e522€24.00€0.37matched
91capture01a1a650-7cc2-7344-8767-7a1f91e0c6e7€9.00€0.19matched
92capture01a1a650-b914-797e-ba8d-87854b14731e€9.00€0.19matched
93capture01a1a650-c048-714f-ad42-5c50e5ce7837€35.00€0.50matched
94capture01a1a650-c99f-7ba1-ab58-2d80c51235d5€24.00€0.37matched
95refund01a1a650-f11c-754e-874b-1accfe67ddf1-€8.00€0.00matched
96capture01a1a650-f9dd-7c6d-8138-606193058dab€35.00€0.50matched
97capture01a1a650-fe31-7138-94d5-c4e13b9bd81d€15.00€0.26matched
98capture01a1a651-0398-7a17-8e9e-e2919ba91560€35.00€0.50matched
99capture01a1a651-11b3-7476-a49b-3b8de7487630€24.00€0.37matched
100capture01a1a651-4981-7b59-b543-4d7c3cd754f5€49.00€0.67matched
101capture01a1a651-6ddb-7180-9ea6-f9f1e45b6c9d€15.00€0.26matched
102capture01a1a651-d35c-771a-b85a-530373de0e86€24.00€0.37matched
103capture01a1a651-de0c-7f53-bc70-4c502d8bfec0€9.00€0.19matched
104capture01a1a651-ec07-7828-8409-3ad6d241341d€35.00€0.50matched
105capture01a1a651-f491-734f-af8f-ac0a01702645€49.00€0.67matched
106capture01a1a652-2092-7931-b75d-c30b1215c8c5€24.00€0.37matched
107capture01a1a652-4b8e-7108-a7ed-a6c0b4e77a4e€35.00€0.50matched
108capture01a1a652-6aaa-7a3f-9f5c-2a9191195494€35.00€0.50matched
109capture01a1a652-992a-7938-80a3-a3a041dc17a3€49.00€0.67matched
110capture01a1a652-a985-7f75-930f-14b41807ca00€35.00€0.50matched
111capture01a1a652-aade-746c-a3d1-0a8e8b6e5dc0€15.00€0.26matched