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, 17:50

Gross

€2,987.00

PSP fee

€46.74

Net to the bank

€2,940.26

Settlement journal

#365191

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • missing linein the books, not in the filecapture:01a1a288-c8d6-7cab-84e2-e389a17e541d is in no file
  • missing linein the books, not in the filecapture:01a1a28d-a9c3-7fa4-a40a-cd9c2a5aaa15 is in no file
  • missing linein the books, not in the filerefund:01a1a291-1a1a-7de2-9a1d-d639f25112a5 is in no file
LineKindReferenceGrossFeeStatus
64capture01a1a28d-5aaf-74f0-9a04-0706aae80ea3€35.00€0.53fee difference
126capture01a1a291-4a20-799a-ab8d-7353b6c1ff13€9.00€0.22fee difference
1capture01a1a27f-3c49-7c4d-9cf0-61544462c104€35.00€0.50matched
2capture01a1a27f-b4c9-7590-8d31-bc8044c2c95c€15.00€0.26matched
3capture01a1a282-c368-7c3a-9ff5-70c7ef89ff14€49.00€0.67matched
4capture01a1a284-b492-7c5c-a845-ddce29620536€24.00€0.37matched
5capture01a1a286-0af5-7db9-99ce-0494e41877e1€15.00€0.26matched
6capture01a1a288-560d-79f8-8aeb-f41875e87321€35.00€0.50matched
7capture01a1a288-641f-74dd-a867-ef20b2ff87a8€15.00€0.26matched
8capture01a1a288-6a7f-76ba-a4ba-0c33b837edd2€35.00€0.50matched
9capture01a1a288-6b01-72ac-8bf5-264f1f1bec20€9.00€0.19matched
10capture01a1a288-98f9-7608-81d3-6b2df59d3b9c€9.00€0.19matched
11capture01a1a288-a8d3-7632-aec3-d32d52f22275€15.00€0.26matched
12capture01a1a288-df8f-7fd0-9909-1b74b2fa4ed1€49.00€0.67matched
13capture01a1a289-0c7f-7631-9e58-f92fef373e51€49.00€0.67matched
14capture01a1a289-1252-748d-ae0f-9d21fd645b84€24.00€0.37matched
15capture01a1a289-1c90-7427-a525-f8845c5acdac€35.00€0.50matched
16capture01a1a289-3ed7-736a-b9fb-58a717fc63b6€35.00€0.50matched
17capture01a1a289-5993-7160-a826-2ccd369875a1€24.00€0.37matched
18capture01a1a289-838b-796f-b2d5-9fff38d28ccd€24.00€0.37matched
19capture01a1a289-984f-7a89-8a78-86e2c9e3fcbe€35.00€0.50matched
20capture01a1a289-9c49-76f8-b95b-5cc85a308298€35.00€0.50matched
21refund01a1a289-c64d-7e6f-a214-5a4ad055a8c5-€14.00€0.00matched
22capture01a1a289-ef69-7301-8b31-2e9d6efcd51f€35.00€0.50matched
23capture01a1a28a-11bc-743e-8b5e-278cb77ddd5a€49.00€0.67matched
24capture01a1a28a-1910-7bb1-8374-b459dbfabc89€24.00€0.37matched
25capture01a1a28a-2125-7397-87ce-c52e859e9eee€9.00€0.19matched
26capture01a1a28a-3dd3-72f5-a8d7-ea3c8aa87ac7€49.00€0.67matched
27capture01a1a28a-5306-785e-abca-c805ccc29465€15.00€0.26matched
28capture01a1a28a-551b-7f81-b092-ffc5b92725ee€9.00€0.19matched
29refund01a1a28a-564b-76f1-9410-f42dd819de41-€9.00€0.00matched
30capture01a1a28a-5892-7e4d-919e-b3408a02e716€35.00€0.50matched
31capture01a1a28a-78cb-7b72-b513-24bf6423597c€35.00€0.50matched
32capture01a1a28a-8e4c-7d94-9dee-800b3eb683aa€35.00€0.50matched
33capture01a1a28a-915c-7d0e-85da-64ce28c27d28€35.00€0.50matched
34capture01a1a28a-a3ef-79b2-ba79-b08a302937d6€35.00€0.50matched
35capture01a1a28a-ac93-7d82-b247-eb843fc5f410€35.00€0.50matched
36capture01a1a28a-b656-7713-9db0-c957895ced69€35.00€0.50matched
37capture01a1a28a-c632-7aae-afcc-2124687cb068€49.00€0.67matched
38capture01a1a28a-d458-7e58-9dc8-02446dfe6ddf€15.00€0.26matched
39capture01a1a28a-f583-7c7b-a230-ff5c576cf10c€35.00€0.50matched
40capture01a1a28b-1a78-7e57-8d93-4a353b3f3a54€35.00€0.50matched
41capture01a1a28b-1c20-77bb-a14b-6e2c91997be5€9.00€0.19matched
42capture01a1a28b-263e-7a4e-90f9-7bebc29e6dce€35.00€0.50matched
43capture01a1a28b-2b67-7556-9a28-2911414ed225€24.00€0.37matched
44refund01a1a28b-4870-78cf-bf87-bea22f86289f-€33.00€0.00matched
45capture01a1a28b-4a65-71b8-b2f3-67f17c11992e€24.00€0.37matched
46capture01a1a28b-741e-7c54-b84d-6cac49fae23f€49.00€0.67matched
47capture01a1a28b-8f66-7f7a-b3af-f7865bb1b6c5€9.00€0.19matched
48capture01a1a28b-90cb-7abc-88c1-69aa68d981c9€24.00€0.37matched
49capture01a1a28b-e0f5-7600-ab21-e8a42a7e3f36€35.00€0.50matched
50capture01a1a28b-f266-7131-8279-05e0a5aaa63d€49.00€0.67matched
51capture01a1a28c-3133-74c0-bcd1-e8cc07cd2b2e€24.00€0.37matched
52capture01a1a28c-521d-780b-9558-3765ff0c14d9€9.00€0.19matched
53capture01a1a28c-807e-77a8-a890-71725d7805a0€9.00€0.19matched
54capture01a1a28c-8182-7972-b32d-5cdabf86cd6f€15.00€0.26matched
55capture01a1a28c-939c-79ce-9707-adf6c787aae7€9.00€0.19matched
56capture01a1a28c-956d-7e1a-9f59-c9e243a88802€24.00€0.37matched
57capture01a1a28c-b590-7d1d-8a8a-594926d0eab2€9.00€0.19matched
58capture01a1a28c-bded-71b3-87b0-08647a0e6085€9.00€0.19matched
59capture01a1a28c-ebb7-7cf9-b670-96a84823b6dc€15.00€0.26matched
60capture01a1a28d-0245-7e84-b0ac-db23bc65c1ca€24.00€0.37matched
61refund01a1a28d-28cd-763b-aff4-a2441fe16acd-€5.00€0.00matched
62capture01a1a28d-31ac-76c0-81d5-94cc76204be4€15.00€0.26matched
63capture01a1a28d-4410-7010-9939-fa1e2f79a89e€24.00€0.37matched
65capture01a1a28d-6c53-71ca-bec9-78ba5f0e22fc€15.00€0.26matched
66capture01a1a28d-6d4b-79eb-b2ee-fd9a6f7d57c8€24.00€0.37matched
67capture01a1a28d-6ebf-76d6-9639-75656a31833b€49.00€0.67matched
68capture01a1a28d-8bbb-7e22-8320-f5fc3d601451€49.00€0.67matched
69capture01a1a28d-8bef-7d77-bb29-460841d28e20€9.00€0.19matched
70capture01a1a28d-9fc5-7f8a-aeb5-c41eb9c8ebea€9.00€0.19matched
71capture01a1a28d-cabe-72c6-b4ca-ca711c88a88b€35.00€0.50matched
72capture01a1a28d-d76a-7754-b4c3-cbd45aab8d61€35.00€0.50matched
73capture01a1a28d-dd3f-7780-baa4-e41982c4a375€24.00€0.37matched
74capture01a1a28d-ebce-7491-868b-9a4425056b92€49.00€0.67matched
75capture01a1a28d-ee93-73c7-99d8-f1fece0fe8f1€35.00€0.50matched
76capture01a1a28d-ff8c-7fbf-ac20-36863f9281ae€35.00€0.50matched
77capture01a1a28e-15c8-7a7f-b75a-22e44c8600d9€24.00€0.37matched
78capture01a1a28e-19a7-797c-ba6d-64dcd881118f€15.00€0.26matched
79refund01a1a28e-18a8-78b7-82c2-422dd83c4850-€23.00€0.00matched
80capture01a1a28e-3017-7a60-9da4-31d4d70b9496€49.00€0.67matched
81capture01a1a28e-3029-7e8d-babe-fd108b644fa2€24.00€0.37matched
82capture01a1a28e-4bfa-7761-8fc1-e1683ebe9262€49.00€0.67matched
83capture01a1a28e-4f50-71b1-8a01-53d953c5a72c€49.00€0.67matched
84capture01a1a28e-595d-76d0-be1c-df9d5127cc03€24.00€0.37matched
85capture01a1a28e-6247-75b9-bf66-79c86153d042€9.00€0.19matched
86refund01a1a28e-892d-790a-8c36-5777b38d884f-€13.00€0.00matched
87capture01a1a28e-89ec-75a6-9fb9-dea4bea2ca3b€35.00€0.50matched
88capture01a1a28e-8d28-7b61-a0fa-85a948a1c865€9.00€0.19matched
89capture01a1a28e-94b9-77c5-988f-7f63787cf912€49.00€0.67matched
90capture01a1a28e-a1eb-78b5-b867-8b41ef81c739€15.00€0.26matched
91capture01a1a28e-a868-7458-b902-893f08261a40€35.00€0.50matched
92capture01a1a28e-ef05-7541-bc96-f0af95ece454€24.00€0.37matched
93capture01a1a28f-26b6-72c0-bdf3-21f5ce463a3e€9.00€0.19matched
94capture01a1a28f-4936-7ef2-b4c3-9862c814e42a€49.00€0.67matched
95refund01a1a28f-625c-7e4f-8131-8d6fa9cb96f3-€5.00€0.00matched
96capture01a1a28f-69c2-7f39-b966-49e0e4a191f4€9.00€0.19matched
97capture01a1a28f-6f0b-7385-a9a9-f7d2b56a52bc€35.00€0.50matched
98capture01a1a28f-9e6a-751c-9078-880ab70f4c32€24.00€0.37matched
99capture01a1a28f-a7dd-7d17-856f-156f0fefacf9€15.00€0.26matched
100capture01a1a28f-b2c2-76f3-af44-0660582b8419€15.00€0.26matched
101capture01a1a28f-bdec-7c89-b9bd-56313b682425€15.00€0.26matched
102capture01a1a28f-cbe8-7f48-ae6a-f1074b474e3f€9.00€0.19matched
103capture01a1a28f-d365-79d6-a68c-ca099501fb9f€24.00€0.37matched
104capture01a1a290-1cd7-7873-8a7b-5fff352a5fcf€35.00€0.50matched
105capture01a1a290-1da7-744e-913c-e24d042ab18a€24.00€0.37matched
106capture01a1a290-2289-7e8c-8e87-7e8633236659€24.00€0.37matched
107capture01a1a290-372d-75d4-af93-559e0d288a34€35.00€0.50matched
108capture01a1a290-41c4-7fc1-a0f4-ad4039b20a15€15.00€0.26matched
109capture01a1a290-4398-768e-9059-0b31393cad2a€15.00€0.26matched
110capture01a1a290-4e9b-7817-a107-873033c115c3€15.00€0.26matched
111capture01a1a290-54be-7747-bb3a-101e31d24c3b€35.00€0.50matched
112capture01a1a290-6558-7645-ae90-89656fa6ce87€9.00€0.19matched
113capture01a1a290-6fdc-75d3-8544-e45373c75716€49.00€0.67matched
114refund01a1a290-7215-756b-ab87-36c0061597ac-€4.00€0.00matched
115capture01a1a290-8eb1-7a86-8c6a-4be6e84c526a€35.00€0.50matched
116capture01a1a290-9565-7482-a1d1-e095dc9166da€15.00€0.26matched
117capture01a1a290-a1ff-7990-a316-a4ea5d6847c0€15.00€0.26matched
118capture01a1a290-a7ff-786d-8ebc-31999803c229€15.00€0.26matched
119capture01a1a290-ad00-73b9-b51e-d15597292ee0€15.00€0.26matched
120capture01a1a290-b7ea-77ea-a1a4-ae6673db7819€15.00€0.26matched
121capture01a1a290-efc5-73d5-828c-7740ba11d58a€15.00€0.26matched
122capture01a1a290-f9e5-7858-899a-188dcc9b8321€24.00€0.37matched
123capture01a1a291-102c-7566-b4ef-40c02668daec€24.00€0.37matched
124capture01a1a291-3e65-7fbf-a82e-c48dd9e4b058€24.00€0.37matched
125capture01a1a291-4a0d-73aa-91c9-dc993f0e30fb€35.00€0.50matched