Recommended for you

Our recommendation engine has come up with some personalized suggestions for you.

Discover more products

    Is this your street address?

    Card

    ···· ···· ···· 4242
    Test card

    05/18

    Card

    Use a different card?

    Card

    pp paypal

    or pay with

    We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

    or pay with

    Please confirm your location:
    Your card will be charged .

    Thank you!

      Gumroad Library

      Download from the App Store or text yourself a link to the app

      Download from the App Store or text yourself a link to the app

      Send SMS
      Nevermind

      $5

        Excel Customer Aged Receivables Dashboard

        Excel Customer Aged Receivables Dashboard

        This Excel dashboard allows you to easily access your customer contact information (including customer contact information, email address, and phone number as well as customer notes) and also to review the number of past due invoices, total past due invoice value, oldest invoice number, oldest customer PO#. On the right hand side of the dashboard there is a past due invoice distribution showing the percentage of past due invoices within each aging category (1-30 days, 31-60 days, 61-90 days, and greater than 91 days). Using the aged receivables information you can easily determine how your customer is performing and it also will show you the aging group with the greatest past due value of invoices.

        The Excel Aged Receivables Dashboard also handles customers who do not have contact information setup as well as customers who do not have any invoices past due. In the header of the dashboard, you'll notice that there are hyperlinks to each of the tabs where you can add customer data, invoice data as well as a tab that shows you how to use the dashboard. I've included the calculations tab in the Excel file also which is where the calculations are performed to allow the dashboard to run. Each tab on the dashboard will have buttons in the header to easily and quickly navigate around the file.

        Sorry, this item is not available in your location.
        Sold out, please go back and pick another option.

        You've already purchased this product.

        • Size 73.4 KB

        Card

        ···· ···· ···· 4242
        Test card

        05/18

        Card

        Use a different card?

        Card

        pp paypal

        or pay with

        We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

        or pay with

        Please confirm your location:
        Your card will be charged US$5.

        Your rental will be available for 30 days. Once started, you’ll have 72 hours to watch it as much as you’d like!

        Thank you!

          Gumroad Library

          Download from the App Store or text yourself a link to the app

          Download from the App Store or text yourself a link to the app

          Send SMS
          Nevermind