Help create a VBA excel reconciliation spreadsheet

  • Job DurationLess than a week
  • Project LevelBasic Level
  • Project deadlineExpired

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

Skills Required

Industry Categories

Freelancer type required for this project