Docstoc

Accounting-Sample_Excel_Check_Register

Document Sample
Accounting-Sample_Excel_Check_Register Powered By Docstoc
					    From Document Downloads at TheSmallBusinessOwnersManual.com




                                                                                                          Cleared?
    For Remote Accounting Help email AccountingHelp@TheSmallBusinessOwnersManual.com

Check #              Date Payee                                   Credit          Debit        Balance               Explanation
                            Daily Credit Card Batch                         $100,000.00                       Y
By Phone           10-Aug   AMEX-Lyn's                      $24,713.57                       $75,286.43       Y Prepayment
By Phone           11-Aug   AMEX- Andrews's                 $10,139.90                       $65,146.53       Y Magellan Corporations Consumer Electronics
                   11-Aug   Daily Credit Card Batch                         $100,000.00     $165,146.53
Wire Transfer      13-Aug   Garmin                          $30,828.61                      $134,317.92       Y      Orders placed on July 26-July 30
Online             13-Aug   Joe Smith                        $8,333.33                      $125,984.59       Y      July salary
Online             13-Aug   ANT                              $1,592.50                      $124,392.09       Y      July 15-30
Online             13-Aug   Cnet Best Price                    $648.05                      $123,744.04       Y      June
Online             13-Aug   Cnet GPSExplorer                   $962.75                      $122,781.29       Y      June
Online             13-Aug   UPS                              $2,355.91                      $120,425.38       Y      Invoice date 7/31
Online             13-Aug   Forrest Frumpie                  $2,650.00                      $117,775.38       Y      Consultant fee August 1-15 and health insurance
Online             13-Aug   Haman Hassein                      $501.65                      $117,273.73       Y      Reimbursement for July $427.90 & $73.75 for previous reimbursement expense not paid
Check # 0091       13-Aug   Topco                              $230.62                      $117,043.11       Y      First Quarter local district tax
Wire Transfer      16-Aug   CWR                             $41,605.64                       $75,437.47       Y      July 30 $4665.72, Aug 2 & 3 $36939.92
Wire Transfer      16-Aug   Wynit                           $33,065.20                       $42,372.27       Y      7/14-7/30 $12,988.41, 7/29 Inventory $13145, 8/2-8/3 $6931.79
Wire Transfer      16-Aug   Seawide                         $24,164.02                       $18,208.25       Y      7/22-7/30 $9481.15, 8/3-8/6 $14,682.87
Online             16-Aug   Bank One -1146-Andrew           $30,685.00                      -$12,476.75       Y      Wynit June $644.40, Wynit July $668.52, CWR for orders placed in June $29372.08
Check #0092        16-Aug   Citicard-3089                    $9,741.88                      -$22,218.63       Y      Dotan's expenses
Check #0093        16-Aug   Voided Check                                                    -$22,218.63       Y      Used for Merchant Application to transfer into new account
                   16-Aug   Daily Credit Card Batch                         $100,000.00      $77,781.37
Check # 0094       18-Aug   Chase 1195 -Andrew's            $24,910.52                       $52,870.85       Y      CWR COG order paid on 7/15
Online             18-Aug   UPS                              $2,033.11                       $50,837.74       Y      For shipments made 8/2-8/6
Online             18-Aug   Cnet                               $738.55                       $50,099.19       Y      July GPSExplorer
Online             18-Aug   Sparkletts                          $32.15                       $50,067.04       Y      July 14-July 28
Online             18-Aug   U Line                             $484.11                       $49,582.93       Y      Ordered on 8/13/2004
Online             20-Aug   AT&T Card-Dotan's                  $190.03                       $49,392.90       Y      shipping scale ordered 7/23 $65.08
Online             20-Aug   Verizon                          $1,468.37                       $47,924.53       Y      Phone for July
Online             23-Aug   Dynamics Direct                  $1,000.00                       $46,924.53       Y      Set up fee and training invoice 8/16
Online             23-Aug   Cloverfield Blvd                 $4,836.85                       $42,087.68       Y      Rent $4534.35, Parking $275, Parking Tax $27.50
Online             23-Aug   UPS                              $2,484.15                       $39,603.53       Y      For orders shipped 8/9-8/13
Online             24-Aug   Forrest Frumpie                  $2,650.00                       $36,953.53       Y      For August 15-August 30
Online             24-Aug   Portable USA                     $3,160.98                       $33,792.55       Y      6/21 $5.00 (extra charge), 7/22-7/30 $3155.98
                   24-Aug   Daily Credit Card Batch                         $100,000.00     $133,792.55
Wire Transfer      25-Aug   Garmin                          $77,052.51                       $56,740.04       Y      Aug 2 order $3449.84, Aug 5 order $73602.67
Online             25-Aug   BarGold                             $63.00                       $56,677.04       Y      rent for September
Online             25-Aug   Cnet Best Price                    $398.45                       $56,278.59       Y      Cnet Best Price for July
Online             26-Aug   Seawide                         $10,777.91                       $45,500.68       Y      July Order $64.66, August 9-August 16 $10713.25
Online             26-Aug   UPS                              $2,070.64                       $43,430.04       Y
                   26-Aug   Daily Credit Card Batch                         $100,000.00     $143,430.04
Phone              26-Aug   AMEX                            $43,638.20                       $99,791.84       Y Garmin payment made on Aug 10th for items ordered July 22-29
Online             26-Aug   Wynit                           $16,689.00                       $83,102.84       Y
Phone              26-Aug   AMEX                            $43,638.20                       $39,464.64       Y Garmin payment made on Aug 10th for items ordered July 22-29
                   26-Aug   Daily Credit Card Batch                         $100,000.00     $139,464.64
Wire Transfer      30-Aug   Garmin                          $20,557.81                      $118,906.83       Y Orders placed on 8/9 & 8/10 with 3% discount
Online             31-Aug   ANT                                $164.50                      $118,742.33       Y Aug1-Aug 15 invoice


    Printed: 8/20/2012, 4:22 AM                                                           Account0471                                        File=1366f7d1-2f18-48dc-b182-ef31a381aa06.xls
                                                                                               Cleared?
Check #           Date Payee                           Credit         Debit         Balance               Explanation
                 31-Aug   Daily Credit Card Batch                $100,000.00     $218,742.33
Wire Transfer     7-Sep   Garmin                    $85,460.59                   $133,281.74       Y 8/17-8/18 inventory
Wire Transfer     7-Sep   CWR                       $75,000.00                    $58,281.74       Y For inventory orders shipped 7/30
Online            8-Sep   Forrest Frumpie            $2,650.00                    $55,631.74       Y September 1-15 Consulting fee & health insurance
                  8-Sep   Daily Credit Card Batch                $100,000.00     $155,631.74
Wire Transfer     9-Sep   Garmin                    $17,479.00                   $138,152.74       Y Inventory ordered on 8/19-8/24
Check # 0094     10-Sep   Chase-0563                 $9,003.84                   $129,148.90       Y protector fee $138.97 from last statement ( I am disputing this, protector fee $71.15 (I am also di
Check # 0095     10-Sep   SCIF                         $872.97                   $128,275.93       Y Payroll report 6/23/2004-9/1/2004




    Printed: 8/20/2012, 4:22 AM                                                Account0471                                     File=1366f7d1-2f18-48dc-b182-ef31a381aa06.xls
          Confirmation




bursement expense not paid




aced in June $29372.08




              Printed: 8/20/2012, 4:22 AM   Account0471   File=1366f7d1-2f18-48dc-b182-ef31a381aa06.xls
          Confirmation




s, protector fee $71.15 (I am also disputing this), CWR August $8446.82, Wynit $ 346.90, CWR $8446.82
                                                     8446.82




               Printed: 8/20/2012, 4:22 AM                                                        Account0471   File=1366f7d1-2f18-48dc-b182-ef31a381aa06.xls

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:8/20/2012
language:English
pages:4