+ Reply to Thread
Results 1 to 3 of 3

Accounting: How to Link General Journal Transactions to Ledger?

  1. #1
    Registered User
    Join Date
    08-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Accounting: How to Link General Journal Transactions to Ledger?

    I am trying to set up a General Journal and Ledger in Excel. Right now, I am manually posting the dates and the numbers into the ledger. Ideally, every general journal transaction would automatically "post" to the Ledger as soon as it is inserted into the General Journal. But, I don't know how to do that!

    I have attached a sample of the General Journal and Ledger.

    Any suggestions on how to get the General Journal to automatically post to the Ledger (using vlookup, etc.)? I am open to any necessary changes, including reformatting everything.
    Attached Files Attached Files
    Last edited by dmfnswm; 08-04-2013 at 07:45 PM. Reason: Added Workbook

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Accounting: How to Link General Journal Transactions to Ledger?

    Hi and welcome to the forum

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-04-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Accounting: How to Link General Journal Transactions to Ledger?

    Done! Thanks. See the original post!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. transfer data from journal to Ledger
    By zerocode in forum Excel General
    Replies: 16
    Last Post: 12-27-2013, 05:37 AM
  2. [SOLVED] Help me on Calculation problem of Journal Ledger
    By creativemind7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2012, 03:19 AM
  3. Create general ledger from journal
    By zeshkanii in forum Excel General
    Replies: 0
    Last Post: 07-12-2012, 07:38 AM
  4. Journal Ledger Balance
    By tariqnaz2005 in forum Excel General
    Replies: 12
    Last Post: 09-21-2010, 12:05 PM
  5. [SOLVED] Is there a general excel small business ledger/journal template?
    By Andy H in forum Excel General
    Replies: 1
    Last Post: 03-20-2006, 01:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1