+ Reply to Thread
Results 1 to 3 of 3

How to reconcile a a floorplan account between books and statement

  1. 07-27-2006, 04:30 PM #1
    Paul Bass
    Guest

    How to reconcile a a floorplan account between books and statement

    Please give me advice on how to efficiently reconcile my floorpan account
    that is composed of a few hundred stock #s and corresponding $ amount. I
    know how
    to download the books (stock# and $ amount) and the statement (stock # and $
    amount). However, there are numerous reconciling items (on stmt, not on bks &
    on bks, not on stmt). Is there a quick way to match all the like stock #s ?
    Right now
    I sort the books by stock # and the statement by stock# and subtract the two
    stock# columns from each other. This still takes a long time.
    Reply With QuoteRegister To Reply
  2. 07-27-2006, 07:53 PM #2
    Excelenator
    Excelenator is offline
    Valued Forum Contributor Excelenator's Avatar
    Join Date
    07-25-2006
    Location
    Wantagh, NY
    Posts
    333
    Have a look at this file.

    ReconcileBooks.zip
    ---------------------------------------------------
    ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
    To insert code into the VBE (Visual Basic Editor)
    1. Copy the code.
    2. Open workbook to paste code into.
    3. Right click any worksheet tab, select View Code
    4. VBE (Visual Basic Editor) opens to that sheets object
    5. You may change to another sheets object or the This Workbook object by double clicking it in the Project window
    6. In the blank space below the word "General" paste the copied code.
    Reply With QuoteRegister To Reply
  3. 08-02-2006, 01:13 AM #3
    Excelenator
    Excelenator is offline
    Valued Forum Contributor Excelenator's Avatar
    Join Date
    07-25-2006
    Location
    Wantagh, NY
    Posts
    333
    you know that file I posted earlier? Forget it there is a MUCH easier way to do this.

    Put the two sets of data in a workbook on separate worksheets. Name the Book Stock# range (column A?) BookStockNo and in the Statement Name the Statement Stock# range (column A also?) StmtStockNo. Then go to the Book worksheet, highlight all the data and insert conditional formatting where the formulas are

    Book worksheet
    =COUNTIF(StmtStockNo,A1)=0

    Statement worksheet
    =COUNTIF(BookStockNo,A1)=0

    Basically each sheet will check the other for the stock numbers and when they are NOT found your conditional formatting will be applied to that row of data. IF you chose to bold the font and yellow highlight the cells you will EASILY see which items are ON the Statement and NOT on the BOOKS and vice versa!

    Much less work.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1