help with ledger please

[lastnotice]

I am trying to create ledgers for my customers and i am not getting very far as you can see.

The balance column is all messed up. Can someone please help me sort this out?

Also, when creating ledgers is it best to do a most recent transaction at top or go from oldest to newest in a top to bottom?

https://www.dropbox.com/sh/loiqwdln0loycv1/AABOi6vjq9QZLoMTPbuLZKYTa?dl=0

 

[My Aswer Is This]

Normally in my Ledgers the first row has headers.
The second row would be my first entry and so on.
Explain more about what you want Balanced.

I never click on links. So explain your layout.

 

[lastnotice]

Date	Desc	Charge	Paid	Balance	Notes
Jan 1 2015	Jan sale	8300		8300
Jan 1 2015			8300	0
Feb 1 2015	Feb sale	8300
Mar 1 2015	Mar sale	8300
Mar 14 2015			10,000
Apr 1 2015	Apr sale	8300
Apr 1 2015	Late charge	300
Apr 18 2015			1000

<tbody>
</tbody>

This is the spreadsheet linked to dropbox.
The balance column need a formula. It currently has E2-D3.

 

[Dave Patton]

Excel 2010
	A	B	C	D	E
1	Date	Desc	Charge	Paid	Balance
2	Jan 1 2015	Jan sale	8,300.00		8,300.00
3	Jan 1 2015			8,300.00	0.00
4	Feb 1 2015	Feb sale	8,300.00		8,300.00
5	Mar 1 2015	Mar sale	8,300.00		16,600.00
6	Mar 14 2015			10,000.00	6,600.00
7	Apr 1 2015	Apr sale	8,300.00		14,900.00
8	Apr 1 2015	Late charge	300.00		15,200.00
9	Apr 18 2015			1,000.00	14,200.00
1a

Cell Formulas
Range	Formula
E2	=N(E1)+C2-D2
E3	=N(E2)+C3-D3
E4	=N(E3)+C4-D4
E5	=N(E4)+C5-D5
E6	=N(E5)+C6-D6
E7	=N(E6)+C7-D7
E8	=N(E7)+C8-D8
E9	=N(E8)+C9-D9

Edit the column references if necessary.
You can copy the formula in E2 down as far as is required.

 

[lastnotice]

Thank you Dave! Appreciate it!!!