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

2 Nov, 21:10

Gross

€3,426.00

PSP fee

€54.30

Net to the bank

€3,371.70

Settlement journal

#349500

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • missing linein the books, not in the filecapture:01a19e22-1a92-7559-bc68-f66257c43648 is in no file
LineKindReferenceGrossFeeStatus
81capture01a19e1e-00e9-7195-aee8-c2c4c3529768€9.00€0.24fee difference
97capture01a19e1e-f1cc-767d-9b88-bd269517d01d€35.00€0.51fee difference
1capture01a19e12-9629-7d1d-b6b8-135109db8538€24.00€0.37matched
2capture01a19e19-07a3-76db-8e63-cc7018b75225€24.00€0.37matched
3capture01a19e19-1dad-7bf4-a5ca-d68a8a5b5e62€9.00€0.19matched
4capture01a19e19-294b-77ef-ab19-a87ce9733bef€35.00€0.50matched
5capture01a19e19-39be-7359-9828-6641f848e587€49.00€0.67matched
6capture01a19e19-5228-70e5-ac52-5d94f6fd759c€15.00€0.26matched
7capture01a19e19-6f0f-7b4b-9d69-bb391ad4341c€35.00€0.50matched
8capture01a19e19-7228-79ba-ac42-bbdd7ac14f1b€35.00€0.50matched
9capture01a19e19-7566-720e-b457-3169b9566a83€35.00€0.50matched
10capture01a19e19-7a0e-781d-99fb-ecbb78503d14€35.00€0.50matched
11capture01a19e19-ba2a-7099-a3eb-ddd342a022cc€35.00€0.50matched
12capture01a19e19-beb2-75eb-84e8-bc39f512febd€24.00€0.37matched
13capture01a19e19-c79d-7dc0-b0f6-8bdf5fbf9b4b€9.00€0.19matched
14capture01a19e19-d51c-7a3e-8e15-6c87b61951b7€35.00€0.50matched
15capture01a19e19-e4eb-7af9-a86b-d4520b18b9d7€15.00€0.26matched
16capture01a19e19-f530-73c7-9c33-a711a428ee7e€49.00€0.67matched
17capture01a19e19-f5ae-76b9-9aef-ef1f316dc2e1€15.00€0.26matched
18capture01a19e19-f784-75d3-beaa-0e648f108209€35.00€0.50matched
19capture01a19e1a-099c-7093-9411-ad2bba8133d1€15.00€0.26matched
20capture01a19e1a-3f45-70a9-843a-7c0bb5c6a9ac€15.00€0.26matched
21capture01a19e1a-430b-718c-bd3c-e262b8308e6f€49.00€0.67matched
22capture01a19e1a-5732-7e73-9e1b-929eda8207d4€9.00€0.19matched
23capture01a19e1a-6442-7eb7-a5cd-d4363e09b076€49.00€0.67matched
24capture01a19e1a-6e42-7e79-ba4d-1ea89f6debc9€24.00€0.37matched
25capture01a19e1a-75c5-707b-ab82-78fa69bc2b29€9.00€0.19matched
26capture01a19e1a-7f11-77a8-9447-c0b45d44e843€9.00€0.19matched
27capture01a19e1a-8896-76dd-981d-f41053de4342€15.00€0.26matched
28capture01a19e1a-a041-7f43-95dc-6ea635d680ce€24.00€0.37matched
29capture01a19e1a-a4cf-7729-906f-ca41cc560386€35.00€0.50matched
30capture01a19e1a-cd92-7117-a003-dc2fe79c4907€35.00€0.50matched
31capture01a19e1a-d832-7045-a88e-dfeeaafda67f€24.00€0.37matched
32capture01a19e1a-d840-7ac0-9808-d8c2d043087b€35.00€0.50matched
33capture01a19e1a-f01d-78a3-a8c9-16e512b8d0f4€35.00€0.50matched
34capture01a19e1a-f7b4-79e5-b198-a9c2186cd773€35.00€0.50matched
35capture01a19e1b-0d5e-7ff7-8f66-6c7bb31334f2€15.00€0.26matched
36capture01a19e1b-18d7-77f9-af9c-5037a699dd6c€15.00€0.26matched
37capture01a19e1b-2d3b-75f8-983c-dadf47ffa8a4€49.00€0.67matched
38capture01a19e1b-371e-78fc-9dce-a30dfbae6aef€35.00€0.50matched
39capture01a19e1b-3d9b-754e-9d37-7b5f70d97408€49.00€0.67matched
40refund01a19e1b-675e-72a8-82cd-dd5323904690-€14.00€0.00matched
41capture01a19e1b-7ae7-7ec0-a935-4769be6fd57e€24.00€0.37matched
42refund01a19e1b-9488-7095-a384-c041ef7d0352-€45.00€0.00matched
43capture01a19e1b-cf56-7552-b013-f583ec58384e€49.00€0.67matched
44capture01a19e1b-d1ab-7d9e-9d11-eb1c3e1f7c02€24.00€0.37matched
45capture01a19e1b-d800-7f5b-9135-bf0ecf16bb02€9.00€0.19matched
46capture01a19e1b-ef45-76c6-a908-eecb966a5533€24.00€0.37matched
47capture01a19e1c-0b20-7542-ba3f-5eab6409761d€49.00€0.67matched
48capture01a19e1c-1576-735b-baa2-fb05a3ad50b8€35.00€0.50matched
49capture01a19e1c-22ec-70aa-9931-2dfde87cdd45€9.00€0.19matched
50capture01a19e1c-2429-7a34-9e02-32e8f58341ec€35.00€0.50matched
51capture01a19e1c-2eca-7cc7-824a-0646223ebd4d€24.00€0.37matched
52capture01a19e1c-34f5-71cb-8fa4-219f91c06e28€15.00€0.26matched
53capture01a19e1c-369d-7928-b1bf-0d72f9a314b6€49.00€0.67matched
54refund01a19e1c-5d0c-77a7-82c2-c1bd5a68c0f8-€24.00€0.00matched
55capture01a19e1c-769a-7908-b8fc-c298059408e2€24.00€0.37matched
56capture01a19e1c-9509-7020-bef3-fa72aac5a246€24.00€0.37matched
57capture01a19e1c-a80a-7784-9a0c-be9e14262f5c€15.00€0.26matched
58capture01a19e1c-a954-755f-a828-496eca542d7f€24.00€0.37matched
59capture01a19e1c-d164-778b-9bd4-c2fd2051683d€24.00€0.37matched
60capture01a19e1c-e369-72d0-975d-06a254049f1d€9.00€0.19matched
61capture01a19e1c-e8a2-78d3-8e31-27e8f37ab0a6€35.00€0.50matched
62capture01a19e1d-01b6-7c6d-b189-c4bbf2212088€15.00€0.26matched
63capture01a19e1d-1114-7066-a368-846bdcfea41b€24.00€0.37matched
64capture01a19e1d-2ddf-77da-a628-60f4a1176d00€49.00€0.67matched
65capture01a19e1d-2fcc-7d78-af95-779e42b4943c€9.00€0.19matched
66capture01a19e1d-3894-75c8-82f3-0d4eb062e15f€9.00€0.19matched
67capture01a19e1d-60d3-780f-93cf-1b265579d5f5€35.00€0.50matched
68capture01a19e1d-68d4-78ad-82c7-45987bc8b6e7€24.00€0.37matched
69capture01a19e1d-6b03-778f-ae11-f2cde56ac847€15.00€0.26matched
70capture01a19e1d-73af-76fa-9974-6b63b07960db€24.00€0.37matched
71refund01a19e1d-760a-7f77-8071-5b8081973837-€9.00€0.00matched
72capture01a19e1d-7973-7a19-b51e-ae4bd2b419e5€24.00€0.37matched
73capture01a19e1d-79e9-7387-8a95-880dcbcc5c42€49.00€0.67matched
74capture01a19e1d-8acf-740e-897e-f459fc55ac28€15.00€0.26matched
75capture01a19e1d-9109-73b1-bdf1-f6fb63145799€9.00€0.19matched
76capture01a19e1d-a590-7717-ae81-80c0af5bfffd€9.00€0.19matched
77capture01a19e1d-b142-773c-9c5e-9b384da7054b€9.00€0.19matched
78capture01a19e1d-c29f-7134-989c-9b9512292513€49.00€0.67matched
79capture01a19e1d-cecf-7767-a93b-ffc08e61b94b€35.00€0.50matched
80capture01a19e1d-f908-74a9-92ae-e64b6ba1cd7f€35.00€0.50matched
82capture01a19e1e-09c6-779a-812d-38f66fe0f4c0€24.00€0.37matched
83capture01a19e1e-135d-71bf-a067-46be8014e77c€24.00€0.37matched
84capture01a19e1e-156b-7244-a946-60c8b33de7c1€35.00€0.50matched
85capture01a19e1e-1eb0-7487-a12b-0788083a5d3b€49.00€0.67matched
86capture01a19e1e-2dba-73e5-afed-d830d1299b50€49.00€0.67matched
87capture01a19e1e-4204-75bc-8b40-e245c7a55f66€24.00€0.37matched
88capture01a19e1e-433e-774d-a51b-a74696f63872€49.00€0.67matched
89capture01a19e1e-477c-7781-99a2-b4731169e6e9€15.00€0.26matched
90capture01a19e1e-5f6e-750b-8dd0-506c0a5f8bf6€24.00€0.37matched
91capture01a19e1e-841f-74e4-b1fc-52db33e4cc1a€9.00€0.19matched
92refund01a19e1e-931f-7c2b-84d8-e7c7daeda0ca-€49.00€0.00matched
93capture01a19e1e-9f27-7de7-ab50-493f21d18d3f€15.00€0.26matched
94capture01a19e1e-ace9-7be4-977f-d2c45fb04e82€35.00€0.50matched
95capture01a19e1e-de3a-71eb-b81d-06bd2f70dea5€9.00€0.19matched
96capture01a19e1e-ed96-7498-8808-c23698b9a7a6€24.00€0.37matched
98capture01a19e1e-f31c-7b6a-a5df-ed451d3ef629€49.00€0.67matched
99capture01a19e1f-2f76-7e2b-a9e4-961feb275348€24.00€0.37matched
100capture01a19e1f-3a6b-7688-a263-eff2d7663685€35.00€0.50matched
101capture01a19e1f-4130-7be3-a93e-0abdfda6b115€15.00€0.26matched
102capture01a19e1f-47fe-7632-b94d-bc6c838f6208€35.00€0.50matched
103capture01a19e1f-4d48-7877-8cc2-75a8dfaa7f98€49.00€0.67matched
104capture01a19e1f-550d-73e4-97ce-773668e0e5e1€49.00€0.67matched
105capture01a19e1f-5dd0-7c85-b81f-6942c931fcab€24.00€0.37matched
106capture01a19e1f-647a-7dfa-b97a-a33f5bd003cf€49.00€0.67matched
107capture01a19e1f-720d-7a34-a18a-3ad0594a8fa9€9.00€0.19matched
108capture01a19e1f-8816-714b-9fc6-a7670f785ed6€24.00€0.37matched
109capture01a19e1f-90b4-7548-a207-6e66f2fb16ba€15.00€0.26matched
110capture01a19e1f-a8e7-7013-abf3-78166afac2f5€49.00€0.67matched
111capture01a19e1f-cda8-7a17-8f07-6dc77b1a4045€24.00€0.37matched
112refund01a19e1f-e262-7003-ad72-0bf4363ecfc6-€8.00€0.00matched
113capture01a19e1f-ee8d-7fb2-afc4-a56a93dd1f05€15.00€0.26matched
114capture01a19e1f-f40f-707b-af7f-2662b4ee5c5d€49.00€0.67matched
115capture01a19e1f-f8a1-7973-8267-23bd2f3ff7d8€35.00€0.50matched
116capture01a19e20-0cc0-7714-a1b2-4ed753b2ec1c€9.00€0.19matched
117capture01a19e20-0dda-7216-804c-c11abeb5248f€24.00€0.37matched
118capture01a19e20-1200-74ff-88d6-2c6cb66aa847€9.00€0.19matched
119capture01a19e20-3891-7d40-b93f-937f09ab98df€9.00€0.19matched
120capture01a19e20-49f3-7e76-9ea6-943840f4e16b€24.00€0.37matched
121capture01a19e20-4e04-77ff-b3b7-31e1a91104bc€9.00€0.19matched
122capture01a19e20-7031-7fa5-b1a3-70e8b63f2bb0€35.00€0.50matched
123capture01a19e20-8eea-7122-87fc-93117780569a€9.00€0.19matched
124capture01a19e20-977d-71d7-a6a0-8cbde5297bc8€9.00€0.19matched
125refund01a19e20-a7be-7e0c-b96c-9e489f0006f4-€5.00€0.00matched
126capture01a19e20-c553-7385-86ce-058b2239fb60€35.00€0.50matched
127capture01a19e20-d27a-7e3c-ac23-a0076fd7ea46€24.00€0.37matched
128capture01a19e20-dba9-7608-a4a3-08f03f6ae7cb€15.00€0.26matched
129refund01a19e21-015e-794c-815f-9269113fff00-€19.00€0.00matched
130capture01a19e21-076a-72e4-b018-46eeac5cc282€9.00€0.19matched
131capture01a19e21-2940-7f19-a90a-35368b5b35e5€24.00€0.37matched
132capture01a19e21-562d-7372-b5a9-8ae5b1dadbd8€24.00€0.37matched
133capture01a19e21-57ee-7f21-990b-1f212e42ea55€15.00€0.26matched
134capture01a19e21-5959-7bb2-90c6-66fa69393a1e€9.00€0.19matched
135capture01a19e21-6520-737c-8b9b-e11cbe8cd57d€49.00€0.67matched
136capture01a19e21-7dcf-7926-864e-f9e569e8689d€15.00€0.26matched
137capture01a19e21-be31-79f6-8ae7-4b2e089ef86a€9.00€0.19matched
138capture01a19e21-e262-771b-b377-4219274d47e3€24.00€0.37matched
139capture01a19e21-e341-793c-b783-708607efda9a€49.00€0.67matched
140capture01a19e21-e417-75d4-a65e-9af0953716cb€35.00€0.50matched
141capture01a19e21-cd66-7ea1-a189-6448b45f9ae9€9.00€0.19matched
142capture01a19e21-f112-71c2-b52b-28825bfb8056€49.00€0.67matched
143capture01a19e21-f368-731c-8adb-4a86e1edcfc8€9.00€0.19matched
144capture01a19e22-02e5-7ecb-a5c5-7c07515e8a1f€49.00€0.67matched