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

6 Nov, 06:30

Gross

€3,052.00

PSP fee

€48.41

Net to the bank

€3,003.59

Settlement journal

#411401

Breaks for a person to look at

  • missing linein the books, not in the filerefund:01a1af94-c790-7643-a89c-2f62befc1559 is in no file
  • missing linein the books, not in the filecapture:01a1af8f-a01c-7cb5-a3ed-c5da42ef3df0 is in no file
LineKindReferenceGrossFeeStatus
1refund01a1af89-d793-7d84-9d89-7c78796dc477-€35.00€0.00matched
2capture01a1af8c-f9ec-79e3-a857-00348b0a784c€49.00€0.67matched
3capture01a1af8d-5779-720d-a896-887862e1caf2€15.00€0.26matched
4capture01a1af8d-75a1-7e03-9b5c-c771c17f6d23€24.00€0.37matched
5capture01a1af8d-827b-7a5a-826d-05400ba3a784€9.00€0.19matched
6capture01a1af8d-ffc6-7c5a-a1a9-698a2992ae63€15.00€0.26matched
7capture01a1af8e-08e8-7a17-9ebe-20dea31f6332€15.00€0.26matched
8capture01a1af8e-13ec-73e4-befa-e16e8bc68965€49.00€0.67matched
9capture01a1af8e-3fb8-7c7d-a702-7f5c53c63bcb€15.00€0.26matched
10capture01a1af8e-41a5-78e8-a921-cb15ffcf0248€9.00€0.19matched
11capture01a1af8e-6c10-7c80-8d5b-aaad602ff0dc€35.00€0.50matched
12capture01a1af8e-93e5-7be9-b5c9-1b682e8df31f€15.00€0.26matched
13capture01a1af8e-a6c6-7a8c-9f1e-b9892be3bb54€49.00€0.67matched
14capture01a1af8e-b05b-7e44-83f4-3fab8a02295f€49.00€0.67matched
15capture01a1af8e-b5cf-7639-b626-f722f1dd80ca€35.00€0.50matched
16capture01a1af8e-bc5f-7d33-92fb-36874958e176€49.00€0.67matched
17capture01a1af8e-c791-77f9-ab31-1c98d20a2b36€24.00€0.37matched
18capture01a1af8e-fce4-7065-a522-34b9a08011a9€35.00€0.50matched
19capture01a1af8f-110e-7528-b317-2c8ffdbcd411€24.00€0.37matched
20capture01a1af8f-2e57-704d-a903-f085c0ab5c62€49.00€0.67matched
21capture01a1af8f-5000-7a4a-9dca-d6993d6b8d0d€24.00€0.37matched
22capture01a1af8f-519c-77f0-939e-44353c967268€24.00€0.37matched
23capture01a1af8f-700b-708c-8305-2e37d143f33a€49.00€0.67matched
24capture01a1af8f-9524-74aa-aa59-68883dc03766€49.00€0.67matched
25capture01a1af8f-a478-77df-9a37-344f76cedc54€15.00€0.26matched
26capture01a1af8f-a9dd-7e76-bfb3-36b1fc24aae8€24.00€0.37matched
27capture01a1af8f-b99c-7c87-a684-dabb1a2f8ad2€24.00€0.37matched
28refund01a1af8f-c04d-72d0-ad6d-93c34ea09a34-€8.00€0.00matched
29capture01a1af8f-ca9b-75d5-90c7-e4a5a4d13c58€49.00€0.67matched
30capture01a1af8f-ce6b-78b9-b3a8-27fa86ded416€24.00€0.37matched
31capture01a1af8f-d212-7f49-ac17-96969d98e9b8€9.00€0.19matched
32capture01a1af8f-f5c4-7f76-86b8-cbfe967a62e5€24.00€0.37matched
33capture01a1af90-0ed9-7823-abd9-69e3dc2a601f€9.00€0.19matched
34capture01a1af90-414a-7a5c-9589-b0adae890e4a€15.00€0.26matched
35capture01a1af90-4f2b-782d-92c9-595451dcc624€24.00€0.37matched
36capture01a1af90-57a7-7899-a61c-e1573d9b918e€9.00€0.19matched
37capture01a1af90-5a44-7d0f-9745-db7aeb645535€49.00€0.67matched
38capture01a1af90-6fc1-7f9e-894d-a0fe01adcf90€24.00€0.37matched
39capture01a1af90-7108-79cf-aeb1-411f82f21fc0€24.00€0.37matched
40capture01a1af90-846c-7c87-902f-668db931ec7a€9.00€0.19matched
41capture01a1af90-984c-77b8-be4f-538fc39fd830€49.00€0.67matched
42capture01a1af90-a253-75ba-aa27-3ee29ad30c5f€15.00€0.26matched
43capture01a1af90-ae9d-7a39-ae0a-a114f5dd835e€24.00€0.37matched
44refund01a1af90-c818-7099-baee-06193a9c5940-€8.00€0.00matched
45capture01a1af90-c8c8-7f00-8eaf-2a0eed1b3cd7€49.00€0.67matched
46capture01a1af90-e0ed-7555-b766-09922156106c€24.00€0.37matched
47capture01a1af90-e485-7100-9df5-69c2fb1c4488€35.00€0.50matched
48capture01a1af90-fb30-709e-bd63-409a70adf9cf€49.00€0.67matched
49capture01a1af91-189b-756f-b321-74a7d11b58fb€9.00€0.19matched
50refund01a1af91-3335-7815-b0c8-136b50fe173f-€21.00€0.00matched
51capture01a1af91-738f-7a66-9a5c-a75788258c2a€15.00€0.26matched
52capture01a1af91-959a-76d9-a1ce-b2903bfec7b9€49.00€0.67matched
53capture01a1af91-96c0-765c-94ba-9b226417b5c0€35.00€0.50matched
54capture01a1af91-cea4-7933-ab0c-a529a0aefb5b€49.00€0.67matched
55capture01a1af91-d986-729c-8d39-087a2a259e52€15.00€0.26matched
56capture01a1af91-ed1b-79a5-afa5-cd9474aaee29€35.00€0.50matched
57capture01a1af91-f9bb-70c8-949e-728b31f7d514€24.00€0.37matched
58capture01a1af92-09ef-7956-bbf8-139a68a34799€35.00€0.50matched
59refund01a1af92-1f00-7b89-b284-a0a1ea9d9abc-€43.00€0.00matched
60capture01a1af92-498a-743e-b0aa-4236f373f4f4€15.00€0.26matched
61capture01a1af92-61a2-79fd-bf02-cebdcb0c07b2€35.00€0.50matched
62capture01a1af92-6c4d-7841-9631-48a5641f7c17€9.00€0.19matched
63capture01a1af92-83dd-7bbd-abbb-fe921f0fc654€24.00€0.37matched
64capture01a1af92-85d1-75ab-ab05-6062789f7416€9.00€0.19matched
65capture01a1af92-8c89-7d6a-8529-c519974b9cc9€9.00€0.19matched
66capture01a1af92-9d81-73c8-b19c-9e851c0fc357€15.00€0.26matched
67capture01a1af92-a985-7e03-8a6a-3d53d003a4f8€9.00€0.19matched
68capture01a1af92-b620-7793-87ea-945514acf97e€35.00€0.50matched
69capture01a1af92-bba3-7941-a966-81af40b4aeb9€24.00€0.37matched
70capture01a1af92-cc71-7477-a846-04af9e89672f€35.00€0.50matched
71capture01a1af92-ced3-75c4-a045-e2de4605256b€49.00€0.67matched
72capture01a1af92-d143-7cbe-b4fb-73f3ea540493€49.00€0.67matched
73capture01a1af92-ddfd-7dfa-a093-b883db1e8536€49.00€0.67matched
74capture01a1af92-e1cf-7c23-bfd0-5fe9bde995fd€9.00€0.19matched
75refund01a1af92-f0e4-7893-a126-3148d850987e-€9.00€0.00matched
76capture01a1af93-0bf7-7d81-aec0-b71d5047f410€35.00€0.50matched
77capture01a1af93-2200-7a13-8504-d55fbd213ed6€49.00€0.67matched
78capture01a1af93-262e-75d2-9af0-2dd501366547€24.00€0.37matched
79capture01a1af93-2bfc-7217-a5c0-71ccb0da1ec9€24.00€0.37matched
80capture01a1af93-3cde-7916-8c45-e298ed9382d9€49.00€0.67matched
81capture01a1af93-46e8-7664-9eba-a07a1dc79687€35.00€0.50matched
82capture01a1af93-489d-72ec-b159-9af6cde9f7c9€24.00€0.37matched
83capture01a1af93-68de-7cde-a6fe-e583dcb625d9€49.00€0.67matched
84capture01a1af93-6cf7-7db3-992c-2aa414e6a0b3€24.00€0.37matched
85capture01a1af93-7748-706e-9714-6808f2e94d38€49.00€0.67matched
86capture01a1af93-8513-711f-8280-c8a910bd424c€9.00€0.19matched
87capture01a1af93-894b-72b1-87b9-ce1b89d9dd31€9.00€0.19matched
88capture01a1af93-9d38-7f02-ade6-01ec5d8511a7€9.00€0.19matched
89capture01a1af93-b017-7988-a5df-7d9e18d4a37f€24.00€0.37matched
90refund01a1af93-b925-7229-9433-60feef904d53-€22.00€0.00matched
91capture01a1af93-bbad-7e97-a450-770e41ff762a€49.00€0.67matched
92capture01a1af93-ccda-7a00-aaa9-eb5f7f720b4f€9.00€0.19matched
93capture01a1af93-d506-7bc4-86e8-ba908001dabc€15.00€0.26matched
94capture01a1af93-de60-729c-9c52-14b47493aa51€15.00€0.26matched
95capture01a1af93-f1c0-7d6c-8d20-382484bd7e2d€35.00€0.50matched
96capture01a1af93-f9e3-7715-93a1-b428efa90e09€49.00€0.67matched
97capture01a1af94-1fa1-7903-a5bb-93e8983690d0€15.00€0.26matched
98capture01a1af94-2325-74c2-bc90-c2a2ba92663a€35.00€0.50matched
99capture01a1af94-26f1-7441-a73c-d6ad74e3eac7€24.00€0.37matched
100capture01a1af94-2a3c-7d0a-bf86-11ee9fde4890€49.00€0.67matched
101capture01a1af94-455e-706a-ae4e-78fafaa00141€9.00€0.19matched
102refund01a1af94-4ab4-7cd5-956f-0a383d180e86-€15.00€0.00matched
103capture01a1af94-6b43-738b-81ed-5b5348538d37€35.00€0.50matched
104capture01a1af94-6f04-747a-b32c-2454d4dafc2e€49.00€0.67matched
105capture01a1af94-7924-7db3-b9a5-01a737c6e2a4€9.00€0.19matched
106capture01a1af94-8c23-745c-abb0-2be7ec379a60€35.00€0.50matched
107capture01a1af94-9bf8-72a1-8565-0314b0bd045b€35.00€0.50matched
108capture01a1af94-dc7d-7ddc-a4e1-e402501d3e9d€24.00€0.37matched
109capture01a1af94-e5f1-784b-839e-75a49ea2f83f€15.00€0.26matched
110capture01a1af94-f7ff-71b8-8980-7b1cc387121c€24.00€0.37matched
111capture01a1af94-f913-7e1d-b0a2-645b3ac9791e€24.00€0.37matched
112capture01a1af95-0309-7934-a6d8-e052172e8a0f€15.00€0.26matched
113capture01a1af95-0b8a-7237-b9ea-d52f68b32ebe€24.00€0.37matched
114capture01a1af95-104d-7d26-81c9-ec7ad20fffd0€15.00€0.26matched
115capture01a1af95-1dd0-7dd0-b406-e1bc7d7a56c8€24.00€0.37matched
116capture01a1af95-280b-7878-809a-811a28f6ff30€24.00€0.37matched
117capture01a1af95-2a87-7da7-adf7-f615ba1f3caa€49.00€0.67matched
118capture01a1af95-4610-7c99-957e-561a4857ca47€24.00€0.37matched
119refund01a1af95-4714-73c9-ac1d-ba31062c0662-€6.00€0.00matched
120capture01a1af95-530d-7ffc-a735-0bc863418a44€9.00€0.19matched
121refund01a1af95-60fe-741f-a1ad-8f0b311a0da3-€14.00€0.00matched
122capture01a1af95-70f3-7262-95b8-7f1b58ae8f50€15.00€0.26matched
123refund01a1af95-8db0-7216-b490-830ef2602e60-€8.00€0.00matched
124capture01a1af95-94cc-78e4-a6de-6e9256a44945€24.00€0.37matched
125capture01a1af95-b5fd-739e-b1df-2e5dcdafe9de€15.00€0.26matched
126capture01a1af95-d4f2-720a-a8ec-ee725dc97bf5€49.00€0.67matched
127capture01a1af95-d940-73b5-a995-a5d2e1c7aed8€35.00€0.50matched
128capture01a1af95-d9ec-78ca-a376-976020bad0bd€24.00€0.37matched