Accounting-Sample_Excel_Check_Register
Document Sample


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
Related docs
Other docs by muhammadali1034
Agreement-Checklist_of_Issues_In_Drafting_and_Negotiating_Software_License_Agreements
Views: 0 | Downloads: 0
Get documents about "