Final answer:
To calculate the up-to-date cash balance, we consider the deposits-in-transit, checks outstanding, EFTs received from customers, NSF check, and bank service charge. The up-to-date cash balance is $8,050.
Step-by-step explanation:
To calculate the up-to-date cash balance, we need to consider the reconciling items from the bank reconciliation. The deposits-in-transit are funds that have been received by the company but have not yet been recorded by the bank.
The checks outstanding are checks that have been written by the company but have not yet been cleared by the bank.
The EFTs received from customers are electronic funds transfers that have been received by the company and recorded by the bank.
To calculate the up-to-date cash balance, we start with the cash balance per the books ($8,000) and add the deposits-in-transit ($800) and the EFTs received from customers ($1,000).
We then subtract the checks outstanding ($500), the NSF check ($200), and the bank service charge ($50). The up-to-date cash balance is $8,050.