Invoice Tracking Template by nyz19012

VIEWS: 12 PAGES: 5

More Info
									7/13/2011                                    774060e8-1fe3-465c-9182-e7f9554b25cc.xls
                                                            Instructions

Order Cycle Description                Notes
            FoodLink balance forward   one time entry for transition from FoodLink to web ordering

     #1     UNFI Order Invoice Total
            Other Distributor 1
            Other Distributor 2
            Payment                    enter payments as a negative number
            Credits                    enter credits as a negative number
            Other Adjustments          enter adjustments as positive or negative number

     #2     UNFI Order Invoice Total
            Other Distributor 1          Tracking Member Balances
            Other Distributor 2
            Payment                      This document offers you 2 ways to keep track of ongoing member balances when using
                                         UNFI's Buying Club Web Ordering system. Use the one that works best for you.
            Credits
            Other Adjustments            The All Members Template can be used to keep all your members' data on one spreadsheet.
                                         The One Member Template keeps each member's data on one sheet. The One
     #3     UNFI Order Invoice Total     Member/sheet can be printed out to give each member a copy. Choose "Print Entire
                                         Workbook" to print all worksheets in one print job.
            Other Distributor 1
            Other Distributor 2          Both the All Members Template and the One Member Template have a column with sections
            Payment                      for each order cycle. In each section are rows for the UNFI order total, totals from other
                                         distributors, payments, credits and other adjustments. The first row is a place to carry over
            Credits
                                         existing balances if you are transitioning from FoodLink. At the bottom is the "Balance" -- the
            Other Adjustments            current total of all charges, credits and adjustments.
    7/13/2011                                     All Members Template

                                                                                   Member 2   Member 3   Member 4   Member 5
Order Cycle Date   Description                Sample Member      Member 1 Amount   Amount     Amount     Amount     Amount
                   FoodLink balance forward   $         1.50

    #1             UNFI Order Invoice Total   $        250.00
                   Other Distributor 1        $         25.00
                   Other Distributor 2        $           -
                   Payment                    $       (275.00)
                   Credits                    $         (1.50)
                   Other Adjustments

    #2             UNFI Order Invoice Total
                   Other Distributor 1
                   Other Distributor 2
                   Payment
                   Credits
                   Other Adjustments

    #3             UNFI Order Invoice Total
                   Other Distributor 1
                   Other Distributor 2
                   Payment
                   Credits
                   Other Adjustments




           Balance Due                        $         -        $         -
    7/13/2011                        One Member Template


Member Name
Order Cycle   Date        Description                Amount       Notes
                                                                  one time entry for transition from
                          FoodLink balance forward                FoodLink to web ordering

    #1                    UNFI Order Invoice Total
                          Other Distributor 1
                          Other Distributor 2
                          Payment
                          Credits
                          Adjustments

    #2                    UNFI Order Invoice Total
                          Other Distributor 1
                          Other Distributor 2
                          Payment
                          Credits
                          Adjustments

    #3                    UNFI Order Invoice Total
                          Other Distributor 1
                          Other Distributor 2
                          Payment
                          Credits
                          Adjustments




                Balance                              $        -
7/13/2011                                Susie Smithers

Susie Smithers -- EXAMPLE
Order Cycle Date         Description                  Amount         Notes
                                                                     one time entry for transition
            12/3/2007    FoodLink balance forward     $        25.14 from FoodLink to web ordering

    #1      12/4/2007    UNFI order                   $     296.51
            12/4/2007    bulk cheese order            $      24.58
            12/4/2007    Albert's order               $      86.13
            12/3/2007    Payment                      $    (350.24) Check # 2345
            12/10/2007   Credits / Adjustments        $     (12.45) moldy cream cheese

    #2      1/3/2008     UNFI order                   $     225.33
            1/3/2008     bulk cheese order            $      55.16
            1/3/2008     Albert's order               $      56.24
            1/3/2008     Credits / Adjustments        $     (16.45) bad apples
            1/3/2008     Payment                      $    (325.81) check #2389

    #3                   UNFI order
                         bulk cheese order
                         Albert's order
                         Credits / Adjustments
                         Payment




            Balance                                   $   39.00
  7/13/2011                                        John Doe


John Doe
Order Cycle Date           Description                   Amount           Notes
                                                                          one time entry for transition from
              12/3/2007    FoodLink balance forward      $        (12.84) FoodLink to web ordering

    #1        12/4/2007    UNFI order                    $      189.42
              12/4/2007    bulk cheese order             $       65.47
              12/4/2007    Albert's order                $       36.84
                           Payment                       $     (291.73) Chec # 1234
              12/10/2007   Credits / Adjustments         $       12.45 moldy cream cheese

    #2        1/3/2008     UNFI order                    $      246.32
              1/3/2008     bulk cheese order             $       52.14
              1/3/2008     Albert's order                $       24.13
                           Credits / Adjustments         $         -
              1/3/2008     Payment                       $     (350.00) check #1289

    #3                     UNFI order
                           bulk cheese order
                           Albert's order
                           Credits / Adjustments
                           Payment




              Balance                                    $    (14.96)

								
To top