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

Gross

€3,205.00

PSP fee

€51.86

Net to the bank

€3,153.14

Settlement journal

#350442

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 1, the contract says 0
  • missing linein the books, not in the filecapture:01a19e5f-bdc8-7dd7-b2d3-225aa5c8e07c is in no file
LineKindReferenceGrossFeeStatus
33capture01a19e5a-ecd4-7f67-aeba-a8147c68056f€35.00€0.53fee difference
112refund01a19e60-0d4e-719c-8402-91946b216bc2-€19.00€0.01fee difference
1capture01a19e50-29fb-7566-86af-48613d47599b€9.00€0.19matched
2capture01a19e53-7c58-759b-a1e6-5a6bab6a5254€15.00€0.26matched
3capture01a19e54-e21b-7a22-b70a-f5dbf294f147€35.00€0.50matched
4capture01a19e59-16e8-7e99-9574-27eeeafcdc4c€35.00€0.50matched
5capture01a19e59-17df-7dfd-9c19-1573cb1db2f0€9.00€0.19matched
6capture01a19e59-269b-7253-84cb-dcecf1bf04ea€49.00€0.67matched
7capture01a19e59-27af-7725-9d15-0fdcae8559cf€35.00€0.50matched
8capture01a19e59-29ff-7453-815f-c342646532d9€35.00€0.50matched
9capture01a19e59-440a-70c6-b32d-38e73346f6aa€35.00€0.50matched
10capture01a19e59-5333-7e5b-b42b-9aa141f21f42€49.00€0.67matched
11refund01a19e59-656e-772f-be98-cd1bf99a6513-€11.00€0.00matched
12capture01a19e59-681d-7d4f-87fe-8a2596acf8cd€9.00€0.19matched
13capture01a19e59-70e7-7062-a4b4-8c55bc7cee28€49.00€0.67matched
14capture01a19e59-79a4-7e3b-8136-11b6c95f490c€35.00€0.50matched
15capture01a19e59-92b8-7552-a6f3-fb404a083666€35.00€0.50matched
16capture01a19e59-953b-75d0-8457-01475860b8f2€49.00€0.67matched
17capture01a19e59-aca4-76de-90b8-c6587a572338€49.00€0.67matched
18capture01a19e59-af37-734d-b477-df6eef82fdcc€49.00€0.67matched
19capture01a19e5a-0455-7105-a91f-7ee58ebbc755€15.00€0.26matched
20capture01a19e5a-06b5-789b-a0af-7af8067f3dbe€9.00€0.19matched
21capture01a19e5a-1120-7a81-8d28-e1c4e3a42de8€24.00€0.37matched
22capture01a19e5a-45d6-7d40-a21e-07874615c3c9€24.00€0.37matched
23capture01a19e5a-4fc8-787d-8368-ec6f86cdb2e8€24.00€0.37matched
24capture01a19e5a-5470-7dc8-8769-44bd95695c32€35.00€0.50matched
25capture01a19e5a-5cd6-7414-baf8-a219f5277139€24.00€0.37matched
26capture01a19e5a-7cd7-77e1-a508-c19f78231d5b€49.00€0.67matched
27capture01a19e5a-7edf-735c-8b3a-5f8394663c76€15.00€0.26matched
28capture01a19e5a-8bdb-7e93-9a45-c4c3d24dfb00€35.00€0.50matched
29capture01a19e5a-a660-764d-89e3-b588b0a85ec4€35.00€0.50matched
30capture01a19e5a-cdec-7d04-8d48-f1dc7ca189e9€35.00€0.50matched
31refund01a19e5a-e070-75c8-a25b-4bcd19802882-€15.00€0.00matched
32capture01a19e5a-e7e5-7d6e-a15e-09d8526f4f14€35.00€0.50matched
34capture01a19e5a-fd20-798c-a246-5d9312d95b67€9.00€0.19matched
35capture01a19e5b-09b6-70a5-afdc-f8209faff437€9.00€0.19matched
36capture01a19e5b-1627-7807-92ad-d6037a8e3933€9.00€0.19matched
37capture01a19e5b-240b-7e23-96cb-1842cef8a733€24.00€0.37matched
38capture01a19e5b-2990-776f-9a06-16e5375dfc8d€9.00€0.19matched
39capture01a19e5b-47cd-72df-b594-f9d432766cc7€49.00€0.67matched
40capture01a19e5b-5dc1-7c52-a4f9-5a023aa2526a€49.00€0.67matched
41capture01a19e5b-7489-7ccd-ad12-0732ccaab12c€24.00€0.37matched
42capture01a19e5b-75e9-724e-a615-374b1c57956d€24.00€0.37matched
43capture01a19e5b-785c-7a7a-b9da-7634678f0fb0€24.00€0.37matched
44capture01a19e5b-79f0-7d34-874d-679082d776d7€49.00€0.67matched
45capture01a19e5b-79fb-7fbc-b2b1-68d7ecab3374€24.00€0.37matched
46capture01a19e5b-7bf6-78d9-b838-09c15b5f2878€9.00€0.19matched
47capture01a19e5b-975d-763d-90b1-4ded3814ca32€24.00€0.37matched
48refund01a19e5b-996b-7339-b055-415ca33eb3e3-€6.00€0.00matched
49capture01a19e5c-0ad2-7f43-b5f8-dd252fb793db€49.00€0.67matched
50capture01a19e5c-1863-7682-bf8e-bfb54f1ee73a€15.00€0.26matched
51capture01a19e5c-1b18-7f24-99a6-c45c11f03932€35.00€0.50matched
52capture01a19e5c-2faa-7801-8c0f-bf53b10bbaed€24.00€0.37matched
53capture01a19e5c-40a5-7c74-a693-2465be7b63df€15.00€0.26matched
54refund01a19e5c-457e-77cf-9dea-7bbf6e5eae1a-€47.00€0.00matched
55capture01a19e5c-6bd5-733a-bed7-d87f2df2efe5€9.00€0.19matched
56capture01a19e5c-7879-7029-8bf0-7117359908cd€24.00€0.37matched
57capture01a19e5c-8075-7c68-aed6-7495eac82cf4€24.00€0.37matched
58capture01a19e5c-8450-7457-ac14-3206d87f7eec€49.00€0.67matched
59capture01a19e5c-8c77-75c0-b677-c3df71da2dee€35.00€0.50matched
60capture01a19e5c-8d38-7f66-974e-929b60bdbc1b€24.00€0.37matched
61refund01a19e5c-ac7f-7a33-b576-e864867f2aa6-€8.00€0.00matched
62refund01a19e5c-b5ed-77ae-beb5-f6aae57ba328-€9.00€0.00matched
63capture01a19e5c-ccb5-7bcf-983c-b7bd8a48e2ff€9.00€0.19matched
64capture01a19e5c-d45c-72ab-84c6-f4cc3de6c0c4€15.00€0.26matched
65refund01a19e5c-fc11-766a-b2c2-bf030466d6ac-€28.00€0.00matched
66capture01a19e5d-140d-7865-a1e1-a461e6543346€15.00€0.26matched
67capture01a19e5d-2a26-7277-96a6-134a032ae102€35.00€0.50matched
68capture01a19e5d-2b57-70d2-900c-2c34fab0b60f€49.00€0.67matched
69capture01a19e5d-2d0f-7a6c-ae13-75898500e657€15.00€0.26matched
70capture01a19e5d-2df9-76be-8849-74821fbc4320€49.00€0.67matched
71capture01a19e5d-313a-7cf3-bf60-1c421c54f7eb€49.00€0.67matched
72capture01a19e5d-389c-7fc8-a7ed-b591e3919bc3€9.00€0.19matched
73capture01a19e5d-634c-7d3c-b789-636230c4ed6a€49.00€0.67matched
74refund01a19e5d-6fb0-7363-9e35-186047a1265e-€45.00€0.00matched
75refund01a19e5d-71ff-77c4-ae76-76c39f1db76b-€15.00€0.00matched
76capture01a19e5d-7708-7188-898e-360a361f944c€24.00€0.37matched
77capture01a19e5d-85bc-7032-8069-8250f08c4963€15.00€0.26matched
78capture01a19e5d-9b57-743d-9cc1-9b77cbad9bd3€24.00€0.37matched
79capture01a19e5d-d4c2-7ef6-83a4-167fe66e200d€24.00€0.37matched
80capture01a19e5d-ddde-75bd-8fa1-fe2fbeaf82bd€9.00€0.19matched
81capture01a19e5e-2f4e-7262-8eae-80b75b1146d8€24.00€0.37matched
82capture01a19e5e-340d-76f8-a44e-969b67ce0411€24.00€0.37matched
83capture01a19e5e-4b65-7402-a09b-9df3defb6ecc€9.00€0.19matched
84capture01a19e5e-53c2-78e4-a67f-2d489e66e513€9.00€0.19matched
85capture01a19e5e-55fb-72df-bcc9-94c8c118dca6€49.00€0.67matched
86refund01a19e5e-6835-772d-bf4a-f4667cc48a98-€32.00€0.00matched
87capture01a19e5e-6a09-7db0-9c44-0b5128074ae4€9.00€0.19matched
88capture01a19e5e-7e52-7987-b072-847e12a9a6f0€15.00€0.26matched
89capture01a19e5e-8139-7414-b61b-baed3afd1e73€15.00€0.26matched
90capture01a19e5e-82ab-7d37-b05b-ee04bc357bdf€24.00€0.37matched
91capture01a19e5e-8d8b-72cd-92ae-11cd3926409e€24.00€0.37matched
92capture01a19e5e-9051-7b94-9dee-d7c9d0c47184€24.00€0.37matched
93capture01a19e5e-a3fd-791f-a039-01e3c383496d€9.00€0.19matched
94capture01a19e5e-b45f-7597-8baf-5d675fd75414€35.00€0.50matched
95capture01a19e5e-c2b6-7146-9f4c-9d4ad7f51221€35.00€0.50matched
96refund01a19e5e-d96a-723f-990f-37bf402b98c8-€14.00€0.00matched
97capture01a19e5e-deb9-7d77-aac4-d4eed2c911a8€24.00€0.37matched
98capture01a19e5e-e262-7fb4-a3a1-a248cbea53fa€9.00€0.19matched
99capture01a19e5e-e3f2-7253-8c44-54cbb1bcce8d€35.00€0.50matched
100capture01a19e5f-00bd-7bd3-b716-88f24fb25fb9€24.00€0.37matched
101refund01a19e5f-3665-77ce-8570-60016a1f0e28-€20.00€0.00matched
102capture01a19e5f-3b5c-742b-88ed-089b209f3868€15.00€0.26matched
103capture01a19e5f-446a-7189-a103-0d59dfa7662d€9.00€0.19matched
104capture01a19e5f-4c5f-72ae-80a1-efa3d3338aff€35.00€0.50matched
105capture01a19e5f-8b4c-7345-b02d-6b1c81d39e73€49.00€0.67matched
106capture01a19e5f-8e49-70e1-aafd-50c714619209€49.00€0.67matched
107refund01a19e5f-9d1a-767a-8f8f-790a1e6a9d64-€5.00€0.00matched
108capture01a19e5f-a47c-77b6-ad27-2332fb17e743€49.00€0.67matched
109capture01a19e5f-a7c1-7f87-915e-125e159709c5€24.00€0.37matched
110capture01a19e5f-ad19-77eb-a6dc-d206ecf08155€35.00€0.50matched
111capture01a19e5f-fee9-7cbb-8780-9f80c2c9824c€49.00€0.67matched
113capture01a19e60-25f4-7a4e-9f67-56140efa33aa€15.00€0.26matched
114capture01a19e60-30f4-7491-b850-77f0871fefc3€49.00€0.67matched
115capture01a19e60-60a8-7aa2-90d6-f43887d07b78€49.00€0.67matched
116capture01a19e60-6797-7f3b-a5da-e00482a9d8fb€49.00€0.67matched
117capture01a19e60-8348-75a4-838d-b113a4fd0e7a€15.00€0.26matched
118capture01a19e60-8f98-7086-b4fe-90a4f6131f74€15.00€0.26matched
119capture01a19e60-9e6e-713d-b75d-d3cb20489a0a€49.00€0.67matched
120capture01a19e60-b088-7413-8b3d-6435d0921e80€15.00€0.26matched
121capture01a19e60-d390-7ef2-81e3-2790e604fe37€15.00€0.26matched
122capture01a19e60-dd12-74b9-8745-b3658dbb457b€49.00€0.67matched
123capture01a19e60-fc63-7dc3-b425-580b4b5a2f00€15.00€0.26matched
124capture01a19e60-fd90-7a9f-9c4f-9b07ad37be81€24.00€0.37matched
125capture01a19e61-032d-7029-98c0-2810e78102d1€24.00€0.37matched
126capture01a19e61-1d34-705d-b66e-5aa70f82802a€49.00€0.67matched
127capture01a19e61-2680-79f2-b79c-e478555a875f€49.00€0.67matched
128capture01a19e61-3390-7276-8cc4-35810b776131€15.00€0.26matched
129refund01a19e61-5184-77b8-a2ec-f57b77f0e30b-€6.00€0.00matched
130capture01a19e61-5872-792b-8c96-b8c8f9bc1542€49.00€0.67matched
131capture01a19e61-7aa1-7ed0-b920-8d026b42c43d€49.00€0.67matched
132capture01a19e61-7d4b-715b-b68c-7ab616e33c37€35.00€0.50matched
133capture01a19e61-9d6c-78d3-8abe-ba5cad4ca580€15.00€0.26matched
134capture01a19e61-ac6c-7ea2-b6f0-ba9d33f1c108€35.00€0.50matched
135capture01a19e61-ad11-751e-ad84-9d171bd53747€9.00€0.19matched
136capture01a19e61-d25d-7842-b7b3-b366c1f291ad€9.00€0.19matched
137capture01a19e61-f968-70fd-814f-6d821f6dc470€49.00€0.67matched
138capture01a19e62-0bb2-7034-b65f-0a7897259621€24.00€0.37matched