Excel spreadsheet

Document Sample
Excel spreadsheet Powered By Docstoc
					Sales
Enter customer payments and all other business-related income. Remember
to remove the sample line!
 DATE                  CUSTOMER                      AMOUNT
 01/01/06                            Betty Buyer $       78.23            TOTAL: $   78.23
Customer refunds
Enter returns and refunds here.
 DATE                    SOURCE                     AMOUNT
 01/01/06                         Rudy Returner $       98.55   TOTAL: $   98.55
Payments for materials used in production (e.g. glass, findings, beads, yarn, wood,
fabric, art canvas)
Fill in the date, the type of purchase and the amount. The total will be filled in for you. Make sure
you remove the sample lines!
 DATE                        TYPE                         AMOUNT
 01/01/06                                     Store X $      245.22                TOTAL: $     245.22
Payments for finished products bought for resale (e.g. pendant chains)
Fill in the date, the type of purchase and the amount. The total will be filled in for yo
Make sure you remove the sample lines!
 DATE                         TYPE                         AMOUNT
 01/01/06                                       Item X $      256.11
le (e.g. pendant chains)
he total will be filled in for you.


                            TOTAL: $   256.11
Payments for depreciable equipment (e.g. computer, printer, scanner, kiln, easel,
sewing machine)
Fill in the date, the item purchased and the amount. The total will be filled in for you. Make sure
you remove the sample lines!
 DATE                        ITEM                      AMOUNT
 01/01/06                                  Machine X $   1,567.88                  TOTAL: $ 1,567.88
Payments for shipping (e.g. stamps, envelopes, PayPal payments to USPS
Fill in the date, the type of purchase, and the amount. The total will be filled in for yo
you remove the sample lines!
 DATE                       SOURCE                        AMOUNT
 01/01/06                                       USPS $         1.05
PayPal payments to USPS)
he total will be filled in for you. Make sure


                          TOTAL: $       1.05
Payments for fees and services (e.g. Etsy listing fees, website hosting fees)
Fill in the date, the company you paid, and the amount. The total will be filled in for you. Make
you remove the sample lines!
 DATE                     COMPANY                       AMOUNT
 01/01/06                                 Etsy Fees   $     34.55
bsite hosting fees)
will be filled in for you. Make sure


               TOTAL: $       34.55
Payments for promotional purposes (e.g. google adwords, blog ads, print ads, business
cards)
Fill in the date, the type of advertising and the amount. The total will be filled in for you.
Make sure you remove the sample lines!
 DATE                         TYPE                         AMOUNT
 01/01/06                               Etsy Showcase $         7.00                  TOTAL: $   7.00
Payments for general office supplies (printer paper, scissors, staples, glue)
Fill in the date, the type of purchase and the amount. The total will be filled
in for you. Make sure you remove the sample lines!
 DATE                        TYPE                         AMOUNT
 01/01/06                                     Store X $       21.92               TOTAL: $   21.92
All other business expenses (e.g. how-to books, repair costs, copyright applications)
Fill in the date, the type of purchase and the amount. The total will be filled
in for you. Make sure you remove the sample lines!
 DATE                         Type                       AMOUNT
 01/01/06                                    Example $       17.89                TOTAL: $   17.89
Inventory on hand at the close of the year, measured by cost of materials.
Instructions: For each type of item you had in stock on December 31, fill in the quantity and
unit cost (cost of materials NOT retail price). The item total and overall total will be generated
for you. Make sure you remove the sample lines!
       ITEM          QUANTITY   UNIT COST          ITEM TOTAL
        Bars of soap        10 $       1.50        $      15.00                 TOTAL: $ 35.00
           Lip Balm         20 $       1.00        $      20.00
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -
                                                   $        -

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:11/30/2011
language:English
pages:42