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, 22:30

Gross

€3,118.00

PSP fee

€49.10

Net to the bank

€3,068.90

Settlement journal

#405273

Breaks for a person to look at

  • missing linein the books, not in the filecapture:01a1add5-9b6d-7ca1-a872-565f6be67039 is in no file
  • missing linein the books, not in the filecapture:01a1add9-de93-7b62-9560-20755bc74d05 is in no file
  • missing linein the books, not in the filecapture:01a1addc-99cc-79db-967a-89a591738e81 is in no file
LineKindReferenceGrossFeeStatus
1capture01a1add0-09d1-7742-ad09-13a7d34b272e€49.00€0.67matched
2capture01a1add5-5fd1-7789-8a1c-792a0d76ab4d€15.00€0.26matched
3capture01a1add5-7e76-7fca-80af-8671780d5272€15.00€0.26matched
4capture01a1add5-8b56-7c07-b718-e8f9cdda32e0€9.00€0.19matched
5capture01a1add5-af22-74b2-9175-69bedabeec35€9.00€0.19matched
6capture01a1add5-c639-7632-b598-9e6a3edcf169€24.00€0.37matched
7capture01a1add5-c7e3-7441-8933-629be2cfdf46€49.00€0.67matched
8capture01a1add5-cd3f-710f-a794-68b85a100a7e€35.00€0.50matched
9capture01a1add5-d74d-75e0-9e38-6c5333cafb39€35.00€0.50matched
10capture01a1add5-db9c-7edb-83f3-b064333d6a7b€24.00€0.37matched
11capture01a1add5-edc6-79fe-93f5-97148b10cc05€15.00€0.26matched
12capture01a1add6-05a4-7615-859e-2b819c260b18€9.00€0.19matched
13refund01a1add6-2304-7b92-84ee-97057c2b3aec-€22.00€0.00matched
14capture01a1add6-3ecb-76c9-a6fa-3d2963b2a3a8€35.00€0.50matched
15capture01a1add6-4c7d-7977-90cd-7281b1fed72e€35.00€0.50matched
16capture01a1add6-5408-75e9-be82-a4195195353a€9.00€0.19matched
17refund01a1add6-5e51-7586-9f9e-52697217a0de-€11.00€0.00matched
18capture01a1add6-9238-79ee-8025-7503f7349dca€9.00€0.19matched
19capture01a1add6-ad64-7b7c-a9b3-bf11efed02bb€24.00€0.37matched
20capture01a1add6-b69b-7432-b3d7-8d77d1dc053c€24.00€0.37matched
21capture01a1add6-cf33-785c-bbdb-ce6c90acde1b€49.00€0.67matched
22capture01a1add6-d9c1-71b7-8619-fc9ab60f09be€24.00€0.37matched
23capture01a1add6-dc79-7f3c-95e7-a5e1e9872c3d€24.00€0.37matched
24capture01a1add6-efd5-7248-a447-a45a3710dc51€15.00€0.26matched
25capture01a1add7-0af5-71ec-b294-c0e4f55dba64€49.00€0.67matched
26capture01a1add7-29ee-78ce-a1bb-b4a80a32dc8c€24.00€0.37matched
27capture01a1add7-3387-7910-84d1-d95f59b8f628€9.00€0.19matched
28capture01a1add7-38b3-7056-bd37-5da1eee3b753€35.00€0.50matched
29capture01a1add7-4e01-7f2e-8a6d-d09ccb38cabe€35.00€0.50matched
30capture01a1add7-89ab-7a4f-9d32-3b5aa9825fce€15.00€0.26matched
31capture01a1add7-88bf-718a-ad1a-997900339445€49.00€0.67matched
32capture01a1add7-991d-77a2-9b4e-b3cca6884444€15.00€0.26matched
33capture01a1add7-e12e-799b-b545-4f8424d5541a€35.00€0.50matched
34capture01a1add7-e39d-75f2-92fa-dba7df157fe6€49.00€0.67matched
35capture01a1add7-f279-7b20-9e97-9a48f5abfd7f€35.00€0.50matched
36capture01a1add7-fa17-7a4c-a370-e7e82f7e2b72€35.00€0.50matched
37capture01a1add7-fc7d-7d8e-8b12-1897be0ebb14€15.00€0.26matched
38capture01a1add8-0e16-72d2-832d-b6de6d6a0210€49.00€0.67matched
39refund01a1add8-22bc-71cc-9361-fee5df3d9bc7-€24.00€0.00matched
40capture01a1add8-487b-7ce3-9b39-94bdd12cf74e€35.00€0.50matched
41refund01a1add8-5037-73bb-8b45-6510a941d2db-€20.00€0.00matched
42capture01a1add8-5df0-769d-8d16-9f58799eca98€49.00€0.67matched
43capture01a1add8-6620-7901-a52f-e0ac1a86cb5b€49.00€0.67matched
44capture01a1add8-786a-7bfe-b093-6b9da34caa40€9.00€0.19matched
45capture01a1add8-91e7-7076-a188-2f206765ad15€49.00€0.67matched
46capture01a1add8-ae18-7d2b-83cc-5021720288a1€35.00€0.50matched
47capture01a1add8-b1d5-767f-9355-57bab60b1d4f€24.00€0.37matched
48capture01a1add8-cd9d-7385-81a3-8a8ea1e2567e€49.00€0.67matched
49capture01a1add8-f618-7c50-983b-59fe2fa3feb6€35.00€0.50matched
50refund01a1add8-f85d-783a-afb6-0245303e7946-€21.00€0.00matched
51capture01a1add9-0c2b-7a76-84e1-5cbcfff28fb9€35.00€0.50matched
52capture01a1add9-11a5-7a04-8306-b1753bef5abd€35.00€0.50matched
53capture01a1add9-2ef1-776b-8df2-4da80f9c9598€24.00€0.37matched
54capture01a1add9-2f83-7d25-9964-c27e3e7bfede€15.00€0.26matched
55capture01a1add9-4b14-705b-acca-94c32f99ae9d€9.00€0.19matched
56capture01a1add9-4f41-738d-be87-37e07b1afbc8€49.00€0.67matched
57capture01a1add9-5f6c-74b4-aac1-fb69fffb13d0€35.00€0.50matched
58capture01a1add9-b120-7451-8a3e-ea880526a152€35.00€0.50matched
59refund01a1add9-bada-7973-913b-51d3a7dc3baa-€16.00€0.00matched
60refund01a1add9-c7f2-7bc3-af0b-f726d2ebe557-€10.00€0.00matched
61capture01a1add9-ffe5-7a63-9cd9-faed4e3827e9€24.00€0.37matched
62capture01a1adda-15d0-73db-8f10-2140a13feeeb€24.00€0.37matched
63capture01a1adda-486a-7cc0-810a-ceb4dde6a88c€15.00€0.26matched
64capture01a1adda-3fe8-72c4-8df1-357f46c00bfb€9.00€0.19matched
65capture01a1adda-6449-79b2-b71f-71e6f19a95fe€24.00€0.37matched
66capture01a1adda-719f-7cd6-bcaa-6a20b6a0a270€15.00€0.26matched
67capture01a1adda-8971-7619-8af6-278727ef8cc6€35.00€0.50matched
68capture01a1adda-9bc9-7875-834a-56f2f4fe7ecf€35.00€0.50matched
69capture01a1adda-b540-76e1-80a3-42d1ea1e3452€15.00€0.26matched
70capture01a1adda-ee86-7c00-b58a-18dfd1f0d278€49.00€0.67matched
71capture01a1adda-f159-7a3e-b8c1-d8ff596fbbfd€49.00€0.67matched
72capture01a1addb-2da0-75bc-8030-54721a608cdc€35.00€0.50matched
73capture01a1addb-3549-796f-8dcf-5c8e42ee852f€49.00€0.67matched
74capture01a1addb-4634-7740-a8cd-c41ea66ab571€9.00€0.19matched
75capture01a1addb-5f22-7357-b83e-9c31072e8614€24.00€0.37matched
76capture01a1addb-68a2-7bae-aa63-d175d3ad2354€24.00€0.37matched
77capture01a1addb-6d12-7965-ae8d-3d5200c1ba9b€15.00€0.26matched
78capture01a1addb-6d41-7dc6-a684-1e366d1de644€49.00€0.67matched
79capture01a1addb-76e9-7ec9-8890-7e681fd93c64€9.00€0.19matched
80capture01a1addb-6cf9-7e2b-a1ac-36cefd84d50e€15.00€0.26matched
81capture01a1addb-8484-779b-b670-bf30dda48b45€24.00€0.37matched
82capture01a1addb-9873-7e6f-9d72-52b757496f5d€24.00€0.37matched
83capture01a1addb-9d46-704d-bf7b-84eb254d7aee€49.00€0.67matched
84capture01a1addb-b2fd-7e87-a601-61d37faf3788€35.00€0.50matched
85capture01a1addb-cc3e-7cd9-a9cc-e9c36ba43657€24.00€0.37matched
86capture01a1addb-d715-7448-9bcb-85c3d20b689c€49.00€0.67matched
87capture01a1addb-e286-75ac-9373-ae735dec727c€24.00€0.37matched
88capture01a1addc-00c4-747a-92df-ea6ea17b5f58€9.00€0.19matched
89refund01a1addc-1f86-756c-bde3-a5c40227765a-€8.00€0.00matched
90capture01a1addc-23ff-76e8-9530-8db82bba7e8c€15.00€0.26matched
91refund01a1addc-33e2-74e7-8edc-3259c74627a8-€3.00€0.00matched
92capture01a1addc-340c-7097-a164-4d0029c6b89f€24.00€0.37matched
93capture01a1addc-3668-7a70-a9d5-4ea51f4a10dc€24.00€0.37matched
94capture01a1addc-47b9-73f1-8c39-7821114cfe59€49.00€0.67matched
95capture01a1addc-4ae0-701b-811f-3c34b508a443€24.00€0.37matched
96capture01a1addc-67a6-7ab5-81cd-23424b8c0839€9.00€0.19matched
97capture01a1addc-6cfa-7089-89be-778d44de5ee4€35.00€0.50matched
98capture01a1addc-7cdc-733e-a0e4-6016e9362da1€15.00€0.26matched
99capture01a1addc-8e7f-718f-a4b7-0e2b94575c97€15.00€0.26matched
100refund01a1addc-9195-7a50-9a74-74dcc9c55131-€22.00€0.00matched
101capture01a1addc-b693-76a9-bde1-a386bd84fcc7€35.00€0.50matched
102refund01a1addc-b7b2-7e18-8d5d-de1be9634ed1-€3.00€0.00matched
103capture01a1addc-cbdd-7914-b434-1a3c41d6dafa€49.00€0.67matched
104capture01a1addc-d484-723c-9e47-a478c5198690€49.00€0.67matched
105capture01a1addc-f6c1-7a8a-83ab-1ba53ed87523€35.00€0.50matched
106capture01a1addc-e995-73f4-8764-5705efa87b75€49.00€0.67matched
107capture01a1addd-2c4b-75ef-929d-b148ea983712€35.00€0.50matched
108capture01a1addd-35d4-72fd-be9f-73ce63c2932f€15.00€0.26matched
109capture01a1addd-3b67-75f6-83a4-02bc8471b20c€15.00€0.26matched
110capture01a1addd-4565-7e6e-96ad-624401a8b2bd€24.00€0.37matched
111capture01a1addd-5e84-7707-b5b6-0179c3086d49€9.00€0.19matched
112capture01a1addd-74d9-76cd-97ad-1eb53236e2d4€9.00€0.19matched
113capture01a1addd-8439-75c2-af13-50ab0b1f07e8€9.00€0.19matched
114capture01a1addd-85cb-71e3-ad69-9635a70a5345€49.00€0.67matched
115capture01a1addd-b0ce-74b2-8ae0-1bd3d65853cb€35.00€0.50matched
116capture01a1addd-ba67-7867-a047-5b1fad542959€24.00€0.37matched
117capture01a1addd-d424-71e8-9105-e6f42981c0e7€9.00€0.19matched
118capture01a1addd-da93-7019-b54f-acf8ad3dce58€49.00€0.67matched
119capture01a1addd-e458-7728-9d7c-bbbe11569eb7€49.00€0.67matched
120capture01a1addd-e4e3-7434-a5d3-b88482b01d1a€15.00€0.26matched
121capture01a1addd-e728-7ca8-877c-5f071b634865€49.00€0.67matched
122capture01a1adde-0923-7bce-ace4-766758c76f74€15.00€0.26matched
123capture01a1adde-0f4f-7d57-aef1-ebf0410f6a7d€9.00€0.19matched
124capture01a1adde-1ca8-7f0d-aa4e-6c945834f780€9.00€0.19matched
125capture01a1adde-254d-7ca2-b964-37ede4a23728€15.00€0.26matched
126capture01a1adde-3088-799e-9b36-c93d9767ce48€49.00€0.67matched
127refund01a1adde-4218-7201-9dde-aeb3a94ea72d-€15.00€0.00matched
128capture01a1adde-4349-7bdf-9237-6494735310dc€24.00€0.37matched
129capture01a1adde-529c-7904-881f-a7264e7d4ee3€9.00€0.19matched
130capture01a1adde-5731-711d-aaf8-b7171846e890€24.00€0.37matched