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

Gross

€3,602.00

PSP fee

€56.83

Net to the bank

€3,545.17

Settlement journal

#371762

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 5, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • missing linein the books, not in the filecapture:01a1a467-2e3b-7d52-8709-d55c31d719e3 is in no file
LineKindReferenceGrossFeeStatus
6refund01a1a464-63a5-7283-88f4-e0d2d32d799f-€5.00€0.05fee difference
117capture01a1a46b-ba34-7076-b8e7-9648c1761808€24.00€0.42fee difference
1capture01a1a45d-21f7-79f9-b57a-1809ebbf94d6€24.00€0.37matched
2capture01a1a45f-692e-7272-a185-6b1c5c619413€15.00€0.26matched
3capture01a1a462-6413-7f78-bd97-39b674f07d49€15.00€0.26matched
4capture01a1a464-597f-7ab3-9240-aff1af5fba24€9.00€0.19matched
5capture01a1a464-602a-7183-8e6d-a24a62b47c3a€9.00€0.19matched
7capture01a1a464-7147-77f9-811b-5215d91f0cf7€9.00€0.19matched
8capture01a1a464-7de2-7632-8ecb-c9f46d21e9bf€49.00€0.67matched
9capture01a1a464-8b87-7137-9acb-2957f4c2511b€49.00€0.67matched
10capture01a1a464-c3d0-7c78-9c48-6c2d5fa6e2ad€9.00€0.19matched
11capture01a1a464-d831-7669-a995-f2909a16ba88€24.00€0.37matched
12capture01a1a464-e297-7a6a-bb48-8e61042f5b64€24.00€0.37matched
13capture01a1a464-e804-7527-9705-9c8746ee1d01€35.00€0.50matched
14capture01a1a464-fe22-7a8b-8205-40a6f19f5dd9€15.00€0.26matched
15capture01a1a465-043b-7d92-b70b-b60d4e7acf62€15.00€0.26matched
16refund01a1a465-2937-7137-9dd1-0b70507f97e9-€9.00€0.00matched
17capture01a1a465-2b29-730d-bb17-ed9e3f960efd€49.00€0.67matched
18refund01a1a465-2d82-7df4-81bb-3308fdef5606-€14.00€0.00matched
19capture01a1a465-55db-7098-9e53-2ba49939f9bf€49.00€0.67matched
20capture01a1a465-5a52-7c7a-9618-c7b3534ce921€9.00€0.19matched
21capture01a1a465-5bf8-7e43-9c15-7059b40cf361€24.00€0.37matched
22capture01a1a465-672e-7dbe-b7e3-d74230165d04€9.00€0.19matched
23capture01a1a465-6b2f-7442-8c1b-dbdfc3b3f453€9.00€0.19matched
24capture01a1a465-6b42-7dba-a9ff-243d57a62f21€49.00€0.67matched
25capture01a1a465-9c6b-79fd-a410-298c667bbab8€15.00€0.26matched
26capture01a1a465-de44-71e2-b9c1-9aa37525e457€35.00€0.50matched
27capture01a1a465-f314-78b8-a458-0eba39d2dff7€35.00€0.50matched
28capture01a1a465-fff3-7440-9828-73f5f6f51d1d€9.00€0.19matched
29capture01a1a466-0318-7546-a1b5-416dc485a35e€9.00€0.19matched
30capture01a1a466-0ec0-7f8d-9a36-5a7c3373e6b2€24.00€0.37matched
31capture01a1a466-10e2-756c-a0f1-bfa6dfbaf8a5€35.00€0.50matched
32capture01a1a466-19e2-75fd-9acb-502d8b5bfdd7€35.00€0.50matched
33capture01a1a466-1aac-78d6-aead-0eed0c31dbdc€9.00€0.19matched
34capture01a1a466-1dca-7e33-ae33-981bf0bc4961€15.00€0.26matched
35capture01a1a466-3276-769f-95f2-f76b50ec8b93€24.00€0.37matched
36capture01a1a466-3e90-7495-851d-58f6d68b91f3€9.00€0.19matched
37capture01a1a466-58aa-7e4d-a236-00156e731129€35.00€0.50matched
38refund01a1a466-5d07-76c9-86ab-1e72ed7cf711-€11.00€0.00matched
39refund01a1a466-6550-7b9c-884c-aa466d897a02-€4.00€0.00matched
40capture01a1a466-7b56-743d-9acd-821504f0b50a€35.00€0.50matched
41capture01a1a466-b5fd-77e2-9fb5-229ebcafbed0€24.00€0.37matched
42capture01a1a466-c007-7b49-a988-80e5fbdef93e€49.00€0.67matched
43capture01a1a466-c4e7-7878-92d0-d7ae502b8862€24.00€0.37matched
44capture01a1a466-c9f3-7a5c-bbc5-6093d51212c6€49.00€0.67matched
45capture01a1a466-e3ad-77bd-b2a7-21977d1e2536€49.00€0.67matched
46capture01a1a466-ee23-78b4-8015-3131ec065670€9.00€0.19matched
47capture01a1a467-05ca-7efb-bf66-fdd6b6f8ae81€15.00€0.26matched
48capture01a1a467-113e-74ed-9ec8-463d3ffc1990€35.00€0.50matched
49capture01a1a467-1978-712a-97d8-1934dd3a0c9c€15.00€0.26matched
50capture01a1a467-2bf2-766e-b7ef-c6357ff28359€35.00€0.50matched
51capture01a1a467-3005-793c-afa1-478851af6e3c€15.00€0.26matched
52capture01a1a467-3597-7307-8e02-3262fec23f9d€9.00€0.19matched
53capture01a1a467-421c-7426-b3f9-ea710e98da53€24.00€0.37matched
54capture01a1a467-59c5-7760-9cae-4fa1ff45cf54€9.00€0.19matched
55refund01a1a467-6297-751c-a8bc-b82cd035afe8-€18.00€0.00matched
56capture01a1a467-85a2-7789-88b9-e3e823593c08€35.00€0.50matched
57capture01a1a467-911a-7e9d-973f-df51d6eb7d87€49.00€0.67matched
58capture01a1a467-9281-7de6-a9b7-e81c62c73d08€49.00€0.67matched
59capture01a1a467-b377-702a-9282-0415b7b5cfcb€15.00€0.26matched
60capture01a1a467-bea3-73fe-bd2e-8617a0b895e1€24.00€0.37matched
61capture01a1a467-c331-7a8a-bc7c-2a967e315cc4€9.00€0.19matched
62capture01a1a467-ea03-752c-930d-c86302f5364d€49.00€0.67matched
63capture01a1a467-f448-760f-8d80-9f86cf50af93€35.00€0.50matched
64capture01a1a467-f74b-7ec1-ba82-a310805267a8€35.00€0.50matched
65capture01a1a468-0d9f-7b37-8d7c-12cdd50e8e58€35.00€0.50matched
66capture01a1a468-13ad-7d38-b5bf-a6b020270340€35.00€0.50matched
67capture01a1a468-36c3-7e71-a804-c971d5105a91€24.00€0.37matched
68capture01a1a468-3d05-716a-97b5-571daab1d8b1€24.00€0.37matched
69capture01a1a468-7eb1-7a0b-96af-65e9bb501d7f€15.00€0.26matched
70capture01a1a468-9aab-74ca-927f-2244c171c4f5€49.00€0.67matched
71capture01a1a468-b44b-7111-be03-101dc40c6c6d€35.00€0.50matched
72capture01a1a468-d012-7471-8c21-c5f40bcc92f9€9.00€0.19matched
73capture01a1a468-dd12-7273-98a4-73be4b6f1046€49.00€0.67matched
74capture01a1a468-de4f-7ce4-90f4-c860af9614f1€9.00€0.19matched
75capture01a1a468-e186-70a9-8e2c-3d85cf052bd8€9.00€0.19matched
76capture01a1a468-f45a-7262-a0d2-6adb8ebfe4e3€35.00€0.50matched
77capture01a1a468-f48e-76fc-b84a-f5c215ed290f€49.00€0.67matched
78capture01a1a469-2042-71bd-8e1e-4f63a64298f2€49.00€0.67matched
79capture01a1a469-21d0-74a0-a9d0-d086854d7b5d€49.00€0.67matched
80capture01a1a469-5273-78dd-a648-3683add74e9a€24.00€0.37matched
81capture01a1a469-60d6-741d-97a9-e10212d439b4€49.00€0.67matched
82capture01a1a469-65e3-7cf1-920a-3e9d9fbe87e2€49.00€0.67matched
83capture01a1a469-70bb-75c9-a289-4cee1a3130c4€35.00€0.50matched
84capture01a1a469-6d3d-7c6d-a5c7-ddf902297602€35.00€0.50matched
85capture01a1a469-8876-77b6-9e45-9b16c8c5c96c€9.00€0.19matched
86capture01a1a469-b636-7c30-be62-ee661fca5b11€49.00€0.67matched
87capture01a1a469-c6b7-7f40-9f69-6c39ce6a8ed2€15.00€0.26matched
88capture01a1a469-e2d1-7ecc-b5c1-f883264a8a0e€49.00€0.67matched
89capture01a1a469-edbb-7b7f-9c3e-7670fc21d733€24.00€0.37matched
90capture01a1a469-ed6c-712d-b9c8-ae39144d5e81€35.00€0.50matched
91capture01a1a46a-1037-72f4-9346-08874dd26c7d€24.00€0.37matched
92capture01a1a46a-26ed-7da5-9363-d35ed1953c5a€9.00€0.19matched
93capture01a1a46a-2afb-73dd-80e7-48b3b82ed685€15.00€0.26matched
94capture01a1a46a-2f6c-7168-be55-5b11b661a760€9.00€0.19matched
95refund01a1a46a-420f-72a3-9adb-418daceeccb9-€10.00€0.00matched
96capture01a1a46a-541b-7cda-bcc8-a6d7aa633efa€49.00€0.67matched
97capture01a1a46a-5ca1-7b01-83ad-656921ff701f€9.00€0.19matched
98capture01a1a46a-9c51-7a0a-aeba-4f0eb88ba0b3€35.00€0.50matched
99capture01a1a46a-ac0b-7a2d-969f-26e4293ab372€9.00€0.19matched
100capture01a1a46a-b3d6-7161-951b-b0fcddd81c3c€15.00€0.26matched
101capture01a1a46a-d5f8-7894-8a14-c267fdc9f534€9.00€0.19matched
102capture01a1a46a-e110-7c71-8336-7b2c6dc06426€9.00€0.19matched
103capture01a1a46a-faa7-786f-991a-6d4475ac5f1b€9.00€0.19matched
104refund01a1a46b-13a2-7710-a193-78e75101e4d4-€7.00€0.00matched
105capture01a1a46b-15c2-79d5-92b8-adc2ad73f394€15.00€0.26matched
106capture01a1a46b-1615-753d-963e-71dfefb59aca€49.00€0.67matched
107refund01a1a46b-2b92-738f-9e8a-2100384f604b-€3.00€0.00matched
108capture01a1a46b-4345-743f-9cf4-cecf4b9d6bb8€49.00€0.67matched
109capture01a1a46b-5762-7c06-b3c9-26ba5ad07d7a€24.00€0.37matched
110capture01a1a46b-5d38-7e47-8ed4-4ffb6823c177€9.00€0.19matched
111capture01a1a46b-5f28-7cde-a099-10ce131a1b40€15.00€0.26matched
112capture01a1a46b-6d62-7ed9-bf9b-e437679599b5€15.00€0.26matched
113capture01a1a46b-857c-7a9f-a236-eb51d7096564€49.00€0.67matched
114refund01a1a46b-abd4-7261-84cb-1282c9d45651-€7.00€0.00matched
115capture01a1a46b-af72-7e8d-a694-4c3b6a93b781€49.00€0.67matched
116capture01a1a46b-b2bd-71ad-a3b7-8139ddaf17f2€49.00€0.67matched
118capture01a1a46b-ca7e-7df6-b6a9-52af8757bbf8€24.00€0.37matched
119capture01a1a46b-da2d-73c1-be64-e9282e29326c€24.00€0.37matched
120capture01a1a46b-eedd-73df-bd59-3ee38bf3575a€24.00€0.37matched
121capture01a1a46b-f4b1-79b9-adb4-71f1fae1da13€35.00€0.50matched
122refund01a1a46c-04e0-7bab-839c-2e1865f43028-€41.00€0.00matched
123capture01a1a46c-0f41-78d6-84be-09dd245e66fd€9.00€0.19matched
124capture01a1a46c-10b4-79fb-8157-5995432eb552€9.00€0.19matched
125capture01a1a46c-1fe9-7300-b1df-92bae4e8cbc9€9.00€0.19matched
126capture01a1a46c-2e73-7cda-9351-d2060a097622€49.00€0.67matched
127capture01a1a46c-38c3-7685-9760-9597079d320e€35.00€0.50matched
128capture01a1a46c-4f9e-76f0-a0da-f0e25273d404€9.00€0.19matched
129capture01a1a46c-5753-744f-bd5c-f323cd69c6b7€35.00€0.50matched
130capture01a1a46c-5a9c-74b5-a473-50e51e33efca€15.00€0.26matched
131capture01a1a46c-6bc3-7d6c-851a-d1e7d5681a0d€24.00€0.37matched
132capture01a1a46c-7204-75f0-9eb0-131253d4df5d€24.00€0.37matched
133capture01a1a46c-758b-706c-b41d-ecab818fe91f€9.00€0.19matched
134capture01a1a46c-79b0-7590-8996-d5c034041fde€35.00€0.50matched
135refund01a1a46c-9064-77a2-80c0-7a638b0b7b94-€21.00€0.00matched
136capture01a1a46c-93a7-7f02-bcf1-eed4b0126ac7€24.00€0.37matched
137capture01a1a46c-988b-7434-9f24-6f39826cc94a€35.00€0.50matched
138capture01a1a46c-996f-70dd-b6c8-9da9bc110cd5€15.00€0.26matched
139capture01a1a46c-a9bc-7e9a-8d95-59fd5ef70d6e€35.00€0.50matched
140capture01a1a46c-aa02-7289-8e87-837fb20957f7€24.00€0.37matched
141capture01a1a46c-c46f-7d23-8c7e-0ed4ad480c6e€49.00€0.67matched
142capture01a1a46c-d22f-7705-8934-2849b6bd1d08€35.00€0.50matched
143capture01a1a46c-dd7e-7f42-be0c-7176b2e43f1a€24.00€0.37matched
144capture01a1a46c-e215-7443-849f-56b7fff00201€9.00€0.19matched
145capture01a1a46c-ece1-749b-8719-53366141e8f5€9.00€0.19matched
146capture01a1a46c-f1da-7100-9fee-452d386869ff€35.00€0.50matched
147capture01a1a46d-05f3-736a-a459-6a88be806493€9.00€0.19matched
148capture01a1a46d-1300-7e3c-b416-52f78dce6914€49.00€0.67matched
149capture01a1a46d-1ce6-7990-bfcf-767e25e3dbc1€9.00€0.19matched
150capture01a1a46d-3813-7296-b156-3bfa49c5c1b9€15.00€0.26matched
151capture01a1a46d-3b7c-74b5-b989-d1305fb25335€9.00€0.19matched
152capture01a1a46d-478a-7658-8a9a-095f8db0288c€15.00€0.26matched
153capture01a1a46d-4ae8-7921-882a-2afb52f54399€15.00€0.26matched
154capture01a1a46d-4ebd-774b-abd3-000978a44d2f€49.00€0.67matched
155capture01a1a46d-5a80-7dd0-9292-9308d5457488€15.00€0.26matched
156capture01a1a46d-7479-7643-af46-667fedd20364€24.00€0.37matched