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

Gross

€3,302.00

PSP fee

€52.18

Net to the bank

€3,249.82

Settlement journal

#397615

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
1capture01a1aba8-c488-74d9-9967-c22621ddbcc5€24.00€0.37matched
2capture01a1aba9-6de0-78f0-ab10-13054add23d0€35.00€0.50matched
3capture01a1abad-37bd-7087-b1e8-320c828b915d€9.00€0.19matched
4capture01a1abaf-293a-7b28-9fb6-eee65e953a55€15.00€0.26matched
5refund01a1abb0-3c46-7636-8ec6-16c77318a46a-€7.00€0.00matched
6capture01a1abb0-4e31-7ec7-9908-70c8040a0baf€15.00€0.26matched
7capture01a1abb0-5d60-760a-9482-8f5908896853€15.00€0.26matched
8capture01a1abb0-5ea5-7327-8135-75ace4debe78€49.00€0.67matched
9capture01a1abb0-6cd7-71a4-a5d9-17ea2e468eb7€49.00€0.67matched
10capture01a1abb0-8a6a-7427-9dee-64abb41be989€35.00€0.50matched
11capture01a1abb0-967c-7da2-af27-c0cf1f63243f€35.00€0.50matched
12capture01a1abb0-c101-7916-ac47-5ba8acbc7b9f€24.00€0.37matched
13capture01a1abb0-df7f-75b5-b7d3-59f936989653€24.00€0.37matched
14capture01a1abb0-e242-7233-bf44-bf777a64c9a7€15.00€0.26matched
15capture01a1abb0-ea8a-7777-9c21-8dbefc8ff171€15.00€0.26matched
16capture01a1abb0-efab-72d4-bf95-d3c42d89fe17€24.00€0.37matched
17capture01a1abb0-f24d-7cb6-9bb5-e92a9fd84eda€49.00€0.67matched
18capture01a1abb1-00d0-7731-8df0-9076bf24a86f€9.00€0.19matched
19capture01a1abb1-2ddc-7c33-bea5-19ca7bd16a4b€24.00€0.37matched
20capture01a1abb1-42a8-7564-9b73-4b15ca9229a2€49.00€0.67matched
21capture01a1abb1-582e-70e8-9f86-765e2ef281d1€24.00€0.37matched
22capture01a1abb1-6ef1-786a-a007-a0ab8799d8dd€24.00€0.37matched
23capture01a1abb1-c191-7a91-80dd-2ab208e606d5€49.00€0.67matched
24capture01a1abb1-f799-7d34-8eea-3f2a1a09262e€15.00€0.26matched
25capture01a1abb1-f82b-763b-b65c-e85b4c01e328€15.00€0.26matched
26capture01a1abb2-1490-7b97-af7f-138ded6fcf8a€9.00€0.19matched
27capture01a1abb2-1671-7747-9e0e-a3d0990e8892€15.00€0.26matched
28capture01a1abb2-399c-7fcf-9152-1d5b4473f132€49.00€0.67matched
29capture01a1abb2-41fa-7c9d-98b3-d9e1f8577b2c€15.00€0.26matched
30capture01a1abb2-5587-71b9-82da-339a447bdd4c€9.00€0.19matched
31capture01a1abb2-5fad-79d1-aa56-15a1ec27b28d€49.00€0.67matched
32capture01a1abb2-7ed5-76db-af9b-80bf9c6c0972€35.00€0.50matched
33capture01a1abb2-808c-7014-9fcd-45b67c7c0965€35.00€0.50matched
34capture01a1abb2-8c08-72a7-b975-b76318b0fb07€35.00€0.50matched
35capture01a1abb2-af04-7534-80f1-66106f8a6854€9.00€0.19matched
36capture01a1abb2-b8b2-70de-a9d7-8f7226a9a978€49.00€0.67matched
37capture01a1abb2-c94e-7b0f-b86a-e41202069513€9.00€0.19matched
38capture01a1abb2-eb76-7fff-a2b2-81792dfeec93€9.00€0.19matched
39capture01a1abb3-0015-71cc-af74-018fc8195064€9.00€0.19matched
40capture01a1abb3-0b32-73ac-b36a-e02fb69c1b23€49.00€0.67matched
41capture01a1abb3-2290-7356-910b-8bf4e5b60947€35.00€0.50matched
42capture01a1abb3-2605-72f7-9fa6-da425bc56811€9.00€0.19matched
43refund01a1abb3-2f0c-7fc2-b3d8-eb321187b892-€6.00€0.00matched
44capture01a1abb3-35c0-785c-ba1e-09411a495f54€35.00€0.50matched
45capture01a1abb3-37b0-74c9-adae-7f4bce250d69€9.00€0.19matched
46capture01a1abb3-3de4-70a5-8315-469afae70972€9.00€0.19matched
47capture01a1abb3-4e31-7237-bedf-4287b6863401€9.00€0.19matched
48capture01a1abb3-7f8d-7aa7-9588-a96675a1c6d5€49.00€0.67matched
49capture01a1abb3-95f9-7727-a4ce-d46acef3838e€35.00€0.50matched
50capture01a1abb3-a9d1-723b-9f4b-52840281347e€24.00€0.37matched
51refund01a1abb3-b859-7ed4-ac7c-fa3e7b20e186-€35.00€0.00matched
52capture01a1abb3-e28a-7149-a688-8ef6bf882bcf€49.00€0.67matched
53capture01a1abb3-e755-7d94-9585-c8125c39cd8c€9.00€0.19matched
54capture01a1abb3-ea4b-7960-9bf7-898a592ce050€49.00€0.67matched
55capture01a1abb3-fa5c-733a-8f38-e57d15171489€49.00€0.67matched
56capture01a1abb4-1596-79f2-873a-b1ea74633aca€49.00€0.67matched
57capture01a1abb4-2e8c-7a28-91fc-9aa2d279a113€15.00€0.26matched
58capture01a1abb4-358e-7827-a3f0-22b89be2e6c8€15.00€0.26matched
59capture01a1abb4-360f-7590-8f44-ea7b3b51c7e9€49.00€0.67matched
60capture01a1abb4-3786-7771-b876-fe64757d4404€24.00€0.37matched
61capture01a1abb4-4034-7f4a-a2fa-a23c6c4157ce€9.00€0.19matched
62capture01a1abb4-4067-7770-9e31-f617e531e4b7€15.00€0.26matched
63capture01a1abb4-4251-7150-b878-d1dd454867bf€15.00€0.26matched
64capture01a1abb4-5ca5-76c0-a81e-68b1e61edf7e€35.00€0.50matched
65capture01a1abb4-6f98-726b-bb8d-45dfe42f0348€35.00€0.50matched
66capture01a1abb4-76c3-78c5-ac61-c88b31ef1746€49.00€0.67matched
67capture01a1abb4-8cf9-774f-bf50-b714a27865f1€24.00€0.37matched
68capture01a1abb4-95d1-70f4-a0fc-efca70c9adaf€49.00€0.67matched
69capture01a1abb4-a3a7-7c7a-9911-a5df64dda821€49.00€0.67matched
70capture01a1abb4-afee-719a-b643-f2a28940e0f1€9.00€0.19matched
71capture01a1abb4-b56b-7193-ad88-20cfed79cafd€15.00€0.26matched
72capture01a1abb4-b49d-7c9e-b458-ccc90a4452cb€9.00€0.19matched
73capture01a1abb4-c0bd-7817-af4b-4c934095a243€24.00€0.37matched
74capture01a1abb4-c394-72c3-b004-8897a1bb8cdf€35.00€0.50matched
75capture01a1abb4-c7e7-7dc7-a9d8-7245fda2ff40€9.00€0.19matched
76capture01a1abb4-e2e7-738c-ab57-b27952b6cfaa€24.00€0.37matched
77capture01a1abb4-e45d-7d95-9ec5-16e731eeb5d7€35.00€0.50matched
78capture01a1abb4-eab5-7568-ad39-8386ee2430b0€15.00€0.26matched
79capture01a1abb4-f389-7ea0-be63-064621155f73€9.00€0.19matched
80capture01a1abb5-0097-75af-a179-c9d6c2fc1b22€15.00€0.26matched
81capture01a1abb5-107f-7377-9634-21ae371dbd1e€24.00€0.37matched
82capture01a1abb5-1c80-79e3-afd2-4cab11ea4129€9.00€0.19matched
83capture01a1abb5-2265-74dc-a34b-f630a3116dae€9.00€0.19matched
84refund01a1abb5-39d3-75c9-a8c4-0da1288dd662-€32.00€0.00matched
85capture01a1abb5-3ad1-7f5a-95db-7a6de4d991e7€15.00€0.26matched
86capture01a1abb5-3b18-7004-959e-dbc92a8528de€15.00€0.26matched
87refund01a1abb5-3b1e-7442-b13f-43624fcf1187-€34.00€0.00matched
88capture01a1abb5-4411-74c5-a6f2-3cf9000a98b0€24.00€0.37matched
89capture01a1abb5-4a2e-7f4a-a001-911a98af9780€49.00€0.67matched
90capture01a1abb5-6356-772a-ac8f-386e0fe78aac€49.00€0.67matched
91capture01a1abb5-665d-720c-8809-ffceeb76880c€24.00€0.37matched
92capture01a1abb5-67c1-77c4-9860-48bbc0bfb467€24.00€0.37matched
93refund01a1abb5-6e37-7092-b6a1-81757c3f8902-€4.00€0.00matched
94capture01a1abb5-71be-7497-a291-8d34107f60c3€24.00€0.37matched
95capture01a1abb5-7866-7995-92d9-98b7710adbfa€15.00€0.26matched
96capture01a1abb5-9609-71fc-81f6-514e979a8ae4€15.00€0.26matched
97capture01a1abb5-a149-765b-9ec6-b83a06b981c9€15.00€0.26matched
98capture01a1abb5-bbbf-74b6-81fe-d5f3203953f3€35.00€0.50matched
99capture01a1abb5-db4e-7707-a2c8-d40fb13aa870€9.00€0.19matched
100capture01a1abb5-f294-7c86-a769-f5fe18267018€35.00€0.50matched
101capture01a1abb5-fa3d-7659-acf6-be2b074311ab€15.00€0.26matched
102refund01a1abb5-fda9-7291-a6cc-5a324bcee26b-€5.00€0.00matched
103refund01a1abb6-0182-7889-8b51-663934f4c7ef-€6.00€0.00matched
104capture01a1abb6-1fcd-773a-823b-34d46caf5e51€24.00€0.37matched
105capture01a1abb6-36d6-794d-9b71-c6eac314a9b9€15.00€0.26matched
106capture01a1abb6-8053-7f50-a03f-8a281ec3c515€9.00€0.19matched
107capture01a1abb6-9313-71b3-950a-50dc0d34e9c7€15.00€0.26matched
108capture01a1abb6-c66c-78a0-b409-335cbfa1c015€49.00€0.67matched
109capture01a1abb6-dc67-7b5a-a26b-f93202b6b644€24.00€0.37matched
110capture01a1abb6-de5a-704f-8b68-a5a552b4ca6d€9.00€0.19matched
111capture01a1abb6-ed66-75b1-b2ab-69b92b3f8f13€24.00€0.37matched
112capture01a1abb6-f84d-712d-90ec-02db7c917d62€35.00€0.50matched
113capture01a1abb7-03ff-78f2-9b71-350d883c2af1€35.00€0.50matched
114capture01a1abb7-0ef6-7bf6-8265-8bfeed21e98c€49.00€0.67matched
115capture01a1abb7-418b-70b3-beda-28c38b95c895€9.00€0.19matched
116capture01a1abb7-4755-7e34-affa-9f4bbe9c23da€24.00€0.37matched
117capture01a1abb7-6fb7-73e2-b204-3bdbabc986ce€49.00€0.67matched
118capture01a1abb7-9933-7ce7-9a85-d7302c101feb€49.00€0.67matched
119capture01a1abb7-a735-74dd-9f4a-82952eea3c87€15.00€0.26matched
120capture01a1abb7-efdb-7435-b424-e85d4f3c641f€24.00€0.37matched
121capture01a1abb8-2606-7ee9-9be6-582aea752755€15.00€0.26matched
122capture01a1abb8-2cc6-7755-8753-5ec10ef0e870€9.00€0.19matched
123capture01a1abb8-41f9-7c4d-bdec-c1c60a096cdf€24.00€0.37matched
124capture01a1abb8-453a-7504-a11f-cb3fb3c8eada€15.00€0.26matched
125capture01a1abb8-52ea-7eac-89af-66396264dfac€49.00€0.67matched
126capture01a1abb8-5697-7a00-bae4-196089f58a47€49.00€0.67matched
127capture01a1abb8-5d15-7816-85e2-4ff005422860€49.00€0.67matched
128capture01a1abb8-7208-7bfa-b326-723af84f28a4€24.00€0.37matched
129capture01a1abb8-7f5b-7647-8dba-db923616d3ef€35.00€0.50matched
130capture01a1abb8-88af-7822-9752-7867e9853ddd€15.00€0.26matched
131capture01a1abb8-890c-7019-ac64-4a4c1e12b7e6€49.00€0.67matched
132capture01a1abb8-8f88-7a25-b6e4-9638852b76e1€24.00€0.37matched
133capture01a1abb8-9434-775a-9065-60660a300f21€15.00€0.26matched
134capture01a1abb8-9b01-7373-97e1-0dec0852f097€9.00€0.19matched
135capture01a1abb8-b1b0-7449-9ad1-a7dfc03d222c€49.00€0.67matched
136refund01a1abb8-ca8e-7477-9feb-d3a19c9c2c12-€10.00€0.00matched
137capture01a1abb8-d295-70c1-ace7-31e63b5edb6b€24.00€0.37matched
138capture01a1abb8-dd24-73df-8a82-29a9716ba2a6€24.00€0.37matched
139refund01a1abb8-e44f-7121-a1c4-c11394ce100f-€7.00€0.00matched
140capture01a1abb8-e4b1-738f-abac-5b1874266e20€15.00€0.26matched
141capture01a1abb9-01e0-7c76-9478-334e40206a13€15.00€0.26matched
142capture01a1abb9-06ef-73e2-b144-ceee80613dad€15.00€0.26matched
143capture01a1abb9-0b3d-701e-85af-819d6d61e708€35.00€0.50matched