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

1 Nov, 23:30

Gross

€3,502.00

PSP fee

€54.48

Net to the bank

€3,447.52

Settlement journal

#333013

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • missing linein the books, not in the filecapture:01a19979-11ec-74bc-a5bc-93a7f27db028 is in no file
LineKindReferenceGrossFeeStatus
11capture01a19973-9099-7947-852a-4829bbee03f5€49.00€0.72fee difference
52capture01a19976-1414-7644-bc76-87cb2f366df3€15.00€0.30fee difference
144capture01a1997b-b596-7de9-ad7d-e7789bc454fd€24.00€0.40fee difference
1capture01a1996f-5f19-746c-98c2-b75d40ad41b3€15.00€0.26matched
2capture01a1996f-b6ef-7963-9dd9-446527e37648€24.00€0.37matched
3capture01a19972-fcf3-793c-a753-7147562b5f4c€9.00€0.19matched
4capture01a19973-2e6b-7650-9754-41098c2f581e€49.00€0.67matched
5capture01a19973-2f0a-74ad-975e-0558421a9e1d€9.00€0.19matched
6capture01a19973-3426-73e2-95e4-150fc51ba128€35.00€0.50matched
7capture01a19973-4233-71bc-8ee1-0f595765f1de€9.00€0.19matched
8capture01a19973-54e5-73b5-9432-d086f12dca2c€24.00€0.37matched
9capture01a19973-56b3-7409-a0f4-9ba2d1b0ea98€24.00€0.37matched
10capture01a19973-8072-7f29-9dac-970a6b0e0f9a€49.00€0.67matched
12capture01a19973-916a-7f9e-beb6-a577d3e7f9eb€49.00€0.67matched
13capture01a19973-99f3-71e2-b005-cef462d38c1f€15.00€0.26matched
14capture01a19973-b14b-7320-8b76-50399657f245€9.00€0.19matched
15capture01a19973-c587-77b1-b640-5fe6545025a1€9.00€0.19matched
16capture01a19973-c9fe-7d5f-b568-8acf859709ba€24.00€0.37matched
17capture01a19973-dc0d-7eac-9f4c-65cec4ffde63€49.00€0.67matched
18capture01a19973-df54-724f-9e06-b313afb3bcd4€24.00€0.37matched
19capture01a19973-e1c9-7f84-af0c-548e7ed8aa25€9.00€0.19matched
20capture01a19973-e7b1-785e-9b6b-e38d01bb633b€24.00€0.37matched
21capture01a19973-f6dc-78f7-b35b-28f0eb8e1566€35.00€0.50matched
22capture01a19974-146b-738a-a765-ac19f7627528€15.00€0.26matched
23refund01a19974-349c-742d-8b82-d0c34703493a-€43.00€0.00matched
24capture01a19974-3684-7770-87c6-599645970d58€35.00€0.50matched
25capture01a19974-3bd1-7c8b-8303-ef7111221f97€24.00€0.37matched
26refund01a19974-4d21-7032-90df-581e7c90718f-€11.00€0.00matched
27capture01a19974-50da-7ed4-bfc0-3c14699ad7fa€35.00€0.50matched
28capture01a19974-6812-7d0e-b87d-352a12de3a40€49.00€0.67matched
29capture01a19974-a48a-7996-96c8-0a7641f92e5e€49.00€0.67matched
30capture01a19974-a814-70a3-b3fe-a93a8f166139€49.00€0.67matched
31capture01a19974-b50c-72d3-8635-446e6f2d47e0€9.00€0.19matched
32capture01a19974-b511-7093-b6ba-5885ab723c06€49.00€0.67matched
33capture01a19974-c61d-71cf-adb9-96befd37d85d€9.00€0.19matched
34capture01a19974-cef4-7622-b6cf-81e6dbda675f€15.00€0.26matched
35capture01a19974-d3d7-76e9-92f0-b9752b5fde58€49.00€0.67matched
36capture01a19974-dafb-76dc-b1ae-190b7cf167ab€15.00€0.26matched
37capture01a19975-0ad5-7e93-92b8-4093c9f44450€15.00€0.26matched
38capture01a19975-182c-72aa-a53c-9dc7e380ecc4€9.00€0.19matched
39capture01a19975-32e2-730c-b964-a87dcc7f6114€24.00€0.37matched
40capture01a19975-4200-7a8a-9eaa-2884f720384c€49.00€0.67matched
41capture01a19975-442f-773e-aacf-c7ba73a4d2d2€49.00€0.67matched
42capture01a19975-44fe-7695-94fa-8dc0e592923f€35.00€0.50matched
43capture01a19975-50ee-7448-8c41-880e4b11dee3€9.00€0.19matched
44refund01a19975-55e0-7f05-9629-43d216105c90-€4.00€0.00matched
45capture01a19975-5691-7326-adae-9eed5d4a466e€24.00€0.37matched
46capture01a19975-94b5-74e7-bfa5-cb213c6fa501€49.00€0.67matched
47capture01a19975-aa50-7829-b8cf-37a7af635bdd€35.00€0.50matched
48capture01a19975-af67-7d0c-8458-c967afec87a8€9.00€0.19matched
49capture01a19975-ca36-7131-955c-51e9714b905f€49.00€0.67matched
50capture01a19975-e243-77e3-83be-fb899e5071aa€15.00€0.26matched
51capture01a19976-0851-7aa1-8b0f-6cbff332cc1f€24.00€0.37matched
53capture01a19976-22c5-7e8e-827c-663ca7e605ce€24.00€0.37matched
54capture01a19976-3381-7cdd-a2ab-01063e8dc2bb€9.00€0.19matched
55capture01a19976-539f-7d82-8f3f-aedec63d8e39€15.00€0.26matched
56capture01a19976-7cb7-7f8f-9ed4-c442c7498cfd€15.00€0.26matched
57capture01a19976-966e-7aae-8170-8e2dbbf3521c€9.00€0.19matched
58capture01a19976-ad2e-78b2-b59d-8d2ceedd6fc6€24.00€0.37matched
59capture01a19976-be8f-7b98-bf8f-200e0b3adb3e€24.00€0.37matched
60capture01a19976-cc6a-7a04-87b4-c473501ca5c9€9.00€0.19matched
61capture01a19976-dab4-726a-82f5-e9e68316c553€15.00€0.26matched
62capture01a19976-ddf8-7e07-8002-e7dcea1d01cc€15.00€0.26matched
63capture01a19977-31ee-71b6-9938-da7af936b105€15.00€0.26matched
64capture01a19977-38cb-7b8d-9e25-cb49a39ad669€49.00€0.67matched
65capture01a19977-38dd-78aa-9a99-3366cdfd14f2€49.00€0.67matched
66capture01a19977-4bf2-7fb5-a161-b25e5029657d€9.00€0.19matched
67capture01a19977-602a-7628-a2b0-d153c1466694€9.00€0.19matched
68capture01a19977-6542-7e42-b664-b03d067be698€35.00€0.50matched
69capture01a19977-7f3c-7d6a-9254-a3756cd1c456€15.00€0.26matched
70capture01a19977-80cc-7e65-8794-8e80ec74e29c€49.00€0.67matched
71capture01a19977-8d86-7411-bb11-7a1d3d8ed54e€9.00€0.19matched
72capture01a19977-98bb-7521-85ad-85d36bcdcb16€24.00€0.37matched
73capture01a19977-a215-72d5-9ad0-8f74fec7ae4f€9.00€0.19matched
74capture01a19977-a4ef-72e2-8573-4023cd5fb8d7€35.00€0.50matched
75capture01a19977-a66f-7e94-960b-d02200e35aa1€35.00€0.50matched
76capture01a19977-ca67-77f0-9595-c9f36f809159€15.00€0.26matched
77capture01a19977-d390-7240-a08a-3fa0beecd8ce€15.00€0.26matched
78capture01a19977-d9e0-7669-8229-77e8906e7a3a€35.00€0.50matched
79capture01a19977-e933-7f81-8bf5-2e01f0f937ac€15.00€0.26matched
80capture01a19977-eef0-7e88-b725-7a815802db9b€15.00€0.26matched
81capture01a19978-15fb-74ec-82c4-b4a28b874701€35.00€0.50matched
82capture01a19978-18af-7d50-b140-edb7f9f36e49€15.00€0.26matched
83capture01a19978-261c-7514-a9e2-9348a3fb071e€15.00€0.26matched
84capture01a19978-2d0e-77db-be84-209fb29a08ed€35.00€0.50matched
85capture01a19978-5171-7833-a0fc-63778d23984e€15.00€0.26matched
86capture01a19978-5a42-7a93-b36a-91cead759ecb€15.00€0.26matched
87capture01a19978-8a04-767c-99d2-07c1f76c8b4d€9.00€0.19matched
88capture01a19978-95ed-74b5-a7fc-47881c8b1776€49.00€0.67matched
89capture01a19978-bad7-7839-ba31-0a21c788aa26€49.00€0.67matched
90capture01a19978-bc24-79d1-b815-d0cad768cd68€49.00€0.67matched
91capture01a19978-c337-7a8a-8344-d39f9d6d8b45€35.00€0.50matched
92capture01a19978-c550-7906-b083-bdc190319b22€35.00€0.50matched
93capture01a19978-cac9-7d52-bd83-68be39196d4d€24.00€0.37matched
94capture01a19978-e150-7e22-881e-54325693f001€15.00€0.26matched
95capture01a19979-13ad-7845-a011-56f658fa0b2c€15.00€0.26matched
96refund01a19979-47cd-7410-8076-00faf5d7b4e3-€15.00€0.00matched
97capture01a19979-4f5e-757a-8740-415a6f4ddecc€9.00€0.19matched
98capture01a19979-50be-7306-87e0-4e12b4ab2d4f€15.00€0.26matched
99capture01a19979-706d-7754-b02c-3dd52c9c4f9d€49.00€0.67matched
100capture01a19979-70fa-7659-93f0-84b871273ccc€49.00€0.67matched
101capture01a19979-7c61-7dff-8e2b-f6af8bf6ce02€49.00€0.67matched
102capture01a19979-8c58-7cd6-a055-d37b6085fd91€9.00€0.19matched
103capture01a19979-a7b2-7446-8ae9-fe1b65a833aa€15.00€0.26matched
104capture01a19979-ca0e-7535-a190-175dd8e8d03e€35.00€0.50matched
105capture01a19979-ee91-7236-aa8f-73a209beec30€24.00€0.37matched
106capture01a19979-f72e-78d1-a068-bd1c2a1ab69c€35.00€0.50matched
107capture01a19979-f810-7966-9f1b-64e19b811653€9.00€0.19matched
108capture01a1997a-0413-706d-a73c-7848d803785e€9.00€0.19matched
109capture01a1997a-0a98-7f91-9ced-18109450ebb9€15.00€0.26matched
110capture01a1997a-1441-7867-8e54-a5d6faa88067€49.00€0.67matched
111capture01a1997a-3f22-7ec4-aaed-7f8684bb0066€49.00€0.67matched
112refund01a1997a-4959-73e2-ac5a-7e9eba63574e-€9.00€0.00matched
113capture01a1997a-4a25-7554-9dcb-61a3c2302217€24.00€0.37matched
114capture01a1997a-59a5-7fbe-bcff-b55b7359cbe5€49.00€0.67matched
115capture01a1997a-5c69-7ce1-8379-69c1ca793350€49.00€0.67matched
116capture01a1997a-8b4f-77c6-a0a2-ce1167e8c7c5€24.00€0.37matched
117capture01a1997a-9cb4-71bd-99d9-89e489431572€15.00€0.26matched
118capture01a1997a-9fd1-7714-bc3c-0c145ad3368a€49.00€0.67matched
119capture01a1997a-ba4d-7235-999e-71cbba60cec3€15.00€0.26matched
120capture01a1997a-bf71-77d8-a089-0ae21c5114a2€15.00€0.26matched
121capture01a1997a-c680-7e74-a8a6-6f0785b8c339€9.00€0.19matched
122capture01a1997a-ca90-79b6-b681-cbe6544ea34f€24.00€0.37matched
123capture01a1997a-d458-742f-a510-8c198dc91101€49.00€0.67matched
124capture01a1997a-db29-7469-b915-5990c167fbb1€24.00€0.37matched
125capture01a1997a-e404-7eab-8914-500b8e6c6534€24.00€0.37matched
126capture01a1997a-e7bb-7403-911e-fb786f5d253a€15.00€0.26matched
127capture01a1997a-f6bd-7d08-9a10-b699d6ef5bf9€15.00€0.26matched
128refund01a1997b-0981-7115-97a7-9bf06003a0cd-€7.00€0.00matched
129capture01a1997b-1dff-744d-acc9-cf45a886c28b€49.00€0.67matched
130capture01a1997b-28b7-7408-b93a-2039332cff69€15.00€0.26matched
131refund01a1997b-34d2-7ca6-8857-0de0b90d81e3-€12.00€0.00matched
132capture01a1997b-386c-71e6-b2fe-5bf5094c074d€9.00€0.19matched
133capture01a1997b-3ab8-748e-b234-e751ce0ae2c2€35.00€0.50matched
134capture01a1997b-3bd8-73af-8a1a-464c2e7389b9€15.00€0.26matched
135capture01a1997b-4d57-7809-9d52-9a539858a01e€15.00€0.26matched
136capture01a1997b-4fe6-74c9-b25c-fdca36225b0e€49.00€0.67matched
137capture01a1997b-5c41-7ce0-8879-01d15c8b0316€9.00€0.19matched
138capture01a1997b-6a9d-740a-a857-9a2d3a7918d0€35.00€0.50matched
139capture01a1997b-7d1d-7872-8c20-caa3a40aafed€24.00€0.37matched
140capture01a1997b-a1bc-7810-b5a3-d566aa9c8d45€49.00€0.67matched
141capture01a1997b-a378-75c2-856c-af120688f26f€35.00€0.50matched
142capture01a1997b-ab9a-7ec7-9d97-f2409d44dd0c€24.00€0.37matched
143capture01a1997b-ae16-7612-acc7-de528f9fa8c5€35.00€0.50matched