Automated data processing of bank statements for cash balance forecasting

Griguta, Vlad-Marius; Gerber, Luciano; Slater-Petty, Helen; Crockett, Keeley; Fry, John

Abstract

The forecasting of cash inflows and outflows across multiple business operations plays an important role in the financial health of medium and large enterprises. Historically, this function was assigned to specialized treasury departments who projected future cash flows within different business units by processing available information on the expected performance of each business unit (e.g. sales, expenditures). We present an alternative forecasting approach which uses historical cash balance data collected from standard bank statements to systematically predict the future cash positions across different bank accounts. Our main contribution is on addressing challenges in data extraction, curation, and pre-processing, from sources such as digital bank statements. In addition, we report on the initial experiments in using both conventional and machine learning approaches to forecast cash balances. We report forecasting results on both univariate and multivariate, equally-spaced cash balances pertaining to a small, representative subset of bank accounts.

Citation

Griguta, V., Gerber, L., Slater-Petty, H., Crockett, K., & Fry, J. (2021). Automated data processing of bank statements for cash balance forecasting. Lecture Notes in Networks and Systems, 284, 49-64. https://doi.org/10.1007/978-3-030-80126-7_5

• Journal Article Type: Article
• Conference Name: SAI Computing Conference 2021, 15 July 2021 - 16 July 2021
• Conference Location: Virtual
• Acceptance Date: Feb 1, 2020
• Online Publication Date: Jul 7, 2021
• Publication Date: 2021
• Deposit Date: Feb 4, 2022
• Journal: Lecture Notes in Networks and Systems
• Print ISSN: 2367-3370
• Publisher: Springer
• Peer Reviewed: Peer Reviewed
• Volume: 284
• Pages: 49-64
• DOI: https://doi.org/10.1007/978-3-030-80126-7_5
• Keywords: Time series forecasting; Cash flow forecasting; Data wrangling
• Public URL: https://hull-repository.worktribe.com/output/3921092
• Related Public URLs: https://e-space.mmu.ac.uk/627061/