Excel Financial Program

%3CLINGO-SUB%20id%3D%22lingo-sub-2582622%22%20slang%3D%22en-US%22%3EExcel%20Financial%20Program%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2582622%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20stand%20alone%20excel%20program%20to%20populate%20a%20General%20Ledger%20spreadsheet%20I%20have%20built%2C%20with%20the%20use%20of%20a%20Data%20Entry%20Form%20and%20which%20will%20also%20automatically%20populate%20a%20Monthly%20Report%20form%20that%20I%20have%20in%20a%20pdf.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20do%20the%20work%2C%20but%20I%20am%20going%20to%20need%20a%20guru%20to%20guide%20me%20along%20this%20path.%26nbsp%3B%20I%20have%20created%20a%20simple%20data%20entry%20form%2C%20which%20obviously%20needs%20tweaking%2C%20but%20it%20populates%20the%20Ledger%2C%20which%20is%20a%20step%20in%20the%20right%20direction.%26nbsp%3B%20After%20using%20the%20form%20to%20populate%20the%20ledger%20and%20I%20am%20ready%20to%20print%20the%20particular%20quarter%20spreadsheet%2C%20I%20want%20it%20to%20print%20without%20the%20form%20showing%20i.e.%20like%20the%20original%20ledger.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20Ledger%20in%20it's%20original%20form%20and%20the%20one%20I%20created%20with%20the%20Data%20Entry%20Form%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2582622%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2582874%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Financial%20Program%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2582874%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111674%22%20target%3D%22_blank%22%3E%40dcg2122%3C%2FA%3E%26nbsp%3BOh%20my!%20As%20an%20accountant%2C%20I'm%20horrified%20by%20what%20I%20see.%20That's%20how%20I%20learned%20accounting%20in%20school%20about%2045%20years%20ago%2C%20%3CU%3Eon%20paper%3C%2FU%3E.%20If%20you%20don't%20want%20to%20buy%20a%20proper%20accounting%20system%2C%20why%20not%20enter%20all%20your%20transactions%20(i.e.%20journal%20entries)%20in%20one%20table%20(Date%2C%20Account%2C%20Description%2C%20and%20create%20general%20ledger%20from%20there.%20Just%20a%20thought.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2583386%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Financial%20Program%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2583386%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThis%20is%20the%20accounting%20system%20that%20the%20Veterans%20of%20Foreign%20Wars%20of%20the%20US%20expect%20their%20treasurers%20to%20maintain.%26nbsp%3B%20It's%20OK%20if%20I%20use%2C%20as%20you%20say%2C%20a%20proper%20accounting%20program%2C%20but%20even%20then%2C%20I%20still%20have%20to%20maintain%20this%20Ledger%2C%20as%20does%20every%20other%20treasurer%20in%20every%20other%20VFW%20Post%2C%20District%20and%20Department%20who%20this%20land.%26nbsp%3B%20As%20you%20san%20see%20from%20my%20ledgers%2C%20I%20don't%20have%20a%20lot%20of%20tramsactions%20so%20it%20would%20be%20counterproductive%20for%20me%20to%20invest%20in%20a%20progam%20like%20quickbooks%20only%20to%20have%20to%20still%20maintain%20this%20ledger.%26nbsp%3B%20What%20I%20am%20after%20or%20what%20I%20wanted%20to%20do%20is%20automate%20the%20process%20and%20share%20it%20with%20my%20counterparts%20so%20they%20don't%20have%20maintain%20this%20in%20a%20semi-stubby%20pencil%20fashiion.%26nbsp%3B%20Right%20or%20wrong%2C%20it%20is%20what%20it%20is%20and%20it's%20not%20going%20to%20change%2C%20so%20with%20that%20said%2C%20are%20you%20willing%20to%20help%20me%20make%20something%20worthwhile.%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2583961%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Financial%20Program%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2583961%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111674%22%20target%3D%22_blank%22%3E%40dcg2122%3C%2FA%3E%26nbsp%3BUnderstood%20and%20fair%20enough.%20I%20can%20only%20sympathise%20with%20you%20and%20your%20counterparts%20for%20the%20fact%20that%20you%20are%20forced%20to%20work%20with%20this%20format.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to create a stand alone excel program to populate a General Ledger spreadsheet I have built, with the use of a Data Entry Form and which will also automatically populate a Monthly Report form that I have in a pdf. 

 

I want to do the work, but I am going to need a guru to guide me along this path.  I have created a simple data entry form, which obviously needs tweaking, but it populates the Ledger, which is a step in the right direction.  After using the form to populate the ledger and I am ready to print the particular quarter spreadsheet, I want it to print without the form showing i.e. like the original ledger. 

 

I have attached the Ledger in it's original form and the one I created with the Data Entry Form

 

Thanks for the help

4 Replies

@dcg2122 Oh my! As an accountant, I'm horrified by what I see. That's how I learned accounting in school about 45 years ago, on paper. If you don't want to buy a proper accounting system, why not enter all your transactions (i.e. journal entries) in one table (Date, Account, Description, and create general ledger from there. Just a thought.

@Riny_van_Eekelen This is the accounting system that the Veterans of Foreign Wars of the US expect their treasurers to maintain.  It's OK if I use, as you say, a proper accounting program, but even then, I still have to maintain this Ledger, as does every other treasurer in every other VFW Post, District and Department who this land.  As you san see from my ledgers, I don't have a lot of tramsactions so it would be counterproductive for me to invest in a progam like quickbooks only to have to still maintain this ledger.  What I am after or what I wanted to do is automate the process and share it with my counterparts so they don't have maintain this in a semi-stubby pencil fashiion.  Right or wrong, it is what it is and it's not going to change, so with that said, are you willing to help me make something worthwhile.?

@dcg2122 Understood and fair enough. I can only sympathise with you and your counterparts for the fact that you are forced to work with this format. 

Going to help me or not?
district9QM@gmail.com