Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Basic Beancounting spreadsheets?
I posted this under 'New Users' and after more reading thought this task would involve programming and a formula. Thanks for your help, or even a direction to research the solution. Cheers. I am new to Excel (and this forum) & want to make my own General Ledger, Monthly Synopsis, Trial Balances, Financial Statements etc. for a new business. I am reading _Basic_Beancounting_ by T. James Cook and wish to use Excel efficiently. (Just learned how to group tabs to make multiple identical forms. Works great and saves a pile of time!) Now I want to take the debit & credit totals from each account column in the monthly synopsis sheet and link them (automatically post) them to the appropriate column in their individual running totals of each General Ledger Account. The problem is (well there are many and please don't tell me to get _Quick_Books_, I do not learn anything that way.) Every month I enter my receipts (debit & credits) on the synopsis sheet ( one page for all the monthly activity) in their account columns and I have a cell with a formula that totals each column. So far so good. Now I have to get that total into the NEXT AVAILABLE ROW of the appropriate column in the General Ledger account that keeps a record of the running monthly totals. The GL also has other adjustment entries so the row number is variable and Excel needs to know which the next blank row is. Do you follow so far? Once that is done, the entry has to stay in the GL when I copy the synopsis sheet to a new file name and clean the original sheet to start a new month. Posting manually to the General Ledger of each month results is a nightmare of columns, tabs, debits, credits, totals, and dates. And so much room for error. I noticed a comment that few people know how to use Excel efficiently so I want to control when I post the synopsis totals after they have been balanced. I bet there is a way to add the current date and reference ID into the GL row at the same time. ( The Beancounting book shows this post into the GL with the current date and a "Syn" reference code.) That would be awesome! So, that's the deal. What sort of statement or formula would do that, and only when I give the command to post? This may not be beginner stuff but I am sure Simply Accounting can do it? Are you up to the challenge? (Or maybe this is routine for you). Thanks. I live in Toronto, Canada. -- JagBbeach ------------------------------------------------------------------------ JagBbeach's Profile: http://www.excelforum.com/member.php...o&userid=32845 View this thread: http://www.excelforum.com/showthread...hreadid=526636 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need lot of help with linking spreadsheets | Links and Linking in Excel | |||
Linking Spreadsheets | Excel Worksheet Functions | |||
Linking Basic Beancounting spreadsheets? | New Users to Excel | |||
Basic formula for linking data | Excel Worksheet Functions | |||
linking spreadsheets | Excel Programming |