+ Reply to Thread
Results 1 to 4 of 4

Aged receivables working file - based on date days since invoice raised

  1. 09-15-2016, 12:06 PM #1
    McQLon
    McQLon is offline
    Registered User
    Join Date
    09-08-2008
    Location
    London
    Posts
    40

    Aged receivables working file - based on date days since invoice raised

    Hi,

    We need to forecast aged receivables for a balance sheet forecast and am having trouble trying to get the data in to a reliable format.

    In the attached we have 4 clients with different levels of spends and different payment terms. We are assuming payment is made on time and would like to find a way to take numerous client spends and show when they hit and leave our aged receivables report.

    I've started this off but am finding it confusing even doing it manually.

    Can anyone help?


    Many thanks,
    McQLon
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-15-2016, 11:32 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2405
    Posts
    13,434

    Re: Aged receivables working file - based on date days since invoice raised

    McQLon,

    If I understand the mission correctly filling the existing formulas across should return the desired output.

    IE grab the fill handle(s) on each of D13, E14 and F15 and copy across.

    Does this do what you want?
    Dave
    Reply With QuoteRegister To Reply
  3. 09-16-2016, 02:00 AM #3
    McQLon
    McQLon is offline
    Registered User
    Join Date
    09-08-2008
    Location
    London
    Posts
    40

    Re: Aged receivables working file - based on date days since invoice raised

    Yes but for the real task I have 100's of clients with different payment terms in different orders and so wondered if there was a way to automate?
    Reply With QuoteRegister To Reply
  4. 09-16-2016, 02:01 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2405
    Posts
    13,434

    Re: Aged receivables working file - based on date days since invoice raised

    That's rather vague.

    I suspect it can, but the example upload didn't include or give indication(s) of those variables. Whoever can demonstrate that doesn't have much to go on.
    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] Aged Receivables - Separate Invoice Date from Payment Date in Aged Summary
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-21-2016, 10:07 AM
  2. [SOLVED] Invoice Date +30 days
    By Pam410 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2015, 04:43 PM
  3. Calculating deferred revenue and then accruing if invoice not raised
    By najo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-10-2014, 03:31 PM
  4. [SOLVED] Calculate END DATE based on START DATE & No of working days
    By prashantha in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-20-2013, 07:22 AM
  5. A4 date of invoice - E4 invoice status - F4 Date invoice was paid - G4 number of days invo
    By Prydien in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  6. calculating aged days
    By jm1234 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2007, 05:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1