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

Gross

€3,524.00

PSP fee

€55.47

Net to the bank

€3,468.53

Settlement journal

#361010

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1a15f-93a8-7465-a881-2d5cd889ca25 is in no file
  • missing linein the books, not in the filecapture:01a1a15b-c66b-7b88-9c9f-e1ece2ad8099 is in no file
LineKindReferenceGrossFeeStatus
143capture01a1a162-ef28-71c2-8927-111db873ce19€49.00€0.72fee difference
1capture01a1a152-57e6-78f6-9734-7684e6078171€15.00€0.26matched
2capture01a1a15a-4717-730e-91b1-c8839ef3dd5d€49.00€0.67matched
3capture01a1a15a-4c3a-7ef5-88d0-5ab757c2d3d0€24.00€0.37matched
4capture01a1a15a-55f2-7053-be41-ee674e9430f9€15.00€0.26matched
5capture01a1a15a-5663-7d64-9d62-40afb11223da€49.00€0.67matched
6capture01a1a15a-59b3-748e-a421-d5578a353e69€35.00€0.50matched
7capture01a1a15a-606f-77f9-bd51-dae843758952€35.00€0.50matched
8capture01a1a15a-6119-7953-8ccc-7e68e731ebfd€15.00€0.26matched
9capture01a1a15a-615e-757a-8c4e-739b0c533d28€24.00€0.37matched
10capture01a1a15a-6d27-77ff-849e-9a920bd09ffd€49.00€0.67matched
11capture01a1a15a-72aa-7ba0-ace9-2156cc030d00€24.00€0.37matched
12capture01a1a15a-928f-7d44-ab30-b3ea8ece81c0€35.00€0.50matched
13capture01a1a15a-9299-7de8-a1ba-e74cec12048d€15.00€0.26matched
14capture01a1a15a-b365-7dbd-bfed-be8afb9ccdfd€15.00€0.26matched
15refund01a1a15a-b440-72e6-a80f-7b483579f907-€31.00€0.00matched
16capture01a1a15a-b8cb-739a-b4e7-364971d2b638€35.00€0.50matched
17capture01a1a15a-bfcf-7411-800b-46d74e09b51c€35.00€0.50matched
18capture01a1a15a-d703-7fea-b19a-b534deb319df€15.00€0.26matched
19capture01a1a15a-d830-77b7-bfc8-72d41c965ce5€24.00€0.37matched
20capture01a1a15a-e32e-7116-9459-b880fa671a06€9.00€0.19matched
21capture01a1a15a-e844-7459-a80a-6838f0292fbc€35.00€0.50matched
22capture01a1a15a-ef00-7fb7-b855-42bfcaedb6c1€49.00€0.67matched
23capture01a1a15a-f0f7-70ef-9593-a4209b45f61c€9.00€0.19matched
24refund01a1a15a-f195-724d-9d50-dacae3475810-€14.00€0.00matched
25capture01a1a15b-1d78-75f6-b2d7-7ab43910d3a2€35.00€0.50matched
26capture01a1a15b-2104-7f04-8eb7-91a6d7531ba6€49.00€0.67matched
27capture01a1a15b-4fc2-7cac-af22-34a97c0e61fc€24.00€0.37matched
28capture01a1a15b-559e-775b-87d5-5d81da9b036e€24.00€0.37matched
29capture01a1a15b-5e63-7f14-a89c-722bf507c750€49.00€0.67matched
30capture01a1a15b-80ec-733a-8291-dcf050c49097€15.00€0.26matched
31capture01a1a15b-8dc3-7d4a-a321-e901a6facf08€24.00€0.37matched
32capture01a1a15b-a07c-7711-a4af-bcd63d3543ae€15.00€0.26matched
33capture01a1a15b-ae73-76bb-9da3-112be6de5b78€35.00€0.50matched
34capture01a1a15b-b96f-7119-9587-6ee9e2e79eed€15.00€0.26matched
35capture01a1a15b-bd38-7546-818c-f23977dfd372€35.00€0.50matched
36capture01a1a15b-c72a-762b-aa15-4838e668ecad€15.00€0.26matched
37capture01a1a15b-d605-74c0-a63d-4a46e73259e2€49.00€0.67matched
38refund01a1a15b-dc5c-7686-a35d-e8ef3a20bc1c-€13.00€0.00matched
39capture01a1a15c-02c8-7461-8bcd-5dd45fc8e347€49.00€0.67matched
40capture01a1a15c-1093-7c4e-b330-deb98e686651€24.00€0.37matched
41capture01a1a15c-1c0b-708a-b54a-4341c3af59e4€9.00€0.19matched
42refund01a1a15c-3bdd-7735-ba74-e448da355aa2-€25.00€0.00matched
43capture01a1a15c-468b-7385-a7c9-826c1adb26a8€49.00€0.67matched
44capture01a1a15c-5a70-702d-84e4-bd970daa5d9b€49.00€0.67matched
45capture01a1a15c-5bf3-7039-bbdc-2c7cc96d02f7€15.00€0.26matched
46capture01a1a15c-754d-71c6-b375-473d56ebd2e2€49.00€0.67matched
47refund01a1a15c-ac7d-7fed-af23-fc242587ba52-€13.00€0.00matched
48capture01a1a15c-bd25-7876-b6f2-ff3179a32f3e€9.00€0.19matched
49capture01a1a15c-c3d7-7c89-a3e0-53703d7375ec€35.00€0.50matched
50capture01a1a15c-e67d-74b1-a9c7-075da82902ac€9.00€0.19matched
51capture01a1a15c-e97b-7fb2-899e-d8627f7609fd€35.00€0.50matched
52capture01a1a15c-eb80-7560-8547-b80e1ae5e8eb€35.00€0.50matched
53capture01a1a15c-f315-7157-985f-15105ddcbde6€49.00€0.67matched
54capture01a1a15c-f33d-76c6-8430-6a0f5d0dcd67€49.00€0.67matched
55capture01a1a15d-0bb7-75f9-9381-ae7ca8ac4290€9.00€0.19matched
56capture01a1a15d-145e-78a7-9716-74e6dda3467c€35.00€0.50matched
57capture01a1a15d-24b2-73af-a0b1-78d0525f7d5b€9.00€0.19matched
58capture01a1a15d-38d7-7b90-a02d-ad9fb526db57€49.00€0.67matched
59capture01a1a15d-3ffc-7bf6-8fb4-bbd6e743996b€9.00€0.19matched
60capture01a1a15d-6ee7-7604-83ce-36caf2405210€15.00€0.26matched
61refund01a1a15d-805b-7a69-8b16-692659afb09c-€35.00€0.00matched
62refund01a1a15d-8238-76f4-80b2-6bfd161e6347-€20.00€0.00matched
63capture01a1a15d-9540-7112-b49f-82436754d4de€24.00€0.37matched
64capture01a1a15d-96ee-7f63-93bb-b99a06737bfd€9.00€0.19matched
65capture01a1a15d-9e31-7732-9e34-fce79ef6e3b1€24.00€0.37matched
66capture01a1a15d-a264-79d4-8f2e-2cc1f5ebf344€35.00€0.50matched
67capture01a1a15d-a881-7674-bd55-85fb65b41e3a€35.00€0.50matched
68capture01a1a15d-b334-7a3a-bc06-3d1cd34d8110€35.00€0.50matched
69capture01a1a15d-bc10-7895-b4cc-68bb934eb10f€24.00€0.37matched
70capture01a1a15d-d1de-7415-b03e-e71eda552eb0€15.00€0.26matched
71capture01a1a15e-1b13-7f8b-900b-b276e692c950€35.00€0.50matched
72capture01a1a15e-22f1-76fe-a0de-2869e048870b€24.00€0.37matched
73capture01a1a15e-6282-75a9-9dd3-bd9b245bd04e€49.00€0.67matched
74capture01a1a15e-7b24-772b-904c-c34cf7955903€24.00€0.37matched
75capture01a1a15e-8e51-704b-9c4d-6f7c6d7d2424€24.00€0.37matched
76capture01a1a15e-9db8-73d7-a131-42dc67e1ebfe€49.00€0.67matched
77capture01a1a15f-0159-74d9-9e0b-afa51ac09996€24.00€0.37matched
78capture01a1a15f-12be-769e-9597-bdc61e4b52f4€49.00€0.67matched
79capture01a1a15f-185a-7018-9af7-b33829ebeee5€24.00€0.37matched
80capture01a1a15f-6798-726e-95ed-bed65aecfe2d€49.00€0.67matched
81capture01a1a15f-7bcb-7a4f-a4c9-5ef898384851€35.00€0.50matched
82capture01a1a15f-8187-7a51-99d1-347e169c5972€9.00€0.19matched
83capture01a1a15f-9b07-7a0f-bece-ed8bf4592668€35.00€0.50matched
84capture01a1a15f-ae3b-7fae-a9e2-b80f9119b2e1€15.00€0.26matched
85capture01a1a15f-c7dd-72fc-8112-0822296272b0€35.00€0.50matched
86capture01a1a15f-e245-769f-b176-cf9ae9ce827b€9.00€0.19matched
87refund01a1a15f-fb4d-7946-81c2-4200e88bb301-€3.00€0.00matched
88capture01a1a160-27d2-7c9f-ae67-28cf5364ff2f€24.00€0.37matched
89capture01a1a160-3187-73aa-97f7-b3e8b893fc27€24.00€0.37matched
90capture01a1a160-72cc-7308-9b17-6ebcfc953cbb€24.00€0.37matched
91capture01a1a160-91c2-7727-b67e-701f9e97f434€49.00€0.67matched
92capture01a1a160-96c1-7de2-8df6-87f90fefd249€35.00€0.50matched
93capture01a1a160-9822-7a91-b72e-d1124d6b02c3€35.00€0.50matched
94capture01a1a160-99b7-779b-a4cd-54d649e0a60c€9.00€0.19matched
95capture01a1a160-9d6f-758f-940c-c2e9425f519c€15.00€0.26matched
96refund01a1a160-9e58-7586-8854-118959a145a0-€18.00€0.00matched
97capture01a1a160-bddb-7855-bb2a-607c0be793cd€35.00€0.50matched
98capture01a1a160-be3b-70af-8243-cd978e895f37€15.00€0.26matched
99capture01a1a160-c62b-7be2-8426-70a0967d4967€24.00€0.37matched
100capture01a1a160-d0ea-7a2f-923c-858f301b7554€9.00€0.19matched
101capture01a1a160-d6a7-7a1a-a009-d373a514f4e8€49.00€0.67matched
102capture01a1a160-de92-7dbc-9d76-5559d2ed60a3€24.00€0.37matched
103capture01a1a161-06f3-7e3a-be70-f3c604e2bae7€24.00€0.37matched
104refund01a1a161-1703-73fe-99f6-8072d27713a7-€7.00€0.00matched
105capture01a1a161-221d-7196-b4b6-a0714ffa554a€49.00€0.67matched
106capture01a1a161-3238-7d4d-a8fc-f439a44a017b€35.00€0.50matched
107capture01a1a161-3aa0-7109-8f36-ef108cade9d6€35.00€0.50matched
108refund01a1a161-40b5-7423-9c62-33bfcdc75a37-€7.00€0.00matched
109capture01a1a161-42ef-768e-87c3-a921ef7d942c€9.00€0.19matched
110capture01a1a161-4b09-7ffb-92f3-f137671137cd€9.00€0.19matched
111capture01a1a161-58e0-7911-9079-9ba4731a3e37€15.00€0.26matched
112capture01a1a161-7097-71ab-974d-674eb2f75341€24.00€0.37matched
113capture01a1a161-74ed-78ff-b6ec-bc31bae4e2c6€15.00€0.26matched
114capture01a1a161-90cb-700a-890a-5bdd3736ef3e€9.00€0.19matched
115capture01a1a161-9787-7324-8822-80f099f90e0a€24.00€0.37matched
116capture01a1a161-9f8c-7a50-86b7-bbfa6e7de3d4€49.00€0.67matched
117refund01a1a161-b26c-7f3b-ba6d-d547b306e6d4-€4.00€0.00matched
118refund01a1a161-bcda-7a84-b30d-42538fb115ca-€5.00€0.00matched
119capture01a1a161-d416-711b-a8a9-8efbf58e3e69€15.00€0.26matched
120capture01a1a161-def7-732e-8078-81d66a1d0282€35.00€0.50matched
121capture01a1a161-e4e0-7443-a642-1c6259ed26f0€49.00€0.67matched
122capture01a1a161-ee06-7649-a46c-f5d1c0c83255€15.00€0.26matched
123capture01a1a161-f1b5-7632-b313-d6eac0451c00€24.00€0.37matched
124capture01a1a162-074f-771a-9eac-44e3b842b88d€9.00€0.19matched
125capture01a1a162-2634-7fa2-9b24-f36eabb3be04€49.00€0.67matched
126capture01a1a162-40ea-7a86-bd72-a96487f92e60€35.00€0.50matched
127capture01a1a162-4a52-7de5-b993-1d0c5785688a€15.00€0.26matched
128capture01a1a162-62d6-7549-a477-cd61a52fc865€35.00€0.50matched
129capture01a1a162-647b-7f7b-b06b-c1bf47d18b60€49.00€0.67matched
130capture01a1a162-6a74-74f0-bb41-37d137d79246€15.00€0.26matched
131capture01a1a162-7a58-7d50-9649-b27484d2b5d2€24.00€0.37matched
132capture01a1a162-7e6c-7c3b-b53d-1c1b4c0d58d6€35.00€0.50matched
133capture01a1a162-8205-7d4f-a7c0-28c2c9eb84ec€49.00€0.67matched
134capture01a1a162-893a-718e-a3af-3a917ffb4bfb€24.00€0.37matched
135capture01a1a162-8960-7bfe-bcce-d2178d70f6c7€49.00€0.67matched
136capture01a1a162-9041-71d4-88ee-54717a8049db€24.00€0.37matched
137capture01a1a162-94cc-77b1-be89-d89e22e38a1f€15.00€0.26matched
138capture01a1a162-a48e-7949-935b-139f8923f844€15.00€0.26matched
139capture01a1a162-b0d9-7050-bd9f-76adb5199aeb€35.00€0.50matched
140capture01a1a162-cb5c-74f2-a02e-c81db4ffb9ac€9.00€0.19matched
141capture01a1a162-d004-75b7-bd3c-3cc78c751a24€35.00€0.50matched
142capture01a1a162-e83f-7b53-b2ae-6fb7a05ad4a2€15.00€0.26matched
144capture01a1a162-f12f-71dc-b5a5-752e550d02c4€9.00€0.19matched
145capture01a1a163-0e71-7bdd-b55e-d2e0015b4650€9.00€0.19matched
146capture01a1a163-2149-7b0f-b702-8e9babbeeec7€35.00€0.50matched