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

4 Nov, 12:20

Gross

€2,973.00

PSP fee

€47.00

Net to the bank

€2,926.00

Settlement journal

#379187

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • missing linein the books, not in the filecapture:01a1a682-0020-7292-955f-f6752a24e392 is in no file
LineKindReferenceGrossFeeStatus
116capture01a1a688-ded8-7748-a80d-dd25ec0ebc28€35.00€0.55fee difference
1capture01a1a680-8c90-7716-a6be-f7586a3ea014€9.00€0.19matched
2capture01a1a680-9d40-71cd-b0d7-3dfa89c41b16€35.00€0.50matched
3capture01a1a680-e26b-772d-9e8a-e84e1c41e69d€49.00€0.67matched
4capture01a1a680-e8da-7275-a3bc-0584fd2a1a97€35.00€0.50matched
5capture01a1a680-f629-7708-a633-b29b5e9e3ea2€35.00€0.50matched
6capture01a1a680-f9ca-778e-a943-45a9b312c613€24.00€0.37matched
7capture01a1a681-103e-74f0-83e6-c68be032bd47€15.00€0.26matched
8capture01a1a681-2063-729d-8e34-d46c37aecb8b€35.00€0.50matched
9capture01a1a681-25e6-7dac-9d21-94fcf4599cbe€35.00€0.50matched
10capture01a1a681-2828-7848-b5c7-490e429b1dac€49.00€0.67matched
11capture01a1a681-287a-79ec-93b4-5ab0f6ec9471€24.00€0.37matched
12capture01a1a681-28c7-7ebd-8369-12dd381214c7€35.00€0.50matched
13capture01a1a681-2bc3-7620-ac91-76e9e0ad4885€9.00€0.19matched
14capture01a1a681-2ebf-7461-b9fc-1f5f456c2f3b€49.00€0.67matched
15capture01a1a681-445c-7bf5-ac7d-2b7b72a0fe87€35.00€0.50matched
16capture01a1a681-4bda-701f-b89f-90f7ede8ce43€24.00€0.37matched
17capture01a1a681-7b28-71a4-9631-faaee6dcade6€24.00€0.37matched
18capture01a1a681-8263-78d2-88d9-c0d65324e3d7€49.00€0.67matched
19refund01a1a681-8430-719a-a53a-b707971fad63-€8.00€0.00matched
20capture01a1a681-8c4d-77cf-bbc9-166c81275afa€15.00€0.26matched
21capture01a1a681-8fcc-7c1b-a989-777773b34162€9.00€0.19matched
22capture01a1a681-a996-7e14-a559-725591610490€35.00€0.50matched
23capture01a1a681-bfec-70a0-ada3-3d5f14dc1ac1€49.00€0.67matched
24refund01a1a681-c59b-71a0-831c-cebd81adf57c-€14.00€0.00matched
25capture01a1a681-db4d-73a8-8b85-705fff240922€35.00€0.50matched
26capture01a1a682-047f-7245-bf85-05304ef1a845€24.00€0.37matched
27capture01a1a682-08d3-7f8f-bcec-a59b6d1e4af7€35.00€0.50matched
28capture01a1a682-0e5e-7935-b033-c9dc9229ec16€15.00€0.26matched
29capture01a1a682-104b-7c36-aae9-24401a496e90€24.00€0.37matched
30capture01a1a682-14e6-7266-b028-fd1d5be2e6bd€24.00€0.37matched
31capture01a1a682-17e3-7946-8c32-ea9066554248€49.00€0.67matched
32capture01a1a682-2c3a-7654-b10b-cbecd71ddc4d€9.00€0.19matched
33capture01a1a682-3bd6-77fd-b0a0-6aef09f57455€24.00€0.37matched
34refund01a1a682-519a-7502-b838-2a6bf32c074f-€5.00€0.00matched
35capture01a1a682-5722-7f22-829d-2f0af0e02b2c€15.00€0.26matched
36capture01a1a682-6558-7480-8b6b-b7bd69e5b628€9.00€0.19matched
37capture01a1a682-656d-73cd-bb1e-53a9f7930d94€9.00€0.19matched
38capture01a1a682-6f37-72c0-aa95-6b2b46417f5c€35.00€0.50matched
39capture01a1a682-8e08-7b44-8204-965d22f6fd45€35.00€0.50matched
40capture01a1a682-a516-7e9f-b4f0-89709e957a8c€35.00€0.50matched
41capture01a1a682-dd96-7881-8c2a-d5b012ff10d6€24.00€0.37matched
42capture01a1a682-f9ce-78ab-8f2f-9fecaee247b7€24.00€0.37matched
43capture01a1a683-04e0-7734-8fed-7e75a2c655fc€9.00€0.19matched
44capture01a1a683-5bdf-79a1-b5cb-30410616664a€15.00€0.26matched
45capture01a1a683-6a58-75da-afca-abf37f7bc489€15.00€0.26matched
46capture01a1a683-71b6-7a27-be5b-5f806a95608d€49.00€0.67matched
47capture01a1a683-7d03-783a-bbb8-6e432b6f51c8€24.00€0.37matched
48capture01a1a683-874b-7c05-80ca-a5a7b96b69db€15.00€0.26matched
49capture01a1a683-908f-78d9-89a8-00438b248260€35.00€0.50matched
50capture01a1a683-9d6c-766e-8af0-deb16dd6dcbd€35.00€0.50matched
51capture01a1a683-a3f1-7aa5-81f8-7711981a8e25€15.00€0.26matched
52capture01a1a683-ad05-7452-a87f-b132bdfe9d23€9.00€0.19matched
53refund01a1a683-bd9c-7311-af0a-74d4179bbb97-€5.00€0.00matched
54capture01a1a683-be5c-75ea-8917-96db8e1cf3e6€24.00€0.37matched
55capture01a1a683-ee05-75fa-8039-4e1e46f0a9fe€49.00€0.67matched
56capture01a1a684-2dc8-73e1-8263-737ab926ee5b€9.00€0.19matched
57capture01a1a684-4d1e-76a6-bc40-e42efee29e54€35.00€0.50matched
58capture01a1a684-5d46-776a-97c0-ec0d6947ab38€15.00€0.26matched
59capture01a1a684-8d62-77db-be6a-b1b07c05a761€49.00€0.67matched
60capture01a1a684-a52a-7aa0-8484-77ea245ec55c€35.00€0.50matched
61refund01a1a684-b9cf-7f99-a7e1-cfa642a3cf2a-€46.00€0.00matched
62capture01a1a684-d6cd-7da7-9b95-c07a72afe238€35.00€0.50matched
63capture01a1a685-22d1-7729-87da-f29851ff50e2€49.00€0.67matched
64capture01a1a685-39ed-7190-a8c6-0d2cbff882ca€24.00€0.37matched
65capture01a1a685-4e5f-7f54-967f-8c34e4324703€15.00€0.26matched
66capture01a1a685-52b2-71ea-b75c-994dc934558e€15.00€0.26matched
67capture01a1a685-958c-74ae-85cd-278807499295€24.00€0.37matched
68capture01a1a685-9611-7ee4-9d5c-448703462faf€49.00€0.67matched
69capture01a1a685-a4c6-7eca-9598-b18cbaf6a1bc€49.00€0.67matched
70capture01a1a685-a646-7aac-a20c-c33959128bc0€24.00€0.37matched
71capture01a1a685-ab7d-7037-82fe-8fb8d65ffe70€9.00€0.19matched
72capture01a1a685-cfb7-7f34-8f67-4e4a1a94d279€9.00€0.19matched
73capture01a1a685-f7a9-7246-98d3-4730e843fad7€15.00€0.26matched
74capture01a1a686-2859-7c8e-91e2-224f411fd9d2€49.00€0.67matched
75capture01a1a686-529e-7163-b04d-cb75f7996dcb€35.00€0.50matched
76capture01a1a686-776c-7dd0-b773-fcfed5d8beb0€24.00€0.37matched
77capture01a1a686-7df7-7a55-83ca-5779f64e3308€15.00€0.26matched
78capture01a1a686-acaa-7f85-8c8f-ab9823b0fe6f€35.00€0.50matched
79capture01a1a686-afe3-76aa-a64b-34645cb9462b€15.00€0.26matched
80capture01a1a686-b61d-76a4-999e-69e45e591969€49.00€0.67matched
81capture01a1a686-b967-739a-89df-0c2a620e6334€24.00€0.37matched
82capture01a1a686-c965-79ba-a9db-e94c1334c213€15.00€0.26matched
83capture01a1a686-cecb-7216-8409-d518ce92271f€35.00€0.50matched
84capture01a1a686-dd3f-7bcb-83fe-c5e29d908582€15.00€0.26matched
85refund01a1a686-e0f4-7a0c-8f45-fab2e9160b9e-€17.00€0.00matched
86capture01a1a686-ed32-7e86-8e65-1390c0ddc1e4€49.00€0.67matched
87capture01a1a687-0341-7bf0-b6ce-664614e627c8€24.00€0.37matched
88capture01a1a687-03dc-7a5e-b5c9-ea450979f9a6€24.00€0.37matched
89capture01a1a687-3fef-714b-b6f5-50018d96ebda€15.00€0.26matched
90capture01a1a687-45e8-7c7f-9288-860ba2a08621€49.00€0.67matched
91capture01a1a687-4ad9-7224-98c4-8bbf4354cd79€49.00€0.67matched
92capture01a1a687-50ec-7e01-9c06-d56419841492€15.00€0.26matched
93capture01a1a687-6c4a-72a5-afb5-442b0801486e€15.00€0.26matched
94capture01a1a687-9204-792b-8f08-ddb557b4973a€15.00€0.26matched
95capture01a1a687-944c-7b81-923a-5dd96070bde5€24.00€0.37matched
96capture01a1a687-a6a0-72db-a413-af773b4be74c€49.00€0.67matched
97capture01a1a687-b307-7a3a-be71-c98b5b091eed€9.00€0.19matched
98capture01a1a687-b9d5-70b7-98aa-ba6fff2ab4d0€49.00€0.67matched
99capture01a1a687-be67-7bcb-9596-b28b7bf2514a€15.00€0.26matched
100capture01a1a687-e5a8-7613-8130-59b8cf8ac6eb€9.00€0.19matched
101capture01a1a687-ed02-7812-a7f1-6b2b851a5491€49.00€0.67matched
102refund01a1a688-0408-77da-88e9-e2466a228d89-€5.00€0.00matched
103refund01a1a688-15fb-7f82-8798-cc0df4f8eb8b-€12.00€0.00matched
104capture01a1a688-1ee5-75e4-95bc-3b9f49477f04€15.00€0.26matched
105capture01a1a688-2284-7950-b76c-73cceb5c26c3€49.00€0.67matched
106capture01a1a688-2e6a-79b3-9fb9-eb5b54f9322e€15.00€0.26matched
107capture01a1a688-31b1-7fd6-a428-2d0f71e27c78€15.00€0.26matched
108capture01a1a688-3e4d-7e5e-bb97-945a7d3976cb€15.00€0.26matched
109refund01a1a688-46ee-7676-a4a3-562dd4d59a8b-€15.00€0.00matched
110capture01a1a688-4b3a-79d9-a767-c5195745fadd€24.00€0.37matched
111capture01a1a688-56c7-735a-88cc-61021642583a€9.00€0.19matched
112capture01a1a688-71cb-77ff-a3d7-be220c764b28€15.00€0.26matched
113capture01a1a688-a33c-78ca-92d5-cdcb1337b77d€15.00€0.26matched
114capture01a1a688-a9b2-722c-a663-127b25b2bf92€9.00€0.19matched
115capture01a1a688-c6d9-72c0-9647-5245740d10b6€15.00€0.26matched
117capture01a1a688-ed39-791e-9b22-7de80acaa324€49.00€0.67matched
118capture01a1a688-f0f4-719c-a2ed-edf7f7edb4bf€9.00€0.19matched
119capture01a1a689-00df-7e37-88e1-bee7df49e531€9.00€0.19matched
120capture01a1a689-0107-7e89-8900-9907e59aa561€15.00€0.26matched
121capture01a1a689-054b-7a47-b969-0089bfd7d10d€15.00€0.26matched
122capture01a1a689-10a1-7163-83ee-c3aebffcd602€49.00€0.67matched
123refund01a1a689-4a58-7408-bedb-5674e09cbe81-€22.00€0.00matched
124capture01a1a689-4ab7-7152-bd11-0f3fd9c2f36f€35.00€0.50matched
125capture01a1a689-644e-738d-89b1-a3cc313112f0€24.00€0.37matched
126capture01a1a689-8c95-7727-84a6-9ccf9d8c6755€24.00€0.37matched
127capture01a1a689-9248-7c44-ab20-1fd628ec27b2€35.00€0.50matched