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

Gross

€2,800.00

PSP fee

€44.49

Net to the bank

€2,755.51

Settlement journal

#366318

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • missing linein the books, not in the filecapture:01a1a2e0-b18e-7562-a5fd-7986fe966b58 is in no file
LineKindReferenceGrossFeeStatus
66capture01a1a2de-c4ca-7e1a-866b-40708f9ea8eb€9.00€0.21fee difference
76capture01a1a2df-ae93-7fa1-9f9a-2d8217798dc4€49.00€0.71fee difference
91capture01a1a2e1-0a47-7bcc-9156-e8f4e80d8661€15.00€0.29fee difference
97capture01a1a2e1-9231-7c52-8c94-c9394ad279e5€9.00€0.23fee difference
1refund01a1a2d2-fa2c-7dfe-8193-9fb751adcda3-€10.00€0.00matched
2capture01a1a2d3-24f6-7fb0-ab48-65f82a98d780€15.00€0.26matched
3capture01a1a2da-b4c8-744c-bb7a-0c3afabfcc42€24.00€0.37matched
4capture01a1a2da-b530-7832-99dd-04cc669fa83c€24.00€0.37matched
5capture01a1a2da-c6b1-79f5-9900-46545518a922€9.00€0.19matched
6capture01a1a2da-cfaf-7468-b61d-3336840428bb€49.00€0.67matched
7capture01a1a2da-f3a9-7b1f-9930-c5c0d1be8072€49.00€0.67matched
8capture01a1a2db-2997-7b59-8b6a-6c06ca27905c€49.00€0.67matched
9capture01a1a2db-4ded-7f6e-89b6-715affa1dad8€9.00€0.19matched
10capture01a1a2db-5701-7556-bd76-094fad6dddfd€24.00€0.37matched
11capture01a1a2db-6404-79bc-a8f1-4bcf550095e5€35.00€0.50matched
12capture01a1a2db-717b-7dc3-8b29-c676952ef4cc€49.00€0.67matched
13capture01a1a2db-7568-7709-b627-e9cb9e9482e2€15.00€0.26matched
14capture01a1a2db-8982-7c23-b826-823e427ef8f0€15.00€0.26matched
15capture01a1a2db-9c27-738c-b1ef-c0b94002766c€24.00€0.37matched
16capture01a1a2db-9ff2-72b7-8802-c8592e49f666€24.00€0.37matched
17capture01a1a2db-aa17-73ba-a1d5-d9cb98b53518€9.00€0.19matched
18capture01a1a2db-acfb-70ee-bfcf-99cbf0a8a207€24.00€0.37matched
19refund01a1a2db-c3ba-768d-b1ed-da2ff8f2dd1c-€7.00€0.00matched
20capture01a1a2db-ce2e-7811-bf12-119a20919d34€9.00€0.19matched
21capture01a1a2db-fcf2-7e63-84e9-3c05d5656527€24.00€0.37matched
22capture01a1a2dc-2841-7ab2-8c0e-73dcec1e6292€35.00€0.50matched
23capture01a1a2dc-4fdc-78ff-b063-7e44d4ef5a34€24.00€0.37matched
24capture01a1a2dc-65ac-7cf4-be50-4eec354a40a2€24.00€0.37matched
25capture01a1a2dc-6902-7ef3-ae4c-6d9da0994e1a€24.00€0.37matched
26capture01a1a2dc-77c0-794f-8759-153f3045e087€49.00€0.67matched
27capture01a1a2dc-8338-73bc-9666-644e7cfb9297€49.00€0.67matched
28refund01a1a2dc-93d6-7b56-ad7b-715e425c8885-€29.00€0.00matched
29capture01a1a2dc-9424-7e4b-9674-9c4d47a8e7a6€9.00€0.19matched
30capture01a1a2dc-b999-71d6-a4c1-663904baded8€49.00€0.67matched
31capture01a1a2dc-c301-7b90-b099-8fab0cc1c0b1€9.00€0.19matched
32capture01a1a2dc-c675-7177-bc81-90dae886ab79€15.00€0.26matched
33capture01a1a2dc-d040-7974-a3f6-a1df44ee2dc0€35.00€0.50matched
34capture01a1a2dc-d2d9-701b-ab18-2b9eae093b6c€35.00€0.50matched
35capture01a1a2dc-e349-7c2c-820d-1c2581c80a64€49.00€0.67matched
36refund01a1a2dc-e680-76e9-a746-850d67c12991-€11.00€0.00matched
37capture01a1a2dc-e6e3-7bb4-95a7-b7a69300fe74€9.00€0.19matched
38refund01a1a2dc-f3c6-7857-80ef-5ee35a0a85ca-€4.00€0.00matched
39capture01a1a2dc-fbbd-73e3-8daa-a8a3fcc96bd2€15.00€0.26matched
40capture01a1a2dd-05a4-7b58-b60a-8a7c056355a2€24.00€0.37matched
41capture01a1a2dd-14cb-77b8-9bc5-fe95b9001ea0€35.00€0.50matched
42capture01a1a2dd-16f6-703f-baef-d4bc8918eeb5€24.00€0.37matched
43capture01a1a2dd-1b3e-7375-be93-9ef78f732b37€35.00€0.50matched
44capture01a1a2dd-2666-77e4-9449-cc23593fb5a5€9.00€0.19matched
45capture01a1a2dd-2a6c-70bf-a44d-ab2aa92cf0ae€15.00€0.26matched
46capture01a1a2dd-2c83-780a-be4e-6e05f15c7c37€49.00€0.67matched
47capture01a1a2dd-3785-7775-9c21-1548c51c4ccf€35.00€0.50matched
48capture01a1a2dd-3cf8-79bd-9e2a-33e065e88954€35.00€0.50matched
49capture01a1a2dd-74d5-7c5d-a2e6-cd63a8a6e465€35.00€0.50matched
50capture01a1a2dd-7531-7e11-a560-cbc972d386b9€15.00€0.26matched
51refund01a1a2dd-7d9e-7209-b7bb-8189985fc4ac-€29.00€0.00matched
52capture01a1a2dd-9354-7399-a2eb-2688a759b3e6€24.00€0.37matched
53capture01a1a2dd-94b9-7380-a2ec-5a8840dd84ab€35.00€0.50matched
54capture01a1a2dd-bbf4-774c-af3a-5b035026a816€9.00€0.19matched
55capture01a1a2dd-daed-789a-8034-99beb4c2ab4c€9.00€0.19matched
56capture01a1a2dd-e59c-7f48-b933-0ff279785e8c€9.00€0.19matched
57capture01a1a2de-2bcf-73fd-9023-449be9394070€24.00€0.37matched
58capture01a1a2de-3007-7d9c-8722-2511aaa9aee7€15.00€0.26matched
59capture01a1a2de-55a2-7683-aab5-848fbc464673€9.00€0.19matched
60capture01a1a2de-5eff-7553-a771-656a222b4317€35.00€0.50matched
61capture01a1a2de-65ca-7fba-bbca-9d0aac3a7c9a€15.00€0.26matched
62capture01a1a2de-94c8-711a-b2cb-71c2f52abf75€49.00€0.67matched
63capture01a1a2de-9515-7c51-b4ba-c00a16ae302a€49.00€0.67matched
64capture01a1a2de-9fc8-7ec5-894f-545b7ea9704b€15.00€0.26matched
65capture01a1a2de-bc2c-7e0e-9be1-f12f961aac04€49.00€0.67matched
67refund01a1a2de-c5ef-7178-93b1-846c4877e14c-€32.00€0.00matched
68capture01a1a2de-de67-79f9-b2da-5f881177e356€9.00€0.19matched
69capture01a1a2de-ed71-73b0-9601-112d701e514a€24.00€0.37matched
70capture01a1a2de-eeed-70ec-ac08-27fa3d14f509€9.00€0.19matched
71capture01a1a2de-f233-796d-a4f1-c55801e3e6cb€35.00€0.50matched
72capture01a1a2df-294d-70ec-9d2e-9ee2f373ebf0€24.00€0.37matched
73refund01a1a2df-4805-751a-916a-a8528f3aee35-€7.00€0.00matched
74capture01a1a2df-543f-77be-8609-b773baef7b5d€35.00€0.50matched
75capture01a1a2df-927a-759b-b765-8201a2e44117€49.00€0.67matched
77capture01a1a2df-ff3a-783e-b608-dd15275e7693€15.00€0.26matched
78capture01a1a2e0-0186-7db3-91f6-8481ed1985e2€35.00€0.50matched
79capture01a1a2e0-43b2-76a0-9937-20e26d87d564€9.00€0.19matched
80capture01a1a2e0-56f8-7cec-abbc-e49bf1f05bf8€9.00€0.19matched
81refund01a1a2e0-7dde-775d-b10f-b98c4145ff05-€5.00€0.00matched
82capture01a1a2e0-7f51-7266-9200-5f89085f79a7€49.00€0.67matched
83capture01a1a2e0-834c-71ac-a954-b508ca0f0ba8€24.00€0.37matched
84capture01a1a2e0-a465-760e-8175-eed68a8c461d€9.00€0.19matched
85capture01a1a2e0-b35c-7f06-8085-dad02b181440€9.00€0.19matched
86capture01a1a2e0-afc0-706b-8f19-d604f3df7f79€49.00€0.67matched
87capture01a1a2e0-bb4b-7ffe-9079-c0f6c63d5bc2€24.00€0.37matched
88capture01a1a2e0-d35f-7918-8e91-c9f9fa696285€49.00€0.67matched
89capture01a1a2e0-e693-7a32-981a-13986ce295b3€15.00€0.26matched
90capture01a1a2e0-eb02-74ee-9f40-001713f8356d€49.00€0.67matched
92capture01a1a2e1-0a4d-77aa-b96b-f3efee03ddbf€35.00€0.50matched
93capture01a1a2e1-1482-7b09-a9b8-78c3aa5e59a7€9.00€0.19matched
94refund01a1a2e1-1670-71ce-a454-369a5aaf5e45-€13.00€0.00matched
95refund01a1a2e1-4cb3-7330-b26b-a6e7053f3f93-€6.00€0.00matched
96capture01a1a2e1-5752-7bb2-9f54-d49ba5decf6f€35.00€0.50matched
98capture01a1a2e1-94eb-7e9a-bc7a-e312cb24de9d€15.00€0.26matched
99capture01a1a2e1-a605-7932-9b94-e4cfbda1a0e4€49.00€0.67matched
100capture01a1a2e1-ba32-7355-88f1-68e20daae60a€35.00€0.50matched
101capture01a1a2e1-d179-7367-a503-e1373e3b439a€9.00€0.19matched
102capture01a1a2e1-edf1-7dea-bdb4-1387858b0f16€49.00€0.67matched
103capture01a1a2e1-fdf5-7b80-bf4e-acc07a438369€15.00€0.26matched
104capture01a1a2e2-0210-79df-93b2-94f1e144a939€49.00€0.67matched
105capture01a1a2e2-1896-7074-9bf1-c1e9d336afe8€49.00€0.67matched
106capture01a1a2e2-3f74-7f67-8e13-50285c86f738€49.00€0.67matched
107capture01a1a2e2-4086-7652-8845-33c0a13b67f0€49.00€0.67matched
108capture01a1a2e2-5a55-7f06-b6f6-7a249218d5d8€9.00€0.19matched
109capture01a1a2e2-8263-7ebf-9d4a-aa00c1b26b7d€35.00€0.50matched
110capture01a1a2e2-9450-7e03-97bc-f2995586cbb5€35.00€0.50matched
111capture01a1a2e2-e08d-7a4d-8af8-d1ec240e1e9c€9.00€0.19matched
112capture01a1a2e2-e66e-7d83-bc5f-f188b3294a97€9.00€0.19matched
113capture01a1a2e2-fc51-794c-910d-6703a4df2d01€49.00€0.67matched
114capture01a1a2e3-025b-7460-a396-cd842326cdf2€24.00€0.37matched
115capture01a1a2e3-32fc-7a21-a137-03ceb2819f7e€15.00€0.26matched
116capture01a1a2e3-3ca1-71b3-9488-4cc7117b9779€35.00€0.50matched
117capture01a1a2e3-4e18-7fcb-a70e-62a42d43bea7€49.00€0.67matched
118capture01a1a2e3-757e-7256-8ba6-e987c44024ad€15.00€0.26matched
119refund01a1a2e3-7a77-79fd-b11e-383866b7616f-€5.00€0.00matched
120capture01a1a2e3-7ecb-7403-8388-5ccb166a853c€24.00€0.37matched
121capture01a1a2e3-7d2e-7241-b781-49dc0003d0a5€24.00€0.37matched