Terminé

Excel or Access - Provide solution to calculate Daily closing balance from a bank statement

I want to calculate interest on an account.

Interest will be calculated daily and compounded monthly.

I have a statement of the account that gives me debits, credits and a running balance.

Some day there will be multiple transactions, and some days there will be none.

I need an excel or access solution to take this input data and give me 365 daily closing balances.

See the attached file for an example of the source data I would have, and my desired output data.

Compétences : Traitement de Données, Excel, Microsoft Access, Visual Basic

en voir plus : bank statement calculate closing balance excel, calculate closing bank balance excel, closing balance excel, calculate closing balance bank statement excel, daily access, daily bank statement excel, my bank, Excel to Access, closing my account, basic bank statement excel, multiple excel, excel monthly daily, excel need bank, bank monthly statement, bank excel file, excel daily data monthly data, daily monthly excel, monthly data daily data, excel daily data monthly, access solution, access daily, input transactions excel, access account, bank statement excel file, excel input data

Concernant l'employeur :
( 4 commentaires ) Sydney, Australia

Nº du projet : #2373173

Décerné à:

nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% AUD en 1 jour
(39 Commentaires)
5.4

13 freelance font une offre moyenne de $123 pour ce travail

rhomeu

MS Access expert here. This can be done in either MS Access 2007/2010.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(41 Commentaires)
6.5
Ciofi

I can do this for you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(13 Commentaires)
4.9
winnet21

Hi, I have experience with this project Please check PM

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(15 Commentaires)
4.9
redsentra

Hi, Excel data processing expert here ready to start immediately. Refer PM for details.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(20 Commentaires)
4.5
samitXI

Please check your inbox. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(18 Commentaires)
4.3
NourElDeen

I'm Expert On Database,I'd Like Helping You In This Task. Thanks, Nour El Deen

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(20 Commentaires)
4.2
ActualCreative

I am happy that this project really suits my skills.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(7 Commentaires)
3.6
rohitpithisaria

Hi I am an excel expert as well as certified professional (equivalenT to CPA). I would like to apply for the job posted by you. Thanks Rohit

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(4 Commentaires)
3.0
muzammil21

we do not offer package we offer Only guaranteed results..100% quality work within time limit...Read more in PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 30 jours
(3 Commentaires)
2.3
jenny88874

Hi, I'm Jenny. Well oriented, well organized and accurate in doing my job. Can extend working hours if its needed. I always wanted to have an excellent appreciation from my client. Thanks,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
sumitnarang82

Respected Sir, I am sumit narang from India. I am Microsoft certified solution developer having certification from usa and got certificates signed by bill gates and master of visual basic.I a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
ganeshlakshmi

This can be done in Excel macro. I can do this for you perfectly as a small software. Please see PM for details. You will also have choice to extract report any time for any period from this little tool. Simp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
sankalplondon14

Please let me know when we have to start the work for you . I am also on Skype add me as sankalpsaxena7

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0