#### lastnotice

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

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

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### My Aswer Is This

##### Well-known Member
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.

#### lastnotice

##### New Member
 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>

The balance column need a formula. It currently has E2-D3.

Last edited:

#### Dave Patton

##### Well-known Member

Excel 2010
ABCDE
1DateDescChargePaidBalance
2Jan 1 2015Jan sale8,300.008,300.00
3Jan 1 20158,300.000.00
4Feb 1 2015Feb sale8,300.008,300.00
5Mar 1 2015Mar sale8,300.0016,600.00
6Mar 14 201510,000.006,600.00
7Apr 1 2015Apr sale8,300.0014,900.00
8Apr 1 2015Late charge300.0015,200.00
9Apr 18 20151,000.0014,200.00
1a
Cell Formulas
RangeFormula
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.

Last edited:

#### lastnotice

##### New Member
Thank you Dave! Appreciate it!!!

Replies
0
Views
644
Replies
1
Views
166
Replies
13
Views
628
Replies
0
Views
296
Replies
0
Views
609

1,191,346
Messages
5,986,134
Members
440,004
Latest member
Dynawoman

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back