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, 00:10

Gross

€2,865.00

PSP fee

€45.20

Net to the bank

€2,819.80

Settlement journal

#406486

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae35-245c-7f06-84cc-b0f11e89088d is already settled by stl_EUR_2989873 line 72
  • duplicate linethe file lists it twicecapture:01a1ae36-1ea5-7aa7-8a69-93ce9b50f1be is already settled by stl_EUR_2989873 line 83
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • missing linein the books, not in the filerefund:01a1ae36-adc3-760a-9793-2e5bbfb2d471 is in no file
LineKindReferenceGrossFeeStatus
73capture01a1ae35-24cf-7923-8f53-96d9a78d745a€15.00€0.26duplicate line
80capture01a1ae35-fcbb-7e67-b2f0-991db7242116€35.00€0.55fee difference
84capture01a1ae36-1f17-7a91-8743-d496390de496€24.00€0.37duplicate line
1capture01a1ae28-1460-785f-b2e5-91e1073d4ca7€9.00€0.19matched
2capture01a1ae28-8e94-7d8b-bf77-32803e99743c€9.00€0.19matched
3capture01a1ae2a-c1c1-7048-ae8e-e172db64a046€49.00€0.67matched
4capture01a1ae2b-292a-730e-8ad8-c82ad73d157c€15.00€0.26matched
5capture01a1ae30-e074-7e5b-8b38-f464215f8bf0€15.00€0.26matched
6capture01a1ae30-e8dd-7e84-b678-62c948aecb28€15.00€0.26matched
7capture01a1ae30-f28a-77e1-a2af-5a312ef7acd3€35.00€0.50matched
8capture01a1ae31-0690-72ca-ab82-8ba838c758c2€15.00€0.26matched
9capture01a1ae31-1f1c-7146-867f-227803454b23€49.00€0.67matched
10capture01a1ae31-2f60-72b2-84ca-4b46e0d98b9b€35.00€0.50matched
11capture01a1ae31-41f2-721d-b086-084aeba89092€49.00€0.67matched
12capture01a1ae31-55b8-7f46-9e78-8e11a8a277a4€15.00€0.26matched
13capture01a1ae31-5c07-7d7d-9e6b-f18303e9e1ee€49.00€0.67matched
14capture01a1ae31-5df1-7809-a677-a297ee91d75e€24.00€0.37matched
15capture01a1ae31-73ae-7998-94a7-65423c1ae424€35.00€0.50matched
16capture01a1ae31-7a03-79ad-baa7-641b78f5c20c€9.00€0.19matched
17capture01a1ae31-7c9a-7eb7-9d0f-d48e638253b8€24.00€0.37matched
18capture01a1ae31-9e2c-7e38-99d6-b804a8c8ca11€35.00€0.50matched
19capture01a1ae31-ab8c-7445-b29b-b7ebb291f09d€35.00€0.50matched
20capture01a1ae31-bbe8-7dc8-8492-da46f9cd23c7€49.00€0.67matched
21capture01a1ae31-e396-72b6-83a6-f343c914f7db€35.00€0.50matched
22capture01a1ae31-f585-7d0e-b604-778501cf1972€24.00€0.37matched
23capture01a1ae32-02d9-7421-bcaf-af89bdb4d6bf€35.00€0.50matched
24capture01a1ae32-0b05-79be-b85c-2b7f65549f73€24.00€0.37matched
25capture01a1ae32-5073-7dd2-b3a0-6fff51393310€15.00€0.26matched
26capture01a1ae32-5351-70b6-b436-adcb4b5d0e28€49.00€0.67matched
27capture01a1ae32-7100-7ddb-9bdc-fb527764a35e€9.00€0.19matched
28capture01a1ae32-7ebf-734e-a9db-1f7bc1bcd3e0€24.00€0.37matched
29capture01a1ae32-8100-7750-a0b3-93094d3a7851€9.00€0.19matched
30capture01a1ae32-a141-71c9-baaa-df39f634911c€35.00€0.50matched
31refund01a1ae32-b0ba-76c7-8318-a58f0209035f-€6.00€0.00matched
32capture01a1ae32-eff9-70d5-912a-a678669160c4€9.00€0.19matched
33capture01a1ae32-f87c-7fc6-b75a-358a8600579c€15.00€0.26matched
34capture01a1ae33-0ba1-73f1-92e1-1cb07cb87d26€49.00€0.67matched
35capture01a1ae33-2e58-761d-81be-b869fea6f271€49.00€0.67matched
36capture01a1ae33-4ac0-77ab-b9c2-e9715e02bbd8€9.00€0.19matched
37capture01a1ae33-4e00-796c-866c-92d63a204284€49.00€0.67matched
38capture01a1ae33-4e09-7c4a-be01-96048fc0fa42€24.00€0.37matched
39capture01a1ae33-7388-741a-836c-7a504f200f07€49.00€0.67matched
40capture01a1ae33-7434-756d-b149-e557a5e2c6e6€49.00€0.67matched
41capture01a1ae33-85cd-737e-8535-39a817c1096f€49.00€0.67matched
42capture01a1ae33-85df-732b-b017-b50fb5fd3850€35.00€0.50matched
43capture01a1ae33-940f-73c4-954d-63946bb394ed€35.00€0.50matched
44capture01a1ae33-9826-7275-9eea-bc000e040376€24.00€0.37matched
45capture01a1ae33-a807-72cf-bd96-944c98bcc5a0€9.00€0.19matched
46capture01a1ae33-c465-76ad-b1ce-14b8b56bd240€35.00€0.50matched
47capture01a1ae33-c9a0-7b68-b73b-19cd79340f43€35.00€0.50matched
48capture01a1ae33-cc70-7b20-a1fd-7ec7c242c1a4€35.00€0.50matched
49refund01a1ae33-cd0a-7ec6-8b76-1ef663d2daa0-€29.00€0.00matched
50capture01a1ae33-e90b-7470-99a8-b0b78f4f9743€9.00€0.19matched
51capture01a1ae33-f791-7329-b2a6-80c57d1c149f€24.00€0.37matched
52capture01a1ae34-06ba-74e5-bfc2-335b3c4a6f50€35.00€0.50matched
53capture01a1ae34-1d19-79fb-abe5-f5ceb6fb32a0€35.00€0.50matched
54capture01a1ae34-20a8-7928-be1a-fb21445794a7€24.00€0.37matched
55capture01a1ae34-2d8f-7d5f-b766-7bf0566d1f95€49.00€0.67matched
56capture01a1ae34-3000-7dd2-a80e-5c4956ff2f7b€9.00€0.19matched
57capture01a1ae34-4ab0-7e45-a838-80f635c2278b€15.00€0.26matched
58capture01a1ae34-57eb-738f-9b7b-17b3c1d86e95€35.00€0.50matched
59capture01a1ae34-6a48-708d-969e-32fcd71e02cd€9.00€0.19matched
60capture01a1ae34-7064-7518-9c07-2c63b90c940a€15.00€0.26matched
61refund01a1ae34-8280-7702-8d65-3e8c3496510d-€44.00€0.00matched
62capture01a1ae34-8a9d-7cc6-b9df-f76919d44ae4€9.00€0.19matched
63capture01a1ae34-ac44-70e2-9964-d08cc057e9e5€15.00€0.26matched
64capture01a1ae34-d189-7540-a10e-fc82a463c82d€49.00€0.67matched
65capture01a1ae34-d841-7744-bc59-6214e835ee0e€24.00€0.37matched
66capture01a1ae34-e6c1-7e1c-a007-f6425f02c71d€24.00€0.37matched
67capture01a1ae34-eb2f-739b-a5d7-39fb33e7501d€49.00€0.67matched
68capture01a1ae34-fb5a-7deb-8be8-cca28e367d6f€15.00€0.26matched
69capture01a1ae35-0454-7912-9629-84299b816d85€35.00€0.50matched
70capture01a1ae35-058b-7a97-be7b-d4b9a1d7f470€24.00€0.37matched
71capture01a1ae35-0ce8-7d8a-b376-918b44997d96€9.00€0.19matched
72capture01a1ae35-24cf-7923-8f53-96d9a78d745a€15.00€0.26matched
74capture01a1ae35-2953-7000-beb5-f5ad223172f9€49.00€0.67matched
75capture01a1ae35-2db2-7190-9cad-cb2bada8df93€9.00€0.19matched
76capture01a1ae35-ac43-777e-8bb0-cbc0c3e8688f€49.00€0.67matched
77capture01a1ae35-b0e6-7c94-bbf0-e07360d6ba92€49.00€0.67matched
78capture01a1ae35-da03-7d9a-9478-8f6a8cfbb47e€15.00€0.26matched
79capture01a1ae35-efe7-759d-a827-388ddbe709cd€35.00€0.50matched
81capture01a1ae36-0151-7975-9c63-9d184e650f1b€49.00€0.67matched
82capture01a1ae36-1b0b-7a15-9cd9-bbd408428dff€24.00€0.37matched
83capture01a1ae36-1f17-7a91-8743-d496390de496€24.00€0.37matched
85capture01a1ae36-38b2-71f6-8cf2-5a63805a62aa€9.00€0.19matched
86capture01a1ae36-6b6e-71c2-a783-cfe5f6344f77€9.00€0.19matched
87capture01a1ae36-771c-75b8-8c67-fee10a592ab7€35.00€0.50matched
88capture01a1ae36-8493-7d42-9795-a7b1d47d5459€49.00€0.67matched
89capture01a1ae36-8924-7425-9c53-5a5cac664648€15.00€0.26matched
90capture01a1ae36-8abb-7bef-b104-f7818f79cfc9€35.00€0.50matched
91refund01a1ae36-c58c-70fe-a51f-a4b8ae7979b9-€48.00€0.00matched
92capture01a1ae36-cf17-7d6e-b9f9-24b22997ce98€15.00€0.26matched
93capture01a1ae36-edab-74ea-b5ca-a58f042cf345€15.00€0.26matched
94capture01a1ae37-1802-7481-82db-1a90c271055b€15.00€0.26matched
95capture01a1ae37-1d96-7044-a75b-7925585f7632€9.00€0.19matched
96capture01a1ae37-276b-75c8-9a00-9d01623c3628€24.00€0.37matched
97capture01a1ae37-3c5c-77a4-8157-7f723663a682€35.00€0.50matched
98capture01a1ae37-47c0-7c78-99d6-2bd61618cb56€9.00€0.19matched
99capture01a1ae37-61e1-7ecb-a68a-87af7df3e13d€24.00€0.37matched
100refund01a1ae37-7343-75b9-824a-97892f5cf217-€6.00€0.00matched
101capture01a1ae37-8eaf-76b6-acdc-f4212d1fcab7€24.00€0.37matched
102capture01a1ae37-acf7-7fd0-8c03-f69704a9e032€9.00€0.19matched
103capture01a1ae37-cb2f-7ec9-ab8b-3b3e2ab66d0b€35.00€0.50matched
104capture01a1ae38-3532-78f9-8c16-38457effcbd6€49.00€0.67matched
105capture01a1ae38-56c0-713c-9807-957fb4aa23e9€24.00€0.37matched
106capture01a1ae38-6d94-740d-aa4c-ceae1e2270bf€9.00€0.19matched
107capture01a1ae38-720d-7a7e-a37a-38eed3e32d82€24.00€0.37matched
108capture01a1ae38-768c-7682-8320-21aeea73a8e6€24.00€0.37matched
109capture01a1ae38-a55b-780a-aaac-1c0fef3d1d17€49.00€0.67matched
110capture01a1ae38-ab13-7156-929a-e0949119cf87€15.00€0.26matched
111capture01a1ae38-b88e-7b81-8cb0-e43f957ec4a5€9.00€0.19matched
112capture01a1ae39-14de-732f-af3c-f596ab84f6db€24.00€0.37matched
113capture01a1ae39-4572-7da4-929f-d7077e04602d€15.00€0.26matched
114capture01a1ae39-baa0-7245-9533-6089a9e92104€24.00€0.37matched
115capture01a1ae39-e19d-75ec-b635-b3b65e0fb480€35.00€0.50matched
116capture01a1ae39-e5aa-7f65-bd01-0b165d42553b€15.00€0.26matched
117capture01a1ae39-f4b9-7b7f-9d7c-8d02ed6d819d€9.00€0.19matched
118capture01a1ae39-fa0f-75f4-a83e-2f057dbbbf65€15.00€0.26matched