This is a demo. The logic below shows how the real cash flow tool I built during my internship works, but the classification rules here run on keyword matching. The production tool used a maintained lookup table of the company's real accounting codes — that table isn't here, and doesn't need to be.
FX rate. Each transaction is converted at the rate implied by the previous day. No separate FX file is required — the rate is derived from same-day USD/EUR transactions in the statement itself and interpolated between known days. Results are therefore approximate, not official.
Conversion. USD transactions are taken directly. TRY transactions are divided by that day's derived USD/TRY rate. Credit minus debit direction is used: positive is a cash inflow, negative is a cash outflow.
Classification. Each line is assigned to a cash flow category based on keywords in its description and counterparty name (collections, supplier payments, payroll, tax, rent, loans, FX revaluation, etc.). Lines matching no rule fall into a general bucket by direction; that share is tracked in the status bar.
Representation only. Everything in this dashboard — the data, the numbers, the entities — is a fictional stand-in built to represent how my actual work functions. It does not involve or expose any specific company's information.