Help create a VBA excel reconciliation spreadsheet
Project detail
Front page with the live date and following fields where a user can input and submit data
for both ATM 1 and ATM2 (can we split them out please and have 2 different sets of identical questions and have the info being submitted and saved in different sheets
Start of day cash balance: [enter amount]
Button which allows the user to submit the balance. This balance is then stored on another sheet which has the date in one column and the amount in another.
Withdrawals: [enter amount]
Deposits: [enter amount]
Cash in G4S [enter amount]
Cash out G4S [enter amount]
End of day cash amount [Reconciles? Y/N- formula to check whether the closing amount = start of day – withdrawals +deposits + cash in – cash out.
Flag if there is any difference