custom excel spread sheet with links

My project consists of several parts as I'll do my best to describe in detail:

1. create a standard spread sheet I can use to record financial transactions, update invoices automatically and the ability to send the invoice out via email or print option

2. The first sheet will be where I simply enter the new customer (or existing) information, this will automatically populate the next sheets with:

a. per student amount

b. fixed GST (Canada is 5%)

c. I have a partner in this business and the amounts must auto calc for the percentage I am giving them (this is not a fixed value, rather I want the abilty to have a drop down menu of 4-percentage choices I would provide you)

d. I have an instructor I also pay out of the "per student" amount and as above, it will change but I have those 3 values as well

3. I would also like the next sheet to keep a value of collected "GST" for Canadian tax purposes

4. I would like the next sheet to use for expense tracking per client, with a total per month value field as well (running total)

5. I would also like the ability to only show certain pages from the workbook (be able to not just protect the workbook, but limit the viewing to what ever sheets I choose

6. For book keeping purposes, I need this to be GAAP compliant (if that exists)

7. Since I am not an accountant, there is likely a few items I have missed, I do wish to have input as well

Also, When payments are recieved, I need a sheet to provide updated details to show the balance as well as updates to our employee payment dates (1st and 15th of the month) based on the drop down fields I provide.

I hope I have explained this well enough, there is going to be modifications and changes so please be aware of this as well.

Thanks and do ask questions if you have them.

Beceriler: Muhasebe, Veri İşleme, Excel, Finans

Daha fazlasını gör: what will an accountant do for my business, what financial accounting, what do i need to be an accountant, want excel spread sheet, tax accounting information, student accountant, project calc, new accountant, financial accounting 1 book, field in accounting, expense items, expense in accounting, choose an accountant, can i change accountant, book keeping business, best accounting book, best accountant, accountant information, what is financial accounting, auto populate data in excel, what is accountant, need a new accountant, i want to be accountant, i want an accountant, want an accountant

İşveren Hakkında:
( 2 değerlendirme ) Calgary, Canada

Proje NO: #4426692



Dear Sir, I am an Excel Expert. I can start working on it, right now and deliver it before Monday. Please, check your inbox for more. Kind Regards, Dimitris M.

%selectedBids___i_period_sub_7% gün içinde 100%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(5 Değerlendirme)

Bu iş için 26 freelancer ortalamada $164 teklif veriyor


Hello, Excel VBA expert here. Please check PM for details. Thanks!

in %bids___i_period_sub_35% gün içinde550%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(58 Değerlendirme)

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

in %bids___i_period_sub_35% gün içinde165%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)

Hi I have designed projects like this and I assure you it can be done exactly the you have described it. Please see PMB for sample work and suggestions.

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(33 Değerlendirme)

excel expert will complete ur project in record time

in %bids___i_period_sub_35% gün içinde110%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)

I am an Economist graduaded from Athens University of Business and Economics with 4+years experience in accounting , business and financial analysis and excelent skills in excel.I would be glad to have a chat with pm f Daha Fazla

in %bids___i_period_sub_35% gün içinde110%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

**** Please check questions in PM. Thanks ****

in %bids___i_period_sub_35% gün içinde180%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

Please check my Excel feedback. We should talk first though, to ensure I can meet your expectations (i.e. not just mine) within a reasonable timeframe. I have attached some ideas.

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

Hi, Excel and VBA expert here, ready to start, plz chk pm for DEMO. Regards.

in %bids___i_period_sub_35% gün içinde60%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

Successful freelancer with 20 years experience with Excel and also know visual basic. I am very experienced at creating / customizing spreadsheets to do all the functions you request. Please refer to the PMB for more Daha Fazla

in %bids___i_period_sub_35% gün içinde126%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hi, ready to work, check your pmb i have attached a sample, thanks

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

I would like to do this project with a twist!

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

With VBA expertise under my belt, this project should be an easy task to handle.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(0 Değerlendirme)

Hi, i have 4+ year of experience in the field of ERP and financial accounting.

in %bids___i_period_sub_35% gün içinde110%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am doing chartered accountant course.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(0 Değerlendirme)

Hello , We are expert in excel automation . For sample proofing , please check private message . Thanks

in %bids___i_period_sub_35% gün içinde515%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I can develop this in better way...

in %bids___i_period_sub_35% gün içinde180%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi I am experienced, familiar and flexible for this job and I have that patience. I am ready to start now. I am passionate to grow together. Payment is not a factor to me. I believe in -time and quality -money is a lo Daha Fazla

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Please check PM.

in %bids___i_period_sub_35% gün içinde130%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

5 years in financial planning and analysis in NYC area with various industry exposure. Will deliver a professional excel file with all your requirements and your branding format. Please feel free to contact me with any Daha Fazla

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Dear sir, I'm certified by TOPIK, or Test of Proficiency in Korean is a Korean language test offered four times annually (in Jan, Apr, Jul, Sept) to foreigners in Korea . It is administered by the National Institute Daha Fazla

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)