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

4 Nov, 19:30

Gross

€2,725.00

PSP fee

€43.71

Net to the bank

€2,681.29

Settlement journal

#384700

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • 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 21, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • missing linein the books, not in the filecapture:01a1a80f-d902-78d4-b606-50acbaff702d is in no file
LineKindReferenceGrossFeeStatus
19capture01a1a80b-138b-78d3-a53c-aad276fd6937€49.00€0.70fee difference
70capture01a1a80f-0302-70b4-8397-1e652012a12b€49.00€0.71fee difference
86capture01a1a810-0974-7a98-9abf-a6567c7a64a4€9.00€0.21fee difference
110capture01a1a811-ffa8-797d-9b26-90aa34abc0b3€9.00€0.24fee difference
1capture01a1a802-4f02-72a7-9ca8-09a03f66ef25€9.00€0.19matched
2capture01a1a803-39ac-7620-8a61-a97237615e0a€9.00€0.19matched
3capture01a1a804-70b5-7631-ac5d-8c7f70df452d€35.00€0.50matched
4capture01a1a804-dc89-7574-913b-3bb8447a70b0€24.00€0.37matched
5capture01a1a806-bb2e-78c1-ae30-59e406a2a11b€24.00€0.37matched
6capture01a1a80a-3e97-728e-af80-f53391921df2€15.00€0.26matched
7refund01a1a80a-43dc-7996-8475-6fc1449afa0e-€17.00€0.00matched
8capture01a1a80a-45d1-7013-bb21-e833229f7416€35.00€0.50matched
9capture01a1a80a-569e-7913-bd74-ce6797c52e93€35.00€0.50matched
10capture01a1a80a-6645-7544-8029-34c65a7ebc01€24.00€0.37matched
11capture01a1a80a-6bed-704b-a4e4-583f77346898€15.00€0.26matched
12capture01a1a80a-93b6-7f60-96c5-0e45b3a9e1e4€24.00€0.37matched
13capture01a1a80a-9710-74e2-8030-32bc7a662057€24.00€0.37matched
14capture01a1a80a-9e15-776f-924e-a6b85de5e808€15.00€0.26matched
15capture01a1a80a-b2e5-721a-9518-08f67de0fcca€49.00€0.67matched
16refund01a1a80a-f0f1-7931-9edb-0f097f2145ad-€9.00€0.00matched
17capture01a1a80a-ffba-73b5-84b5-3aebbf678581€9.00€0.19matched
18capture01a1a80b-0198-7271-85e8-56b410f0f65a€9.00€0.19matched
20capture01a1a80b-1c1a-7bd8-b132-c63f8814d344€15.00€0.26matched
21capture01a1a80b-2297-72b5-8563-879c04a91b2b€9.00€0.19matched
22capture01a1a80b-2b3e-7073-a391-ef21c67dbd3a€49.00€0.67matched
23capture01a1a80b-3026-739d-824a-eda8f1c7b071€49.00€0.67matched
24capture01a1a80b-427e-72fc-a1a1-f44a631d6f5c€35.00€0.50matched
25capture01a1a80b-5b4e-770d-af15-8e3ca0bc9421€15.00€0.26matched
26capture01a1a80b-5da9-7fd5-8496-89427fea07cb€49.00€0.67matched
27refund01a1a80b-685b-7093-a8c5-7b53fab2af6d-€4.00€0.00matched
28capture01a1a80b-9806-7d50-9cb6-251ced20e1f8€15.00€0.26matched
29capture01a1a80b-a484-763b-9483-4239c91663e4€49.00€0.67matched
30capture01a1a80b-aa1d-7191-afa2-b8155e45030c€35.00€0.50matched
31capture01a1a80b-ccd1-7e11-a3c2-8a42b5ec0a17€24.00€0.37matched
32capture01a1a80b-dd97-7eb8-ae39-998a65b39967€15.00€0.26matched
33capture01a1a80b-f971-7986-b7de-0f0b580227f3€24.00€0.37matched
34capture01a1a80c-0958-7066-a89e-c0e1b4a0885d€9.00€0.19matched
35capture01a1a80c-1247-74c0-8e62-e890e03a09b9€24.00€0.37matched
36capture01a1a80c-17a9-7690-b460-97d57a33c2c2€49.00€0.67matched
37capture01a1a80c-3065-711b-962d-5f000c9b5e7b€9.00€0.19matched
38capture01a1a80c-3dd8-7d44-be77-76e22d266265€15.00€0.26matched
39capture01a1a80c-47a4-77d3-aa3c-a246cbbdc0c1€9.00€0.19matched
40capture01a1a80c-73f9-7ddf-9949-9a29d1d3f72a€15.00€0.26matched
41capture01a1a80c-7418-747e-93ef-28a260a4d71f€9.00€0.19matched
42capture01a1a80c-897b-7885-9ec7-c52c911a5dda€15.00€0.26matched
43capture01a1a80c-ba6e-719c-9016-dc604783b82c€9.00€0.19matched
44capture01a1a80c-d941-7fdd-bb6d-3ce54e6847b6€24.00€0.37matched
45capture01a1a80d-07f9-7fee-9621-c55ada1346d5€9.00€0.19matched
46capture01a1a80d-26f1-7a85-b713-f77a31a6147f€15.00€0.26matched
47capture01a1a80d-33ad-7aac-aed4-171e3910d7d7€9.00€0.19matched
48capture01a1a80d-4661-72be-a6e0-88e505b741ed€15.00€0.26matched
49capture01a1a80d-53b6-766c-82ec-31a3747a939f€35.00€0.50matched
50capture01a1a80d-5a68-7069-80b3-197995281970€15.00€0.26matched
51capture01a1a80d-b0ed-75bc-8fcb-8dd0bc30064a€9.00€0.19matched
52capture01a1a80d-bd0b-7994-b8b1-bb3d846408fe€9.00€0.19matched
53capture01a1a80d-ca44-7840-bab7-887841e74d4e€9.00€0.19matched
54capture01a1a80e-0028-7580-b063-177984313e73€15.00€0.26matched
55capture01a1a80e-16b8-7d72-91ca-685bc78855e8€35.00€0.50matched
56capture01a1a80e-229d-720a-ac3b-2020cb30e175€35.00€0.50matched
57refund01a1a80e-244c-7dd5-9b49-af00e6e6e61b-€4.00€0.00matched
58capture01a1a80e-6685-70bb-b8c6-82d4c215848a€15.00€0.26matched
59capture01a1a80e-765a-710b-9162-8c0e64865034€49.00€0.67matched
60capture01a1a80e-785f-7564-b987-3f3025176239€49.00€0.67matched
61capture01a1a80e-7d4b-7018-bb95-2aa38cefe58d€49.00€0.67matched
62refund01a1a80e-8467-79b8-b9fe-b6d081b1db89-€18.00€0.00matched
63capture01a1a80e-91ea-7253-a9cd-9e6e19a20019€24.00€0.37matched
64capture01a1a80e-a5a2-73bc-a865-49b86515f6ea€9.00€0.19matched
65capture01a1a80e-a5f5-76e8-b0a7-1ae857f57a89€24.00€0.37matched
66capture01a1a80e-caee-7336-8ba7-1e411a556dce€24.00€0.37matched
67capture01a1a80e-e690-7841-8c17-8f36c98af6fb€35.00€0.50matched
68refund01a1a80e-e940-7c14-b9fd-44c54e34b36b-€47.00€0.00matched
69capture01a1a80e-fd1b-75e9-aff8-6f487a88ba28€49.00€0.67matched
71capture01a1a80e-ffb8-7561-8050-2d1f11b07181€35.00€0.50matched
72capture01a1a80f-2c03-7088-b572-705b4da528ba€9.00€0.19matched
73capture01a1a80f-5a27-7a6c-93f1-f2d6c9605f31€35.00€0.50matched
74capture01a1a80f-809f-7a08-bfb7-813be450ea53€24.00€0.37matched
75capture01a1a80f-94f6-71f6-8200-d9c53d0f72f7€15.00€0.26matched
76capture01a1a80f-98f2-79cc-8c25-90c3aaec554b€35.00€0.50matched
77capture01a1a80f-a873-7490-847a-643ec2e2e3c3€9.00€0.19matched
78capture01a1a80f-acb8-7d25-a9a0-a099f524e867€49.00€0.67matched
79capture01a1a80f-b647-76d7-9beb-d5692072dd62€24.00€0.37matched
80refund01a1a80f-b79b-76c4-93f4-d5c4c1af7c30-€10.00€0.00matched
81capture01a1a80f-b908-702f-8880-d1045108e677€9.00€0.19matched
82capture01a1a80f-bb74-7e44-8f36-0d59713d49f7€49.00€0.67matched
83capture01a1a80f-f077-7427-9b54-ba00f7282296€24.00€0.37matched
84capture01a1a80f-fb85-7f0e-b58e-2ba74e852b50€24.00€0.37matched
85capture01a1a810-02c1-78de-aadb-8d7d89e7312e€9.00€0.19matched
87capture01a1a810-2cef-77e3-8370-e3f99f2b4b98€24.00€0.37matched
88capture01a1a810-43b4-7e01-81df-ed80b145b13c€35.00€0.50matched
89capture01a1a810-51cf-76b1-9c7b-89445e2147c4€9.00€0.19matched
90capture01a1a810-6d2e-7ba5-9bbe-71b2d1c33af9€9.00€0.19matched
91capture01a1a810-79c2-7679-a80e-b1894f63e69a€15.00€0.26matched
92capture01a1a810-8a07-7d8e-ab8b-dbf6353ac7bb€24.00€0.37matched
93capture01a1a810-8bf8-75a8-b9a6-e09b6aa0ae64€24.00€0.37matched
94capture01a1a810-edcb-7f85-83a5-f2fd6cb74d7f€15.00€0.26matched
95capture01a1a810-fbaf-70c5-969d-88c785a82dea€35.00€0.50matched
96capture01a1a811-2453-72fc-a610-e620ceeb786d€49.00€0.67matched
97capture01a1a811-30ec-7721-aec6-972a05948a59€15.00€0.26matched
98capture01a1a811-3825-7371-8a1d-5fcee159d281€15.00€0.26matched
99capture01a1a811-3b6c-77e3-afe4-77c9b78f4816€9.00€0.19matched
100capture01a1a811-445f-7e95-8ff7-1e292d1c7a82€24.00€0.37matched
101capture01a1a811-62dc-78d4-a675-0f31c7bd23cb€15.00€0.26matched
102capture01a1a811-6aef-703a-8a4b-e4b17b679dec€9.00€0.19matched
103refund01a1a811-79b7-7845-8632-197d5ded8c30-€5.00€0.00matched
104capture01a1a811-a2d8-75e1-921d-76ebe002bef0€24.00€0.37matched
105capture01a1a811-b59a-7317-873e-bab8d787a8c3€35.00€0.50matched
106capture01a1a811-bcb4-732a-b4c3-d615ac65bf03€15.00€0.26matched
107capture01a1a811-cc60-78dc-b659-c705b41b0d66€9.00€0.19matched
108capture01a1a811-ebac-78e4-9d27-142a2cb7092f€35.00€0.50matched
109capture01a1a811-ecef-79dd-a120-3363dce0a15d€35.00€0.50matched
111capture01a1a812-0d5b-7bb0-a8d6-5c9aa6f0d530€49.00€0.67matched
112capture01a1a812-4c53-7377-b8b0-1dffbf8563b2€35.00€0.50matched
113capture01a1a812-5018-756b-b052-9ae3f7295636€24.00€0.37matched
114capture01a1a812-560f-79c7-bafe-e163996bf876€9.00€0.19matched
115capture01a1a812-5c58-7257-b4d5-9fe568c4df67€35.00€0.50matched
116capture01a1a812-9b6c-71ab-9355-46a684001331€35.00€0.50matched
117capture01a1a812-9df6-7636-af26-665b117ba536€9.00€0.19matched
118capture01a1a812-a30b-71d2-8feb-79f85cdbc3ab€49.00€0.67matched
119capture01a1a812-bb9e-7e24-bbea-9b78ae73e0a9€35.00€0.50matched
120capture01a1a812-c669-7e72-a7dd-e553a17f9c05€35.00€0.50matched
121capture01a1a812-ca39-79f2-a9f3-7ba763dece64€15.00€0.26matched
122capture01a1a812-ec96-7779-8e3b-918ab9d5fef2€35.00€0.50matched
123capture01a1a812-f1a8-7dfd-8a51-7d34d18dbf07€9.00€0.19matched
124capture01a1a813-222d-75ee-af23-8cbb8c6d9485€9.00€0.19matched
125capture01a1a813-3180-7b9e-b0a7-8569627c5e30€49.00€0.67matched