Help create a VBA excel reconciliation spreadsheet
Budget $30-250 USD
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
26 freelances font une offre moyenne de 123 $ pour ce travail
Excel VBA expert with more than 300+ reviews ok freelancer. I can implement it in 2 days. please assign me the project so that I can start with the implementation.
Hi, I have over 10 years of working experience as Excel VBA developer. Please share your file with me to review and we can discuss more in chat. I am available right away to work. Thanks
Hi, I am well versed with VBA and can help to create the reconciliation sheet in Excel. It would help to discuss further on this. Looking forward to your response. Thanks
Hello Sir I am an expert on Excel I am available right now I can do this job please knock me......... Thanks Anowar
Hi there, Gone through your requirement. I can help you to reconcile the sheets. Please provide the INPUTs and required output as sample. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Await Plus
Hello. I'm a specialist in Excel and macros in VBA. I have knowledge in Excel tools to achieve what you are looking for.
Hi Sir I am interrested in this project. My name is Faiz and im a statistician and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and dat Plus
Hi, Good day. I understand you need a good ATM reconciliation analysis done in Excel. An excel work that provides accurate computations while being easy to understand. I will like to assist you on this project as I hav Plus
Hi there, This sounds like an interesting project and I would like to create the bank reconciliation tool for you. With an accounting background and over 10 years of experience in working with Excel (with a focus on t Plus
Dear Customer, I've got vast experience with excel and macro automation. I'm capable to create the reconciliation spreadsheet you are looking for in a day for you. The user interface can be adjusted as per you request, Plus
Greetings, I think here you are looking for someone to create a vba sheet. I understood your project description. I am an expert in vba, macros, excel, and am interested in your project. I am confident that I can Plus
Hi, appreciate if you took the time to review my proposal. New to this platform but I am very familiar with MS Excel and have experienced completing few projects. I am used with Excel VBA, Macros, Userform and other f Plus
Hello I am a proactive person and dedicated to my work with passion, I am dedicated to providing solutions in virtual administration tasks, data entry and everything related to providing development to your requireme Plus
Hi I am a mechanical engineer from Australia. I am new to freelancer and would like to start building my portfolio here. I believe that your job is the perfect starting point. Being an engineer I am highly competent i Plus