Closed

Help create a VBA excel reconciliation spreadsheet

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: Excel, Visual Basic, Visual Basic for Apps, Data Processing, Data Entry

See more: can build front end excel spreadsheet, create front end user interface excel, excel vba program front end example, building front end excel spreadsheet, create front end excel, vba front end excel spreadsheet, create front end search entire excel workbook, create front end excel database, create excel front end entry form, create front end excel input, vba excel manipulating spreadsheet, create front end enter data excel spreadsheet, create user friendly front end excel, create gui front end excel, excel data input front end, excel database gui front end, create the form in magento front end with module

About the Employer:
( 2 reviews ) Rostov-on-Don, Russian Federation

Project ID: #28308044

26 freelancers are bidding on average $123 for this job

(312 Reviews)
7.8
(402 Reviews)
7.5
Teloquence

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.

$156 USD in 2 days
(344 Reviews)
7.7
mrbrave

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

$70 USD in 2 days
(292 Reviews)
6.9
finecodervw

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

$125 USD in 3 days
(142 Reviews)
6.4
(65 Reviews)
6.6
(146 Reviews)
6.7
AnowarRatul

Hello Sir I am an expert on Excel I am available right now I can do this job please knock me......... Thanks Anowar

$89 USD in 2 days
(209 Reviews)
6.1
(116 Reviews)
5.9
dhanrajkarthick

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 More

$70 USD in 2 days
(34 Reviews)
5.0
VbaStudio

Hello. I'm a specialist in Excel and macros in VBA. I have knowledge in Excel tools to achieve what you are looking for.

$100 USD in 7 days
(9 Reviews)
3.7
faiiz

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 More

$35 USD in 1 day
(6 Reviews)
3.1
Emmyope93

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 More

$68 USD in 2 days
(4 Reviews)
3.2
nadjasalewski

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 More

$167 USD in 7 days
(3 Reviews)
2.5
sidbte

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, More

$110 USD in 2 days
(2 Reviews)
2.3
chnsci

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 More

$130 USD in 4 days
(3 Reviews)
1.8
(1 Review)
1.6
afikrifadzil

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 More

$50 USD in 2 days
(2 Reviews)
0.9
Freelaurie

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 More

$140 USD in 7 days
(0 Reviews)
0.0
michaelelder25

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 More

$140 USD in 7 days
(0 Reviews)
0.0