Question Importing Financial Statements From Excel To Access

[farmir]

Hello Guys,

i am simply new to this forum and i am new to Access as well i have very few knowledge regarding this program.

to get to the point i have been ask to do income statement , Cash flow and a balance sheet in excel and then use Access to record the same data or to import them to be able to use queries after that. the problem is i dont know how to import them and i dont know how to transform the Statements it self into a database format can any of you please help me ASAP thanks a lot

 

[the_net_2.0]

there is no way you can directly translate these kind of statements to a database program. the setup is completely different. IMO, the best thing that you could do would be to go to the boss and tell him or her that this is really not possible. either/or would be the best.

 

[John Big Booty]

Or, cut straight to the chase and get an off the shelf accounting package that has that functionality built in.

 

[the_net_2.0]

Or, cut straight to the chase and get an off the shelf accounting package that has that functionality built in.

which is a better idea.

 

[farmir]

Thank you all for replying 2 my post but i need to use Access i dont have any other options so is there is a way to make this work !!!!

 

[vbaInet]

We're talking about money here and getting the books right. Any wrong calculations you make, your company (or your boss' company) suffers. If you're a novice at this get an off the shelf package. This isn't a 6 months job.

Even I wouldn't spend my time building such a package because I know how much of my time it will consume. Developers specialise in building accounting packages that's how critical it is.

 

[farmir]

i see :S thanks anyways man i am really sorry i wasted your time guys
Thanks a lot

 

[vbaInet]

You didn't waste our time. It's always good to do some research before coming to a conclusion. I don't think your boss understands the cons in trying to do this him/herself.

Good luck convincing your boss

 

[farmir]

i hope , okay i want 2 ask another question if i will do it manually in Access how can i differentiate between the year or should year 2009 be in one table and 2010 in another table for example ?

 

[vbaInet]

Please elaborate. The year of what?

 

[farmir]

okay i attached the excel sheet with this post you will find that like 2 tables in each financial statement one for 2009 and the other is for 2010 to show how did the difference between the 2 years what i want 2 do is transfer or make these tables using access and i am willing to do it manually as well but i don't understand how should i do it in Access !!! hope you have a better idea now on what's going on

 

[vbaInet]

The spreadsheet alone is too cumbersome and transposing it into Access would require a you create at least 7 tables. Like already mentioned, this isn't a one minute task and as a result I am not in a position to provide a quick solution. Your question would be better suited in the Practice and Theory of Database Design section of the forum.

However, having looked at your spreadsheet I feel you don't need Access for this so my advice would be to seek a solution in Excel. Reason being you don't have data per se, you have calculations. Queries are best suited for performing calculations on raw data, not just on figures.

Explain what kind of calculation you want to do in the Excel section of the forum and someone will be able to provide a solution.

 

[farmir]

Well the thing i dont want anything more in excel i just want 2 do this in Access :S i know it sounds stupid but i am not the boss but my question was i need 2 create a table for Balance Sheet 2009 and another one for 2010 , to be able to put it into access am i right or wrong ? based on your answer i will go and ask in the other section you told me about thanks a lot so far for your time and effort as well I really appreciated it

 

[vbaInet]

No, it's not just one table for Balance Sheet which was why I mentioned your spreadsheet is cumbersome. Your spreadsheet needs to be broken down into several tables but like I mentioned your spreadsheet seriously isn't something for Access.

Have fun in the other sections and we may meet there

 

[farmir]

Thanks a lot man , i am already now in the other section hoping 2 find a solution thanks a lot for your time and effort

 

[gemma-the-husky]

of course it is possible, but it is a matter of correct data structure.

it comes back to a suitable nominal ledger/general ledger structure to store the raw values which need to be reported, these to be held in a structured/ordered way so as to make the financial statement follow "automatically"

I would think that to do this, you need to be proficient at both databases and accountancy - soi you understand what you need to do, and how to do it.