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

5 Nov, 10:30

Gross

€3,217.00

PSP fee

€49.54

Net to the bank

€3,167.46

Settlement journal

#396096

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ab43-bf3c-7c43-853d-e29a2926cafa is already settled by stl_EUR_2989791 line 25
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
26capture01a1ab43-bfc1-7fdc-b175-ee73508d0131€24.00€0.37duplicate line
64capture01a1ab45-f2e8-79d2-9af1-61bdc8ab510c€9.00€0.20fee difference
108capture01a1ab49-70f2-7844-ace6-7bf7c9431bc2€49.00€0.70fee difference
1capture01a1ab3d-9e98-7cc0-a7a1-f26a8f73a5d3€35.00€0.50matched
2capture01a1ab3e-adbd-75f5-a57c-44a3a8073d86€24.00€0.37matched
3capture01a1ab40-45d2-724b-a760-ac00efc0d4f8€9.00€0.19matched
4capture01a1ab42-32da-7c02-a4fb-c87f1d0351a0€35.00€0.50matched
5capture01a1ab42-5609-70fe-beba-c1ef8f03f6b5€24.00€0.37matched
6capture01a1ab42-5ac1-78b0-bd26-51be3a20f2f0€49.00€0.67matched
7capture01a1ab42-5bb0-728d-8d0d-90689c39226b€49.00€0.67matched
8capture01a1ab42-7455-722d-8fe9-f582a2a0600c€24.00€0.37matched
9capture01a1ab42-beb6-777b-bc39-071f7d2d7cda€49.00€0.67matched
10capture01a1ab42-cdf8-745a-8988-1d9626d23799€24.00€0.37matched
11capture01a1ab42-daf1-76dd-bde4-2d5dc565e77b€9.00€0.19matched
12capture01a1ab42-fca9-77e4-94ae-ee5a8ebd7664€9.00€0.19matched
13capture01a1ab43-002f-72da-b93d-fd7d1de9c428€49.00€0.67matched
14capture01a1ab43-1b96-77a2-b3dc-f2946b8bac54€15.00€0.26matched
15refund01a1ab43-2be6-7e33-9638-e9eeba9ee943-€4.00€0.00matched
16capture01a1ab43-34e5-751c-95d9-276007047529€9.00€0.19matched
17capture01a1ab43-68df-7db6-a700-7f3b598b62a0€15.00€0.26matched
18capture01a1ab43-83a7-713e-a3ba-1e49ae8116fa€35.00€0.50matched
19capture01a1ab43-8607-7540-a500-707bbc4bac21€15.00€0.26matched
20capture01a1ab43-869d-71f0-a573-c1d77b2ed6b5€35.00€0.50matched
21capture01a1ab43-8e52-7f62-9cc8-7fd9f55fe8f0€9.00€0.19matched
22capture01a1ab43-9424-7b90-93d9-bb730428bab1€9.00€0.19matched
23capture01a1ab43-96af-7b4f-a246-89ebcee5ea32€35.00€0.50matched
24capture01a1ab43-9cd3-7952-8597-b5c082b15bed€35.00€0.50matched
25capture01a1ab43-bfc1-7fdc-b175-ee73508d0131€24.00€0.37matched
27capture01a1ab43-ed36-74bf-8528-0e802a6fbd43€9.00€0.19matched
28refund01a1ab43-f2dd-7363-afb3-4b302a1a9946-€9.00€0.00matched
29capture01a1ab43-f919-7b90-9570-9e58a5b04bbf€35.00€0.50matched
30capture01a1ab44-0676-7b3f-952f-f6acee034c9c€24.00€0.37matched
31capture01a1ab44-1bd3-75bd-b8ac-db847272f0ac€24.00€0.37matched
32capture01a1ab44-1c3a-7f84-91d3-e2391e0cac3d€35.00€0.50matched
33capture01a1ab44-1d1e-7c65-a7d2-77bb8edf73d6€15.00€0.26matched
34capture01a1ab44-22dd-7405-9ab6-a45a6c04091d€49.00€0.67matched
35capture01a1ab44-2927-75f3-a213-306fbe9ab541€15.00€0.26matched
36capture01a1ab44-4489-75ff-a578-db9c53d57d53€24.00€0.37matched
37capture01a1ab44-5011-79c1-a374-8680af362355€35.00€0.50matched
38capture01a1ab44-562d-7fa9-b1a7-7625125a447b€15.00€0.26matched
39capture01a1ab44-5930-7178-b72d-e45608559834€49.00€0.67matched
40capture01a1ab44-6e6e-7486-a8d1-71dbcecdb098€15.00€0.26matched
41capture01a1ab44-7948-78e2-a49d-1224e622d655€35.00€0.50matched
42capture01a1ab44-7e71-761e-999f-67f8b91f4c52€49.00€0.67matched
43capture01a1ab44-8225-760f-b5c0-2214c9701454€24.00€0.37matched
44capture01a1ab44-b74a-7966-879f-09c7d5b1f825€35.00€0.50matched
45capture01a1ab45-03ce-728f-82c3-7f141ed25991€35.00€0.50matched
46capture01a1ab45-03de-7ef0-87de-09709441fce2€9.00€0.19matched
47refund01a1ab45-0893-7e28-bb46-37066064a11e-€10.00€0.00matched
48capture01a1ab45-1965-770f-b0b3-5ef3f33c5b89€35.00€0.50matched
49capture01a1ab45-1dc5-7448-b157-990e57cb8c7d€49.00€0.67matched
50capture01a1ab45-29b9-7d6d-8c93-4746250936ff€49.00€0.67matched
51capture01a1ab45-5082-7372-b819-ed8fe28e05fe€9.00€0.19matched
52capture01a1ab45-5c15-7317-85ca-806a62b0273b€24.00€0.37matched
53refund01a1ab45-6147-7baf-9836-44eab46b414a-€17.00€0.00matched
54capture01a1ab45-6bda-7c69-ac07-bd7724ff4792€15.00€0.26matched
55capture01a1ab45-6e92-79ee-9e31-43c35f2972c6€24.00€0.37matched
56capture01a1ab45-7177-7646-bb4f-bc1f694879a9€35.00€0.50matched
57capture01a1ab45-8aec-7ca3-b303-1324c544e083€49.00€0.67matched
58capture01a1ab45-9b01-7fa7-9199-272f08be01dd€24.00€0.37matched
59capture01a1ab45-a092-7a02-95e5-c85d6ef5501a€24.00€0.37matched
60capture01a1ab45-a914-744a-ba10-df3d06eceb86€9.00€0.19matched
61capture01a1ab45-bba5-700c-8953-f6843d166aa0€24.00€0.37matched
62refund01a1ab45-cde2-7a9b-96fa-0ab185a6dfba-€3.00€0.00matched
63capture01a1ab45-eeac-7ba3-bff2-2a7a37bbc441€9.00€0.19matched
65capture01a1ab46-0b8b-7eab-85bc-bdac6abbcf25€35.00€0.50matched
66capture01a1ab46-0c69-7f2e-8c28-b3ac05870367€35.00€0.50matched
67capture01a1ab46-3ba6-7e18-8dab-94d6a443e488€9.00€0.19matched
68capture01a1ab46-49b0-77f3-b6b9-d0b119bfaa33€9.00€0.19matched
69capture01a1ab46-58a1-77a1-ab59-e008a7745c8e€35.00€0.50matched
70capture01a1ab46-643b-7c50-b0ee-1f9f03605013€24.00€0.37matched
71capture01a1ab46-64c5-7fbd-a5eb-7a353113a706€15.00€0.26matched
72capture01a1ab46-75db-7fd5-b999-c756fe0858ae€24.00€0.37matched
73capture01a1ab46-9443-797e-8c51-f70429430e53€49.00€0.67matched
74capture01a1ab46-a042-7a1a-8420-a8c80e8651cf€49.00€0.67matched
75capture01a1ab46-c399-76c1-83ae-a60d631cccea€24.00€0.37matched
76refund01a1ab46-d4ac-7f06-aee1-d8ab96f2cb84-€5.00€0.00matched
77capture01a1ab46-f186-7452-abd3-75a7ea978a23€9.00€0.19matched
78capture01a1ab46-f95e-748c-b9c9-bfcd1f350587€24.00€0.37matched
79capture01a1ab47-0e8b-73ab-89f6-0d84f5ed5779€49.00€0.67matched
80capture01a1ab47-1db8-7126-89ad-35999e317064€49.00€0.67matched
81capture01a1ab47-1f0d-75b5-a4cb-d84227ba40ca€9.00€0.19matched
82capture01a1ab47-2aa4-7cc3-b914-3fd8b4da2369€49.00€0.67matched
83capture01a1ab47-8816-79f1-8198-42429e1c03a0€15.00€0.26matched
84capture01a1ab47-9889-7a8c-a403-7fcb420f7797€15.00€0.26matched
85capture01a1ab47-a02a-7123-8fce-2eae4a8f716b€35.00€0.50matched
86capture01a1ab47-b276-7d17-9544-ccd4ac7669a3€24.00€0.37matched
87capture01a1ab47-ba31-78e3-ba0d-5c56f427cc2b€35.00€0.50matched
88capture01a1ab47-c58e-730e-a9f3-967300531882€24.00€0.37matched
89capture01a1ab47-c634-73a4-875b-39e2170e021e€35.00€0.50matched
90capture01a1ab47-fef4-70dc-bf26-052967cb694f€49.00€0.67matched
91capture01a1ab48-1ae9-7c3f-89e9-4696230292fb€9.00€0.19matched
92capture01a1ab48-23f8-70bc-9de3-8e8281288b04€24.00€0.37matched
93capture01a1ab48-2501-7659-8d19-fa6b516e743b€24.00€0.37matched
94capture01a1ab48-4f51-7669-bd16-68e1baf257ba€35.00€0.50matched
95capture01a1ab48-5d33-7720-8f30-3ad1ac97a6dc€49.00€0.67matched
96capture01a1ab48-8a6f-7e0b-adb8-8f0f6e291c45€9.00€0.19matched
97capture01a1ab48-c876-7560-b85f-916ef878b7c4€49.00€0.67matched
98capture01a1ab48-d378-7a8e-b8c4-104d688e2be4€24.00€0.37matched
99capture01a1ab48-e8c8-75ba-8f2a-0c4f850c9461€35.00€0.50matched
100capture01a1ab48-faf6-77ac-831b-b5019d8b3ec3€9.00€0.19matched
101capture01a1ab49-2091-7d58-ad2d-81b44f39017a€15.00€0.26matched
102capture01a1ab49-20b8-7e52-8903-0b8b20b7dbdc€24.00€0.37matched
103capture01a1ab49-28c1-70a5-9433-355153423f91€24.00€0.37matched
104capture01a1ab49-40d1-7f7e-a4e7-8c7949d3dab1€24.00€0.37matched
105capture01a1ab49-47bd-76b4-89f7-7e6e480844f4€49.00€0.67matched
106capture01a1ab49-556f-75aa-a1c8-1659de9b8824€9.00€0.19matched
107capture01a1ab49-6c3c-7726-8704-b47e63439551€35.00€0.50matched
109capture01a1ab49-74d1-7f56-803b-2f85042feeb2€15.00€0.26matched
110refund01a1ab49-7ac8-7945-8470-ce2614fbb140-€20.00€0.00matched
111capture01a1ab49-9699-7111-a1de-c12148009173€49.00€0.67matched
112capture01a1ab49-ad62-7a0a-98a2-7dad950dd444€15.00€0.26matched
113capture01a1ab49-b5b9-7938-b51f-45d26b4b16cc€9.00€0.19matched
114capture01a1ab49-c8c0-73e3-92ec-e46af811d511€15.00€0.26matched
115capture01a1ab49-d7e9-7698-adc1-443d72e01d67€9.00€0.19matched
116capture01a1ab49-ebaa-742c-ba02-347d76fb5874€49.00€0.67matched
117capture01a1ab49-f452-79b0-9022-96a5775d69b9€9.00€0.19matched
118capture01a1ab49-f61b-7956-b9f5-b65c274dd883€24.00€0.37matched
119capture01a1ab4a-1c1f-78a9-9983-ee4eaebb0945€15.00€0.26matched
120capture01a1ab4a-1e81-7e30-accb-3d6db66e958d€49.00€0.67matched
121capture01a1ab4a-2201-7625-ba7b-8987afd22575€24.00€0.37matched
122capture01a1ab4a-457f-7858-90f1-878c2d2ec3bc€9.00€0.19matched
123capture01a1ab4a-5606-7d79-a8be-a37aa90c4cc0€9.00€0.19matched
124capture01a1ab4a-5cba-74ba-b2ec-888ec888b8e2€24.00€0.37matched
125capture01a1ab4a-a2dc-7ee8-a0e9-dea2b2ab948d€15.00€0.26matched
126capture01a1ab4a-b4ec-7fcd-8c2c-aee44bbcbe1f€49.00€0.67matched
127capture01a1ab4a-c079-710a-8078-0547d094bef0€15.00€0.26matched
128capture01a1ab4a-c5f6-7969-bd92-faae229f8770€35.00€0.50matched
129capture01a1ab4a-ed6b-746e-8d4b-55b3e84cac69€15.00€0.26matched
130capture01a1ab4a-f679-79c2-8089-fdb049beda04€15.00€0.26matched
131capture01a1ab4b-1bd9-720c-b494-15fe17a45d57€24.00€0.37matched