En cours

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

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é à :


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

60 $ AUD en 1 jour
(39 Commentaires)

13 freelance ont fait une offre moyenne de 123 $ pour ce travail


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

200 $ AUD en 2 jours
(41 Commentaires)

I can do this for you

120 $ AUD en 0 jours
(13 Commentaires)

Hi, I have experience with this project Please check PM

30 $ AUD en 1 jour
(15 Commentaires)

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

30 $ AUD en 1 jour
(20 Commentaires)

Please check your inbox. Thanks

250 $ AUD en 2 jours
(18 Commentaires)

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

40 $ AUD en 0 jours
(20 Commentaires)

I am happy that this project really suits my skills.

60 $ AUD en 1 jour
(7 Commentaires)

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

30 $ AUD en 1 jour
(4 Commentaires)

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

250 $ AUD en 30 jours
(3 Commentaires)

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,

250 $ AUD en 2 jours
(0 Commentaires)

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

150 $ AUD en 3 jours
(0 Commentaires)

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

90 $ AUD en 2 jours
(0 Commentaires)

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

100 $ AUD en 1 jour
(0 Commentaires)