+ Reply to Thread
Results 1 to 9 of 9

Apply fifo when i am making payments to my vendors

  1. 12-20-2015, 08:57 AM #1
    rishabhmehtam
    rishabhmehtam is offline
    Registered User
    Join Date
    11-23-2013
    Location
    Pune , india
    MS-Off Ver
    Excel 2003
    Posts
    5

    Apply fifo when i am making payments to my vendors

    Namaste everyone ,

    I have/will have a set of vouchers that need to be paid .
    I pay adhoc and unplanned , but when i pay i have to keep a track that i am paying according to fifo to all my accounts

    I am unable to set up such functionality using excel , wherein i shall be able to have a voucherwise outstanding fifo_help.xls

    Need help

    Appreciate your time

    Regards

    Rishabh Mehta
    Reply With QuoteRegister To Reply
  2. 12-20-2015, 09:01 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Apply fifo when i am making payments to my vendors

    Please amend your sheet, to show your desired results (calculate them manually); as I cannot tell what you need from the description provided.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 12-21-2015, 08:13 AM #3
    rishabhmehtam
    rishabhmehtam is offline
    Registered User
    Join Date
    11-23-2013
    Location
    Pune , india
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Apply fifo when i am making payments to my vendors

    Quote Originally Posted by Glenn Kennedy View Post
    Please amend your sheet, to show your desired results (calculate them manually); as I cannot tell what you need from the description provided.
    Like u wanted i have attached the file depicting the solution required
    this is the final solution that i require

    appreciate

    Warm regards

    rishabh
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-21-2015, 08:30 AM #4
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Apply fifo when i am making payments to my vendors

    Can we have dates in proper date format e.g. dd/mm/yy?
    Reply With QuoteRegister To Reply
  5. 12-22-2015, 05:02 AM #5
    rishabhmehtam
    rishabhmehtam is offline
    Registered User
    Join Date
    11-23-2013
    Location
    Pune , india
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Apply fifo when i am making payments to my vendors

    fifo_help.xls

    this should do it

    Warm regards

    rishabh mehta
    Reply With QuoteRegister To Reply
  6. 12-22-2015, 05:33 AM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Apply fifo when i am making payments to my vendors

    Try this in D20 and copy down...
    =IF(SUM($D$3:D3)<$H$1,0,SUM($D$3:D3)-($H$1+SUM($D$19:D19)))
    Reply With QuoteRegister To Reply
  7. 12-22-2015, 11:24 AM #7
    rishabhmehtam
    rishabhmehtam is offline
    Registered User
    Join Date
    11-23-2013
    Location
    Pune , india
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Apply fifo when i am making payments to my vendors

    thanks so very much @ glenn really did it for me ... now i am going to apply it to my spreadsheet .

    warm regards

    rishabh mehta
    Reply With QuoteRegister To Reply
  8. 12-22-2015, 11:26 AM #8
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Apply fifo when i am making payments to my vendors

    Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
    Reply With QuoteRegister To Reply
  9. 12-22-2015, 11:28 AM #9
    rishabhmehtam
    rishabhmehtam is offline
    Registered User
    Join Date
    11-23-2013
    Location
    Pune , india
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Apply fifo when i am making payments to my vendors

    thanks so very much @ glenn really did it for me ... now i am going to apply it to my spreadsheet .

    warm regards

    rishabh mehta
    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)

Similar Threads

  1. [SOLVED] Loan Payment Schedule with Interest-Only Payments & P & I Payments
    By Masscatz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2014, 11:51 AM
  2. Match vendors shown in table, sorted by type, to a list of vendors and return vendor type.
    By djmyers in forum Excel General
    Replies: 6
    Last Post: 11-27-2013, 10:28 PM
  3. Posting Maltiple Payments to Multiple Invoices – FIFO Method
    By amardas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2013, 12:40 AM
  4. How to apply Fifo method?
    By mahaveersomani in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-16-2013, 08:29 AM
  5. [SOLVED] Code is not making cells with no color filled. Can not apply NO FILL to spreadsheet.
    By Flowerski in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-01-2012, 08:35 AM
  6. How do I forecast future payments by analyzing past payments?
    By CeeBee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2005, 03:06 PM
  7. [SOLVED] Making comments apply to more than one cell
    By Evelyn in forum Excel General
    Replies: 2
    Last Post: 02-08-2005, 09:06 PM

Tags for this Thread

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